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! 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