(RADIATOR) <Log SQL> Error

[Hugh Irvine]

Hello Julio -

You can use any SQL statement that is supported by your database.

For accounting you would use the AcctSQLStatement parameter.

See section 6.29.16 in the Radiator 3.11 reference manual 
("doc/ref.html").

regards

Hugh


On 24 Dec 2004, at 01:52, Julio Cesar Pinto wrote:

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

NB:

Have you read the reference manual ("doc/ref.html")?
Have you searched the mailing list archive 
(www.open.com.au/archives/radiator)?
Have you had a quick look on Google (www.google.com)?
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.