Need Help in Confluence installation

[aravind]

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

[Alejandro Conde Carrillo]

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

[Luca Orlandi]

I'm sorry I cannot downvote (yet)

[C_ Faysal]

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 ?

[aravind]

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.

[C_ Faysal]

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