Topic: Postgresql on SME 7 opening port 5432

[Tetrao]

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

[byte]

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

[byte]

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

[Tetrao]

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

[byte]

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?

[Tetrao]

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

[william_syd]

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?