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

Reply via email to