Freeradius - MySQL Update problem
Hello, Let me start off by saying I am new to this list and not very accomplished in freeradius administration. I am running a freeradius-1.1.0-19.6 setup to gather VoIP accounting information from a Cisco AS5350 router and insert this information into a mysql-5.0.18-16 database. The OS is SuSE Linux 10.1. I am having trouble populating the MySQL database with a certain attribute 'h323-remote-address'. A tail of the radius logs shows me that this attribute is being received by radius. It however does not appear in the database. I have tried altering the mysql statements in sql.conf to insert the value of this attribute in a field that was previously being populated with something else - to ensure that the sql statement is correct - (of the same type - i.e. varchar(32)) but that field stops being populated after the changes. I have also tried it with a field that was previously not being populated, with no success. The value is supposed to be an IP address. Could someone please help me? Thanks and regards, Timothy
On Wed 01 Aug 2007, musoket@mtn.co.ug wrote:
Hello,
Let me start off by saying I am new to this list and not very accomplished in freeradius administration.
I am running a freeradius-1.1.0-19.6 setup to gather VoIP accounting information from a Cisco AS5350 router and insert this information into a mysql-5.0.18-16 database. The OS is SuSE Linux 10.1.
I am having trouble populating the MySQL database with a certain attribute 'h323-remote-address'.
Add a field to the radacct table, and add modify the sql query to add the attribute you wish into the field you added. It will just work.. -- Peter Nixon http://peternixon.net/
Hi musoket, Wednesday, August 1, 2007, 3:17:15 PM, you wrote:
I am having trouble populating the MySQL database with a certain attribute h323-remote-address. A tail of the radius logs shows me that this attribute is being received by radius. It however does not
How does your INSERT look like? AFAIK, in logs you get something like h323-remote-address = "h323-remote-address=re.mo.te.ip" You should use the %{h323-remote-address} variable Regards, Claudiu Filip @: claudiu@globtel.ro Http://www.globtel.ro T:+40344880100 F:+40344880113
participants (3)
-
Claudiu Filip -
musoket@mtn.co.ug -
Peter Nixon