MySQL datasource not set up in Tomcat

[esciara]

Hi,

I tried to actually install (finally... after playing around the environment :) ) a full Confluence server with the cookbook just to realise that the datasource for the MySQL Connector is not set in Tomcat. I guess some other bit could be missing to have it fully work.

For this point in particular, according to this Confluence documentation page, the DataSource Resource element should be set in the server.xml.erb, "within the Context element, directly after the opening <Context.../> line, before Manager". And it is not there:

                <Context path="" docBase="../confluence" debug="0" reloadable="false" useHttpOnly="true">
                  <Manager pathname="" />
                </Context>

Also need to add things in the web.xml.erb.

I am quite happy to add this to the cookbook and send a pull request. But will your merge it? I still have pull requests pending.

I am happy to give a hand to have it fully working... and tested.

Em

[esciara]

Aha! I just found that you are setting up a direct JDBC connection... as a note, this is done with this piece of code in recipes/linux_standalone.rb and recipes/linux_installer.rb:

if settings['database']['type'] == 'mysql'
  include_recipe 'mysql_connector'
  mysql_connector_j "#{node['confluence']['install_path']}/lib"
end

I have not been successful yet in going through the final setup web based process to verify that Confluence can be completely installed with the cookbook (need to deal with a SSL connection error) (it works :) ), but looking at the Database Setup For MySQL Documentation page Step 6, it is said:

Copy the driver JAR file to the /confluence/WEB-INF/lib folder in your new or upgraded Confluence installation.

This means the line should be more like:

  mysql_connector_j "#{node['confluence']['install_path']}/confluence/WEB-INF/lib"

I am used to install the JDBC driver through a datasource. It would make it possible to test the connection using sequel.

In any case, IMHO, this should be an option in the cookbook. As mentioned earlier, I am happy to work on a pull request.

[lock]

This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.