Hello! On Thu, 26 Sep 2002, Paul Khavkine wrote:
> > Hi. > > Anyone use rlm_sql_postgres for accounting ? Sure. > I seem to have a problem with the queries, i get errors when trying to > insert 0 in acctstarttime or in brief: change sql.conf. You'd search thru this maillist archive for ready recipe (Igor Khen had posted HOWTO, IIRC). Personally me had made modifications in sql.conf and sql_modules to insert NULL instead of 0. That's the way for PG. BTW, inserting 0 as acctstoptime is MySQLism, really, and it is goes against the nature of SQL. Martin Gruber in his gave good clue why NULL value was implemeted in SQL at all. Naturally, when start accounting, acctstoptime has no meaningful value, right? This is what NULL value in SQL is for. > acctstoptime, the DB backend complains that 0 is not a valid timestamp > representation. -- WBR, Yury Bokhoncovich, Senior System Administrator, NOC of F1 Group. Phone: +7 (3832) 106228, ext.140, E-mail: [EMAIL PROTECTED] Unix is like a wigwam -- no Gates, no Windows, and an Apache inside. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html