Acounting problem with SQL and detail files

[Arran Cudbard-Bell]

On 11 Feb 2014, at 14:47, Aurélien Lafranchise <aurelien.lafranchise at mobiquithings.com> wrote:

> Hi All,
> 
> We noticed an issue on our FreeRADIUS Version 2.1.12 on a CentOS 6.3 kernel 2.6.32-279.2.1.el6.x86_64.
> 
> Our FreeRADIUS is connected to a database for the accounting queries. It is also configured to save the same accounting information in the detail files.
> 
> We had a database connection problem (Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0). We were surprised that during this problem the accounting information that cannot be passed to the database was not written in the detail files.

You were using something like

redundant {
	sql
	detail
}

Right?

What error code was rlm_sql returning when it had no handles left?

You may want to consider using v3.0.x, the connection pool code, and reconnection logic is a significant improvement over the module specific code in v2.x.x.

-Arran

Arran Cudbard-Bell <a.cudbardb at freeradius.org>
FreeRADIUS Development Team

FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 881 bytes
Desc: Message signed with OpenPGP using GPGMail
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20140211/38a6c1eb/attachment-0001.pgp>