<div dir="ltr"><div class="gmail_extra"><div class="gmail_quote">On Mon, Oct 14, 2013 at 11:13 AM, troxlinux <span dir="ltr"><<a href="mailto:xserverlinux@gmail.com" target="_blank">xserverlinux@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><span lang="en"><span>Hi </span><span>list, I'm</span> <span>trying to</span> <span>put my</span> <span>voicemail</span> <span>on</span> <span>asterisk</span> <span>realtime with</span> <span>11.XX</span><span>, generate</span> <span>tables in a</span> <span>couple of</span> <span>files in</span> <span>the folder</span> <span>realtime /</span> <span>mysql</span></span> , voicemail_messages.sql and voicemail.sql <br clear="all">


<br><span lang="en"><span>the connection with</span> <span>mysql</span> <span>and</span> <span>odbc</span> <span>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></div></blockquote></div><br><br></div><div class="gmail_extra">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.<br>
<br><br><div><div dir="ltr">--<br>Thanks,<br>Warren Selby, dCAP<br><a href="http://www.selbytech.com" target="_blank">http://www.SelbyTech.com</a><br></div></div>
<br></div></div>