[asterisk-users] realtime voicemail asterisk 11

[Warren Selby]

On Mon, Oct 14, 2013 at 11:13 AM, troxlinux <xserverlinux at gmail.com> wrote:

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

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.


--
Thanks,
Warren Selby, dCAP
http://www.SelbyTech.com <http://www.selbytech.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20131014/cc4106a8/attachment.html>