Friday, August 16, 2013

Ubuntu ShowSlow setup

Show Slow is an excellent website that you can use to track your website's performance metrics over time.  You can have your stats sent to the publicly available www.showslow.com website or install your instance so your metrics are kept private.  The installation and configuration guide is here but it's lacking some of the details for Ubuntu.  So here's a step by step way to setup Show Slow on Ubuntu 13.04.

  1. sudo apt-get install apache2                #installs the apache webserver
  2. sudo apt-get install php5                     #installs php5
  3. sudo apt-get install php5-mysql           #installs php's mysql support
  4. sudo apt-get install php5-mcrypt         #installs php encryption support
  5. sudo apt-get install curl php5-curl       #installs curl & php curl support
  6. sudo apt-get install mysql-server         #insalls mysql
  7. mysql -u root -p  #fill in your password
    1. GRANT USAGE ON *.* TO 'showslowuser'@'%' IDENTIFIED BY PASSWORD '-- Your Password Here!--';
    2. GRANT ALL PRIVILEGES ON `showslow`.* TO 'showslowuser'@'%';
    3. exit
  8. cd /var/www
  9. sudo wget http://www.showslow.org/downloads/showslow_1.2.tar.bz2 #download Show Slow
  10. sudo tar xvfj showslow_1.2.tar.bz2     #uncompress Show Slow
  11. cd showslow_1.2
  12. sudo cp config.sample.php config.php
  13. sudo vi config.php
    1. set your timezone as one of the IANA timezones
    2. set your db connection information to the showslowuser from #7
  14. make
  15. /etc/init.d/apache2 restart
Your private instance of Show Slow should be available now at http://localhost/showslow_1.2.  To configure Firefox to send data to your instance of Show Slow follow the guide at http://localhost/showslow_1.2/configure.php.

No comments: