Realtime Voicemail Asterisk 11

Home » Asterisk Users » Realtime Voicemail Asterisk 11
Asterisk Users 6 Comments

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!

any help is appreciated!

6 thoughts on - Realtime Voicemail Asterisk 11

  • 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.

  • 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

  • First issue I see – you’ve got the context named [general] in res_config_mysql, but you’re attempting to connect to asterisk in extconfig.conf (mysql,*asterisk*,voicemail_messages). The second item in extconfig.conf should match the database context name in res_config_mysql. So either fix res_config_mysql by changing [general] to [asterisk], or fix extconfig.conf by changing the line to “voicemail =>
    mysql,general,voicemail_messages”.

    Make whichever change you prefer (I would make the change in res_config_mysql.conf personally, but it’s up to you), and then reload asterisk to see if that resolves the error. Otherwise, post whatever you’re new error is.

  • thnk Warren , I only see one warning message

    [Oct 14 13:12:14] WARNING[2736][C-00000000]: app_voicemail.c:3768
    retrieve_file: SQL Get Data error! coltitle