similar to: res_odbc not working

Hi. I can't figure this one out. Hope someone can help me. root@pbx:# cat /etc/odbc.ini [Asterisk] Description=PostgreSQL asterisk Driver=PostgreSQL Trace=No TraceFile=/tmp/odbc.log Database=asterisk ServerName=localhost UserName=XXXX Password=XXXX Port=5432 Protocol=7.4 ReadOnly=No RowVersioning=No ShowSystemTables=Yes ShowOidColumn=Yes FakeOidIndex=Yes ConnSettings=

Hi, Can somebody tell me what I've been doing wrong for the res_config_odbc not to work properly. I already looked on the mailing list for some answer but I can't find one. The closes subject I found is "res_odbc not working". Btw, I already followed BKW reply on that subject. I guessed the log below can tell us res_odbc.so is succefully loaded, so it easy to presumed it

Has anyone had any luck with PostgreSQL and Realtime? The realtime instructions on voip-info seem pretty straight forward... just not woking for me. I've included all of my config files below, and my console output. Entire console bootup output: [root@abox asterisk]# /usr/sbin/asterisk -vvvvvvc == Parsing '/etc/asterisk/asterisk.conf': Found == Parsing

Hi, I have remove the comment defor res_odbc.so and res_config_odbc.so in my modules.conf, but the module is still not loading when I do: module show like odbc I have o module returned anybody knows why? -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20090127/0963b5a4/attachment.htm

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

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

I use realtime on my asterisk installation. I have always used mysql for my realtime connection but as mysql seems to be on the "soon to be deprecated" list of asterisk features I am trying to move to ODBC (still using MariaDB/Mysql on backend). I find ODBC support in Asterisk very unstable. Just today my asterisk server (a test server and a production server) has crashed often

I'm doing an upgrade from Asterisk 11 to 13. I'm following the guide at https://wiki.asterisk.org/wiki/display/ast/setting+up+PJSIP+REaltime to setup realtime, as I use realtime on Asterisk 11 too. I'm getting the following error when trying to connect the peer to the server. Help? :) Thanks, Travis [Jun 15 16:20:03] NOTICE[5116] res_odbc.c: res_odbc: Connected to laf [laf] [Jun

I am trying to get cdr via odbc to work on Asterisk 13.7.2 but I keep getting this error: [Feb 9 16:21:43] WARNING[2088]: cdr_odbc.c:160 execute_cb: cdr_odbc: Error in ExecDirect: -1, query is: INSERT INTO cdr (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode,uniqueid,userfield,peeraccount,linkedid,sequence) VALUES ({ts

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

If someone could explain me this (added some extra debugging code Mar 10 00:47:13 NOTICE[7561]: chan_sip.c:8448 handle_request: Registration from '<sip:a7@domain>' failed for '172.20.41.7' Mar 10 00:47:13 WARNING[7561]: res_config_odbc.c:97 realtime_odbc: SQL param name is a7 Mar 10 00:47:13 WARNING[7561]: res_odbc.c:90 odbc_smart_execute: SQL Execute error! Attempting a

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

Hello all! My basic problem is that we haven't been able to get realtime to use ODBC to store configuration data. Here are the details: We've installed Asterisk on a CentOS machine as follows: 1. Downloaded, compiled, and installed FreeTDS 0.63 2. Downloaded, compiled, and installed unixODBC 2.2.11 3. Downloaded, compiled, and installed Asterisk, Asterisk-Addons, and Zaptel from CVS

Hi, I am trying to log queue_log to odbc (MS SQL) I have res_odbc.conf configured and modules.conf have preload => res_odbc.so preload => res_config_odbc.so extconfig.conf has queue_log => odbc,asterisk. When I start asterisk I get the following messages. The important one being: Realtime mapping for 'queue_log' found to engine 'odbc', but the engine is not available

Hi there, admittedly this is a slightly aged RH system. ;-> Yet what I'd like to know is if this compile problem is clearly due to the gcc version, or if there is a way to solve the issue...? Cheers, Philipp [root@box src]# gcc -v Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 20000731 (Red Hat Linux 7.2 2.96-112.7.2) [root@box src]# rpm -q unixODBC

Dear list, i have a issue Asterisk crash (Module res_odbc exactly) after the same log who is "/ERROR[23805] astobj2.c: bad magic number.../" you will see on the log : Today [2016-02-24 16:00:38] ERROR[23805] *astobj2.c: bad magic number 0x552f302e for 0x7fe3505b3958* [2016-02-24 16:00:44] Asterisk 11.2-cert1 built by root @ Voice_server on a x86_64 running Linux on 2013-04-09

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.

I am trying to resolve a problem where grandstream phones (only) fail to register after a period of time. I have a mysql realtime setup that appears to work, but fails for no reason. before i classify the realtime system as unusable, I am trying to isolate the problem. One thing I have noticed is the odbc driver continues to load even though I have removed (from what I can tell) references to