Hello.
I am new to this. Please let me know what other information you need.
I am trying to integrate Asterisk with postgresql. I was able to install postgresql with out any problem. I have installed postgresql: 8.1.4-1.1 and unixodbc. I have also created the user “asterisk” for ODBC to make the connection between Asterisk and Postgresql.
When I run
[asterisk@asterisk ~]$ echo “select 1” | isql -v asterisk-connector
I get the following error:
[28000][unixODBC]FATAL: missing or erroneous pg_hba.conf file
[ISQL]ERROR: Could not SQLConnect
See below for my pg_hba.conf info:
// /var/lib/pgsql/data/pg_hba.conf
host all asterisk 127.0.0.1 255.255.255.255 md5
host all asterisk trust