Need Help in Confluence installation

Question

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

Luca Orlandi · Answer

I'm sorry I cannot downvote (yet)

Alejandro Conde Carrillo · Answer

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

C.Faysal {CFcon} · Answer

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