similar to: Test CVS HEAD Voicemail ODBC Storage

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

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

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

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

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

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

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

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

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?

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

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

Seems like other postings tend to think that saving recordings as files and not as blobs in the database are a more reliable way to go. Opinions on this? Looking at supporting it for ARI and judging interest. Dan 512.791.0137 www.littlejohnconsulting.com

Way back in the mists of time, I built my asterisk installation with SNMP support. It's a bit tedious to get the sub-agent for snmpd set up but once you have it you can poll the OID for the asterisk sub-agent and it will tell you how many calls are up at that moment in time. That said, I actually prefer ARA/ARI to flat file configuration of endpoints and dialplans.  Changes are more or less

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

Hi list, yesterday I converted my voicemail.conf to realtime voicemail and also configured to store the voicemessages in a database using odbc as described here <http://www.voip-info.org/wiki/view/Asterisk+RealTime+Voicemail> and here <http://www.voip-info.org/wiki/view/Asterisk+Voicemail+ODBC+storage>. I am using asterisk 1.4.2 with mysql. I also installed the proper odbc driver for

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

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