View Single Post
  #1  
Old 19th March 2012, 21:34
vbayer vbayer is offline
Junior Member
 
Join Date: Mar 2012
Location: Grudziądz, Poland
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Skype™ to vbayer
Default OpenSuse 12.1 "vlogger" script issue

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.):
Quote:
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:
Quote:
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 :
Quote:
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
Quote:
# 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:
Quote:
After=syslog.target network.target mysql
but unsuccessfully. The following error was indicated:
Quote:
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,
Reply With Quote
Sponsored Links