(RADIATOR) <Log SQL> Error

[Hugh Irvine]

Hello Roel -

Have you tried the Oracle "truncate" command?

Otherwise we could consider adding a Truncate parameter to Radiator.

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?

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
-
CATool: Private Certificate Authority for Unix and Unix-like systems.

--
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.