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
Note that MacOS X is not supported as a server (check supported platforms). I recommend you to try installing it in a linux box.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.