similar to: play greeting from odbc voicemail

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

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",

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'm using Asterisk 1.4.13, the latest released version. The linux platform is FC7. I setup my Asterisk server to use IMAP storage. Dovecot is the IMAP server. Its storing messages perfectly--no problems. I should also mention that I'm using MySQL for real-time configuration. That must be working (at least partially), because I can authenticate v. the voicemail table. However, the

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

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 there, I am configuring a small voicemail server and I am facing the following problem. Executing this command: exten => 1234,1,VoiceMail(${NUMBER}@test) When a user does not have a customized temporary greeting vm-intro message is played asking for the message to the user but when the user has already a temporary greeting both the temporary greeting and vm-intro are played. Basically

Ok. I was sucessful in installing ODBC storage I'm using MySQL in the backend as it is. but all my drivers are now ODBC. I am running asterisk-cvs head as of last night 9/19/05 My question is this... the old voicemail.cgi script that allowed checking voicemail no longer works etc, and never did work for me without a static voicemail.conf file. Anyways.. that aside... how does one retrieve

Before I head down the path of converting voicemail to an ODBC backend, I have a couple questions that I was hoping someone would know. 1. Is the voicemail message stored in the datbase, or just it's location/filename? 2. Does MWI propagate when using an ODBC backend? 3. If it does both of those things, wouldn't it work well for a centralized voicemail system instead of a solution like

Is the storage of actual voicemail messages in a database still limited to ODBC? If so, why? And is the use of mySQL and ODBC at the same time still a bad idea? If so, why? I want to store all of my voicemail stuff in a database so that I can give users web access to it, but I don't want to run web services on my * server itself. If it is all in a DB, I can have a web box and a

Hi all, Is it possible to store voicemail in a Mysql database without using ODBC? I've got RTA sip and voicemail working; I just want to store the messages in the db now. Configuring ODBC seems like a lot of work if I don't have to. TIA. -- Take care and have fun, Mike Diehl.

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

I've checked the wiki, searched the mailing list, Mantis (bug tracker), and looked through the source code, but found not mention of this issue: If using ODBC Storage for voicemail messages, name-playback by app_directory breaks. app_directory has no ODBC Storage code and therefore only looks for the greet.wav file (recording of user's name) in the filesystem, whereas app_voicemail saves

Hello, Upgraded from 1.6.1.0 to 1.6.1.1 and my voicemail setup does not work anymore. I use ODBC storage for voicemail. Comes out that the "voicemessages" table schema should have changed, because the log says Asterisk needed to store data to an additional field called "flag". Any new message cannot be saved. The thing is that I'd like to know where I can find an updated

Running 1.4.26.2 on CentOS 5.3 Using ODBC with mysql for voicemail storage. Everytime my dialplan tries to open a connection to save a message or retrieve a stored message, Asterisk dumps out and restarts with: Asterisk ended with exit status 127 Asterisk died with code 127. Automatically restarting Asterisk. mpg123: no process killed It restarts fine, but still no voicemail. Nothing in a Mysql

Hello guys. Did anybody use voicemail ODBC storage feature? All "voicemessages" fields name are clear except for "dir", which is assigned to "/var/spool/asterisk/voicemail/default/1234/INBOX". Why do we need any directory when we store voicemessages in the database? Noreover, that field is choosen as the KEY or INDEX (marked as MUL in README.odbcsrorage, so I

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

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