Monday, July 12, 2010

How to Install confluence wiki on linux server(64 bit) + mysql database configuration error

Guys,

I have referred following URL to install the confluence wiki on linux(64 bit).

=====
http://confluence.atlassian.com/display/DOC/Installing+Confluence+Standalone+on+UNIX+or+Linux
=====

Regarding the DB setting you can refer the following URL :

====
http://confluence.atlassian.com/display/DOC/Database+Setup+For+MySQL

NB: You need to create one db user and db password. Just give grant privileges to the "confluence" db or customized DB that you had manually created.

====
http://confluence.atlassian.com/display/DOC/Configuring+a+MySQL+Datasource+in+Apache+Tomcat
====

Here are the error messages that I had received during configuring the DB at the browser.

====
* Configuring the database failed. Couldn't create the database schema.
* com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException:
Could not create connection to database server. Attempted reconnect 3 times.
Giving up
====

Sol : 1. The error is basically happened for mismatching of DB engine.
2. checked the DB engine at the backend like mysql# show variable like "%engine%";
3. Now you'll see the URL to connect the DB via jdbc driver like :
jdbc:mysql://localhost/confluenceuser?autoReconnect=true&sessionVariables=storage_engine%3DInnoDB

4. For my case DB engine was MyIsAm at mysql.
5. I setup the following URL :
jdbc:mysql://localhost/confluenceuser?autoReconnect=true&sessionVariables=storage_engine%3DMyIsAm
6. Then I proceeded further and I had successfully installed the software.

Try :)

3 comments:

  1. This post helped me stting up Confluence on Mandriva 2010.2 using MySQL databas on localhost. Change of DB engine was critical and also setting the HOME path.

    The real pain was to get JAVA SDK installed and JAVA_HOME path registered. Not even sure if I understand how I actually got right...Will it still work tomorrow? :-)

    ReplyDelete
  2. Please setup JAVA_HOME path in the profile. It'll still work once you restart the machine.

    ReplyDelete
  3. You can refer the following URL to setup the java home path :

    ----
    http://kmaiti.blogspot.com/2010/07/how-to-install-jdk16021-on-64-bit-linux.html
    ----

    ReplyDelete