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