Infact, > > # /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. > > > Look at the last item in the UPGRADING file ... > > ALTER TABLE tracking CHANGE > Timestamp UnixTimestamp BIGINT NOT NULL; > > That renames the column from Timestamp to UnixTimestamp, but it looks > wrong. Try ... > > > ALTER TABLE session_tracking CHANGE > Timestamp UnixTimestamp BIGINT NOT NULL; >
I just noticed this only after my ltest post.. sorry.. ;-) rocsca _______________________________________________ Users mailing list [email protected] http://lists.policyd.org/mailman/listinfo/users
