topic Problems starting alfresco - permissions error? in Alfresco Archive

Problems starting alfresco - permissions error?

trs-80 — Tue, 13 Mar 2007 09:59:37 GMT

I'm trying to get alfresco 2 running on Tomcat5.5 on Debian Etch with Sun Java 5. I put the war file in /var/lib/tomcat5.5/webapps, copied the endorsed jars to /usr/share/tomcat5.5/common/endorsed, copied the three core config files to /var/lib/tomcat5.5/shared/classes/afresco, set dir.root to /srv/

Re: Problems starting alfresco - permissions error?

rivetlogic — Mon, 19 Mar 2007 13:26:29 GMT

Hi,

Did you try checking if alfresco.log allows user tomcat55 to write to it?

-rw-******

Cheers,

–Aladdin

Re: Problems starting alfresco - permissions error?

trs-80 — Tue, 20 Mar 2007 01:18:48 GMT

Yes, it can:

-rw-r–r– 1 tomcat55 nogroup 0 2007-03-13 17:56 alfresco.log‍

I got past this error by disabling the security manager (TOMCAT5_SECURITY=NO) as detailed here since I'm using Debian, however then I got

16/03/2007 17:56:53 org.apache.catalina.core.StandardContext start
SEVERE: Error listenerStart
16/03/2007 17:56:53 org.apache.catalina.core.StandardContext start
SEVERE: Context [/alfresco] startup failed due to previous errors
‍‍‍‍‍

so I turned on debugging and hit http://issues.alfresco.com/browse/AR-1196, lowering the log level fixed that, now I can see the root cause:

2007-03-20 10:11:11,454 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Statement execution failed:
   SQL:  alter table JBPM_PROCESSINSTANCE add index FK_PROCIN_ROOTTKN (ROOTTOKEN_), add constraint FK_PROCIN_ROOTTKN foreign key (ROOTTOKEN_) references JBPM_TOKEN (ID_)
   Error: Can't create table './alfresco/#sql-70db_146.frm' (errno: 150)
   File: /var/lib/tomcat5.5/temp/Alfresco/AlfrescoSchemaCreate-org.hibernate.dialect.MySQLInnoDBDialect-40345.sql
   Line: 965
‍‍‍‍‍‍