Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 19th March 2012, 21:34
vbayer vbayer is offline
Junior Member
 
Join Date: Mar 2012
Location: Grudziądz, Poland
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Skype™ to vbayer
Default 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: http://www.howtoforge.de/forum/insta...-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.):
Quote:
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:
Quote:
Mar 19 17:28:36 ibox8 systemd[1]: PID file /var/run/httpd2.pid 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 :
Quote:
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
Quote:
# 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
/etc/systemd/system/multi-user.target.wants/apache2.service

I tried to add "mysql" to this file:
Quote:
After=syslog.target network.target mysql
but unsuccessfully. The following error was indicated:
Quote:
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,
Reply With Quote
Sponsored Links
  #2  
Old 20th April 2012, 15:48
maresri maresri is offline
Junior Member
 
Join Date: Mar 2012
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #3  
Old 20th April 2012, 15:54
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,733
Thanks: 840
Thanked 5,596 Times in 4,407 Posts
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
bowlAltetle (21st July 2014)
  #4  
Old 20th April 2012, 16:23
maresri maresri is offline
Junior Member
 
Join Date: Mar 2012
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #5  
Old 20th April 2012, 16:39
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,733
Thanks: 840
Thanked 5,596 Times in 4,407 Posts
Default

Do you get any errors when you run this command:

/usr/local/ispconfig/server/scripts/vlogger
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #6  
Old 20th April 2012, 17:08
maresri maresri is offline
Junior Member
 
Join Date: Mar 2012
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.
...
Reply With Quote
Reply

Bookmarks

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
HowTo - upgrade openSuSE 11.4 to 12.1 Landis HOWTO-Related Questions 2 21st January 2012 22:54
Cannot login to phpmyadmin penkku HOWTO-Related Questions 1 24th February 2011 10:26
freebsd 7, samba 3, domain controller alexdimarco Suggest HOWTO 6 5th November 2010 17:54


All times are GMT +2. The time now is 09:45.


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