[keycloak-user] Upgrade to 6.0.1 - Oracle driver failing to load

[Huw McNamara]

Hi David,

We had a similar problem that was caused by the enhanced validation added in later EAPs, mentioned here https://access.redhat.com/solutions/4010511

I can't remember the exact solution but I think we had a class wrongly specified in our xml and we had to correct it per the documentation https://access.redhat.com/documentation/en-us/red_hat_jboss_enterprise_application_platform/7.0/html/configuration_guide/datasource_management#example_oracle_xa_datasource.


Regards,
Huw
________________________________
From: keycloak-user-bounces at lists.jboss.org <keycloak-user-bounces at lists.jboss.org> on behalf of David Paul <dpaul at cognera.com>
Sent: 23 May 2019 17:44
To: keycloak-user at lists.jboss.org
Subject: Re: [keycloak-user] Upgrade to 6.0.1 - Oracle driver failing to load

Any ideas on this?

One suggestion was to use the CLI to add the driver.  Tried that and no change.

Is there a way to increase logging beyond DEBUG?  Or is there somewhere it logs more information other than the server.log file?   It says failed to load but doesn't give details as to why.

Thanks,
Dave





Harriscomputer

David Paul
Manager, Application Development
P: 403-218-2010 x79107
F: 403-218-2012
E: dpaul at cognera.com


[cid:cognera_logo_214_d306d615-a7fa-4e98-bd69-dcc2e13056da.png]


530 - 8 Avenue SW Suite 920
Calgary, Alberta
T2P 3S8
www.cognera.com<http://www.cognera.com>


This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message.




From: David Paul
Sent: Wednesday, May 22, 2019 11:34 AM
To: keycloak-user at lists.jboss.org
Subject: Upgrade to 6.0.1 - Oracle driver failing to load

Hi,

I have a working standalone 3.2.1 on linux using Oracle DB 12.1 as its data store that I'm upgrading to 6.0.1.  I'm running into a problem getting it to load the oracle driver and I assume I'm missing a step but I have followed the guide here:
https://www.keycloak.org/docs/latest/upgrading/index.html

I have:
unpacked 6.0.1
mv standalone directory to standalone.old
cp -R 3.2.1/standalone to 6.0.1/
cp -R 3.2.1/modules/system/layers/keycloak/org/oracle  6.0.1/modules/system/layers/keycloak/org/
cp -R 3.2.1/themes/<our-themes> 6.0.1/themes/
6.0.1/bin/jboss-cli.sh -file=bin/migrate-standalone.cli          (feedback indicates success on all actions)
Made sure migrationStrategy value="update"

When I run 6.0.1/bin/standalone.sh I get:
...
09:26:10,588 ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 31) WFLYCTL0013: Operation ("add") failed - address: ([
    ("subsystem" => "datasources"),
    ("jdbc-driver" => "oracle")
]) - failure description: "WFLYJCA0114: Failed to load datasource class: oracle.jdbc.driver.OracleDriver"

Again, this works in my 3.2.1 on the same server, so I assume my datasource and driver declaration are correct in standalone.xml file as well as the module.xml and ojdbc8.jar.  I also can confirm the datastore is in use for the 3.2.1 install through connecting to the DB store using TOAD for oracle.  I have confirmed permissions on the entire Keycloak directory structure are identicle between the 3.2.1 and 6.0.1 locations.

Is there another step or declaration of the driver or something that I must do?

Thank you for your time,
Dave