Alfresco 3.3 on GlassfishV3 with jndi for 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.

spector

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?

spector

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.