HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)

- Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=16)

- - Ruby on Rails Tutorial need help (http://www.howtoforge.com/forums/showthread.php?t=3642)

Ruby on Rails Tutorial need help

I found this tutorial which details how to install Ruby on Rails on a system running Ubuntu5.10, Mysql, Apache2, and fcgid. All of which are included in the 'perfect setup' box I'm running. The question is which tutorial steps need to be changed in order to get Ruby on Rails working with ISPConfigs configuration.

It might work with ISPConfig if you put the lines oin step 12 in the apache directives field in the website settings in ISPConfig instead of the .htaccess file.

Even with the apache directives. I still get

500 error - Internal Server Error!

when trying to access the public directory in my Rails app

step 11 says to change the document root for my virtual host to the public directory of the rails app however after changing the Vhost file
$/etc/apache2/vhosts/Vhosts_ispconfig.conf
for my site after about 10mins or so this gets changed back to the default document root by ISPConfig. Is it possible to change the document root for our virtual sites?

Quote:

Originally Posted by Geoinline

Is it possible to change the document root for our virtual sites?

No, that's not possible.

Interesting problem

After following countless rails tutorials and trying different things to get it working with ISPConfig i get this error when reloading apache2.

grep: /etc/apache2/fcgid.conf: No such file or directory
grep: /etc/apache2/fcgid.load: No such file or directory
grep: /etc/apache2/rewrite.load: No such file or directory
/etc/init.d/apache2: line 103: kill: (14415) - Operation not permitted

Does this give you any ideas as to what needs to be configured?

Could this be caused by me adding
AddHandler fcgid-script .fcgi
to my Apache Directives (Optional): in ISPConfig?

One problem I've come across that would be beneficial to know is that the public directory of a rails app has it's own .htaccess file. This caused this error in web##/log/errors.log
/var/www/web##/web/testapp/public/.htaccess: Options not allowed here
after deleting this file I could then load .html files through my symlink

I've managed to setup a symlink in my web##/web dir to the web##/cgi-bin/testapp/public dir which allows me to load .html docs through the symlink however when I add

RewriteEngine On
To Apache Directives (Optional):

I can no longer load .html docs through the symlink. If RewriteEngine is required by rails and it appears putting it in the Directives doesn't work..
Where should I enable RewriteEngine?

Also how would I configur my app to access mysql if the app's datebase file looks like this

Quote:

# MySQL (default setup). Versions 4.1 and 5.0 are recommended.
#
# Get the fast C bindings:
# gem install mysql
# (on OS X: gem install mysql -- --include=/usr/local/lib)
# And be sure to use new-style password hashing:
# http://dev.mysql.com/doc/refman/5.0/en/old-client.html
development:
adapter: mysql
database: depot_development
username: root
password:
socket: /path/to/your/mysql.sock

# Connect on a TCP socket. If omitted, the adapter will connect on the
# domain socket given by socket instead.
#host: localhost
#port: 3306

# Warning: The database defined as 'test' will be erased and
# re-generated from your development database when you run 'rake'.
# Do not set this db to the same as development or production.
test:
adapter: mysql
database: depot_test
username: root
password:
socket: /path/to/your/mysql.sock

production:
adapter: mysql
database: depot_production
username: root
password: wibble
socket: /path/to/your/mysql.sock

# PostgreSQL versions 7.4 - 8.1
#
# Get the C bindings:
# gem install postgres
# or use the pure-Ruby bindings on Windows:
# gem install postgres-pr
postgresql_example:
adapter: postgresql
database: depot_development
username: depot
password:

# Connect on a TCP socket. Omitted by default since the client uses a
# domain socket that doesn't need configuration.
#host: remote-database
#port: 5432

# Schema search path. The server defaults to $user,public
#schema_search_path: myapp,sharedapp,public

# Character set encoding. The server defaults to sql_ascii.
#encoding: UTF8

# Minimum log levels, in increasing order:
# debug5, debug4, debug3, debug2, debug1,

# info, notice, warning, error, log, fatal, or panic
# The server defaults to notice.
#min_messages: warning

# SQLite version 2.x
# gem install sqlite-ruby
sqlite_example:
adapter: sqlite
database: db/development.sqlite2

# SQLite version 3.x
# gem install sqlite3-ruby
sqlite3_example:
adapter: sqlite3
database: db/development.sqlite3

# In-memory SQLite 3 database. Useful for tests.
sqlite3_in_memory_example:
adapter: sqlite3
database: ":memory:"

I log into phpmyadmin with:
Username: web17_db1

Quote:

Originally Posted by Geoinline

Yes. I guess the fastcgi daemon (fcgid) configuration is missing.

Quote:

One problem I've come across that would be beneficial to know is that the public directory of a rails app has it's own .htaccess file. This caused this error in web##/log/errors.log
/var/www/web##/web/testapp/public/.htaccess: Options not allowed here
after deleting this file I could then load .html files through my symlink

I've managed to setup a symlink in my web##/web dir to the web##/cgi-bin/testapp/public dir which allows me to load .html docs through the symlink however when I add

RewriteEngine On
To Apache Directives (Optional):

I can no longer load .html docs through the symlink. If RewriteEngine is required by rails and it appears putting it in the Directives doesn't work..
Where should I enable RewriteEngine?

Put the content from your .htaccess file in the apache directives field of the website and remove the .htaccess file.

Quote:

Also how would I configur my app to access mysql if the app's datebase file looks like this

I log into phpmyadmin with:
Username: web17_db1

If this databadase was created with ISPConfig, the username is not web17_db1, it is web17_u1. web17_db1 is the name of the database.

I'am not familar with rails. But generally the database details are:

host: localhost
user: web17_u1
password: Your database password
database: web17_db1

Quote:

Yes. I guess the fastcgi daemon (fcgid) configuration is missing.

So how would I go about reinstalling fcgid?

Thanks for you help so far :)

What's the output of

Code:

ls -la /etc/apache2/mods-available

drwxr-xr-x 2 root root 4096 2006-04-22 10:17 .
drwxr-xr-x 9 root root 4096 2006-04-22 10:21 ..
-rw-r--r-- 1 root root 66 2005-10-04 02:52 actions.load
-rw-r--r-- 1 root root 60 2005-10-04 02:52 asis.load
-rw-r--r-- 1 root root 70 2005-10-04 02:52 auth_anon.load
-rw-r--r-- 1 root root 68 2005-10-04 02:52 auth_dbm.load
-rw-r--r-- 1 root root 74 2005-10-04 02:52 auth_digest.load
-rw-r--r-- 1 root root 130 2005-10-04 02:52 auth_ldap.load
-rw-r--r-- 1 root root 62 2005-10-04 02:52 cache.load
-rw-r--r-- 1 root root 70 2005-10-04 02:52 cern_meta.load
-rw-r--r-- 1 root root 61 2005-10-04 02:52 cgid.conf
-rw-r--r-- 1 root root 60 2005-10-04 02:52 cgid.load
-rw-r--r-- 1 root root 58 2005-11-21 13:11 cgi.load
-rw-r--r-- 1 root root 58 2005-11-21 13:11 cgi.load.21-11-05_13-11-02
-rw-r--r-- 1 root root 37 2005-10-04 02:52 dav_fs.conf
-rw-r--r-- 1 root root 64 2005-10-04 02:52 dav_fs.load
-rw-r--r-- 1 root root 58 2005-10-04 02:52 dav.load
-rw-r--r-- 1 root root 66 2005-10-04 02:52 deflate.load
-rw-r--r-- 1 root root 72 2005-10-04 02:52 disk_cache.load
-rw-r--r-- 1 root root 66 2005-10-04 02:52 expires.load
-rw-r--r-- 1 root root 72 2005-10-04 02:52 ext_filter.load
-rw-r--r-- 1 root root 108 2006-04-11 17:35 fcgid.conf
-rw-r--r-- 1 root root 62 2005-04-08 02:11 fcgid.load
-rw-r--r-- 1 root root 72 2005-10-04 02:52 file_cache.load
-rw-r--r-- 1 root root 66 2005-10-04 02:52 headers.load
-rw-r--r-- 1 root root 60 2005-10-04 02:52 imap.load
-rw-r--r-- 1 root root 66 2005-11-21 13:11 include.load
-rw-r--r-- 1 root root 66 2005-11-21 13:11 include.load.21-11-05_13-11-02
-rw-r--r-- 1 root root 60 2005-10-04 02:52 info.load
-rw-r--r-- 1 root root 60 2005-10-04 02:52 ldap.load
-rw-r--r-- 1 root root 70 2005-10-04 02:52 mem_cache.load
-rw-r--r-- 1 root root 90 2005-10-04 02:52 mime_magic.conf
-rw-r--r-- 1 root root 72 2005-10-04 02:52 mime_magic.load
-rw-r--r-- 1 root root 135 2005-11-21 13:11 php4.conf
-rw-r--r-- 1 root root 135 2005-11-21 13:11 php4.conf.21-11-05_13-11-02
-rw-r--r-- 1 root root 59 2005-11-21 13:11 php4.load
-rw-r--r-- 1 root root 59 2005-11-21 13:11 php4.load.21-11-05_13-11-02
-rw-r--r-- 1 root root 840 2005-10-04 02:52 proxy.conf
-rw-r--r-- 1 root root 78 2005-10-04 02:52 proxy_connect.load
-rw-r--r-- 1 root root 70 2005-10-04 02:52 proxy_ftp.load
-rw-r--r-- 1 root root 72 2005-10-04 02:52 proxy_http.load
-rw-r--r-- 1 root root 316 2005-10-04 02:52 proxy.load
-rw-r--r-- 1 root root 66 2005-11-21 13:11 rewrite.load
-rw-r--r-- 1 root root 66 2005-11-21 13:11 rewrite.load.21-11-05_13-11-02
-rw-r--r-- 1 root root 66 2005-10-04 02:52 speling.load
-rw-r--r-- 1 root root 3545 2005-11-21 13:11 ssl.conf
-rw-r--r-- 1 root root 3545 2005-11-21 13:11 ssl.conf.21-11-05_13-11-02
-rw-r--r-- 1 root root 58 2005-11-21 13:11 ssl.load
-rw-r--r-- 1 root root 58 2005-11-21 13:11 ssl.load.21-11-05_13-11-02
-rw-r--r-- 1 root root 64 2005-11-21 13:11 suexec.load
-rw-r--r-- 1 root root 64 2005-11-21 13:11 suexec.load.21-11-05_13-11-02
-rw-r--r-- 1 root root 70 2005-10-04 02:52 unique_id.load
-rw-r--r-- 1 root root 244 2005-11-21 13:11 userdir.conf
-rw-r--r-- 1 root root 244 2005-11-21 13:11 userdir.conf.21-11-05_13-11-02
-rw-r--r-- 1 root root 66 2005-11-21 13:11 userdir.load
-rw-r--r-- 1 root root 66 2005-11-21 13:11 userdir.load.21-11-05_13-11-02
-rw-r--r-- 1 root root 70 2005-10-04 02:52 usertrack.load
-rw-r--r-- 1 root root 74 2005-10-04 02:52 vhost_alias.load

i don't get that error anymore when i try to restart apache2, because i removed some broken symlinks that where in my apache2 dir called fcgid.conf, fcgid.load and rewrite.load