[Asterisk-Users] ODBC error ?

[Jens Kübler]

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 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 = ?]
>
Problem was:
GRANT <rights> ON <table> TO user

Jens