similar to: Asterisk ODBC Insert issue

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

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

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, Are all the astricon presentations up? I'm especially after the one that tilghman did. I caught the tail end of the prez when I decided to skip the session I was attending and go for that one. :)

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

Hello, Does asterisk func odbc support multi query? I'm executing stored procedure which returns two tables. With tsql command I can see both tables. But asterisk only shows the first. My database is MSSQL. Maybe there is workaround... Thanks -- Best Regards, Giedrius -------------- next part -------------- An HTML attachment was scrubbed... URL:

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

Hi everybody I have a logic question that is confusing me. ifTime(00:00-12:00|*|*|*) { Playback(welcome-morning); } else { ifTime(12:00-18:00|*|*|*) { Playback(welcome-afternoon); } else { Playback(welcome-evening); }

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

Hello everybody, I have tried to connect to external databases (specifically, to a MS Access database in my computer) from R using the RODBC package. Unfortunatelly I haven't been able to do it, even if I 'followed' the instructions in the manual. COuld someone please help me? I have a MS Access database in my computer and I went to the control panel in order to create a DSN file

Hi All Just finished setting up a vm with centos 5.5 and asterisk 1.8.3 Using timerfd as a timing source. Has anyone got a similar setup in production ? How's performance? Thanks, Neeraj?

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 authentication get access to internal PBX extensions. I CAN do this with a PIN, no sweat, but from a user perspective it

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

Hello, I'm trying to execute a stored procedure on a MSSQL Server from the dial plan, but it's not working. I'm getting the following error: Unable to execute query.... Asterisk has been compiled with UnixODBC, and I've done the necessary configurations in func_odbc, res_odbc and odbc.ini. Has anyone done this before with success? -------------- next part -------------- An HTML

Hi all, I am testing with Asterisk 1.8.0 beta3 using realtime with a mssql server using freetds and unixodbc, which works with 1.6.1.20. With the same config in 1.8 I get an error when trying to start asterisk which says: [Aug 23 15:06:12] WARNING[7180]: loader.c:387 load_dynamic_module: Error loading module 'res_config_odbc.so': /usr/lib/asterisk/modules/res_config_odbc.so: undefined

Hi guys, I'm trying to write hangup causes from asterisk into the CDR record. Using version 1.4.24.1 at the moment, but no joy so far. Has anyone implemented this?