similar to: CDR to MS-SQL via ODBC issue

Hi all, I'm trying to set up an odbc connection to a ms-sql server from an asterisk 1.6.1 install My problem is that I cannot get asterisk to build func_odbc & res_odbc.so I installed yum -y install unixODBC unixODBC-devel libtool-ltdl libtool-ltdl-devel And then went on to reconfigure / recompile asterisk after a ./configure --with-odbc=/usr/lib/ I get

>> >> >> Hi All, >> >> After getting licences for Skype for asterisk a while ago I finally got >> around to setting up a server with two channels and setting up a bcp on >> the skype end. >> >> The idea behind this is the following: >> >> Users can dial into the PBX, get authenticated and only after> >>

Hi folks, How would I go about running a stored procedure call from asterisk via func_odbc. I'm after an example entry in func_odbc if possible for ast 1.4 Also, if someone could post an insert statement that actually works, would be nice. Thanks, :)

Hi folks, Is there anywhere I can possibly get a model of the exam itself, maybe possible scenarios for the prac, etc? To people who have done the exam....any helpful hints ? Thanks,

Help! I've been using mysql for cdr storage, I need to switch to MS SQL. I must be stupid or something but I cannot figure out how to setup the cdr_tds. I have FreeTDS configured properly, but my unixodbc is not working properly either... I'd be happy with either solution, but I'm in need of assistance. Luke Catranis

Hi, Has anyone made a successfull instalation of cdr_odbc?? I've install unixODBC-2.2.8 (made my own RPM) and then built the module. I'm trying to send the cdrs to a M$ SQL server. The sql connection works because I can do any query via isql. When I do the calls I get the following output on the asterisk console: -- Executing Hangup("SIP/test1-a5e1", "") in new

Hello Everyone, I have an installation where the client has a Microsoft SQL database that holds all of their case information. They would like the asterisk system to require users to enter a valid case number when making an outgoing call. I?m seeing some documentation regarding people using Microsoft SQL for CDR storage, however nothing regarding validating authentication using a Microsoft SQL

"make menuconfig" does not show cdr_odbc as a selectable compile option. I have compiled and installed both unixODBC and freetds from source and have verified both successfully connect to my sql server. Both were installed to standard locations (/usr/lib). I had no problem compiling cdr_odbc on my test server(CentOS 4.6), however following the same steps on my production server (CentOS

On 12/05/2018 05:00 PM, Antony Stone wrote: > On Wednesday 05 December 2018 at 15:31:38, hw wrote: >> I don't see a table for that. > > You need to create that for yourself. > > Asterisk can write to database tables, but doesn't help you set them up, for > reasons I can't comment on. How do I know what the schema needs to be? Does anybody have a scheme for

Hello, We installed AsteriskNOW (Asterisk version 1.6.2.19) and purchased FFA and G.729 licenses and installed them successfully. When we tried to install asterisk addons (we need the CDRs), we get license conflict error messages. Searching google, we see that there's a way to force install the addons, but that "way" isn't properly detailed, so we didn't manage to do it.

Hi, is cdr logging using odbc buggy? I'im only getting an error "cdr_odbc.c:174 odbc_log: Unable to retrieve database handle. CDR failed.". Connecting with isql to the datasource given in cdr_odbc.conf works just fine, and using the database for sippeers also works. The documentation[1] is confusing because it says freeTDS is required and that you must not use multiple

Hi all, The asterisk book states the following for using ODBC to connect to an MS database. ? The pooling and limit options are quite useful for MS SQL Server and Sybase databases. These permit you to establish multiple connections (up to limit connections) to a database while ensuring that each connection has only one statement executing at once (this is due to a limitation in the protocol

svn trunk. I'm trying to get cdr to work with my odbc database. I have followed a checklist that I had previously but still can't get it to work. There are no errors (verbose 40 and debug 40), I get [cdr_odbc.so] => (ODBC CDR Backend) == Parsing '/etc/asterisk/cdr_odbc.conf': Found *CLI> cdr status CDR logging: enabled CDR mode: simple CDR registered backend:

Hi guys, Having issues with doing an insert statement using ast 1.4.24: [START] dsn=mssql-asterisk write=INSERT INTO testdb (callarrival,callerid) VALUES ('${VAL1}','${VAL2}') SET(ODBC_START()${TIMESTAMP},${CALLERID(num)}) No errors pop up on execute, but nothing gets inserted. Read and update work fine, Wondering where I'm going off track with this, Thanks,

Hi guys, Anyone done this with CentOS and asterisk 1.4? thanks

Just finished with the instructions from digium website/ net on how to compile FFA: After restart, modules did not get loaded so tried to load manually: [Dec 18 14:31:26] WARNING[11002]: loader.c:359 load_dynamic_module: Error loadin ile: No such file or directory [Dec 18 14:31:26] WARNING[11002]: loader.c:653 load_resource: Module 'res_fax.so Verified the files exist: astbh00*CLI>

> I'd suggest try recording in ulaw first and then convert all to wav after. > It may have something to do with timing since you're using iax, what are you using as a timing source? Hardware or software? > Sent from my iPhone -------------- next part -------------- An HTML attachment was scrubbed... URL:

I am wondering what the best solution is for initiating a call from Outlook Contacts. I imagine something that would start the call from the outlook card (or similar) and then dial the user's extension and the contact's phone number and place them in a bridge. Anyone use something like this? Travis Ryan Director of Information Technologies Oscar Winski Company 2407 North Ninth Street

Hi, I am trying to get * log to mssql server. I have odbc and freetds configured, but my insert query is missing calldate which is a NOT NULL field in database schema. cdr_adaptive_odbc: Insert failed on 'sqlserver:cdr'. CDR failed: INSERT INTO cdr (clid,src,dst,dcontext,channel,lastapp,lastdata,duration,billsec,disposition,amaflags,uniqueid) VALUES

Hello, we are migrating an Asterisk install from Trixbox/Asterisk 1.2 to Elastix 0.92 with asterisk-1.4.17 on CentOS 5. I need to migrate an funtion that consults a remote sybase database, using ODBC and freetds. On the new server I am able to connect to the database using isql without problems. When I try to connect from asterisk logs show: pbx.c: Function ODBC_SQL not registered Indeed I