Connect NB 6.9.1 to PostgreSQL 8.4 on remote server

[aml148]

Running NB 6.9.1 on XP box, PostgreSQL 8.4 on remote Ubuntu 10.04.1) box. PgSQL server is set up, and a blank database has been created. Attempting to register SQL server with:

Host: jdbc:postgresql://host.company.com/schema.database
Port: 5432

This gives an error message "DatabaseException: Unknown host". But I can ping the host successfully with the same string.

Ubuntu box IS enabled for remote access via an entry in pg_hba.conf (and I can connect to the remote Ubuntu database with local psql client using the same credentials I'm giving to NB). Also, I can make a connection to the database in NB and see tables, fields etc.

PostgreSQL JDBC driver DOES show in project's "libraries" list, and is listed as postgresql-8.3-603.jdbc3.jar. That seems suspect since I am running pgSQL 8.4, but checking for updates on NB-Help yields "everything is current" message. I'm still suspicious - do I need a newer driver? If so, where do I get it?

And if not, what else have I overlooked?

Thanks in advance for your help.

[Ryan Cuprak]

Try resolving the hostname in Java. It could be some sort of configuration issue. I once had a problem on Linux where ping could resolve addresses but Java could not. Network configuration was setup incorrectly. Your situation is slightly different but Java and ping might be using different mechanisms to resolve the address.

Ryan

On Oct 5, 2010, at 5:18 PM, aml148 <address-removed> wrote:

[aml148]

It _was_ a configuration issue - thanks!