I installed freeradius along with freetds and unixodbc
on RH8 to be able to send accounting records to a
MSSQL database.
Radius starts fine and connects to mssql but I get
the following errors when radius is trying to
update/insert the mssql database for accounting records:
rlm_sql: Couldn't insert SQL accounting STOP record - 00000
OR
rlm_sql: Couldn't update SQL accounting for START packet - 00000
extract of debugging output:
------------------------------
sql: connect_failure_retry_delay = 60
sql: simul_count_query = ""
sql: simul_verify_query = ""
sql: simul_zap_query = ""
rlm_sql: Driver rlm_sql_unixodbc loaded and linked
rlm_sql: Attempting to connect to freeradius@MSSQL-6:/freeradius
rlm_sql: starting 0
rlm_sql: Attempting to connect #0
rlm_sql: Connected new DB handle, #0
rlm_sql: starting 1
rlm_sql: Attempting to connect #1
rlm_sql: Connected new DB handle, #1
<snip>
modcall: entering group preacct
modcall[preacct]: module "preprocess" returns noop
rlm_realm: Looking up realm NULL for User-Name = "dme"
rlm_realm: No such realm NULL
modcall[preacct]: module "suffix" returns noop
modcall[preacct]: module "files" returns noop
modcall: group preacct returns noop
modcall: entering group accounting
radius_xlat: 'dme'
sql_set_user: escaped user --> 'dme'
radius_xlat: 'UPDATE radacct SET AcctStopTime = '2002-11-06 18:44:40',
AcctSessionTime = '127', AcctInputOctets = '2320', AcctOutputOctets = '157339',
AcctTerminateCause = 'User-Request', AcctStopDelay = '0', ConnectInfo_stop = '' WHERE
AcctSessionId = '7400315D' AND UserName = 'dme' AND NASIPAddress = '212.24.192.4' AND
AcctStopTime = 0'
rlm_sql: Reserving sql socket id: 4
radius_xlat: 'INSERT into radacct (AcctSessionId, AcctUniqueId, UserName, Realm,
NASIPAddress, NASPort, NASPortType, AcctStopTime, AcctSessionTime, AcctAuthentic,
ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets,
CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol,
FramedIPAddress, AcctStartDelay, AcctStopDelay) values('7400315D', '', 'dme', '',
'212.24.192.4', '34', 'ISDN', '2002-11-06 18:44:40', '127', 'RADIUS', '', '', '2320',
'157339', '', '', 'User-Request', 'Framed-User', 'PPP', '212.24.192.101', '0', '0')'
rlm_sql_unixodbc: '00000 '
rlm_sql: Couldn't insert SQL accounting STOP record - 00000
rlm_sql: Released sql socket id: 4
modcall[accounting]: module "sql" returns ok
radius_xlat: '/usr/local/var/log/radius/radacct/212.24.192.4/detail'
rlm_detail: /usr/local/var/log/radius/radacct/%{Client-IP-Address}/detail expands to
/usr/local/var/log/radius/radacct/212.24.192.4/detail
modcall[accounting]: module "detail" returns ok
modcall[accounting]: module "unix" returns ok
radius_xlat: 'dme'
Accounting: logout: entry for NAS 212.24.192.4 port 34 has wrong ID
modcall[accounting]: module "radutmp" returns ok
modcall: group accounting returns ok
Sending Accounting-Response of id 175 to 212.24.192.4:1118
Finished request 0
Going to the next request
==================================================================================================
Does anybody know a solution to this problem?
thanks,
Christian
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
