Time to upgrade debian lenny

It is time to say good bye to debian lenny. Time to upgrade...

http://www.debian.org/News/2013/20131012

Can't connect to local MySQL server through socket

My problem occured after I increased the size of the MySQL query_cache_size. The first step to fix this problem was to stop the MySQL server through the init.d script:

/etc/init.d/mysql stop

After I changed the query_cache_size setting in /etc/mysql/my.cnf to 16M

So I tried to start the MySQL server again but the following error message was shown:

Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!

And in the syslog:

Jan 26 16:14:34 1106-28-18 /etc/init.d/mysql[25916]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Jan 26 16:14:34 1106-28-18 /etc/init.d/mysql[25916]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Jan 26 16:14:34 1106-28-18 /etc/init.d/mysql[25916]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Jan 26 16:14:34 1106-28-18 /etc/init.d/mysql[25916]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Jan 26 16:14:34 1106-28-18 /etc/init.d/mysql[25916]:

So I took a look to the /var/run/mysqld/ directory if there is a mysqld.sock file, it was not there so I created it and made the mysql user to his owner:

chown mysql /var/run/mysqld/mysqld.sock
touch /var/run/mysqld/mysqld.sock

After I started MySQL with the init.d script the server runs like it should

Plesk vhost and register globals

To activate register globals or other php modules on a linux machine running plesk you have to create a file named vhost.conf in the conf directory of your virtual host directory containing something like this:

php_flag register_globals on

After that I had to execute the following command:

/usr/local/psa/admin/sbin/websrvmng --reconfigure-vhost --vhost-name=domain.com

terminal browser

A great terminal web browser for linux is w3m. It is easy to use and works how a browser should work.

apt-get install w3m

horde Auth_imp: Required IMAP extension not found.

I installed the horde webmail groupware on my rackmounted server as it is described in the horde webmail wiki for debian. After I tried to login to my mailaccount via horde I received the following error message

A fatal error has occurred
Auth_imp: Required IMAP extension not found.
Details have been logged for the administrator.

The solution was to install the imap extension for php5:

apt-get install php5-imap

"sh: /mogrify: No such file or directory"

This has actually nothing to do with specially with debian lenny. This problem can happen on any machine which runs a apache webserver. In a PHP Script I use a ImageMagick function called mogrify to resize the images automatically. It did not work and in my /var/log/apache2/error.log I found this entry:

"sh: /mogrify: No such file or directory"

The solution was very simple. I had activated PHP SafeMode which prevent PHP Scripts from using the exec command. After I deactivated Safe Mode ImageMagick works how it should.

lost connection after UNKNOWN

I had this message in the mail.log after I tried to send a mail through my new isp using mozilla thunderbird lost connection after UNKNOWN. The solution was to configure the outgoing server new I use STARTTLS and confirm the certificate again.