> 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. > 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;
-N
smime.p7s
Description: S/MIME Cryptographic Signature
_______________________________________________ Users mailing list [email protected] http://lists.policyd.org/mailman/listinfo/users
