Alfresco 3 stable with Mysql

[peter-adams]

Can anyone help?

I have setup a new Ubuntu server and installed Mysql 5  and Alfresco 3 stable.  Before starting Alfresco, I edited the custom-repository.properties to change the database directory to mysql, remove the Derby config and add the mysql.  I also edited the custom-hiberate-dialect.properties file to remove Derby and add Mysql.  Then I edited the Alfresco.sh to configure the JAVA_HOME.

When I start up, tomcat runs (I tested it with an index.html file), but Alfresco fails with a 404 error.  From everything I have read, it appears that the mysql-connector-java-5.0.3-bin.jar was missing.  I downloaded this and placed it in the /tomcat/lib folder, but I am not sure how it gets called?  In anycase, it still does not work.

One last point, Before doing this clean install, I did the standard Derby install and it worked, so it is definitely something to do with the mysql connection.  I can connect manually to the Alfresco database, so I know that the MYsql itself is okay.

[mrogers]

You need to post any errors from the Alfresco.log files.

And did you create an empty database and account for alfresco to use?

[peter-adams]

Yes, I created an empty Alfresco dtb and have pasted the logs below:

custom-hibernate.properties

#
# BSRV2 Hibernate configuration for changing Database dialect
# For a full list: http://www.hibernate.org/hib_docs/v3/re … l-dialects
#
#
# MySQL dialect (default)
#
hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect

custom-repository.properties

###############################
## Common Alfresco Properties #
###############################

#
# Sample custom content and index data location
#
dir.root=/usr/lib/mysql
dir.indexes=/opt/Alfresco/alf_data/lucene-indexes

#
# Sample database connection properties
#
db.name=alfresco
db.username=alfresco
db.password=alfresco
#db.pool.initial=10
#db.pool.max=100

#
# External locations
#
ooo.exe=/usr/lib/openoffice/program/soffice
ooo.user=${dir.root}/oouser
img.root=/usr/local
swf.exe=/opt/Alfresco/bin/pdf2swf

#
# Property to control whether schema updates are performed automatically.
# Updates must be enabled during upgrades as, apart from the static upgrade scripts,
# there are also auto-generated update scripts that will need to be executed. After
# upgrading to a new version, this can be disabled.
#
#db.schema.update=true
#
#
# MySQL connection (This is default and requires mysql-connector-java-5.0.3-bin.jar, which ships with the Alfresco server)
#
db.driver=org.gjt.mm.mysql.Driver
db.url=jdbc:mysql://localhost:3306/alfresco

To test tomcat, I created a folder /opt/Alfrescotomcat/webapps/test and then created a simple index.html file.

I then ran sh /opt/Alfresco/alf_start and got the following display

sh /opt/Alfresco/alf_start.sh
Using CATALINA_BASE: /opt/Alfresco/tomcat
Using CATALINA_HOME: /opt/Alfresco/tomcat
Using CATALINA_TMPDIR: /opt/Alfresco/tomcat/temp
Using JRE_HOME: /usr/lib/jvm/java-6-sun

I then opened my browser and opened http://localhost:8080 and saw the contents of my index file which shows the tomcat server is working.

Heres the crunch. When I open http://localhost:8080/alfresco, it takes a few minutes of load time and then returns a 404 page error.

the resulting log files in tomcat/logs are as follows:


Catalina.out

CompilerOracle: exclude org/apache/lucene/index/IndexReader$1.doBody
CompilerOracle: exclude org/alfresco/repo/search/impl/lucene/index/IndexInfo$Merger.mergeIndexes
CompilerOracle: exclude org/alfresco/repo/search/impl/lucene/index/IndexInfo$Merger.mergeDeletions
Apr 7, 2009 9:38:08 AM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Apr 7, 2009 9:38:08 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1349 ms
Apr 7, 2009 9:38:08 AM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Apr 7, 2009 9:38:08 AM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.18
Apr 7, 2009 9:38:08 AM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive alfresco.war
Apr 7, 2009 9:38:13 AM org.apache.catalina.core.StandardContext addApplicationListener
INFO: The listener "org.apache.myfaces.webapp.StartupServletContextListener" is already configured for this context. The duplicate definition has been ignored.
09:38:46,127 ERROR [web.context.ContextLoader] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'luceneFullTextSearchIndexer' defined in class path resource [alfresco/core-services-context.xml]: Cannot resolve reference to bean 'indexerAndSearcherFactory' while setting bean property 'indexerAndSearcherFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'indexerAndSearcherFactory' defined in class path resource [alfresco/core-services-context.xml]: Cannot resolve reference to bean 'admLuceneIndexerAndSearcherFactory' while setting bean property 'defaultBinding'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'admLuceneIndexerAndSearcherFactory' defined in class path resource [alfresco/core-services-context.xml]: Cannot resolve reference to bean 'mlAwareNodeService' while setting bean property 'nodeService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'mlAwareNodeService' defined in class path resource [alfresco/node-services-context.xml]: Cannot resolve reference to bean 'mtAwareNodeService' while setting bean property 'defaultBinding'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'mtAwareNodeService': FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dbNodeService' defined in class path resource [alfresco/node-services-context.xml]: Cannot resolve reference to bean 'dbNodeServiceImpl' while setting bean property 'target'; nested exception is org.springframework.beans.factory.BeanCreationException: Error c

Catalina.log

Apr 7, 2009 9:38:08 AM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Apr 7, 2009 9:38:08 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1349 ms
Apr 7, 2009 9:38:08 AM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Apr 7, 2009 9:38:08 AM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.18
Apr 7, 2009 9:38:08 AM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive alfresco.war
Apr 7, 2009 9:38:13 AM org.apache.catalina.core.StandardContext addApplicationListener
INFO: The listener "org.apache.myfaces.webapp.StartupServletContextListener" is already configured for this context. The duplicate definition has been ignored.
Apr 7, 2009 9:38:46 AM org.apache.catalina.core.StandardContext start
SEVERE: Error listenerStart
Apr 7, 2009 9:38:46 AM org.apache.catalina.core.StandardContext start
SEVERE: Context [/alfresco] startup failed due to previous errors
Apr 7, 2009 9:38:49 AM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive share.war
Apr 7, 2009 9:38:57 AM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive studio.war
Apr 7, 2009 9:40:07 AM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
Apr 7, 2009 9:40:07 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 118645 ms

Localhost.log

Apr 7, 2009 9:38:16 AM org.apache.catalina.core.ApplicationContext log
INFO: Set web app root system property: 'webapp.root' = [/opt/Alfresco/tomcat/webapps/alfresco/]
Apr 7, 2009 9:38:16 AM org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring root WebApplicationContext
Apr 7, 2009 9:38:46 AM org.apache.catalina.core.StandardContext listenerStart
SEVERE: Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'luceneFullTextSearchIndexer' defined in class path resource [alfresco/core-services-context.xml]: Cannot resolve reference to bean 'indexerAndSearcherFactory' while setting bean property 'indexerAndSearcherFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'indexerAndSearcherFactory' defined in class path resource [alfresco/core-services-context.xml]: Cannot resolve reference to bean 'admLuceneIndexerAndSearcherFactory' while setting bean property 'defaultBinding'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'admLuceneIndexerAndSearcherFactory' defined in class path resource [alfresco/core-services-context.xml]: Cannot resolve reference to bean 'mlAwareNodeService' while setting bean property 'nodeService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'mlAwareNodeService' defined in class path resource [alfresco/node-services-context.xml]: Cannot resolve reference to bean 'mtAwareNodeService' while setting bean property 'defaultBinding'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'mtAwareNodeService': FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dbNodeService' defined in class path resource [alfresco/node-services-context.xml]: Cannot resolve reference to bean 'dbNodeServiceImpl' while setting bean property 'target'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dbNodeServiceImpl' defined in class path resource [alfresco/node-services-context.xml]: Cannot resolve reference to bean

Thanks

[ofrxnz]

This bit doesnt look right

dir.root=/usr/lib/mysql
dir.indexes=/opt/Alfresco/alf_data/lucene-indexes

i bet /usr/lib/mysql is read only to the alfresco user.  And that is where it trys to write all the repository data
i would expect it to be

dir.root=/opt/Alfresco/alf_data
dir.indexes=/opt/Alfresco/alf_data/lucene-indexes

[iomari]

This bit doesnt look right

dir.root=/usr/lib/mysql
dir.indexes=/opt/Alfresco/alf_data/lucene-indexes

i bet /usr/lib/mysql is read only to the alfresco user.  And that is where it trys to write all the repository data
i would expect it to be

dir.root=/opt/Alfresco/alf_data
dir.indexes=/opt/Alfresco/alf_data/lucene-indexes

I am having the exact same problem and my dir.root does equal /opt/alfresco/alf_data. [size=85](The lowercase "a" on the alfresco folder is not a mistake)[/size]


###############################                             
## Common Alfresco Properties #                             
###############################                             

#
# Sample custom content and index data location
#                                             
dir.root=/opt/alfresco/alf_data               

#
# Sample database connection properties
#                                     
db.name=alfresco                      
db.username=alfresco
db.password=alfresco
db.pool.initial=10
db.pool.max=100

#
# Sample external executable locations
#
#ooo.exe=/opt/openoffice/program/soffice
#ooo.user=${dir.root}/oouser
#img.root=/srv/alfresco/ImageMagick
#swf.exe=/srv/alfresco/bin/pdf2swf

#
# Sample index tracking frequency
#
#index.tracking.cronExpression=0/5 * * * * ?

#
# Property to control whether schema updates are performed automatically.
# Updates must be enabled during upgrades as, apart from the static upgrade scripts,
# there are also auto-generated update scripts that will need to be executed.  After
# upgrading to a new version, this can be disabled.
#
#db.schema.update=true

#
# Derby connection
#
#db.driver=org.apache.derby.jdbc.EmbeddedDriver
#db.url=jdbc:derby:alf_data/derby_data/alfresco;create=true

#
# HSQL connection
#
#db.driver=org.hsqldb.jdbcDriver
#db.url=jdbc:hsqldb:file:alf_data/hsql_data/alfresco;ifexists=true;shutdown=true;

#
# MySQL connection (This is default and requires mysql-connector-java-5.0.3-bin.jar, which ships with the Alfresco server)
#
db.driver=org.gjt.mm.mysql.Driver
db.url=jdbc:mysql://localhost/alfresco

#
# PostgreSQL connection (requires postgresql-8.2-504.jdbc3.jar or equivalent)
#
#db.driver=org.postgresql.Driver
#db.url=jdbcostgresql://localhost:5432/alfresco


However can you explain:  db.url=jdbc:mysql://localhost/alfresco  ?
where exactly is //localhost/alfresco ?

[ofrxnz]

However can you explain: db.url=jdbc:mysql://localhost/alfresco ?
where exactly is //localhost/alfresco ?

Its the location of your DB.  MySQL is a networkable DB so it is essentially db.url=<dbEngine><dbType>://<network location>[ort]/<dbName>

so, if you had a stand alone MySQL server at mysql.company.com or 10.0.1.247 , and you named the DB "AlfMain"

the path could be

//mysql.company.com/AlfMain

or

//10.0.1.247/AlfMain

I believe the default port is 3306

so with port notation it is

//10.0.1.247:3306/AlfMain

the use of "localhost" tells alfresco to reach mysql over the loopback.

Also, MySQL permissions are host spicific. 

so a statement such as "grant all on alfresco.* to 'alfuser'@'192.168.1.24' identified by 'passowrd' is only good for alfuser connecting from the 192.168.1.24 host.  some other options are 192.168.1.% for a wild card ( i think) which will allow the entire class C subnet and 'localhost' for the local host. 

iomari. 

you probably want this in your configuration as wel

dir.indexes=/opt/Alfresco/alf_data/lucene-indexes

Can you do an ls -l in your Alfresco directory and check the owner and permissions on the alf_data folder and then the lucine-indexes folder inside of it. 



here is what my files look like.  This is from my test instance on Windows, but the DB stuff should be the same all that should be needed is a path adjustment. 

custom-repository.properties

################################# Common Alfresco Properties ################################## Sample custom content and index data location#dir.root=C:/Alfresco/alf_datadir.indexes=C:/Alfresco/alf_data/lucene-indexesalfresco.cluster.name=ALFRESCO_TEST## Sample database connection properties#db.name=alfrescoDBdb.username=userdb.password=password#db.pool.initial=10#db.pool.max=100## External locations#ooo.exe=C:/Alfresco/OpenOffice.org/program/sofficeooo.user=${dir.root}/oouserimg.root=C:/Alfresco/ImageMagickswf.exe=C:/Alfresco/bin/pdf2swfindex.tracking.cronExpression=0/5 * * * * ?index.recovery.mode=AUTO## Property to control whether schema updates are performed automatically.# Updates must be enabled during upgrades as, apart from the static upgrade scripts,# there are also auto-generated update scripts that will need to be executed.  After# upgrading to a new version, this can be disabled.##db.schema.update=true## Derby connection##derby#db.driver=org.apache.derby.jdbc.EmbeddedDriver#derby#db.url=jdbc:derby:C:/Alfresco/alf_data/derby_data/alfresco;create=true## HSQL connection##hsql#db.driver=org.hsqldb.jdbcDriver#hsql#db.url=jdbc:hsqldb:file:C:/Alfresco/alf_data/hsql_data/alfresco;ifexists=true;shutdown=true;## MySQL connection (This is default and requires mysql-connector-java-5.0.3-bin.jar, which ships with the Alfresco server)#db.driver=org.gjt.mm.mysql.Driverdb.url=jdbc:mysql://10.0.2.67:3306/alfrescoDB## PostgreSQL connection (requires postgresql-8.2-504.jdbc3.jar or equivalent)##postgresql#db.driver=org.postgresql.Driver#postgresql#db.url=jdbc:postgresql://localhost:3306/alfrescomail.host=server.company.commail.port=25mail.username=usermail.password=password‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

and

custom-hibernate-dialect.properties

## Sample Hibernate configuration for changing Database dialect# For a full list: http://www.hibernate.org/hib_docs/v3/reference/en/html_single/#configuration-optional-dialects### Derby dialect##derby#hibernate.dialect=org.hibernate.dialect.DerbyDialect## HSQL dialect##hsql#hibernate.dialect=org.hibernate.dialect.HSQLDialect## MySQL dialect (default)#hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect## PostgreSQL dialect##postgresql#hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect#postgresql#hibernate.query.substitutions=true TRUE, false FALSE‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

[iomari]

Thanks for your reply. I added the index line and I still get a 404 page. My database is still empty with no tables generated. I create the database with the db_setup.sql script: mysql -u root -p < ./db_setup.sql from the folder where the script is. It was successfully created with no tables of course. But starting the service did not create anything. I also removed the alf_data folder before I started
Below are my main config files and a clean catalina.out file showing the errors:

catalina.out:
CompilerOracle: exclude org/apache/lucene/index/IndexReader$1.doBody
CompilerOracle: exclude org/alfresco/repo/search/impl/lucene/index/IndexInfo$Merger.mergeIndexes
CompilerOracle: exclude org/alfresco/repo/search/impl/lucene/index/IndexInfo$Merger.mergeDeletions
Apr 14, 2009 7:22:43 AM org.apache.coyote.http11.Http11Protocol init                             
INFO: Initializing Coyote HTTP/1.1 on http-8081                                                  
Apr 14, 2009 7:22:43 AM org.apache.catalina.startup.Catalina load                                
INFO: Initialization processed in 929 ms                                                         
Apr 14, 2009 7:22:43 AM org.apache.catalina.core.StandardService start                           
INFO: Starting service Catalina                                                                  
Apr 14, 2009 7:22:43 AM org.apache.catalina.core.StandardEngine start                            
INFO: Starting Servlet Engine: Apache Tomcat/6.0.18                                              
Apr 14, 2009 7:22:43 AM org.apache.catalina.startup.HostConfig deployWAR                         
INFO: Deploying web application archive alfresco.war                                             
Apr 14, 2009 7:22:47 AM org.apache.catalina.core.StandardContext addApplicationListener          
INFO: The listener "org.apache.myfaces.webapp.StartupServletContextListener" is already configured for this context. The duplicate definition has been ignored.
07:22:52,176  ERROR [web.context.ContextLoader] Context initialization failed                                                                                 
org.springframework.beans.factory.parsing.BeanDefinitionParsingException: Configuration problem: Failed to import bean definitions from URL location [classpath*:alfresco/extension/*-context.xml]
Offending resource: class path resource [alfresco/application-context.xml]; nested exception is org.springframework.beans.factory.xml.XmlBeanDefinitionStoreException: Line -1 in XML document from file [/mnt/installs/opt/alfresco/tomcat/shared/classes/alfresco/extension/custom-authority-services-context.xml] is invalid; nested exception is org.xml.sax.SAXParseException: Premature end of file.                         
Caused by: org.springframework.beans.factory.xml.XmlBeanDefinitionStoreException: Line -1 in XML document from file [/mnt/installs/opt/alfresco/tomcat/shared/classes/alfresco/extension/custom-authority-services-context.xml] is invalid; nested exception is org.xml.sax.SAXParseException: Premature end of file.                                                                                                              
Caused by: org.xml.sax.SAXParseException: Premature end of file.                                                                                                                                                 
        at org.apache.xerces.util.ErrorHandlerWrapper.createSAXParseException(Unknown Source)                                                                                                                    
        at org.apache.xerces.util.ErrorHandlerWrapper.fatalError(Unknown Source)                                                                                                                                 
        at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source)                                                                                                                                   
        at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source)                                                                                                                                   
        at org.apache.xerces.impl.XMLVersionDetector.determineDocVersion(Unknown Source)                                                                                                                         
        at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)                                                                                                                                    
        at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)                                                                                                                                    
        at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)                                                                                                                                             
        at org.apache.xerces.parsers.DOMParser.parse(Unknown Source)                                                                                                                                             
        at org.apache.xerces.jaxp.DocumentBuilderImpl.parse(Unknown Source)                                                                                                                                      
        at org.springframework.beans.factory.xml.DefaultDocumentLoader.loadDocument(DefaultDocumentLoader.java:76)                                                                                               
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:351)                                                                                 
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:303)                                                                                   
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:280)                                                                                   
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:131)                                                                     
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:147)                                                                     
        at org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.importBeanDefinitionResource(DefaultBeanDefinitionDocumentReader.java:171)                                                  
        at org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.parseDefaultElement(DefaultBeanDefinitionDocumentReader.java:145)                                                           
        at org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.parseBeanDefinitions(DefaultBeanDefinitionDocumentReader.java:130)                                                          
        at org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.registerBeanDefinitions(DefaultBeanDefinitionDocumentReader.java:90)                                                        
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.registerBeanDefinitions(XmlBeanDefinitionReader.java:458)                                                                               
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:353)                                                                                 
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:303)                                                                                   
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:280)                                                                                   
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:131)                                                                     
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:147)                                                                     
        at org.springframework.web.context.support.XmlWebApplicationContext.loadBeanDefinitions(XmlWebApplicationContext.java:124)
        at org.springframework.web.context.support.XmlWebApplicationContext.loadBeanDefinitions(XmlWebApplicationContext.java:92)
        at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:101)
        at org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory(AbstractApplicationContext.java:389)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:324)
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:830)
        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:719)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
        at org.apache.catalina.core.StandardService.start(StandardService.java:516)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Apr 14, 2009 7:22:52 AM org.apache.catalina.core.StandardContext start
SEVERE: Error listenerStart
Apr 14, 2009 7:22:52 AM org.apache.catalina.core.StandardContext start
SEVERE: Context [/alfresco] startup failed due to previous errors
Apr 14, 2009 7:22:52 AM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive share.war
07:22:56,136  INFO  [web.site.FrameworkHelper] Successfully Initialized Web Framework
Apr 14, 2009 7:22:56 AM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive studio.war
07:22:59,018  INFO  [web.scripts.DeclarativeRegistry] Registered 67 Web Scripts (+0 failed), 71 URLs
07:22:59,020  INFO  [web.scripts.AbstractRuntimeContainer] Initialised Presentation Web Script Container (in 322.564ms)
07:22:59,669  INFO  [web.scripts.DeclarativeRegistry] Registered 101 Web Scripts (+0 failed), 105 URLs
07:22:59,669  INFO  [web.scripts.AbstractRuntimeContainer] Initialised WebFramework Web Script Container (in 633.729ms)
07:22:59,739  INFO  [web.site.FrameworkHelper] Successfully Initialized Web Framework
Apr 14, 2009 7:23:00 AM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8081
Apr 14, 2009 7:23:00 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 16683 ms

here is my custom-hibernate-dialect.properties:
#
# Sample Hibernate configuration for changing Database dialect
# For a full list: http://www.hibernate.org/hib_docs/v3/reference/en/html_single/#configuration-optional-dialects
#

#
# Derby dialect
#
#hibernate.dialect=org.hibernate.dialect.DerbyDialect

#
# HSQL dialect
#
#hibernate.dialect=org.hibernate.dialect.HSQLDialect

#
# MySQL dialect (default)
#
hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect

#
# PostgreSQL dialect
#
#hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
#hibernate.query.substitutions=true TRUE, false FALSE

here is  my custom-repository.properties
###############################                                               
## Common Alfresco Properties #                                               
###############################                                               

#
# Sample custom content and index data location
#                                             
dir.root=/opt/alfresco/alf_data                           
dir.indexes=/opt/alfresco/alf_data/lucene-indexes

#
# Sample database connection properties
#
db.username=alfresco
db.password=alfresco
#db.pool.initial=10
#db.pool.max=100

#
# Sample external executable locations
#
#ooo.exe=/opt/openoffice/program/soffice
#ooo.user=${dir.root}/oouser
#img.root=/srv/alfresco/ImageMagick
#swf.exe=/srv/alfresco/bin/pdf2swf

#
# Sample index tracking frequency
#
#index.tracking.cronExpression=0/5 * * * * ?

#
# Property to control whether schema updates are performed automatically.
# Updates must be enabled during upgrades as, apart from the static upgrade scripts,
# there are also auto-generated update scripts that will need to be executed.  After
# upgrading to a new version, this can be disabled.
#
#db.schema.update=true

#
# Derby connection
#
#db.driver=org.apache.derby.jdbc.EmbeddedDriver
#db.url=jdbc:derby:alf_data/derby_data/alfresco;create=true

#
# HSQL connection
#
#db.driver=org.hsqldb.jdbcDriver
#db.url=jdbc:hsqldb:file:alf_data/hsql_data/alfresco;ifexists=true;shutdown=true;

#
# MySQL connection (This is default and requires mysql-connector-java-5.0.3-bin.jar, which ships with the Alfresco server)
#
db.driver=org.gjt.mm.mysql.Driver
db.url=jdbc:mysql://localhost:3306/alfresco

#
# PostgreSQL connection (requires postgresql-8.2-504.jdbc3.jar or equivalent)
#
#db.driver=org.postgresql.Driver
#db.url=jdbcostgresql://localhost:5432/alfresco

I would appreciate any help.

Thanks

[iomari]

anyone.
please 

[mrogers]

Your database configuration looks O.K.

The error is related to reading
/mnt/installs/opt/alfresco/tomcat/shared/classes/alfresco/extension/custom-authority-services-context.xml

Could you open this file in a text editor and check that it looks O.K.  and contains well formed XML.  
The error reported is that its truncated but it could be something like a garbled character set or line endings.

[iomari]

Your database configuration looks O.K.

The error is related to reading
/mnt/installs/opt/alfresco/tomcat/shared/classes/alfresco/extension/custom-authority-services-context.xml

Could you open this file in a text editor and check that it looks O.K.  and contains well formed XML.  
The error reported is that its truncated but it could be something like a garbled character set or line endings.

Thanks for your reply. That file does not exist anywhere in  my  alfresco directory.

This is my current catalina.out log:

CompilerOracle: exclude org/apache/lucene/index/IndexReader$1.doBody
CompilerOracle: exclude org/alfresco/repo/search/impl/lucene/index/IndexInfo$Merger.mergeIndexes
CompilerOracle: exclude org/alfresco/repo/search/impl/lucene/index/IndexInfo$Merger.mergeDeletions
Apr 15, 2009 2:11:04 PM org.apache.coyote.http11.Http11Protocol init                             
INFO: Initializing Coyote HTTP/1.1 on http-8181                                                  
Apr 15, 2009 2:11:04 PM org.apache.catalina.startup.Catalina load                                
INFO: Initialization processed in 923 ms                                                         
Apr 15, 2009 2:11:04 PM org.apache.catalina.core.StandardService start                           
INFO: Starting service Catalina                                                                  
Apr 15, 2009 2:11:04 PM org.apache.catalina.core.StandardEngine start                            
INFO: Starting Servlet Engine: Apache Tomcat/6.0.18                                              
Apr 15, 2009 2:11:04 PM org.apache.catalina.startup.HostConfig deployWAR                         
INFO: Deploying web application archive alfresco.war                                             
Apr 15, 2009 2:11:06 PM org.apache.catalina.core.StandardContext addApplicationListener          
INFO: The listener "org.apache.myfaces.webapp.StartupServletContextListener" is already configured for this context. The duplicate definition has been ignored.
14:11:28,286  INFO  [config.xml.XMLConfigService$PropertyConfigurer] Loading properties file from class path resource [alfresco/file-servers.properties]      
14:11:31,594  ERROR [web.context.ContextLoader] Context initialization failed                                                                                 
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'activityService' defined in class path resource [alfresco/activities/activities-feed-context.xml]: Cannot resolve reference to bean 'postDaoService' while setting bean property 'postDaoService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'postDaoService' defined in class path resource [alfresco/activities/activities-feed-context.xml]: Cannot resolve reference to bean 'sqlMapClient' while setting bean property 'sqlMapClient'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlMapClient' defined in file [/mnt/installs/opt/alfresco-demo/tomcat/shared/classes/alfresco/extension/custom-activities-feed-context.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Error occurred.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml                                                                             
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'postDaoService' defined in class path resource [alfresco/activities/activities-feed-context.xml]: Cannot resolve reference to bean 'sqlMapClient' while setting bean property 'sqlMapClient'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlMapClient' defined in file [/mnt/installs/opt/alfresco-demo/tomcat/shared/classes/alfresco/extension/custom-activities-feed-context.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Error occurred.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml                                                                                                                                                               
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlMapClient' defined in file [/mnt/installs/opt/alfresco-demo/tomcat/shared/classes/alfresco/extension/custom-activities-feed-context.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Error occurred.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml                                     
Caused by: java.lang.RuntimeException: Error occurred.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml                                                                                                              
        at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse(SqlMapConfigParser.java:109)                                                                                                            
        at com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(SqlMapClientBuilder.java:90)                                                                                                           
        at org.springframework.orm.ibatis.SqlMapClientFactoryBean.buildSqlMapClient(SqlMapClientFactoryBean.java:326)                                                                                            
        at org.springframework.orm.ibatis.SqlMapClientFactoryBean.afterPropertiesSet(SqlMapClientFactoryBean.java:280)                                                                                           
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1201)                                                          
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1171)                                                             
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425)                                                                  
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)                                                                                               
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)                                                                            
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)                                                                                                   
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)                                                                                                   
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:261)                                                                          
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:109)                                                                   
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1099)                                                        
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:861)                                                                
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:421)                                                                  
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)                                                                                               
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)                                                                            
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)                                                                                                   
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)                                                                                                   
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:261)                                                                          
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:109)                                                                   
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1099)                                                        
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:861)                                                                
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:421)                                                                  
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)                                                                                               
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)                                                                            
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)                                                                                                   
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)                                                                                                   
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:287)                                                                    
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:352)                                                                                           
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)                                                                                                     
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)                                                                                                       
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)                                                                                               
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)                                                                                                                     
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)                                                                                                                             
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)                                                                                                                       
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)                                                                                                                               
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)                                                                                                                                 
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:830)                                                                                                                                 
        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:719)                                                                                                                                
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)                                                                                                                                
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)                                                                                                                                    
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)                                                                                                                            
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)                                                                                                               
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
        at org.apache.catalina.core.StandardService.start(StandardService.java:516)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml
        at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:62)
        at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse(SqlMapConfigParser.java:106)
        … 57 more
Caused by: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml
        at com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java:123)
        at com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:84)
        at com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:102)
        at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:72)
        at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:60)
        … 58 more
Caused by: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml
        at com.ibatis.common.resources.Resources.getResourceAsStream(Resources.java:108)
        at com.ibatis.common.resources.Resources.getResourceAsStream(Resources.java:93)
        at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser$11.process(SqlMapConfigParser.java:383)
        at com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java:121)
        … 62 more
Apr 15, 2009 2:11:31 PM org.apache.catalina.core.StandardContext start
SEVERE: Error listenerStart
Apr 15, 2009 2:11:31 PM org.apache.catalina.core.StandardContext start
SEVERE: Context [/alfresco] startup failed due to previous errors
log4j:ERROR LogMananger.repositorySelector was null likely due to error in class reloading, using NOPLoggerRepository.
Apr 15, 2009 2:11:33 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive share.war
14:11:36,794  INFO  [web.site.FrameworkHelper] Successfully Initialized Web Framework
Apr 15, 2009 2:11:36 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive studio.war
14:11:39,748  INFO  [web.scripts.DeclarativeRegistry] Registered 67 Web Scripts (+0 failed), 71 URLs
14:11:39,750  INFO  [web.scripts.AbstractRuntimeContainer] Initialised Presentation Web Script Container (in 476.848ms)
14:11:40,416  INFO  [web.scripts.DeclarativeRegistry] Registered 101 Web Scripts (+0 failed), 105 URLs
14:11:40,416  INFO  [web.scripts.AbstractRuntimeContainer] Initialised WebFramework Web Script Container (in 648.52997ms)
14:11:40,560  INFO  [web.site.FrameworkHelper] Successfully Initialized Web Framework
Apr 15, 2009 2:11:40 PM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8181
Apr 15, 2009 2:11:40 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 36489 ms

Thanks