View Single Post
  #5  
Old 14th April 2006, 18:05
Geoinline Geoinline is offline
Member
 
Join Date: Nov 2005
Posts: 50
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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

Last edited by Geoinline; 14th April 2006 at 19:53.
Reply With Quote