[Kevin L]

Hi, I'd like to set up the Redmine app on my site but I don't know what I'm doing. Has anyone done this? Or anything similar enough to help?

Here's what I've done:

Requested, and received, SSH access.
Made sure Ruby and Rails are both at the version level that are necessary for this app.
Ftp'd the SVN checkout of Redmine to a public subfolder.
Tried to follow the ASO wiki on setting up -- and failed. (But I don't really know what's necessary to do to set it up).

If it gives any insight, when trying to give a command like (as per instructions in ASO wiki):
kluikens@saul [~/www/redmine]# script controller User
openpty failed
Terminated

(I asked about this in a ticket to support, but they couldn't find a solution either).

If anyone could help, that'd be wonderful. If not, I'll give up and try out Trac instead.

[Kevin L]

I think I've made a little progress, as I know I've accessed the MySQL database and written data when doing the Rakefile. But it seems my Rails server is not running. I run into a 'Page Load Error' when clicking the url from the 'Ruby on Rails' subsection on cPanel. Is this because there's something wrong with my install, or the server running? Thanks.

[Kevin L]

I got it! Although this might all be easy to someone who's not a complete newby, I figure it's proper to write a tutorial now. Well, here goes.

Also, this contains no Windows specific instructions. I did this on a Leopard (10.5.4) running Macbook and assume it'll work on a Linux machine too.

==============================
Resources:
A Small Orange Wiki: Deploying an Existing Ruby App
Redmine Install Guide (localhost)
Local Redmine installation with Trac data migration (video)
==============================

Do you have SSH access? You'll need it. If not, send in a support ticket asking for such.

Let's grab Redmine -- it can be downloaded as zip or tarball here at RubyForge. Or you can pull the latest trunk with subversion:

CODE

svn co http://redmine.rubyforge.org/svn/trunk redmine
svn co svn://rubyforge.org/var/svn/redmine/trunk redmine

Go into the /config folder and make a duplicate of database.yml.example and delete .example off the copy. Once I had done that, I ftp'd it to my root ASO directory.

Next, create an empty MySQL database for it. I did this through cPanel. I named mine a generic redmine. Make sure you add a user.

You can do this in any text editor, but after tonight I like the GNU nano command-line editor. SSH into your account and navigate to /config so you can edit the database.yml file.

CODE

cd ~/redmine/config/
nano database.yml

Change the production block accordingly to your database:

CODE

production:
  adapter: mysql
  database: <username>_<database name>
  host: localhost
  username: <username>_<user>
  password: <user password>

Here, I follow steps 4 and 5 from the Redmine install guide.

Create the database structure, by running the following command under the application root directory. It will create tables and an administrator account.

CODE

cd ~/redmine/
rake db:migrate RAILS_ENV="production"

Insert default configuration data in database, by running the following command. This step is optional but highly recommended, as you can define your own configuration from scratch. It will load default roles, trackers, statuses, workflows and enumerations.

CODE

rake redmine:load_default_data RAILS_ENV="production"

Let's make sure that worked. (Credit: ASO Wiki) Navigate to:

CODE

cd ~/redmine/config/
nano environment.rb

And remove the comment from the line so that:

CODE

ENV['RAILS_ENV'] ||= 'production'

Now, let's test it by running the WEBrick server. Try the following command:

CODE

ruby script/server -e production

Did it work? Try your site at port 3000. It should be up and running!

Now, if anyone else knows -- does anyone know how to do some redirection so that example.com:3000 can be redirected to code.example.com?

[cypher543]

You're running WEBrick on your ASO account? I don't think that's allowed... RoR apps are perfectly capable of being installed and run from Apache.

[Kevin L]

You're running WEBrick on your ASO account? I don't think that's allowed... RoR apps are perfectly capable of being installed and run from Apache.

Not now -- I was following instructions for local-machine installs and they suggested that. I'm gonna set up the FastCGI stuff as soon as I get home. All of this is very much a learning experience.

[Alx]

Did you get any success with the dispatch? I'm blocked at this step...

[Alx]

Got the dispatch.fcgi working editing .htaccess:

replace:

<IfModule mod_fastcgi.c>
RewriteRule ^(.*)$ dispatch.fcgi [QSA,L]
</IfModule>
<IfModule mod_fcgid.c>
RewriteRule ^(.*)$ dispatch.fcgi [QSA,L]
</IfModule>
<IfModule mod_cgi.c>
RewriteRule ^(.*)$ dispatch.cgi [QSA,L]
</IfModule>

by:

RewriteRule ^(.*)$ dispatch.fcgi [QSA,L]

But then I got these lines in the error.log, continuing to dig to resolve it:

[Sat Nov 8 09:43:22 2008] [warn] FastCGI: (dynamic) server "/home/peeloo/public_html/redmine/dispatch.fcgi" has failed to remain running for 30 seconds given 3 attempts, its restart interval has been backed off to 600 seconds
[Sat Nov 8 09:43:19 2008] [warn] FastCGI: (dynamic) server "/home/peeloo/public_html/redmine/dispatch.fcgi" has failed to remain running for 30 seconds given 3 attempts, its restart interval has been backed off to 600 seconds
[Sat Nov 8 09:43:16 2008] [warn] FastCGI: (dynamic) server "/home/peeloo/public_html/redmine/dispatch.fcgi" has failed to remain running for 30 seconds given 3 attempts, its restart interval has been backed off to 600 seconds
[Sat Nov 8 09:43:13 2008] [warn] FastCGI: (dynamic) server "/home/peeloo/public_html/redmine/dispatch.fcgi" has failed to remain running for 30 seconds given 3 attempts, its restart interval has been backed off to 600 seconds
[Sat Nov 8 09:43:10 2008] [warn] FastCGI: (dynamic) server "/home/peeloo/public_html/redmine/dispatch.fcgi" has failed to remain running for 30 seconds given 3 attempts, its restart interval has been backed off to 600 seconds
[Sat Nov 8 09:43:07 2008] [warn] FastCGI: (dynamic) server "/home/peeloo/public_html/redmine/dispatch.fcgi" has failed to remain running for 30 seconds given 3 attempts, its restart interval has been backed off to 600 seconds
[Sat Nov 8 09:43:01 2008] [warn] FastCGI: (dynamic) server "/home/peeloo/public_html/redmine/dispatch.fcgi" (pid 13031) terminated by calling exit with status '1'
[Sat Nov 8 09:43:01 2008] [warn] FastCGI: (dynamic) server "/home/peeloo/public_html/redmine/dispatch.fcgi" (uid 32205, gid 32206) restarted (pid 13031)
[Sat Nov 8 09:42:55 2008] [warn] FastCGI: (dynamic) server "/home/peeloo/public_html/redmine/dispatch.fcgi" (pid 13008) terminated by calling exit with status '1'
[Sat Nov 8 09:42:55 2008] [warn] FastCGI: (dynamic) server "/home/peeloo/public_html/redmine/dispatch.fcgi" (uid 32205, gid 32206) restarted (pid 13008)
[Sat Nov 8 09:42:49 2008] [warn] FastCGI: (dynamic) server "/home/peeloo/public_html/redmine/dispatch.fcgi" (pid 12980) terminated by calling exit with status '1'
[Sat Nov 8 09:42:49 2008] [warn] FastCGI: (dynamic) server "/home/peeloo/public_html/redmine/dispatch.fcgi" (uid 32205, gid 32206) restarted (pid 12980)
[Sat Nov 8 09:42:43 2008] [warn] FastCGI: (dynamic) server "/home/peeloo/public_html/redmine/dispatch.fcgi" (pid 12954) terminated by calling exit with status '1'
[Sat Nov 8 09:42:43 2008] [warn] FastCGI: (dynamic) server "/home/peeloo/public_html/redmine/dispatch.fcgi" (uid 32205, gid 32206) started (pid 12954)

[Alx]

Another missing bit, in public/dispatch.fcgi, the header

#!/usr/bin/ruby

need to be replace with

#!/usr/local/bin/ruby

[robvs]

I couldn't get the latest Redmine trunk code to work on my ASO shared hosting account (Redmine 0.9.x requires Rack), so I tried a few other things, which are detailed here: http://robvs.wordpre...shared-hosting/. It isn't as detailed and organized as Kevin L's instructions, but you might still find it helpful.

[-ASO- Frank]

Nice writeup. If you have time, you may want to mirror it over to our wiki[1] so its easier for customers to find. Thanks!

[1] http://wiki.asmallorange.com

[Budi Dharmawan]

Whoa, I hope this thread is not obsolete yet since the last post was on May

So I have tried to install Redmine on my shared ASO host, at first I got rack / rails gem installation issues (rack 1.0.1 is needed), then I installed both gems.

gem list:

• actionmailer (2.3.5)
  
• actionpack (2.3.5)
  
• activerecord (2.3.5)
  
• activeresource (2.3.5)
  
• activesupport (2.3.5)
  
• rack (1.0.1)
  
• rails (2.3.5)
  
• rake (0.8.7)

but still, when I try the db:migrate, I got this following error :

!!! The bundled mysql.rb driver has been removed from Rails 2.2. Please install the mysql gem and try again: gem install mysql.
rake aborted!
no such file to load -- mysql

I am hoping for a positive answer here, sorry if my post sounds silly. This is my first post after all!

[Budi Dharmawan]

ah, turns out I can't install a system gems like that (Thanks B.J. from ASO)

then I got sql error to connect the database ----

Client does not support authentication protocol requested
by server; consider upgrading MySQL client

fixed it with this help : http://dev.mysql.com...old-client.html

after creating a subdomain for my Redmine :

cd ~/public_html
rm -R SUBDOMAIN_NAME
ln -S ~/redmine-folder SUBDOMAIN_NAME

and start the server..

IT. IS. ON.

thank you ASO support.

[Budi Dharmawan]

an update : if you want to view your git repositories in Redmine, you neet to edit the /lib/redmine/scm/adapters/git_adapter.rb GIT_BIN property to the git directory :

from ssh : which git

copy the git directory

edit the /lib/redmine/scm/adapters/git_adapter.rb (on line 24 or 25 ?)
GIT_BIN = "/usr/local/bin/git"

to the value you get from which git

thank you ASO support for installing git on my shared server!