pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Moray McConnachie <moray.mcconnachie@computing-services.oxford.ac.uk>
To: José Carlos Faial <faial@intelectum.com.br>
To: pgsql-interfaces@hub.org
Subject: Re: [INTERFACES] Openlink Universal Data Access
Date: Fri, 3 Sep 1999 16:12:05 +0100
Message-ID: <01b301bef61e$aebf3190$760e01a3@oucs.ox.ac.uk> (raw)
References: <513C757322FBD11185A400C0DF46C270237F81@BOSS>

I've used the combination you describe.  One of OpenLink's options requires
a user to have a log-on account - opsyslogin set to Yes under
[generic_pgr95] in oplrqb.ini. Try setting it to no, if your postgres log-in
details differ from your system log-in details.

You also need to make sure that the postgres database has a rather open
security policy, or that a user and password which can log in to the
postgres database (*not* (necessarily) the uid and password of the postgres
super user) is specified under  [generic_pgr95] in oplrqb.ini

YOu will need to restart the broker after every change of oplrqb.ini. Read
all the comments in the oplrqb.ini file, and you should soon work out what's
going on.

Otherwise, post the contents of your oplrqb.ini & the contents of your
pg_hba.conf - it does sound as though you have set incorrectly the
authorisation method required.

Alternatively, a post to one of openlink's own newsgroups might be better.


----- Original Message -----
From: José Carlos Faial <faial@intelectum.com.br>
To: <pgsql-interfaces@hub.org>
Sent: Friday, September 03, 1999 3:41 PM
Subject: [INTERFACES] Openlink Universal Data Access


> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi all,
> Somebody is using Openlik Universal Data Access (multi-tier version) for
> access a PostgreSQL database? I installed the Request broker, pgr95_sv
> agent on my Linux Server and Generic Odbc driver in a machine running
> windows 95.
> So, here is the problem: when a test my connection the odbc driver (in
> windows) results this error:
> Connection Failled
> SQLSTATE = "08004", NativeError = 0, ErrorMsg = "[OpenLink][ODBC]invalid
> username/password"
> SQLSTATE = "08004", NativeError = 0, ErrorMsg =
> "[OpenLink][ODBC]Connection reject by data source"
>
> In Request Broker Log:
> 05:48:11 10.0.0.34 called (10.0.0.34.1072)
> 05:48:11 request: domain=PostgreSQL database=faial serveropts=
> 05:48:11   connectopts=10.0.0.1 user=faial opsys=win32 readonly=0
> 05:48:11   application=ODBCCP32 processid=4294512091
> 05:48:11 solve mapping: pgr95:faial:faial:msdos:10.0.0.34:ODBCCP32:rw
> 05:48:11 using mapping: pgr95:*:*:*:*:*:*
> 05:48:11 using [generic_pgr95] ServerProgram=pgr95_sv
> 05:48:11 unsuccessful login attempt for faial
> 05:48:11 rejected faial@10.0.0.34.ODBCCP32 (invalid username/password)
>
> The database name is faial, the username is faial (I can connect using
> pgsql or by postODBC driver) and the password is testdb.
>
> Somebody can help me??
>
> In time: I configure the oplrqb.ini with a enviroment for this database,
> like this:
> [generic_pgr95]
> Description = Default settings for Postgress 95 agent
> Program     = pgr95_sv
> OpSysLogin  = yes
> ReUse       = never
> ;CommandLine    = -T
> ;ConnectOptions =
> ;Directory      = /tmp
> Database        = faial
> Userid          = faial
> Password        = testdb
> ReadOnly        = No
>
> Thanks.
>
> ________________________________________
> Jose Carlos Faial - Network Manager
> Registered Linux User #133319
> E-mail: faial@intelectum.com.br
>
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGPfreeware 6.0.2 for non-commercial use <http://www.pgp.com;
>
> iQA/AwUBN8/c8IuTSrQ9LukdEQJPgwCcDALMxX6FxszbeE79O7h9fAGhNJkAoITM
> VTuy4jT+aQR9yURyUWEVeiKw
> =vxzm
> -----END PGP SIGNATURE-----
>
> ************
>
>




view thread (2+ messages)

Message-ID: <01b301bef61e$aebf3190$760e01a3@oucs.ox.ac.uk>
Permalink:  ../01b301bef61e$aebf3190$760e01a3@oucs.ox.ac.uk/
Also on:    postgresql.org/message-id/01b301bef61e$aebf3190$760e01a3@oucs.ox.ac.uk

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: moray.mcconnachie@computing-services.oxford.ac.uk, faial@intelectum.com.br, pgsql-interfaces@hub.org
  Subject: Re: [INTERFACES] Openlink Universal Data Access
  In-Reply-To: <01b301bef61e$aebf3190$760e01a3@oucs.ox.ac.uk>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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