Hello Ezeqiuas,
I believe the second line is meant to give access to other computers on
the LAN. Do you have a class B network? Shouldn't the subnet mask on the
second line be 255.255.0.0? I use this line in my pg_hba.conf:
host all all 192.168.25.0/24 trust
We use a class C network..
Here you can see what the pg_hba.conf settings mean:
http://www.postgresql.org/docs/8.0/static/client-authentication.html
Regards,
Frans
Ezequias Rodrigues da Rocha wrote:
My pg_hba.conf is here:
host all all 10.0.0.0 255.0.0.0 password
host all all 192.168.0.0 255.0.0.0 password
host all all 127.0.0.1/32 trust
host all all 200.249.133.135 255.255.255.255
password
# IPv6 local connections:
host all all ::1/128 trust
host all all 192.168.0.0 255.255.0 0 password
What do you say about that ?
Frans Knibbe wrote:
Hello Ezequias,
Did you edit pg_hba.conf to allow non-local connections to your
database?
Regards,
Frans
Ezequias Rodrigues da Rocha wrote:
Hi list,
I am starting with mapserver, but have a very important error and I
have no idea how to put it to work. I doesn't even know if I did it
before but here is the problem:
I am trying to access a postgis layer with the mapserver 4.4.2 and
via browser the return of server was:
msDrawMap(): Image handling error. Failed to draw layer named
'bairros'.
msPOSTGISLayerOpen(): Query error. couldnt make connection to DB
with connect string 'user=postgres password=post dbname=dbpotgis
host=192.168.0.15 port=5432'.
Error reported was 'could not create socket: Permission denied '.
This error occured when trying to make a connection to the specified
postgresql server.
Most commonly this is caused by
(1) incorrect connection string
(2) you didnt specify a 'user=...' in your connection string
(3) the postmaster (postgresql server) isnt running
(4) you are not allowing TCP/IP connection to the postmaster
(5) your postmaster is not running on the correct port - if its not
on 5432 you must specify a 'port=...'
(6) the security on your system does not allow the webserver
(usually user 'nobody') to make socket connections to the postmaster
(7) you forgot to specify a 'host=...' if the postmaster is on a
different machine
(8) you made a typo
I hope someone could help me. Nobody did before.
Sincerely
Ezequias
