(RADIATOR) format input

[Hugh Irvine]

Hello Budi -

I am not certain of the exact SQL syntax for your database, but you 
should use something like this:

          AcctColumnDef ctime, 
substring_index(%{cisco-h323-connect-time}, '=', -1), literal

See the examples in section 3.28.16 in the Radiator 3.7.1 reference 
manual ("doc/ref.html").

regards

Hugh




On Wednesday, Oct 8, 2003, at 16:00 Australia/Melbourne, budi wibowo 
wrote:

> i'm runnign radiator 3.6 and use mysql as database
> server
> here's is part of my radius.cfg
>
> <Realm as53-sg>
>         <AuthBy SQL>
>           DBSource      dbi:mysql:accounting
>           DBUsername xxx
>           DBAuth xxxx
>         AccountingTable as5300
>          AcctColumnDef
> ctime,%{cisco-h323-connect-time},formatted,substring_index(%s,
> '=', -1)
>
> ctime is connect time of my call
> in cisco format it looks like
>
> cisco-h323-connect-time =
> "h323-disconnect-time=*15:36:24.733 UTC Thu Mar 4
> 2003"
>
> how can i only input 15:36:24 and Mar 4 2003 to mysql
> as separate field
> how can i do that
>
>
> rgds
>
> budi
>
>
>
>
> __________________________________
> Do you Yahoo!?
> The New Yahoo! Shopping - with improved product search
> http://shopping.yahoo.com
> ===
> 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?

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

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