similar to: ODBC Voicemail storage and app_directory

I current have a working Asterisk 1.2.12 server with ODBC voicemail storage, realtime static maps for voicemail, sip and iax configuration files. Realtime extensions, etc. All works great. I have verified that this configuration works on my test server as well. Now I am trying to test the 1.4B3 version on the same test server, and all works well except for ODBC voicemail. I am using the same

As we are getting closer to release of CVS head as version 1.2, we're in need of your help. One of the cool new features in CVS head is the ability to store the actual voicemail messages in a database. This is not using ARA, the Asterisk Realtime Architecture, but directly interfaces with ODBC from app_voicemail. It stores both meta data and audio in the database, which will give you real

Hi, I have a strange problem. I'm using Asterisk 1.4.xx with ODBC storage (FreeTDS -> Mssql 2008 database). Everything it's working fine, but sometimes I receive this error and Asterisk crashes. [Aug 25 13:25:13] WARNING[14032] app_voicemail.c: SQL Prepare failed![SELECT COUNT(*) FROM pbx_VoiceMail WHERE dir = '/var/spool/asterisk /voicemail/default/7002/INBOX'] [Aug 25

If you run CVS HEAD, and are using ODBC storage for voicemail, please apply and test the patch from bug 3024 in Mantis. This patch should _not_ change the behavior of your system at all, and that's what needs to be tested. If you can try it, please report the results in the bugnotes. Thanks!

Hi, I'm having a bit of a problem with storing voicemail messages in an odbc database. I *think* I've got everything configured correctly but messages are stored on the asterisk server instread of in the database. System info 64 bit redhat RHEL 5.1 Asterisk 1.4.26 unixODBC installed used makemenuselect to instal res_odbc and cdr_odbc Back end database DB2 Database name voiceml

Hi, I'm wondering whether or not I should go for ODBC or IMAP voicemail storage. Before diving into details, I would be very pleased to get input form others. 1. With IMAP, is it necessary to save a copy of voicemails in /var/log files so that a user can still listen to his (or her) own voicemails with his own hardphone ? 2. How then, can you make sure to skip non-voice mails stored in the

Hi all, We have an asterisk installation here that uses realtime for voicemails through ODBC. It works very well except that every now and then (ie four or five days or so) it breaks. I have included a log from the CLI of the most recent break, it looks like this: ---------------- Start of output -- Executing Dial("SIP/sip.ict.ru.ac.za-b7721690",

Hey gang, I've been using * with voicemail-mysql for a few weeks. Works like a charm. Even wrote a nice php web interface to let users check, play and download their messages. Recently found out that if you use mysql-voicemail then you CAN NOT use app_directory as app_directory reads its information from voicemail.conf. If you are using mysql-voicemail, then there aren't any entries in

Hi, I have some issue with voice mail with ODBC on asterisk 11.7 box. I may not understand database functionality on asterisk fully. The most suspected area is func_odbc. I already googled but not luck. Your guide is warmly welcomed *Error messages when I make call and leave message.* -- <SIP/1ffa9-00000007> Playing 'auth-thankyou.g722' (language 'en') [2014-05-28

I have Asterisk 1.4.32 and I would like save all VoiceMail to MSSQL 2008 database. I configured ODBC, but I receive this errors. [Jun 18 14:00:37] NOTICE[19914] res_odbc.c: Connecting sqlserver [Jun 18 14:00:37] NOTICE[19914] res_odbc.c: res_odbc: Connected to sqlserver [kupalaodbc] [Jun 18 14:00:37] WARNING[19914] app_voicemail.c: SQL Prepare failed![SELECT COUNT(*) FROM pbx_VoiceMail

I am running CentOS 5 with Asterisk 1.4.14. I am trying to setup storage of voicemail messages into MySQL. It is my understanding that I can only do this via ODBC. I installed per http://www.voip-info.org/wiki/view/CentOS+5+and+Asterisk+1.4.x+installation unixODBC unixODBC-devel libtool-ltdl libtool-ltdl-devel and mysql-connector-odbc. I reconfigured and built Asterisk, using menuconfig to

Hello, I am using ODBC storage for the message deposited through voicemail() application. Everything works fine for the audio message if the format given in voicemail .conf is any audio format . e.g. in voicemail.conf give the format as format=gsm This case works fine. But if I give the following format in voicemail.conf format=h263|gsm And no video codec is sent from the

Hi, Is there any reason why ODBC voicemail storage requires varchar for most fields? For example, is there anything stopping me using a BIGINT or similar for origtime or INT for duration? Kind regards, Dan

Hi I was trying to have realtime voicemail working with ODBC Driver. Everything works fine with MySQL Realtime access, BUT as I want to implement ODBC Storage as well, it seems that everything should go through ODBC ( what I read on voip-info wiki page ) But I do not manage to make it work with ODBC. Outside Asterisk, ODBC works fine, I can access my databases & tables ! Asterisk fails to

Hello, On a Debian Buster instance, I compiled Asterisk 17.3.0 from source. I enables all 3 File, IMAP and ODBC voicemail modules but I'm still using classical File module (in modules;conf and voicemail.conf): cd asterisk-17.3.0 ... make menuselect.makeopts menuselect/menuselect --enable app_voicemail_imap menuselect.makeopts; done menuselect/menuselect --enable app_voicemail_odbc

I have been testing with asterisk 1.4.11 and have found a segmentation fault while using voicemail. It happens when I try to forward a voicemail. As soon as I press the option the server crashes. I ran asterisk up inside gdb and got the following stack trace ==================================================================== Program received signal SIGSEGV, Segmentation fault. 0x00140adf in

hi all, I can not get voicemail working in realtime with asterisk-1.2.6. extconfig.conf is correct voicemail => odbc,asterisk,voicemail_users i am getting the fallowing error Executing Answer("SIP/xx.xx.xx.xxx-0a02e1c0", "") in new stack -- Executing Set("SIP/xx.xx.xxx-0a02e1c0", "foo=102") in new stack -- Executing

Hi All, I have an issue on voice mail with odbc in asterisk 11.7 box. Voice message can be received through Google mail but it doesn't show in phone. The error messages is as follow and let me get your kind advice. -- <SIP/0015-00000007> Playing 'auth-thankyou.g722' (language 'en') [2014-05-28 14:55:13] DEBUG[12260][C-00000006]: app_voicemail.c:3824 last_message_index:

Hello, I have moved from Asterisk 1.0.7-BRIstuffed-0.2.0-RC7k (debian pkg) to CVS-HEAD, and realtime. Compiled no problem and now running, with realtime extensions and sip users in postgres (ODBC connection) database, trunking also works. I have looked on google, wiki, and this mailing list, along with talking to some peers, but to no avail. My problem revolves around voicemail. I have looked

Hi All, I have an issue with the ODBC voicemail storage option with asterisk. All appears to work fine, however, I get several sql execute warnings. I was wondering if anyone out there could help me get to the bottom of what is causing this and how I could possibly go about rectifying it. The warning message we are getting is as follows: WARNING[30115]: app_voicemail.c:1280 delete_file: SQL