JBoss Error When Doing a Fresh Installation of Appian 16.2

sattamd over 7 years ago

Hi,
I am up for a fresh installation of Appian 16.2 on a Windows 64 bit environment with 4GB RAM. I have installed JBoss EAP 6.4.0 and MySQL server 5.7.13.
After going through the installation guide and following the steps I configured the server. I could start the Appian engines and the search-server without any issue. However, while starting Jboss I get the following error "could not load driver for module [com.mysql.jdbc]" and some missing dependencies for the AppianDS(datasource).
I am using a J connector (MySQL-connector-java-5.1.39-bin.jar) driver and jdk 8.
I am using configure script to deploy the configurations to Jboss home.
Attaching the jboss log file. Any help would be greatly appreciated.
Thanks.

server.log

Discussion posts and replies are publicly visible

0 sattamd over 7 years ago

Here are the configuration files that reside in the configuration repository directory of appian home
standalone.xml.dev
appian-mysql-ds.xml.dev
custom.properties.dev
module.xml.txt
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 chandolum
A Score Level 1
over 7 years ago

@sattamd : hope the below link will helps you,
forum.appian.com/.../Configuring_Relational_Databases.html
and can you change file name of appian-mysql-ds.xml to appian-ds.xml and give a try
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sattamd over 7 years ago

I tried changing the name and followed exactly the same steps as given I the link. Still, I get the same error.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 bhanuprakashm over 7 years ago

@sattamd can you please try the "mysql-connector-java-5.1.31.jar" file instead of -5.1.39.. I am also face the same issue..just I changed the jar file.. it is working.
Please check let me know..
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sattamd over 7 years ago

sure I will check
can you please share the jar file here
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 stefanom469 over 7 years ago

This caused me a big headache yesterday, but I solved, don't know why, giving a different name to the driver, both in standalone.xml and in appian-mysql-ds.xml. So I had driver name "mysql", while module name was still "com.mysql.jdbc". Also double check that module.xml and mysql-connector-java-5.1.39-bin.jar are in folder com/mysql/jdbc/main if your module is called com.mysql.jdbc, it might seems silly, but at some point, when I had almost tried anything from different guides I mixed paths and names and I found that I was missing jdbc folder (com/mysql/main).
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sattamd over 7 years ago

sorry I could not get you Stefan. what exactly should I change?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sattamd over 7 years ago

@Stefan the path for the connector and module.xml is com/MySQL/jdbc/main. Should I change the driver name property as MySQL?? is that what you are suggesting?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 stefanom469 over 7 years ago

actually, I'm not sure it is case sensitive (I'm quite new to java), but my folders reflect exactly the module name, everything lowercase. I was suggesting 2 things:
1) try using different names for driver and module (keep in mind that module name have to reflect the folder structure), so driver name: "mysql" (remember to change it also in yout appian-mysql-ds.xml file, module name "com.mysql.jdbc", folder structure "modules/com/mysql/jdbc/main"
2) be sure that module name reflects folder structure (as above)
Hope it can help
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sattamd over 7 years ago

@Stefan I will check it and get back to you. Thanks for the gesture
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel