Hi,
I am able to get authentication from LDAP server but
could not get accounting records on Mysql....here
below is the log.....................................
-----------------------------------------------------
modcall[accounting]: module "detail" returns ok
rlm_sql: Reserving sql socket id: 4
rlm_sql: received Acct On/Off packet
radius_xlat: 'UPDATE radacct SET
AcctStopTime='2002-03-07 17:59:46',
AcctSessionTime=unix_timestamp('2002-03-07 17:59:46')
- unix_timestamp(AcctStartTime),
AcctTerminateCause='', AcctStopDelay = WHERE
AcctSessionTime=0 AND AcctStopTime=0 AND NASIPAddress=
'10.100.10.1' AND AcctStartTime <= '2002-03-07
17:59:46''
rlm_sql: Couldn't update SQL accounting for ALIVE
packet - You have an error in your SQL syntax near
'WHERE AcctSessionTime=0 AND AcctStopTime=0 AND
NASIPAddress= '10.100.10.1' A' at line 1
rlm_sql: Released sql socket id: 4
modcall[accounting]: module "sql" returns ok
modcall: group accounting returns ok
Sending Accounting-Response of id 3 to
10.100.10.1:2006
Finished request 4
Going to the next request
--- Walking the entire request list ---
Cleaning up request 4 ID 3 with timestamp 3c87aa92
Nothing to do. Sleeping until we see a request.
Any suggestion ???
AS Spada
__________________________________________________
Do You Yahoo!?
Try FREE Yahoo! Mail - the world's greatest free email!
http://mail.yahoo.com/
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
