Yes Dustin. The user has permission. At the tables, I have all the data necessary. Without the b2bua, the proxy SER run very well. It is the unique problem: b2bua need to access the Freeradius. I dont understand what can happening. I didnt find any errors.... Other suggestions are welcome.
Many thanks Dustin! --- Dustin Doris <[EMAIL PROTECTED]> escreveu: > 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 > _______________________________________________________ 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
