search for: res_odbc

...ltime] Description = Asterisk realtime FUNC_ODBC access Driver = MySQL Socket = /var/lib/mysql/mysql.sock Server = localhost User = astrealtime Pass = XXXX Database = asterisk Option = 3 [root at Aiur asterisk]# cat /etc/asterisk/res_odbc.conf ;;; odbc setup file ; ENV is a global set of environmental variables that will get set. ; Note that all environmental variables can be seen by all connections, ; so you can't have different values for different connections. [ENV] INFORMIXSERVER => my_special_database INFORMIXDIR =>...

...? name? ??????????????????????????????????strategy????? ?1??????? ???????????? support???????? ????????????????????????rrmemory??????????? ? There are more fields but these are the most important ? I keep getting this error: ? node1*CLI> queue show No queues. [Apr 18 22:41:06] WARNING[18599]: res_odbc.c:645 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 42000: [MySQL][ODBC 5.1 Driver][mysqld-5.1.67]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''\' ORDER BY name' at line 1 (20...

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

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

...adaptive_odbc.c error line. "mysqlcheck -a -e -v DBase" and "mysqlcheck -c -e -v DBase" both returned OK for all tables. Environment is: in production Asterisk 11.7.0~dfsg-1ubuntu1 Ubuntu 14.04.1 LTS Any thoughts? Thanx Ethy [Apr 25 10:56:56] WARNING[19013][C-000002cb]: res_odbc.c:645 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 23000: [MySQL][ODBC 5.1 Driver][mysqld-5.5.40-0ubuntu0.14.04.1-log]Duplicate entry '0000-00-00 00:00:00-1234-CLIENT_ID' for key 'PRIMARY' (133) [Apr 25 10:56:56] WARNING[19013][C-000002cb]: res_odbc.c:657 ast_od...

...#39;s not. I am getting the following errors from the asterisk console: ? node1*CLI> queue show support support has 0 calls (max unlimited) in 'rrmemory' strategy (0s holdtime, 0s talktime), W:0, C:0, A:0, SL:0.0% within 60s ?? No Members ?? No Callers [Apr 19 22:37:05] WARNING[18366]: res_odbc.c:645 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 42000: [MySQL][ODBC 5.1 Driver][mysqld-5.1.67]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''\' AND queue_name = ? ORDER BY inte...

...returned OK for all tables. > > > > Environment is: > > in production Asterisk 11.7.0~dfsg-1ubuntu1 > > Ubuntu 14.04.1 LTS > > > > Any thoughts? > > > > Thanx > > > > Ethy > > > > [Apr 25 10:56:56] WARNING[19013][C-000002cb]: res_odbc.c:645 > > ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 23000: > > [MySQL][ODBC 5.1 Driver][mysqld-5.5.40-0ubuntu0.14.04.1-log]Duplicate > > entry '0000-00-00 00:00:00-1234-CLIENT_ID' for key 'PRIMARY' (133) > > > > [Apr 25 10:56:56] W...

...peers dissapear for 1 minute until modules get reloaded. Asterisk Version: 1.4.21.1 Local BD: Postgresql 7.4.19 External BD: Postgresql 7.4.19 This is what I see at logs: *Problem is begginig:* [May 11 09:02:57] NOTICE[17727] *loader.c: 2 modules will be loaded*. [May 11 09:02:57] NOTICE[17727] res_odbc.c: Adding ENV var: INFORMIXSERVER=my_special_database [May 11 09:02:57] NOTICE[17727] res_odbc.c: Adding ENV var: INFORMIXDIR=/opt/informix [May 11 09:02:57] NOTICE[17727] res_odbc.c: Connecting local [May 11 09:02:57] NOTICE[17727] res_odbc.c: res_odbc: Connected to local [* conector-loca*l] [May...

...hared -Xlinker -x -o res_agi.so res_agi.o gcc -pipe -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing- declarations -g -Iinclude -I../include -D_REENTRANT -D_GNU_SOURCE -O6 - march=i686 -DZAPTEL_OPTIMIZATIONS -fomit-frame-pointer - DZAPATA_MOH -DOPENSSL_NO_KRB5 -fPIC -c -o res_odbc.o res_odbc.c res_odbc.c: In function `odbc_sanity_check': res_odbc.c:131: `SQLLEN' undeclared (first use in this function) res_odbc.c:131: (Each undeclared identifier is reported only once res_odbc.c:131: for each function it appears in.) res_odbc.c:131: parse error before `rowcount' re...

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

...DBase" and "mysqlcheck -c -e -v DBase" both returned OK for all tables. > > Environment is: > in production Asterisk 11.7.0~dfsg-1ubuntu1 > Ubuntu 14.04.1 LTS > > Any thoughts? > > Thanx > > Ethy > > [Apr 25 10:56:56] WARNING[19013][C-000002cb]: res_odbc.c:645 > ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 23000: > [MySQL][ODBC 5.1 Driver][mysqld-5.5.40-0ubuntu0.14.04.1-log]Duplicate entry > '0000-00-00 00:00:00-1234-CLIENT_ID' for key 'PRIMARY' (133) > > [Apr 25 10:56:56] WARNING[19013][C-000002cb]...

...(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 reconnect... Mar 10 00:47:13 WARNING[7561]: res_odbc.c:411 odbc_obj_disconnect: res_odbc: disconnected 0 from pgsql [PostgreSQL-asterisk] Mar 10 00:47:13 NOTICE[7561]: res_odbc.c:468 odbc_obj_connect: Connecting pgsql Mar 10 00:47:13 NOTIC...

I have Asterisk 1.4.32 and I would like save all VoiceMail to MSSQL 2008 database. I configured ODBC, but I receive this errors. [Jun 18 14:00:37] NOTICE[19914] res_odbc.c: Connecting sqlserver [Jun 18 14:00:37] NOTICE[19914] res_odbc.c: res_odbc: Connected to sqlserver [kupalaodbc] [Jun 18 14:00:37] WARNING[19914] app_voicemail.c: SQL Prepare failed![SELECT COUNT(*) FROM pbx_VoiceMail WHERE dir = '/var/spool/asterisk/voicemail/default/390/INBOX']...

...| | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ [Oct 14 10:06:16] WARNING[10037][C-00000003]: res_odbc.c:645 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 42S02: [MySQL][ODBC 5.2(w) Driver][mysqld-5.6.12]Table 'asterisk.voicemessages' doesn't exist (86) [Oct 14 10:06:16] WARNING[10037][C-00000003]: res_odbc.c:657 ast_odbc_prepare_and_execute: SQL Execute error -1! Verif...

...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 start if I use "pre-connect = yes" in res_odbc.conf ( See errors below ) If I do not use it, then, I get another error message : "res_config_odbc.c: SQL Alloc Handle failed!" when I try to access the voicemail. Any ideas would be more than welcome ! Thanks ! *Here is my config* /etc/odbcinst.ini [MySQL] Description = ODBC for...

...e. 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 the res_odbc system. i have deleted the res_odbc.conf file is there anything else I do want to keep the mysql functionality, just get rid of the odbc stuff. Greg Regards Greg Cirino ___________________________________ Cirelle Enterprises Inc. 603-425-2221 www.cirelle.com Web Application Development &...

...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 15 16:20:03] DEBUG[5116] res_odbc.c: odbc_release_obj2(0x7f3f1c4815d8) called (obj->txf = (nil)) [Jun 15 16:20:03] ERROR[5116] res_pjsip_registrar.c: Unable to bind contact 'sip:812 at 10.1.80.112:5062' to AOR '812' [Jun 15 16:20:03] DEBUG...

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,

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/attachme...

I've recently had an Asterisk 1.4.x install system crash, luckily I was well into configuring a replacement system. Initially, the system was running: Debian 6 64BIT Asteirsk 11.3 USB sound card (to paging amp) Audio file is sent to the console via /dev/dsp1 on a 3 second time delayed call file. Initial testing shows this working well, but the day before I was to deliver and install, I