(RADIATOR) <Log SQL> Error

[R.H.Hoek]

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.