(RADIATOR) <Log SQL> Error

[Mike McCauley]

Hello Roel -

On Monday 25 October 2004 19:05, R.H.Hoek wrote:
> 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!

We have now added a MaxMessageLength parameter to LogSQL and LogSYSLOG. The 
new version is in the 3.10 patches now, and will be included in the next 
release.

Cheers.



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

-- 
Mike McCauley                               mikem at open.com.au
Open System Consultants Pty. Ltd            Unix, Perl, Motif, C++, WWW
9 Bulbul Place Currumbin Waters QLD 4223 Australia   http://www.open.com.au
Phone +61 7 5598-7474                       Fax   +61 7 5598-7070

Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, 
Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS, 
TTLS, PEAP etc on Unix, Windows, MacOS etc.

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