search for: res_config_odbc

When I try to use 1.6.1.1 with ODBC and MySQL, I get these: [Jun 19 17:19:22] WARNING[5882] res_config_odbc.c: Realtime table supporten_sip at asterisk: column type (-9) unrecognized for column 'name' [Jun 19 17:19:22] WARNING[5882] res_config_odbc.c: Realtime table supporten_sip at asterisk: column type (-9) unrecognized for column 'ipaddr' [Jun 19 17:19:22] WARNING[5882] res_config_odbc...

...-shared -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_config_odbc.o res_config_odbc.c res_config_odbc.c: In function `realtime_odbc': res_config_odbc.c:67: `SQLLEN' undeclared (first use in this function) res_config_odbc.c:67: (Each undeclared identifier is reported only once res_config_odbc.c:67: for each function it appears in.) res_config_odbc.c:67: p...

..._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[5116] res_config_odbc.c: Skip: 0; SQL: SELECT * FROM ps_contacts WHERE id LIKE ? ORDER BY id [Jun 15 16:20:03] DEBUG[5116] res_config_odbc.c: Parameter 1 ('id LIKE') = '812;@%' [Jun 15 16:20:03] DEBUG[5116] res_odbc.c: odbc_release_obj2(0x7f3f1c4815d8) called (obj->txf = (nil)) [Jun 15 16:20:03] DEBUG...

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

Hi, I'm getting the following at asterisk startup. OCBC was working with 1.4 no problem, but now under 1.6 (I've tried 1.6.1, 1.6.2-beta3/beta4) I can't seem to get rid of this .... anyone? WARNING[32664]: loader.c:385 load_dynamic_module: Error loading module 'res_config_odbc.so': /usr/lib/asterisk/modules/res_config_odbc.so: undefined symbol: ast_odbc_clear_cache Any help would be greatly appreciated ... Todd

...elect * from ast_config where filename='iax.conf' and commented=0 order by filename,cat_metric desc,var_metric asc,category,var_name,var_val,id" | isql Asterisk <lot of output from table> SQLRowCount returns 39 39 rows fetched So the odbc thingy works! root@pbx:# cat res_config_odbc.conf [settings] table = ast_config connection = myconn root@pbx:# cat res_odbc.conf [myconn] dsn=Asterisk username=XXXXX password=XXXXX preconnect=yes root@pbx:# cat extconfig.conf [settings] agents.conf => odbc enum.conf => odbc extensions.conf => odbc iax.conf => odbc iax...

...ng 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 symbol: ast_odbc_clear_cache [Aug 23 15:06:12] NOTICE[7180]: res_odbc.c:1471 odbc_obj_connect: Connecting mssql asterisk: net.c:348: tds_select: Assertion `timeout_seconds >= 0' failed. When I set [mssql] enabled => no...

...rows. When I start "asterisk -gcvvvvv" the first time, everything works fine. Then I issue a "reload", and something strange happens: Reloading SIP Feb 22 09:50:23 NOTICE[26316]: config.c:764 __ast_load: Loading Config sip.conf via odbc engine == Parsing '/etc/asterisk/res_config_odbc.conf': Found Use EXIT or QUIT to exit the asterisk console *CLI> After that, basically nothing else happens, and asterisk still works. Now, if I issue another "reload", asterisk segfaults. That's what "bt" says inside gdb: (gdb) bt #0 0x0000002a9607df81 in my_st...

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

...es_odbc.c:132 load_odbc_config: registered database handle 'mysql' dsn->[MySQL-asterisk] Jul 7 20:11:32 NOTICE[-1084915040]: res_odbc.c:369 odbc_obj_connect: res_odbc: Connected to mysql [MySQL-asterisk] Jul 7 20:11:32 NOTICE[-1084915040]: res_odbc.c:402 load_module: res_odbc loaded. [res_config_odbc.so] => (Odbc Configuration) Jul 7 20:11:32 NOTICE[-1084915040]: config.c:880 ast_config_register: Registered Config Engine odbc == Parsing '/etc/asterisk/extconfig.conf': Found Jul 7 20:11:32 NOTICE[-1084915040]: res_config_odbc.c:233 load_module: res_config_odbc loaded. These are...

...8 [2009-09-23 11:10:57.3q] VERBOSE[10431] chan_sip.c: -- Registered SIP 'stone' at 10.215.42.138 port 5060 [2009-09-23 11:10:57.3q] VERBOSE[10431] chan_sip.c: > Saved useragent "ipDialog SipTone 1.2.0 rc Z_21 UA" for peer stone [2009-09-23 11:10:57.3q] WARNING[10431] res_config_odbc.c: Key field 'ipaddr' does not exist in table 'foo.sip at asterisk'. Update will fail [2009-09-23 11:10:57.3q] DEBUG[10431] res_config_odbc.c: Skip: 62; SQL: UPDATE public.sip SET ipaddr=? WHERE name=? [2009-09-23 11:10:57.3q] DEBUG[10431] res_config_odbc.c: Parameter 1 ('ipadd...

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

...sterisk 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 /etc/asterisk/res_config_odbc.conf [settings] ;table => ast_config connection => mysql1 /etc/asterisk/res_odbc.conf [mysql1] dsn => dsn username => username password => pass pre-connect => yes Messages from asterisk when it asterisk is loaded [res_odbc.so] => (ODBC Resource) == Parsing '/etc/aste...

...ne 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 => odbc,mysql1,sip_buddies sipfriends => odbc,mysql1,sip_buddies /etc/asterisk/res_config_odbc.conf [settings] ;table => ast_config connection => mysql1 /etc/asterisk/res_odbc.conf [mysql1] dsn => dsn username => username password => pass pre-connect => yes Messages from asterisk when it asterisk is loaded [res_odbc.so] => (ODBC Resource) == Parsing '/etc/aste...

Hello, After installing Asterisk from source in Slackware 13.1, I get the following error: Error loading module 'res_config_odbc.so': /usr/lib/asterisk/modules/res_config_odbc.so: undefined symbol: ast_odbc_clear_cache Then a core dump. If I change the /etc/asterisk/modules.conf in order to preload the 'res_odbc.so' module, then the error dissapears, *but* still crashes with core dump Could someone point m...

...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 MySQL Driver = /usr/lib/libmyodbc.so Setup = /usr/lib/libodbcmyS.so FileUsage =...

Why is the SELECT statement below putting a "?" in for the username? I am using today's CVS. Jan 13 18:48:41 WARNING[7570]: res_config_odbc.c:105 realtime_odbc: SQL Execute error! [SELECT * FROM sip_buddies WHERE name = ?] Full dump: Sip read: REGISTER sip:198.88.216.85 SIP/2.0 Via: SIP/2.0/UDP 192.168.1.2:5060;branch=z9hG4bK-ffmzndpfrao2;rport From: "Mike's Peoria Snom" <sip:MikePeoriaSnom___1@198.88.216.85>;t...

...from asterisk logs show: pbx.c: Function ODBC_SQL not registered Indeed I can find this function in /var/lib/asterisk/modules As far as I understand asterisk needs to be recompiled to include the function. Recompiling asterisk-1.4.17 I get even into more trouble: make menuselect shows XXX 4. res_config_odbc XXX 13. res_odbc ODBC Resource Depends on: unixodbc(E), ltdl(E) unixODBC and unixODBC-devel are installed. Thanks for any hint to get my ODBC_SQL included and working! Enrique -- Dirk Enrique Seiffert - Lintec S.A. Ed. Torre del Reloj - Of. 401 Plaza de los Coches, Centro Cartagena - Colomb...

...[21622]: res_odbc.c:133 load_odbc_config: registered database handle 'PostgreSQL' dsn->[PostgreSQL] Dec 17 11:33:05 NOTICE[21622]: res_odbc.c:353 odbc_obj_connect: res_odbc: Connected to PostgreSQL [PostgreSQL] Dec 17 11:33:05 NOTICE[21622]: res_odbc.c:379 load_module: res_odbc loaded. [res_config_odbc.so] => (ODBC Configuration) Dec 17 11:33:05 NOTICE[21622]: config.c:888 ast_config_register: Registered Config Engine odbc == Parsing '/etc/asterisk/extconfig.conf': Found Dec 17 11:33:05 NOTICE[21622]: res_config_odbc.c:190 load_module: res_config_odbc loaded. [res_features.so] =>...

...ibmysqlclient.so.16.0.0[b48f1000+12e000] >> >> after downgrade to 13.7.2 >> asterisk is ok > > Could be https://issues.asterisk.org/jira/browse/ASTERISK-25957 - a > solution is to change the order in modules.conf to: > > preload => res_odbc.so > preload => res_config_odbc.so > preload => chan_local.so > preload => cdr_adaptive_odbc.so > > /niklas > -- --------------------------------------- Marek Cervenka ======================================= -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.d...