similar to: voicemail with odbc

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:

I have a mixed PBX system with both Asterisk 1.4.21 and 1.2.27 (moving to 1.2.28). For now I need to keep a few boxes in 1.2 and not migrate them all to 1.4. However, I would like to have func_odbc and res_odbc on all servers. On 1.4.21, native func_odbc seems to work fine. On 1.2.27, the func_odbc backport is giving me an error (I know that this backport is not "officially supported"

Hello, Now I'm testing func_odbc and hash. My configurations are: func_odbc.conf [GETNUMBER] dsn=sqlserver ;mode=multirow ;rowlimit=10 readsql=SELECT number,real_number1,real_number2,status FROM ivr.dbo.numbers WHERE number=${SQL_ESC(${ARG1})} extensions.conf exten => s,1,Ringing exten => s,n,Wait(4) exten => s,n,Answer exten => s,n,Set(NUMERIS=37037210602) exten =>

Hi all asterisk 1.8.23 I have odbc all setup to mysql but cant figure out why the dialplan wont write to the odbc function fubc_odbc.conf [DEVICES] dsn=device-conn ;dsn in res_odbc not odbc.ini readsql=SELECT call.callNum, call.city, devices.callId, devices.id FROM call INNER JOIN devices ON call.id = devices.callId WHERE deviceNumber = '${ SQL_ESC(${ARG1})}'

All, Thank you in advance for any help. I have a customer in need of a conferencing system. A requirement is for users to each have their own PIN for the same bridge. So, I put the list of users, PINs bridges into a MYSQL DB and used an ODBC connector to parse the table. Asterisk is connected and reads the rows as expected. The problem is that if a user enters a PIN that is NOT in the table,

All; I am running Asterisk 11.6-cert16 and I have voicemail setup so voicemail messages are sent as email attachments. That works fine. However, the body of the email contains the CallerID(name), but is missing the CallerID(num). For example, the email body looks like this: Just wanted to let you know you were just left a 0:21 long message (number 13) in mailbox 101 from WIRELESS

hello i m using asterisk-1.0.9. i want to connect to db through odbc. isql is working. but asterisk is not getting user information from this table. can any one pls check this /etc/asterisk/extconfig.conf [settings] sipusers => odbc,mysql1,sip_buddies sippeers => odbc,mysql1,sip_buddies sip.conf => odbc,mysql1,sip_buddies sipfriends => odbc,mysql1,sip_buddies

hello i m using asterisk-1.0.9. i want to connect to db through odbc. isql is working. but asterisk is not getting user information from this table. can any one pls check this odbc connection is working properly is there some thing required /etc/asterisk/extconfig.conf [settings] sipusers => odbc,mysql1,sip_buddies sippeers => odbc,mysql1,sip_buddies sip.conf =>

Gentlemen, I have googled, searched the mailing list archives, and even spoke on the IRC channel, but have not found an answer to the following problem. I am attempting to retrieve multiple columns in an ODBC query using ARRAY per the solutions offered by many individuals. My dialplan code is as follows: exten => _.,n,Set(ARRAY(var1,var2,var3)=${ODBC_LOOKUP(${KEYVAL})}) exten =>

I want to let Asterisk read its configuration from a mysql database. I configured everything according to the wiki page: http://www.voip-info.org/tiki-index.php?page=Asterisk+res_config. However it doesn't work. I am using 1.0.8 asterisk version and here are my config files: Extconfig.conf: [settings] ;uncomment to load queues.conf via the db engine. ;queues.conf =>

Nope, I got the stable 1.08 release from cvs. Frank From: "Wei Kun" <wei-kun@mediaring.com> Subject: RE: [Asterisk-Users] Asterisk configuration from database withres_config To: "'Asterisk Users Mailing List - Non-Commercial Discussion'" <asterisk-users@lists.digium.com> Message-ID: <00a301c5a3c5$93384370$6f01010a@corp.mediaring.com> Content-Type:

i have installed the asterisk 1.6 before that installed the necessary packages in Debian, * i followed the steps as follows, root at astserver: ~# apt-get install unixodbc unixodbc-dev odbc-postgresql postgresql-8.1 postgresql-contrib postgresql-dev * then i installed the asterisk 1.6 version with the odbc modules as in the selected list. * then i created the database as asterisk and the user

I agree you however i solved my problem with app_voicemail.c The table scheme provide in doc/README.odbcstorage don't match to sql queries in app_voicemail.c I think developpers who has written app_voicemail.c for ARA provide a useable table ! Regards Harry --- Steve McMahon <voip@digitaldatabits.net> a ?crit : > These questions should be sent to Asterisk-Users > this is not a

I agree you however i solved my problem with app_voicemail.c The table scheme provide in doc/README.odbcstorage don't match to sql queries in app_voicemail.c I think developpers who has written app_voicemail.c for ARA provide a useable table ! Regards Harry --- Steve McMahon <voip@digitaldatabits.net> a ?crit : > These questions should be sent to Asterisk-Users > this is not a

Hello I'm about to set up a voicemail system for multiple wholesale customers. So I use a realtime mysql config for the mailboxes. All single mailboxes have their information about the number, emailaddress, password in the database. This works fine. Now the notification emails of course should be customized per wholesale customer. I added a 'mandate' table to the database and

Hi, In modifying the template for voicemail emails, I can only get ${VM_CIDNUM} to appear in an email. Does anyone know how to get the others to appear? Thanks for your help!

I've been continuing to experiment with MySQL. I'm having absolutely no luck getting asterisk to read voicemail configuration data and mailbox configuration data from mysql tables instead of from voicemail.conf. The default Asterisk setup that reads from voicemail.conf and extensions.conf works fine. I'm using Asterisk CVS-v1-0-12/12/04-15:58:29 on a Whitebox Enterprise Linux box.

Hi ALL, When i was accessing the voice message it suddenly goes dead and after that i couldn't able to retrieve the voicemessage again from my mailbox . This happens once in a while for any configured mailboxes I am using the following system configuration. asterisk 1.4.22.1 odbc storage of voicemail messages centos 5.2 64bit unixODBC-2.2.11-7.1 mysql-connector-odbc-3.51.12-2.2

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

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