freeradius and mysql - no matching entry in db

2005-10-25 Thread Luqman H
i have fedora core 4 and freeradius-1.0.5 and this is what i do... # radtest luqe mypassword localhost 1812 testing123 Sending Access-Request of id 24 to 127.0.0.1:1812 User-Name = luqe User-Password = mypassword NAS-IP-Address = dns.mammiri.net NAS-Port = 1812

Re: freeradius and mysql - no matching entry in db

2005-10-25 Thread Lewis Bergman
Luqman H said: No matching entry in the database for request from user [luqe] but if i'm quering manually on mysql: mysql SELECT id, UserName, Attribute, Value, op FROM radcheck WHERE Username = 'luqe' ORDER BY id; +-+--+---+--++ | id | UserName |

Re: freeradius and mysql - no matching entry in db

2005-10-25 Thread Luqman H
2005/10/25, Lewis Bergman [EMAIL PROTECTED]: mysql SELECT id, UserName, Attribute, Value, op FROM radcheck WHERE Username = 'luqe' ORDER BY id; +-+--+---+--++ | id | UserName | Attribute | Value| op |

Re: freeradius and mysql - no matching entry in db

2005-10-25 Thread Luqman H
if i include the user file, - rlm_sql_mysql: query: SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = 'luqe' AND usergroup.GroupName = radgroupreply.GroupName ORDER