Does the user you have defined in sql.conf have select permissions on the radius.* tables?
ie: GRANT SELECT on radius.* to [EMAIL PROTECTED] identified by 'yourpass'; If so, then can you login to mysql with that user and run this query and copy/paste the actual query and results here. SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE STRCMP(UserName, '16000') = 0 ORDER BY id; Please copy/paste the actual results from this query. On Thu, 6 Jan 2005, Bruno Machado wrote: > Please my friends! Help me! > > I already configured the B2Bua and the proxy SER to > work together, but I need to authenticate the b2bua on > the FreeRadius. The errors: > > rlm_sql (sql): No matching entry in the database for > request from user [16000] > rlm_sql (sql): Released sql socket id: 2 > modcall[authorize]: module "sql" returns notfound > for request 2 > modcall: group authorize returns ok for request 2 > auth: No authenticate method (Auth-Type) configuration > found for the request: Rejecting the user > auth: Failed to validate the user. > > > I saw this screen all the day. I did everything that I > can. If somebody know anything to help me, I will be > very grateful! > Thanks. > > Bruno Machado > > > --- Bruno Machado <[EMAIL PROTECTED]> escreveu: > > Sorry friends > > > > The number that is showed at the tables is 16000! > > Forget the 16004. > > > > > > --- Chris Parker <[EMAIL PROTECTED]> escreveu: > > > > > > > > > > > On Jan 5, 2005, at 12:45 PM, Bruno Machado wrote: > > > > > > > Hi all > > > > > > > > Im trying to use the B2bua with Radius but some > > > > problems is happening here. When I send a > > "INVITE" > > > > from the SER to the B2bua, it try authenticate, > > > but it > > > > doesnt work. The text below is the log of the > > > Radius: > > > > > > > > radius_xlat: 'SELECT > > > id,UserName,Attribute,Value,op > > > > FROM radcheck WHERE STRCMP(UserName, '16000') = > > 0 > > > > ORDER BY id' > > > > rlm_sql (sql): Reserving sql socket id: 3 > > > > rlm_sql_mysql: query: SELECT > > > > id,UserName,Attribute,Value,op FROM radcheck > > WHERE > > > > STRCMP(UserName, '16000') = 0 ORDER BY id > > > > > > What do you get when you run this query by hand? > > > > > > -Chris > > > -- > > > \\\|||/// \ StarNet - A US LEC Company \ > > > > > Chris Parker > > > \ ~ ~ / \ Wholesale Internet \ > > > Director, Engineering > > > | @ @ | \ http://www.megapop.net \ > > > (847) 963-0116 x321 > > > > > > oOo---(_)---oOo--\------------------------------------------------------ > > > VoiceEclipse, The Fresh Alternative > > > http://www.voiceeclipse.com > > > > > > > > > - > > > List info/subscribe/unsubscribe? See > > > http://www.freeradius.org/list/users.html > > > > > > > > > > > > > > > > _______________________________________________________ > > > > Yahoo! Acesso Gr�tis - Instale o discador do Yahoo! > > agora. http://br.acesso.yahoo.com/ - Internet r�pida > > e gr�tis > > > > - > > List info/subscribe/unsubscribe? See > > http://www.freeradius.org/list/users.html > > > > > > > > _______________________________________________________ > Yahoo! Acesso Gr�tis - Instale o discador do Yahoo! agora. > http://br.acesso.yahoo.com/ - Internet r�pida e gr�tis > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
