Problem with accounting insert into Oracle
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.
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.
On 08/13/2012 11:10 AM, Aurélien Lafranchise wrote:
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 ?
Do you have any .rpmnew or .rpmsave files under /etc/raddb? If so the server will try to load them. -- John Dennis <jdennis@redhat.com> Looking to carve out IT costs? www.redhat.com/carveoutcosts/
I have installed a new linux and it is a fresh install. I copied /etc/raddb from one box to another that's all ! The other difference is that I switch from Fedora 14 to CentOS 6.3. AL Le 13 août 2012 à 17:28, John Dennis a écrit :
On 08/13/2012 11:10 AM, Aurélien Lafranchise wrote:
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 ?
Do you have any .rpmnew or .rpmsave files under /etc/raddb? If so the server will try to load them.
-- John Dennis <jdennis@redhat.com>
Looking to carve out IT costs? www.redhat.com/carveoutcosts/
On 08/13/2012 11:41 AM, Aurélien Lafranchise wrote:
I have installed a new linux and it is a fresh install. I copied /etc/raddb from one box to another that's all !
What about your /etc/raddb/certs? Did you copy that too? If so you may have problems if the server cert does not match the new machine. I don't think that's would account for a SQL error, but you do need to be careful with just copying things around.
The other difference is that I switch from Fedora 14 to CentOS 6.3.
AL <http://mobiquithings.com/>
Le 13 août 2012 à 17:28, John Dennis a écrit :
On 08/13/2012 11:10 AM, Aurélien Lafranchise wrote:
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 ?
Do you have any .rpmnew or .rpmsave files under /etc/raddb? If so the server will try to load them.
-- John Dennis <jdennis@redhat.com <mailto:jdennis@redhat.com>>
Looking to carve out IT costs? www.redhat.com/carveoutcosts/ <http://www.redhat.com/carveoutcosts/>
-- John Dennis <jdennis@redhat.com> Looking to carve out IT costs? www.redhat.com/carveoutcosts/
/etc/raddb/certs was copied too! How to regenerate the certificates ? In general, how to install a copy of a radius server to another box ? For my SQL problem, any idea ? Thanks all AL Le 13 août 2012 à 18:35, John Dennis a écrit :
On 08/13/2012 11:41 AM, Aurélien Lafranchise wrote:
I have installed a new linux and it is a fresh install. I copied /etc/raddb from one box to another that's all !
What about your /etc/raddb/certs? Did you copy that too? If so you may have problems if the server cert does not match the new machine. I don't think that's would account for a SQL error, but you do need to be careful with just copying things around.
The other difference is that I switch from Fedora 14 to CentOS 6.3.
AL <http://mobiquithings.com/>
Le 13 août 2012 à 17:28, John Dennis a écrit :
On 08/13/2012 11:10 AM, Aurélien Lafranchise wrote:
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 ?
Do you have any .rpmnew or .rpmsave files under /etc/raddb? If so the server will try to load them.
-- John Dennis <jdennis@redhat.com <mailto:jdennis@redhat.com>>
Looking to carve out IT costs? www.redhat.com/carveoutcosts/ <http://www.redhat.com/carveoutcosts/>
-- John Dennis <jdennis@redhat.com>
Looking to carve out IT costs? www.redhat.com/carveoutcosts/
participants (3)
-
Alan DeKok -
Aurélien Lafranchise -
John Dennis