Freeradius dies with Postgresql error

[Alan DeKok]

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.