viagra europe acheter finasteride compro levitra levitra france achat viagra en ligne commande cialis prozac sans ordonnance levitra naturale viagra ricetta acheter kamagra impuissance sexuelle cialis sans prescription acheter cialis sans ordonnance cialis vente libre vente viagra zyban prix sildenafil venta libre vendo levitra vendita cialis cialis kauf kamagra apcalis vardenafil generico sildenafil venta levitra rezeptfrei acheter cialis sur internet viagra preis vendo levitra levitra ohne rezept aquisto levitra accutane generique acheter kamagra 100mg acheter viagra pas chere vendo viagra milano viagra te koop sildenafil generico achat de viagra tadalafil precio trouver du cialis kamagra pas cher ordina viagra acquisto viagra italia vente de cialis cialis generico viagra kopen achat de levitra propecia prix cialis 10mg medicament levitra cialis bon prix acheter viagra vendo viagra pilule viagra acquisto viagra svizzera levitra prijs cialis europe viagra svizzera acheter du kamagra vendo sildenafil kamagra rezeptfrei levitra ricetta vendo viagra achat kamagra traitement impuissance viagra bestellen viagra farmacia achat vardenafil trouver du levitra viagra generique cialis vente libre viagra senza ricetta cialis generique en france viagra verkauf levitra venta libre viagra kosten cura impotenza levitra sur internet comprar sildenafil viagra prijs cialis svizzera viagra sin receta disfunzione erettile rimedi viagra 50 mg vente de cialis sur internet pharmacie en ligne viagra ohne rezept vendo cialis generique cialis tadalafil rezeptfrei viagra ordonnance aquisto viagra cialis sur le net cialis belgique compra levitra achat de cialis commande levitra sildenafil costo vardenafil generique acheter cialis moins cher zithromax prix acquistare viagra levitra generico tadalafil 10 mg costo viagra comprar viagra pela internet comprar levitra generica acquista levitra compro cialis kamagra te koop il viagra levitra venta levitra italia impotenza cure vente cialis clomid prix comprar cialis cialis pharmacie levitra generique acquisto viagra originale viagra prezzo viagra naturale cialis en ligne cialis generico 10 mg cialis sin receta viagra en ligne levitra te koop levitra effet secondaire acheter cialis en pharmacie pastilla levitra achat cialis 20mg comprar cialis em portugal acheter cialis pas chere cialis suisse

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.

One Response to “The Joys of Setting up Confluence!!”

  1. Hi Farhan

    Great if you have time to come and start a thread on how you see technology imoacting Future Capitalism at

    In our year long dialogue with 10000 Youth and Yunus alumni , 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

Leave a Reply

Spam Protection by WP-SpamFree

  • Add Feed to Reader:

  • Add to Google Reader or Homepage
    Subscribe in NewsGator Online
    Add to netvibes
    Subscribe in Bloglines
    Add to Technorati Favorites

  • Categories