[asterisk-users] realtime voicemail asterisk 11
Hi list, I'm trying to put my voicemail on asterisk realtime with 11.XX, generate tables in a couple of files in the folder realtime / mysql , voicemail_messages.sql and voicemail.sql the connection with mysql and odbc works well isql asterisk useradmin xxx +---+ | Connected!| | | | sql-statement | | help [tablename] | | quit | | | +---+ [Oct 14 10:06:16] WARNING[10037][C-0003]: res_odbc.c:645 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 42S02: [MySQL][ODBC 5.2(w) Driver][mysqld-5.6.12]Table 'asterisk.voicemessages' doesn't exist (86) [Oct 14 10:06:16] WARNING[10037][C-0003]: res_odbc.c:657 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk [asterisk]... [Oct 14 10:06:16] WARNING[10037][C-0003]: res_odbc.c:761 ast_odbc_sanity_check: Connection is down attempting to reconnect... [Oct 14 10:06:16] NOTICE[10037][C-0003]: res_odbc.c:1527 odbc_obj_connect: Connecting asterisk [Oct 14 10:06:16] NOTICE[10037][C-0003]: res_odbc.c:1559 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk] [Oct 14 10:06:16] WARNING[10037][C-0003]: app_voicemail.c:5609 messagecount: SQL Execute error! any help is appreciated! -- rickygm http://gnuforever.homelinux.com -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] realtime voicemail asterisk 11
On Mon, Oct 14, 2013 at 11:13 AM, troxlinux xserverli...@gmail.com wrote: Hi list, I'm trying to put my voicemail on asterisk realtime with 11.XX, generate tables in a couple of files in the folder realtime / mysql , voicemail_messages.sql and voicemail.sql the connection with mysql and odbc works well isql asterisk useradmin xxx +---+ | Connected!| | | | sql-statement | | help [tablename] | | quit | | | +---+ [Oct 14 10:06:16] WARNING[10037][C-0003]: res_odbc.c:645 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 42S02: [MySQL][ODBC 5.2(w) Driver][mysqld-5.6.12]Table 'asterisk.voicemessages' doesn't exist (86) [Oct 14 10:06:16] WARNING[10037][C-0003]: res_odbc.c:657 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk [asterisk]... [Oct 14 10:06:16] WARNING[10037][C-0003]: res_odbc.c:761 ast_odbc_sanity_check: Connection is down attempting to reconnect... [Oct 14 10:06:16] NOTICE[10037][C-0003]: res_odbc.c:1527 odbc_obj_connect: Connecting asterisk [Oct 14 10:06:16] NOTICE[10037][C-0003]: res_odbc.c:1559 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk] [Oct 14 10:06:16] WARNING[10037][C-0003]: app_voicemail.c:5609 messagecount: SQL Execute error! Could you post a sanitized version of your res_config_mysql.conf and extconfig.conf files? I'm thinking maybe you've got an error in there somewhere that's causing this error. -- Thanks, Warren Selby, dCAP http://www.SelbyTech.com http://www.selbytech.com -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] realtime voicemail asterisk 11
res_config_mysql [general] dbhost = 127.0.0.1 dbname = asterisk dbuser = root dbpass = x dbport = 3306 dbsock = /var/lib/mysql/mysql.sock extconfig.conf voicemail= mysql,asterisk,voicemail_messages right now I'm around trying to rename the table voicemail_messages by asterisk.voicemessages 2013/10/14 Warren Selby wcse...@selbytech.com On Mon, Oct 14, 2013 at 11:13 AM, troxlinux xserverli...@gmail.comwrote: Hi list, I'm trying to put my voicemail on asterisk realtime with 11.XX, generate tables in a couple of files in the folder realtime / mysql , voicemail_messages.sql and voicemail.sql the connection with mysql and odbc works well isql asterisk useradmin xxx +---+ | Connected!| | | | sql-statement | | help [tablename] | | quit | | | +---+ [Oct 14 10:06:16] WARNING[10037][C-0003]: res_odbc.c:645 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 42S02: [MySQL][ODBC 5.2(w) Driver][mysqld-5.6.12]Table 'asterisk.voicemessages' doesn't exist (86) [Oct 14 10:06:16] WARNING[10037][C-0003]: res_odbc.c:657 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk [asterisk]... [Oct 14 10:06:16] WARNING[10037][C-0003]: res_odbc.c:761 ast_odbc_sanity_check: Connection is down attempting to reconnect... [Oct 14 10:06:16] NOTICE[10037][C-0003]: res_odbc.c:1527 odbc_obj_connect: Connecting asterisk [Oct 14 10:06:16] NOTICE[10037][C-0003]: res_odbc.c:1559 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk] [Oct 14 10:06:16] WARNING[10037][C-0003]: app_voicemail.c:5609 messagecount: SQL Execute error! Could you post a sanitized version of your res_config_mysql.conf and extconfig.conf files? I'm thinking maybe you've got an error in there somewhere that's causing this error. -- Thanks, Warren Selby, dCAP http://www.SelbyTech.com http://www.selbytech.com -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users -- rickygm http://gnuforever.homelinux.com -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] realtime voicemail asterisk 11
On Mon, Oct 14, 2013 at 12:19 PM, troxlinux xserverli...@gmail.com wrote: res_config_mysql [general] dbhost = 127.0.0.1 dbname = asterisk dbuser = root dbpass = x dbport = 3306 dbsock = /var/lib/mysql/mysql.sock extconfig.conf voicemail= mysql,asterisk,voicemail_messages First issue I see - you've got the context named [general] in res_config_mysql, but you're attempting to connect to asterisk in extconfig.conf (mysql,*asterisk*,voicemail_messages). The second item in extconfig.conf should match the database context name in res_config_mysql. So either fix res_config_mysql by changing [general] to [asterisk], or fix extconfig.conf by changing the line to voicemail = mysql,general,voicemail_messages. Make whichever change you prefer (I would make the change in res_config_mysql.conf personally, but it's up to you), and then reload asterisk to see if that resolves the error. Otherwise, post whatever you're new error is. -- Thanks, Warren Selby, dCAP http://www.SelbyTech.com http://www.selbytech.com -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] realtime voicemail asterisk 11
thnk Warren , I only see one warning message [Oct 14 13:12:14] WARNING[2736][C-]: app_voicemail.c:3768 retrieve_file: SQL Get Data error! coltitle=category [SELECT * FROM voicemessages WHERE dir=? AND msgnum=?] 2013/10/14 Warren Selby wcse...@selbytech.com On Mon, Oct 14, 2013 at 12:19 PM, troxlinux xserverli...@gmail.comwrote: res_config_mysql [general] dbhost = 127.0.0.1 dbname = asterisk dbuser = root dbpass = x dbport = 3306 dbsock = /var/lib/mysql/mysql.sock extconfig.conf voicemail= mysql,asterisk,voicemail_messages First issue I see - you've got the context named [general] in res_config_mysql, but you're attempting to connect to asterisk in extconfig.conf (mysql,*asterisk*,voicemail_messages). The second item in extconfig.conf should match the database context name in res_config_mysql. So either fix res_config_mysql by changing [general] to [asterisk], or fix extconfig.conf by changing the line to voicemail = mysql,general,voicemail_messages. Make whichever change you prefer (I would make the change in res_config_mysql.conf personally, but it's up to you), and then reload asterisk to see if that resolves the error. Otherwise, post whatever you're new error is. -- Thanks, Warren Selby, dCAP http://www.SelbyTech.com http://www.selbytech.com -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users -- rickygm http://gnuforever.homelinux.com -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] realtime voicemail asterisk 11
On Mon, Oct 14, 2013 at 2:15 PM, troxlinux xserverli...@gmail.com wrote: thnk Warren , I only see one warning message [Oct 14 13:12:14] WARNING[2736][C-]: app_voicemail.c:3768 retrieve_file: SQL Get Data error! coltitle=category [SELECT * FROM voicemessages WHERE dir=? AND msgnum=?] I'm not sure on this. Hopefully someone else can help. -- Thanks, Warren Selby, dCAP http://www.SelbyTech.com http://www.selbytech.com -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] realtime voicemail asterisk 11
ok , thnk Warren , your help has been invaluable. 2013/10/14 Warren Selby wcse...@selbytech.com On Mon, Oct 14, 2013 at 2:15 PM, troxlinux xserverli...@gmail.com wrote: thnk Warren , I only see one warning message [Oct 14 13:12:14] WARNING[2736][C-]: app_voicemail.c:3768 retrieve_file: SQL Get Data error! coltitle=category [SELECT * FROM voicemessages WHERE dir=? AND msgnum=?] I'm not sure on this. Hopefully someone else can help. -- Thanks, Warren Selby, dCAP http://www.SelbyTech.com http://www.selbytech.com -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users -- rickygm http://gnuforever.homelinux.com -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users