Problems with using Customize table schema

Ivan Kalik tnt at kalik.net
Fri Mar 7 13:43:52 CET 2008


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 at 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
>
>




More information about the Freeradius-Users mailing list