problem with rlm_sql or mysql-server ?

Mathieu Lemaitre mlemaitre at walan.biz
Tue Mar 20 14:23:26 CET 2007


Hi everybody,

I have a problem with freeradius 1.0.2 and mysql 4.0.24, on a debian 
stable, used for about 1700 clients. I often have (about 10 times an 
hour) errors like these:

Tue Mar 20 12:21:29 2007 : Auth: Login incorrect: [XXXX/YYYYY] (from 
client ZZZZ port 0)
Tue Mar 20 12:21:40 2007 : Info: rlm_sql (sql): No matching entry in the 
database for request from user [XXXXX]
Tue Mar 20 12:21:40 2007 : Auth: Login incorrect: [XXXXX/YYYYY] (from 
client ZZZZ port 0)
Tue Mar 20 12:22:00 2007 : Info: rlm_sql (sql): No matching entry in the 
database for request from user [XXXXX]
Tue Mar 20 12:22:00 2007 : Auth: Login incorrect: [XXXXX/YYYYY] (from 
client ZZZZ port 0)
Tue Mar 20 12:22:21 2007 : Auth: Login OK: [XXXXX/YYYYY] (from client 
ZZZZ port 0)

whereas, of course, the username exists, and the pass didn't change...

is this a problem with the freeradius config, or is the mysqlserver too 
busy?

thanks for your answers,

Mathieu

-------------- next part --------------
A non-text attachment was scrubbed...
Name: mlemaitre.vcf
Type: text/x-vcard
Size: 298 bytes
Desc: not available
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20070320/4fb268e6/attachment.vcf>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 4199 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20070320/4fb268e6/attachment.bin>


More information about the Freeradius-Users mailing list