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

This widget could not be displayed.

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

This widget could not be displayed.

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
Posted Sep 17, 2018 in Confluence

Why start from scratch? Introducing four new templates for Confluence Cloud

Hi my Community friends!  For those who don't know me, I'm a product marketer on the Confluence Cloud team - nice to meet you! For those of you who do, you know that I've been all up in your Co...

569 views 7 6
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