No database support

[chihoko]

Is there any reason why you have left out support for configuring Confluence to use a postgres/mysql database as you have done with your Jira module? (which works great btw).

[mkrakowitzer]

I am sure there was, just not sure exactly why. I will take a look and implement if possible. Atlassian is not really consistent with the configuration between there applications Give me a day or two and I should hopefully have it sorted it out.

[chihoko]

Hey, have you had a chance to take a look? Are you using this module in production?

[mkrakowitzer]

Yes we have a few thousand users in production. I will add this support
soon. Sorry for slow response, ill get on it as soon as i can.
On Nov 1, 2014 3:13 PM, "chihoko" [email protected] wrote:

Hey, have you had a chance to take a look? Are you using this module in
production?

—
Reply to this email directly or view it on GitHub
#3 (comment)
.

[mkrakowitzer]

Hi Chihoko

I have looked at this in some detail, this is not something easy to implement. The database information is stored in this file (/home/confluence/confluence.cfg.xml ), unfortunatly its not as simple as just putting all the correct details in this file. The file is created as part of the wizard, and has multiple stages where we would need to insert data and then continue to the next step.

By placeing a fully populated version of the above file and restarted confluence, basically just does nothing.

Anyway I have not given up yet, I just cant promise you will get this feature anytime soon.
I will investigate if I can populate this data via the api? Its probably not available until its fully installed, or I could look attempting to complete the setup through a series of http POSTS.

Failing all of that I will raise a support ticket with atlassian and ask for some advice.

[chihoko]

Hey, baie dankie, I really appreciate the investigation!

[nomoresecrets]

Any news on the database integration?

[mkrakowitzer]

Unfortunately not :( confluence is not like stash or jira. the API is terrible, the config files are even worse. Unless someone can give me some pointers or suggestions on how to handle this, my time is best spent elsewhere.

Sorry I know this is probably not the answer you where looking for.

[nomoresecrets]

Nevermind, I guess you don't get any money from Atlassian to for creating/maintaining puppet-modules ;)

Thanks for your work!

[JvdW]

Have a look at the puppet module for conflucence from jurgenlust also on github. He has support for a db connection

[mkrakowitzer]

Only after the initial install/setup, which means you need to use the
module, run puppet, follow the setup wizard, then update the params to
configure the dB, which you just configured using the wizard. I'm not sure
its a good idea.
On 27 Mar 2015 12:15, "JvdW" [email protected] wrote:

Have a look at the puppet module for conflucence from jurgenlust also on
github. He has support for a db connection

—
Reply to this email directly or view it on GitHub
#3 (comment)
.

[igalic]

@mkrakowitzer i think it's time to raise a ticket with atlassian.

[mkrakowitzer]

OK, will do it shortly. Let see how far this enterprise license of mine will get us :)

I had a closer look at the way its done in the module by jurgenlust, he basically has an onlyif statement and checks the config file for a particular string. When it matches, he can then manage the database config (After it was configured by the wizard).

We could add this, but it does not add value imho. Everything is already configured when you are forced to do it in the wizard. If you have a requirement to migrate databases or change the database hostname, this config file is the last thing you will be concerned about.

@igalic Let me know if you think its worth adding

[igalic]

i don't really know, @mkrakowitzer, i'm currently not using confluence._.

[jyaworski]

Hello: What's the status of this?

[ardrigh]

Is there any chance this might be supported now with Confluence 6 released?

There have been a few small releases already, so now would be a good time to ask if this could be supported.

There is something in the Java API but I don't think anyone wants to go there.
https://docs.atlassian.com/atlassian-confluence/latest-server/com/atlassian/confluence/it/setup/database/JdbcDatabaseSetup.html

[whynotkeithberg]

Hello! First thanks for your amazing puppet modules I use several of them. I recently used the Jira module and it's incredible so I decided to use your confluence page.

I've read through this issue and I completely understand why there isn't database support.

however, I think it would be nice if you could take it out from the README and other info on the github/forge page. I spent a little bit setting up the module and running it to find that the parameter doesn't exist. I dug through the puppet module to see what I did wrong and found that it only existed in the README.md. It may help some people if you put some of this discussion in the README. If you'd like, I'm happy to write up a little blurb & modify the README and send it back to you for approval if you like. I can't guarantee it will be amazing but I'm happy to help out here with all the work you've saved me.

Thanks again!