Hi Renzzo, Which linux distribution you are using?
maybe problem is due to mysql.sock try with direct tcp connection. 1. remove "dbsock = /var/lib/mysql/mysql.sock" line 2. change mysql user host permission from "localhost" "%" 3. dump mysql permissions or restart mysql; 4. reload / restart asterisk. Regards Nasir Iqbal http://www.ictinnovations.com On Wed, 2007-09-26 at 23:25 -0500, RENZZO SOTOMAYOR wrote: > 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' > > (9a43a82001dfa49d84e8facb765f7 > d > > 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 _______________________________________________ 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
