Thread: 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
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
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
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 >