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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' 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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
