[Babase] Re: Ranker security problems
Jun Yang
junyang at gmail.com
Thu Aug 23 23:21:08 EDT 2007
Forgot to cc the babase list...
On 8/23/07, Jun Yang <junyang at gmail.com> wrote:
> On 8/20/07, Karl O. Pinc <kop at meme.com> wrote:
> >
> > Jun,
> >
> > I believe that the ranker program is not attemping
> > to establish an SSL connection. Either the PQconnectdb()
> > call is not passing the right 'sslmode' parameter keyword
> > ("prefer" would be best, in the db server I ensure that
> > connections going through the VPN are not double-encrypted
> > with libpq's SSL as well) or the libpq was not compiled with
> > SSL support. See:
> >
> > http://www.postgresql.org/docs/8.1/static/libpq.html#LIBPQ-CONNECT
> >
> > I'm pretty sure that at one point when Tyler was directly
> > connecting to papio, before we tried the VPN, the ranker
> > was connecting with SSL enabled.
>
> I make the fix this weekend, but before I proceed I'd like to
> understand exactly where the problem is. I just tried JDBC
> connection from a Java application running on papio,
> and it was able to connect to the database server without specifying
> any ssl property during connection. So just to make sure: ssl is
> needed only when connecting from biology.duke.edu machine
> (thus without vpn) other than papio itself, right?
>
> --- Jun Y.
>
More information about the Babase
mailing list