(RADIATOR) <Log SQL> Error

[R.H.Hoek]

Hugh Irvine wrote:
> 
> Hello Roel -
> 
> Have you tried the Oracle "truncate" command?

With the 'truncate' command you can drop the table content
and 'trunc(n,m)' truncate only numbers

So....

> 
> Otherwise we could consider adding a Truncate parameter to Radiator.

That would be fine!

> 
> regards
> 
> Hugh
> 
> 
> On 23 Oct 2004, at 01:05, R.H.Hoek wrote:
> 
>> Dear madam/sir,
>>
>> We need help.
>> We got an error message when we use <log SQL> (Radiator V3.9 and 3.10):
>>
>> DBD::Oracle::db do failed: ORA-01704: string literal too long (DBD 
>> ERROR: OCIStmtExecute) at 
>> /usr/lib/perl5/site_perl/5.8.0/Radius/SqlDb.pm line 225.
>>
>> De config looks like:
>>
>> <Log SQL>
>>
>>  DBSource        dbi:Oracle:tent
>>  DBUsername      username
>>  DBAuth          geheim
>>
>>  Table wouter.radlog
>>
>>  Trace 4
>>
>>  Identifier TenTSQLlog
>>
>>  LogQuery insert into %3 (TIME_STAMP, PRIORITY, MESSAGE) values (%t, 
>> %0, %2)
>>
>> </Log>
>>
>> The 'messages' are quite long when trace is set to 4 with the use of 
>> EAP-TTLS (>4000 characters)
>>
>> Oracle has a limitation of 4000 Character
>> For our purpose messages with a length of 1000-2000 are enough
>>
>> Is it possible to set the maximum message length?
>>
>> The insert query:
>> LogQuery insert into %3 (TIME_STAMP, PRIORITY, MESSAGE) values (%t, 
>> %0, substr(%2,1,100))
>> does NOT work
>>
>>
>> -- 
>>
>> Groeten,
>>
>> Roel H.Hoek, SeniorNetworkmanager
>> Dienst Informatietechnologie, Bibliotheek en Educatie (ITBE)
>> Universiteit Twente,  Postbus 217,  7500 AE  Enschede
>> kmr SP 422, telefoon: 053 - 489 4598,  fax: 053 - 489 2383
>> e-mail: R.H.Hoek at UTwente.NL http://www.utwente.nl/itbe
>>
>> -- 
>> Archive at http://www.open.com.au/archives/radiator/
>> Announcements on radiator-announce at open.com.au
>> To unsubscribe, email 'majordomo at open.com.au' with
>> 'unsubscribe radiator' in the body of the message.
>>
>>
> 
> NB: have you included a copy of your configuration file (no secrets),
> together with a trace 4 debug showing what is happening?
> 


-- 

Groeten,

Roel H.Hoek, SeniorNetworkmanager
Dienst Informatietechnologie, Bibliotheek en Educatie (ITBE)
Universiteit Twente,  Postbus 217,  7500 AE  Enschede
kmr SP 422, telefoon: 053 - 489 4598,  fax: 053 - 489 2383
e-mail: R.H.Hoek at UTwente.NL http://www.utwente.nl/itbe

--
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.