Right this is far more effort than I would of hoped, but at least some progress is being made.
First I had to install my on RubyGems system following http://wiki.dreamhost.com/index.php/RubyGems
This didn't work initially, but i think the last thing I changed was use the .bash_profile line from the second instructions (i.e. echo 'export GEM_PATH="$GEM_HOME:/usr/lib/ruby/gems/1.8"' >> .bash_profile)
With that working, I installed the camping. Again this didn't work straight away (I will try to remember what I did to get it working later)
Now I created my dispatch.fcgi file along the lines of the one described at http://code.whytheluckystiff.net/camping/wiki/TheCampingServerForApache however instead of a path I used 'current' which I saw in another example ...
Camping::Models::Base.establish_connection :adapter => sqlite3', :database => File.expand_path(current + '/camping.db')
Camping::FastCGI.serve File.expand_path(current)
Then I moved onto the .htaccess file. I am using ...
# General Apache options
AddHandler fastcgi-script .fcgi
Options +FollowSymLinks +ExecCGI
# Redirect all requests not available on the filesystem to Rails
# By default the cgi dispatcher is used which is very slow
RewriteEngine On
RewriteRule ^$ index.html [QSA]
RewriteRule ^([^.]+)$ $1.html [QSA]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule ^(.*)$ dispatch.fcgi [QSA,L]
# In case Rails experiences terminal errors
# Instead of displaying this message you can supply a file here which will be rendered instead
#
# Example:
# ErrorDocument 500 /500.html
ErrorDocument 500 "<h2>Application error</h2>Camping application failed to start properly"
But now when I try view the site I get the error message and in my error logs I get ...
[Thu Jun 07 15:04:59 2007] [error] [client 89.xxx.xxx.xxx] mod_rewrite: maximum number of internal redirects reached. Assuming configuration error. Use 'RewriteOptions MaxRedirects' to increase the limit if neccessary.