Tableau Installation (Dedicated cPanel Servers)
Posted by Miraenda Mon, 19 Jun 2006 01:57:00 GMT
This version of Tableau requires Ruby 1.8.2 or later and Rails 1.0 or later with FastCGI. If your dedicated server does not already have Ruby and Rails installed on it, you can contact dedicated@lunarpages.com to request an installation. Please provide the last 4 digits of your card on file for ownership confirmation along with your dedicated server domain name or account username. Managed addon customers have 1 free script installation available to them. Non-managed addon customers would pay $75 per hour for the script. Ruby and Rails with FastCGI support takes approximately 1 hour to install.
A. Creating your database for Tableau:
- Log into cPanel and click on MySQL Databases icon:
- As per the example below, enter tab in the "New Database" field under Current Databases area, then click "Create Database" button. Your full database name will then show as cPaneluser_tab.
- Under Current Users area as seen in the example below, enter tab for the "Username" field and enter a password that you write in your notes for the "Password" field, then click "Create User" button. Your full database user's name will then show as cPaneluser_tab.
- Under Add Users to Your Database area as shown below, select in the "User" dropdown cPaneluser_tab and select in the "Database" dropdown cPaneluser_tab, then click "Add User to Database" button.
B. Checkout tableau via subversion:
If you do not already have subversion installed, please see this tutorial on how to do so.
In shell SSH as root, run the following command, remembering to replace user with the username for the account onto which you are installing Tableau:
cd /home/user
svn checkout svn://creativi.st/tableau/trunk tableau
This will create a directory called tableau at /home/user/ with the newest copy of Tableau available.
C. Ensure .htaccess has right dispatch.fcgi entry:
cd /home/user/tableau/public
vi .htaccess
RewriteRule ^(.*)$ dispatch.cgi?$1 [QSA,L]
to
RewriteRule ^(.*)$ dispatch.fcgi?$1 [QSA,L]
D. Copy the database.yml.sample file to database.yml and edit it:
cd /home/user/tableau/config
cp database.yml.sample database.yml
vi database.yml
H. Replace whatever it has with the following then change cPaneluser to your cPanel username and somepass to your database user's password (the 2 spaces to the left of some of the lines are spaces not tabs, so do not change them to tabs):
# MySQL (default setup). Versions 4.1 and 5.0 are recommended. development: adapter: mysql database: cPaneluser_tab username: cPaneluser_tab password: somepass # socket: /tmp/mysql.sock production: adapter: mysql database: cPaneluser_tab username: cPaneluser_tab password: somepass # socket: /tmp/mysql.sock
E. Edit the environment.rb file:
cd /home/user/tableau/config
vi environment.rb
#ENV['RAILS_ENV'] = 'production'
to
ENV['RAILS_ENV'] = 'production'
require 'rmagick'
to
require 'RMagick'
F. Migrate the database:
cd /home/user/tableau
rake migrate
G. Symlink the directories (if you will be using tableau at http://domain.com):
cd /home/user
mv public_html public_html.bak
ln -s /home/user/tableau/public public_html
mkdir public_html/cgi-bin
chown -R user:user public_html
chown user:nobody public_html
If you will be using tableau at http://domain.com/folder do the following instead:
cd /home/user/public_html
ln -s ../tableau/public folder
H. Loading up Tableau in a browser:
You should now be able to navigate to tableau at either http://domain.com/ or http://domain.com/folder/, depending on which you chose in Step G. You will need to signup by clicking the login link on the left hand side to begin administering the gallery.
Please see Tableau site for images on administration. Please see a demo of Tableau at gallery.rubyasylum.com.
Have fun with your new gallery!
