Dear Andrew,
1) ok .. I have found a script in icradius called ./scripts/dictimport.pl
that did the import ...
[ Note : you might have seen the answer I got from Alan that said
I should not need it : "You should be able to use 'clients.conf'."
but you are right, I should take no risk :it doesn't hurt ;-)
]
2) but I still cannot authenticate a user from mysql !
* freeradius does connect to mysql.
* if a username doesn't exist it doesn't show extra SQL data in the
debugging
but if the user exists ( fablab) I have those extra lines quoted bellow !
* I tried to do as you suggested and to crypt the passwd without extra luck
...
Question : if I use crypt do I have to change the sql.conf ?
(authorize_check_query = "SELECT id,UserName,Attribute,Value FROM
${authcheck_table} WHERE Username = '%{SQL-User-Name}' ORDER BY id" doesn't
say anything about (un/)crypted data ??
would you mind sending me your radiusd.conf/sql.conf ( trimming the passwd
of course) ?
maybe you could do a mysqldump of your DB and cut off all the radcheck
confidential data
(except a test account ) and all radacct data ?
thanks
fabrice.
--------------------8<-------------------------
rlm_sql: Reserving sql socket id: 4
radius_xlat: 'fablab'
sql_escape in: 'fablab'
sql_escape out: 'fablab'
sql_set_user: escaped user --> 'fablab'
radius_xlat: 'SELECT id,UserName,Attribute,Value FROM radcheck WHERE
Username = 'fablab' ORDER BY id'
Password = "LetMeIn"
radius_xlat: 'SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupche
ck.Value FROM radgroupcheck,usergroup WHERE usergroup.Username = 'fablab'
AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id'
Password = "LetMeIn"
Service-Type = Framed-User
Password = "LetMeIn"
Service-Type = Framed-User
Framed-Protocol = PPP
radius_xlat: 'SELECT id,UserName,Attribute,Value FROM radreply WHERE
Username = 'fablab' ORDER BY id'
radius_xlat: 'SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrouprep
ly.Value FROM radgroupreply,usergroup WHERE usergroup.Username = 'fablab'
AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id'
Framed-IP-Address = 192.168.1.1+
Framed-IP-Address = 192.168.1.1+
Framed-MTU = 576
Framed-IP-Address = 192.168.1.1+
Framed-MTU = 576
Service-Type = Framed-User
Framed-IP-Address = 192.168.1.1+
Framed-MTU = 576
Service-Type = Framed-User
Framed-Protocol = PPP
Framed-IP-Address = 192.168.1.1+
Framed-MTU = 576
Service-Type = Framed-User
Framed-Protocol = PPP
Framed-Compression = Van-Jacobson-TCP-IP
rlm_sql: Released sql socket id: 4
rlm_sql: Pairs do not match [fablab]
modcall[authorize]: module "sql" returns notfound
-------------------->8-------------------------
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
