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. -- James Purser Chief Talking Guy - Linux Australia Update http://k-sit.com - My Blog http://la-pod.k-sit.com - Linux Australia Update Blog and Forums Skype: purserj1977 -- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
