similar to: Voicemail, SQL & ODBC

Does anybody have realtime queue members working? Not the queues themselves, just the members. I have realtime working for voicemail and sippeers, but I can't get queue members to work. Here is what I have: res_mysql.conf: [general] dbhost = 127.0.0.1 dbname = ASTERISK dbuser = myuser dbpass = mypass dbport = 3306 dbsock = /tmp/mysql.sock queues.conf: [general]

Hi All, I'm using asterisk 1.2.9.1 and mysql 3.23, asterisk add-ons 1.2.3. All seems to work normally with realtime voicemail, reads vmbox parameters from the db fine. When I try to change the password, asterisk operates normally, "enter new password" ok, "re-enter new password" ok, "password has been changed" There are no entries in the mysql.log setting 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

We've had a few people complain that the "beep" before leaving a voicemail is not loud enough and too short. Does anybody have a recorded beep that they can share, that is a little louder and a little longer? We've had this box in production for 2+ years, so I hate to mess with the gain on the PRI or anything like that because everything else works fine. I know nothing

Is there any way to see the called number when a call gets redirected to the 'a' extension from voicemail? Say x123 calls x456 and it rolls to voicemail. x123 hits * and gets dumped into the 'a' extension in the original context. I need some logic in 'a' to do a database lookup based on the original called number (x456). Any ideas? When I do a test, it appears

Our asterisk server has been up and running for over a year and it works great. I have emails going to my account as an attachment and I can listen to them on the desktop and it works fine. I just got a T-Mobile MDA that runs Windows Pocket (or whatever they call it) and it can check email. If I have it download the email, it gets the attachment, but it can't seem to play it (it CAN

I know that you can set it up to where a user hits 0 from their mailbox and goes to an operator, but can you set up other options as well? Could I have 0 for an operator and 1 to go to another extension? I know you can do this by building an AA, but I don't want to have to do that for every user as there are about 40 people that want this. They won't all go to the same number.

Is anybody using 1.2 (or 1.2.1) in a production network using Realtime (voicemail, sip or extensions) with 100+ SIP phones? If so, what are your experiences? We've been running 1.0.3 for about a year and it's been rock-solid. We'd like to upgrade to Realtime and 1.2, but I'm afraid of killing our stability. Obviously, we'd do it in stages (upgrade to 1.2, then realtime

I am using realtime on two boxes, one running 1.4.10.1 and one running 1.4.11. Everything works fine except for when I make a database change, such as a phones password. I change the DB, I prune the peer, I see it is gone and then I see it show up again in "sip show peer xxxx", but everything is not being updated. The phone will not register even though the DB and the phone have

I''m having an error from Linux via freeTDS/ODBC to SQL Server with cod that runs fine against SQLite and MySQL. Here''s the code: def find_recipes_for_workorder_by_id @recipe_pages, @recipes = paginate_with_sort :recipes, :per_page => 10, \ :conditions => ["recipe.workorder_id = ?", params [:workorder]] render :template =>

Hi guys, Having issue with getting CDR to write to MS-SQL via ODBC. > cdr_odbc: Connected to freetds-connector > cdr_odbc: Error in PREPARE -1 > cdr_odbc: Query FAILED Call not logged! == Spawn extension (cisco, ##########, 2) exited non-zero on 'IAX2/astYYYY-507 Isql test: [xxx at YYYY asterisk]# isql freetds-connector XXXXXXX YYYYYYYYY

I am running 1.4.10.1. I have a macro that is called from default for a certain extension (both below). I added NoCDR to s to try and stop extra CDR records, but I am still getting them. Any idea how to stop them? extensions.conf: [macro-STDEXT] exten =s,1,NoCDR() exten =s,2,Dial(${ARG1},30,Tt) exten =s,3,Goto(s-${DIALSTATUS},1) exten =s-NOANSWER,1,Voicemail(${ARG2}|u) exten

I am in the process of setting up several * servers using realtime and connecting to mysql. I am trying to figure out if I should just use one database and one set of tables for all of the user data. Or if I should have separate databases for each * box. The boxes are independent of each other in that customerA only connects to box A. They will never fail over to box B or anything like

I am trying to configure RealTime Voicemail with MySQL. I downloaded compiled and installed the CVS HEAD for asterisk, and for asterisk-addons. MySQL seems to be loading correctly (the cdr table is recording incoming calls). But the RealTime Voicemail doesn't seem to be checking the database table for the voicemail users. When trying to login to voicemailMain if I use a user in the

Hello I am having trouble setting up the cdr_odbc with MSSQL server. Has anybody done this? I have followed what little documentation I can find. Asterisk errors on a connection error, but tcpdump doesn't even show an attempt. Does anybody have some examples for MSSQL ODBC CDR? I've downloaded unixODBC and the FreeTDS project, recompiled asterisk.... Thanks Duane Cox --------------

I have followed the cookbook on http://wiki.rubyonrails.org/database-support/ms-sql but am having problems with the rails part. I can connect to the database using sqsh so I think all the freetds plumbing is good. When I try to connect to the db with a rake db:migrate or just using script/ console I get this error: >> Client.find(:first) DBI::InterfaceError: Unable to load driver

I have a project that is requiring the use of MS SQL from asterisk. I get an error when the pjsip contact tries to update the contact table. [Oct 15 21:34:55] WARNING[3033]: res_odbc.c:649 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 22018: [FreeTDS][SQL Server]Conversion failed when converting the varchar value '3.000000' to data type int. (101) The datatype

Hi, i?m trying to access a MSSQL server (in a windows machine in the network) from a Visual Basic Application running under wine, using an ODBC driver. Since there aren?t any MSSQL drivers for linux i decided to use de native ones, so i installed mdac_typ.exe . Then i configured the DSN using odbcad32.exe but when i tested the connection (configured using tcp/ip) an error message appeared

Hello, I decided to embrace getting a new Rails application to see an existing MSSQL database and trying to get unixODBC, freeTDS, and ActiveRecord able to query my MSSQL database. I''m following the procedure outlined at http://wiki.rubyonrails.org/rails/pages/HowtoConnectToMicrosoftSQLServerFromRailsOnLinux but my system (Ubuntu 8.10 - Intrepid Ibex, Rails 2.3, Ruby 1.8.7)

How does the g729 encoder/decoder count in regards to the total number of licenses and how does it count an encoder/decoder? I looked on the wiki and don't really see anything that explains it. In other words, how do the calls below count (assume no reinvite)? g729 phone calls into voicemail g729 phone calls g711 phone g729 phone calls other g729 phone