Problems starting alfresco - permissions error?

[trs-80]

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/alfresco and set log4j.appender.File.File=/var/log/tomcat5.5/alfresco.log in /var/lib/tomcat5.5/webapps/alfresco/WEB-INF/classes/log4j.properties

The tomcat55 user owns all of those files and /srv/alfresco. However, on startup I get

SEVERE: Error deploying web application archive alfresco.war
<snip>
Caused by: java.security.AccessControlException: access denied (java.io.FilePermission /var/log/tomcat5.5/alfresco.log write)‍‍‍

despite the fact that /var/log/tomcat5.5/alfresco.log exists and is owned by tomcat55. What's going on here?

[rivetlogic]

Hi,

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

-rw-******

Cheers,

–Aladdin

[trs-80]

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
‍‍‍‍‍‍