changed to MySQL after HSQL database created
PostPosted:Wed Jan 16, 2013 8:17 pm
My plan while installing openkm 6.2 Community was to use MySQL instead of HSQL as the database type but I forgot one important step.
I neglected to make the changes described in the web page http://wiki.openkm.com/index.php/MySQL_-_OpenKM_6.2 prior to starting openkm by executing /tomcat/bin/startup.sh. Openkm therefore created the HSQL database.
Rather than repeating the installation of openkm I decided to try to change the database from the default to MySQL.
I stopped openkm by executing /tomcat/bin/shutdown.sh and then (after waiting for shutdown to complete) made the edits indicated in the above web page.
The process seems to have worked but I am disturbed by the caution on the above web page that I should not change databases once the databases have been created (or is it initialized?) . I am worried of hidden problems that may surface later. Do I have reason to worry? Do I need to delete the HSQL database?
By the way, I found to my surprise that I did not need to make any changes to OpenKM.xml as my file already had the correct information.
I would also like to suggest that, for clarity's sake , the word "databases" be changed to "tables" in the sentence "In this OpenKM release you can create the databases automatically configuring the hibernate.dialect and hibernate.hbm2ddl properties in OpenKM.cfg. " , since the openkm database needs to be manually created.
Thank you again for a wonderful product and the excellent community support.
I neglected to make the changes described in the web page http://wiki.openkm.com/index.php/MySQL_-_OpenKM_6.2 prior to starting openkm by executing /tomcat/bin/startup.sh. Openkm therefore created the HSQL database.
Rather than repeating the installation of openkm I decided to try to change the database from the default to MySQL.
I stopped openkm by executing /tomcat/bin/shutdown.sh and then (after waiting for shutdown to complete) made the edits indicated in the above web page.
The process seems to have worked but I am disturbed by the caution on the above web page that I should not change databases once the databases have been created (or is it initialized?) . I am worried of hidden problems that may surface later. Do I have reason to worry? Do I need to delete the HSQL database?
By the way, I found to my surprise that I did not need to make any changes to OpenKM.xml as my file already had the correct information.
I would also like to suggest that, for clarity's sake , the word "databases" be changed to "tables" in the sentence "In this OpenKM release you can create the databases automatically configuring the hibernate.dialect and hibernate.hbm2ddl properties in OpenKM.cfg. " , since the openkm database needs to be manually created.
Thank you again for a wonderful product and the excellent community support.