I try configure Realtime in Asterisk 1.2RC2 on my SUSE Linux box following the asteriskguru tutorial (www.asteriskguru.com/tutorials/realtime_pgsql.html).
I can connect locally to the Postgre Database. But when starting Asterisk it just freezes at the point where it trys to connect to the database. This is what the log says:
NOTICE: res_odbc.c:294 load_odbc_config: registered database handle ‘ast_cnf’ dsn->[asterisk]
NOTICE: res_odbc.c:552 odbc_obj_connect: Connecting ast_cnf
There are no error messages.
I tried some things and noticed that it behaves exactly the same way when the Postgre server is NOT running. It also does NOT make any difference when I comment out all entries in “pg_hba.conf” which are as follows:
local all all trust
host all all 127.0.0.1 255.255.255.255 trust
I know these are very insecure settings (it’s only for debugging…).
I checked whether PGSQL is listening on port 5432…
netstat -na | grep 5432
unix 2 [ACC] STREAM LISTENING 8500 /tmp/.s.PGSQL.5432
And at this point I don’t know what to check furthermore
When I change in res_odbc.conf the parameter “pre-connect” to “no” Asterisk starts properly.
I hope someone can help me.
Thanks a lot in advance!!!