Error While configuring confluence with Mysql

[Joy Debnath]

Hi All,

I am trying to implement confluence on our VM. I have installed confluecne on one server and mysql on remote server. I am facing issue, it would be great if you can provide any solution. Any help would be greatly acknowledged.

I have followed below path to configure confluence with mysql

1) I have installed and configure confluence on the server 172.17.42.107

2) I have installed mysql on the server 172.17.42.107

create database confluence ;

GRANT ALL PRIVILEGES ON confluence.* TO 'confluenceuser'@'172.17.42.107' IDENTIFIED BY 'confluencepass';

3) I am using Direct JDBC Connection

The url is

jdbc:mysql://172.17.42.108:3306/confluence?useUnicode=true&characterEncoding=utf8

username confluenceuser

password confluencepass
The following error(s) occurred:

* Configuring the database failed. Couldn't create the database schema.
* Error creating bean with name 'pluginManager' defined in class path resource [services/pluginServiceContext.xml]: Cannot resolve reference to bean 'pluginStateStore' while setting constructor argument with index 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'pluginStateStore' defined in class path resource [services/pluginServiceContext.xml]: Cannot resolve reference to bean 'bandanaManager' while setting bean property 'bandanaManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'bandanaManager' defined in class path resource [services/bandanaServiceContext.xml]: Cannot resolve reference to bean 'bandanaPersister' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'bandanaPersister' defined in class path resource [services/bandanaServiceContext.xml]: Cannot resolve reference to bean 'dbBandanaPersister' while setting bean property 'persister'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dbBandanaPersister' defined in class path resource [services/bandanaServiceContext.xml]: Cannot resolve reference to bean 'transactionManager' while setting bean property 'transactionManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager' defined in class path resource [databaseSubsystemContext.xml]: Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [productionDatabaseContext.xml]: Invocation of init method failed; nested exception is net.sf.hibernate.MappingException: org.dom4j.DocumentException: svn.atlassian.com Nested exception: svn.atlassian.com

[Azwandi Mohd Aris]

You might be able to see more information about the error message inside the Confluence logs [1], which usually tells you the underlying cause such as insufficient privilege or error in connecting to the database

[1] http://confluence.atlassian.com/display/DOC/Working+with+Confluence+Logs