[asterisk-users] Asterisk realtime error

[Nasir Iqbal]

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