pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jeanna Geier <jgeier@apt-cafm.com>
To: Juan Miguel Paredes <juan.paredes@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Beginner's Question: No pg_hba.conf entry for host...SSL Off
Date: Tue, 26 Sep 2006 09:57:15 -0500
Message-ID: <008701c6e17c$0ec8c1f0$6700a8c0@geier> (raw)
References: <005a01c6e16f$36655d70$6700a8c0@geier>
	<9e0a28690609260634n76a8a45fo6e5c28be367aad2f@mail.gmail.com>

Hi and thanks so much for the replies!!

I had perused that doc and google prior to posting and didn't have any luck; 
what I tried was the following:

added:
private static final String DB_SSL_STATUS = "true";
&
prop.setProperty("ssl", DB_SSL_STATUS);

...
public class DatabaseConnection {
    private static String DB_IP;

    private static final String DB_PORT = "5432";
    private static String DB_CATALOG = "apt";
    private static final String DB_USER = "postgres";
    private static final String DB_PASSWORD = "XXXX";
    private static final String DB_SSL_STATUS = "true";

    public static void initIPAddress(String address){
        DB_IP = address;
    }

    public static void initCatalog(String catalog){
        DB_CATALOG = catalog;
public static Connection initialize() throws SQLException
    {
        final Connection connection;
        Properties prop = new Properties();
        String url;

        try{
            Class.forName("org.postgresql.Driver");

            //url = "jdbc:postgresql://64.34.162.40:5432/apt";
            url = "jdbc:postgresql://" + DB_IP + ":" + DB_PORT + "/" + 
DB_CATALOG;

            //prop.setProperty("user","postgres");
            //prop.setProperty("password", "XXXX");
            //prop.setProperty("ssl", "true");
            prop.setProperty("user", DB_USER);
            prop.setProperty("password", DB_PASSWORD);
            prop.setProperty("ssl", DB_SSL_STATUS);

            connection = DriverManager.getConnection(url, prop);
            connection.setTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED);

            if(connection == null){
                throw new Exception();
            }

            Thread maintainConn = new Thread(new Runnable(){
                public void run(){
                    while(connection != null){
                        try{
                        maintainConnection(connection);
                        //10 minutes
                        Thread.sleep(600000);
                        }
                        catch(InterruptedException ie){}
                   }
                }
            });
            maintainConn.setDaemon(true);
            maintainConn.start();
        }
        catch(ClassNotFoundException cnf){
            throw new SQLException(cnf.getMessage());
        }
        catch(Exception e){
            throw new SQLException(e.getMessage());
        }

        return connection;
    }


However, when I do that, it's throwing an exception from: connection = 
DriverManager.getConnection(url, prop);
and I'm getting an error message that says: "The connection attempt failed."

Any other ideas?

Much thanks, as always.
-Jeanna


----- Original Message ----- 
From: "Juan Miguel Paredes" <juan.paredes@gmail.com>
To: "Jeanna Geier" <jgeier@apt-cafm.com>
Cc: <pgsql-admin@postgresql.org>
Sent: Tuesday, September 26, 2006 8:34 AM
Subject: Re: [ADMIN] Beginner's Question: No pg_hba.conf entry for 
host...SSL Off


> On 9/26/06, Jeanna Geier <jgeier@apt-cafm.com> wrote:
>> Hi All-
>>
>> I am hoping for some help on this one...  we are in the process of
>> implementing our program with SSL enabled on the Postgres side of things. 
>> I
>> can start and connect to the database from the command line ok using my
>> current configuration:
>>
>>   C:\msys\1.0\local\pgsql\bin>psql -d apt -U postgres
>>   Welcome to psql 8.0.8, the PostgreSQL interactive terminal.
>>
>>   Type:  \copyright for distribution terms
>>        \h for help with SQL commands
>>        \? for help with psql commands
>>        \g or terminate with semicolon to execute query
>>        \q to quit
>>
>>   SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
>>
>>   Warning: Console code page (437) differs from Windows code page (1252)
>>          8-bit characters may not work correctly. See psql reference
>>          page "Notes for Windows users" for details.
>>
>>   apt=#
>>
>> However, when I try to run our application to and connect to the 
>> database, I
>> am receiving the following error: Connection rejected: FATAL: no 
>> pg_hba.conf
>> entry for host "127.0.0.1", user "postgres", database "apt", SSL off.
>>
>> Here is my pg_hba.conf file:
>>
>>   # TYPE DATABASE USER CIDR-ADDRESS METHOD
>>   # IPv4 local connections:
>>   #host all all 127.0.0.1/32 trust
>>   # IPv6 local connections:
>>   hostssl all all 127.0.0.1/32 trust
>>
>> I'm assuming that I have to put some code in my program to enable this
>> connection besides just putting it in the conf file...but where exactly
>> would this go?  Below is an excerpt of our connection code:
>>
>> public class DatabaseConnection {
>>     private static String DB_IP;
>>
>>     private static final String DB_PORT = "5432";
>>     private static String DB_CATALOG = "apt";
>>     private static final String DB_USER = "postgres";
>>     private static final String DB_PASSWORD = "XXXX";
>>
>>     public static void initIPAddress(String address){
>>         DB_IP = address;
>>     }
>>
>>     public static void initCatalog(String catalog){
>>         DB_CATALOG = catalog;
>>     }
>>
>>     public static Connection initialize() throws SQLException
>>     {
>>         final Connection connection;
>>         Properties prop = new Properties();
>>         String url;
>>
>>         try{
>>             Class.forName("org.postgresql.Driver");
>>
>>             //url = "jdbc:postgresql://64.34.162.40:5432/apt";
>>             url = "jdbc:postgresql://" + DB_IP + ":" + DB_PORT + "/" +
>> DB_CATALOG;
>>
>>             //prop.setProperty("user","postgres");
>>             //prop.setProperty("password", "XXXX");
>>             prop.setProperty("user", DB_USER);
>>             prop.setProperty("password", DB_PASSWORD);
>
> Hi, Jeanna... I'm not a java programmer, but it looks like you could use
>
> props.setProperty("ssl","true");
>
> as seen in postgresql jdbc documentation:
>
> http://jdbc.postgresql.org/documentation/80/connect.html
>
> Regards.
> 




view thread (7+ messages)  latest in thread

Message-ID: <008701c6e17c$0ec8c1f0$6700a8c0@geier>
Permalink:  ../008701c6e17c$0ec8c1f0$6700a8c0@geier/
Also on:    postgresql.org/message-id/008701c6e17c$0ec8c1f0$6700a8c0@geier

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: jgeier@apt-cafm.com, juan.paredes@gmail.com
  Subject: Re: Beginner's Question: No pg_hba.conf entry for host...SSL Off
  In-Reply-To: <008701c6e17c$0ec8c1f0$6700a8c0@geier>
  References: <005a01c6e16f$36655d70$6700a8c0@geier> <9e0a28690609260634n76a8a45fo6e5c28be367aad2f@mail.gmail.com> <008701c6e17c$0ec8c1f0$6700a8c0@geier>

* 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