Can't create EjbcaDS

[Piorun2002]

I'm trying to install EJCBA-CE on Windows (wildfly-32 / wildfly-37). I've tested three databases: MS SQL, MySQL, and MariaDB, and I always get the same error:

FLYCTL0186: Services which failed to start: service jboss.persistenceunit."ejbca.ear#ejbca".FIRST_PHASE: org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment] due to: Unable to determine Dialect without JDBC metadata (please set 'jakarta.persistence.jdbc.url' for common cases or 'hibernate.dialect' when a custom Dialect implementation must be provided)
WFLYCTL0448: 609 additional services are down due to their dependencies being missing or failed

I'm trying to initialize the database with the command (the ejcba DB was previously created in SQL):

[standalone@localhost:9990 /] data-source add --name=ejbcads --driver-name="mariadb-java-client-3.4.1.jar" --connection-url="jdbc:mysql://127.0.0.1:3306/ejbca" --jndi-name="java:/EjbcaDS" --use-ccm=true --driver-class="org.mariadb.jdbc.Driver" --user-name="ejbcauser" --password="Pass1234" --validate-on-match=true --background-validation=false --prepared-statements-cache-size=50 --share-prepared-statements=true --min-pool-size=5 --max-pool-size=150 --pool-prefill=true --transaction-isolation=TRANSACTION_READ_COMMITTED --check-valid-connection-sql="select 1;" WFLYCTL0441: Operation has resulted in failed or missing services WFLYCTL0186: Services which failed to start: service jboss.persistenceunit."ejbca.ear#ejbca".__FIRST_PHASE__: or g.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnv ironment] due to: Unable to determine Dialect without JDBC metadata (please set 'jakarta.persistence.jdbc.url' for comm on cases or 'hibernate.dialect' when a custom Dialect implementation must be provided)

How do I set up this Dialect? (I've tried various methods, but without success)

[primetomas]

See how you configure database type in the documentation on pre-requisite configuration.
https://docs.keyfactor.com/ejbca/latest/managing-ejbca-configurations#id-(9.3.3)ManagingEJBCAConfigurations-database.properties

[Piorun2002]

Thank you for your quick reply, this is my database.properties

`

=========================

Database Configuration

=========================

datasource.jndi-name=EjbcaDS
database.name=mysql
database.driver=org.mariadb.jdbc.Driver
database.url=jdbc:mysql://127.0.0.1:3306/ejbca
database.username=ejbcauser
database.password=xxx_real_paass_xxxx

`

[primetomas]

It's a bit hard to follow with the different logs concatenated, i.e. the jboss-cli command and a row from the server.log in the same block. Dialect is derived from the database.name. Did you modify database.properties after building and deploying EJBCA? If you edit this file you need to "ant build deployear" again.

I'm assuming you use the latest version of EJBCA.

[Piorun2002]

I've been trying to fix this bug for several days now. I've tested different versions of Java and Wildfly.

#Environment:
OS: Windows 2025
JAVA: OpenSDK 17 or 21 (tested both)
Wildfly: 32 or 27 (tested both)
SQL: MariaDB or MySQL (tested both)
DBDriver: mysql-connector-j-9.4.0.jar or mariadb-java-client-3.4.1.jar in the wildfly\standalone\deployments directory

#Installation:
EJCBA: git clone https://github.com/Keyfactor/ejbca-ce.git
Creating the database

Adding the configuration file ejbca-ce\conf\database.properties

datasource.jndi-name=EjbcaDS
database.name=mysql
database.driver=org.mariadb.jdbc.Driver
database.url=jdbc:mysql://127.0.0.1:3306/ejbca
database.username=ejbcauser
database.password=SecurePass1234

ant clean deployear (no errors)
start wildfly as standalone
on second terminal

PS C:\EJCBA\ejbca-ce> & "$env:APPSRV_HOME\bin\jboss-cli.bat" --connect
[standalone@localhost:9990 /] data-source add --name=ejbcads --driver-name="mariadb-java-client-3.4.1.jar" --connection-url="jdbc:mysql://127.0.0.1:3306/ejbca" --jndi-name="java:/EjbcaDS" --use-ccm=true --driver-class="org.mariadb.jdbc.Driver" --user-name="ejbcauser" --password="zaq1@WSXcde3" --validate-on-match=true --background-validation=false --prepared-statements-cache-size=50 --share-prepared-statements=true --min-pool-size=5 --max-pool-size=150 --pool-prefill=true --transaction-isolation=TRANSACTION_READ_COMMITTED --check-valid-connection-sql="select 1;"
WFLYCTL0441: Operation has resulted in failed or missing services
WFLYCTL0186:   Services which failed to start:      service jboss.persistenceunit."ejbca.ear#ejbca".__FIRST_PHASE__: or
g.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnv
ironment] due to: Unable to determine Dialect without JDBC metadata (please set 'jakarta.persistence.jdbc.url' for comm
on cases or 'hibernate.dialect' when a custom Dialect implementation must be provided)

full logs from Wildfly
Willdfly_Log.zip

[primetomas]

You are not doing commands in the right order as documented.
What installation instructions are you following? WildFly 27 isn't supported as pretty well documented here: https://docs.keyfactor.com/ejbca/9.1.1/installation-prerequisites
(that's for 9.1.1)
There's no idea trying things that aren't even listed as supported, it will only get you into trouble and you will really have to clean everything and start from scratch as your experiments may leave residue.

For example, "ant deployear", which copies ejbca.ear to the WildFly deployment folder happens after you create the data source, in the output above ejbca.ear is clearly already deployed to WildFly.

I would start all over again, really delete all your old directories and stick to https://docs.keyfactor.com/ejbca/9.1.1/ejbca-installation.

There are many components here, so it's not trivial (Java, WildFly, Database, EJBCA). If you want to see how a installed system will look like try the container. https://github.com/Keyfactor/ejbca-ce/

The only thing you need to configure in database.properties is database.name=mysql, the rest you can leave out.

[dobicinaitis]

Just a heads-up: when using MariaDB, you need to either add ?permitMysqlScheme to the jdbc:mysql... connection string or use jdbc:mariadb... instead.

Docs: https://docs.keyfactor.com/ejbca/latest/wildfly-35#id-(9.3.3)WildFly35-MariaDB.1

MariaDB Connection URL

If you are using MariaDB connector of versions >= 3.0:

• ?permitMysqlScheme must be added to the connection url, if mysql identifier is used, i.e.: jdbc:mysql://127.0.0.1:3306/ejbca?permitMysqlScheme
• or mariadb identifier must be used, i.e.: jdbc:mariadb://127.0.0.1:3306/ejbca

[Piorun2002]

I found a solution/workaround, maybe it will be useful to someone:

Unable to determine Dialect without JDBC metadata (please set 'jakarta.persistence.jdbc.url' for common cases or 'hibernate.dialect' when a custom Dialect implementation must be provided)

So after a long struggle I decided to install an older version of EJBCA 8.3.1, Microsoft OpenJDK 11 and Wildfly 26.1.3 - in this configuration everything works fine and there is no error about 'JDBC Dialect'

[primetomas]

Just a note here: Installing an older version of EJBCA is not an advice I would give anyone. In order to stay up to date and keep your platform secure you need to use recent components.

[Piorun2002]

I completely agree with you, but I'm not a Java developer and couldn't find a solution to this problem, so I decided to use an earlier version where this problem doesn't occur.
My installation procedure (including the .properties files) is consistent with the documentation and works on 8.3.1. If you can advise me which exact version of Java and Wildfly I should use, I can try reinstalling.
I know I'll have to deal with this issue sooner or later because we're using nCipehr HSM and need to test PKI PQC, so support for ML- algorithms will be needed.

[primetomas]

Did you use the command noted by Adnris above about MariaDB clients >3.0?

[Piorun2002]

Yes, I had this setting and tested three databases: MS SQL, MySQL and MariaDB - I had the same error on all of them.
It seems that changing JAVA from 21/17 to 11 solved the problem.
I'll try reinstalling - now I have a routine that works on 8.3.1, so it will be easier to compare the results with version 9.x.

[primetomas]

Actually your error to create DS has nothing todo with EJBCA. Since EJBCA is not even deployed, simply creating the datasource in WildFly is a pure WildFly/JDBC driver topic.

For me it works well with the following command (from the EJBCA install doc), I'm using MariaDB java client 3.5.1. Why are you using an old version btw? Using WildFly 35 and Java 21.
https://docs.keyfactor.com/ejbca/latest/ejbca-installation

/opt/wildfly/bin/jboss-cli.sh --connect 'data-source add --name=ejbcads2 --connection-url="jdbc:mysql://127.0.0.1:3306/ejbca?permitMysqlScheme" --jndi-name="java:/EjbcaDS2" --use-ccm=true --driver-name="mariadb-java-client.jar" --driver-class="org.mariadb.jdbc.Driver" --user-name="ejbca" --credential-reference={store=defaultCS, alias=dbPassword} --validate-on-match=true --background-validation=false --prepared-statements-cache-size=50 --share-prepared-statements=true --min-pool-size=5 --max-pool-size=150 --pool-prefill=true --transaction-isolation=TRANSACTION_READ_COMMITTED --check-valid-connection-sql="select 1;"'

[Piorun2002]

I managed to upgrade to 9.1.1 - and I didn't encounter any errors with 'Dialect'

Thank you for your support.

[primetomas]

Fantastic. Thanks for the update.