topic Re: error 404 /alfresco is not found Windows 7, tomcat in Alfresco Archive

error 404 /alfresco is not found Windows 7, tomcat

melttech — Mon, 24 Dec 2012 05:02:55 GMT

I tried debugging this for a week and tried almost every solutions but nothing seems to work.Steps : I download the source code from alfresco svn using Subclipse and Ant built it. Launch tomcat (startup.bat)Solutions that i tried : 1. Catalina.bat : set JAVA_OPTS=%JAVA_OPTS% -Xms512m -Xmx1024m -XX:M

Re: error 404 /alfresco is not found Windows 7, tomcat

melttech — Thu, 27 Dec 2012 01:01:57 GMT

Well, seems no one is replying. I Configured the tomcat log4j logging described in http://tomcat.apache.org/tomcat-7.0-doc/logging.html#Using_Log4j and now the log shows the real problem with the spring configuration.

from this point, im configuring alfresco to workd with Oracle database. Goodbye MySQL.

here is the alfresco.log : http://pastebin.com/i15tEU83

Re: error 404 /alfresco is not found Windows 7, tomcat

melttech — Thu, 27 Dec 2012 02:01:07 GMT

Failed to get resource: alfresco/ibatis/#resource.dialect#/activities-insert-SqlMap.xml

the activities-insert-SqlMap.xml is missing in alfresco/ibatis/org.hibernate.dialect.Dialect

do i have to find this activities-insert-SqlMap.xml

or find the oracle dialect and configure it in hibernate-context.xml?

Re: error 404 /alfresco is not found Windows 7, tomcat

melttech — Thu, 27 Dec 2012 03:01:02 GMT

Again, i'm answering my own question.

Seem i get a lots of missing xml file after finding activities-insert-SqlMap.xml, I recommand you guys downloading org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect at https://github.com/krumboeck/oracle-alfresco/tree/master/src/config/alfresco

I downloaded all the files and paste it in \webapps\alfresco\WEB-INF\classes\alfresco\ibatis\ and C:\tomcat\webapps\alfresco\WEB-INF\classes\alfresco\dbscripts

Next error to be solved is : Caused by: java.rmi.server.ExportException: Port already in use: 50504; nested exception is:
java.net.BindException: Address already in use: JVM_Bind

Re: error 404 /alfresco is not found Windows 7, tomcat

melttech — Thu, 27 Dec 2012 03:13:58 GMT

solution for RMI port already in use : https://forums.alfresco.com/en/viewtopic.php?t=16915

Then, i received Context initialization failed error.

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'tenantAdminDAO' defined in class path resource [alfresco/dao/dao-context.xml]: Cannot resolve reference to bean 'repoSqlSessionTemplate' while setting bean property 'sqlSessionTemplate'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'repoSqlSessionTemplate' defined in class path resource [alfresco/ibatis/ibatis-context.xml]: Cannot resolve reference to bean 'repoSqlSessionFactory' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'repoSqlSessionFactory' defined in class path resource [alfresco/ibatis/ibatis-context.xml]: Invocation of init method failed; nested exception is org.springframework.core.NestedIOException: Failed to parse config resource: class path resource [alfresco/ibatis/alfresco-SqlMapConfig.xml]; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: org.apache.ibatis.builder.BuilderException: Error creating document instance. Cause: org.xml.sax.SAXParseException; lineNumber: 5; columnNumber: 7; Element type "html" must be declared.

alfresco.log : http://pastebin.com/txvkFsnP

anybody can help?

Re: error 404 /alfresco is not found Windows 7, tomcat

mrogers — Thu, 27 Dec 2012 23:20:50 GMT

I suggest you install using an installer until you are familiar with a working instance of alfresco.

Don't try to use Oracle with alfresco community, its not supported.

Your original problem was either the "alfresco" database did not exist or the account used to access the database did not have enough permissions to create tables.

Re: error 404 /alfresco is not found Windows 7, tomcat

melttech — Fri, 28 Dec 2012 01:14:39 GMT

Okay. I'm turning back to MySQL and got this in my alfresco.log

Connecting to database: jdbc:mysql:///alfresco, UserName=alfresco@localhost, MySQL-AB JDBC Driver
09:04:44,768 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
09:04:48,980 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema auto-update failed
org.activiti.engine.ActivitiException: couldn't create db schema: create table ACT_RU_EXECUTION (
ID_ varchar(64),
REV_ integer,
PROC_INST_ID_ varchar(64),
BUSINESS_KEY_ varchar(255),
PARENT_ID_ varchar(64),
PROC_DEF_ID_ varchar(64),
SUPER_EXEC_ varchar(64),
ACT_ID_ varchar(255),
IS_ACTIVE_ TINYINT,
IS_CONCURRENT_ TINYINT,
IS_SCOPE_ TINYINT,
IS_EVENT_SCOPE_ TINYINT,
SUSPENSION_STATE_ integer,
CACHED_ENT_STATE_ integer,
primary key (ID_),
unique ACT_UNIQ_RU_BUS_KEY (PROC_DEF_ID_, BUSINESS_KEY_)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin
at org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:853)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes

I realized i didnt set the database configuration : http://docs.alfresco.com/4.0/index.jsp?topic=%2Fcom.alfresco.enterprise.doc%2Fconcepts%2Fmysql-config-settings.html

and didnt add the ?useUnicode=yes&characterEncoding=UTF-8 at the end of db.url in alfresco-global.properties

Now i got my alfresco running. Thx!