Thread: Fw: Open Office
OK tried these, but seem to be more MySQL related. Is there not a PostgreSQL/OO guru on this list? Scott ----- Original Message ----- From: "J M Okomba" <Okomba@kabage.co.ke> To: <pgsql-jdbc@postgresql.org> Sent: Tuesday, January 21, 2003 3:35 PM Subject: Re: [JDBC] Open Office > > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html
On Tue, 21 Jan 2003 18:51:52 -0000 Scott Taylor <scott.taylor@4i-dotcom.com> wrote:
> OK tried these, but seem to be more MySQL related. Is there not a
> PostgreSQL/OO guru on this list?
i hadn't answered because i figured that someone who actually knew what
they were doing might.
> > > 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.
start with the settings in /var/lib/pgsql/data/pg_hba.conf
postgresql defaults to not answering tcp/ip connnections; you need to turn
this up as part of your configuration process.
richard
--
Richard Welty rwelty@averillpark.net
Averill Park Networking 518-573-7592
Unix, Linux, IP Network Engineering, Security
Here is pg_hba.conf settings # TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD local all all trust host all all 127.0.0.1 255.255.255.255 trust Here is postgresql.conf # # Connection Parameters # tcpip_socket = true #ssl = false The error messages are OO messages, so not sure if they acurate. PostgreSQL is sitting on Cygwin (on MS 98) so not sure if there is something about the way that works. Scott ----- Original Message ----- From: "Richard Welty" <rwelty@averillpark.net> To: <pgsql-jdbc@postgresql.org> Sent: Tuesday, January 21, 2003 7:50 PM Subject: Re: Fw: [JDBC] Open Office > On Tue, 21 Jan 2003 18:51:52 -0000 Scott Taylor <scott.taylor@4i-dotcom.com> wrote: > > > OK tried these, but seem to be more MySQL related. Is there not a > > PostgreSQL/OO guru on this list? > > i hadn't answered because i figured that someone who actually knew what > they were doing might. > > > > > 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. > > start with the settings in /var/lib/pgsql/data/pg_hba.conf > > postgresql defaults to not answering tcp/ip connnections; you need to turn > this up as part of your configuration process. > > richard > -- > Richard Welty rwelty@averillpark.net > Averill Park Networking 518-573-7592 > Unix, Linux, IP Network Engineering, Security > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html
On Tue, 2003-01-21 at 17:08, Scott Taylor wrote: > Here is pg_hba.conf settings > > # TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD > > local all all > trust > host all all 127.0.0.1 > 255.255.255.255 trust > > Here is postgresql.conf > > # > # Connection Parameters > # > tcpip_socket = true > #ssl = false > > The error messages are OO messages, so not sure if they acurate. PostgreSQL > is sitting on Cygwin (on MS 98) so not sure if there is something about the > way that works. Try with your user name and the database name Try with the IP of your machine and a 255.255.255.0 netmask The error you are getting isn't a jdbc error it is a pg_hba.conf error Cheers Tony Grant -- www.tgds.net Library management software toolkit, redhat linux on Sony Vaio C1XD, Dreamweaver MX with Tomcat and PostgreSQL