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