Hello,
I am having an issue trying to install Manage using a SQL database server.
I have MAS core up and running using these instructions. Version 8.10.2
https://ibm-mas-manage.github.io/sno/#mas-and-manage-installation
I decided to use the GUI in MAS to install Manage. The SQL database is on AWS RDS right now though I have also tried using a dedicated instance with SQL installed.
I went through configuring the database using this.
https://catalog.us-east-1.prod.workshops.aws/workshops/78554b88-0cd8-45a1-b9ee-2c1078aa6995/en-US/01-masinstallation/01-02-masinstall-private/rds-sqlserver-create
And using different examples of the JDBC connection and options from these sites as well as others.
https://ibm-mas-manage.github.io/sno/#mas-and-manage-installation
https://www.ibm.com/docs/en/maximo-manage/8.0.0?topic=suite-deploying-activating-manage
https://catalog.us-east-1.prod.workshops.aws/workshops/78554b88-0cd8-45a1-b9ee-2c1078aa6995/en-US/01-masinstallation/01-02-masinstall-private/install-manage
However even though I get green checkmarks for the database connections in Configurations, the Manage install stops progressing on database related errors.
TASK [debug] ********************************
ok: [localhost] => {
"status": {
"conditions": [
{
"message": "Server Bundles not deployed in workspace jfc ",
"reason": "Pending",
"status": "False",
"type": "Ready"
},
{
"message": "Build generated and tagged with 20230804T141411-8.6",
"reason": "Build completed",
"status": "True",
"type": "BuildReady"
},
{
"message": " Db Connection Failure updatedb-needed . Deployment all - not deployed",
"reason": "Pending",
"status": "False",
"type": "DeploymentReady"
},
{
"message": "status:dbconnex:failed: Db Connection Failure updatedb-needed ",
"reason": "Failed",
"status": "True",
"type": "DeploymentCR"
I can connect to the database from other locations so I know it is accessible and I've used a JDBC tester on the various connection strings I've tried with success. Could these errors be something other than Manage trying to connect to the SQL database?
These are the latest 2 versions of a JDBC connection I have tried.
No SSL
jdbc:sqlserver://SERVER.amazonaws.com:1433;database=maxdb80;integratedSecurity=false;sendStringParametersAsUnicode=false;selectMethod=cursor;encrypt=false;trustServerCertificate=false;
SSL Enabled
jdbc:sqlserver://SERVER.amazonaws.com:1433;database=maxdb80;integratedSecurity=false;sendStringParametersAsUnicode=false;selectMethod=cursor;encrypt=true;trustServerCertificate=true;
Though I have tried simpler ones like - jdbc:sqlserver://SERVER:1433;databaseName=maxdb80;encrypt=true;
Thanks.
------------------------------
Andrew Meuse
------------------------------