[asterisk-users] Asterisk realtime error

[Peder @ NetworkOblivion]

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