Skip to main content
Advanced Search
Search Terms
Content Type

Exact Matches
Tag Searches
Date Options
Updated after
Updated before
Created after
Created before

Search Results

437 total results found

Backup & Restore

MySQL

Backup Script#1: #!/bin/bash # 以下配置資訊請自己修改 mysql_user="USER" #MySQL 備份使用者 mysql_password="PASSWORD" #MySQL 備份使用者的密碼 mysql_host="localhost" mysql_port="3306" mysql_charset="utf8" #MySQL 編碼 backup_db_arr=("db1" "db2") #要備份的資料庫名稱,多個用空格分開隔開 如("db1" "db2...

Picroft

Raspberry Pi

Introduction Picroft is a ready-made way to run Mycroft on a Raspberry Pi 3, 3B+ or 4 and is provided as a disk image that you can burn to a Micro SD card. Links Official Home Youtube Tutorials https://www.youtube.com/watch?v=M398I6YIleM https://www....

iSCSI and multipath on CentOS 7

Linux Administration SAN & iSCSI

系統環境 iSCSI Storage: NetApp FAS8200 Linux OS: CentOS 7 Server H/W: HP DL380 Gen10 iSCSI 用網路卡: 10G SFP 光纖網路卡 x 2 設定網路卡 使用指令 nmtui 分別設定兩張網卡的 IP 與 Mask 注意: 這兩張網卡不要作 Bonding。 設定 iSCSI 安裝 iscsi 套件 yum install iscsi-initiator-utils 設定 iscsid.conf: ...

Learning

Linux Administration SAN & iSCSI

iSCSI How to configure iSCSI target & initiator on RHEL/CentOS 7.6

iptables

Linux Administration

基本指令 列出現有規則 iptables -L -n -v iptables -L -n -v --line-numbers iptables -L INPUT -n -v --line-numbers 重啟/清除所有規則 service iptables stop service iptables start iptables -F iptables -X iptables -t nat -F iptables -t nat -X iptables -t mangle -F ipta...

Install Node.js via binary archive

Node.js

Download: https://nodejs.org/en/download/ With Linux Unzip the binary archive to any directory you wanna install Node, I use /usr/local/lib/nodejs VERSION=v10.15.0 DISTRO=linux-x64 sudo mkdir -p /usr/local/lib/nodejs sudo tar -xJvf node-$VERSION-$DISTRO....

Learning Node.js

Node.js

Docker Dockerize Node.js apps with Buildpacks Installation How To Install NodeJS On Linux

SSL/TLS Web Server

SSL 與 CA

Generate Certificates Method 1: 不需要 CA 的憑證 mkdir /etc/apache2/certs cd /etc/apache2/certs openssl genrsa -out myhomepbx.key 2048 openssl req -new -key myhomepbx.key -out myhomepbx.csr openssl x509 -req -days 3650 -in myhomepbx.csr -signkey myhomepbx.key ...

HAProxy

Load Balancer

Offical Sites Home: http://www.haproxy.org/ Forum: https://discourse.haproxy.org/ Installation Install HAProxy on Debian or Ubuntu Run HAProxy as a Docker container # RedHat 8.3 yum install haproxy Setting Up HAProxy Logging The default config...

Linux Bonding Network

Linux Administration 網路管理

RedHat 7/8 with nmtui nmtui > Edit a connection > Add > New Connection > Select Bond > Create Profile Name: bond0 Device: bond0 > Slaves > Add Profile Name: eno1-slave NOTE: 建議這裡要加上 -slave,與實際的裝置名稱做區別 Device: eno1 Profile Name: ens3f0-slave Devic...

teaming

Git Installation

Git

Git Client # CentOS/RedHat 5/6 # Install from source # Get the required version of GIT from https://www.kernel.org/pub/software/scm/git/ yum install zlib-devel openssl-devel cpio expat-devel gettext-devel wget https://mirrors.edge.kernel.org/pub/software/...

Learning

Linux Administration 檔案及目錄加密-Encrypt

GPG Using GPG to Encrypt and Decrypt Files on Linux [Hands-on for Beginners] LUKS How to unlock LUKS using Dropbear SSH keys remotely in Linux - nixCraft (cyberciti.biz) Linux Hard Disk Encryption With LUKS [cryptsetup command ] - nixCraft (cyberciti...

DB2 管理

IBM DB2 Database

資料庫 新增資料庫 create db MYDB on /db2_home/istv11/MYDB using codeset big5 territory TW collate using identity USER TABLESPACE MANAGED BY DATABASE USING (FILE '/db2_home/istv11/MYDB/TBS_DMS/userspace_4k_c01' 524288) TEMPORARY TABLESPACE MANAGED BY SYSTEM USING...

Partition Table

MySQL

Check if partition is supported > show plugins; Create partition table create table mm_tx_new ( start_time timestamp(6) not null default '0000-00-00 00:00:00.000000', end_time timestamp(6), hostname varchar(20), servername var...

Sign up and Register

Linux Administration Red Hat Subscription Manager

Tutorials [RH-KM] Using Red Hat Subscription Management How to enable Red Hat Subscription on RHEL 8/7 How to register RHEL 8 with subscription manager using command-line 如何在 RHEL 中使用訂閱管理器啟用軟體倉庫 How to activate your no-cost Red Hat Enterprise Linux subs...

AIX/Linux Monitoring with njmon

Grafana

nimon (NOT njmon) + InfluxDB + Grafana njmon = JSON output nimon = njmon but straight to InfluxDB NOTE: as of version 78, the njmon and nimon have been merged into one binary file. Using the option -J (nimon mode) or -I (nimon mode). njmon Downlo...

nmon

spfile v.s. pfile

Oracle Database

pfile 純文字檔案, client端參數檔案;不能動態修改,可以用普通的編輯器修改,修改之後需要重啟。pfile可能會導致伺服器啟動不一致,因為可以在客戶端啟動。 spfile 二進制檔案,伺服器端參數檔案,有了spfile,oracle可以實現動態參數在線修改,部分參數修改之後無需重啟。但是,因為是二進制檔案,所以不能用普通的編輯器修改,要用alter命令從sql裡面來修改。spfile保證伺服器每次的啟動都是一致的。 spfile 與 pfile 設定檔可以互相轉換,只有 spfile 而沒有 ...

RClone

Linux Administration

Rclone syncs your files to cloud storage Installation Ubuntu sudo apt install rclone Storj DCS Manual: https://documentation.tardigrade.io/how-tos/sync-files-with-rclone  Config rclone config n) New remote s) Set configuration password q) Quit conf...

Raspberry Pi OS

Raspberry Pi

Installation Raspberry Pi Imager Ubuntu 22.04 sudo apt install rpi-imager Create User NOTE: 新版 Raspberry Pi OS 已經移除內建帳號 pi。使用前需要手動先建立帳號。 Headless Setup SD Card > Boot partition > File: userconf userconf: alang:<encrypted-password> Generate encr...

Build a Java app

Flatpak

Tutorials https://docs.flatpak.org/en/latest/first-build.html https://flathub.org/home http://blog.matbooth.co.uk/08-openjdk-in-flathub.html