res_config_mysql [general] dbhost = 127.0.0.1 dbname = asterisk dbuser = root dbpass = xxxxx 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.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-00000003]: 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-00000003]: 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-00000003]: res_odbc.c:761 >> ast_odbc_sanity_check: Connection is down attempting to reconnect... >> [Oct 14 10:06:16] NOTICE[10037][C-00000003]: res_odbc.c:1527 >> odbc_obj_connect: Connecting asterisk >> [Oct 14 10:06:16] NOTICE[10037][C-00000003]: res_odbc.c:1559 >> odbc_obj_connect: res_odbc: Connected to asterisk [asterisk] >> [Oct 14 10:06:16] WARNING[10037][C-00000003]: 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