search for: ast_odbc_sanity_check

...version for the right syntax to use near ''\' ORDER BY name' at line 1 (202) [Apr 18 22:41:06] WARNING[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:...

...ntax to use near ''\' AND queue_name = ? ORDER BY interface' at line 1 (226) [Apr 19 22:37:05] WARNING[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:...

...-1234-CLIENT_ID' for key 'PRIMARY' (133) [Apr 25 10:56:56] WARNING[19013][C-000002cb]: res_odbc.c:657 ast_odbc_prepare_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-aste...

...; > [Apr 25 10:56:56] WARNING[19013][C-000002cb]: res_odbc.c:657 > > ast_odbc_prepare_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...

...ey 'PRIMARY' (133) > > [Apr 25 10:56:56] WARNING[19013][C-000002cb]: res_odbc.c:657 > ast_odbc_prepare_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-aste...

...r][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! 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...

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,

...Txn isolation) returned an error: HY000: [MySQL][ODBC 5.2(w) Driver]Lost connection to MySQL server during query [Feb 9 16:28:48] WARNING[3781]: res_config_odbc.c:117 custom_prepare: SQL Prepare failed![SELECT * FROM ps_domain_aliases WHERE id = ?] [Feb 9 16:28:48] WARNING[3781]: res_odbc.c:765 ast_odbc_sanity_check: Connection is down attempting to reconnect... Aborted (core dumped) -- Telecomunicaciones Abiertas de M?xico S.A. de C.V. Carlos Ch?vez +52 (55)9116-91161

...Txn isolation) returned an error: HY000: [MySQL][ODBC 5.2(w) Driver]Lost connection to MySQL server during query [Feb 9 16:28:48] WARNING[3781]: res_config_odbc.c:117 custom_prepare: SQL Prepare failed![SELECT * FROM ps_domain_aliases WHERE id = ?] [Feb 9 16:28:48] WARNING[3781]: res_odbc.c:765 ast_odbc_sanity_check: Connection is down attempting to reconnect... Aborted (core dumped) Any pointers on working with ODBC and Asterisk? -- Telecomunicaciones Abiertas de M?xico S.A. de C.V. Carlos Ch?vez +52 (55)9116-91161

...1: 23502: ERROR: null value in column "eventtype" violates not-null constraint; Error while executing the 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[9...