JDBC - Open Office

Scott,

the url may be wrong, I think it should be
jdbc:postgresql://localhost/accs

Dave

On Mon, 2002-12-16 at 12:10, Scott Taylor wrote:

I am trying to connect to PostgreSQL 7.2 in Open Office on Red Hat 8. I
have downloaded the driver pg73jdbc3.jar into my JAVA_HOME/lib/ext.

In OO I have completed the "new datasources" with the following
parameters:

URL - jdbc:postgresql:accs
Driver Class - org.postgresql.Driver
Username - XXXXXX
Character Set - system

All the docs say you can download a pre-compiled driver or compile your
own source. Most of the docs seem to assume you have taken the source
option.

OO cannot seem to connect, and asks to check username/password. It also
says that no java is installed. Java -version confirms it is installed.
Is their a special configuration for java with OO? Can anyone see a
problem?

Regards

Scott

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

--
Dave Cramer <Dave@micro-automation.net>

OO cannot seem to connect, and asks to check username/password. It also
says that no java is installed. Java -version confirms it is installed.
Is their a special configuration for java with OO? Can anyone see a
problem?

When you installed OO, where did you tell it java was located? My best
guess is that you need to update OO's opinion of which java to use.
--
Steve Wampler <swampler@noao.edu>
National Solar Observatory

What does 'which java' points to?

Scott Taylor wrote:

I am trying to connect to PostgreSQL 7.2 in Open Office on Red Hat 8. I
have downloaded the driver pg73jdbc3.jar into my JAVA_HOME/lib/ext.

In OO I have completed the "new datasources" with the following
parameters:

URL - jdbc:postgresql:accs
Driver Class - org.postgresql.Driver
Username - XXXXXX
Character Set - system

All the docs say you can download a pre-compiled driver or compile your
own source. Most of the docs seem to assume you have taken the source
option.

OO cannot seem to connect, and asks to check username/password. It also
says that no java is installed. Java -version confirms it is installed.
Is their a special configuration for java with OO? Can anyone see a
problem?

--
Fernando Nasser
Red Hat Canada Ltd. E-Mail: fnasser@redhat.com
2323 Yonge Street, Suite #300
Toronto, Ontario M4P 2C9

Yes TCP/IP was set to to "true". As mentioned previously, there is no
problem with postmaster as I use it regularly.

So my problem remains that I cannot connect to PostgreSQL through Open
Office by JDBC using these parameters

URL -jdbc:postgresql://localhost/accs
Driver -org.postgresql.Driver
Username -xxxxx
Character Set -system

Any ideas?

Scott

On Mon, 2002-12-16 at 22:07, Fernando Nasser wrote:

Scott Taylor wrote:

In the "new data source" in OO where the driver information is, it asks
for username and password. I assume it means for PostgreSQL not the
system?

I am on the same machine as the server, and my pg_hba.conf file has the
following access:

# TYPE DATABASE IP_ADDRESS MASK AUTH_TYPE
AUTH_ARGUMENT

local all trust
host all 127.0.0.1 255.255.255.255 trust

# Using sockets credentials for improved security. Not available
everywhere,
# but works on Linux, *BSD (and probably some others)

local all ident sameuser

This would still not let you connect using TCP/IP. You must start your
postmaster with '-i' or change the line in your postgresql.conf file from:

#tcpip_socket = false

to:

tcpip_socket = true

i.e., uncomment it and make it true (and restart your server).

psql will connect regardless as it will use Unix sockets for a local database by
default.

--
Fernando Nasser
Red Hat - Toronto E-Mail: fnasser@redhat.com
2323 Yonge Street, Suite #300
Toronto, Ontario M4P 2C9

--
Scott Taylor
Managing Director
4i dotCom

Phone: +44 7767 257 371
Email: scott.taylor@4i-dotcom.com
Web: http://www.4i-dotcom.com

This transmission is confidential and intended for the named recipient
only. Should you not be the person or entity named, please be advised
that you have received this in error, and that you should delete this
immediately.

"™µú¡Ûû†ÚV´}_aGG)O¤ÇÞä‡ïŠeØWŒ`î”ÀO‘Ãü–ÀJèŠeB–ò˵ýõ[\%ðˆ;.Aó¶¡UGÒ~å?~‡¹PÉFÃL¬7¾tI

Scott,

So my problem remains that I cannot connect to PostgreSQL through Open
Office by JDBC using these parameters

URL -jdbc:postgresql://localhost/accs
Driver -org.postgresql.Driver
Username -xxxxx
Character Set -system

I haven't used JDBC with OpenOffice data sources, as I remember that
configuration was a real pain. Do you have any other JDBC data sources that
you could play with to see if the issue is Postgres or OOo-JDBC?

Alternately, can you try connecting via JDBC from a simple java program to try
and get more detailed error messages?

--
-Josh Berkus
Aglio Database Solutions
San Francisco