Thread: Fw: Open Office

Fw: Open Office

From
"Scott Taylor"
Date:
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


Re: Fw: Open Office

From
Richard Welty
Date:
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

: Fw: Open Office

From
"Scott Taylor"
Date:
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


Re: : Fw: Open Office

From
Tony Grant
Date:
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