Error While configuring confluence with Mysql

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

3 answers

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';

you must issue the command:

flush privileges;

in mysql after granting the user....

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,

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Oct 24, 2018 in Confluence

Atlassian Research opportunity with Confluence templates

Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time!   We're looking for people to participate in a   remote 1-hr workshop...

1,147 views 20 14
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you