Annexes
CalledInStart=0
LicenseCode=0
AddrAsFromNas=0 FeeFirstDuration=0 FeeFirstAs=0
Annexe 3 : Quelques commandes effectuées par
Radius dans la BD Mysql (voir Fichier WinRadius.backup)
> INSERT INTO tbUsers
(username,password,groups,addr,cash,expiry,others,method,billtype)
VALUES ('kwate','kwate','','192.168.10.55',0,'2011/12/30','','Based on
Time','Postpaid')
> INSERT INTO tbUsers
(username,password,groups,addr,cash,expiry,others,method,billtype)
VALUES ('saedouala','saedouala','1','192.168.85.11',0,'','','Based on
Time','Postpaid')
> INSERT INTO tbVoIP
(username,called_station_id,calling_station_id,acct_status_type,acct_delay_time,acct
_session_id,acct_session_time,nas_ip_address,nas_port,h323_conf_id,h323_call_orig
in,h323_call_type,h323_remote_address,h323_connect_time,h323_disconnect_time,h
323_disconnect_cause,h323_voice_quality) VALUES
('4003','4004','4003','stop','18','h323-conf-id=B48402AA BEAC11E0 8002EB94
D449E749','5','192.168.85.253','','B48402AA BEAC11E0 8002EB94
D449E749','answer','Telephony','(null)','*15:16:25.911 UTC Fri Aug 5
2011','*15:16:30.723 UTC Fri Aug 5 2011','10','0')
> INSERT INTO tbUsers
(username,password,groups,addr,cash,expiry,others,method,billtype)
VALUES ('RadUser','RadUserpass','','',0,'','','Based on
Time','Postpaid')
|
|
