Accounting redundancy problem

[Ivan Kalik]

> 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