Install HestiaCP

1.
wget https://raw.githubusercontent.com/hestiacp/hestiacp/release/install/hst-install.sh

2.
apt-get upgrade

3.
apt-get update && apt-get install ca-certificates

4.
bash hst-install.sh --multiphp yes -f -y no -e noreply@aaa.com -p PassWord -s hestia.aaa.com

ISPconfig Postfix

Postfix open TLS/SSL and submission ports


root> vi /etc/postfix/master.cf


[...]
submission inet n       -       -       -       -       smtpd
  -o syslog_name=postfix/submission
  -o smtpd_tls_security_level=encrypt
  -o smtpd_sasl_auth_enable=yes
  -o smtpd_client_restrictions=permit_sasl_authenticated,reject

#  -o smtpd_reject_unlisted_recipient=no
#  -o smtpd_client_restrictions=$mua_client_restrictions
#  -o smtpd_helo_restrictions=$mua_helo_restrictions
#  -o smtpd_sender_restrictions=$mua_sender_restrictions
#  -o smtpd_recipient_restrictions=permit_sasl_authenticated,reject
#  -o milter_macro_daemon_name=ORIGINATING

smtps     inet  n       -       -       -       -       smtpd
  -o syslog_name=postfix/smtps
  -o smtpd_tls_wrappermode=yes
  -o smtpd_sasl_auth_enable=yes
  -o smtpd_client_restrictions=permit_sasl_authenticated,reject

#  -o smtpd_reject_unlisted_recipient=no
#  -o smtpd_client_restrictions=$mua_client_restrictions
#  -o smtpd_helo_restrictions=$mua_helo_restrictions
#  -o smtpd_sender_restrictions=$mua_sender_restrictions
#  -o smtpd_recipient_restrictions=permit_sasl_authenticated,reject
#  -o milter_macro_daemon_name=ORIGINATING
[...]


root> service postfix restart

Incorrect datetime value: '' for column 'updatetime' at row 1

Incorrect datetime value: '' for column 'updatetime' at row 1


mysql  run

mysql> set session sql_mode='';

mysql> set global sql_mode=''; 

sqLite 匯出匯入

//指定db檔案
sqlite3 /home/data/p1.db
//匯出SQL
sqlite>.output /home/data/p1.sql
sqlite>.dump
sqlite>.quit


//指定db檔案
sqlite3 /home/data/p1.db
//SQL匯入
sqlite>.read /home/data/p1.sql
sqlite>.quit


//指定db檔案
sqlite3 /home/data/p1.db
//設定分割符號
sqlite>.separator ";"
//匯入CSV檔案
sqlite>.import /home/data/p1.csv [tablename]

小麥B落開張

歡迎大家來交流
並交個朋友