(RADIATOR) newbiw question: acctcolumndef

[budi wibowo]

hi .. i'm new to this mailing list 
i have a problem with accounting to mysql 
i have some reference and i have this on my radius.cfg
<Realm dbku>
   AcctLogFileName              %L/detail
   <AuthBy SQL>
        DBSource                dbi:mysql:billing
        DBUsername              xxx
        DBAuth                  xxxx

        AuthSelect
        AccountingTable accouting
        AcctColumnDef  
H323SETUPTIME,cisco-h323-setup-time
        AcctColumnDef   H323GWID,cisco-h323-gw-id
        AcctColumnDef   H323CONFID,cisco-h323-conf-id
        AcctColumnDef  
H323CALLORIGIN,cisco-h323-call-origin
        AcctColumnDef  
H323CALLTYPE,cisco-h323-call-type
        AcctColumnDef  
ACCTSESSIONTIME,Acct-Session-Time,integer
        AcctColumnDef  
H323CONNECTTIME,cisco-h323-connect-time,integer-date
        AcctColumnDef  
H323DISCONNETTIME,cisco-h323-disconnect-time
        AcctColumnDef  
H323DISCONNECTCAUSE,cisco-h323-disconnect-cause
        AcctColumnDef  
H323REMOTEADDRESS,cisco-h323-remote-address
       AcctColumnDef  
H323REMOTEADDRESS,cisco-h323-remote-address
        AcctColumnDef   USERNAME,User-Name
        AcctColumnDef  
ACCTSTATUSTYPE,Acct-Status-Type
        AcctColumnDef  
CALLEDSTATIONID,Called-Station-Id
        AcctColumnDef   NASIPADDRESS,NAS-IP-Address

        AcctFailedLogFileName  %L/missedaccounting
    </AuthBy>

i also have created the table, using trace 4 i get
something like this 
Thu Jun  5 04:30:11 2003: DEBUG: do query is: insert
into accouting (NASIPADDRES
S,H323CONFID,USERNAME,ACCTSESSIONTIME,H323SETUPTIME,H323CALLORIGIN,H323GWID,H323
CONNECTTIME,H323DISCONNETTIME,ACCTSTATUSTYPE,CALLEDSTATIONID,H323CALLTYPE,H323RE
MOTEADDRESS,H323DISCONNECTCAUSE) values
('1.1.1.1','h323-conf-id=6000001
9 46F05A14 0E18000C
30A85EFD','Irjavgw at dbku',0,'h323-setup-time=*23:50:22.591
UT
C Tue Mar 2
1993','h323-call-origin=answer','h323-gw-id=ipipgw.','h323-connect-t
ime=*23:50:23.613 UTC Tue Mar 2
1993','h323-disconnect-time=*23:50:23.613 UTC Tu
e Mar 2
1993','Stop','39935048505','h323-call-type=VoIP','h323-remote-address
=66.68.133.70','h323-disconnect-cause=10')

in this example i have 'h323-disconnect-cause=10' is
it possible only '10' inserted to mysql?
if it is possible how'w the syntax at acctcolumndef?


rgds

budi




__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.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.