asterisk users - Sep 2007 - asterisk-users Digest, Vol 38, Issue 83

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 failed MD5 authentication for '101'
(9a43a82001dfa49d84e8facb765f7de2 != 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20070925/b8051a9f/attachment.htm