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

[Dmitry Telegin]

Hello David,

The 4.6.0 release featured the upgrade to Wildfly 14, I believe that could be the cause.

Just did the following (Keycloak 4.8.3):
- added Oracle driver via jboss-cli:
module add --name=oracle --resources=/path/to/oracle.com/ojdbc8.jar --dependencies=javax.api,javax.transaction.api
- went to Wildfly console (localhost:9990) and added a datasource via the UI.

This worked perfectly, and resulted in the following subsystem config (see attachment). I suggest that you check how that is different from what you have currently.

Good luck,
Dmitry Telegin

Carretti Consulting OÜ | Keycloak Consulting and Training
Sepapaja 6, Tallinn 15551, Estonia | info at carretti.pro

On Wed, 2019-06-05 at 13:35 +0000, David Paul wrote:
> Hi all,
> 
>    I was able to determine that it is 4.5.0 to 4.6.0 that breaks the oracle driver load.  Was something changed between those versions that breaks the upgrade process I used (shown in email content below)?  I used that same process from:
> 3.2.1 to 3.4
> 3.4 to 4.0
> 4.0 to 4.1
> 4.1 to 4.2.1
> 4.2.1 to 4.5
> 
> 4.5 to 4.6 causes the error I listed in the below email content.
> My (oracle) linux 7 OS is up to date and I have tried java 7, 8 and openJava 10.   Also I used ojdbc7.jar and ojdbc8.jar drivers
> 
> Has something changed between these versions requiring driver install changes?
> 
> Dave
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> From: David Paul
> Sent: Wednesday, May 22, 2019 11:34 AM
> To: keycloak-user at lists.jboss.org<mailto: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<https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fwww.keycloak.org%2fdocs%2flatest%2fupgrading%2findex.html&c=E,1,VwQodI4TO7fFJHiHwFLI2Ky5yCCJyIMJOTHLO-_ut3MBF4rFAGsufTo9KePMpKkkKVug3UYDwFDLH-LO6iCPxLOaF4iL0ULbAW-gSnhXsA,,&typo=1>
> 
> 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<https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fjboss-cli.sh&c=E,1,ab6YsK-xlZROb7EUCOM3EUCRW9ooNpUK94VbuefL_YpdhbfWp5u-gnQmSpp2ehDfOopcTUJp24TsI9xviiSe2DH8XMX_AoeHoORZmWdet6ZLCouNeg,,&typo=1> -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<https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fstandalone.sh&c=E,1,h9VovdOt-3vQu6oxeF1CbHVJJViK1bTLMPxUFiMqX1Z1nDQT8jQS5gOcx1E-nsnmxQKXMsT-Yw82lgHCCra6aJfyWeAEFGCZR0Ri5NcleGn6hcdGfGfrguLv5l4,&typo=1> 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
> 
> 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.
> 
> 
> 
> 
> _______________________________________________
> keycloak-user mailing list
> keycloak-user at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/keycloak-user
-------------- next part --------------
A non-text attachment was scrubbed...
Name: datasources.xml
Type: application/xml
Size: 1399 bytes
Desc: not available
Url : http://lists.jboss.org/pipermail/keycloak-user/attachments/20190605/54b4f1f4/attachment.rdf