Vegard Svanberg wrote:
I'm using Freeradius with a Postgresql backend. Every two or three days, Freeradius dies. These are the last lines from the log file:
Tue Feb 24 21:15:31 2009 : Auth: Login OK: [XXXX] (from client YYYY port 3 cli ZZZZZZZZ) Tue Feb 24 21:16:34 2009 : Auth: Login OK: [XXXX] (from client YYYY port 3 cli ZZZZZZZZ) Tue Feb 24 21:16:48 2009 : Auth: Login OK: [XXXX] (from client YYYY port 4 cli ZZZZZZZZ) Tue Feb 24 21:18:32 2009 : Error: rlm_sql_postgresql: PostgreSQL Query failed Error: Tue Feb 24 21:18:32 2009 : Auth: Invalid user: [XXXX] (from client YYYY port 1509942 cli XX:XX:XX:XX:XX:XX)
Then nothing (it's gone and has to be started up again).
Ugh. That's not nice.
The problem is that this never happens if I run radiusd with -X, so I'm having trouble catching more info.
See doc/bugs in the latest "git" tree (stable) for instructions on leaving it running under "gdb". You will also likely need to build the server with debugging symbols, too.
Any clues? This is Freeradius 2.1.0 btw. I've just upgraded to 2.1.3 to see if the problem goes away.
I don't recall anything being changed in the postgres back-end. Alan DeKok.