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

Confluecnce Version 3.5.4

Mysql version 5.0

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

[Sergey Markovich]

Just an idea. Not sure if it helps. Grant permissions for localhost user too.

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

[Harry Chan]

Hi, you said that you have configured MySQL on 172.17.42.107

But your JDBC url is: jdbc:mysql://172.17.42.108:3306/confluence?useUnicode=true&characterEncoding=utf8

Note that 1 is 107 and 1 is 108. Please ensure that the URLs are the same.

Cheers,

[Jose Montanez]

you must issue the command:

flush privileges;

in mysql after granting the user....