OpenSuse 12.1 "vlogger" script issue

Discussion in 'Installation/Configuration' started by vbayer, Mar 19, 2012.

  1. vbayer

    vbayer New Member

    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.):
    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:
    Also, the followng entry is logged in Apache-error_log :
    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
    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:
    but unsuccessfully. The following error was indicated:
    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,
  2. maresri

    maresri New Member

    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
  3. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
  4. maresri

    maresri New Member

    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
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    Do you get any errors when you run this command:

  6. maresri

    maresri New Member

    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.
  7. jumba

    jumba New Member

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

    Falko has opened a bug for it.

    Till, any suggestions?
  8. till

    till Super Moderator Staff Member ISPConfig Developer

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

    sotourda New Member

    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=component&a3edf680c80948d30f67894340c9a5e9=kvs9h6c274pq96t4o9h9hg69l0sg005l9rf1246oqgcbvqcad2p1&9b10555da6e5c90da37b27bc1a598d6d=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=component 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.

    Last edited: Jul 17, 2012
  10. till

    till Super Moderator Staff Member ISPConfig Developer

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

    sotourda New Member

    Now I have the next error:


    [Tue Jul 17 18:09:45 2012] [error] [client] PHP Warning: nl2br() expects parameter 1 to be string, array given in /usr/local/ispconfig/interface/web/monitor/show_log.php on line 127, referer:

    /* fetch the Data from the DB */
    $record = $app->db->queryOneRecord("SELECT data, state FROM monitor_data WHERE type = '" . $app->db->quote($logId) . "' and server_id = " . $_SESSION['monitor']['server_id'] . " order by created desc");

    if(isset($record['data'])) {
    $data = unserialize($record['data']);

    $logData = nl2br($data);

    $app->tpl->setVar("log_data", $logData);
    } else {
    $app->tpl->setVar("log_data", $app->lng("no_logdata_txt"));

    $app->tpl->setVar("list_head_txt", $title);
    $app->tpl->setVar("list_desc_txt", $description);
    $app->tpl->setVar("time", getDataTime($logId));
    $app->tpl->setVar("monTransDate", $monTransDate);
    $app->tpl->setVar("monTransRefreshsq", $monTransRefreshsq);


    access_log: - - [17/Jul/2012:18:21:59 +0200] "GET /monitor/show_data.php?type=fail2ban HTTP/1.1" 200 261 "" "Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)"
    Last edited: Jul 17, 2012
  12. sotourda

    sotourda New Member

    The problem is not solved.

    The server not acept uploads if the size is up 128 Kb.

    any idea??????

    Sorry for my english.

    Last edited: Jul 19, 2012

Share This Page