http://www.debiantutorials.com/installing-vsftpd-using-text-file-for-virtual-users/
vsftpd
Posted by fabio
on 11/04/2013
No comments
Incremental VALUE with MYSQL
Posted by fabio
on 11/04/2013
Comments Off
SET @pos:=0;
LPAD(@pos:=@pos+1,4,'0')
How long is “too long” for MySQL Connections to sleep?
Posted by fabio
on 27/12/2012
No comments
mysqld will timeout DB Connections based on two(2) server options:
interactive_timeout
wait_timetout
Both are 28800 seconds (8 hours) by default.
You can set these options in /etc/my.cnf
If your connections are persistent (opened via mysql_pconnect) you could lower these numbers to something reasonable like 600 (10 min) or even 60 (1 min). Or, if your app works just fine, you can leave the default. This is up to you.
You must set these as follows in my.cnf (takes effect after mysql restart):
[mysqld]
interactive_timeout=180
wait_timeout=180
If you do not want to restart mysql, then run these two commands:
SET GLOBAL interactive_timeout = 180;
SET GLOBAL wait_timeout = 180;
This will not close the connections already open. This will cause new connections to close in 180 sec.
Add SPF records to all domains in Plesk
Posted by fabio
on 20/11/2012
No comments
To add SPF records to every domain in Plesk, you can use this huge one-liner:
mysql -u admin -p`cat /etc/psa/.psa.shadow` psa -e "select dns_zone_id,displayHost from dns_recs GROUP BY dns_zone_id ORDER BY dns_zone_id ASC;" | awk '{print "INSERT INTO dns_recs (type,host,val,time_stamp,dns_zone_id,displayHost,displayVal) VALUES ('''TXT''','''"$2"''','''v=spf1 a mx ~all''',NOW(),"$1",'''"$2"''','''v=spf1 a mx ~all''');"}' | mysql -u admin -p`cat /etc/psa/.psa.shadow` psa
Then you’ll need to make Plesk write these changes to the zone files:
# mysql -Ns -uadmin -p`cat /etc/psa/.psa.shadow` -D psa -e 'select name from domains' | awk '{print "/usr/local/psa/admin/sbin/dnsmng update " $1 }' | sh
You can check your work by viewing the new entries you made:
mysql -u admin -p`cat /etc/psa/.psa.shadow` psa -e "SELECT * FROM dns_recs WHERE type='TXT';"
Another Quick way to disable IPv6 – Debian Squeeze (6) without reboot
Posted by fabio
on 09/02/2012
No comments
echo "# Disable IPv6" >> /etc/sysctl.conf
echo "net.ipv6.conf.all.disable_ipv6 = 1" >> /etc/sysctl.conf
echo "#" >> /etc/sysctl.conf
sysctl -p