[Help-gnu-radius] Authentication Mysql

[Andrey Nikolaev]

Hi!
I have problem with authenticate radiusd v1.2 from mysql database.

I'm working with radius v0.93 and not problems is it.
See configure user test...

radiusd: Сервер GNU Radius, версия 1.2 (i386-unknown-freebsd5.2.1)
Платформа компиляции: FreeBSD
Флаги отладки:
Флаги компиляции:USE_SQL_MYSQL USE_SNMP
настройки по умолчанию:
Порты:
 AUTH: 1812
 ACCT: 1813
Пути:
 каталог файлов конфигурации: /usr/local/Radius/etc/raddb
 каталог журналов:            /var/log
 каталог обсчёта:             /var/log/radacct
 каталог файла pid:           /var/run

configure password for user test
mysql> update passwd set password=encrypt('test') where user_name='test';
+-----------+---------+---------------+--------+
| user_name | service | password      | active |
+-----------+---------+---------------+--------+
| test      |         | fT1dA7C3ATl4U | Y      |
+-----------+---------+---------------+--------+

/usr/local/Radius/sbin>./radauth test test
FAIL

and debug log write next:
сен 02 10:41:30 mysql.c:158:rad_mysql_getpwd: query: SELECT password FROM 
passwd WHERE user_name='te
st' AND active='Y'
сен 02 10:41:30 mysql.c:61:do_mysql_query: called with SELECT password FROM 
passwd WHERE user_name='
test' AND active='Y'
сен 02 10:41:30 mysql.c:71:do_mysql_query: MYSQL query returned 0
сен 02 10:41:30 auth.c:292:rad_check_password: auth_type=3, userpass=test, 
name=test, password=UngwW
SRhZySpc
сен 02 10:41:30 auth.c:322:rad_check_password:   auth: Crypt
сен 02 10:41:30 auth.c:333:rad_check_password: pwbuf: $2a$04$UngwWSR
сен 02 10:41:30 auth.c:911:sfn_validate: 1 -> 15
сен 02 10:41:30 auth.c:1197:sfn_reject_cleanup: 15 -> 14
сен 02 10:41:30 auth.c:1203:sfn_reject: REJECT: test


why password crypted function encrypt not equal password radiusd ?

And what do ?

Thank you.

-- 
Andrey Nikolaev                 +380652-511616
                                +380652-276405
address@hidden                  AN1035-RIPE