vlogger (problem)

[cusco]

Hello.

First of all, thank you folks so much for ISPConfig. It is a great help.

Now, I set it up in a server, and upgraded it over the time as it was requested.

I am using Debian and in Apache2 error.log I find:

1 configured -- resuming normal operations
[Mon May 07 13:05:44 2012] [error] [client 85.68.37.102] File does not exist: /var/www/feed
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
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
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
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
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
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 would like to understand what is happening, because some hours after apache is running, I get a alarm stating that apache does not reply. Only after I restart the service.

I googled for this and found something about missing perl modules but I have the 'datetime' installed:
libdatetime-format-builder-perl libdatetime-format-http-perl libdatetime-format-strptime-perl libdatetime-locale-perl libdatetime-perl libdatetime-timezone-perl

[till]

Which Debian version do you use and which ispconfig version?

[cusco]

Hi,

Thanks for replying.

ISPConfig is ISPConfig 3.0.4.4

Debian is wheezy (as it in frozen state)

I also tried using /usr/sbin/vlogger (from debian package) instead and error.log shows the following

1 configured -- resuming normal operations
[Mon May 07 13:26:07 2012] [error] [client 173.192.238.48] File does not exist: /var/www/feed
DBI connect('database=dbispconfig;host=localhost:3306','ispconfig',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/local/ispconfig/server/scripts/vlogger line 507
DBI Error:  at /usr/local/ispconfig/server/scripts/vlogger line 507, <STDIN> line 1.
Can't call method "prepare" on an undefined value at /usr/local/ispconfig/server/scripts/vlogger line 511, <STDIN> line 1.
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
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
DBI connect('database=dbispconfig;host=localhost:3306','ispconfig',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/local/ispconfig/server/scripts/vlogger line 507
DBI Error:  at /usr/local/ispconfig/server/scripts/vlogger line 507, <STDIN> line 6.
Can't call method "prepare" on an undefined value at /usr/local/ispconfig/server/scripts/vlogger line 511, <STDIN> line 6.
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
[Mon May 07 13:35:38 2012] [error] [client 176.9.183.131] client sent HTTP/1.1 request without hostname (see RFC2616 section 14.23): /w00tw00t.at.ISC.SANS.DFind:)
[Mon May 07 13:35:46 2012] [error] [client 85.68.37.102] File does not exist: /var/www/feed
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
DBI connect('database=dbispconfig;host=localhost:3306','ispconfig',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/local/ispconfig/server/scripts/vlogger line 507
DBI Error:  at /usr/local/ispconfig/server/scripts/vlogger line 507, <STDIN> line 1.
Can't call method "prepare" on an undefined value at /usr/local/ispconfig/server/scripts/vlogger line 511, <STDIN> line 1.
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
DBI connect('database=dbispconfig;host=localhost:3306','ispconfig',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/local/ispconfig/server/scripts/vlogger line 507
DBI Error:  at /usr/local/ispconfig/server/scripts/vlogger line 507, <STDIN> line 1.
Can't call method "prepare" on an undefined value at /usr/local/ispconfig/server/scripts/vlogger line 511, <STDIN> line 1.
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
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
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
DBI connect('database=dbispconfig;host=localhost:3306','ispconfig',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/local/ispconfig/server/scripts/vlogger line 507
DBI Error:  at /usr/local/ispconfig/server/scripts/vlogger line 507, <STDIN> line 1.
Can't call method "prepare" on an undefined value at /usr/local/ispconfig/server/scripts/vlogger line 511, <STDIN> line 1.
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
DBI connect('database=dbispconfig;host=localhost:3306','ispconfig',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/local/ispconfig/server/scripts/vlogger line 507
DBI Error:  at /usr/local/ispconfig/server/scripts/vlogger line 507, <STDIN> line 1.
Can't call method "prepare" on an undefined value at /usr/local/ispconfig/server/scripts/vlogger line 511, <STDIN> line 1.
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
[Mon May 07 13:46:11 2012] [error] [client 85.68.37.102] File does not exist: /var/www/feed
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
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
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
[Mon May 07 13:56:15 2012] [error] [client 174.36.228.156] File does not exist: /var/www/feed
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
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
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
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
DBI connect('database=dbispconfig;host=localhost:3306','ispconfig',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/local/ispconfig/server/scripts/vlogger line 507
DBI Error:  at /usr/local/ispconfig/server/scripts/vlogger line 507, <STDIN> line 1.
Can't call method "prepare" on an undefined value at /usr/local/ispconfig/server/scripts/vlogger line 511, <STDIN> line 1.
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
[Mon May 07 14:05:48 2012] [error] [client 85.68.37.102] File does not exist: /var/www/feed
DBI connect('database=dbispconfig;host=localhost:3306','ispconfig',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/local/ispconfig/server/scripts/vlogger line 507
DBI Error:  at /usr/local/ispconfig/server/scripts/vlogger line 507, <STDIN> line 2.
Can't call method "prepare" on an undefined value at /usr/local/ispconfig/server/scripts/vlogger line 511, <STDIN> line 2.
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
[Mon May 07 14:06:46 2012] [error] [client 77.88.28.246] File does not exist: /var/www/robots.txt
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
DBI connect('database=dbispconfig;host=localhost:3306','ispconfig',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/local/ispconfig/server/scripts/vlogger line 507
DBI Error:  at /usr/local/ispconfig/server/scripts/vlogger line 507, <STDIN> line 11.
Can't call method "prepare" on an undefined value at /usr/local/ispconfig/server/scripts/vlogger line 511, <STDIN> line 11.
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
DBI connect('database=dbispconfig;host=localhost:3306','ispconfig',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/local/ispconfig/server/scripts/vlogger line 507
DBI Error:  at /usr/local/ispconfig/server/scripts/vlogger line 507, <STDIN> line 1.
Can't call method "prepare" on an undefined value at /usr/local/ispconfig/server/scripts/vlogger line 511, <STDIN> line 1.
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
DBI connect('database=dbispconfig;host=localhost:3306','ispconfig',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/local/ispconfig/server/scripts/vlogger line 507
DBI Error:  at /usr/local/ispconfig/server/scripts/vlogger line 507, <STDIN> line 1.
Can't call method "prepare" on an undefined value at /usr/local/ispconfig/server/scripts/vlogger line 511, <STDIN> line 1.
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
DBI connect('database=dbispconfig;host=localhost:3306','ispconfig',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/local/ispconfig/server/scripts/vlogger line 507
DBI Error:  at /usr/local/ispconfig/server/scripts/vlogger line 507, <STDIN> line 1.
Can't call method "prepare" on an undefined value at /usr/local/ispconfig/server/scripts/vlogger line 511, <STDIN> line 1.
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
DBI connect('database=dbispconfig;host=localhost:3306','ispconfig',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/local/ispconfig/server/scripts/vlogger line 507
DBI Error:  at /usr/local/ispconfig/server/scripts/vlogger line 507, <STDIN> line 1.
Can't call method "prepare" on an undefined value at /usr/local/ispconfig/server/scripts/vlogger line 511, <STDIN> line 1.
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
DBI connect('database=dbispconfig;host=localhost:3306','ispconfig',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/local/ispconfig/server/scripts/vlogger line 507
DBI Error:  at /usr/local/ispconfig/server/scripts/vlogger line 507, <STDIN> line 1.
Can't call method "prepare" on an undefined value at /usr/local/ispconfig/server/scripts/vlogger line 511, <STDIN> line 1.
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
DBI connect('database=dbispconfig;host=localhost:3306','ispconfig',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/local/ispconfig/server/scripts/vlogger line 507
DBI Error:  at /usr/local/ispconfig/server/scripts/vlogger line 507, <STDIN> line 1.
Can't call method "prepare" on an undefined value at /usr/local/ispconfig/server/scripts/vlogger line 511, <STDIN> line 1.
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
DBI connect('database=dbispconfig;host=localhost:3306','ispconfig',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/local/ispconfig/server/scripts/vlogger line 507
DBI Error:  at /usr/local/ispconfig/server/scripts/vlogger line 507, <STDIN> line 1.
Can't call method "prepare" on an undefined value at /usr/local/ispconfig/server/scripts/vlogger line 511, <STDIN> line 1.
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
DBI connect('database=dbispconfig;host=localhost:3306','ispconfig',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/local/ispconfig/server/scripts/vlogger line 507
DBI Error:  at /usr/local/ispconfig/server/scripts/vlogger line 507, <STDIN> line 1.
Can't call method "prepare" on an undefined value at /usr/local/ispconfig/server/scripts/vlogger line 511, <STDIN> line 1.
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
[Mon May 07 14:16:13 2012] [error] [client 85.68.37.102] File does not exist: /var/www/feed
DBI connect('database=dbispconfig;host=localhost:3306','ispconfig',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/local/ispconfig/server/scripts/vlogger line 507
DBI Error:  at /usr/local/ispconfig/server/scripts/vlogger line 507, <STDIN> line 1.
Can't call method "prepare" on an undefined value at /usr/local/ispconfig/server/scripts/vlogger line 511, <STDIN> line 1.
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
DBI connect('database=dbispconfig;host=localhost:3306','ispconfig',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/local/ispconfig/server/scripts/vlogger line 507
DBI Error:  at /usr/local/ispconfig/server/scripts/vlogger line 507, <STDIN> line 1.
Can't call method "prepare" on an undefined value at /usr/local/ispconfig/server/scripts/vlogger line 511, <STDIN> line 1.
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
DBI connect('database=dbispconfig;host=localhost:3306','ispconfig',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/local/ispconfig/server/scripts/vlogger line 507
DBI Error:  at /usr/local/ispconfig/server/scripts/vlogger line 507, <STDIN> line 1.
Can't call method "prepare" on an undefined value at /usr/local/ispconfig/server/scripts/vlogger line 511, <STDIN> line 1.
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
DBI connect('database=dbispconfig;host=localhost:3306','ispconfig',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/local/ispconfig/server/scripts/vlogger line 507
DBI Error:  at /usr/local/ispconfig/server/scripts/vlogger line 507, <STDIN> line 5.
Can't call method "prepare" on an undefined value at /usr/local/ispconfig/server/scripts/vlogger line 511, <STDIN> line 5.
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
DBI connect('database=dbispconfig;host=localhost:3306','ispconfig',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/local/ispconfig/server/scripts/vlogger line 507
DBI Error:  at /usr/local/ispconfig/server/scripts/vlogger line 507, <STDIN> line 1.
Can't call method "prepare" on an undefined value at /usr/local/ispconfig/server/scripts/vlogger line 511, <STDIN> line 1.
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

So I reverted to the vlogger from ispconfig

[till]

The debian vlogger will not work as it can cause apache to hang sometimes, the ispconfig version is patched in this regard. But you can install vlogger from debian to get all dependencies installed. Just ensure that the debian vlogger is not used anywhere in the apache config files.

So run:

apt-get install vlogger

to get all dependencies installed. Seems as if the vlogger config file is broken on your server, take a look into the file /etc/vlogger-dbi.conf and ensure that the password for the mysql user "ispconfig" in that file is the smame then the one that you find in the file /usr/local/ispconfig/server/lib/config.inc.php