[asterisk-users] realtime voicemail asterisk 11

troxlinux xserverlinux at gmail.com
Mon Oct 14 12:19:44 CDT 2013


res_config_mysql

[general]
dbhost = 127.0.0.1
dbname = asterisk
dbuser = root
dbpass = xxxxx
dbport = 3306
dbsock = /var/lib/mysql/mysql.sock

extconfig.conf
voicemail=> mysql,asterisk,voicemail_messages


right now I'm around trying to rename the table voicemail_messages by
asterisk.voicemessages


2013/10/14 Warren Selby <wcselby at selbytech.com>

> 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>
>
>
> --
> _____________________________________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
> New to Asterisk? Join us for a live introductory webinar every Thurs:
>                http://www.asterisk.org/hello
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
>



-- 
rickygm

http://gnuforever.homelinux.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20131014/f215ec86/attachment.html>


More information about the asterisk-users mailing list