Re: [Asterisk-Users] Realtime voicemail not working
2006/6/23, Mike [EMAIL PROTECTED]: Hi,I've been using MySql with the CDR for awhile with no issues at all, but Ifigured I'd try putting voicemail users in a DB.Using the same DB (verylow load), and a user that has been proven to work well using a client GUI, I inserted one user and tried to use realtime.This is what I get in theconsole:ERROR[30517]: res_config_mysql.c:615 mysql_reconnect: MySQL RealTime: Failedto connect database server asterisk on localhost. Check debug for more info. What's in your res_mysql.conf file? You need to place the connection settings there like you did in cdr_mysql.conf. If you still get errors, start asterisk using the -d option and check /var/log/asterisk. Also check logger.conf to make sure debugging is enabled. ___ --Bandwidth and Colocation provided by Easynews.com -- Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] Realtime voicemail not working
That is what I have in my config file. Pretty much the same thing as the CDR file [general]dbhost=localhostdbname=dbdbuser=userdbpass=pw;dbport=3306;dbsock = /tmp/mysql.sock Mike From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Benjamin StockerSent: June 23, 2006 9:07 AMTo: Asterisk Users Mailing List - Non-Commercial DiscussionSubject: Re: [Asterisk-Users] Realtime voicemail not working 2006/6/23, Mike [EMAIL PROTECTED]: Hi,I've been using MySql with the CDR for awhile with no issues at all, but Ifigured I'd try putting voicemail users in a DB.Using the same DB (verylow load), and a user that has been proven to work well using a client GUI, I inserted one user and tried to use realtime.This is what I get in theconsole:ERROR[30517]: res_config_mysql.c:615 mysql_reconnect: MySQL RealTime: Failedto connect database server asterisk on localhost. Check debug for more info. What's in your res_mysql.conf file? You need to place the connection settings there like you did in cdr_mysql.conf. If you still get errors, start asterisk using the -d option and check /var/log/asterisk. Also check logger.conf to make sure debugging is enabled. ___ --Bandwidth and Colocation provided by Easynews.com -- Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] Realtime voicemail not working
Weird. I just tried with 127.0.0.1 instead of localhost and it worked. Can't explain why How can I force it to go through a db socket instead? Mike From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Benjamin StockerSent: June 23, 2006 9:07 AMTo: Asterisk Users Mailing List - Non-Commercial DiscussionSubject: Re: [Asterisk-Users] Realtime voicemail not working 2006/6/23, Mike [EMAIL PROTECTED]: Hi,I've been using MySql with the CDR for awhile with no issues at all, but Ifigured I'd try putting voicemail users in a DB.Using the same DB (verylow load), and a user that has been proven to work well using a client GUI, I inserted one user and tried to use realtime.This is what I get in theconsole:ERROR[30517]: res_config_mysql.c:615 mysql_reconnect: MySQL RealTime: Failedto connect database server asterisk on localhost. Check debug for more info. What's in your res_mysql.conf file? You need to place the connection settings there like you did in cdr_mysql.conf. If you still get errors, start asterisk using the -d option and check /var/log/asterisk. Also check logger.conf to make sure debugging is enabled. ___ --Bandwidth and Colocation provided by Easynews.com -- Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] Realtime voicemail not working
2006/6/23, Mike [EMAIL PROTECTED]: That is what I have in my config file. Pretty much the same thing as the CDR file [general]dbhost=localhostdbname=dbdbuser=userdbpass=pw;dbport=3306 ;dbsock = /tmp/mysql.sock In logger.conf, enable debug mode: debug = notice,warning,error,debug,verboseStart asterisk in debug mode: asterisk -d Check /var/log/asterisk/debug, you should see more details about the connection problem there. ___ --Bandwidth and Colocation provided by Easynews.com -- Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] Realtime voicemail not working
I think you just comment out dbhost statement and leave the dbsock statement in, and it assumes its a localhost connection on the socket specified. Cheers, Adam From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Sent: 23 June 2006 14:51 To: 'Asterisk Users Mailing List - Non-Commercial Discussion' Subject: RE: [Asterisk-Users] Realtime voicemail not working Weird. I just tried with 127.0.0.1 instead of localhost and it worked. Can't explain why How can I force it to go through a db socket instead? Mike From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Benjamin Stocker Sent: June 23, 2006 9:07 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] Realtime voicemail not working 2006/6/23, Mike [EMAIL PROTECTED]: Hi, I've been using MySql with the CDR for awhile with no issues at all, but I figured I'd try putting voicemail users in a DB.Using the same DB (very low load), and a user that has been proven to work well using a client GUI, I inserted one user and tried to use realtime.This is what I get in the console: ERROR[30517]: res_config_mysql.c:615 mysql_reconnect: MySQL RealTime: Failed to connect database server asterisk on localhost. Check debug for more info. What's in your res_mysql.conf file? You need to place the connection settings there like you did in cdr_mysql.conf. If you still get errors, start asterisk using the -d option and check /var/log/asterisk. Also check logger.conf to make sure debugging is enabled. ___ --Bandwidth and Colocation provided by Easynews.com -- Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
