<div dir="ltr">res_config_mysql<br><div><br>[general]<br>dbhost = 127.0.0.1<br>dbname = asterisk<br>dbuser = root<br>dbpass = xxxxx<br>dbport = 3306<br>dbsock = /var/lib/mysql/mysql.sock<br><br>extconfig.conf <br>voicemail=> mysql,asterisk,voicemail_messages<br>
<br><br><span id="result_box" class="" lang="en"><span class="">right now I'm</span> <span class="">around trying to</span> <span class="">rename the table</span> <span class="">voicemail_messages</span> <span class="">by</span> <span class="">asterisk.voicemessages</span></span><br>
</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">2013/10/14 Warren Selby <span dir="ltr"><<a href="mailto:wcselby@selbytech.com" target="_blank">wcselby@selbytech.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr"><div><div class="h5"><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></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>
<br>--<br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br></blockquote></div><br><br clear="all"><br>-- <br>rickygm<br><br><a href="http://gnuforever.homelinux.com">http://gnuforever.homelinux.com</a>
</div>