> I'm running Freeradius Version 2.0.4 with sql_postgres and sql_log > modules. > > Through the redundant module I can use a postgres database (on a remote > server) as a primary destination of my accounting messages and a sql_relay > file as an alternative in case of my database failure. > > > > Almost, everything works fine, meaning that if I stop the postgres process > on my remote server, freeradius try to send accounting messages to it and > as it receive messages from the server telling that the connection is > refused, freeradius logs accounting sql request into the sql_relay file. > > > > Now here's my problem: If I shutdown the server which host the postgres > database, freeradius try to send request to it and as there's no answer > from the server Freeradius doesn't pass through the SQL request through > the sql_log module. It keeps on waiting for an answer infinitely. > > > > When I launch freeradius whith the "freeradius -X" command, I can see the > following message: Error: rlm_sql (sql_TMS): Failed to connect DB handle > #0 > > > > It's very annoying because my backup solution doesn't handle the database > server unavailability! > > > > NB: I tried to use the "connect_failure_retry_delay" directive within the > rlm_sql_postgres module but this has no effect!
Have a look at buffered-sql virtual server. Ivan Kalik Kalik Informatika ISP - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html