nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }
As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.
alfresco some problem

hoffmannlin
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?
Find more posts tagged with

Comments

sdavis
What's in your catalina.out file for Tomcat?
hoffmannlin
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
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
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
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!
Mike
chiazhi_tan
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