[asterisk-users] realtime voicemail asterisk 11

[troxlinux]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20131014/ecdb32ad/attachment.html>