Thread: I get a error msg when i try to connect to the DB
Hi
I have installed PostGRESql 7.4.17 and when i try to connect to the db i get the msg
psql: FATAL: no pg_hba.conf entry for host "???", user "sfmdb", database "LOGDB", SSL off
My pg_hba.conf entry is as below
# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD
# Disable default configuration
local all all trust
# IPv4-style local connections:
host all all 127.0.0.1 255.255.255.255 trust
# IPv6-style local connections:
host all all ::1 ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff trust
can you please guide me on what the problem might be.
Regards
Rajaram
On Thu, 2007-08-16 at 21:16 +0530, Rajaram J wrote: > Hi > > I have installed PostGRESql 7.4.17 and when i try to connect to the db > i get the msg > > psql: FATAL: no pg_hba.conf entry for host "???", user "sfmdb", > database "LOGDB", SSL off > You are allowing local, non TCP/IP connctions, and connections through the loop back, but you are not allowing remote conncetions. You need an entry of some form that is host all all ??? 255.255.255.255 trust btw, trust is usually bad, you should use some form of authentication. > My pg_hba.conf entry is as below > > > > # TYPE DATABASE USER IP-ADDRESS IP-MASK > METHOD > > # Disable default configuration > > local all all > trust > # IPv4-style local connections: > host all all 127.0.0.1 255.255.255.255 > trust > # IPv6-style local connections: > host all all ::1 > ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff trust > > > can you please guide me on what the problem might be. > > Regards > > Rajaram > > -- Brad Nicholson 416-673-4106 Database Administrator, Afilias Canada Corp.
Hi I tred this option but still i get the same message. Any more options that i can try. Regards Rajaram J ----- Original Message ----- From: "Brad Nicholson" <bnichols@ca.afilias.info> To: "Rajaram J" <rajarj@hotmail.com> Cc: <pgsql-general@postgresql.org> Sent: Thursday, August 16, 2007 9:35 PM Subject: Re: [GENERAL] I get a error msg when i try to connect to the DB > On Thu, 2007-08-16 at 21:16 +0530, Rajaram J wrote: >> Hi >> >> I have installed PostGRESql 7.4.17 and when i try to connect to the db >> i get the msg >> >> psql: FATAL: no pg_hba.conf entry for host "???", user "sfmdb", >> database "LOGDB", SSL off >> > You are allowing local, non TCP/IP connctions, and connections through > the loop back, but you are not allowing remote conncetions. You need an > entry of some form that is > > host all all ??? 255.255.255.255 trust > > btw, trust is usually bad, you should use some form of authentication. > >> My pg_hba.conf entry is as below >> >> >> >> # TYPE DATABASE USER IP-ADDRESS IP-MASK >> METHOD >> >> # Disable default configuration >> >> local all all >> trust >> # IPv4-style local connections: >> host all all 127.0.0.1 255.255.255.255 >> trust >> # IPv6-style local connections: >> host all all ::1 >> ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff trust >> >> >> can you please guide me on what the problem might be. >> >> Regards >> >> Rajaram >> >> > -- > Brad Nicholson 416-673-4106 > Database Administrator, Afilias Canada Corp. > >
<div style="background-color:"><p>Hi<br /><br />Sorry I forgot to give the pg_hba.conf detail<p>Error message - <p>==============removing existing temp installation ==============<br />============== creating temporary installation ==============<br />============== initializing database system ==============<br />==============starting postmaster ==============<br />running on port 65432 with pid 8227<br />==============creating database "regression" ==============<br />createdb: could not connect to database template1:FATAL: missing or erroneous pg_hba.conf file<br />HINT: See server log for details.<br />pg_regress: createdbfailed<br /><br />Present pg_hba.conf entries -<p># TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD<p>local all all trust<br />host all all ???255.255.255.255 trust<br />host all all 0.0.0.0 0.0.0.0 trust<p># IPv4-style local connections:<br />host all all 127.0.0.1 255.255.255.255 trust<br /># IPv6-style local connections:<br />host all all ::1 ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff trust<br /><p>I'm stuck here andcould not proceed any further can you please help.<div><p><font face="Arial" size="2">Regards</font><b><font size="2"><pstyle="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%">Rajaram J <img height="12" src="http://graphics.hotmail.com/emsmile.gif"width="12" /></font></b><font face="Times New Roman" size="2"></font></div></div><brclear="all" /><hr />Live the life in style with MSN Lifestyle. <a href="http://g.msn.com/8HMAENIN/2731??PS=47575"target="_top">Check out! </a>
On 8/18/07, Rajaram J <rajarj@hotmail.com> wrote: > Hi > > I tred this option but still i get the same message. Any more options that i > can try. And after that change you restarted the postmaster? > Regards > Rajaram J Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/htmlmail.htm
Hi Yes I restarted postmaster after that but the problem still persists. Regards Rajaram ----- Original Message ----- From: "Andrej Ricnik-Bay" <andrej.groups@gmail.com> To: "Rajaram J" <rajarj@hotmail.com> Cc: <pgsql-general@postgresql.org> Sent: Saturday, August 18, 2007 4:01 AM Subject: Re: [GENERAL] I get a error msg when i try to connect to the DB > On 8/18/07, Rajaram J <rajarj@hotmail.com> wrote: >> Hi >> >> I tred this option but still i get the same message. Any more options >> that i >> can try. > And after that change you restarted the postmaster? > > >> Regards >> Rajaram J > Cheers, > Andrej > > -- > Please don't top post, and don't use HTML e-Mail :} Make your quotes > concise. > > http://www.american.edu/econ/notes/htmlmail.htm >
On 8/18/07, Rajaram J <rajarj@hotmail.com> wrote: > Hi > Yes I restarted postmaster after that but the problem still persists. OK, Only looked at your file just now. Those ???? are meant to be the IP of your client. You weren't meant to put questionmarks into the file. > Regards > Rajaram Cheers, Andrej