----- Original Message -----
From: "Fabrice LABORIE" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 22, 2001 9:29 AM
Subject: found script dicimport.pl but still cannot authenticate
> 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 ?
I saw in your previous post that you where putting attributes in your
radgroupcheck table. These are causing a problem. In the 'Authorize'
section when the 'check' statements are processed they must already be in
the auth-request.
Joe Modjeski
>
>
> 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
>
>
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
