dotCMS Install - Mac OS X and MySQL

Description

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: http://diymacserver.com/installing-mysql/)
2. Secure mysql by creating a my.cnf file by copying the my-medium.cnf
to /etc (see: http://diymacserver.com/installing-mysql/securing-your-mysql-install/
3. Start mysql. If the startup pkg was installed, this works: sudo
/Library/StartupItems/

MySQLCOM/MySQLCOM start
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"
                 url="jdbc:mysql://localhost/dotcms?characterEncoding=UTF-8"
                 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
graceful-stop"
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 ./startup.sh
12. running startup creates all the tables in your mysql database. Now
you should have dotcms running. Go to localhost to see your startup
site.
13. to shutdown run ./shutdown.sh in the bin folder

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

--
Brad Rice
bradrice1 -- at -- gmail.com
‚Äč

Code

See Above