ISPConfig 3.0.1.4 causes Apache to have too many open files

[SamTzu]

Sorry, Till. I don't know how to do that.

I'm looking at the file and this is what it shows me...
What shall I check it with against?

dsn DBI:mysql:database=dbispconfig;host=localhost:3306
user ispconfig
pass a5dccXXXXXXX1c02079aYYYYd6f7a1
dump 30

[till]

run:

mysql -u ispconfig -p dbispconfig

and then enter the passphrase that is listed in the line "pass" of the file. If you are able to login, then this part is fine and you must have a different problem. In this case please post the exact error messages that you get and where you got them.

[SamTzu]

I could log in properly to the database.
Restarting apache seems to help with the openfiles problem.
I did lsof before I restarted apache and after restart.

This is where it seem to go wrong...
After this it seems to repeat same FIFO stuff over and over...

apache2 497 www-data mem REG 254,2 11404089 /usr/lib/apache2/modules/mod_alias.so (path dev=0,55)
apache2 497 www-data mem REG 254,2 9830703 /lib/ld-2.7.so (path dev=0,55)
apache2 497 www-data 0r CHR 1,3 9652486 /dev/null
apache2 497 www-data 1w CHR 1,3 9652486 /dev/null
apache2 497 www-data 2w REG 0,55 3454444 10904184 /var/log/apache2/error.log
apache2 497 www-data 3u IPv6 10350045 TCP *:www (LISTEN)
apache2 497 www-data 4u sock 0,4 10350046 can't identify protocol
apache2 497 www-data 5u IPv6 10350050 TCP *:http-alt (LISTEN)
apache2 497 www-data 6u sock 0,4 10350051 can't identify protocol
apache2 497 www-data 7r FIFO 0,5 10860218 pipe
apache2 497 www-data 8w FIFO 0,5 10860218 pipe
apache2 497 www-data 9w REG 0,55 75688 10904188 /var/log/apache2/other_vhosts_access.log
apache2 497 www-data 10u 0000 0,6 0 6908 anon_inode
apache2 497 www-data 11w FIFO 0,5 10860219 pipe
apache2 497 www-data 12w REG 0,55 6121 10904186 /var/log/apache2/access.log
apache2 497 www-data 13u sock 0,4 13170653 can't identify protocol
apache2 497 www-data 15w FIFO 0,5 10860221 pipe
apache2 497 www-data 17w FIFO 0,5 10860222 pipe
apache2 497 www-data 18w FIFO 0,5 10860247 pipe
apache2 497 www-data 19w FIFO 0,5 10860294 pipe
apache2 497 www-data 20w FIFO 0,5 10860248 pipe
apache2 497 www-data 21w FIFO 0,5 10860358 pipe
apache2 497 www-data 22w FIFO 0,5 10860295 pipe
apache2 497 www-data 23w FIFO 0,5 10860458 pipe
apache2 497 www-data 24w FIFO 0,5 10860359 pipe
apache2 497 www-data 25w FIFO 0,5 10860502 pipe
apache2 497 www-data 26w FIFO 0,5 10860459 pipe
apache2 497 www-data 27w FIFO 0,5 10860543 pipe
apache2 497 www-data 28w FIFO 0,5 10860503 pipe
apache2 497 www-data 29w FIFO 0,5 10860558 pipe
apache2 497 www-data 30w FIFO 0,5 10860544 pipe
apache2 497 www-data 31w FIFO 0,5 10860572 pipe
apache2 497 www-data 32w FIFO 0,5 10860559 pipe
apache2 497 www-data 33w FIFO 0,5 10860590 pipe
apache2 497 www-data 34w FIFO 0,5 10860573 pipe
apache2 497 www-data 35w FIFO 0,5 10861153 pipe
apache2 497 www-data 36w FIFO 0,5 10860591 pipe

In apache error log I see this...

BEGIN failed--compilation aborted at /usr/local/ispconfig/server/scripts/vlogger line 147.
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
Can't locate Date/Format.pm in @INC (@INC contains: /etc/perl /usr/local/lib/perl/5.10.0 /usr/local/share/perl/5.10.0 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl) at /usr/local/ispconfig/server/scripts/vlogger line 147

[till]

Ok, so the Date/Format perl module is missing on your server which is required by vloggaer and this causes apache to fail.

on debian and ubuntu the package is named libtimedate-perl and can be installed with:

apt-get install libtimedate-perl

for othert distributions this package is available too. Search for date "date::format" with yast or yum if you run a different linux distribution.

[SamTzu]

I have said it before and I say it again.

You are the man!

[grillonic]

Originally Posted by till

Ok, so the Date/Format perl module is missing on your server which is required by vloggaer and this causes apache to fail.

on debian and ubuntu the package is named libtimedate-perl and can be installed with:

apt-get install libtimedate-perl

for othert distributions this package is available too. Search for date "date::format" with yast or yum if you run a different linux distribution.

Do you know where can I look to find libtimedate-perl to install it in CentOS 5.4 ??, please, I'm having kinda the same problem, but mine is more like this:

BEGIN failed--compilation aborted at /usr/local/ispconfig/server/scripts/vlogger line 147.
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
Can't locate Date/Format.pm in @INC (@INC contains: /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/5.8.8) at /usr/local/ispconfig/server/scripts/vlogger line 147.
BEGIN failed--compilation aborted at /usr/local/ispconfig/server/scripts/vlogger line 147.
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
Can't locate Date/Format.pm in @INC (@INC contains: /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/5.8.8) at /usr/local/ispconfig/server/scripts/vlogger line 147.
BEGIN failed--compilation aborted at /usr/local/ispconfig/server/scripts/vlogger line 147.
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
Can't locate Date/Format.pm in @INC (@INC contains: /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/5.8.8) at /usr/local/ispconfig/server/scripts/vlogger line 147.
BEGIN failed--compilation aborted at /usr/local/ispconfig/server/scripts/vlogger line 147.

Hope you can help me too mate.

[till]

Run this command:

yum install webalizer perl-DateTime-Format-HTTP perl-DateTime-Format-Builder

To install all nescessary modules for the ispconfig statistics. Thats step 19 of the ispconfig installation instructions, so please follow the install guides closely to avoid such problems.

[crazylamp]

I have the same problem. And i have solved it by using the below command:

yum install perl-Time*

I'm using CentOS 5.4

[jrklein]

Thank you Till for your solution above and to you and Falko for all of your work on the ISPconfig project and documentation!

We were able to resolve this problem by installing the Perl Date::Format module on Debian Squeeze.

apt-get install libtimedate-perl

I recently built multiple VPS running a new/clean install of Debian Squeeze 6.0 and ISPconfig 3.0.4.6. My builds did not include the package. The installation guide I followed did not suggest installing the package since it likely assumed the package was already installed.

The apache2 processes would consume all available VPS memory and the VPS host would begin killing all new processes in the affected VPS. Restarting the apache2 service in the affected VPS would temporarily resolve the problem. The cause of the problem was obvious once we checked into it. The apache error log (/var/log/apache2/error.log) in the affected VPS contained hundreds of thousands of errors related to vlogger and the missing Perl module.

Originally Posted by till

Ok, so the Date/Format perl module is missing on your server which is required by vloggaer and this causes apache to fail.

on debian and ubuntu the package is named libtimedate-perl and can be installed with:

apt-get install libtimedate-perl

[pakogah]

Originally Posted by crazylamp

I have the same problem. And i have solved it by using the below command:

yum install perl-Time*

I'm using CentOS 5.4

on centos 6.3 it's installed using command

yum -y install perl-TimeDate

from: http://www.question-defense.com/2008...ormatpm-in-inc