Re: problem connecting from JDBC - Mailing list pgsql-jdbc

Hi,
I did set the tcp/ip socket value to true in postgresql.conf. And I added
the line:
host all 127.0.0.1 255.0.0.0 trust
to pg_hba.conf file. This file already had the line:
local all all ident sameuser
I left it as it is. Now it shows me the error:
Missing or erroneous pg_hba.conf file

Thanks,
Ravi.



>From: "Nick Fankhauser" <nickf@ontko.com>
>Reply-To: <nickf@ontko.com>
>To: "Ravi Kanth" <ravi_kanth@msn.com>, <pgsql-jdbc@postgresql.org>
>Subject: Re: [JDBC] problem connecting from JDBC
>Date: Mon, 10 Nov 2003 12:29:03 -0500
>
>Ravi-
>
>I'd suggest checking in postgresql.conf to make sure tcpip_socket is set to
>on & also check pg_hba.conf to make sure the authorization info is set up
>to
>allow local connections.
>
>Take a look here for a more complete explanation:
>
>http://www.fankhausers.com/postgresql/jdbc/welcome.html#tcpip
>
>
>-Nick
>
> > -----Original Message-----
> > From: pgsql-jdbc-owner@postgresql.org
> > [mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of Ravi Kanth
> > Sent: Monday, November 10, 2003 11:44 AM
> > To: pgsql-jdbc@postgresql.org
> > Subject: [JDBC] problem connecting from JDBC
> >
> >
> > Hi,
> > I am trying to access postgresql database (7.3.2 - that came by
> > default with
> > RedHat Linux 9 distro) using JDBC. I have a Linux user called
> > "oracle" that
> > I have created in postgresql also and gave that user privileges
> > to create a
> > database.
> > I tried to create a databse using createdb and it works.
> > The url that I am using in JDBC is:
> > "jdbc:postgresql://localhost:5432/test",
> > "oracle", "". It reverts bck with error that says:
> > SQLException: Connection refused. Check that the hostname and port are
> > correct and that the postmaster is accepting TCP/IP connections.
> > I am using JDK 1.4.2 and NetBeans IDE.
> > Can anyone plz help? Thanks.
> >
> > Ravi.
> >
> > _________________________________________________________________
> > Compare high-speed Internet plans, starting at $26.95.
> > https://broadband.msn.com (Prices may vary by service area.)
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 9: the planner will ignore your desire to choose an index scan if
>your
> >       joining column's datatypes do not match
> >
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

_________________________________________________________________
Send a QuickGreet with MSN Messenger
http://www.msnmessenger-download.com/tracking/cdp_games