RE: Freeradius - MySQL Update problem
Hi Claudiu, Thanks for your response. Thu, 2 Aug 2007 03:10:24 +0300, you wrote:
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
That is in fact the variable that I am using in my insert and update statements but it still doesn't work. See below: accounting_update_query_alt = "INSERT into ${acct_table1} (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctSt artTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, ServiceType,FramedProtocol, FramedIPAddress, AcctStartDelay) values('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{Cisco-NAS-Port}', '%{NAS-Port-Type}', DATE_SUB('%S',INTERVAL (%{Acct-Session-Time:-0} + %{Acct-Delay-Time:-0}) SECOND), '%{Acct-Session-Time}', '%{Acct-Authentic}','', '%{Acct-Input-Octets}', '%{Acct-Output-Octets}', '%{Called-Station-Id}', '%{Calling-Station-Id}', '%{h323-remote-address}', '%{Framed-Protocol}', '%{h323-remote-address}', '0')" It appears twice here because I tried putting it in two different columns. Regards Timothy.
Send us the log (radiusd -X) with your accounting request. Lets see if this query gets executed. Ivan Kalik Kalik Informatika ISP Dana 2/8/2007, "musoket@mtn.co.ug" <musoket@mtn.co.ug> piše:
Hi Claudiu, Thanks for your response.
Thu, 2 Aug 2007 03:10:24 +0300, you wrote:
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
That is in fact the variable that I am using in my insert and update statements but it still doesn't work. See below:
accounting_update_query_alt = "INSERT into ${acct_table1} (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctSt artTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, ServiceType,FramedProtocol, FramedIPAddress, AcctStartDelay) values('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{Cisco-NAS-Port}', '%{NAS-Port-Type}', DATE_SUB('%S',INTERVAL (%{Acct-Session-Time:-0} + %{Acct-Delay-Time:-0}) SECOND), '%{Acct-Session-Time}', '%{Acct-Authentic}','', '%{Acct-Input-Octets}', '%{Acct-Output-Octets}', '%{Called-Station-Id}', '%{Calling-Station-Id}', '%{h323-remote-address}', '%{Framed-Protocol}', '%{h323-remote-address}', '0')"
It appears twice here because I tried putting it in two different columns.
Regards
Timothy.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hi musoket,
You should use the %{h323-remote-address} variable That is in fact the variable that I am using in my insert and update
Dont forget that you have (at least) 2 call legs for each call. With as5350, I guess you will have one voip call leg and one PSTN call leg. The PSTN call leg wont have any h323-remote-address, because it's not VoIP. The AS will notify the radius for each call leg, so you should have two STOPs for each call. I dont see anything wrong with your insert query. It should work. Be sure to have in the dictionary the ATTRIBUTE h323-remote-address for vendor cisco (but if your logs contain h323-remote-address, then you probably have that). Best regards, Claudiu Filip sorry, I ran out of business cards
participants (3)
-
Claudiu Filip -
musoket＠mtn.co.ug -
tnt＠kalik.co.yu