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/installation-und-konfiguration-12/fresh-install-von-ispc-3-0-4-3-auf-opensuse-12-1-nach-perfectsetup-mit-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.): 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 /etc/systemd/system/multi-user.target.wants/apache2.service 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,
Im experiencing similar errors in /var/log/apache2/error_log. I run ISPConfig Version: 3.0.4.4 on OpenSUSE 12.1. Code: [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
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.
I have these perl modules already installed. Including modules you mentioned. Code: 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 DateTime.pm | 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
This show usage of vlogger. Code: Usage: vlogger [OPTIONS]... [LOGDIR] Handles a piped logfile from a webserver, splitting it into it's host components, and rotates the files daily. ...
We have the same problem with the perfect server setup on Ubuntu 12.04. Falko has opened a bug for it. Till, any suggestions? Thanks
vlogger error Hello, I have the manual, where is the solution???? my problem is: access_log: 192.168.1.101 - - [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 "http://192.168.1.101/administrator/index.php?option=com_media" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/536.11 (KHTML, like Gecko) Chrome/20.0.1132.47 Safari/536.11" 192.168.1.101 - - [17/Jul/2012:16:53:55 +0200] "GET /administrator/index.php?option=com_media&view=mediaList&tmpl=component HTTP/1.1" 200 12079 "http://192.168.1.101/administrator/index.php?option=com_media" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/536.11 (KHTML, like Gecko) Chrome/20.0.1132.47 Safari/536.11" erro_log: 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.
Now I have the next error: error_log: [Tue Jul 17 18:09:45 2012] [error] [client 192.168.1.2] 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: https://192.168.1.101:8080/index.php# /* 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("log_id",$logId); $app->tpl->setVar("list_desc_txt", $description); $app->tpl->setVar("time", getDataTime($logId)); $app->tpl->setVar("monTransDate", $monTransDate); $app->tpl->setVar("monTransRefreshsq", $monTransRefreshsq); $app->tpl_defaults(); $app->tpl->pparse(); access_log: 192.168.1.2 - - [17/Jul/2012:18:21:59 +0200] "GET /monitor/show_data.php?type=fail2ban HTTP/1.1" 200 261 "https://192.168.1.101:8080/index.php#" "Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)"
The problem is not solved. The server not acept uploads if the size is up 128 Kb. any idea?????? Sorry for my english.