Ruby Asylum

Tableau Installation (Shared cPanel Servers)

Posted by Miraenda Sun, 18 Jun 2006 02:56:00 GMT

This version of Tableau requires FastCGI and Rails version 1.0 or greater as well as RMagick gem. The current servers that this will work on are Alcor, Gallifrey and Telos.

A. Creating your database for Tableau:

1. Log into cPanel and click on MySQL Databases icon:

2. 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.

3. 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.

4. 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. Get a Copy of tableau.tar.gz

Download a copy of the current release (svn copy) from here. After obtaining a copy that you have saved to your system, you can then proceed with the next steps.

C. Upload Tableau Using cPanel:

1. Log into cPanel.
2. Click on "File Manager" icon:

3. A new window will open. In that new window, click on "Upload File(s)" link toward the top:


4. The page will load new content. Click one of the "Browse..." buttons:


5. The Windows "File Upload" dialog prompt will open. Navigate to where you saved tableau.tar.gz on your system, highlight tableau.tar.gz, then click the "Open" button.


6. Back at the File Manager screen where you have the "Browse..." button, click the "Upload" button:


7. Tableau will begin uploading. Please note that it might take awhile for it to upload due to the size, usually around 3-15 minutes depending on your connection speed.

D. Upload Tableau via FTP:

If you prefer to use FTP to upload so you see the progress of the file upload, try the following instead

1. Open your FTP client and access your account via FTP with most clients using the following to connect:
   Host/Address: domain.com
   Username: cPanelusername
   Password: cPanelpassword
   
2. Highlight the file tableau.tar.gz on your system where you saved it and right click.
3. Select upload (it needs to be uploaded to your main directory not inside public_html folder, so you should be at the level where you see public_html listed as a folder)
4. Wait for the file to complete uploading.
5. You can view an image of what Filezilla FTP client would look like for this process at this location.

E. Extracting Tableau:

1. Log into cPanel if you aren't already logged into it.
2. Click on "File Manager" icon if you aren't already in there:

3. A new window will open for File Manager, then click on the tableau.tar.gz file name (not the icon):


4. In the upper right hand corner, there are a list of links. Select "Extract File Contents" link in that list:


5. A new window will open with the extracted files and folders listed as the extraction processes. Wait until this finishes (will say Done at the bottom left of most browsers once completed), then close the new window.
6. In the File Manager window, refresh your browser. You should now see a folder called tableau there:

F. Changing the database.yml file for your database details:

1. In File Manager, click on the folder icon to the left of the tableau folder:


2. Click on the folder icon to the left of the config folder:


3. Click on the database.yml file name (not the icon):


4. In the upper right hand corner, click on "Edit File" link as shown below.


5. A new window will open with the following in it:
   # 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


6. Replace cPaneluser with your cpanel username (there are 4 instances of this on lines 4, 5, 11 and 12). Do not remove the _tab part. For example, I would replace cPaneluser_tab with rubyasyl_tab for my rubyasylum.com account.
7. In the password: line (lines 6 and 13), input the password you used when creating your database user earlier.
8. Click the "Save" button, then close that window (keep the File Manager Window open though).