(RADIATOR) <Log SQL> Error

[Julio Cesar Pinto]

Hi,

I was reviewing the history of the list, in order to find a solution at
one problem that we have. The situation is very similar that the email
posted below, but with the clause AuthBy SQL. We have into accounting
table the field username varchar(255) in some cases we have registries
with more characters that 255, really we just need the first 255 (could
be is strange to somebody, to us is normal ;) ). So, our DBA suggest me
use the following string.

substr('username',1,255)

Can I use this?

I appreciate any comment in the matter.

Thanks a lot,

JC.




-----Original Message-----
From: owner-radiator at open.com.au [mailto:owner-radiator at open.com.au] On
Behalf Of Mike McCauley
Sent: Monday, October 25, 2004 4:20 AM
To: R.H.Hoek
Cc: Hugh Irvine; radiator at open.com.au; Schoot,W. (ITBE)
Subject: Re: (RADIATOR) <Log SQL> Error

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.

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