search for: odbc_obj_connect

.../res_odbc.conf': Found [Feb 22 18:21:46] NOTICE[21214]: res_odbc.c:229 load_odbc_config: Adding ENV var: INFORMIXSERVER=my_special_database [Feb 22 18:21:46] NOTICE[21214]: res_odbc.c:229 load_odbc_config: Adding ENV var: INFORMIXDIR=/opt/informix [Feb 22 18:21:46] NOTICE[21214]: res_odbc.c:508 odbc_obj_connect: Connecting mysql [Feb 22 18:21:46] WARNING[21214]: res_odbc.c:519 odbc_obj_connect: res_odbc: Error SQLConnect=-1 errno=0 [unixODBC][Driver Manager]Data source name not found, and no default driver specified [Feb 22 18:21:46] WARNING[21214]: res_odbc.c:444 ast_odbc_request_obj: Failed to connect t...

...[18599]: res_odbc.c:657 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk [asterisk-connector]... [Apr 18 22:41:06] WARNING[18599]: res_odbc.c:761 ast_odbc_sanity_check: Connection is down attempting to reconnect... [Apr 18 22:41:06] NOTICE[18599]: res_odbc.c:1527 odbc_obj_connect: Connecting asterisk [Apr 18 22:41:06] NOTICE[18599]: res_odbc.c:1559 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector] [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...

...[18366]: res_odbc.c:657 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk [asterisk-connector]... [Apr 19 22:37:05] WARNING[18366]: res_odbc.c:761 ast_odbc_sanity_check: Connection is down attempting to reconnect... [Apr 19 22:37:05] NOTICE[18366]: res_odbc.c:1527 odbc_obj_connect: Connecting asterisk [Apr 19 22:37:05] NOTICE[18366]: res_odbc.c:1559 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector] [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...

..._and_execute: SQL Execute error -1! Verifying connection to MyAsterisk-asterisk [MyAsterisk-asterisk]... [Apr 25 10:56:56] WARNING[19013][C-000002cb]: res_odbc.c:761 ast_odbc_sanity_check: Connection is down attempting to reconnect... [Apr 25 10:57:01] NOTICE[19013][C-000002cb]: res_odbc.c:1527 odbc_obj_connect: Connecting MyAsterisk-asterisk [Apr 25 10:57:01] NOTICE[19013][C-000002cb]: res_odbc.c:1559 odbc_obj_connect: res_odbc: Connected to MyAsterisk-asterisk [MyAsterisk-asterisk] [Apr 25 10:57:01] WARNING[19013][C-000002cb]: res_odbc.c:645 ast_odbc_prepare_and_execute: SQL Execute returned an error...

...to MyAsterisk-asterisk [MyAsterisk-asterisk]... > > > > [Apr 25 10:56:56] WARNING[19013][C-000002cb]: res_odbc.c:761 > > ast_odbc_sanity_check: Connection is down attempting to reconnect... > > > > [Apr 25 10:57:01] NOTICE[19013][C-000002cb]: res_odbc.c:1527 > > odbc_obj_connect: Connecting MyAsterisk-asterisk > > > > [Apr 25 10:57:01] NOTICE[19013][C-000002cb]: res_odbc.c:1559 > > odbc_obj_connect: res_odbc: Connected to MyAsterisk-asterisk > > [MyAsterisk-asterisk] > > > > [Apr 25 10:57:01] WARNING[19013][C-000002cb]: res_odbc.c:645 &g...

...cute error -1! Verifying connection to > MyAsterisk-asterisk [MyAsterisk-asterisk]... > > [Apr 25 10:56:56] WARNING[19013][C-000002cb]: res_odbc.c:761 ast_odbc_sanity_check: Connection is down attempting to reconnect... > > [Apr 25 10:57:01] NOTICE[19013][C-000002cb]: res_odbc.c:1527 odbc_obj_connect: Connecting MyAsterisk-asterisk > > [Apr 25 10:57:01] NOTICE[19013][C-000002cb]: res_odbc.c:1559 > odbc_obj_connect: res_odbc: Connected to MyAsterisk-asterisk [MyAsterisk-asterisk] > > [Apr 25 10:57:01] WARNING[19013][C-000002cb]: res_odbc.c:645 > ast_odbc_prepare_and_execute: SQ...

...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 NOTICE[7561]: res_odbc.c:483 odbc_obj_connect: res_odbc: Connected to pgsql [PostgreSQL-asterisk] Mar 10 00:47:13 WARNING[7561]: res_config_odbc.c:104 realtime_odbc: SQL Execute error! [SELECT * FROM sip_hadiko WHERE name = ?] The params seem to be correct, bu...

...dbc.c:657 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk [asterisk]... [Oct 14 10:06:16] WARNING[10037][C-00000003]: res_odbc.c:761 ast_odbc_sanity_check: Connection is down attempting to reconnect... [Oct 14 10:06:16] NOTICE[10037][C-00000003]: res_odbc.c:1527 odbc_obj_connect: Connecting asterisk [Oct 14 10:06:16] NOTICE[10037][C-00000003]: res_odbc.c:1559 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk] [Oct 14 10:06:16] WARNING[10037][C-00000003]: app_voicemail.c:5609 messagecount: SQL Execute error! any help is appreciated! -- rickygm http://gnufor...

...rror 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 in res_odbc.conf asterisk starts. Have there been changes in res_odbc or is this a bug? Thanks for advise. Oliver -------------- next part -------------- An...

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,

...y 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 WARNING[10380]: res_odbc.c:559 odbc_obj_connect: res_odbc: Error SQLConnect=-1 errno=1044 [unixODBC][MySQL][ODBC 3.51 Driver]Access denied for u ser 'asterisk'@'%' to database 'asterisk' Any suggestions? Thanks

.... 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 NOTICE[3923]: res_odbc.c:473 odbc_obj_connect: Connecting asterisk Jul 17 22:12:14 NOTICE[3923]: res_odbc.c:488 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk] Jul 17 22:12:14 NOTICE[3923]: res_odbc.c:518 load_module: res_odbc loaded. [res_config_odbc.so] => (ODBC Configuration) Jul 17 22:12:14 NOTICE[3923]: config.c:836 ast_c...

...query (101) [Oct 22 21:46:09] WARNING[952]: res_odbc.c:646 ast_odbc_prepare_and_execute: SQL Execute error -1! Attempting a reconnect... [Oct 22 21:46:09] WARNING[952]: res_odbc.c:742 ast_odbc_sanity_check: Connection is down attempting to reconnect... [Oct 22 21:46:09] NOTICE[952]: res_odbc.c:1472 odbc_obj_connect: Connecting PostgreSQL-asterisk [Oct 22 21:46:09] NOTICE[952]: res_odbc.c:1502 odbc_obj_connect: res_odbc: Connected to PostgreSQL-asterisk [asterisk-connector] [Oct 22 21:46:09] WARNING[952]: cel_odbc.c:733 odbc_log: Insert failed on 'PostgreSQL-asterisk:celnew'. CEL failed: INSERT INTO c...

...175 modules will be loaded. ..[May 3 13:29:14] NOTICE[7477]: res_odbc.c:235 load_odbc_config: Adding ENV var: INFORMIXSERVER=my_special_database [May 3 13:29:14] NOTICE[7477]: res_odbc.c:235 load_odbc_config: Adding ENV var: INFORMIXDIR=/opt/informix [May 3 13:29:14] NOTICE[7477]: res_odbc.c:530 odbc_obj_connect: Connecting asterisk [May 3 13:29:14] WARNING[7477]: res_odbc.c:541 odbc_obj_connect: res_odbc: Error SQLConnect=-1 errno=0 [unixODBC][Driver Manager]Data source name not found, and no default driver specified [May 3 13:29:14] WARNING[7477]: res_odbc.c:463 ast_odbc_request_obj: Failed to connect...

...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 may be choppy. | | WARNING[21806]: res_odbc.c:565 odbc_obj_connect: res_odbc: Error | SQLConnect=-1 errno=0 [unixODBC][Driver Manager]Data source name not | found, and no default driver specified `---- but asterisk daemon start well. the pb is when I start ekiga I always get : IN FRENCH : L'inscription de ekiga a 10.0.0.1 a echoue IN ENGLISH :ekiga c...

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

...ing 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 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 '/e...

...a maximum of 1 digits. -- <Local/777777 at from-internal-out-7-00000000;1> Playing 'custom-gvl/2.slin' (language 'en') > 0xb6c04f70 -- Probation passed - setting RTP source address to 192.168.1.226:15396 [Jan 8 14:37:23] NOTICE[9132][C-00000000]: res_odbc.c:1524 odbc_obj_connect: Re-connecting asterisk [Jan 8 14:37:23] NOTICE[9132][C-00000000]: res_odbc.c:1559 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector] == Spawn extension (from-internal-out-7, 777777, 13) exited non-zero on 'Local/777777 at from-internal-out-7-00000000;2' -- User d...

...y_special_database Mar 13 20:44:26 NOTICE[10829]: res_odbc.c:265 load_odbc_config: Adding ENV var: INFORMIXDIR=/opt/informix Mar 13 20:44:26 NOTICE[10829]: res_odbc.c:294 load_odbc_config: registered database handle 'asterisk' dsn->[asterisk] Mar 13 20:44:26 NOTICE[10829]: res_odbc.c:552 odbc_obj_connect: Connecting asterisk Mar 13 20:44:26 WARNING[10829]: res_odbc.c:563 odbc_obj_connect: res_odbc: Error SQLConnect=-1 errno=0 [unixODBC][Driver Manager]Data source name not found, and no default driver specified Mar 13 20:44:26 NOTICE[10829]: res_odbc.c:597 load_module: res_odbc loaded. [res_monitor...

...a maximum of 1 digits. -- <Local/777777 at from-internal-out-7-00000000;1> Playing 'custom-gvl/2.slin' (language 'en') > 0xb6c04f70 -- Probation passed - setting RTP source address to 192.168.1.226:15396 [Jan 8 14:37:23] NOTICE[9132][C-00000000]: res_odbc.c:1524 odbc_obj_connect: Re-connecting asterisk [Jan 8 14:37:23] NOTICE[9132][C-00000000]: res_odbc.c:1559 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector] == Spawn extension (from-internal-out-7, 777777, 13) exited non-zero on 'Local/777777 at from-internal-out-7-00000000;2' -- User d...