New and Improved 3.13 Beta. Highlights: Shareable filters and dashboards and lots of other goodies. Any feedback can be raised as JIRA issues in the JIRA project.
Issue Details (XML | Word | Printable)

Key: CONF-7414
Type: New Feature New Feature
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Christopher Owen [Atlassian]
Reporter: David Soul [Atlassian]
Votes: 85
Watchers: 34
Operations

If you were logged in you would be able to see more operations.
Confluence

Officially support mySQL 5.0

Created: 04/Dec/06 02:21 PM   Updated: 27/Aug/07 07:45 PM
Component/s: Database / Hibernate
Affects Version/s: None
Fix Version/s: 2.5.6, 2.6.0

Time Tracking:
Issue & Sub-Tasks
Issue Only
Not Specified

Environment: MySQL 5.0 or later
Issue Links:
Blocker
 

Participants: Carol Jarosz, Charles Miller [old account, do not assign issues], Christopher Owen [Atlassian], David Soul [Atlassian], doug newton, Eagle Wang, Gary Weaver, Ing. Robert Erlinger, Jeff Heinen and Sherif Mansour
Since last comment: 1 year, 3 weeks, 2 days ago
Resolution Date: 06/Aug/07 12:15 AM
Labels:

Sub-Tasks  All   Open   

 Description  « Hide
MySQL is currently listed as unsupported on http://confluence.atlassian.com/display/DOC/Confluence+Installation+Guide

Please test this database.

If successful, update the MySQL install guide at http://confluence.atlassian.com/display/DOC/Database+Configuration with any workarounds or setup instructions and list as supported.
If unsuccessful, log the issue in jira.atlassian.com and list as unsupported.



 All   Comments   Work Log   Change History      Sort Order: Ascending order - Click to sort in descending order
David Soul [Atlassian] added a comment - 04/Dec/06 02:46 PM
Users who would like 5.0 to be officially supported may like to vote on this issue. It appears to be compatible but users currently wishing to install will not have technical support if they run into difficulties with setup until it is fully tested and the documentation updated.

Users wishing to install 5.0 on their own can attempt the instructions at http://confluence.atlassian.com/display/DOC/Database+Setup+For+mySQL


doug newton added a comment - 20/Mar/07 06:34 PM
MySQL 5.0 has been out for a while now, and our company has standardized on it as the version for our MySQL servers. I hope this platform is officially supported by Atlassian soon.

Ing. Robert Erlinger added a comment - 16/Apr/07 07:59 AM
I hope Mysql 5 will be supported as soon as possible!

Jeff Heinen added a comment - 18/Apr/07 02:17 PM
I've just been told that MySQL 5.0 and several other core applications are going to be replacing their aging counterparts on our production servers. There is a request that we keep our JIRA/Confluence server at the same revision as the rest of the systems. I'd like to be able to tell them to go ahead.

Is there an ETA, or a list of items that need to be addressed, and/or something we can do to assist in this process?


Carol Jarosz added a comment - 26/Apr/07 09:48 AM
We will be unable to upgrade our OS because MySQL 5.0 will be the only supported version. I hope that you will work on supporting MySQL 5.0 for Confluence soon!

Charles Miller [old account, do not assign issues] added a comment - 26/Apr/07 10:09 AM
This issue is currently scheduled to be addressed for Confluence 2.6 (mid-June), although we obviously can't make a firm commitment. We haven't yet done any testing against this configuration, and thus don't know what issues, if any, we will encounter.

That said, I believe a number of people are already using Confluence 2.4 successfully with MySQL 5, despite the lack of official support. So we're cautiously optimistic.


Eagle Wang added a comment - 29/Jun/07 03:34 AM
I hope that you will work on supporting MySQL 5.0 for Confluence soon!!!!!!

Gary Weaver added a comment - 05/Jul/07 08:05 AM
Just for the record, we had a local issue (more info in CSP-9986) with MySQL 5.0.5 and Confluence 2.5.4 (both running on OS X 10.4) where after creating a user with username "fightclub", you could not create a group with name "fightclub", however you could create a user with the same username as an existing group. Looking at the database, it appears that users and groups are stored in the "os_user" and "os_group" tables but there are no rows in either the "users" or "groups" tables. Also there were no rows in the "os_group" table containing "fightclub", so it would appear that the application is mistakenly reporting "A group with this name already exists" even though it doesn't. In addition, with default log4j.properties settings, there is no logging of this event when this issue occurs. Because of this, I'm switching to a different database that is supported for future confluence plugin development for Confluence 2.5.x (one that is listed here http://confluence.atlassian.com/display/DOC/Confluence+Installation+Guide ).

Gary Weaver added a comment - 05/Jul/07 09:35 AM
Nevermind... seems that both MySQL 5.0.5 and MySQL 4.1.22 have the aforementioned issue (CSP-9986).

Sherif Mansour added a comment - 09/Jul/07 08:22 PM
For those interested, I have been advised by support that this is due to be fixed in Confluence 2.6, which is due in roughly 6 weeks from today

Christopher Owen [Atlassian] added a comment - 06/Aug/07 12:15 AM
Hi everyone,

We now have established a regular build and test configuration using MySQL 5.0 and as such it is now a supported database when used with Confluence 2.5 and above.

Cheers,
Chris


Gary Weaver added a comment - 06/Aug/07 12:08 PM
That's great! Thanks!