[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: Problem with connection to host (wrong host)
From:       Melvin Davidson <melvin6925 () gmail ! com>
Date:       2018-03-31 16:00:37
Message-ID: CANu8Fiymdo284dK5sSHg+SkyioPwkJ8_nsft+OqakkdOrYodng () mail ! gmail ! com
[Download RAW message or body]

On Sat, Mar 31, 2018 at 11:44 AM, Mike Martin <redtux1@gmail.com> wrote:

> Hi
> I am just setting up a postgres server, details
> Host 192.168.0.3
> pg_hba.conf
> # TYPE  DATABASE        USER            ADDRESS                 METHOD
>
> # "local" is for Unix domain socket connections only
> local   all             all                                     peer
> # IPv4 local connections:
> host    all             all             192.168.0.0/32            ident
> # IPv6 local connections:
> host    all             all             127.0.0.1/32            ident
>
> host    all             all             ::1/128                 ident
>
> postgresql.conf
> listen_addresses-'*'
>
> however when I try to connect from my laptop (ip 192.168.0.2) I get
>
> psql -h 192.168.0.3 -U usevideo -W
> Password for user usevideo:
> psql: FATAL:  no pg_hba.conf entry for host "192.168.0.2", user
> "usevideo", database "usevideo", SSL off
>
> So a bit confused, is psql ignoring the host parameter
>
> thanks
>
>
>




*>So a bit confused, is psql ignoring the host parameter It is not ignoring
your entry, you simply have not entry for the laptop you are connecting
from,So simply add the following:*
*host    all             all             192.168.0.2/32
ident     *           <- note, you may have to change the authentication
method depending on your environment



-- 
*Melvin Davidson*
*Maj. Database & Exploration Specialist*
*Universe Exploration Command – UXC*
Employment by invitation only!

[Attachment #3 (text/html)]

<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On Sat, Mar \
31, 2018 at 11:44 AM, Mike Martin <span dir="ltr">&lt;<a \
href="mailto:redtux1@gmail.com" target="_blank">redtux1@gmail.com</a>&gt;</span> \
wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px \
#ccc solid;padding-left:1ex"><div \
dir="ltr"><div><div><div><div><div><div><div>Hi<br></div>I am just setting up a \
postgres server, details<br></div>Host 192.168.0.3<br></div>pg_hba.conf<br># TYPE  \
DATABASE        USER            ADDRESS                 METHOD<br><br># \
&quot;local&quot; is for Unix domain socket connections only<br>local   all           \
all                           <wbr>          peer<br># IPv4 local \
connections:<br>host    all             all             <a \
href="http://192.168.0.0/32" target="_blank">192.168.0.0/32</a>            ident<br># \
IPv6 local connections:<br>host    all             all             <a \
href="http://127.0.0.1/32" target="_blank">127.0.0.1/32</a>            \
ident<br><br>host    all             all             ::1/128                 \
ident<br><br></div>postgresql.conf<br>listen_addresses-&#39;*&#39;<br><br></div>however \
when I try to connect from my laptop (ip 192.168.0.2) I get<br><br>psql -h \
192.168.0.3 -U usevideo -W<br>Password for user usevideo: <br>psql: FATAL:  no \
pg_hba.conf entry for host &quot;192.168.0.2&quot;, user &quot;usevideo&quot;, \
database &quot;usevideo&quot;, SSL off<br><br></div>So a bit confused, is psql \
ignoring the host parameter<br><br></div>thanks<br><div><div><br><div><br></div></div></div></div>
 </blockquote></div>
<div><b>&gt;So a bit confused, is psql ignoring the host parameter

<br><br>It is not ignoring your entry, you simply have not entry <br>for the laptop \
you are connecting from,<br>So simply add the following:<br></b><br></div><b>host    \
all             all             192.168.0.<span \
style="color:rgb(255,0,0)">2</span>/32            ident     </b>           &lt;- \
note, you may have to change the authentication method depending on your \
environment<br>

<br><br clear="all"><br>-- <br><div class="gmail_signature" \
data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div \
dir="ltr"><font size="4"><b><span style="font-family:courier new,monospace">Melvin \
Davidson</span></b></font><b><span style="color:red"><br>Maj. Database &amp; \
Exploration Specialist</span></b><b><br>Universe Exploration Command – <span \
style="color:blue;background:yellow">UXC</span><span \
style="color:blue"></span></b><b></b><span \
style="font-size:8.0pt;color:blue"><br>Employment by invitation only!</span>

</div></div></div></div></div></div>
</div></div>



[prev in list] [next in list] [prev in thread] [next in thread]