Hi,
has anyone already successfully installed MAS v9 on OpenShift Local?
I am asking because I am encountering a problem with the "app-cfg-manage" task which raises the error "validate and parse jdbc connection parameter".
IMO it is due to the fact that I use a db external to OCP but that doesn't explain the error as I never had any problems with v8.

Hi,
has anyone already successfully installed MAS v9 on OpenShift Local?
I am asking because I am encountering a problem with the "app-cfg-manage" task which raises the error "validate and parse jdbc connection parameter".
IMO it is due to the fact that I use a db external to OCP but that doesn't explain the error as I never had any problems with v8.

OK, thanks for the information Jason.
That should remove my doubt that there is a generic problem in the ansible related to jdbc configuration with an external db.
Looking at the log it turns out that ansible does not have the jdbc configuration data, as if the API call to retrieve it returns an empty response (even though the JdbcCfg resource is correctly configured).
Of course it would be strange if the problem arose from using OCP Local because I think it is analogous to an SNO scenario. 
I will try the installation from scratch again as soon as I have time.

Hi,
has anyone already successfully installed MAS v9 on OpenShift Local?
I am asking because I am encountering a problem with the "app-cfg-manage" task which raises the error "validate and parse jdbc connection parameter".
IMO it is due to the fact that I use a db external to OCP but that doesn't explain the error as I never had any problems with v8.

Hi Diego - Have you see these steps for OpenShift Local - https://github.com/evilADevil/mas-local

Thanks.

OK, thanks for the information Jason.
That should remove my doubt that there is a generic problem in the ansible related to jdbc configuration with an external db.
Looking at the log it turns out that ansible does not have the jdbc configuration data, as if the API call to retrieve it returns an empty response (even though the JdbcCfg resource is correctly configured).
Of course it would be strange if the problem arose from using OCP Local because I think it is analogous to an SNO scenario. 
I will try the installation from scratch again as soon as I have time.

Hi,
has anyone already successfully installed MAS v9 on OpenShift Local?
I am asking because I am encountering a problem with the "app-cfg-manage" task which raises the error "validate and parse jdbc connection parameter".
IMO it is due to the fact that I use a db external to OCP but that doesn't explain the error as I never had any problems with v8.

OK, thanks for the information Jason.
That should remove my doubt that there is a generic problem in the ansible related to jdbc configuration with an external db.
Looking at the log it turns out that ansible does not have the jdbc configuration data, as if the API call to retrieve it returns an empty response (even though the JdbcCfg resource is correctly configured).
Of course it would be strange if the problem arose from using OCP Local because I think it is analogous to an SNO scenario. 
I will try the installation from scratch again as soon as I have time.

Hi,
has anyone already successfully installed MAS v9 on OpenShift Local?
I am asking because I am encountering a problem with the "app-cfg-manage" task which raises the error "validate and parse jdbc connection parameter".
IMO it is due to the fact that I use a db external to OCP but that doesn't explain the error as I never had any problems with v8.

Hi,
has anyone already successfully installed MAS v9 on OpenShift Local?
I am asking because I am encountering a problem with the "app-cfg-manage" task which raises the error "validate and parse jdbc connection parameter".
IMO it is due to the fact that I use a db external to OCP but that doesn't explain the error as I never had any problems with v8.

Hey Diego

I have it running. I just upgraded my MAS 8.11.12 instance which I installed on OpenShift Local to MAS 9. OpenShift Local is a gamechanger for developers. I tied SNO as well, but was not successful. OpenShift Local is definitely the best option.

I am also using an external DB to OCP - I think this is the easiest if you are trying to install on a laptop like me. I am using SQL Server Developer.

Cheers

Aneesh

------------------------------
Aneesh Joseph

Original Message:
Sent: Wed July 03, 2024 04:25 PM
From: Diego Visentin
Subject: MAS 9 on OpenShift Local

Hi,
has anyone already successfully installed MAS v9 on OpenShift Local?
I am asking because I am encountering a problem with the "app-cfg-manage" task which raises the error "validate and parse jdbc connection parameter".
IMO it is due to the fact that I use a db external to OCP but that doesn't explain the error as I never had any problems with v8.

Hi Aneesh,
Thanks for reassuring us that at least the upgrade process works. 👍
But I would also like to be able to validate the installation from scratch via the CLI. I have tried several of its latest releases, but always to no avail. 
Assuming it works for sure in some scenarios, I suppose there is something untested in mine. For example, using the external db.

Hey Diego

I have it running. I just upgraded my MAS 8.11.12 instance which I installed on OpenShift Local to MAS 9. OpenShift Local is a gamechanger for developers. I tied SNO as well, but was not successful. OpenShift Local is definitely the best option.

I am also using an external DB to OCP - I think this is the easiest if you are trying to install on a laptop like me. I am using SQL Server Developer.

Cheers

Aneesh

------------------------------
Aneesh Joseph

Original Message:
Sent: Wed July 03, 2024 04:25 PM
From: Diego Visentin
Subject: MAS 9 on OpenShift Local

Hi,
has anyone already successfully installed MAS v9 on OpenShift Local?
I am asking because I am encountering a problem with the "app-cfg-manage" task which raises the error "validate and parse jdbc connection parameter".
IMO it is due to the fact that I use a db external to OCP but that doesn't explain the error as I never had any problems with v8.

Diego, were you able to solve this? I stuck exactly on the same step. Doing the maximo POC, for the very first time and I believe I have a very similar setup. Cluster of OCP , and I run db2 (community edition) in docker. I can connect to the db2 instance using from Dbeaver using exactly same jdbc string wihtout a problem. 

But the install fails on "validate and parse jdbc connection parameter". (masinstance-entitymgr-ws-xxxx pod) 

 I am wondering if the jdbc url is not properly passed to the container that runs the ansible job.

Hi Aneesh,
Thanks for reassuring us that at least the upgrade process works. 👍
But I would also like to be able to validate the installation from scratch via the CLI. I have tried several of its latest releases, but always to no avail. 
Assuming it works for sure in some scenarios, I suppose there is something untested in mine. For example, using the external db.

Hey Diego

I have it running. I just upgraded my MAS 8.11.12 instance which I installed on OpenShift Local to MAS 9. OpenShift Local is a gamechanger for developers. I tied SNO as well, but was not successful. OpenShift Local is definitely the best option.

I am also using an external DB to OCP - I think this is the easiest if you are trying to install on a laptop like me. I am using SQL Server Developer.

Cheers

Aneesh

------------------------------
Aneesh Joseph

Original Message:
Sent: Wed July 03, 2024 04:25 PM
From: Diego Visentin
Subject: MAS 9 on OpenShift Local

Hi,
has anyone already successfully installed MAS v9 on OpenShift Local?
I am asking because I am encountering a problem with the "app-cfg-manage" task which raises the error "validate and parse jdbc connection parameter".
IMO it is due to the fact that I use a db external to OCP but that doesn't explain the error as I never had any problems with v8.

Hi Grzegorz,

That time I found that the <InstanceID>-<WorkspaceID>-jdbccfg-workspace-application-binding was empty and I solved it by entering the jdbc parameters by hand.
This is not the way I would recommend, but having also tried opening a ticket with IBM support without getting any useful feedback, I approached the problem in this unorthodox way.

Diego, were you able to solve this? I stuck exactly on the same step. Doing the maximo POC, for the very first time and I believe I have a very similar setup. Cluster of OCP , and I run db2 (community edition) in docker. I can connect to the db2 instance using from Dbeaver using exactly same jdbc string wihtout a problem. 

But the install fails on "validate and parse jdbc connection parameter". (masinstance-entitymgr-ws-xxxx pod) 

 I am wondering if the jdbc url is not properly passed to the container that runs the ansible job.

Hi Aneesh,
Thanks for reassuring us that at least the upgrade process works. 👍
But I would also like to be able to validate the installation from scratch via the CLI. I have tried several of its latest releases, but always to no avail. 
Assuming it works for sure in some scenarios, I suppose there is something untested in mine. For example, using the external db.

Hey Diego

I have it running. I just upgraded my MAS 8.11.12 instance which I installed on OpenShift Local to MAS 9. OpenShift Local is a gamechanger for developers. I tied SNO as well, but was not successful. OpenShift Local is definitely the best option.

I am also using an external DB to OCP - I think this is the easiest if you are trying to install on a laptop like me. I am using SQL Server Developer.

Cheers

Aneesh

------------------------------
Aneesh Joseph

Original Message:
Sent: Wed July 03, 2024 04:25 PM
From: Diego Visentin
Subject: MAS 9 on OpenShift Local

Hi,
has anyone already successfully installed MAS v9 on OpenShift Local?
I am asking because I am encountering a problem with the "app-cfg-manage" task which raises the error "validate and parse jdbc connection parameter".
IMO it is due to the fact that I use a db external to OCP but that doesn't explain the error as I never had any problems with v8.

Diego, were you able to solve this? I stuck exactly on the same step. Doing the maximo POC, for the very first time and I believe I have a very similar setup. Cluster of OCP , and I run db2 (community edition) in docker. I can connect to the db2 instance using from Dbeaver using exactly same jdbc string wihtout a problem. 

But the install fails on "validate and parse jdbc connection parameter". (masinstance-entitymgr-ws-xxxx pod) 

 I am wondering if the jdbc url is not properly passed to the container that runs the ansible job.

Hi Aneesh,
Thanks for reassuring us that at least the upgrade process works. 👍
But I would also like to be able to validate the installation from scratch via the CLI. I have tried several of its latest releases, but always to no avail. 
Assuming it works for sure in some scenarios, I suppose there is something untested in mine. For example, using the external db.

Hey Diego

I have it running. I just upgraded my MAS 8.11.12 instance which I installed on OpenShift Local to MAS 9. OpenShift Local is a gamechanger for developers. I tied SNO as well, but was not successful. OpenShift Local is definitely the best option.

I am also using an external DB to OCP - I think this is the easiest if you are trying to install on a laptop like me. I am using SQL Server Developer.

Cheers

Aneesh

------------------------------
Aneesh Joseph

Original Message:
Sent: Wed July 03, 2024 04:25 PM
From: Diego Visentin
Subject: MAS 9 on OpenShift Local

Hi,
has anyone already successfully installed MAS v9 on OpenShift Local?
I am asking because I am encountering a problem with the "app-cfg-manage" task which raises the error "validate and parse jdbc connection parameter".
IMO it is due to the fact that I use a db external to OCP but that doesn't explain the error as I never had any problems with v8.

More than likely your problem is you missed the CRC setting to allow the VM to see the host network.

crc config set host-network-access true

You can find more info here: https://github.com/evilADevil/mas-local/tree/main/mssql
I also install using the MAS CLI instead the playbook at that link and have no problem.

Diego, were you able to solve this? I stuck exactly on the same step. Doing the maximo POC, for the very first time and I believe I have a very similar setup. Cluster of OCP , and I run db2 (community edition) in docker. I can connect to the db2 instance using from Dbeaver using exactly same jdbc string wihtout a problem. 

But the install fails on "validate and parse jdbc connection parameter". (masinstance-entitymgr-ws-xxxx pod) 

 I am wondering if the jdbc url is not properly passed to the container that runs the ansible job.

Hi Aneesh,
Thanks for reassuring us that at least the upgrade process works. 👍
But I would also like to be able to validate the installation from scratch via the CLI. I have tried several of its latest releases, but always to no avail. 
Assuming it works for sure in some scenarios, I suppose there is something untested in mine. For example, using the external db.

Hey Diego

I have it running. I just upgraded my MAS 8.11.12 instance which I installed on OpenShift Local to MAS 9. OpenShift Local is a gamechanger for developers. I tied SNO as well, but was not successful. OpenShift Local is definitely the best option.

I am also using an external DB to OCP - I think this is the easiest if you are trying to install on a laptop like me. I am using SQL Server Developer.

Cheers

Aneesh

------------------------------
Aneesh Joseph

Original Message:
Sent: Wed July 03, 2024 04:25 PM
From: Diego Visentin
Subject: MAS 9 on OpenShift Local

Hi,
has anyone already successfully installed MAS v9 on OpenShift Local?
I am asking because I am encountering a problem with the "app-cfg-manage" task which raises the error "validate and parse jdbc connection parameter".
IMO it is due to the fact that I use a db external to OCP but that doesn't explain the error as I never had any problems with v8.