Peder, I have all the permissions in mysql user. I can query my database from the local box. Mik Cheez, yes, it is. mysql.sock is in /var/lib/mysql/ Asterisk and Mysql are in the same PC I still have the same error and don't know what to do. help plz!
thanks in advance, Renzzo Mik Cheez wrote: >Is your mysql.sock actually in /var/lib/mysql/ ? Peder wrote: >Could be a mysql permission issue. Try this from the local box: > >mysql -u root -p ><enter asterisk as the password> >use asterisk; >select * from sip_buddies; >select * from iax_buddies; > >If you get that far and can see the entries in iax_buddies and >sip_buddies, you know it isn't a permissions issue. If you can't, then >you know where to look. RENZZO SOTOMAYOR wrote: > Hi! I am proving Asterisk 1.2.24 in realtime with MySQL 5.0.27 using > Idefisk softphones. I followed the steps of "how to" of voip-org but > always have this error: > > Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: > MySQL RealTime: Failed to query database. Check debug for more info. > Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: > MySQL RealTime: Failed to query database. Check debug for more info. > Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: > MySQL RealTime: Failed to query database. Check debug for more info. > Sep 25 20:29:07 NOTICE[12000]: chan_iax2.c:5252 register_verify: Host > 127.0.0.1 <http://127.0.0.1/> failed MD5 authentication for '101' > (9a43a82001dfa49d84e8facb765f7d > e2 != 31610d29241e861816b83998501ee223) > > I configure extconfig.conf as: > [settings] > iaxusers => mysql,asterisk,iax_buddies > iaxpeers => mysql,asterisk,iax_buddies > sipusers => mysql,asterisk,sip_buddies > sippeers => mysql,asterisk,sip_buddies > > res_mysql.conf as: > [general] > dbhost = localhost > dbname = asterisk > dbuser = root > dbpass = asterisk > dbport = 3306 > dbsock = /var/lib/mysql/mysql.sock > > My table as: > CREATE TABLE iax_buddies ( > name varchar(30) primary key NOT NULL, > username varchar(30), > type varchar(6) NOT NULL, > secret varchar(50), > callerid varchar(100), > context varchar(100), > host varchar(31) NOT NULL default 'dynamic', > disallow varchar(100), > allow varchar(100) > ); > > I'm running asterisk on Fedora 6. Plz help > > thanks in advance > > Renzzo > > > ------------------------------------------------------------------------ > > _______________________________________________ > > Sign up now for AstriCon 2007! September 25-28th. http://www.astricon.net/ > > --Bandwidth and Colocation Provided by http://www.api-digital.com-- > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users
_______________________________________________ Sign up now for AstriCon 2007! September 25-28th. http://www.astricon.net/ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users