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:

  1. Log into cPanel and click on MySQL Databases icon:
    2. MySQL Databases
  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. Curent Databases
  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. Curent Users
  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.
    5. Add Users to Your Databases

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!

Posted in  | 49 comments | 20 trackbacks

Comments

Leave a response

  1. Dell Inspiron 2600 Adapter said 1410 days later:
    Thanks. Your articles were very helpful, especially the next one.
  2. mbt shoes said 1418 days later:
    Thank you for posting such a useful website. Your weblog happens to be not just informative but also very stimulating too. There are a limited number of people who are capable of write technical articles that creatively.
  3. t3 hair dryers said 1418 days later:
    There are a limited number of people who are capable of write technical articles that creatively.
  4. t3 hair dryers said 1418 days later:
    Thank you for posting such a useful website. Your weblog happens to be not just informative but also very stimulating too. There are a limited number of people who are capable of write technical articles that creatively.
  5. mbt shoes said 1418 days later:
    There are a limited number of people who are capable of write technical articles that creatively.
  6. chi flat irons said 1418 days later:
    Thank you for posting such a useful website. Your weblog happens to be not just informative but also very stimulating too.
  7. discount chi flat irons said 1418 days later:
    Your weblog happens to be not just informative but also very stimulating too. There are a limited number of people who are capable of write technical articles that creatively.
  8. christian louboutin shoes said 1418 days later:
    Thank you for posting such a useful website.
  9. discount ugg boots said 1418 days later:
    Your weblog happens to be not just informative but also very stimulating too.
  10. fashion life said 1418 days later:
    Thank you for posting such a useful website. Your weblog happens to be not just informative but also very stimulating too. There are a limited number of people who are capable of write technical articles that creatively.
  11. christian louboutin shoes said 1418 days later:
    Thank you for posting such a useful website. Your weblog happens to be not just informative but also very stimulating too. There are a limited number of people who are capable of write technical articles that creatively.
  12. t3 hair dryers said 1418 days later:
    Thank you for posting such a useful website. Your weblog happens to be not just informative but also very stimulating too. There are a limited number of people who are capable of write technical articles that creatively.
  13. discount ugg boots said 1418 days later:
    Thank you for posting such a useful website. Your weblog happens to be not just informative but also very stimulating too. There are a limited number of people who are capable of write technical articles that creatively.
  14. stock market today said 1463 days later:
    this information was nice one! and very helpful!
  15. air jordan shoes said 1464 days later:
    this information was nice one! and very helpful!
  16. moncler jackets said 1480 days later:
    Its amazing, looking at the time and effort you put into your blog and detailed information you provide. I'll bookmark your blog and visit it weekly for your new posts
  17. Louis Vuitton Outlet said 1485 days later:
    In our website, you can choose your dream wedding dress and accessories.Eternal love starts from here!
  18. Coach outlet said 1487 days later:
    you can choose your dream wedding dress and accessories.Eternal love starts from here!
  19. louis vuitton bags said 1487 days later:
    Thank you for posting such a useful website. Your weblog happens to be not just informative but also very stimulating too. There are a limited number of people who are capable of write technical articles that creatively.
  20. Chanel 2.55 handbags said 1487 days later:
    Your weblog happens to be not just informative but also very stimulating too.
  21. Supra Shoes said 1487 days later:
    this information was nice one! and very helpful!
  22. cheap UGG Boots outlet said 1487 days later:
    wedding dress and accessories.Eternal love starts from here!
  23. MBT Sneaker,Anti Shoes said 1487 days later:
    good sport shoes for every body.
  24. MBT Sneaker,Anti Shoes said 1487 days later:
    MBT Sneaker,Anti Shoes
  25. clen tablets said 1487 days later:
    It very useful to me. thank you!
  26. DIOR cosmetic said 1487 days later:
    Your website is so beautiful.
  27. 007dvd said 1487 days later:
    I get it ,thank you!
  28. room online casino said 1488 days later:
    Thanks. You've made the installation process much quicker for me!
  29. replica watches said 1499 days later:
    http://www.rep1ica.com/GoodsBrand/Porsche-Design-58.html http://www.rep1ica.com/GoodsBrand/Rado-59.html http://www.rep1ica.com/GoodsBrand/Richard-Mille-61.html http://www.rep1ica.com/GoodsBrand/Roger-Dubuis-62.html http://www.rep1ica.com/GoodsBrand/Rolex-63.html http://www.rep1ica.com/GoodsBrand/Swiss-Army-64.html http://www.rep1ica.com/GoodsBrand/Tag-Heuer-65.html
  30. cheap nfl jerseys said 1506 days later:
    Perhaps this is one of the most interesting blogs that I have ever seen. Interesting article, Funny comment. Keep it up!
  31. designer purses online said 1508 days later:
    Thank you for sharing
  32. rassiali said 1508 days later:
    It is very useful to me. thank you! http://mickeyli.multiply.com/journal http://airylotus.ning.com/profiles/blog/list?user=1shasfkcua5aw
  33. Buy Tramadol said 1508 days later:
    Great work man, thats very cool
  34. Buy Tramadol said 1508 days later:
    Great work man, thats very cool.
  35. Buy Tramadol said 1508 days later:
    Great work man, thats very cool.
  36. Buy Tramadol said 1508 days later:
    Awesome.
  37. Buy Tramadol said 1508 days later:
    Great
  38. cheap jerseys said 1511 days later:
    Perhaps this is one of the most interesting blogs that I have ever seen. Interesting article, Funny comment. Keep it up!
  39. wholesale new era hats said 1514 days later:
    That was a great piece of information., I enjoyed reading it..,
  40. New Era Hats said 1514 days later:
    Perhaps this is one of the most interesting blogs that I have ever seen. Interesting article, Funny comment. Keep it up!
  41. OEM design crystal said 1515 days later:
    It is very useful to me. thank you!
  42. crystal necklaces said 1515 days later:
    I have get a lot of useful information and fresh knowledge in your website.
  43. Stock Picks said 1522 days later:
    It's very important what you write and you show some of the information relevant that i need. Thanx mate!
  44. unlocked g1 said 1523 days later:
    It is very useful to me. thank you!
  45. wholesale china cell said 1523 days later:
    I really want learn it better.
  46. omega watches said 1523 days later:
    xiaoxiao123 08 20

    Juicy Couture is a fashion rolex watches brand which was founed in 1997 form California,

  47. slots bonus games said 1526 days later:
    Oh, man! You've helped me a lot! Thanks for the help that you've made by this post!
  48. replica watches said 1533 days later:
    This article is really great, strong support Rolex Submariner http://www.topluxwatch.com/
  49. chopard mens watch said 1540 days later:
    Thank you for sharing

Trackbacks

Use the following link to trackback from your own site:
http://rubyasylum.com/articles/trackback/15

RSS feed for this post trackback uri

(leave url/email »)

   Preview comment