Creating a new mairlist network database

Archive mAirList 4.x (English)
1

Hi everybody :slight_smile:

I’m trying to create a new mairlist database in network mode on windows and have encountered a couple of problems:-

  1. I’ve installed PostgreSQL and followed the user manual with creating a login and a database. That seemed to all go well but then I’ve tried to allow remote computers to access PostgreSQL again following the instructions and they just seem like gobble-de-gook to me…

  2. Then I’ve tried to setup mairlist following the instructions (having skipped out the step above for now). All works well until I click setup when it tells me that the password I’m entering is wrong. I’m typing it exactly as I wrote it in PostgreSQL and have gone back to PostgreSQL to check that I didn’t make a typo but to no joy… Cannot for the life of me work out the problem!

Any help really appreciated! I’m not the most technically minded and our engineer is away at the moment but I’m trying my best

Matt

2

The most complicated part of it is usually getting the pg_hba.conf right. That’s where you tell PostgreSQL which computers are allowed to connect to the server, and which databases they are allowed to use.

PostgreSQL is kind of “super safe” out of the box and won’t allow any network access at all until you have edited the pg_hba.conf file (and restarted/reloaded the server process).

Maybe you can elaborate on “they just seem like gobble-de-gook to me”? Any specific error message?