On Sun, 30 Oct 2005 14:05:18 +1100 James Purser <[EMAIL PROTECTED]> wrote:
> On Sun, 2005-10-30 at 14:01 +1100, Russell Davie wrote: > > Hi > > I am having difficulty in getting postgreasql past the ssl required for > > tcp/ip > > > > this is what I'm getting when I manually start postgresql: > > > > [EMAIL PROTECTED]:/etc/init.d # ./postgresql-7.4 start > > * Starting PostgreSQL 7.4 database server: main > > The PostgreSQL server failed to start. Please check the log > > output: > > /usr/lib/postgresql/7.4/bin/postmaster: TCP/IP connections must be enabled > > for SSL > > > > [fail] > > > > adding a new user to postgres doesn't occur as postgres isn't running: > > > > [EMAIL PROTECTED]:~$ createuser -d wwww-data > > Shall the new user be allowed to create more new users? (y/n) n > > createuser: could not connect to database template1: could not connect to > > server: No such file or directory > > Is the server running locally and accepting > > connections on Unix domain socket > > "/var/run/postgresql/.s.PGSQL.5432"? > > > > > > I've found how to make the rss keys for openssl, but I'm not sure where to > > put them. ie the data directory mentioned in: > > http://www.postgresql.org/docs/7.4/interactive/ssl-tcp.html > > > > Is this the right step? or is this in the wrong direction? (likely!) > > > > TIA > > > > Russell > > > > Postgresql needs to be told explicitly that it has to accept tcp/ip > connections in the start up script, you might want to check if this is > happening, if no tcp/ip then the ssl will fail. > -- great it works! I edited the /etc/postgresl/7.4/main/postgresql.conf and changed: #tcpip_socket=false to: tcpip_socket=true thanks - Russell > > -- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html