error 404 /alfresco is not found Windows 7, tomcat

[melttech]

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:MaxPermSize=1024m %LOGGING_MANAGER%
2. alfresco.global.properties :

dir.root=C:/tomcat/alf_data
dir.keystore=${dir.root}/keystore

db.name=alfresco
db.username=alfresco
db.password=alfresco
db.host=localhost
db.port=3306
db.driver=org.gjt.mm.mysql.Driver
db.url=jdbc:mysql://${db.host}:${db.port}/${db.name}
db.pool.validate.query=select 1

3. repository.properties : dir.root=C:/tomcat/alf_data
4. Define PATH : JAVA_HOME, TOMCAT_HOME etc

Anyone can help me?

Windows 7, Tomcat 6, JDK 1.7, MySQL Server 6, Subclipse 1.8, Eclipse J2E Juno

Alfresco Version properties : version.major=4, version.minor=2, version.revision=0, version.label=, version.edition=Community
version.scmrevision=http://svn.alfresco.com/repos/alfresco-open-mirror/alfresco/HEAD/root@44873
version.build=r44873, version.schema=6022

catalina.out : http://pastebin.com/vaErdiey

alfresco.out : http://pastebin.com/iuvpesp1

Cheers,

[melttech]

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

[melttech]

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?

[melttech]

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

[melttech]

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?

[mrogers]

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.

[melttech]

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-confi...

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!