cancel
Showing results for 
Search instead for 
Did you mean: 

alfresco some problem

hoffmannlin
Champ in-the-making
Champ in-the-making
i use centos4.4 server to install(mimi installment)

and use yum to install gnome* and mysql 4.1

download alfresco ver2.1  and install

when i start alfresco …

i will see

HTTP Status 404 - /alfresco/

type Status report

message /alfresco/

description The requested resource (/alfresco/) is not available.
Apache Tomcat/5.5.23


what matter?

Asked which information each also does need only then to know wrongly
in where? How perhaps should solve?
6 REPLIES 6

sdavis
Champ in-the-making
Champ in-the-making
What's in your catalina.out file for Tomcat?

hoffmannlin
Champ in-the-making
Champ in-the-making
This my tomcat.out think


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
Jul 1, 2007 11:39:33 PM org.apache.coyote.http11.Http11BaseProtocol
init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Jul 1, 2007 11:39:34 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 3161 ms
Jul 1, 2007 11:39:34 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Jul 1, 2007 11:39:34 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.23
Jul 1, 2007 11:39:34 PM org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
Jul 1, 2007 11:39:38 PM org.apache.catalina.startup.HostConfig
deployWAR
INFO: Deploying web application archive alfresco.war
23:40:36,633 ERROR
[transform.magick.AbstractImageMagickContentTransformer] ImageMagickContentTransformer not available: Failed to perform
ImageMagick transformation:
Execution result:
   os:         Linux
   command:    convert
/opt/Alfresco/tomcat/temp/Alfresco/ImageMagickContentTransformer_init_source_893.gif
  /opt/Alfresco/tomcat/temp/Alfresco/ImageMagickContentTransformer_init_target_894.png
   succeeded:  false
   exit code:  1
   out:       
   err:        java.io.IOException: convert: not found
23:40:47,084 WARN  [remoting.rmi.RmiRegistryFactoryBean] Could not
detect RMI registry - creating new one
23:40:47,866 ERROR [repo.transaction.TransactionUtil] Error rolling
back transaction
java.lang.IllegalStateException: No user transaction is active
   at
org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:479)
   at
org.alfresco.repo.transaction.TransactionUtil.executeInTransaction(TransactionUtil.java:214)
   at
org.alfresco.repo.transaction.TransactionUtil.executeInUserTransaction(TransactionUtil.java:89)
   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:585)
   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:585)
   at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
23:40:47,906 ERROR [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:369)
   at
org.alfresco.repo.transaction.TransactionUtil.executeInTransaction(TransactionUtil.java:188)
   at
org.alfresco.repo.transaction.TransactionUtil.executeInUserTransaction(TransactionUtil.java:89)
   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:585)
   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:585)
   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 create
PoolableConnectionFactory (Unknown initial character set index '192'
received from server. Initial client character set can be forced via the
'characterEncoding' property.)
   at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)
   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.sql.SQLException: Unknown initial character set index
'192' received from server. Initial client character set can be forced
via the 'characterEncoding' property.
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
   at
com.mysql.jdbc.Connection.configureClientCharacterSet(Connection.java:2342)
   at
com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java:3861)
   at com.mysql.jdbc.Connection.createNewIO(Connection.java:2657)
   at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
   at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
   at
org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
   at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
   at
org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877)
   at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)
   … 57 more
23:40:48,132 ERROR [[Catalina].[localhost].[/alfresco]] 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 '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:369)
   at
org.alfresco.repo.transaction.TransactionUtil.executeInTransaction(TransactionUtil.java:188)
   at
org.alfresco.repo.transaction.TransactionUtil.executeInUserTransaction(TransactionUtil.java:89)
   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:585)
   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:585)
   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 create
PoolableConnectionFactory (Unknown initial character set index '192'
received from server. Initial client character set can be forced via the
'characterEncoding' property.)
   at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)
   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.sql.SQLException: Unknown initial character set index
'192' received from server. Initial client character set can be forced
via the 'characterEncoding' property.
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
   at
com.mysql.jdbc.Connection.configureClientCharacterSet(Connection.java:2342)
   at
com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java:3861)
   at com.mysql.jdbc.Connection.createNewIO(Connection.java:2657)
   at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
   at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
   at
org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
   at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
   at
org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877)
   at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)
   … 57 more
23:40:48,138 ERROR [[Catalina].[localhost].[/alfresco]] Exception
sending context initialized event to listener instance of class
org.alfresco.web.app.ContextListener
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:369)
   at
org.alfresco.repo.transaction.TransactionUtil.executeInTransaction(TransactionUtil.java:188)
   at
org.alfresco.repo.transaction.TransactionUtil.executeInUserTransaction(TransactionUtil.java:89)
   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:585)
   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:585)
   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 create
PoolableConnectionFactory (Unknown initial character set index '192'
received from server. Initial client character set can be forced via the
'characterEncoding' property.)
   at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)
   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.sql.SQLException: Unknown initial character set index
'192' received from server. Initial client character set can be forced
via the 'characterEncoding' property.
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
   at
com.mysql.jdbc.Connection.configureClientCharacterSet(Connection.java:2342)
   at
com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java:3861)
   at com.mysql.jdbc.Connection.createNewIO(Connection.java:2657)
   at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
   at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
   at
org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
   at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
   at
org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877)
   at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)
   … 57 more
Jul 1, 2007 11:40:48 PM org.apache.catalina.core.StandardContext start
SEVERE: Error listenerStart
Jul 1, 2007 11:40:48 PM org.apache.catalina.core.StandardContext start
SEVERE: Context [/alfresco] startup failed due to previous errors
Jul 1, 2007 11:40:51 PM org.apache.coyote.http11.Http11BaseProtocol
start
INFO: Starting Coyote HTTP/1.1 on http-8080
Jul 1, 2007 11:40:51 PM org.apache.catalina.storeconfig.StoreLoader
load
INFO: Find registry server-registry.xml at classpath resource
Jul 1, 2007 11:40:52 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 78014 ms

steve
Champ in-the-making
Champ in-the-making
Hi,

It's not an error I have seen before…
Could you try with MySQL version 5.x rather that 4.x?

Thanks,

Steve

sdavis
Champ in-the-making
Champ in-the-making
I'd also check your DB connection settings (e.g. in custom-db-connection.properties).  Seems odd that the lower-level error centers on

Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (Unknown initial character set index '192'
received from server.

192 is likely more about an IP address than anything else…

mikeh
Star Contributor
Star Contributor
This looks similar to this bug report on the MySQL site:
    http://bugs.mysql.com/bug.php?id=26178

The solution recommended was to upgrade to the latest MySQL, to try and fix an unknown "UTF-8 not supported" problem. I suggest you follow Steve's advice and try with a new MySQL server.

> 192 is likely more about an IP address than anything else…
Coincidence only I'm afraid! Smiley Happy


Mike

chiazhi_tan
Champ in-the-making
Champ in-the-making
I was searching high and low all over when i got a very similiar "server won't start" problem. Have doubled checked the database has been created, necc. access granted etc. but still it would not work.

(btw, I'm running Alfresco a windows 2003 server)

Finally, I took Steve's advise - uninstall mySQL 4 and update to a mySQL-5.0.41win32.zip.. and finally, myAlfresco page loads in the browser. (btw, I've use utf-8 as the charset as well in mySQL)

Think we'll need to update the wiki documentation on the installation procedures.

BTW, I'm using Alfresco Community-2.1R1-Setup.exe, on Windows 2003, mySQL-5.0.41win32.zip, with J2SE Runtime Environment 6 Update 1.

Hope this info is useful for other people who are equally stuck/clueless when we follow the wiki documentation

cheers