Hi Sam, I have tried adding in the -i flag into the postgresql startup command line but it displays the following upon starting up of Asterisk:
Jun 25 02:00:02 ERROR[1074494336]: cdr_pgsql.c:298 my_load_module: cdr_pgsql: Unable to connect to database server localhost. Calls will not be logged! Jun 25 02:00:02 ERROR[1074494336]: cdr_pgsql.c:299 my_load_module: cdr_pgsql: Reason: FATAL: Missing or erroneous pg_hba.conf file, see postmaster log for details Very strangely, the pg_hba.conf file is right there, at /var/lib/pgsql/pg_hba.conf On Thu, 24 Jun 2004 23:27:46 +1000, Sam Tilders <[EMAIL PROTECTED]> wrote: > > On Thu, Jun 24, 2004 at 09:05:42PM +0800, Caleb Kow wrote: > > Jun 24 21:20:53 ERROR[1074494336]: cdr_pgsql.c:299 my_load_module: > > cdr_pgsql: Reason: could not connect to server: Connection refused > > Is the server running on host localhost and accepting > > TCP/IP connections on port 5432? > > > > However, the strange thing is that when I try to connect to this > > database using the command prompt, it puts me through! :) Only when > > Asterisk tries to connect to the postgresql database does it not work. > > Any idea why this is happening? > > Asterisk is trying to connect to the postgresql postmaster. > > "netstat -na |grep 5432" should show a line with LISTEN, if it > does not then postgres is not accepting tcp connections. > > postmaster needs the -i option to accept tcp connections. > > The startup script, perhaps /etc/init.d/postgresql needs > the command line to pg_ctl add the -i option to > postmaster's command line. Something like: > /usr/bin/pg_ctl -p /usr/bin/postmaster -o '-p 5432 -i' start > with whatever other options are already there. > > Then after a restart, asterisk should be able to connect to > postgres. > > -- > -- > Sam Tilders > [EMAIL PROTECTED] > (Move to Jupiter) > _______________________________________________ > Asterisk-Users mailing list > [EMAIL PROTECTED] > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users > _______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
