similar to: Dynamic realtime + queues.conf Unresolved

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

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

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

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,

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

Is there any way to get debug info on res_odbc? I get the following but this is the last I ever see of anything ODBC related. Obviously, my extensions are not working from the database, but I can connect to ODBC via isql and run queries just fine. Jul 17 22:12:13 NOTICE[3923]: res_odbc.c:215 load_odbc_config: registered database handle 'asterisk' dsn->[asterisk] Jul 17 22:12:13

Hi, all I use Ubuntu 12.04.01 TLS and install asterisk 11.7.0 (tar.gz downloaded from asterisk.org). We named it "Asterisk11". I want to generate a call file to /var/spool/asterisk/outgoing. This call will dial out to Local Channel and return to some Extens. Then Asterisk11 will generate a CDR records to MySQL's cdr table(in database "mydatabase") via cdr_adaptive_odbc.

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 Sorry that forgot add mail subject last one. I use Ubuntu 12.04.01 TLS and install asterisk 11.7.0 (tar.gz downloaded from asterisk.org). We named it "Asterisk11". I want to generate a call file to /var/spool/asterisk/outgoing. This call will dial out to Local Channel and return to some Extens. Then Asterisk11 will generate a CDR records to MySQL's cdr table(in database

Hi, all Sorry for null subject last mail. I use Ubuntu 12.04.01 TLS and install asterisk 11.7.0 (tar.gz downloaded from asterisk.org). We named it "Asterisk11". I want to generate a call file to /var/spool/asterisk/outgoing. This call will dial out to Local Channel and return to some Extens. Then Asterisk11 will generate a CDR records to MySQL's cdr table(in database

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

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

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

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, im trying to get an odbc connection to work. Its no problem if asterisk an mysl running on one machine. When i try to set up an external DB it won't connect. External connections to the db are possible (bind-address = 0.0.0.0 and the user asterisk is allowed to connect from each ip). The password in the config is the right one i already double checked it. Jul 23 12:31:54

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