(RADIATOR) newbiw question: acctcolumndef

[Mike McCauley]

Hello Budi,

Can you please let me know the name of the Radiator licensee you are 
representing?

Cheers.

On Thu, 5 Jun 2003 02:47 pm, budi wibowo wrote:
> 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,H
>323RE 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.

-- 
Mike McCauley                               mikem at open.com.au
Open System Consultants Pty. Ltd            Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia   http://www.open.com.au
Phone +61 3 9598-0985                       Fax   +61 3 9598-0955

Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, 
Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS, 
TTLS, PEAP etc on Unix, Windows, MacOS etc.

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