HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (
-   Installation/Configuration (
-   -   OpenSuse 12.1 "vlogger" script issue (

vbayer 19th March 2012 21:34

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:
Unfortunately, this topic still is not resolved.

My observations are as following:

1. Initial ("from scratch") installation of OpenSuse 12.1 and then ISPConfig
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/ 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

I tried to add "mysql" to this file:
Quote: 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,

maresri 20th April 2012 15:48

Im experiencing similar errors in /var/log/apache2/error_log.
I run ISPConfig Version: on OpenSUSE 12.1.


[Fri Apr 20 14:22:58 2012] [notice] Apache/2.2.21 (Linux/SUSE) mod_ssl/2.2.21 OpenSSL/1.0.0e PHP/5.3.8 mod_fcgid/2.3.6 DAV/2 mod_ruby/1.3.0 Ruby/1.8.7(2011-12-28) mod_python/3.3.1 Python/2.7.2 configured -- resuming normal operations
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
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

till 20th April 2012 15:54

There are most lile someperl modules missing. Either the bd / dbi modules or perl date.

The dbi modules can be installed with:

yast2 -i perl-DBD-mysql perl-DBI

For the perl date modules you might sarch with yast as I dont know the exact names.

maresri 20th April 2012 16:23

I have these perl modules already installed. Including modules you mentioned.


i | perl                                | The Perl interpreter                                                                  | package
i | perl-Archive-Zip                    | Provide an interface to ZIP archive files                                              | package
i | perl-Authen-SASL                    | SASL Authentication framework                                                          | package
i | perl-BerkeleyDB                      | Perl extension for Berkeley DB version 2, 3 or 4                                      | package
i | perl-Bootloader                      | Library for Configuring Boot Loaders                                                  | package
i | perl-Class-Factory-Util              | Provide utility methods for factory classes                                            | package
i | perl-Class-Load                      | A working require "Class::Name" and more                                              | package
i | perl-Class-Singleton                | Implementation of a "Singleton" class                                                  | package
i | perl-Clone                          | Recursively copy Perl datatypes                                                        | package
i | perl-Config-Crontab                  | Read/Write Vixie compatible crontab files                                              | package
i | perl-Convert-ASN1                    | ASN.1 Encode/Decode library                                                            | package
i | perl-Convert-BinHex                  | Extract data from Macintosh BinHex files                                              | package
i | perl-Convert-TNEF                    | Perl module to read TNEF files                                                        | package
i | perl-Convert-UUlib                  | Perl interface to the uulib library                                                    | package
i | perl-Crypt-DES                      | Perl DES encryption module                                                            | package
i | perl-Crypt-OpenSSL-RSA              | RSA encoding and decoding, using the openSSL libraries                                | package
i | perl-Crypt-OpenSSL-Random            | Crypt::OpenSSL::Random Perl module                                                    | package
i | perl-Crypt-Rijndael                  | Crypt::CBC compliant Rijndael encryption module                                        | package
i | perl-Crypt-SmbHash                  | perl module Crypt::SmbHash                                                            | package
i | perl-DBD-mysql                      | MySQL driver for the Perl5 Database Interface (DBI)                                    | package
i | perl-DBI                            | Database independent interface for Perl                                                | package
i | perl-DateTime                        | A date and time object                                                                | package
i | perl-DateTime-Format-Builder        | Create DateTime parser classes and objects                                            | package
i | perl-DateTime-Format-Strptime        | Parse and format strp and strf time patterns                                          | package
i | perl-DateTime-Locale                | Localization support for                                                  | package
i | perl-DateTime-TimeZone              | Time zone object base class and factory                                                | package
i | perl-Digest-HMAC                    | Keyed-Hashing for Message Authentication                                              | package
i | perl-Digest-MD4                      | RSA MD4 Message Digest Algorithm (Perl Module)                                        | package
i | perl-Digest-SHA1                    | Perl Interface to the SHA-1 Algorithm                                                  | package
i | perl-Encode-Detect                  | An Encode::Encoding subclass that detects the encoding of data                        | package
i | perl-Encode-Locale                  | Determine the locale encoding                                                          | package
i | perl-Error                          | Error/exception handling in an OO-ish way                                              | package
i | perl-File-Listing                    | parse directory listing                                                                | package
i | perl-HTML-Parser                    | HTML parser class                                                                      | package
i | perl-HTML-SimpleParse                | a bare-bones HTML parser                                                              | package
i | perl-HTML-Tagset                    | Data tables useful in parsing HTML                                                    | package
i | perl-HTTP-Cookies                    | HTTP cookie jars                                                                      | package
i | perl-HTTP-Daemon                    | a simple http server class                                                            | package
i | perl-HTTP-Date                      | Date conversion routines                                                              | package
i | perl-HTTP-Message                    | HTTP style message (base class)                                                        | package
i | perl-HTTP-Negotiate                  | choose a variant to serve                                                              | package
i | perl-IO-Socket-INET6                | Object interface for AF_INET|AF_INET6 domain sockets                                  | package
i | perl-IO-Socket-SSL                  | Nearly transparent SSL encapsulation for IO::Socket::INET                              | package
i | perl-IO-stringy                      | I/O on in-core objects like strings and arrays                                        | package
i | perl-IP-Country                      | Fast lookup of country codes from IP addresses                                        | package
i | perl-LWP-MediaTypes                  | guess media type for a file or a URL                                                  | package
i | perl-List-MoreUtils                  | Provide the stuff missing in List::Util                                                | package
i | perl-MIME-tools                      | modules for parsing (and creating!) MIME entities                                      | package
i | perl-MLDBM                          | store multidimensional hash structures in tied hashes                                  | package
i | perl-Mail-DKIM                      | Signs/verifies Internet mail with DKIM/DomainKey signatures                            | package
i | perl-Mail-SPF                        | An object-oriented implementation of Sender Policy Framework                          | package
i | perl-Mail-SpamAssassin              | Perl Modules For Using Spamassassin Within An Own Perl Script                          | package
i | perl-MailTools                      | Set of perl modules related to mail applications                                      | package
i | perl-Math-Round                      | Perl extension for rounding numbers                                                    | package
i | perl-Net-CIDR-Lite                  | Perl extension for merging IPv4 or IPv6 CIDR addresses                                | package
i | perl-Net-DNS                        | Perl interface to the DNS resolver                                                    | package
i | perl-Net-Daemon                      | Perl extension for portable daemons                                                    | package
i | perl-Net-HTTP                        | Low-level HTTP connection (client)                                                    | package
i | perl-Net-IP                          | allow easy manipulation of IPv4 and IPv6 addresses                                    | package
i | perl-Net-Ident                      | Lookup the username on the remote end of a TCP/IP connection                          | package
i | perl-Net-LibIDN                      | Net::LibIDN Perl module                                                                | package
i | perl-Net-SNMP                        | Object oriented interface to SNMP                                                      | package
i | perl-Net-SSLeay                      | Perl extension for using OpenSSL                                                      | package
i | perl-Net-Server                      | Extensible, general Perl server engine                                                | package
i | perl-NetAddr-IP                      | Manages IPv4 and IPv6 addresses and subnets                                            | package
i | perl-NetxAP                          | Interface to the protocol family IMAP, IMSP, ACAP, and ICAP                            | package
i | perl-Params-Util                    | Simple, compact and correct param-checking functions                                  | package
i | perl-Params-Validate                | Validate method/function parameters                                                    | package
i | perl-Parse-RecDescent                | Generate Recursive-Descent Parsers                                                    | package
i | perl-PlRPC                          | Perl Extension for Writing PlRPC Servers                                              | package
i | perl-SQL-Statement                  | SQL parsing and processing engine                                                      | package
i | perl-Socket6                        | IPv6 Sockets (Perl Module)                                                            | package
i | perl-Sys-Hostname-Long              | Try every conceivable way to get full hostname                                        | package
i | perl-TermReadLine-Gnu                | Perl extension for the GNU Readline/History Library                                    | package
i | perl-TimeDate                        | Parse date strings into time values                                                    | package
i | perl-URI                            | Uniform Resource Identifiers (absolute and relative)                                  | package
i | perl-Unix-Syslog                    | Perl interface to the UNIX syslog(3) calls                                            | package
i | perl-WWW-RobotRules                  | database of robots.txt-derived permissions                                            | package
i | perl-X500-DN                        | Provides an interface for RFC 2253 style DN strings                                    | package
i | perl-XML-LibXML                      | Perl Binding for libxml2                                                              | package
i | perl-XML-NamespaceSupport            | A simple generic namespace support class                                              | package
i | perl-XML-Parser                      | A perl module for parsing XML documents                                                | package
i | perl-XML-SAX                        | XML::SAX Perl Module                                                                  | package
i | perl-XML-SAX-Base                    | Base class SAX Drivers and Filters                                                    | package
i | perl-XML-Simple                      | Easy API to read/write XML (Perl module)                                              | package
i | perl-XML-XPath                      | A set of modules for parsing and evaluating XPath statements                          | package
i | perl-base                            | The Perl interpreter                                                                  | package
i | perl-gettext                        | Message handling functions                                                            | package
i | perl-ldap                            | Client Interface for LDAP Servers                                                      | package
i | perl-libwww-perl                    | The World-Wide-Web library for Perl                                                    | package
i | perl-razor-agents                    | The required perl modules for razor-agents                                            | package

till 20th April 2012 16:39

Do you get any errors when you run this command:


maresri 20th April 2012 17:08

This show usage of vlogger.


Usage: vlogger [OPTIONS]... [LOGDIR]
Handles a piped logfile from a webserver, splitting it into it's
host components, and rotates the files daily.

jumba 17th May 2012 16:09

We have the same problem with the perfect server setup on Ubuntu 12.04.

Falko has opened a bug for it.

Till, any suggestions?

till 18th May 2012 11:03

We will check that and try to reproduce it on our test servers.

sotourda 17th July 2012 17:33

vlogger error
Hello, I have the manual, where is the solution????

my problem is:

access_log: - - [17/Jul/2012:16:53:52 +0200] "POST /administrator/index.php?option=com_media&task=file.upload&tmpl=c omponent&a3edf680c80948d30f67894340c9a5e9=kvs9h6c2 74pq96t4o9h9hg69l0sg005l9rf1246oqgcbvqcad2p1&9b105 55da6e5c90da37b27bc1a598d6d=1&format=html HTTP/1.1" 500 1851 "" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/536.11 (KHTML, like Gecko) Chrome/20.0.1132.47 Safari/536.11" - - [17/Jul/2012:16:53:55 +0200] "GET /administrator/index.php?option=com_media&view=mediaList&tmpl=com ponent HTTP/1.1" 200 12079 "" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/536.11 (KHTML, like Gecko) Chrome/20.0.1132.47 Safari/536.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

I am ussing joomla 2.5, and i can not upload any media archive or extension

sorry if my english is bad.


till 17th July 2012 18:28

The issue has been solved already. Just update your system to the current ispconfig version.

All times are GMT +2. The time now is 22:02.

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