Problem with accounting insert into Oracle

Aurélien Lafranchise aurelien.lafranchise at
Mon Aug 13 14:47:38 CEST 2012

Hi Alan,

Thanks for the answer.

I need all these data so it is not a clean problem. But I will disable sqltrace when everything will be ok.

Could you be more precise on where to increase the 2K limit ?


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