Sorry,
> > > It there exists a database maintainance procedure for the
underlyng
> > > policyd database? Thanks.
> > >
> > Run cbpadmin --cleanup about once every day.
> >
>
> Cool! Thanks!
>
But,
# /usr/local/bin/cbpadmin --cleanup
Policyd Admin Tool (ClueBringer) v2.1.0a - Copyright (c) 2007-2008
LinuxRulz
=> Quotas: enabled
Module: Core
-> running cleanup...
[CORE] Failed to remove old session tracking records:
cbp::dblayer::DBDo(134): Error executing command '
DELETE FROM
session_tracking
WHERE
UnixTimestamp < ?
': Unknown column 'UnixTimestamp' in 'where clause'
Use of uninitialized value in string ne at
/usr/local/lib/policyd-2.0/cbp/modules/Core.pm line 58.
Use of uninitialized value in concatenation (.) or string at
/usr/local/lib/policyd-2.0/cbp/modules/Core.pm line 58.
[CORE] Removed records from session tracking table
Module: Quotas Plugin
-> running cleanup...
[QUOTAS] Removed 0
Maybe I miss something in upgrading policyd database schema.. :-(
Basically, I started with a working copy of cluebringer-2.0.5. The I
have installed cluebringer-2.0.6 (I have added the table "accounting" to
the schema installed together with cluebringer-2.0.5). Finally, I have
installed the Rev 413 so I have further updated policyd database schema
as reported in UPGRADING file included in trunk.
What I have to refer to get the apprpriate schema to use?
Thanks,
rocsca
_______________________________________________
Users mailing list
[email protected]
http://lists.policyd.org/mailman/listinfo/users