This helps when altering table structure, for example from myisam to tokudb:
SET sql_mode = ”
ERROR 1067 (42000) at line 1: Invalid default value for
Leave a reply
Monthly Archives: January 2017
postfix/smtpd[]: warning: SASL authentication failure: cannot connect to saslauthd server: No such file or directory
Issue on Debian 8 + virtualmin:
ln -s /var/spool/postfix/var/run/saslauthd /var/run/saslauthd
chown root:sasl /var/spool/postfix/var/run/saslauthd
usermod -a -G sasl postfix
sudo /etc/init.d/postfix restart
sudo /etc/init.d/saslauthd restart
virtualmin change mailbox address format
You can change the username format by going into System Settings -> Server Template -> Default -> Mail for Domain, and change “Format for usernames that include domain” to “user@domain”.
pptp https not working
If some websites not working on pptp VPN.
What you need to do is increase the MTU on ppp0. Since you want this to occur every time a new connection is initiated you need to edit /etc/ppp/ip-up find a space in there and add ‘ifconfig ppp0 mtu 1468’ that should fix things for you.
pppd Cannot determine ethernet address for proxy ARP
sysctl -w net.ipv4.ip_forward=1
vi /etc/sysctl.conf
net.ipv4.ip_forward = 1
virtualenv
pip install virtualenv
cd /root/new
virtualenv venv
source venv/bin/activate
possible virtualenv -p /usr/bin/python2.7 venv
Sorry – this system lacks PPP kernel support
vzctl stop 101
vzctl set 101 –features ppp:on –save
vzctl start 101
vzctl set 101 –devices c:108:0:rw –save
vzctl exec 101 mknod /dev/ppp c 108 0
vzctl exec 101 chmod 600 /dev/ppp
bash: mkvirtualenv: command not found
source “/usr/bin/virtualenvwrapper.sh”
export WORKON_HOME=”/opt/virtual_env/”
tomcat the request or reply is too large
Connector port=”8080″ protocol=”HTTP/1.1″
connectionTimeout=”20000″
redirectPort=”8443″ maxHttpHeaderSize=”65536″ maxPostSize=”4194304″
URIEncoding=”UTF-8″/>
tomcat manager password and username
tomcat-users:
role rolename=”manager-gui”/>
user username=”admin” password=”admin” roles=”manager-gui”/>
simple gre tunnel
ip tunnel add gre0 mode gre remote 172.168.10.25 local 192.168.233.204 ttl 255
ip link set gre0 up
ip addr add 10.10.10.1/24 dev gre0
PPTP usually use this Cisco tunneling protocol and etc.
gzip and pigz
pigz is a parallel implementation of gzip for modern multi-processor, multi-core machines. So do not forget use it.
renew self signed ssl certificate
openssl x509 -req -days 365 -in new.csr -signkey ssl.key -out ssl.crt
if CSR is missing:
openssl req -new -key testingcert.key -out new.csr
openssl genrsa -out testingcert.key 2048 (2048 bits RSA private key for encryption and signing)
check ssl info
openssl req -in ssl.csr -noout -text
check ssl date
openssl x509 -in ssl.crt -noout -enddate
notAfter=Dec 30 11:10:42 2016 GMT