asterisk users - Mar 2005 - ODBC error ?

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

Am Donnerstag 10 M?rz 2005 00:55 schrieb 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@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 = ?]
>
Problem was:
GRANT <rights> ON <table> TO user

Jens