Config TCP Port for postgres

Classic Servoy
1

Hello,

I’m strugling to get the servoy database server to work on postgres (it should work as default driver)

I think i found the problem but stil no idea how to solve it, So here’s what i did:

If i try to remotely investigate my server (with nmap) it says that the port is closed (Hence my problem)

But TCP filtering is OFF on my server also (i think) no firewall blocking. (because switching it off has no effect)
See below

Can java block the 5432 port??

I need some help here…

Regards, JJ_Delft

2

Hi.

Default, postgres is configured only for local acces.

Edit the file pg_hba.con and replace the line

host all all 127.0.0.1/32 md5

by

host all all 0.0.0.0 0.0.0.0 md5

Also edit the file postgresql.conf and check that this line is uncommented

listen_addresses = '*'

Restart the postgres service and try again.

Best regards.

3

Thanks for your post mr. Herrero,

I could not start the service. That is : I could not start postgres.exe after making your suggested changes.
But I appreciate your responce nevertheless… :)

Kind Regerds, JJ_Delft

4

Hi:

What is the error returned by Postgres?

Which contained the code I told him to change?

This configuration I have it on several server running smoothly.

Best regqards.

5

Hello again,

It is a dbase initialization error.

Says something like … needs postmaster with -i option.
It’s the same error as e.g. trying to startup pg_ctl, see below:

Regards, JJ_Delft

6

Hello:

I see a Windows system, so I’ll make a stupid question: do you have a antivirus software installed? Do not have a integrated firewall?

Greetings

7

Hi Adelo,

This is screenshot of netsh current status: (cmd = netsh firewall show state)

Firewallstatus:

Profiel = Standaard
Operationele modus = Uitschakelen
Uitzonderingsmodus = Inschakelen
Antwoordmodus voor multicast/broadcast = Inschakelen
Kennisgevingsmodus = Inschakelen
Versie van Groepsbeleid = Geen
Extern-beheermodus = Uitschakelen

Poorten die momenteel op alle netwerkinterfaces zijn geopend:
Poort Protocol Versie Programma

80 TCP IPv4 F:\Program Files\Apache Software Foundation\Apache2.2
bin\httpd.exe
137 UDP IPv4 (null)
139 TCP IPv4 (null)
138 UDP IPv4 (null)
3306 TCP IPv4 F:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld.exe

5432 TCP IPv4 (null)
3389 TCP IPv4 (null)
443 TCP IPv4 F:\Program Files\VisualSVN Server\bin\VisualSVNServer.
exe
445 TCP IPv4 (null)
2869 TCP IPv4 (null)
1900 UDP IPv4 C:\WINDOWS\system32\svchost.exe

Any suggestions (putting off firewall had no effect upto now)

Regards, JJ

8

JJ,

This looks like there is an issue with some library.
Does the windows system logs give any clue?

Rob