[SOLVED] Mirgrate from HSQL to MySQL

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

newmember

So I had everything running fine with HSQL and I wanted to migrate to MySQL.
I had no data in this setup, it was a fresh install on CentOS 5.2.

When I restarted alfresco the first time after changing databases the java process' used all my SWAP file and ran for an hour without stopping.
I thought something was wrong so I rebooted.
After I rebooted.

Now I have the splash login but I can't use the admin:admin.

The remote server may be unavailable or your authentication details have not been recognised.

How do I trouble shoot this and/or any ideas?
Was the data in HSQL suppose to migrate to MySQL?

Thanks


Here are the commands I have done.

Install mysql from packages:
 yum install mysql-server
 
Start mysql 
 /etc/init.d/mysqld start
  
Test mysql is running:
 mysql -u root -p
  
Add Alfresco user etc to mysql
 mysql < /opt/Alfresco/extras/databases/mysql/db_setup.sql\
 
See if the database is there:

 #mysql
 mysql> show databases;
 +——————–+
 | Database           |
 +——————–+
 | information_schema |
 | alfresco           |
 | mysql              |
 | test               |
 +——————–+
 4 rows in set (0.00 sec)
 
 mysql> quit
 
OK lets now change Alfresco to use MySQL database: 

Browse to the tomcat\shared\classes\alfresco\extension\ directory.
Locate and open the following two files: 

* custom-hibernate-dialect.properties
* custom-repository.properties 

 vi custom-repository.properties
 
Add comments to HSQL connection options
Remove comments from MySQL connection options
So it looks like below:
 …..
 # Derby connection
 #
 #db.driver=org.apache.derby.jdbc.EmbeddedDriver
 #db.url=jdbc:derby:alf_data/derby_data/alfresco;create=true

 #
 # HSQL connection
 #
 #db.driver=org.hsqldb.jdbcDriver
 #db.url=jdbc:hsqldb:file:alf_data/hsql_data/alfresco;ifexists=true;shutdown=true;

 #
 # MySQL connection (This is default and requires mysql-connector-java-5.0.3-bin.jar, which ships with the Alfresco server)
 #
 db.driver=org.gjt.mm.mysql.Driver
 db.url=jdbc:mysql://localhost/alfresco
 ……
 
 
We need to change one more file:

 vi custom-hibernate-dialect.properties
 
 …….
 #
 # Derby dialect
 #
 #hibernate.dialect=org.hibernate.dialect.DerbyDialect

 #
 # HSQL dialect
 #
 #hibernate.dialect=org.hibernate.dialect.HSQLDialect

 #
 # MySQL dialect (default)
 #
 hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect
 
 #
 # PostgreSQL dialect
 #
 ……
 
Ok to restart Alfresco

 ./alfresco.sh stop
 ./virtual_alf.sh stop
 ./alfresco.sh start
 ./virtual_alf.sh start‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

loftux

Did you empty alf_data? If you previously started alfresco wiht another db setup you may alreade have data in there. Assuming you do no have any data there that you want to keep, just delete all subdirectories.

Also, set the dir.root to an absolute path for the data directory in the file custom-repository.properties.

Peter Löfgren