pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedQ: Mac: Openlink->Linux: Openlink-PostgreSQL
3+ messages / 2 participants
[nested] [flat]
* Q: Mac: Openlink->Linux: Openlink-PostgreSQL
@ 1999-09-22 07:12 Jelle Ruttenberg <ruttenberg@neroc.nl>
0 siblings, 0 replies; 3+ messages in thread
From: Jelle Ruttenberg @ 1999-09-22 07:12 UTC (permalink / raw)
To: pgsql-general@postgresql.org.pgsql-interfaces
Hello all,
maybe somewhat off topic here, but the people at OpenLink who are
working on it don't have an answer yet:
I'm using OpenLink Data Access Driver Suite 3.2 to connect from a Mac to
a Linux with PostgreSQL 6.5.1. When I set the authentication in
pg_hba.conf to 'password', the connection is rejected by PostgreSQL with
the message: 'Password authentication failed for user 'nps''. When I set
the authentication to 'trust' it works.
Is there somebody who has been able to get OpenLink with
password-authentication by PostgreSQL working and can give me some
clues?
Thanks,
Jelle.
NOTES:
- password-file: PGDATA/pg_pwd
- users in the password-file: added with CREATE USER
- the passwords aren't encrypted
- connecting the database with 'psql <databasename> -u' works
- OpenLink uses the generic database-agent for PostgreSQL (95?) to
connect to the database
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] Q: Mac: Openlink->Linux: Openlink-PostgreSQL
@ 1999-09-22 09:41 Jelle Ruttenberg <ruttenberg@neroc.nl>
0 siblings, 0 replies; 3+ messages in thread
From: Jelle Ruttenberg @ 1999-09-22 09:41 UTC (permalink / raw)
To: Moray McConnachie <Moray.McConnachie@computing-services.oxford.ac.uk>; +Cc: pgsql-general@postgresql.org; pgsql-interfaces
Hi Moray,
OpSysLogin was already set to No, so I hereby send you the full
oplrqb.ini.
Q:
What file(s) does PostgreSQL need for password-authentication? In the
docs I see something about pg_shadow. I created the users with their
passwords with 'CREATE USER..' and they are in the file pg_pwd
(read/write only for the PostgreSQL-owner) and I haven't specified an
alternative password-file in pg_hba.conf.
Thanks,
Jelle.
>On Wed, 22 Sep 1999 09:12:25 +0200 Jelle Ruttenberg
><ruttenberg@neroc.nl> wrote:
>
>> Hello all,
>>
>> maybe somewhat off topic here, but the people at OpenLink who are
>> working on it don't have an answer yet:
>>
>> I'm using OpenLink Data Access Driver Suite 3.2 to connect from a Mac to
>> a Linux with PostgreSQL 6.5.1. When I set the authentication in
>> pg_hba.conf to 'password', the connection is rejected by PostgreSQL with
>> the message: 'Password authentication failed for user 'nps''. When I set
>> the authentication to 'trust' it works.
>>
>> Is there somebody who has been able to get OpenLink with
>> password-authentication by PostgreSQL working and can give me some
>> clues?
>>
>> Thanks,
>> Jelle.
>
>Check out oplrqb.ini. Make sure you have OpSysLogIn set to
>No under the postgres section. If that doesn't work on its
>own, please post your full oplrqb.ini
>----------------------
>Moray.McConnachie@computing-services.oxford.ac.uk
--------------------------------------------------------------
NEROC Publishing Solutions
Jelle Ruttenberg
De Run 1131, 5503 LB Veldhoven Phone : +31-(0)40-2586641
P.O.Box 133, 5500 AC Veldhoven Fax : +31-(0)40-2541893
The Netherlands E-mail : ruttenberg@neroc.nl
--------------------------------------------------------------
Attachments:
oplrqb.ini.hqx (application/mac-binhex40, 40.4K) download
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] Q: Mac: Openlink->Linux: Openlink-PostgreSQL
@ 1999-09-22 16:06 Herouth Maoz <herouth@oumail.openu.ac.il>
0 siblings, 0 replies; 3+ messages in thread
From: Herouth Maoz @ 1999-09-22 16:06 UTC (permalink / raw)
To: pgsql-general@postgresql.org; pgsql-interfaces
At 09:12 +0200 on 22/09/1999, Jelle Ruttenberg wrote:
> - password-file: PGDATA/pg_pwd
> - users in the password-file: added with CREATE USER
> - the passwords aren't encrypted
> - connecting the database with 'psql <databasename> -u' works
> - OpenLink uses the generic database-agent for PostgreSQL (95?) to
> connect to the database
I am a bit on shaky ground here, but I think the frontend-backend protocol
changed sometime between version 6.2 and 6.3. The specific change was in
fact related to password authentication. (Gurus, correct me if I'm mistaken
in this).
The bottom line of all this is that if you want to use passwords, you have
to have a frontend-backend agent/driver/module which is compatible with the
new protocol. If you mentioned Postgre 95, it's probably an old, old agent.
Herouth
--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1999-09-22 16:06 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-09-22 07:12 Q: Mac: Openlink->Linux: Openlink-PostgreSQL Jelle Ruttenberg <ruttenberg@neroc.nl>
1999-09-22 09:41 Re: [INTERFACES] Q: Mac: Openlink->Linux: Openlink-PostgreSQL Jelle Ruttenberg <ruttenberg@neroc.nl>
1999-09-22 16:06 Re: [INTERFACES] Q: Mac: Openlink->Linux: Openlink-PostgreSQL Herouth Maoz <herouth@oumail.openu.ac.il>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox