RHEL5/Alfresco 2.2.0 Install... A little help?

[meansartin14]

I have no idea where I'm going wrong. I have a freshly-installed RHEL5 server with MySQL and JDK 1.6 installed.

I downloaded the AlfrescoEnterprise-2.2.0-Linux-x86-Install.bin from http://www.alfresco.com/products/ecm/enttrial/.
I ran through the installation wizard without any errors.
I ran through the 'Run configuration wizard' step after the installation, selecting MySQL as the database.
I then open up a browser with the address http://localhost:8080/alfresco to no avail.

I've read the "Installing and configuring Alfresco DM 2_2.pdf" from the community website and it has not helped me whatsoever.

I've got to believe it can't be this difficult to install Alfresco… I'm a bit frustrated.

Help?!

[mikeh]

You've come to the right place, but please locate and post your alfresco.log file so people know where to start looking for the problem.

Thanks,
Mike

[samuel_penn]

Having just done some RHEL 5 installs, I had lots of issues with the firewall, which was blocking various ports. I can't remember whether 8080 was blocked by default, but it might be worth looking at.

Also, the version of OpenOffice supplied with RHEL 5 doesn't work properly, so if you want to use OpenOffice integration, use a different version of OO (I used the RPMs from the openoffice website for OO 2.4).

Sam.

[meansartin14]

You've come to the right place, but please locate and post your alfresco.log file so people know where to start looking for the problem.

Hmm, there doesn't appear to be an alfresco.log. Even tried searching from the / directory as root. I assume this is a problem.

It doesn't appear to me that Alfresco was installed properly by the .bin file. Here's what I get if I run "alf_start.sh":

sh: @@ALFRESCO_DIR@@/alfresco.sh: No such file or directory‍

After a browse of the process table (ps -ef | grep alf | grep -v grep), I have no instances of alfresco running (also a problem, duh).

Having just done some RHEL 5 installs, I had lots of issues with the firewall, which was blocking various ports. I can't remember whether 8080 was blocked by default, but it might be worth looking at.

Also, the version of OpenOffice supplied with RHEL 5 doesn't work properly, so if you want to use OpenOffice integration, use a different version of OO (I used the RPMs from the openoffice website for OO 2.4).

Per your suggestion, I completely disabled the firewall. I have not touched OpenOffice, as I do not need it for my implementation.

However, I think my problem lies at a more basic level. See above.

Any ideas? Thanks for the help!

[meansartin14]

OK, after some custom configuration per a bug report (https://issues.alfresco.com/jira/browse/ALFCOM-1771), I now have an alfresco.log file.

Here are its contents, sorted because there's a ridiculous amount of text in it.

[root@localhost Alfresco]# cat alfresco.log | grep ERROR
08:48:09,673 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
08:48:09,682 ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/alfresco]] Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener
08:48:09,688 ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/alfresco]] Exception sending context initialized event to listener instance of class org.alfresco.web.app.ContextListener
08:50:22,568 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
08:50:22,577 ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/alfresco]] Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener
08:50:22,582 ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/alfresco]] Exception sending context initialized event to listener instance of class org.alfresco.web.app.ContextListener‍‍‍‍‍‍‍‍

Help?

[xfa18]

Hi,

Can you send the line below

ERROR [org.springframework.web.context.ContextLoader] Context initialization failed

Because it's very difficult to help you within the all error.
Another solution is to save the alfresco.log and you restart alfresco.

[meansartin14]

Can you send the line below

ERROR [org.springframework.web.context.ContextLoader] Context initialization failed

Sure can:

10:10:35,692 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dictionaryRepositoryBootstrap' defined in class path resource [alfresco/core-services-context.xml]: Invocation of init method failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection
Caused by:
org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection
Caused by:
org.hibernate.exception.GenericJDBCException: Cannot open connection
        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
        at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:420)
        at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
        at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)
        at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
        at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)
        at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:497)
        at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:349)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:255)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:214)
        at org.alfresco.util.transaction.SpringAwareUserTransaction.begin(SpringAwareUserTransaction.java:380)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:238)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:171)
        at org.alfresco.repo.dictionary.DictionaryRepositoryBootstrap.bootstrap(DictionaryRepositoryBootstrap.java:134)
        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.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1160)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1122)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1085)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:429)
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250)
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161)
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:273)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:346)
        at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156)
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:825)
        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
        at org.apache.catalina.core.StandardService.start(StandardService.java:448)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
        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:295)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'org.gjt.mm.mysql.Driver'
        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:766)
        at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
        at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
        at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:417)
        … 54 more
Caused by: java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
        at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1359)
        at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1205)
        at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:169)
        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:760)
        … 57 more
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

[mikeh]

This is a fairly common issue…

The last exception in the chain is usually the one to look at first, and sure enough it's telling us what's wrong:

java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver

This indicates that the MySQL JDBC driver hasn't been installed correctly - you'll need to download it from MySQL (http://dev.mysql.com/downloads/connector/j/5.0.html) and install the mysql-connector-java-5.0.X-bin.jar file into tomcat/common/lib.

Thanks,
Mike

[meansartin14]

This is a fairly common issue…

The last exception in the chain is usually the one to look at first, and sure enough it's telling us what's wrong:

java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver

This indicates that the MySQL JDBC driver hasn't been installed correctly - you'll need to download it from MySQL (http://dev.mysql.com/downloads/connector/j/5.0.html) and install the mysql-connector-java-5.0.X-bin.jar file into tomcat/common/lib.

Done. That fixed my problem and I am now using my Alfresco installation! Thank you all very much for the help!

For my purposes and for anyone who will have this problem in the future, I will list, step-by-step, the process I went through to configure Alfresco properly in a post sometime tomorrow.

Thanks again!!