OpenForum RSS: Freeradius2+Mysql ��

Freeradius2+Mysql �� (jonson)

Wed, 29 Jun 2011 03:05:12 GMT

�� Crypt-Password �� Cleartext-Password, ��

Freeradius2+Mysql �� (jonson)

Wed, 29 Jun 2011 01:05:56 GMT

> ��-�� :
> authorize_check_query = "select id, login as username, 'Crypt-Password' as attribute,
> pass as value, ':=' as op from users where login='%{User-Name}' order
> by id"
> authorize_reply_query = "select id, login as username, 'Crypt-Password' as attribute,
> pass as value, ':=' as op from users where login='%{User-Name}' order
> by id"

�� , �� 5 �� , �� , �� :

++[sql] returns ok
++[expiration] returns noop
++[logintime] returns noop
++[pap] returns updated
Found Auth-Type = PAP
# Executing group from file /usr/local/etc/raddb/sites-enabled/default
+- entering group PAP {...}
[pap] login attempt with password "qwe"
[pap] Using CRYPT password "qwe"
[pap] Passwords don't match
++[pap] returns reject
Failed to authenticate the user.
Login incorrect (rlm_pap: CRYPT password check failed): [qwe/qwe] (from client localhost port 1812)
Using Post-Auth-Type Reject
# Executing group from file /usr/local/etc/raddb/

Freeradius2+Mysql �� (orangeant)

Tue, 28 Jun 2011 22:05:05 GMT

��-�� :

authorize_check_query = "select id, login as username, 'Crypt-Password' as attribute, pass as value, ':=' as op from users where login='%{User-Name}' order by id"
authorize_reply_query = "select id, login as username, 'Crypt-Password' as attribute, pass as value, ':=' as op from users where login='%{User-Name}' order by id"

OpenForum RSS: Freeradius2+Mysql ���������

Freeradius2+Mysql ��������� (jonson)

Freeradius2+Mysql ��������� (jonson)

Freeradius2+Mysql ��������� (orangeant)

OpenForum RSS: Freeradius2+Mysql ��

Freeradius2+Mysql �� (jonson)

Freeradius2+Mysql �� (jonson)

Freeradius2+Mysql �� (orangeant)