[SOLVED] Failed deploying alfresco from war

[bluearth]

Hi,

Since alfresco installation package for linux requires GUI which not suitable for my current situation, I decided to try and deploy alf from the war package (alfresco-community-war-3.2r.zip). My web container is tomcat 6. So I followed the instruction at "Installing and Configuring Alfresco ECM Community Edition 3.2r.pdf".

- I have created the required directory that are missing in tomcat 6.
- Move the extension dir from the zip file to shared/classes/alfresco/
- That gives me the main alf configuration under shared/classes/alfresco/ at alfresco-global.propertoes
- Edited that file to match my environtment.
- Dropped JDBC driver under lib (mine uses MSSQL Server jTDS driver)
- Drop the alfresco.war under tomcat's webapp dir
- Bootstrap tomcat

The server started, but server output indicates that alfresco.war failed to load. Here's the server output highlighting the place where tomcat fails:

…
INFO: Starting Servlet Engine: Apache Tomcat/6.0.20
Nov 9, 2009 1:42:59 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 ignore
d.
13:43:06,844  INFO  [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/repository.properties]
13:43:06,846  INFO  [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/domain/transaction.properties]
13:43:06,979  INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties
]
13:43:11,075  WARN  [hibernate.cfg.SettingsFactory] Could not obtain connection metadata
org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'org.gjt.mm.mysql.Driver'
        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1136)
        at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
       …further stacktrace goes here…
…
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

As shown, alf still look for default MySQL driver and seemed ignoring my global property setting.
Is there anything missing from my installation steps?

Cheers…

[mrogers]

Yes you have missed setting the class loader for tomcat 6.

http://wiki.alfresco.com/wiki/Install_Tomcat6

[bluearth]

Yes you have missed setting the class loader for tomcat 6.

http://wiki.alfresco.com/wiki/Install_Tomcat6

Thanks for the reply. I dId that but simply forgot to mention it in my original post.

[mrogers]

alfresco-global.properties goes in shared/classes rather than shared/classes/alfresco.

[bluearth]

alfresco-global.properties goes in shared/classes rather than shared/classes/alfresco.

Okay I moved alfresco-global.properties to that location, something seems to happen. The bootstrap process did find my alfresco-global.properties (as shown in the server output), but then it throws a bunch of spring exceptions.

…
INFO: Starting Servlet Engine: Apache Tomcat/6.0.20
Nov 10, 2009 2:36:11 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.
02:36:18,718  INFO  [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/repository.properties]
02:36:18,719  INFO  [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/domain/transaction.properties]
02:36:18,720  INFO  [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from URL [file:/home/barkah.yusuf/apache-tomcat-6.0.20/shared/classes/alfresco-global.properties]
02:36:18,882  INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
02:36:27,535  ERROR [web.context.ContextLoader] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'indexerComponent' defined in class path resource [alfresco/core-services-context.xml]: Cannot resolve reference to bean '&indexerAndSearcherFactory' while setting bean property 'storeRedirectorProxyFactory'; nested exception is  […the nested exceptions is quite long, but the line ends with…] Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: com.ibatis.sqlmap.client.SqlMapException: The <sqlMap> resource is missing: alfresco/ibatis/#resource.dialect#/locks-insert-SqlMap.xml
…
‍‍‍‍‍‍‍‍‍‍‍‍

I reckon that I'm missing ibatis dialect definition for MSSQL server.
Any other idea?

Thanks

[dward]

Did you say you were using SQL Server? SQL server (and other enterprise databases) are only supported in the enterprise edition. Try an enterprise trial.

[bluearth]

Did you say you were using SQL Server? SQL server (and other enterprise databases) are only supported in the enterprise edition. Try an enterprise trial.

Yes I did.
And after two days straight strugling to figure out what went wrong I can finally rest easy now

Thanks for the clarification.

EDIT: Could you point me to official page/document that saying which RDBMSs Alfresco Community supports?