Ant runinstall failed with : CLI could not contact EJBCA instance.

[gilles380]

Hi support team,
I traveled all along the install procedure (Mariadb/WildFly,and ejbca github ) , then if fail on last mile, I read in the forum about wildfly possibly not well configured, but as I am not skilled in application server, I don't have any clue.
My installation
EJBCA from github https://github.com/Keyfactor/ejbca-ce (ant deployear, ant build then ant runinstall)
WildFly is 26 (following https://doc.primekey.com/ejbca/ejbca-installation/application-servers/jboss-eap-7-4#JBossEAP7.4-ConfigureWildFlyRemoting)
MariaDB 11.3.2, database setup (https://doc.primekey.com/ejbca/ejbca-installation/creating-the-database#CreatingtheDatabase-MariaDB/MySQL)
Please find the WildFly log attached
wildfly.log
Then I can provide other usefull information for you to help me on this.
Many thanks
G.

[svenska-primekey]

From the log there is no ejbca.ear file being loaded. What is in the deployment directory for wildfly? If you followed the directions the path should be /opt/wildfly/standalone/deployment

[gilles380]

Also, I have

2024-03-07 10:41:36,448 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("deploy") failed - address: ([("deployment" => "ejbca.ear")]) - failure description: {
"WFLYCTL0412: Required services that are not installed:" => ["jboss.naming.context.java.EjbcaDS"],
"WFLYCTL0180: Services with missing/unavailable dependencies" => [
"jboss.persistenceunit."ejbca.ear#ejbca".FIRST_PHASE is missing [jboss.naming.context.java.EjbcaDS]",
"jboss.persistenceunit."ejbca.ear#ejbca" is missing [jboss.naming.context.java.EjbcaDS]"
]
}
2024-03-07 10:41:36,514 ERROR [org.jboss.as] (Controller Boot Thread) WFLYSRV0026: WildFly Full 26.0.0.Final (WildFly Core 18.0.0.Final) started (with errors) in 7607ms - Started 5377 of 6249 services (674 services failed or missing dependencies, 409 services are lazy, passive or on-demand)

[primetomas]

"missing [jboss.naming.context.java.EjbcaDS]" looks like either this command wasn't executed, or didn't succeed, i.e. adding the data source (EjbcaDS) to WildFly configuration.
https://doc.primekey.com/ejbca/ejbca-installation/application-servers/wildfly-26#WildFly26-AddDatabaseDriver
and
https://doc.primekey.com/ejbca/ejbca-installation/application-servers/wildfly-26#WildFly26-AddaDatasource

[primetomas]

You missed to set MySQL as database in:
https://doc.primekey.com/ejbca/ejbca-installation/managing-ejbca-configurations#ManagingEJBCAConfigurations-database.properties

[primetomas]

"Unknown table 'sequences' in information_schema" (most likely) means the information in database.properties was wrong when the ear file was built. If you change values afterwards you must:
"ant clean deployear"

Cheers

[gilles380]

Thanks @primetomas and @svenska-primekey for your support.