On Wed, 6 Aug 2003, Truong Manh Cuong wrote: > Hi all, > I use PostgresSQL and I have problem with database: > freeradius dies when user connects to server so I must change > radacct::AcctStart/StopTime : datetime -> TIMESTAMP with time zone > > in Dialup_admin::user_finger.php3 > SELECT ... WHERE AcctStopTime = '0' > > And error report: query-error. AcctStopTime is NULL in database, not = 0. I > don't know how to correct it. > So at page online user page, I can't show online user with > SELECT ... WHERE AcctStopTime = '0'
Fixed in the user finger and user admin pages. Please do a cvs update on dialupadmin and see if everything is working now. Thanks > > Please help me. > Thanks and Regards > > ******************************************************* > Truong M?nh Cu?ng > System Engineer - SE > Research & Development Division - RDD > Mobile: 84-90-8392986 > Work Phone: 84-08-9321001 - 664 > Email [EMAIL PROTECTED] > EIS Service, Inc. > http://www.globaleis.com > Saigon Software Park, 2nd Floor. > 123 Truong Dinh St., Dist. 3, HCM City, Vietnam. > Tel 84-8-932 1001 Fax 84-8-932 1002 > ******************************************************* > > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > -- Kostas Kalevras Network Operations Center [EMAIL PROTECTED] National Technical University of Athens, Greece Work Phone: +30 210 7721861 'Go back to the shadow' Gandalf - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html