Bug 214483 - www/webalizer Unable to purge old records in webalizer dns_cache.db
Summary: www/webalizer Unable to purge old records in webalizer dns_cache.db
Status: Closed FIXED
Alias: None
Product: Ports & Packages
Classification: Unclassified
Component: Individual Port(s) (show other bugs)
Version: Latest
Hardware: Any Any
: --- Affects Many People
Assignee: Dirk Meyer
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-11-13 17:23 UTC by Alexander Sheiko
Modified: 2016-11-14 05:33 UTC (History)
0 users

See Also:
dinoex: maintainer-feedback+

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Alexander Sheiko 2016-11-13 17:23:51 UTC 
Unable to purge old records in webalizer dns_cache.db

wcmgr -v -p /var/db/webalizer/dns_cache.db
Purging records over 7 days from '/var/db/webalizer/dns_cache.db'
Error: Unable to lock cache file: Bad file descriptor

file /var/db/webalizer/dns_cache.db
/var/db/webalizer/dns_cache.db: Berkeley DB 1.85 (Hash, version 2, native byte-order)

fuser /var/db/webalizer/dns_cache.db
/var/db/webalizer/dns_cache.db:

wcmgr -v  /var/db/webalizer/dns_cache.db
Webalizer DNS Cache file listing generated Sun Nov 13 19:17:18 2016

IP Address         TTL Age    Hostname
--------------- ------------- -----------------------------------------------
93.124.35.38    [1744d:15h:57m] host-93-124-35-38.dsl.sura.ru
89.169.55.254   [1740d:16h:08m]
95.111.164.208  [1727d:15h:53m]
...
59.91.149.103   [10d:15h:32m]
77.45.205.192   [03d:22h:05m] 192.205.c10008-a53.dsl-dynamic.vsi.ru
202.46.57.178   [02d:12h:31m]
-----------------------------------------------------------------------------
Filename: /var/db/webalizer/dns_cache.db  (1456576 records)

cat /var/db/ports/www_webalizer/options
# This file is auto-generated by 'make config'.
# Options for webalizer-2.23.8_4
_OPTIONS_READ=webalizer-2.23.8_4
_FILE_COMPLETE_OPTIONS_LIST=GEOIP GEODB BDB1 BDB WEBALIZER_CONV  FULL_CGI_REFS CLICKABLE_REFERER LARGE_URL  DOCS EXAMPLES
OPTIONS_FILE_SET+=GEOIP
OPTIONS_FILE_UNSET+=GEODB
OPTIONS_FILE_SET+=BDB1
OPTIONS_FILE_UNSET+=BDB
OPTIONS_FILE_UNSET+=WEBALIZER_CONV
OPTIONS_FILE_UNSET+=FULL_CGI_REFS
OPTIONS_FILE_SET+=CLICKABLE_REFERER
OPTIONS_FILE_UNSET+=LARGE_URL
OPTIONS_FILE_SET+=DOCS
OPTIONS_FILE_SET+=EXAMPLES
Comment 1 commit-hook freebsd_committer freebsd_triage 2016-11-14 05:32:06 UTC 
A commit references this bug:

Author: dinoex
Date: Mon Nov 14 05:31:26 UTC 2016
New revision: 426083
URL: https://svnweb.freebsd.org/changeset/ports/426083

Log:
  - fix purge with option BDB1
  PR:		214483

Changes:
  head/www/webalizer/Makefile
  head/www/webalizer/files/patch-wcmgr.c
Comment 2 Dirk Meyer freebsd_committer freebsd_triage 2016-11-14 05:33:05 UTC 
Thanks for the good report.