FreeRadius 0.5 with mysql 3.22.32

[Tsui Kai Ho Kyo]

Dear all,   I had configured my free-radius 0.5 on redhat 6.2 linux server. I run the server by using "./radiusd -xxyz -l stdout" The problem is that my dial up users got "Error 5: access denied", however, the standard output shown things ok.. one more thing.. I can find the record for username "egtwc98" at radacct table too... Pls help.   rad_recv: Accounting-Request packet from host 156.62.150.121:1646, id=178, length=92 Thread 2 assigned request 1 --- Walking the entire request list --- Cleaning up request 0 ID 177 with timestamp 3cb0fd96 Nothing to do.  Sleeping until we see a request. Thread 2 handling request 1, (1 handled so far)         NAS-IP-Address = 156.62.150.121         NAS-Port = 27         NAS-Port-Type = Async         User-Name = "SSDJC5"         Acct-Status-Type = Start         Acct-Authentic = Local         Service-Type = Framed-User         Acct-Session-Id = "0000028D"         Framed-Protocol = PPP         Framed-IP-Address = 156.62.155.230         Acct-Delay-Time = 0 modcall: entering group preacct   hints: Matched DEFAULT at 36   modcall[preacct]: module "preprocess" returns updated modcall: group preacct returns updated modcall: entering group accounting radius_xlat:  '/etc/radius/var/log/radius/radacct/156.62.150.121/detail' rlm_detail: /etc/radius/var/log/radius/radacct/%{Client-IP-Address}/detail expands to /etc/radius/var/log/radius/radacct/156.62.150.121/detail   modcall[accounting]: module "detail" returns ok radius_xlat:  'SSDJC5' sql_escape in:  'SSDJC5' sql_escape out:  'SSDJC5' sql_set_user:  escaped user --> 'SSDJC5' 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) values('', '0000028D', '', 'SSDJC5', '', '156.62.150.121', '', 'Async', '2002-04-08 10:20:08', '0', '0', 'Local', '', '', '0', '0', '', '', '', 'Framed-User', 'PPP', '156.62.155.230', '0', '0')' rlm_sql: Reserving sql socket id: 19 query:  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) values('', '0000028D', '', 'SSDJC5', '', '156.62.150.121', '', 'Async', '2002-04-08 10:20:08', '0', '0', 'Local', '', '', '0', '0', '', '', '', 'Framed-User', 'PPP', '156.62.155.230', '0', '0') rlm_sql: Released sql socket id: 19   modcall[accounting]: module "sql" returns ok radius_xlat:  'SSDJC5'   modcall[accounting]: module "radutmp" returns ok modcall: group accounting returns ok Sending Accounting-Response of id 178 to 156.62.150.121:1646 Finished request 1 Going to the next request Thread 2 waiting to be assigned a request     Regards, Benson