On Thursday 03 July 2003 11:07 am, Kevin Fenzi wrote: > I am seeing a problem with a new freeradius 0.8.1 install using > postgresql as the backend. [...] > Nothing to do. Sleeping until we see a request. [...]
[reformatting for readability] > rlm_sql_postgresql: query: UPDATE radacct SET AcctStopTime = '2003-07-02 15:33:30', AcctSessionTime = '', AcctInputOctets = CASE WHEN '' = '' THEN 0 ELSE '' END, AcctOutputOctets = CASE WHEN '' = '' THEN 0 ELSE '' END, AcctTerminateCause = '', AcctStopDelay = '0', FramedIPAd dress = '', ConnectInfo_stop = '' WHERE AcctSessionId = '1808' AND UserName = 'root' AND NASIPAddress = '127.0.0.1' AND AcctStopTime IS NU LL The first thing that caught my attention were the "case when '' = ''..." elements, which I suspect indicates something isn't being expanded properly, but when I went through "reformatting" it, two lines jumped out immediately: FramedIPAd dress = '', AND AcctStopTime IS NU LL I only inserted CR's and spaces to line things up -- those embedded spaces were in your original message -- they COULD be an artifact of your cut-n-paste action to create the message in the first place, but if not, well, they may point to the problem :) -- Yet another Blog: http://osnut.homelinux.net
pgp00000.pgp
Description: signature