Freeradius dies with Postgresql error
aland at deployingradius.com
Wed Feb 25 15:54:37 CET 2009
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.
More information about the Freeradius-Users