ThinkUp captures your posts, replies, retweets, friends, followers, and links on social networks like Twitter and Facebook. We'll be adding more networks in the future. ThinkUp stores your social data in a database you control, and makes it easy to search, sort, filter, export, and visualize in useful ways.ThinkUp requires the LAMP stack, a number of php packages, and sendmail. Installing these individually can be daunting so I wrote a script that takes care of all the prerequisites and installs ThinkUp on an Ubuntu EC2 instance. I commented out the phpmyadmin installation because it isn't necessary, but it is nice to have if you need to make changes to the database.
For testing, I used my Ubuntu 10.10 AMI that complies with AWS free tier requirements: ami-8548bfec. One caveat, I set my ThinkUp account email to gmail which seems to mark the autoregistration notification email as spam, so check your spam folder first.
UPDATE 12/30/10: Canonical released refreshed UEC images for 10.10 (Maverick Meerkat) with 8GB root EBS volumes that will run on the AWS free tier. The list of Amazon published AMIs is available here.
UPDATE 1/5/11: Andy Baio updated the script and wrote a tutorial to perform the whole install in the browser. The tutorial is on the ThinkUp wiki.
# install ThinkUp on EC2 Ubuntu instance: # # @spara 12/23/10 # echo "Installing required packages, follow the prompts" sleep 2 # install required packages sudo apt-get update sudo tasksel install lamp-server sudo apt-get -y install unzip sudo apt-get -y install curl libcurl3 libcurl3-dev php5-curl php5-mcrypt php5-gd --fix-missing sudo apt-get -y install sendmail # restart apache to init php packages sudo service apache2 restart # not necessary but nice to have #sudo apt-get -y install phpmyadmin wget https://github.com/downloads/ginatrapani/ThinkUp/thinkup-0.7.zip --no-check-certificate sudo unzip -d /var/www/ thinkup-0.7.zip # config thinkup installer sudo ln -s /usr/sbin/sendmail /usr/bin/sendmail sudo chown -R www-data /var/www/thinkup/_lib/view/compiled_view/ sudo touch /var/www/thinkup/config.inc.php sudo chown www-data /var/www/thinkup/config.inc.php # create database echo -n "Enter the MySQL admin password: " read -e pword mysqladmin -h localhost -u root -p$pword create thinkup # echo message addy=$(GET http://169.254.169.254/latest/meta-data/public-hostname) echo "Copy the URL below to install and configure Thinkup" echo "http://$addy/thinkup/install/"