start alfresco server errors

cthomas — Sat, 14 Apr 2007 10:21:51 GMT

Hello, I have just followed the install procedure, choosing mySQL db (mySQL already installed and well working [root access protected]), no error at all at install.When running the "start Alfresco server" batch file, I have errors:————————————————————————————————————————————————————–12:13:56,484 WAR

Re: start alfresco server errors

kevinr — Mon, 16 Apr 2007 13:14:11 GMT

The important errors is this:

Access denied for user 'alfresco'@'localhost' (using password: YES)

You need to ensure the alfresco user has access to the 'alfresco' schema in MySQL, something like this:

grant all on alfresco.* to 'alfresco'@'localhost' identified by 'alfresco' with grant option;
grant all on alfresco.* to 'alfresco'@'localhost.localdomain' identified by 'alfresco' with grant option;

Thanks,

Kevin

Re: start alfresco server errors

cthomas — Mon, 16 Apr 2007 14:57:20 GMT

alfresco user well exists and is granted with ALL PRIVILEGES
nevertheless error still displayed is:
————————————————————————————————————–
16 avr. 2007 16:50:29 org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
16 avr. 2007 16:50:31 org.apache.catalina.startup.HostConfig deployWAR
INFO: DÃšploiement de l'archive alfresco.war de l'application web
16:51:07,417 WARN [remoting.rmi.RmiRegistryFactoryBean] Could not detect RMI registry - creating new one
16:51:08,370 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:461)
        at org.alfresco.repo.transaction.TransactionUtil.executeInTransaction(TransactionUtil.java:201)
        at org.alfresco.repo.transaction.TransactionUtil.executeInUserTransaction(TransactionUtil.java:82)
        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:1093)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1063)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:363)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:226)
————————————————————————————————————–
somewhere else we still find:
————————————————————————————————————–
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'alfresco'@'localhost' (using password: YES))
        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:80)
        at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:417)
        … 50 more
Caused by: java.sql.SQLException: Access denied for user 'alfresco'@'localhost' (using password: YES)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812)
        at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269)
        at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182)
        at com.mysql.jdbc.Connection.createNewIO(Connection.java:2644)
        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)
        … 53 more
16:51:08,401 ERROR [[Catalina].[localhost].[/alfresco]] Exception lors de l'envoi de l'ÃšvÃžnement contexte initialisÃš (context initialized) Ã“ l'instance de classe d'Ãšcoute (listener) org.springframewor
k.web.context.ContextLoaderListener
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dictionaryRepositoryBootstrap' defined in class path resource [alfresco/core-services-context.xml]: Initializati
on of bean failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.G
enericJDBCException: Cannot open connection
org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connec
tion
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)
————————————————————————————————————–
Thanks for your help.
Regards,
CTH

Re: start alfresco server errors

kevinr — Mon, 16 Apr 2007 16:07:06 GMT

The error:

Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'alfresco'@'localhost' (using password: YES))
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:80)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:417)
… 50 more
Caused by: java.sql.SQLException: Access denied for user 'alfresco'@'localhost' (using password: YES) 
‍‍‍‍‍‍‍‍

still suggests there is a connection problem from the machine you are running Alfresco on. Can you connect to the DB from that machine using a cmd line client?

Thanks,

Kevin

Re: start alfresco server errors

cthomas — Mon, 16 Apr 2007 19:51:05 GMT

Problem is solved with user, additional problem because of no creation of the DB Alfresco.
Some bugs during tests especially with the search engine (utf8_bin page code), loading hiver.jpg file with hiver description not found anymore

topic Re: start alfresco server errors in Alfresco Archive

start alfresco server errors

Re: start alfresco server errors

Re: start alfresco server errors

Re: start alfresco server errors

Re: start alfresco server errors