Hello people,i just added the h323remoteaddress parameter to my mysql
database and updated the sql.conf file
(to insert the h323remoteaddress in the db) like the following:
I added the h323remoteaddress in the accounting_start_query:
accounting_start_query = "INSERT into radacct (RadAcctId,
AcctSessionId, AcctUniqueId, UserName, Realm,
NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctStopTime,
AcctSessionTime, AcctAuthentic, ConnectInfo
_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets,
CalledStationId, CallingStationId, AcctTerminateCa
use, ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay,
AcctStopDelay,h323remoteaddress) values('',
'%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}',
'%{Realm}', '%{NAS-IP-Address}', '%{NAS-
Port-Id}', '%{NAS-Port-Type}', '%S', '0', '0', '%{Acct-Authentic}',
'%{Connect-Info}', '', '0', '0', '%{Called-
Station-Id}', '%{Calling-Station-Id}', '', '%{Service-Type}',
'%{Framed-Protocol}', '%{Framed-IP-Address}', '%{
Acct-Delay-Time}', '0','%{h323remoteaddress}')"
after that i got this error:
sql_set_user: escaped user --> '555334433'
radius_xlat: 'INSERT into radacct (RadAcctId, AcctSessionId,
AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType,
AcctStartTime, AcctStopTime, AcctSessionTime, AcctAuthentic,
ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets,
CalledStationId, CallingStationId, AcctTerminateCause, ServiceType,
FramedProtocol, FramedIPAddress, AcctStartDelay,
AcctStopDelay,h323remoteaddress) values('', '00001AC8', '',
'1150930808', '', '200.73.182.8', '', 'Async', '2002-08-30 12:30:38',
'0', '0', '', '', '', '0', '0', '004955555', '555334433', '',
'Login-User', '', '', '0', '0')'
rlm_sql: Reserving sql socket id: 2
rlm_sql: Couldn't update SQL accounting for START packet - Column count
doesn't match value count at row 1
radius_xlat: 'UPDATE radacct SET AcctStartTime = '2002-08-30 12:30:38',
AcctStartDelay = '0', ConnectInfo_start = '' WHERE AcctSessionId =
'00001AC8' AND UserName = '1150930808' AND NASIPAddress = '200.73.182.8'
AND AcctStopTime = 0'
rlm_sql: Released sql socket id: 2
So i also added the parameter to the accounting_stop_query_alt query
,the error message is gone but i am not getting any
input in the db(h3232remoteaddres values)
Any ideas?,does anyone has a working sql.conf/voip example(extract of
the needed querys....) i might find usefull?
I think this queries are the problem because all the other data is being
inserted in the db without any problem..
Thanks in advance,sorry for the long mail.
Hernan
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
