Problems installing Confluence - multiple errors

First time setting up Confluence on Windows 2003, using the downloaded Zip file. Was planning on using SQL Server 2005.

VERY frustrated as the docs seem to be incomplete, or maybe I'm just stupid (or a combination).

Run startup, open browser, get a 404 resource not found error.

Run catalina, get this (below) - what are my problems (besides myself) and how do I fix them?

---

Sep 1, 2011 2:04:56 PM org.apache.coyote.http11.Http11Protocol pause

INFO: Pausing Coyote HTTP/1.1 on http-8085

Sep 1, 2011 2:04:57 PM org.apache.catalina.core.StandardService stop

INFO: Stopping service Tomcat-Standalone

Sep 1, 2011 2:04:57 PM org.apache.catalina.core.StandardContext stop

INFO: Container org.apache.catalina.core.ContainerBase.[Standalone].[localhost].[/] has not been started

Sep 1, 2011 2:04:57 PM org.apache.coyote.http11.Http11Protocol destroy

INFO: Stopping Coyote HTTP/1.1 on http-8085

Sep 1, 2011 2:11:08 PM org.apache.tomcat.util.digester.SetPropertiesRule begin

WARNING: [SetPropertiesRule]{Server} Setting property 'debug' to '0' did not find a matching property.

Sep 1, 2011 2:11:08 PM org.apache.tomcat.util.digester.SetPropertiesRule begin

WARNING: [SetPropertiesRule]{Server/Service/Engine} Setting property 'debug' to '0' did not find a matching property.

Sep 1, 2011 2:11:08 PM org.apache.tomcat.util.digester.SetPropertiesRule begin

WARNING: [SetPropertiesRule]{Server/Service/Engine/Host} Setting property 'debug' to '0' did not find a matching property.

Sep 1, 2011 2:11:08 PM org.apache.tomcat.util.digester.SetPropertiesRule begin

WARNING: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'debug' to '0' did not find a matching property.

Sep 1, 2011 2:11:08 PM org.apache.coyote.http11.Http11Protocol init

INFO: Initializing Coyote HTTP/1.1 on http-8085

Sep 1, 2011 2:11:08 PM org.apache.catalina.startup.Catalina load

INFO: Initialization processed in 852 ms

Sep 1, 2011 2:11:08 PM org.apache.catalina.core.StandardService start

INFO: Starting service Tomcat-Standalone

Sep 1, 2011 2:11:08 PM org.apache.catalina.core.StandardEngine start

INFO: Starting Servlet Engine: Apache Tomcat/6.0.32

Sep 1, 2011 2:13:38 PM org.apache.catalina.core.StandardContext start

SEVERE: Error listenerStart

Sep 1, 2011 2:13:39 PM org.apache.catalina.core.StandardContext start

SEVERE: Context [] startup failed due to previous errors

Sep 1, 2011 2:13:39 PM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc

SEVERE: The web application [] registered the JDBC driver [org.hsqldb.jdbc.JDBCDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.

Sep 1, 2011 2:13:39 PM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc

SEVERE: The web application [] registered the JDBC driver [com.mysql.jdbc.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.

Sep 1, 2011 2:13:39 PM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc

SEVERE: The web application [] registered the JDBC driver [org.postgresql.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.

Sep 1, 2011 2:13:39 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads

SEVERE: The web application [] appears to have started a thread named [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0] but has failed to stop it. This is very likely to create a memory leak.

Sep 1, 2011 2:13:39 PM org.apache.catalina.loader.WebappClassLoader clearThreadLocalMap

SEVERE: The web application [] created a ThreadLocal with key of type [com.atlassian.core.logging.ThreadLocalErrorCollection$2] (value [com.atlassian.core.logging.ThreadLocalErrorCollection$2@c5dbb]) and a value of type [java.lang.Boolean] (value [false]) but failed to remove it when the web application was stopped. This is very likely to create a memory leak.

Sep 1, 2011 2:13:39 PM org.apache.catalina.loader.WebappClassLoader clearThreadLocalMap

SEVERE: The web application [] created a ThreadLocal with key of type [java.lang.ThreadLocal] (value [java.lang.ThreadLocal@1ddc3ea]) and a value of type [org.dom4j.DocumentFactory] (value [org.dom4j.DocumentFactory@6963b0]) but failed to remove it when the web application was stopped. This is very likely to create a memory leak.

Sep 1, 2011 2:13:44 PM org.apache.coyote.http11.Http11Protocol start

INFO: Starting Coyote HTTP/1.1 on http-8085

Sep 1, 2011 2:13:44 PM org.apache.catalina.startup.Catalina start

INFO: Server startup in 155583 ms

12 answers

I understand your frustration. Lets take this one step at a time. When you do the initial install, are you able to run it using the built in database?

Nope, did the initial install two days ago. Spent some time working through some other issues. I didn't even know from the documentation that it has a built in database - but no, have not been able to run it successfully and access it at local host at all.

Can we start at the beginning again then?

Is this the only thing running on the server? If so then chances are your ports are not in use. If you have other products running on the server then you should determine which ports are available (netstat)

Remove the current install of Confluence.

Download the Confluence Windows installer. Run the installer. Note, if you are running a anti-virus on your server, especially if it is McAfee, you should disable it.

http://confluence.atlassian.com/display/DOC/Installing+Confluence+on+Windows

I would recommend that to start with we don’t worry about the service. Just start it inactively using the start-confluence.bat.

Let me know how it goes to that point

Thanks Jo-Anne, I'll try that. I'm assuming I can use the evaluation installer and enter my license later?

You will need to enter an evaluation license, but it will prompt you for that.

There will be more after this initial setup. But right now if we take it in small pieces, we can get you up and running in no time. (And connecting to sqlserver is very easy).

Wow-much easier. Not sure why the ZIP archive is recommended.

At database setup:

  1. note, instructions for installing jtds drivers are broken, sends you to the general DB setup instructions.
  2. downloaded jtds and installed in tomcat directory, added CLASSPATH
  3. input database details: confdb, username, and password (this is a domain user), get:

Configuring the database failed. Couldn't create the database schema.

java.sql.SQLException: Network error IOException: Connection refused: connect

I assume its not connecting. Where do I find the correct info / setup for this? or is there another recommended method?

But did it work initially before you tried to connect to your database? (There is a built in database that comes with it). the conneciton refused could be something as simple as the database username/password is incorrect. One of the other problems that I've had in the past is that TCPIP was not enabled on the sqlserver. Once that was enabled everything worked much better.

Thank you Jo-Anne, that works (I assume you mean installing the embedded database). Can you please point me to up to date, step by step instructions for getting this working with SQL Server and jtds or whatever the recommended setup is? I could also do PostgreSQL but it would be nice to have some accurate instructions :) not sure I trust what's on the site right now.

I was all set to send you the link and it turns out that there is an error in the link and its not resolving (Atlassian, are you out there?)

The JIRA link is working at, http://confluence.atlassian.com/display/JIRA/Connecting+JIRA+to+SQL+Server+2005 But it is a bit different.

The Confluence should be at: http://confluence.atlassian.com/display/DOC/Database+Setup+for+SQL+Server

Postgre is at this link and has the same error for the documentation as the confluence one:

http://confluence.atlassian.com/display/DOC/Database+Setup+for+PostgreSQL

(I'll check through my documenation and see if I ever printed it out. If I did I could sent it to you. But right now...its lunchtime)

Ok, back to work :) all of those instructions assume a fresh install. Now that I have it installed with the built-in database, what's the easiest way to move it to another DB? I don't care what I use, PostgreSQL, MySQL, or SQL Server 2005 - all are available installed. MySQL is with XAMPP if that's easier.

It also still shows as running an evaluation version - and I can't find any of the files described for setup (like the WEB-INF) directory.

I believe I have PostgreSQL installed and running ok (not sure about the drivers for connecting to confluence yet, though).

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Oct 24, 2018 in Confluence

Atlassian Research opportunity with Confluence templates

Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time!   We're looking for people to participate in a   remote 1-hr workshop...

1,103 views 17 14
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you