DBvisualizer on MacOS X

Hi again,

URL: jdbc:postgresql//192.168.0.253:8000/template1

I have put a colon after postgresql and it partly works. (The line now
looks: "URL: jdbc:postgresql://192.168.0.253:8000/template1". But now I
get a message like "Connection denied. Check that the server accepts
TCP/IP connections."

Thx

Thiemo

--
Thiemo Kellner
Tösstalstrasse 146
CH-8400 Winterthur

Hi Thiemo-

Do you either have the tcpip_socket flag set in postgresql.conf or a -i flag
on the command line for the server?

If not, take a look here for instructions:
http://www.fankhausers.com/postgresql/jdbc/#tcpip. You may also want to read
down further in the same document for info on connection authorization if
you haven't already set that up.

Regards,

-NickF

-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of thiemo
Sent: Wednesday, March 13, 2002 2:15 AM
To: pgJDBC; pgGeneral
Subject: [JDBC] Fwd: DBvisualizer on MacOS X

Hi again,

URL: jdbc:postgresql//192.168.0.253:8000/template1

I have put a colon after postgresql and it partly works. (The line now
looks: "URL: jdbc:postgresql://192.168.0.253:8000/template1". But now I get
a message like "Connection denied. Check that the server accepts TCP/IP
connections."

Thx

Thiemo

--
Thiemo Kellner
T�sstalstrasse 146
CH-8400 Winterthur

Hi,

Do you either have the tcpip_socket flag set in postgresql.conf or a -i
flag
on the command line for the server?

thanks I had the command line argument -o for this option. However, I
included the options in the config file.

Cheers

Thiemo

--
Thiemo Kellner
Tösstalstrasse 146
CH-8400 Winterthur

Maybe just a typo:

URL: jdbc:postgresql//192.168.0.253:8000/template1

but you need a colon after 'postgresql' e.g. 'jdbc:postgresql://...' as JDBC will parse the URL looking for the 'postgresql' and not find it... your TCP port number should be fine to leave at 8000 (begs the question why tho ;) as long as its reflected in the URL, but if you want to change it, put this (or uncomment it) in the postgresql.conf file:

port = 5432

Cheers,
Joe

-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org [mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of thiemo
Sent: Wednesday, 13 March 2002 18:10
To: pgJDBC; pgGeneral
Subject: [JDBC] DBvisualizer on MacOS X

Hello,

I try to connect to a PostgreSQL 7.2 db with DB-Visualizer 2.1 on MacOS X (well , the DB is on SuSE), but get the following message:
"No suitable driver.
There is no driver that can handle a connection for the
specified URL. The most common reason is that the driver
is not in the CLASSPATH or among the list of dynamically
loaded drivers. Also check that the URL is correct spelled."

My settings are:
"Database Alias: Template1
JDBC Driver: org.postgresql.Driver
URL: jdbc:postgresql//192.168.0.253:8000/template1
Userid
postgres
pasword *****"

I have loaded, as can be seen, the jdbc driver. But couldn't find the file dbvis.lax to integrate it into its class path. BTW, I have compiled postgres myself with option port 8000. Does anyone happen to know how I can fix this?

Thx

Thiemo

--
Thiemo Kellner
Tösstalstrasse 146
CH-8400 Winterthur