You will have to make up your mind: are you going to use perl or sql module to get passwords. You have asked about using perl and used sql. Ivan Kalik Kalik Informatika ISP Dana 7/3/2008, "johnson elangbam" <elangbamjohnson@gmail.com> piše:
HI, As advice by Ivan Kalik I've add a table and put username and password only, but still the problem is there, and the output is like this. Please let me know how to used the customized table.
Ready to process requests. rad_recv: Access-Request packet from host 127.0.0.1 port 32791, id=197, length=57 User-Name = "david" User-Password = "david" NAS-IP-Address = 192.168.1.227 NAS-Port = 0 +- entering group authorize ++[preprocess] returns ok rlm_realm: No '@' in User-Name = "david", looking up realm NULL rlm_realm: No such realm "NULL" ++[suffix] returns noop rlm_eap: No EAP-Message, not doing EAP ++[eap] returns noop expand: %{User-Name} -> david rlm_sql (sql): sql_set_user escaped user --> 'david' rlm_sql (sql): Reserving sql socket id: 4 expand: SELECT usernames,passwords FROM userpass WHERE usernames = '%{SQL-User-Name}' -> SELECT usernames,passwords FROM userpass WHERE usernames = 'david' query: SELECT usernames,passwords FROM userpass WHERE usernames = 'david' rlm_sql: The 'Attribute' field is empty or NULL, skipping the entire row. rlm_sql (sql): Error getting data from database rlm_sql (sql): SQL query error; rejecting user rlm_sql (sql): Released sql socket id: 4 ++[sql] returns fail Invalid user: [david/david] (from client localhost port 0) Found Post-Auth-Type Reject +- entering group REJECT expand: %{User-Name} -> david attr_filter: Matched entry DEFAULT at line 11 ++[attr_filter.access_reject] returns updated Delaying reject of request 0 for 1 seconds Going to the next request Waking up in 0.9 seconds. Sending delayed reject for request 0 Sending Access-Reject of id 197 to 127.0.0.1 port 32791 Waking up in 4.9 seconds. Cleaning up request 0 ID 197 with timestamp +86 Ready to process requests.
Regards Elangbam Johnson