Thread: Open Office

Open Office

From
"Scott Taylor"
Date:
I wonder whether anyone could either point me to some decent documentation
on connecting to Open Office, or correct the information below from the
Datsources box in OO.

Name: PostgreSQL
Database Type: JDBC
URL: jdbc:postgresql://localhost:5432/recruitment

Driver Class: org.postgresql.Driver
Username: Scott
Password: check
Character: system

I have version 7.3.1 (Cygwin on 98) and the driver pg73jdbc3.jar is in my
classpath as follows:

SET
CLASSPATH=C:\j2sdk1.4.1_01\lib\tools.jar;C:\cygwin\usr\share\postgresql\java
\pg73jdbc3.jar

I have also set TCP/IP sockets =true and have trust for authentication

I am getting the following errors in OO:

1. No connection could be established for the URL
jdbc:postgresql://localhost:5432/recruitment.

2. Connection refused. Check that the hostname and port are correct and that
the postmaster is accepting TCP/IP connections.

3. Please check the current settings, e.g. user name and password.

Thanks

Scott



Re: Open Office

From
Tony Grant
Date:
On Tue, 2003-01-21 at 08:48, Scott Taylor wrote:

> 3. Please check the current settings, e.g. user name and password.

try using another authentication than trust. I have had problems with
this from time to time on Linux.

Cheers

Tony Grant

--
www.tgds.net Library management software toolkit,
redhat linux on Sony Vaio C1XD,
Dreamweaver MX with Tomcat and PostgreSQL


Re: Open Office

From
J M Okomba
Date:
Check http://www.itworld.com/nl/lnx_desktop/09052002/?idgnet
and http://documentation.openoffice.org/HOW_TO/data_source/data1_EN.html

The MySQL example at http://kienlein.com/pages/mysql-jdbc-howto-en.html
could also help


> -----Original Message-----
> From:    Scott Taylor [SMTP:scott.taylor@4i-dotcom.com]
> Sent:    21 January 2003 13:49
> To:    pgsql-jdbc@postgresql.org
> Subject:    [JDBC] Open Office
>
> I wonder whether anyone could either point me to some decent documentation
> on connecting to Open Office, or correct the information below from the
> Datsources box in OO.
>
> Name: PostgreSQL
> Database Type: JDBC
> URL: jdbc:postgresql://localhost:5432/recruitment
>
> Driver Class: org.postgresql.Driver
> Username: Scott
> Password: check
> Character: system
>
> I have version 7.3.1 (Cygwin on 98) and the driver pg73jdbc3.jar is in my
> classpath as follows:
>
> SET
> CLASSPATH=C:\j2sdk1.4.1_01\lib\tools.jar;C:\cygwin\usr\share\postgresql\ja
> va
> \pg73jdbc3.jar
>
> I have also set TCP/IP sockets =true and have trust for authentication
>
> I am getting the following errors in OO:
>
> 1. No connection could be established for the URL
> jdbc:postgresql://localhost:5432/recruitment.
>
> 2. Connection refused. Check that the hostname and port are correct and
> that
> the postmaster is accepting TCP/IP connections.
>
> 3. Please check the current settings, e.g. user name and password.
>
> Thanks
>
> Scott
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Re: Open Office

From
Nagy István
Date:
Scott,

I faced a similar problem several weeks ago (PostgreSQL 7.2 and
OpenOffice1.0.1).

There were three step i had to arrange to access the back end.

Your situation might be different because  i use a network.
PostgreSQL and OpenOffice instances run on different hosts and i use
password authentication

1., I put the postgresql.jar in the $JAVA_HOME/jre/lib/ext directory on all
'OpenOffice' hosts
2., I installed the OpenOffice again because java support hadn't been
installed
(click 'more' on the error message.A new panel will appear. Click on the
'Error' branch.
If you see a 'No javainstalled' message in the description then your
OpenOffice is unable to use java)
I suppose that you can modify your current installation by using the setup
of the OpenOffice.
3., I added the following line to the $PGDATA/pg_hba.conf:
host    NAME_OF_THE_DATABASE    IPADDRESS_OF_THE_OPENOFFICE_HOSTS
NETMASK_OF_THE_IP    password    NAME_OF_THE_PG_PASSWORD_FILE

the password for the username i use to connect to the backend is stored in
the $PGDATA/NAME_OF_THE_PG_PASSWORD_FILE

After re-starting the OpenOffice I was able to connect to the PostgreSQL.


Regards
Istvan Nagy

----- Original Message -----
From: Scott Taylor <scott.taylor@4i-dotcom.com>
To: <pgsql-jdbc@postgresql.org>
Sent: Tuesday, January 21, 2003 2:48 PM
Subject: [JDBC] Open Office


> I wonder whether anyone could either point me to some decent documentation
> on connecting to Open Office, or correct the information below from the
> Datsources box in OO.
>
> Name: PostgreSQL
> Database Type: JDBC
> URL: jdbc:postgresql://localhost:5432/recruitment
>
> Driver Class: org.postgresql.Driver
> Username: Scott
> Password: check
> Character: system
>
> I have version 7.3.1 (Cygwin on 98) and the driver pg73jdbc3.jar is in my
> classpath as follows:
>
> SET
>
CLASSPATH=C:\j2sdk1.4.1_01\lib\tools.jar;C:\cygwin\usr\share\postgresql\java
> \pg73jdbc3.jar
>
> I have also set TCP/IP sockets =true and have trust for authentication
>
> I am getting the following errors in OO:
>
> 1. No connection could be established for the URL
> jdbc:postgresql://localhost:5432/recruitment.
>
> 2. Connection refused. Check that the hostname and port are correct and
that
> the postmaster is accepting TCP/IP connections.
>
> 3. Please check the current settings, e.g. user name and password.
>
> Thanks
>
> Scott
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>