similar to: ODBC Connection failed

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

Hello, I get some problem installing asterisk + ekiga on my debian etch: ii asterisk 1.2.13~dfsg-2 Open Source Private Branch Exchange (PBX) ii ekiga 2.0.3-4 H.323 and SIP compatible VOIP client $: asterisk -U asterisk -vgc give me some WARNING like : ,---- | WARNING[21806]: res_musiconhold.c:852 moh_register: Unable to open | pseudo channel for timing... Sound

When I try and start asterisk I get the following, however I have commented out the data the connections in res_mysql.conf and res_pgsql.conf. I am not sure therefore why I am getting these errors. Do I have to change something else to turn this off? Thanks Asterisk 1.4.21.2~dfsg-3, Copyright (C) 1999 - 2008 Digium, Inc. and others. Created by Mark Spencer <markster at digium.com> Asterisk

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 All I have dozens of these messages on CLI complaining about database connection and error writing CDR to disk. The curious thing is I can find them all inside the database. I "selected" them using uniqueid and manually compared each column with the cdr_adaptive_odbc.c error line. "mysqlcheck -a -e -v DBase" and "mysqlcheck -c -e -v DBase" both returned OK for

On Sat, 25 Apr 2015 17:11:34 +0200 jg <webaccounts173 at jgoettgens.de> wrote: > > > Hi All > > > > I have dozens of these messages on CLI complaining about database > > connection and error writing CDR to disk. > > > > The curious thing is I can find them all inside the database. > > I "selected" them using uniqueid and manually

Hi, ? I am trying to store queues.conf to a MySQL database using dynamic realtime. I have a working ODBC connection and the queueing system already works but I want to store the queues.conf file to a database. I am following the guide from Asterisk the definitive guide, the ebook can be found at: http://ofps.oreilly.com/titles/9781449332426/asterisk-DB.html ? I have a database called asterisk

Hi list, I'm trying to put my voicemail on asterisk realtime with 11.XX, generate tables in a couple of files in the folder realtime / mysql , voicemail_messages.sql and voicemail.sql the connection with mysql and odbc works well isql asterisk useradmin xxx +---------------------------------------+ | Connected! | | | |

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

Hi all, I'm new to asterisk. I have it installed and 1 x100p card. I'm trying to use kphone to connect out. But, when I start * it gives me sound card busy error. I've checked ps aux and nothing seems to have the sound card. Any ideas? Does starting asterisk automatically take the sound card? Also, can you use the phone connected into the XFO card w/ asterisk or do you need an XFS card

Hi. I have an Asterisk 13.14.1 setup which uses ODBC to write CEL and CDR records. The connection to my database server depends on a VPN tunnel being up, and if Asterisk starts before that tunnel is functional, I get messages such as the following in the Asterisk log file: [2020-06-23 10:40:22.384335] delta WARNING[1697]: res_odbc.c:958 in odbc_obj_connect: res_odbc: Error SQLConnect=-1

I have been playing with res_odbc in these last days, but it doesn't want to work. This is the output when starting Asterisk, so everything seems OK: [res_odbc.so] => (ODBC Resource) == Parsing '/etc/asterisk/res_odbc.conf': Found Jul 7 20:11:32 NOTICE[-1084915040]: res_odbc.c:132 load_odbc_config: registered database handle 'mysql' dsn->[MySQL-asterisk] Jul 7

Hello, I'm stuck with getting cdr records stored in MySql database. I have a working realtime environment and have verified that the db connection works fine when used via res_config_mysql.conf. I'd appreciate Your help on how to get the odbc connector working as I think there's something wrong with its configuration. The problem presented itself as an error when making a call that

Hi, ? I want queues.conf to be stored on a MySQL database using dynamic realtime. I am using asterisk 11.2.1 and?MySQL 5.1.67, the?MySQL database is hosted on?another server but?I can access the?database via ODBC. ? I have created the following tables: ? SQL> show tables; +-----------------------------------------------------------------+ |

Anyone have any idea what this is talking about. Here is my zapata.conf [channels] switchtype=5ess signalling=pri_cpe echocancel=yes echocancelwhenbridged=yes echotraining=400 callerid=asreceived group=1 context=default musiconhold=default faxdetect=incoming channel => 1-23 Here is my zaptel.conf span=1,1,0,esf,b8zs bchan=1-23 # set this to 1-15,17-31 for E1 dchan=24 # set this to 16 for

Hi, I have been experimenting with CEL in a trunk version of asterisk for some time and have upgraded my test machine to 1.8.0 today. Made a few calls and it looks like the eventtype field is missing in the CEL insert query when using ODBC. I see the following errors on the console: [Oct 22 21:46:09] WARNING[952]: res_odbc.c:634 ast_odbc_prepare_and_execute: SQL Execute returned an error -1:

Ok, I reinstalled pkg-config from apt-get and now I think it?s all good. Man, PJSIP has been a chore to get working right on this server and on the last. Though the last server wasn?t near the issue this was. Lol I think what happened was that after initial trouble, I ran the ?install prereq? or something like that and it must have did it?s own install of pjsip that sent me down a duplicate path,

Hello Users, I doing on Voicemail in Asterisk For my RealTime, By using the ODBC connectivity For Voicemessages. in Made the Change in res_odbc.conf, odbc.ini, odbcinst.ini and voicemail.conf When I start My Asterisk server it give me Some Warning, When I googled , a proper Docummentation is not found, it found in some there languages, the First Warning is. Warning [30188]

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