Thread: Openlink Universal Data Access

Openlink Universal Data Access

From
José Carlos Faial
Date:
-----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-----


Re: [INTERFACES] Openlink Universal Data Access

From
"Moray McConnachie"
Date:
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-----
>
> ************
>
>