[Linux-bruxelles] problème postgres
Stan Pinte
stanpinte at fastmail.fm
Mer 24 Mar 22:32:01 CET 2004
Stan Pinte wrote:
> hello,
>
> j'essaye de me connecter à postgres, via un tunnel ssh...
>
> ssh -p 333 -l userX -L 5000:localhost:5432 monhostpostgres
>
> le tunnel s'ouvre bien...
>
> mais
>
> psql -h localhost -p 5000 -d dbx -U userX
>
> reste bloqué...et n'avance pas!!!!!
>
> quelqu'un aurait-il une idée?
>
> Merci mille fois!
>
> pour info::
>
> tail pg_hba.conf:
>
> # This default configuration allows any local user to connect as any
> # PostgreSQL username, over either UNIX domain sockets or IP:
>
> local all trust
> host all 127.0.0.1 255.255.255.255 trust
>
> # If you want to allow non-local connections, you will need to add more
> # "host" records (and don't forget to start the postmaster with "-i"!).
>
> # CAUTION: if you are on a multiple-user machine, the above default
> # configuration is probably too liberal for you --- change it to use
> # something other than "trust" authentication.
>
> host all 132.147.101.0 255.255.255.0 trust
> host all 132.148.101.0 255.255.255.0 trust
> host all 132.150.101.0 255.255.255.0 trust
> host all 139.165.84.0 255.255.255.0 trust
> host all 127.0.0.1 255.255.255.0 trust
>
>
> Stan.
>
des précisions: quand je lance mon tunneling en verbose, il me dit:
Opening forwarded connection to localhost:5432
Forwarded connection refused by server
Plus d'informations sur la liste de diffusion Linux-bruxelles