Re: Freeradius dies with Postgresql error

2009-02-25 Thread 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: [] (from client  port 3 
> cli )
> Tue Feb 24 21:16:34 2009 : Auth: Login OK: [] (from client  port 3 
> cli )
> Tue Feb 24 21:16:48 2009 : Auth: Login OK: [] (from client  port 4 
> cli )
> 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: [] (from client  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.

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Freeradius dies with Postgresql error

2009-02-24 Thread Vegard Svanberg
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: [] (from client  port 3 cli 
)
Tue Feb 24 21:16:34 2009 : Auth: Login OK: [] (from client  port 3 cli 
)
Tue Feb 24 21:16:48 2009 : Auth: Login OK: [] (from client  port 4 cli 
)
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: [] (from client  port 
1509942 cli XX:XX:XX:XX:XX:XX)

Then nothing (it's gone and has to be started up again).

The problem is that this never happens if I run radiusd with -X, so I'm
having trouble catching more info. 

Any clues? This is Freeradius 2.1.0 btw. I've just upgraded to 2.1.3 to
see if the problem goes away.

-- 
Vegard Svanberg  [*tak...@irc (EFnet)]

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html