dotCMS Install - Mac OS X and MySQL


This is a step by step guide to installing dotCMS on OSX using MySQL as your DB. 

Installing dotcms on Mac OS X with mysql

1. Install mysql (see:
2. Secure mysql by creating a my.cnf file by copying the my-medium.cnf
to /etc (see:
3. Start mysql. If the startup pkg was installed, this works: sudo

4. create a empty database in mysql. I used the name "dotcms".  Make sure you have innodb table support installed.
5. create a user for that database. I used "dotcms"
6. Edit the ROOT.xml file in
<dotcmsreleasefolder>/tomcat/conf/Catalina/localhost/ by setting this block
using database name, username and password:

<!-- MYSQL UTF8 -->
       <Resource name="jdbc/dotCMSPool" auth="Container"
                 type="javax.sql.DataSource" driverClassName="com.mysql.jdbc.Driver"
                 username="dotcms" password="<yourpassword>" maxActive="60"
maxIdle="10" maxWait="60000"
                 removeAbandoned="true" removeAbandonedTimeout="60" logAbandoned="true"
                 validationQuery="SELECT 1" testOnBorrow="true"/>

7. Comment out the POSTGRES block which is set as the default database
8. If you have Apache running, shut it down by running "sudo apachectl
9. On the command line go to your dotcms release folder and run
"chmod -R 755 ./bin/*.sh" and "chmod 755 ./tomcat/bin/*.sh"
10. cd to bin
11. run ./
12. running startup creates all the tables in your mysql database. Now
you should have dotcms running. Go to localhost to see your startup
13. to shutdown run ./ in the bin folder

14. to view the catalina log, open a Terminal in the ./tomcat/logs folder and
run "tail -f dotcms.out"

Brad Rice
bradrice1 -- at --


See Above