Problems with using Customize table schema

johnson elangbam elangbamjohnson at gmail.com
Fri Mar 7 13:21:55 CET 2008


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20080307/91586c30/attachment.html>


More information about the Freeradius-Users mailing list