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/20070926/2f661023/attachment.htm
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
Is your mysql.sock actually in /var/lib/mysql/ ? 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
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
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-------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20070928/788b1265/attachment.htm