新增使用者spencerchang
sudo adduser spencerchang
spencerchang加入群組sudo,www-data
sudo adduser spencerchang sudo
sudo adduser spencerchang www-data
Add php5.6 PPA(php7.0以上，不用新增)
sudo add-apt-repository ppa:ondrej/php
更新PPA資料源
sudo apt-get update
安裝apache2
sudo apt-get install apache2
安裝mysql 5.7
sudo apt-get install mysql-client-5.7 mysql-server-5.7
安裝php 5.6 和其他套件
sudo apt-get install php5.6 php5.6-bz2 php5.6-cgi php5.6-cli php5.6-common php5.6-curl php-dev php5.6-fpm php5.6-gd php5.6-imap php5.6-intl php5.6-json php5.6-ldap php5.6-mbstring php5.6-mcrypt php5.6-mysql php5.6-odbc php5.6-sybase php5.6-xml php5.6-zip
安裝 libapache2-mod-php5.6
sudo apt-get install libapache2-mod-php5.6
安裝phpmyadmin
sudo apt-get install phpmyadmin
enable rewrite
sudo a2enmod rewrite
php版本顯示錯誤的話
sudo ln -sfn /usr/bin/php5.6 /etc/alternatives/php
更新到最新的軟體更新
sudo apt-get dist-upgrade
enable speling
sudo a2enmod speling
關閉mysql strict mode，新增一個disable_strict_mode.cnf，記得重啟mysql生效
sudo vim /etc/mysql/conf.d/disable_strict_mode.cnf
[mysqld]
sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
變更root directory
sudo vim /etc/passwd
sync file
匯出所有的資料庫
mysqldump -u root -p --all-databases > vsi_all.sql
匯入所有的資料庫
mysql -u root -p < vsi_all.sql
tar壓縮檔案成bz2,exclude log, -p保留原權限
sudo tar -jpcv -f /web/web_all.tar.bz2 --exclude=log --exclude=Backup /web/
rsync檔案 -P是續傳和進度顯示
sudo rsync -e "ssh -p 87" -avhP web_all.tar.bz2 web1admin@206.198.231.21:/web/
解壓縮tar檔
sudo tar -jxv -f /web/web_all.tar.bz2 -C /web/
rsync資料
sudo rsync -e "ssh -p 87" -avhP --exclude 'Backup' --exclude 'log' /web/ web1admin@206.198.231.21:/web/
sendmail
安裝sendmail
sudo apt-get install sendmail
加入domain 到local-host-names，一行一個domain，允許收發信
sudo vim /etc/mail/local-host-names
phantomjs
安裝phantomjs
sudo mv phantomjs-2.1.1-linux-x86_64 /usr/local/share/
sudo chmod -R 777 /usr/local/share/phantomjs-2.1.1-linux-x86_64
sudo ln -sf /usr/local/share/phantomjs-2.1.1-linux-x86_64/bin/phantomjs /usr/local/share/phantomjs
sudo ln -sf /usr/local/share/phantomjs-2.1.1-linux-x86_64/bin/phantomjs /usr/local/bin/phantomjs
sudo ln -sf /usr/local/share/phantomjs-2.1.1-linux-x86_64/bin/phantomjs /usr/bin/phantomjs
Crontab
查看web1admin的crontab
crontab -l
編輯crontab
crontab -e
目前的crontab 時程
# m h dom mon dow command
0 1 * * * /web/backup/geoip_bin.sh
0 2 * * * /web/backup/vse_finchclub/feu_backup.sh
0 4 * * * /web/backup/vscn_web/cn_backup.sh
0 6 * * * /web/backup/mvb/mvb_backup.sh
#0 20 * * * /web/backup/partner_web/partner_backup.sh
0 21 * * * /web/backup/qr_web/qr_backup.sh
0 22 * * * /web/backup/lstage_database/lstage_database.sh
0 23 * * * /web/backup/lstage_web_set/lstage_web_set.sh
0 5 * * * /web/backup/vsei_web/vsei_backup.sh
0 8 * * * /web/backup/reconfig_gitlab.sh
0 13 * * * /web/backup/reconfig_gitlab.sh
30 21 * * * /web/backup/reconfig_gitlab.sh
30 10 * * * sh /web/ap_web/serial_import_vse/cron.sh
30 9 * * * sh /web/ap_web/serial_import_vse/cron_vsi.sh
#* * * * * php /web/pss/artisan schedule:run >> /dev/null 2>&1
Rotate Log
001_www.viewsonic.com.tw.conf 和 001_www.viewsonic.com.tw-le-ssl.conf 加上
ErrorLog "|/usr/bin/rotatelogs -l /web/log/tw_error-%Y%m%d.log 604800"
CustomLog "|/usr/bin/rotatelogs -l /web/log/tw_access-%Y%m%d.log 604800" combined
001_www.viewsonic.com.tw-8080.conf 加上
ErrorLog "|/usr/bin/rotatelogs -l /web/log/tw_error-%Y%m%d.log 604800"
CustomLog "|/usr/bin/rotatelogs -l /web/log/tw_access-%Y%m%d.log 604800" combined env=!forwarded
CustomLog "|/usr/bin/rotatelogs -l /web/log/tw_access-%Y%m%d.log 604800" proxy env=forwarded