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
