Alfresco 4 Community and MySQL

[heden75]

Hi,

I just set up the new Alfresco 4 Community edition but was surprised by the use of Postgres as the default database. I tried both the easy and advanced installation but couldn't change the database to mysql as there are no mysql scripts to populate the database. Any help would be much appreciated.

How about the upgrading process  ? I previously set up a version 3.3 with MySQL and don't see then how to upgrade to this version 4.0 under Postgres.

Regards,
Arnaud.

[mrogers]

Alfresco 4 community works fine with MySql however as you have seen its no longer an option in the installer.    AFAIK the problem was we couldn't get a straight answer about whether we could distribute MySql in the installers.

Perhaps the easiest option is to install with the postgress database and then switch over the database settings to mysql.    Or just do a manual install using the alfresco.war file.

[mikeh]

Please see http://docs.alfresco.com/3.4/topic/com.alfresco.Enterprise_3_4_0.doc/tasks/mysql-config.html

Thanks,
Mike

[heden75]

Thanks for your explanation but the MySQL database once create does not get populated (neither tables nor data) and the software is not runnning then. 

I had a look at the reference document - http://docs.alfresco.com/3.4/topic/com.alfresco.Enterprise_3_4_0.doc/tasks/mysql-config.html -that I used for the version 3.3 installation. Version 4.0 doesn't look to have the same file hierarchy and I actually don't see the advantage to move to the version 4 if we continue to use the version 3.4 scripts.

Arnaud.

[mrogers]

If the database tables are "not populated".    Then you have not connected to the database properly.  Check your alfresco-global. properties.   You will also need to delete the contents of alf data from your temporary install with Postgresql.

The quick and dirty way to upgrade is to just shutdown, backup, replace the alfresco and share war files and then restart.

[sjoerdjump]

If the database tables are "not populated".    Then you have not connected to the database properly.  Check your alfresco-global. properties.   You will also need to delete the contents of alf data from your temporary install with Postgresql.

The quick and dirty way to upgrade is to just shutdown, backup, replace the alfresco and share war files and then restart.

I will try this first. Having problems with 32 bit linux and alfresco 4.0
Can't seem to find the info i am looking for…

[cloudcontrol]

same here- no joy on a CLEAN install of latest nightly build (11/18) - even after deleting the /alf_data/ contents for good measure. Installing from the .war file it does not automatically create the MySQL tables- here is my alfresco-global.properties DB section:

db.name=alfresco
db.username=alfresco
db.password=alfresco
db.host=localhost
db.port=3306
#

Has Alfresco drank the bitrock Kool-Aid and forgotten how to support those you install manually?

[mrogers]

Have you created the empty database for alfresco to use?

create database alfresco DEFAULT CHARACTER SET utf8;
grant all on alfresco.* to 'alfresco'@'localhost' identified by 'alfresco' with grant option;
grant all on alfresco.* to 'alfresco'@'localhost.localdomain' identified by 'alfresco' with grant option;

[loftux]

In repository.properties file the default db url is
db.url=jdbc:mysql:///${db.name}

That means that setting db.host and db.port has no effect.
You can change it to
db.url=jdbc:mysql://${db.host}:${db.port}/${db.name}
(the default one should still work if you are on localhost)

and make sure you grant permissions to the user connecting from the domain as mrogers mentioned.

[jpfi]

hi,
you'll have to put the mysql-jdbc-driver in tomcat/lib ( mysql-connector-java-5.x.x-bin.jar) if you havn't done yet.
cheers, jan