Koozali.org: home of the SME Server

Obsolete Releases => SME 7.x Contribs => Topic started by: Tetrao on February 01, 2007, 11:12:36 AM

Title: Postgresql on SME 7 opening port 5432
Post by: Tetrao on February 01, 2007, 11:12:36 AM

I have installed postgresql on SME 7.
Trying to join my server (local network, server only) or simply trying to run a CGI from the console, It say port 5432 isn't open !
looking with netstat -antp I see that 5432 isn't open ...
How do I do to open this port ?

Thanks for answer,
Didier

Title: Postgresql on SME 7 opening port 5432
Post by: byte on February 01, 2007, 11:17:41 AM

Moving this topic to the SME 7.x contribs forum, it is more appropriate there. Thanks!

Title: Postgresql on SME 7 opening port 5432
Post by: byte on February 01, 2007, 11:21:00 AM

What rpms did you use? Search on the bug tracker I'm sure I remember seeing Charlie posting to a bug some rpms for use with SME

Edit - Yes here you go...

http://bugs.contribs.org/show_bug.cgi?id=1667

Title: Postgresql on SME 7 opening port 5432
Post by: Tetrao on February 01, 2007, 12:03:59 PM

Thank you Bite.
Excuse me but I'm very new with sme and contrib forum.
I've installed postgresql using yum some more perl modules with gcc. Everything is running well under normal user added by postgres using psql.
How can I open this port 5432 ?

Thanks for answer,
Didier

Title: Postgresql on SME 7 opening port 5432
Post by: byte on February 01, 2007, 01:12:23 PM

Quote from: "Tetrao"

How can I open this port 5432 ?

Have a look here...

http://smeserver.sourceforge.net/sme70/sme70/Manual/FAQ?v=j77#h1094-8

What exactly are you trying to do? Allow access outside or for internal access only?

Title: Postgresql on SME 7 opening port 5432
Post by: Tetrao on February 02, 2007, 11:16:16 AM

Hi Bite.
I try to open connection to my server(10.252.2.137) only from the intranet (10.0.0.0/255.0.0.0), not from outside to my database in postgresql using html interface (perl, DBI, DBD etc)
postgresql works fine on the server itself using added user by postgres and psql.
Making a netstat -atpn on the server, I can't see port 5432 open.

Thanks for answers
Didier

Title: Postgresql on SME 7 opening port 5432
Post by: william_syd on February 02, 2007, 01:39:24 PM

Do something like..

Code: [Select]

db configuration set postsql service status enabled access public TCPPort 5432
signal-event remoteaccess-update

You are in server only mode so use your router/firewall to control access from the internet.

Oh.. do you have to use the -i option when starting Postgresql?