Hi,

That sounds like a database misconfiguration, the tomcat catalina.out log file might give more details of the error. You could try to configure the datasource following Custom Database Configuration. If you are installing on Ubuntu, why don't you try following the steps in Installation on Linux?

I have tried that method yes with the same result. I also wanted to try and install the components as I am likely to need to install in varying environments. Tomcat is working as I see this error but I am still not able to open it as advised previously.

I've looked in the logs and get the following in joget.log and catalina.out

ERROR 12 Apr 2016 08:28:08 org.joget.commons.spring.web.CustomContextLoaderListener  - ===== Error initializing WebApplicationContext =====

Sounds like a database misconfiguration. Can you check your app_datasource-default.properties file to make sure that the settings are correct eg mysql default port is 3306

Where do I find this file? I cant see it.

It's in the wflow directory as mentioned in https://dev.joget.org/community/display/KBv5/Custom+Database+Configuration

Hi Anders,

Found the file. Can it be moved to the tomcat folder instead? its sitting in the roots home folder which is not great.

The file I found only includes the following line (Including the date/time):

currentProfile=jwdb

Obviously this is missing a lot of information which is why its not working. I suspect this will be because I am running as the root user which is causing permissions issues when it configures.

Thanks

I was having this same problem. It took me almost the entire flight from ATL to SFO, but I finally was able to get it working.

The website instructions for setting up the database does not work. In the readme in the installation directory, I found the answer. In order to set up the database, you must run setup.sh. This will ask you all the questions to set up the app_datasource-default.properties file, AND it will create the database and all the tables for you.

One more issue I had was that setup.sh runs an ANT task which invokes the mysql command and mysql bin directory was not in my path, so I had to add it.

Good Luck!

Hi, It looks like you're missing a file? There should be properties 2 files in the wflow directory. If your profile name is "jwdb" then you should see the 2 files: app_datasource.properties and app_datasource-jwdb.properties. The 2nd file is the one containing the JDBC settings. Yup, it's possible to modify the location of the wflow directory by setting the JVM environment variable -Dwflow.home=path_to_wflow_directory, e.g. https://dev.joget.org/community/display/KBv5/Deployment+Best+Practices#DeploymentBestPractices-JavaVMTuning Hope this helps!

I encountered the same issue while upgrading v4.0.34 to v5.0.25 (Linux x64)

Problem solved after upgrading JDK from 7u25 to 8u202.

Hi John, if you don't mind,

Would you please provide me the complete tutorial on doing this?

Because I'm having the same problem and yet, I still can't figure out on how to solve it.

Thank you.