[asterisk-users] Asterisk realtime error

[RENZZO SOTOMAYOR]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20070926/f1f41283/attachment.htm