It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Setting up Confluence with mysql external database

Cliff Martin Oct 13, 2011

I am trying to setup new instances of Confluence 4.0 on a test server and a production server. Both are using mysql. I am encountering a problem when I hit the configure database step.

The following error(s) occured:

  • Configuring the database failed. Couldn't create the database schema.
  • Error creating bean with name 'macroIconManager' defined in class path resource [services/pluginServiceContext.xml]: cannot resolve reference to bean... (very long error message)

I have recreated the database from within mysql several times, the last time with the folowing:

CREATE DATABASE confluence CHARACTER SET utf8 COLLATE utf8_bin;

I have a user setup for confluence named 'conuser', and I have granted permission on the database thusly:

GRANT ALL ON confluence.* TO 'conuser'@'%';

I have reviewed the following pages, and still don't see anything:

http://confluence.atlassian.com/display/DOC/Database+Setup+For+MySQL

http://confluence.atlassian.com/display/CONFKB/Known+Issues+for+MySQL

3 answers

0 votes
Andrew Frayling Oct 15, 2011

Hi Cliff,

Not being able to create the DB schema is usually a permissions issue. In your SQL statement to create the user you don't give the user a password. Do you get any further with the DB setup if you create the user with:

GRANT ALL ON confluence.* TO 'conuser'@'%' IDENTIFIED BY '<yourpassword'>;

and using both the username and the password on the DB setup screens?

Also, check the JDBC URL on the setup screen to make sure it's using the correct hostname, port and DB name.

Hope that helps,

Andrew.

Cliff Martin Oct 16, 2011

I have tried both with and without the password, also specifing a specific host, localhost and the wild card. no luck. The error message does suggest a permissions issue, but I have tried everything I can think of to address it.

I have done similar things with the jdbc connection string.

0 votes

Cliff.

I've had these sorts of problems with setting up an MYSQL database with Confluence...
My solution was to install the Postgre SQL database... and my god was it easy!!!
Just my opinion... but, I'm just about a Postgre convert now!!!...

Regards,

Grunta

Cliff Martin Oct 16, 2011

I am lucky to have msql. I don't think I can get postgres approved.

0 votes
Colin Goudie Oct 16, 2011

Are your instances of Confluence on the same machine as MYSQL? If not, are you creating the database and user from your Confluence machine or on the DB server? If so, try use mysql console on the Confluence machine to verify you can get to the server.

At the end of the day if you have username, password, host, port, database name etc.. correct then if Confluence is throwing an error then you either have a network connectivity issue or you don't have one of the above correct. Confluence connects fine to MySQL.

Cliff Martin Oct 19, 2011

I tired setting up Confluence 4.0 using Postgre 8.3.3, following these instructions and it still didn't work:

http://confluence.atlassian.com/display/DOC/Database+Setup+for+PostgreSQL

So the setup is failing for both MySQL 5.1 and Postgres.

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Confluence

6 Awesome Ways to Apply Trello, JIRA and Confluence to your Project

I attended  Atlassian Summit 2019  and learned a lot from the presenters, attendees and knowledgeable Atlassian product managers. The presentations I attended focused on applying Agile, pla...

2,502 views 11 28
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you