2nd option is chosen. Many thanks. rg 2008/4/17 Ivan Kalik <tnt@kalik.net>:
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@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
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html