Need Help in Confluence installation

Hi ,

I recently installed evaluation version of Confluence 4.3 in MAC OS Lion.

I could see installation went fine by default thec onfluence takes the HSQL DB instead i wanted to connect to mySQL.

I changed the confluence.cfg.xml and when i reastart the server i get

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'confluence.bandana' doesn't exist

This seems to be because the DB "confluence" does not have the mandatory tables.

How can create the tables required in mySQL DB , there is a confluencedb.script in data folder but it is specific to HSQL.

Could any one please helping me in sorting this out,

Thanks in advance ,

Aravind

2 answers

hi

sounds like your installed conflunece running on hsqldb

did you already took a look at

https://confluence.atlassian.com/display/DOC/Migrating+from+HSQLDB+to+MySQL ?

Thanks for the reply,

I tried using migration assiatant but getting below error,

Could not connect to Source DBMS.
[IM002] [iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded (0) (SQLDriverConnect)

ODBC connection string: jdbc:hsqldb:\Users\Aravind_\Desktop\confluence-data\database\confluencedb;hsqldb.tx=MVCC

Copied the hsqldb.jar to /mysql/lib folder.

Copied the hsqldb.jar to /mysql/lib folder.

why this location? shouldn't it be inside your application_installDIR

i.e. mine (using linux) is located here

/opt/atlassian/confluence/confluence/WEB-INF/lib

this dir contains the db drivers

ls -1 *sql*
hsqldb-2.2.4.jar
mysql-connector-java-5.1.22-bin.jar
postgresql-9.0-801.jdbc4.jar

Note that MacOS X is not supported as a server (check supported platforms). I recommend you to try installing it in a linux box.

I'm sorry I cannot downvote (yet)

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Mar 12, 2019 in Confluence

Confluence Admin Certification now $150 for Community Members

More and more people are building their careers with Atlassian, and we want you to be at the front of this wave! Important Dates Start the Certification Prep Course by 2 April 2019 Take your e...

271 views 2 10
Read article

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