Hello Neil/Everybody, Yes you are correct, PostgreSQL has to be specifically configured within the server it is hosted on to allow host calls from Asterisk so that the socket connects.
Here is how I solved the problem through the help of everybody here: Firstly enable the -i command in the /etc/init.d/postgresql command for starting up postgresql. Secondly, edit pg_hba.conf to add in a host (not local) entry in it so that PostgreSQL server allows host connects, most probably from 127.0.0.1 using the password method. Once you are done, asterisk should be able to connect to postgresql when it starts up. Here is a big "THANK YOU" to all who helped along the way. Cheers :) On Fri, 25 Jun 2004 10:55:28 -0400, Neil Cherry <[EMAIL PROTECTED]> wrote: > > Caleb Kow wrote: > > Here we go: > > > > [EMAIL PROTECTED] root]# netstat -ap > > Active Internet connections (servers and established) > > Proto Recv-Q Send-Q Local Address Foreign Address > > State PID/Program name > > tcp 0 0 *:32768 *:* > > LISTEN 3221/ > > tcp 0 0 *:imaps *:* > > I didn't see Postgres running but did notice mysql. They run on different > ports so that not a problem unless you are mistaking one for the other. > > Another poster stated that Postgres runs local socekts by default and > that a change in the config is needed to get it working with TCP/IP. > I'd investigate that as that's what it looks like. I hope this helps. > > > > -- > Linux Home Automation Neil Cherry [EMAIL PROTECTED] > http://home.comcast.net/~ncherry/ (Text only) > http://linuxha.sourceforge.net/ (SourceForge) > http://hcs.sourceforge.net/ (HCS II) > _______________________________________________ > 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
