asked on

Connect SQL400 to MySQL server with OBF:password

Hi Experts,

I use JVAGATE to connect SQL400 to a MySQL server and that is working really great on my own test server.
But now I get the credentials from the real server and received a password looking like this:
"OBF:some_encrypted_code:"
I can't use this in a SQL connect to command.

How can I connect to the server?
Is it possible to add the user and password to the driver string in the config?
or do I need the password in plain text?
or another option?

Thanks.
Theo

lcohan

I believe that could be done by modifying /JVAGATE/conf/global.properties to include the hashed password something like below where you would include that OBF obfuscated value where your Postgres connection is defined:

# you should have something like below in your global.properties file
[...]
ard.url.PGDWS=jdbc:postgresql://xxx.xxx.xxx.xxx:5432/dws
ard.driver.PGDWS=org.postgresql.Driver
[...]
ard.properties.PGDWS.password=OBF:1y7v11w9f1ww1r3f1tvz1rp61vn61wu61w8b1yf21zt11uha1y83

Open in new window

Theo Kouwenhoven

ASKER

Hi Icohan,

Maybe it works with Postgres, but it seems not to work with MySql.
But I will do more tests after the weekend.

lcohan

Sorry for not being clear enough...what I posted was a section for Postgres backend indeed but I believe there must be some similar section for MySQL in that /conf/global.properties file and is just a matter of finding it and check and see where and how the MySQL connection was defined and in my opinion should work somewhat the same for any database. In the end I think this JVAGATE is ultimately relying on a JDBC connectivity in the backend.

ASKER CERTIFIED SOLUTION

Theo Kouwenhoven

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial