(RADIATOR) Query in module SQL

[Hugh Irvine]

Hello Julio -

You would do something like this:

	AcctColumnDef ACCTSESSIONID, substr(%{Acct-Session-Id},1,64), literal

or as you mention you can also use an AcctSQLStatement.

regards

Hugh


On 18 May 2006, at 10:33, Julio Cesar Pinto wrote:

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


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.