topic Re: RHEL5/Alfresco 2.2.0 Install... A little help? in Alfresco Archive

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

meansartin14 — Tue, 07 Oct 2008 14:31:32 GMT

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 th

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

mikeh — Tue, 07 Oct 2008 14:58:32 GMT

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

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

samuel_penn — Tue, 07 Oct 2008 15:20:28 GMT

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.

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

meansartin14 — Tue, 07 Oct 2008 17:59:47 GMT

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!

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

meansartin14 — Wed, 08 Oct 2008 12:59:42 GMT

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?

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

xfa18 — Wed, 08 Oct 2008 14:11:24 GMT

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.

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

meansartin14 — Wed, 08 Oct 2008 15:27:13 GMT

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
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

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

mikeh — Wed, 08 Oct 2008 20:03:38 GMT

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

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

meansartin14 — Wed, 08 Oct 2008 20:26:27 GMT

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!!