AnsweredAssumed Answered

Screwed up my install.

Question asked by dc41 on Jun 26, 2009
Latest reply on Jun 26, 2009 by dc41
I had Alfresco Labs 3 running beautifully on an Ubuntu 9.04 install. Then I screwed it up.  Here's the problem…

15:14:46,945 INFO  [org.alfresco.config.xml.XMLConfigService$PropertyConfigurer] Loading properties file from class path resource [alfresco/file-servers.properties]
15:15:26,497 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'luceneIndexBackupComponent' 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)
ETC.

First thing I did was change the hostname for the server and changed from a DHCP assigned address to a static address.

Second thing is use these instructions for get Alfresco to start at system boot.
create a file

vi initialize.sh

Add these lines

#!/bin/sh
ALF_HOME=/opt/Alfresco
echo "Creating init.d links"
ln -s $ALF_HOME/alfresco.sh /etc/init.d/alfresco
ln -s $ALF_HOME/virtual_alf.sh /etc/init.d/virtual_alf
update-rc.d alfresco defaults
ln -s $ALF_HOME/alfresco.sh /etc/init.d/alfresco
ln -s $ALF_HOME/virtual_alf.sh /etc/init.d/virtual_alf
update-rc.d alfresco defaults
update-rc.d virtual_alf defaults

Lets make it executable

chmod 777 initialize.sh

Run it

./initialize.sh

Could either of these actions have affected the file-server.properties? I think that's where the problem lies.  Also, how do I reverse the actions done by the above script? I've already deleted /etc.init.d/alfresco and virtual_alf.

Thanks!

Outcomes