<div dir="ltr"><span id="result_box" class="" lang="en"><span class="">Hi </span><span class="">list, I'm</span> <span class="">trying to</span> <span class="">put my</span> <span class="">voicemail</span> <span class="">on</span> <span class="">asterisk</span> <span class="">realtime with</span> <span class="">11.XX</span><span>, generate</span> <span class="">tables in a</span> <span class="">couple of</span> <span class="">files in</span> <span class="">the folder</span> <span class="">realtime /</span> <span class="">mysql</span></span> , voicemail_messages.sql and voicemail.sql <br clear="all">

<br><span id="result_box" class="" lang="en"><span class="">the connection with</span> <span class="">mysql</span> <span class="">and</span> <span class="">odbc</span> <span class="">works well</span></span><br><br>isql asterisk useradmin xxx<br>

+---------------------------------------+<br>| Connected!                            |<br>|                                       |<br>| sql-statement                         |<br>| help [tablename]                      |<br>

| quit                                  |<br>|                                       |<br>+---------------------------------------+<br><br><br><br>[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)<br>

[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]...<br>[Oct 14 10:06:16] WARNING[10037][C-00000003]: res_odbc.c:761 ast_odbc_sanity_check: Connection is down attempting to reconnect...<br>

[Oct 14 10:06:16] NOTICE[10037][C-00000003]: res_odbc.c:1527 odbc_obj_connect: Connecting asterisk<br>[Oct 14 10:06:16] NOTICE[10037][C-00000003]: res_odbc.c:1559 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk]<br>

[Oct 14 10:06:16] WARNING[10037][C-00000003]: app_voicemail.c:5609 messagecount: SQL Execute error!<br><br><br><span id="result_box" class="" lang="en"><span class="">any help is</span> <span class="">appreciated</span><span class="">!</span></span><br>

<br><br><br>-- <br>rickygm<br><br><a href="http://gnuforever.homelinux.com">http://gnuforever.homelinux.com</a>
</div>