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.

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Reply via email to