[asterisk-users] Asterisk realtime error
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
[asterisk-users] Asterisk realtime error
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 ___ 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
Re: [asterisk-users] Asterisk realtime error
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 ___ 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
Re: [asterisk-users] 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 ___ 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
[asterisk-users] open source screen pop software for asterisk
Hi! I am new here. Well I'm doing a call center using asterisk and I'm looking for an open source screen pop software to pop the caller's information, its call history and others things. i was looking around and find the U-rang2 the problem is that it isn't open source. if someone knows about an open source screen pop please tell me. thanks in advance renzzo ___ --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