Problem with accounting insert into Oracle

Alan DeKok aland at
Mon Aug 13 14:23:23 CEST 2012

Aurélien Lafranchise wrote:
> I have the same error for every request in dialup.conf (STOP, START, UPDATE).
> The database connection is working well but I have:
> [sql] Couldn't insert SQL accounting STOP record - ORA-01756: quoted string not properly terminated 
> with sqltrace on you can see the mistake at the end. The request seems to be truncated:

  Yes.  You can't put infinie amounts of data into the SQL query.  The
limit is ~2K or so.

> Any idea ? Is there a global option for the maximum number of characters for a request ?

  It's limited in the SQL module.

  You've edited the configuration to log tons of data.  This generally
isn't useful, or necessary.  Fix that, or edit the SQL module to allow
more than 2K of data in the expansion.

  Alan DeKok.

More information about the Freeradius-Users mailing list