PostgreSQL server + client

English mAirList 5.x
1

Hey

I know this been up before even by myself.
Last time i gave up because i couldnt get it to work, thats not gonna happen this time!

My setup

[ul][li]Mairlist 5.1.4 (build 2790) [/li]
[li]PostgreSQL 8.3[/li][/ul]

PostgreSQL has the following accepted in (postgresql.conf)

listen_adresses = '*'
port = 5432

My problem
Server is running on 192.168.1.101:5432 and thats all fine on the “server computer” Mairlist works flawless. How ever my Connections seems to be a mess. In the pg_hba.conf i have open for my “client” running on ip 192.168.1.100 with the following line.

host all all 192.168.1.100 md5

Router is forwarding port 5432 to 192.168.1.101 so thats not my problem.
I have inside PostgreSQL setup a user mydj with password PassWord1010! just for testing. I have also assigned the mairlist_dj role to that user.

Offcourse the computer that run as a server has that port open thru firewall, still i get a Socket error 10060 (Connection timed out).

Please help me before i go crazy ???

2

“Connection time out” is definitely a firewall issue (assuming that you have double-checked the IP addresses and ports).

3

I have trippel checked it, but will dig further into my firewall. See where the issue is :slight_smile:

4

After some hours of configuration of my firewall.
Restart of services and even a restart of server.

I now get this error message!

Socket Error #10054
Connection reset by peer
5

Problem solved! :slight_smile:

6

Great. Mind to tell us what the problem was?

7

It’s something people might forget to do!

I was so up to my knees with postgres trying to make it work, so i missed to enable Mairlist database server from start menu.
It was more me thinking it was activated automatic with mairlist ;D

But no it wasnt ::slight_smile:

8

Actually mAirListDB Server is not related to the PostgreSQL connection at all.

Well, it uses the PG connection to proxy incoming DBClient connections - but it is not required in order to connect to the PG server.

Must have been something else :wink:

9

Well when i try to connect to postgreSQL via port 5432 i get this.

Socket Error #10054
Connection reset by peer

When i go via Mairlist database server using port 8840 it work all fine.
Now i only need to test Everything so that works like i want. Then we have to save money for the licens :smiley: