First, thanks for such a useful post. This is the best How To Install Redmine guide for cPanel/Ruby! I would like add two things to keep in mind while following this How-To that may not be clear or if your server behaves like mines
The database once created with cPanel may not have the proper character set. It should be UTF-8!
- You have to make sure that the database character set is UTF-8 before importing any data. Some cPanel/MySQL services, by default, setup databases with character sets for "latin1_swedish_ci" and not "utf8_general_ci". This simple MySQL command can quickly fix that:
ALTER DATABASE `redmine_database` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
Once unpacking the tar file, check to see that the user and usergroup for the redmine files/directories are set to your proper server's user and usergroup.
- After extraction, I noticed that the folder came with the default user:usergroup as 3000:3000. This simple SSH command line will fix that:
chown -R my_username:my_usergroup redmine-0.9.3
You may have to update your configuration on the .htaccess file
- Be sure that the rewrite rule points to your server correctly and that it is using the proper port. Here is how it is setup on my server:
RewriteRule ^(.*)$ "http://example.com:12001%{REQUEST_URI}" [P,QSA,L]
I'm excited about using Redmine. Hope this helps. Thanks again for the post!