#1  
Old 7th May 2012, 14:24
cusco cusco is offline
Junior Member
 
Join Date: Nov 2011
Location: ~/
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Skype™ to cusco
Angry vlogger (problem)

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:

Code:
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
Reply With Quote
Sponsored Links
  #2  
Old 7th May 2012, 15:24
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,983
Thanks: 825
Thanked 5,372 Times in 4,219 Posts
Default

Which Debian version do you use and which ispconfig version?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 7th May 2012, 15:27
cusco cusco is offline
Junior Member
 
Join Date: Nov 2011
Location: ~/
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Skype™ to cusco
Default

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
Code:
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
Reply With Quote
  #4  
Old 7th May 2012, 15:32
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,983
Thanks: 825
Thanked 5,372 Times in 4,219 Posts
Default

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
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
Reply

Bookmarks

Tags
debian, ispconfig 3, vlogger

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MyDNS notify problem sgabor Installation/Configuration 4 21st December 2011 18:01
table lookup problem aurelius Installation/Configuration 5 2nd November 2011 19:12
Strange email problem for one of my domains... any help appreciated paulrobert_a Installation/Configuration 5 9th August 2010 14:15
ISPConfig3 Mail Warn Errors reason8 General 3 25th November 2009 13:58
BIG Problem Postfix issue admins Installation/Configuration 11 13th November 2009 10:05


All times are GMT +2. The time now is 08:27.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.