MySQL Installation

Connect Daily requires version 5.0 or higher of MySQL.

1. Copy the MySQL Connector/J JDBC Driver files to your application server's path, or the cdaily-3.3.6/WEB-INF/lib directory.
2. Create the database and user:
   
   user:~>mysql --user=root
mysql>create database calendar character set utf8;
mysql>grant all privileges on calendar.* to 'calendar'@'localhost' identified by 'calendar';
mysql>grant SUPER on *.* to 'calendar'@'localhost';
mysql>exit
3. Create the database schema:
   
   user:~>mysql --user=calendar -p calendar
Enter Password:
mysql>\. calschema.sql
mysql>exit
4. Restore Permissions to Default
   
   user:~>mysql --user=root
mysql>revoke super on *.* from calendar;
5. Configure the JDBC entries in the cdaily-3.3.6/WEB-INF/configuration.properties file
   
   DBObjectClass=com.MHSoftware.db.support.MySQLDB
JDBCConnectString=jdbc\:mysql\://localhost\:3306/calendar
JDBCDriver=com.mysql.jdbc.Driver
JDBCPassword=calendar
JDBCUserID=calendar

Note

If your MySQL installation is an upgrade and you're having trouble with the Trigger creation complaining about SUPER, then you need to run the mysql fix permissions and tables upgrade script.

Triggers must be executed by the creator. It's important that you run the script using the same user the calendar will connect as. In MySQL 5.0, if this is not the case, then you'll need to grant SUPER to the Connect Daily database user.