ports/152365: Periodic script resets file ownership to root on assp db

[Marco Walraven]

>Number:         152365
>Category:       ports
>Synopsis:       Periodic script resets file ownership to root on assp db
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          sw-bug
>Submitter-Id:   current-users
>Arrival-Date:   Thu Nov 18 15:00:17 UTC 2010
>Closed-Date:
>Last-Modified:
>Originator:     Marco Walraven
>Release:        8.1-RELEASE
>Organization:
Terantula
>Environment:
FreeBSD titanium.fearlabs.com 8.1-RELEASE FreeBSD 8.1-RELEASE #2: Sat Jul 24 16:43:37 CEST 2010     root at chassis:/opt/obj/usr/cvsup/8-stable/src/sys/CHASSIS  amd64

>Description:
/usr/local/etc/periodic/daily/510.assp does ASSP's nightly housekeeping.
The rebuildspamdb.pl script it calls generates new db files however if you
are running your assp as user assp these will be set to root and generate
errors during normal operation of ASSP.

Nov-18-10 13:07:00 Cleaning up penalty records ...;
Nov-18-10 13:07:00 Error: orderedtie is unable to write to /var/db/assp/pb/pbdb.black.db - Permission denied;
Nov-18-10 13:07:00 Error: orderedtie is unable to write to /var/db/assp/pb/pbdb.white.db - Permission denied;
Nov-18-10 13:07:00 PenaltyBox: cleaning WhiteBox finished; before=3, deleted=0;
Nov-18-10 13:07:00 Saving penalty records;
Nov-18-10 13:07:00 Error: orderedtie is unable to write to /var/db/assp/pb/pbdb.black.db - Permission denied;
Nov-18-10 13:07:00 Error: orderedtie is unable to write to /var/db/assp/pb/pbdb.white.db - Permission denied;

>How-To-Repeat:
Standard install of ASSP from the ports tree.
cd /var/db/assp/pb
chown assp:assp *
ls -als 

4 -rw-r--r--   1 assp  assp   112 Nov 18 14:46 pbdb.white.db
4 -rw-r--r--   1 assp  assp   112 Nov 18 14:34 pbdb.white.db.bak
4 -rw-r--r--   1 assp  assp   112 Nov 18 13:07 pbdb.white.db.tmp


/usr/local/etc/periodic/daily/510.assp
ls -als 

4 -rw-r--r--   1 root  assp   112 Nov 18 14:47 pbdb.white.db
4 -rw-r--r--   1 assp  assp   112 Nov 18 14:46 pbdb.white.db.bak
4 -rw-r--r--   1 assp  assp   112 Nov 18 13:07 pbdb.white.db.tmp

>Fix:
Added a chown assp:assp *.db to the /usr/local/etc/periodic/daily/510.assp
periodic script. 

>Release-Note:
>Audit-Trail:
>Unformatted: