[vbayer]

I've got a problem with OpenSuse 12.1 "vlogger" script. The issue description could be found on one of German's forum: http://www.howtoforge.de/forum/insta...-apache2-5448/
Unfortunately, this topic still is not resolved.

My observations are as following:

1. Initial ("from scratch") installation of OpenSuse 12.1 and then ISPConfig 3.0.4.3
2. After this, I observed the following entry in "Apache-error_log" every 5 minutes (ca.):

piped log program ' /usr/local/ispconfig/server/scripts/vlogger -s access.log -t "%Y%m%d-access.log" -d "/etc/vlogger-dbi.conf" /var/log/ispconfig/httpd' failed unexpectedly

I checked "On page traffic" statistics and they look good in my opinion. I see that these statistics are calculated accurately (they are incrementing) so it looks like "vlogger" scricpt works with "mysql" properly.

However, during system startup there is an error message indicated by Apache module:

Mar 19 17:28:36 ibox8 systemd[1]: PID file /var/run/httpd2.pid not readable (yet?) after start.
Mar 19 17:28:36 ibox8 start_apache2[1533]: MySQL Connection problem

Also, the followng entry is logged in Apache-error_log :

DBI connect('database=dbispconfig;host=localhost:3306' ,'ispconfig',...) failed: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2) at /usr/local/ispconfig/server/scripts/vlogger line 257

Because of Apache is started before MySQL, I'm not sure if this fact does not impact "vlogger" functionality.

I tried to change startiing sequence of services by updating

# Required-Start: $local_fs $remote_fs $network mysql

in /etc/init.d/apache2

but without any success

It turned out that "Apache" is started by
/etc/systemd/system/multi-user.target.wants/apache2.service

I tried to add "mysql" to this file:

After=syslog.target network.target mysql

but unsuccessfully. The following error was indicated:

Mar 19 17:48:54 ibox8 systemd[1]: Failed to add dependency on mysql, ignoring: Invalid argument

I have no any ather idea how to fight this issue and belive you guys can help me.

My questios are:

1. How to enforce start of MySQL before Apache initialization in OpenSuse 12.1?
2. How to eliminate "vlogger" error?

Thanks for your help.

Best regards,