Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Has anyone successfully configured CLM 6.0.6.1 on Oracle RDS from AWS?

Questions
Tags
Users
Badges
Ryan McBryde
(59●1●12●33) Mar 17 '23, 3:15 p.m.

Yes, 6.0.6.1 is out of support.

I am trying to upgrade to 7.0.2 but I am using SQL Server and I can't run RDNG 7.0.2 on SQL Server, so I have to migrate the databases over to Oracle.  We have the apps running on AWS EC2 and we currently have the databases on SQL Server 2014 RDS.  The Oracle RDS has been created and the necessary databases as well.  The databases have been set up with data encryption so certificates come into the picture.

We keep running into this error:

The server was unable to connect to the database because the database connection settings are invalid or because database is unreachable (SQLSTATE: 08006, SQLCODE: 17002). Verify the connection settings in your teamserver.properties file.

The connection string referenced:

com.ibm.team.repository.db.jdbc.location=thin:<DBNAME>/{password}@//hostname.rds.amazonaws.com:1521:<SID>

Has anyone successfully set up CLM 6.0.6.1 or 7.0.2 using secured Oracle RDS?

0 votes

Comments
Ian Barnard
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Mar 18 '23, 11:33 a.m.
See the docs https://www.ibm.com/docs/en/elm/7.0.2?topic=server-establishing-secure-oracle-database-connection-liberty - that topic doesn't exist for 6.0.6.1 but might be worth trying?  

Ryan McBryde
Mar 18 '23, 6:29 p.m.
Thanks Ian, I am looking at that article and it is helpful.  I was hoping that in the vast universe of Rational users that there was someone who had it working with either 6.0.6.1 or 7.0.2. 

David Honey
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Mar 20 '23, 4:29 a.m.
Have you tried DBeaver to see if you can successfully connect through JDBC?

Ryan McBryde
Mar 20 '23, 6:00 p.m.
I have used DB Visualizer to successfully ping the host and port but cannot connect.  I think it's an issue with certificates, ewallet files, etc. as described here: https://www.ibm.com/support/pages/node/6468589 Doesn't seem to work with RDS however. 

1 answer
2,963 views
0 votes

One answer

Permanent link
Ian Barnard
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (3.0k●7●15) edited
Apr 04 '23, 6:30 a.m.
First try the steps documented for 7.0.2 which may work for older versions: https://www.ibm.com/docs/en/elm/7.0.2?topic=server-establishing-secure-oracle-database-connection-liberty

Something else you could try, based on experience with 6.0.6.1 getting a secured connection to SQL Server: I had to update the jre to get it to work. I think this is because the SSL/TLS implementation is in JRE and there have been breaking changes since the JRE shipped with 6.0.6.1 - sorry, I don't have more detail.

Obviously care is needed replacing the JRE so get a backup of everything first! Strongly suggest doing this in a test environment first!


To update: Download the jre archive from the link above, delete the jre folder in 6.0.6.1 and copy over from the archive

Run java -version to confirm it's the new version

Then the SSL connection will hopefully work.

0 votes

Comments
Ryan McBryde
Apr 18 '23, 10:41 a.m.
HI Ian, Thanks for your help.  I seem to have gotten working but still working out exactly got it to work.  I did update the JRE as you suggested, but I also created a wallet file, converted it to a jks file and then added lines to use it to the server startup bat file.  I also discovered that the database passwd had an @ sign in it and that was causing problems so I changed the passwd.  It now works and as I said I am trying to document exactly what was done and which pieces did what.  I will post again with the results of that.   Now I am trying to do the same for my JAS database and running into similar issues.  Any experience with that?

Ian Barnard
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Apr 21 '23, 5:29 a.m.
See https://www.ibm.com/support/pages/node/6468589 - although note that the modifications to repotools.sh/bat must be remade after any ifix update or use of repotools -clean (because this redeploys them from the application code) Also apparently at least on linux ORACLE_JDBC_DRIVE_FILE should point at only the ojbc8.jar not the list of files as shown in technote  

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 7,622
× 1,452

Question asked: Mar 17 '23, 3:15 p.m.

Question was seen: 2,963 times

Last updated: Apr 21 '23, 5:29 a.m.

Confirmation Cancel Confirm