Need to customized the table schema.

johnson elangbam elangbamjohnson at gmail.com
Thu Feb 28 13:14:29 CET 2008


hi,
     I am using free radius 2 with MS Sql 2000. I want to make a database
schema of my own to store only username and password in MS Sql. I would like
to modify the query so that the radius server reads only this information
from my customized table.I've tryied modyfying sql queries from
dialup.confto read from my table but it doesn't work. Please help.
Here is the piece of output of the radius server after rejecting the
username and the password.


rad_recv: Access-Request packet from host 127.0.0.1 port 32835, id=208,
length=56
        User-Name = "John"
        User-Password = "1"
        NAS-IP-Address = 192.168.2.227
        NAS-Port = 0
+- entering group authorize
++[preprocess] returns ok
++[chap] returns noop
++[mschap] returns noop
    rlm_realm: No '@' in User-Name = "John", looking up realm NULL
    rlm_realm: No such realm "NULL"
++[suffix] returns noop
  rlm_eap: No EAP-Message, not doing EAP
++[eap] returns noop
++[unix] returns notfound
++[files] returns noop
        expand: %{User-Name} -> John
rlm_sql (sql): sql_set_user escaped user --> 'John'
rlm_sql (sql): Reserving sql socket id: 4
        expand: SELECT name,value FROM checking WHERE name =
'%{SQL-User-Name}' -> SELECT name,value FROM checking WHERE name = 'John'
query:  SELECT name,value FROM checking WHERE name = 'John'
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: [John/1] (from client localhost port 0)
  Found Post-Auth-Type Reject
+- entering group REJECT
        expand: %{User-Name} -> John
 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 208 to 127.0.0.1 port 32835
Waking up in 4.9 seconds.
Cleaning up request 0 ID 208 with timestamp +17
Ready to process requests.


With Regards
Elangbam Johnson
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20080228/4dfe94c9/attachment.html>


More information about the Freeradius-Users mailing list