(RADIATOR) format input

[budi wibowo]

i think mysql can recognize format 15:36:24 as time 
so using substring_index or substring may be can help?


rgds

budi

--- Hugh Irvine <hugh at open.com.au> wrote:
> 
> 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.


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