similar to: Voicemail message storage in db w/o ODBC?

Thank you for your time. I've put my replies to your questions in-line, below. On Wednesday, June 07, 2017 10:19:41 AM Antony Stone wrote: > On Tuesday 06 June 2017 17:54:59 Mike Diehl wrote: > > > Hi all, > > > > I'm upgrading to Asterisk 13.14.0 x86_64. During my beta testing, I've > > discovered that my server crashes as soon as I leave a

Hi all, I'm upgrading to Asterisk 13.14.0 x86_64. During my beta testing, I've discovered that my server crashes as soon as I leave a voicemail message. I'm using odbc voicemail storage as well as mysql dynamic configuration. I'm using unixODBC 2.3.2-r2 with myodbc 5.2.7-r1 I suspect that the odbc drivers are the problem. Is ther an alternative drive that I should be using?

Hi all, I've got a new server up, but it's not staying up.... After a day or so, it segfaults with: [Mar 22 23:17:49] WARNING[12177]: res_odbc.c:1406 _ast_odbc_request_obj2: SetConnectAttr (Txn isolation) returned an error: HY000: [MySQL][ODBC 5.2(a) Driver]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use

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

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

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

Here is something I wrote years ago. I expect you can adjust it for your needs # cat remove_blank_vmail #!/bin/bash # remove_blank_vmail takes arguments as voicemail boxes and removes messages with audio files shorter then MINSIZE (in bytes) #---------------------------------------------------------------------- # Description: # Author: John Harragin Monroe-Woodbury CSD # Created at: Thu Nov 6

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

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

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

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

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