[Asterisk-Users] ODBC error ?

[Jens Kübler]

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 at 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 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, but ODBC reconnects although its connected and 
the displayed sql statement is obviously wrong.
The queried client exists in the database.

Any suggestions would be nice.

Jens