Обсуждение: Re: [JDBC] JDBC - Open Office

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