UPWORK/ODESK guru: Tips and Tricks for clients

skype: upwork.link , email: [email protected]

Archive for December, 2012

Disable dns lookups for mysql

without comments

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!

Written by spectre

December 18th, 2012 at 6:34 pm

Posted in Mysql

Noninteractive package installation on Debian squeezy – debconf way

without comments

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.

Read the rest of this entry »

Written by spectre

December 17th, 2012 at 10:57 am

Posted in Tips and Tricks

Protected: Mysql – all about charset. Mysql – все о кодировке.

without comments

This content is password protected. To view it please enter your password below:

Written by spectre

December 12th, 2012 at 7:24 pm

Posted in Mysql

How do I get the full path to a Perl script that is executing? – Right way.

without comments

  • 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";
    
     Read the rest of this entry »

Written by spectre

December 6th, 2012 at 12:12 pm

Posted in Perl

SASL authentication and Postfix

without comments

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:

Read the rest of this entry »

Written by spectre

December 3rd, 2012 at 5:03 pm

Posted in Postfix & Amavis

Пароли пользователей (root) в mysql.

without comments

Сброс пароля root в несколько шагов когда пароль забыт или неизвестен.

Read the rest of this entry »

Written by spectre

December 1st, 2012 at 3:19 pm

Posted in Mysql