topic Re: Getting 404 error when I changed my h2 database to mysql in Alfresco Archive

Getting 404 error when I changed my h2 database to mysql

krishan_deo — Thu, 10 Mar 2016 05:12:00 GMT

Hi,When I changed my h2 database to mysql database in db.properties file then I am getting, HTTP Status 404 - /activiti-explorer when I open the activiti explorer.Please help me I am using 5.19 version.Thank You

Re: Getting 404 error when I changed my h2 database to mysql

hari — Thu, 10 Mar 2016 07:09:25 GMT

Hi Krishan,
Ideally it has to work. The community members here will not be able to help you with the information which you have provided. Please share the logs etc.
But clearly what I can say is that it could only be because of the db configurations being incorrect. Please verify them.

Re: Getting 404 error when I changed my h2 database to mysql

krishan_deo — Thu, 10 Mar 2016 07:21:39 GMT

Hello Sir
I have verified my db.properties, every thing is fine still I am getting error
Failed to load resource: http://localhost:8080/activiti-explorer the server responded with a status of 404 (Not Found)
My db.properties file
db=mysql
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/activiti
jdbc.username=root
jdbc.password=root

Re: Getting 404 error when I changed my h2 database to mysql

hari — Thu, 10 Mar 2016 09:36:01 GMT

Hi Krishan,

Check if the mysql service is up and running in your system. And if it up, check the port and the user credentials by trying to connect to it with the db client. If everything works and not just here the look at the logs and see whats getting printed there.

Re: Getting 404 error when I changed my h2 database to mysql

krishan_deo — Sat, 30 Apr 2016 10:03:02 GMT

mysql service is up and running fine with other java example, I searched log in var/log directory but there is no log file.

Re: Getting 404 error when I changed my h2 database to mysql

faizal-manan — Tue, 10 May 2016 03:27:11 GMT

1. verify act_* table
2. reconfigure log4j

you should able to see the stacktrace during starting your webserver. It's should be there unless it turn off

Re: Getting 404 error when I changed my h2 database to mysql

mahamuniraviraj — Sun, 22 May 2016 07:09:35 GMT

mysql-connector-java-x.x.xx.jar is missing. Download the jar from maven repository. If you are deploying activiti-explorer war in Tomcat, then copy mysql connector jar to following folder : {TOMCAT_HOME}/webapps/activiti-explorer/WEB-INF/lib.