ATG 2007.1 on Mac OS X with MySQL

For some weeks now ATG 2007.1 is available. My entry about installing ATG on Mac OS X explained how to install ATG 2006.3 on Mac OS X Tiger which is not supported by ATG . It got a few hits, so perhaps an update is needed.

Pre installation

• Have jboss-4.0.5GA ready. This is the only version supported by ATG 2007.1.
• Have MySQL ready. Only 5.0.20 is supported. However I have used 5.0.45 and so far it seems to be working fine. Make sure you use the InnoDB engine instead of the MyISAM.
• Create an ATG user on MySQL in a way you seem fit
• Add export JBOSS_HOME=<your JBOSS 4.0.5GA path here> to .bash_login. If you use another shell, you know what to do.
• Take care of your permissions.
• Download ATG2007.1 for Unix

Installation and configuration

• Run ATG2007.1.bin
• When asked to enter the path where to install ATG, remove the space. It will make things easier.
• When asked for JAVA_HOME use /System/Library/Frameworks/JavaVM.framework/Versions/ 1.5.0/Home or your preferred version.
• Drop your license files in <ATG folder>/home/localconfig
• Add the following line export ATGJRE=/System/Library/Frameworks/JavaVM.framework/ Versions/CurrentJDK/Commands/java to dasEnv.sh
• Copy MySQL JDBC driver (mysql-connector-java-5.0.7-bin.jar) to <JBOSS_HOME>/server/atg/lib
• Add a mysql-ds.xl to <JBOSS_HOME>/server/atg/deploy and fill in the correct database name etc.
• Create a file, like this: /home/localconfig/atg/dynamo/service/jdbc/JTDataSource.properties
  The ATG documentation states to create a jbossconfig folder with a change to a manifest to point to that path. I skipped that.
• Edit this JTDataSource.properties. It should contain:
  JNDIName=java:/MySqlDS
  and
  $class=atg.nucleus.JNDIReference
• Run datascripts:
  • /Applications/ATG2007.1/DAS/sql/install/mysql/das_ddl.sql
  • /Applications/ATG2007.1/DPS/sql/install/mysql/dps_ddl.sql
  • /Applications/ATG2007.1/DSS/sql/install/mysql/dss_ddl.sql
  • /Applications/ATG2007.1/DCS/sql/install/mysql/dcs_ddl.sql

  I used mysql -D <dbname> < /Applications/ATG2007.1/DAS/sql/install/mysql/ das_ddl.sql --user=<username> --password=<password>

Some notes

Adding Darwin to <ATG folder>/home/bin/DynamoEnv.sh is not something I use anymore as I did in 2006.3. I will assume Solaris. This will make patching easier, as Robert Hellwig found out.

Unlike ATG 2006.3 ATG2007.1 JTDatasource.properties can contain $class=atg.nucleus.JNDIReference

The executing of the SQL scripts was not correct in the previous Blog. The user and password command was wrong. Why didn’t anybody tell me?

On the previous blog entry, I got some questions on how you can tell MySQL to use InnoDB. Check your my.cnf or my.ini file. It’s in the ATG documentation: