Hello Manda;
Thank you very much for your help... Now i am using postgrep and I can send the CDR to the DB. But now I have another question ... :-) how can I get tha Callduration ?? I know thar I have to use disconect and connectime , but i do not know how . Can you pls help me ?
Thanks Fabio
----- Original Message ----- From: "Manda Costin" <[EMAIL PROTECTED]>
To: <freeradius-users@lists.freeradius.org>; <[EMAIL PROTECTED]>
Sent: Thursday, January 27, 2005 8:47 AM
Subject: Re: Radius Cisco h323 Voip
Pe 26 Jan 2005, la 23:16, =?iso-8859-1?Q?Fabio_Vira=E7=E3o?= <[EMAIL PROTECTED]> a scris:
Hi ;
How can I send all these information to a Mysql Database ??
If you look in the src/billing directory in the freeradius source packet you will see how to do billing with postgres. Also the reasons why mysql does NOT work well with Cisco. However, you can try MySQL 5.0 which is still in testing AFAIK, and see how it goes.
I highly recomend postgreSQL, though, and to create a good accounting/billing system for Cisco you need to combine the info in the src/billing directory with the one in src/modules/rlm_sql/drivers/rlm_sql_postgresql. At least this is how I did it.
Also, don't forget to set with_cisco_vsa_hack=yes in the radiusd.conf file.
Does anyone have any ideia that can help me ??
Sorry Joe
Thanks Fabio
Mon Aug 30 14:38:18 2004 NAS-IP-Address =3D 192.168.115.4 Cisco-NAS-Port =3D "CAS 1:0" NAS-Port-Type =3D Async User-Name =3D "351289767299" Called-Station-Id =3D "17863045678" Calling-Station-Id =3D "351212362299" Acct-Status-Type =3D Stop Service-Type =3D Login-User h323-gw-id =3D "h323-gw-id=3DTest0909" Cisco-AVPair =3D "h323-incoming-conf-id=3DD397A0 F9CA11D8 = 9519C3E7=20 31564DA6" h323-call-origin =3D "h323-call-origin=3Doriginate" h323-call-type =3D "h323-call-type=3DTelephony" h323-setup-time =3D "h323-setup-time=3D14:45:00.680 GMT Mon Aug = 30 2004" h323-connect-time =3D "h323-connect-time=3D14:45:23.482 GMT Mon = Aug 30=20 2004" h323-disconnect-time =3D "h323-disconnect-time=3D14:46:06.352 = GMT Mon=20 Aug 30 2004" h323-disconnect-cause =3D "h323-disconnect-cause=3D10" h323-voice-quality =3D "h323-voice-quality=3D0" h323-conf-id =3D "h323-conf-id=3DD397A0 F9CA11D8 9519C3E7 = 31564DA6" Acct-Session-Id =3D "0000EDD9"
----
Home, no matter how far... http://www.home.ro
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
