Re: [JDBC] JDBC - Open Office
От | Scott Taylor |
---|---|
Тема | Re: [JDBC] JDBC - Open Office |
Дата | |
Msg-id | 1040117561.1128.23.camel@localhost.localdomain обсуждение исходный текст |
Ответы |
Re: [JDBC] JDBC - Open Office
|
Список | pgsql-novice |
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
В списке pgsql-novice по дате отправления: