topic Re: Alfresco application not starting on Tomcat in Alfresco Archive

Alfresco application not starting on Tomcat

xymak1y — Mon, 07 Feb 2011 11:46:54 GMT

Hello,following setup:xampp-win32-1.7.4-VC6 including MySQL and Tomcat, and MySQL connector mysql-connector-java-5.1.14 (not community). The database connection is working, Alfresco added a alf_bootstrap_lock table to it, so the connection is up and running.Java opts:set JAVA_OPTS=-Xms256m -Xmx1024

Re: Alfresco application not starting on Tomcat

mrogers — Mon, 07 Feb 2011 12:11:13 GMT

"org.alfresco.error.AlfrescoRuntimeException: 01070000 A previous schema upgrade failed or was not completed. Revert to the original database before attempting the upgrade again."

You probably got impatient and killed Alfresco while it was installing the DB. It should take a couple of minutes. If this is a new install then drop the database and delete the content store and start again. If not restore from backup.

Re: Alfresco application not starting on Tomcat

xymak1y — Mon, 07 Feb 2011 13:06:39 GMT

I emptied the database, removed all users and set it up from scratch:

CREATE DATABASE alfresco DEFAULT CHARACTER SET utf8;

GRANT ALL ON alfresco.* TO 'alfresco'@'localhost' identified BY 'alfresco' WITH
GRANT OPTION;

GRANT ALL ON alfresco.* TO 'alfresco'@'localhost.localdomain' identified BY
'alfresco' WITH GRANT OPTION;‍‍‍‍‍‍‍

I then cleaned up the stopped TC, cleaned up the /webapps directory, and re-deployed all three .war files.

This is the log file after deploying:

http://nopaste.voric.com/paste.php?f=lpuqlk

Apparently the SQL is malformed? The database is running on InnoDB engine.