Problem with accounting insert into Oracle

[Aurélien Lafranchise]

Ok, it is what I thought. 

It is strange: it was working well on Freeradius 2.1.10-1 and not on my fresh install 2.1.12-3. Any idea ?

AL

Aurélien Lafranchise wrote:
> Could you be more precise on where to increase the 2K limit ?

 All over the place in rlm_sql.c and sql.c.

 Alan DeKok.

Le 13 août 2012 à 14:47, Aurélien Lafranchise a écrit :

> 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 ?
> 
> Cheers,
> AL
> 
> 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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20120813/496565f5/attachment.html>