(RADIATOR) Query in module SQL

[Julio Cesar Pinto]

Hugh,

We was tried to use many combination but always the value was
deprecated. Some possibilities that we used was the following:

AcctColumnDef ACCTSESSIONID,%{Acct-Session-Id}

AcctColumnDef ACCTSESSIONID,%{Acct-Session-Id},literal

AcctColumnDef ACCTSESSIONID,%{Acct-Session-Id},formatted

AcctColumnDef ACCTSESSIONID,%{Acct-Session-Id},any

Finally we solve the problem without use AcctColumnDef and just use
AcctSQLStatement, but we have with the doubt if we can use substr
function in the AcctColumnDef

I appreciate your information.

Greetings,

JC.


-----Original Message-----
From: Hugh Irvine [mailto:hugh at open.com.au] 
Sent: Wednesday, May 17, 2006 2:02 AM
To: Julio Cesar Pinto
Cc: radiator at open.com.au
Subject: Re: (RADIATOR) Query in module SQL


Hello Julio -

You can use the "literal" type in your AcctColumnDef.

See section 5.29.14 in the Radiator 3.14 reference manual ("doc/ 
ref.html").

regards

Hugh


On 17 May 2006, at 07:18, Julio Cesar Pinto wrote:

> Hi,
>
> In order to cut the long value that some attributes come from the NAS,
> we use substr for example in SessionDatabase we have the following
> query:
>
> AddQuery insert into RADONLINE (USERNAME, NAS_IP_ADDRESS, NAS_PORT,
> ACCT_SESSION_ID, TIMESTAMP, FRAMED_IP_ADDRESS, NAS_PORT_TYPE,
> SERVICE_TYPE, CALLING_STATION_ID, CALLED_STATION_ID, IFX_VISP_ID,
> IFX_COUNTRY_ID) values (substr('%u',1,255),'%1',0%2,%3,to_date('%d % 
> m %Y
> %H:%M:%S', 'DD MM YYYY
> HH24:MI:SS'),'%{Framed-IP-Address}','%{NAS-Port-Type}','%{Service- 
> Type}'
> ,substr('%{Calling-Station-Id}',1,64),'%{Called-Station-Id}','%{Ifx- 
> Visp
> -Id}','%{Ifx-Country-Id}')
>
> substr('%u',1,255)
> substr('%{Calling-Station-Id}',1,64)
>
> This work perfect, but now I would like to use the same in AuthBy SQL
> but I don't know how to include it in the clause.
>
> Please let me know if we can use it.
>
> Thanks in advance.
>
> Greetings,
>
> JC.
>
>
> --
> 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.