rlm_sql - Different table for User authentication

[Ivan Kalik]

Database is used to store attributes. It doesn't authenticate users.
>From data you have stored in authcheck table no attribute can be created
with chack query so that's a likely reason for segfault.

1. Use another module (perl, exec) that can do authentication with data
from authcheck table.

or

2. Add attribute name and op fields (back) to your table and fix them in
your modified query to Cleartext-Password (or whatever password
attribute you are using) and :=.

Ivan Kalik
Kalik Informatika ISP


Dana 17/4/2008, "rsg" <ranil.santhish at gmail.com> piše:

>Hi,
>
>I need to use a different auth table for Username/Password check.
>
>
>Here are the modifications I made into config.
>
>#raddb/sql.conf
>
>:
>  authcheck_table = "authcheck"
>:
>..
>
>#raddb/sql/mysql/dialup.conf
>:
>..
>## +++++++++ Here i retain the order of return data but omit some
>Attributes (2. Attr Name and 4.Attr Operation as described in
>Authorization Queries) +++++
>
>       authorize_check_query = "SELECT id, userid, passwd \
>          FROM ${authcheck_table} \
>          WHERE userid = '%{SQL-User-Name}' \
>          ORDER BY id"
>
>
>## +++++++++++++I DID NOT TOUCH THE REPLY QUERY
>++++++++++++++++++++++++++++++++++++++
>
>        authorize_reply_query = "SELECT id, username, attribute, value, op \
>          FROM ${authreply_table} \
>          WHERE username = '%{SQL-User-Name}' \
>          ORDER BY id"
>:
>..
>
>When I tried to authenticate a user I get a segmentation fault as follows;
>
>------
>rlm_sql (sql): sql_set_user escaped user --> 'test'
>rlm_sql (sql): Reserving sql socket id: 2
>   expand: SELECT id, userid , password  FROM authcheck  WHERE userid
>= '%{SQL-User-Name}'  ORDER BY id
>-> SELECT id, userid, password  FROM authcheck  WHERE login = 'test' ORDER BY id
>
>Segmentation fault
>------
>
>Are there any particular parameters/settings that i've missed here?
>
>
>Thanks for the suggestions.
>
>rg
>-
>List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>
>