In a small environment VPS or VDS, there’s very little reason to rely on DNS resolution inside MySQL.
You can disable it by adding ‘skip-name-resolve’ to your my.cnf (section mysqld) or by using the ‘–skip-name-resolve’ command line argument. Remember: If you disable DNS lookups, you will need to set permissions using IP addresses rather than host names!
Month: December 2012
Noninteractive package installation on Debian squeezy – debconf way
Once you have many Debian servers, maintenance would be a problem. Sometimes, I would like to install Debian package in all of these servers. However, it takes too much time to ssh into every hosts, and answer the installation questions one by one.
Thanks for the debconf(1), it’s quite easy to do non-interactive installation, since debconf already provide a noninteractive frontend. All you need to do is set the configuration before you install the package. It can be done by debconf-set-selections.
“Noninteractive package installation on Debian squeezy – debconf way”Continue reading
Protected: Mysql – all about charset. Mysql – все о кодировке.
How do I get the full path to a Perl script that is executing? – Right way.
- THESE ALL WRONG !!!!!!
use Cwd qw(abs_path cwd); my $cwd = cwd(); my $abs_path = abs_path(); my $FILE = __FILE__; print "1. $cwd $abs_path $FILE\n"; "How do I get the full path to a Perl script that is executing? – Right way."Continue reading
SASL authentication and Postfix
Next options require attention:
smtpd_sasl_auth_enable = yes smtpd_sasl_authenticated_header = no smtpd_sasl_exceptions_networks = smtpd_sasl_local_domain = smtpd_sasl_path = smtpd_sasl_security_options = noanonymous, noplaintext smtpd_sasl_tls_security_options = noanonymous, noplaintext smtpd_sasl_type = cyrus
/etc/postfix/main.cf: smtpd_sasl_type = dovecot | cyrus /etc/postfix/main.cf: smtpd_sasl_path = private/auth
This example uses a pathname relative to the Postfix queue directory, so that
it will work whether or not the Postfix SMTP server runs chrooted.Regardless of the
SASL implementation type, enabling SMTP authentication in the Postfix SMTP server
always requires setting the smtpd_sasl_auth_enable option:
“SASL authentication and Postfix”Continue reading