Product:
Search Type:

Web statistics is not calculated. When I run 'statistics' or 'webalizer' manually, I get "db_put fail!" error.

Article ID: 1415 
Last Review: May,04 2007
APPLIES TO:
  • Plesk for Linux/Unix

RESOLUTION

If you get the following error when try to run 'statistics' utility:

 

# /usr/local/psa/admin/sbin/statistics --calculate-all
Webalizer V2.01-10 (Linux 2.6.9-34.0.2.ELsmp) English
Using logfile STDIN (clf)
DNS Lookup (15): db_put fail!

 

It means that /usr/local/psa/var/lib/webalizer/webalizer.cache or /var/lib/webalizer/dns_cache.db files were damaged or exceeded 2GB. These files are used by 'webalizer' to cache DNS queries when it resolves IPs from access_log requests to Apache came from. Remove the file and run 'statistics' again.

 

If you don't need to resolve IPs or statistics you can disable it by commenting DNSCache and DNSChildren directives in /etc/webalizer.conf and /var/www/vhosts/DOMAIN.TLD/conf/webalizer.conf files.


Please provide feedback on this article

Did this article help you solve your issue?
Yes
No
Partially
I do not know yet
 
Strongly Agree   Strongly Disagree
  9 8 7 6 5 4 3 2 1
The article is easy to understand
The article is accurate
Additional Comments:
*Please provide us with your email address in case we need to contact you.
*Please type the code you can see.
* - required fields