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-----
>
> ************
>
>