From: Moritz Bayer <moritz.bayer@googlemail.com>
To: Phillip Smith <phillip.smith@weatherbeeta.com.au>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_hba.conf & putty
Date: Tue, 6 Mar 2007 09:49:35 +0100
Message-ID: <c244500b0703060049g1d037b8ax53efd2b1f4f97b5d@mail.gmail.com> (raw)
In-Reply-To: <00a901c75f84$d7b9fa80$9b0014ac@wbaus090>
References: <c244500b0703051557r2f511f69q2386aa19b0106c4f@mail.gmail.com>
<00a901c75f84$d7b9fa80$9b0014ac@wbaus090>
Thanks a lot,
the change of the tunnels IP address to 127.0.0.1 made it!
:-)
Great!
2007/3/6, Phillip Smith <phillip.smith@weatherbeeta.com.au>:
>
> I know your problem (I think)
>
>
>
> Your SSH forward you said is defined as:
>
> Lserver.ip.address:5432
>
>
>
> So the requests will be coming from your server's IP address via the eth0
> interface… You need to change this to 127.0.0.1 to make it use the lo
> interface, and then the requests will come from 127.0.0.1 to match your
> pg_hba.conf
>
>
>
> Cheers,
>
> ~p
>
>
>
>
>
> -----Original Message-----
> *From:* pgsql-admin-owner@postgresql.org [mailto:
> pgsql-admin-owner@postgresql.org] *On Behalf Of *Moritz Bayer
> *Sent:* Tuesday, 6 March 2007 10:58
> *To:* Phillip Smith
> *Cc:* pgsql-admin@postgresql.org
> *Subject:* Re: [ADMIN] pg_hba.conf & putty
>
>
>
> hello phillip,
>
> yes, the connection i defined in pgadmin uses localhost:5432.
>
> Still, no success :(
>
>
>
>
> 2007/3/6, Phillip Smith < phillip.smith@weatherbeeta.com.au>:
>
> What address are you connecting to on your desktop computer? You should be
> using localhost:5432 which putty will redirect to the server via the SSH
> tunnel and the server will connect to PostgreSQL on your behalf.
>
>
>
> ~p
>
>
>
> -----Original Message-----
> *From:* pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org]
> *On Behalf Of *Moritz Bayer
> *Sent:* Tuesday, 6 March 2007 10:31
> *To:* pgsql-admin@postgresql.org
> *Subject:* [ADMIN] pg_hba.conf & putty
>
>
>
> dear list,
>
> I know there are already hunderts of posts about pg_hba.conf, but still
> after reading a few of them I still got troubles with this topic.
>
> I've got a vpn server with a ststic ip address, java apps are supposed to
> run there receiving data from a postgresql database.
> The database is running, but for changes on it I want to open a putty
> connection while using pgAdmin.
> In putty, I define a tunnel to port 5432, its displayed like this:
> Lserver.ip.address:5432
>
> Thought this entries in my pg_hba.conf would do it:
>
> # "local" is for Unix domain socket connections only
> local all all md5
>
> # IPv4 local connections:
> host all all 127.0.0.1/32 md5
>
> # IPv6 local connections:
> host all all ::1/128 md5
>
> well, it doesn't. When i run pgAdmin with an open putty connection, it
> still says: error connecting to server.
>
> Any hints how I can find out whats still wrong?
>
> Thanks in advance,
> Mo
>
>
>
> ********************Confidentiality and Privilege
> Notice********************
>
> The material contained in this message is privileged and confidential to
> the addressee. If you are not the addressee indicated in this message or
> responsible for delivery of the message to such person, you may not copy or
> deliver this message to anyone, and you should destroy it and kindly notify
> the sender by reply email.
>
> Information in this message that does not relate to the official business
> of Weatherbeeta must be treated as neither given nor endorsed by
> Weatherbeeta. Weatherbeeta, its employees, contractors or associates shall
> not be liable for direct, indirect or consequential loss arising from
> transmission of this message or any attachments
>
>
>
> ********************Confidentiality and Privilege
> Notice********************
>
> The material contained in this message is privileged and confidential to
> the addressee. If you are not the addressee indicated in this message or
> responsible for delivery of the message to such person, you may not copy or
> deliver this message to anyone, and you should destroy it and kindly notify
> the sender by reply email.
>
> Information in this message that does not relate to the official business
> of Weatherbeeta must be treated as neither given nor endorsed by
> Weatherbeeta. Weatherbeeta, its employees, contractors or associates shall
> not be liable for direct, indirect or consequential loss arising from
> transmission of this message or any attachments
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: moritz.bayer@googlemail.com, phillip.smith@weatherbeeta.com.au
Subject: Re: pg_hba.conf & putty
In-Reply-To: <c244500b0703060049g1d037b8ax53efd2b1f4f97b5d@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox