The Joys of Setting up Confluence!!
When configuring and setting up Confluence, it’s possible to hit those roadblocks along the way that can slow you down, or completely throw you off track… I hit one such hurdle recently. Not being someone who is proficient in Tomcat, MS SQL Server, and all things Java, and JDBC related..
Steps – install MS SQL Server
Install Tomcat Apache
Generate EAR to install into Tomcat, with the desired version of Confluence.
Install the EAR, through the Tomcat Manager, to install Confluence.
Then comes the fun..
First Create the MS SQL instance. Then in that instance, create a database, that will then be used to store the data from Confluence in. [important note, once you've created the instance, it's important to make sure you create the database, inside the instance that you'll want to use yourself, otherwise you will go through countless hours, trying to connect to the instance, when all the app can do, is connect to the database, inside of the instance.
I then would strongly recommend you go to SQL Server Configuration Manager, go to SQL Server Network Configuration > then protocols for the SQL instance that you've created and which contains the database in it. Make sure that the Protocol for TCP/IP is enabled, then go to the properties, and on the IP Addreses tab, take note of the TCP Dynamic Ports number. If you want, you can change this to 1433, which seems to be a general recommendation, everywhere I've ever seen it.
If it weren't for The Java Ranch Forum I wouldn't have gotten that vital bit of info - so huge props to whoever wrote it!!
Next, on the server, make sure you open up all the ports, that relate to MS SQL server, so that it can work properly. After that you may want to then download the helpertest.jsp file from atlassian, which will only work, once you go into the WEB-INF folder, and rename web.xml to backup web.xml (once you've got things working, and tested you'll want to return that name of that file back...
Next, load up that test file, and pop in the following information:
(At this stage we're assuming that you have downloaded the most recent, or already have the jtds driver saved into your webapps/confluence/lib directory)
Test a Standard Database Connection:Driver Class Name: JDBC URL: DB username: DB password:
NOTE: Port number, is as set up in SQL Configuration Manager, under the TCP Dynamic Port for the particular instance that contains that database that you'll be connecting to. Also, when using the JDBCURL, the first part is just the same as the one up top.. the part that says [goldmine] should be replaced with IP, or servername, followed by the correct port number. After the forward slash, you don’t write the name of the instance of the database, you write the name of the database itself created inside of the instance. Hope that’s clear! So for instance Confluence, where you create a database of confluence-data, you only need the confluence-data part in the JDBC URL..
Crazy, but it works…
Once the test passes as ok, for it all, you’re ready to complete running the setup in the main program.
No related posts.
Related posts brought to you by Yet Another Related Posts Plugin.
Hi Farhan
Great if you have time to come and start a thread on how you see technology imoacting Future Capitalism at http://futurecapitalism.ning.com/
In our year long dialogue with 10000 Youth and Yunus alumni http://yunus10000.com , november’s focus is internet for the poor with california celebrating Yunus contributions to ending digital divides with the museum of tech’s award ceremony next week http://futurecapitalism.ning.com/forum/topics/small-things-about-yunus-or