Alfresco 3.3 on GlassfishV3 with jndi for Mysql

spector — Tue, 24 Aug 2010 17:13:53 GMT

Can anyone provide a walk through in using Alfresco 3.3 on a glassfish V3 that uses jndi (A jdbc to an external Mysql 5.1).I tried compiling alfresco and placing it but it takes a long time to do so and then dies on me. (Yes i am a newbee here). Any heads up?

Re: Alfresco 3.3 on GlassfishV3 with jndi for Mysql

spector — Tue, 24 Aug 2010 20:35:09 GMT

First step:
Prepare the DB. (Assuming you have a Mysql 5.1 already installed somewhere)

Execute these commands in Mysql, using the root account.

create database alfresco default character set utf8 collate utf8_bin;
grant all on alfresco.* to 'alfresco'@'localhost' identified by 'alfresco' with grant option;
grant all on alfresco.* to 'alfresco'@'%' identified by 'alfresco' with grant option;
grant all on alfresco.* to 'alfresco'@'localhost.localdomain' identified by 'alfresco' with grant option;

The schema will be filled once the alfresco.war file is load onto Glassfish.

Second step:
Get the alfresco package. Go and download the alfresco-community-war-3.3g.zip file. Unzip the file and also unzip the alfresco.war file.

third step:
Open and modify the alfresco-global.properties (found at \alfresco-community-war-3.3g\extensions\extension\alfresco-global.properties )as you wish.
(For this example the DB is on another machine , so you change the db.host=localhost to db.host="Machine's IP address", then save the file)

copy the file \alfresco-community-war-3.3g\extensions\extension\alfresco-global.properties into the unzipped alfresco directory (\alfresco-community-war-3.3g\alfresco\WEB-INF\classes\alfresco-global.properties) zip up the alfresco and change the extension to ".war" instead of ".zip"

Forth step:
Log into the glassfish console and deploy the share.war first, followed by the alfresco.war.

You must wait a few minutes to do this. During this time alfresco.war file will populate you schema on the Mysql DB.

*Note in order to make Glassfish handle the jdbc connection by its self, it would take some changing on the war files, and well I still need to research how to do this. Ill update if i manage to figure this out. Although it would be a very good option, since it would make Alfresco a bit faster and a bit lighter.

topic Alfresco 3.3 on GlassfishV3 with jndi for Mysql in Alfresco Archive

Alfresco 3.3 on GlassfishV3 with jndi for Mysql

Re: Alfresco 3.3 on GlassfishV3 with jndi for Mysql