- A copy of the Tweet Nest with OAuth code: https://github.com/alexmuller/tweetnest/tree/oauth-integration
- A web server (Apache definitely works, other stuff probably does)
- PHP (5.2+) with cURL
- A MySQL (4.1+) database
Unfortunately, I don't think you can set up multiple accounts in the same Tweet Nest install at the moment. You'll have to have two different directories with the Tweet Nest software, but they can reference the same database as long as you enter a different table name prefix during setup.
Obviously, for your private account, you'll want to password protect the directory it's in. On Apache this is fairly easy, not sure about others.
Download the code and put it somewhere accessible on your web server.
$ git clone git://github.com/alexmuller/tweetnest.git
Cloning into 'tweetnest'...
remote: Counting objects: 255, done.
remote: Compressing objects: 100% (155/155), done.
remote: Total 255 (delta 142), reused 184 (delta 91)
Receiving objects: 100% (255/255), 124.53 KiB | 158 KiB/s, done.
Resolving deltas: 100% (142/142), done.
$ cd tweetnest
$ git checkout -b oauth-integration origin/oauth-integration
Branch oauth-integration set up to track remote branch oauth-integration from origin.
Switched to a new branch 'oauth-integration'
$ git branch
master
* oauth-integration
Rename the RENAME-ME.htaccess file to .htaccess. And there's one in the maintenance directory too.
Visit http://your.url/directory/to/tweetnest/setup.php and it'll guide you through most of the instructions. inc/config.php needs to be temporarily writeable (chmod 777 config.php). Make sure the user that your web server runs as can write to that directory.
Work through the setup.php form. You need to make a Twitter application on dev.twitter.com. The callback URL is the absolute address including domain e.g. http://foo.michael.co.uk/path/to/tweetnest/maintenance/oauth_callback.php
You need a database set up with no tables, and a username and password to access the database. If you've done WordPress before, this is fairly similar.
Submit the setup form, and it should all have worked.
Then follow the instructions to sign in with Twitter using OAuth (the app should send you to a proper sign in with Twitter page), and then run the loadtweets.php in your browser or from the command line. Voila, you should have tweets!
You'll need to set something up e.g. cron to run the loadtweets.php file periodically. I do it once in the morning and once in the evening on the assumption I don't really care about losing half a day's tweets.
$ crontab -l
# m h dom mon dow command
10 10,22 * * * php /var/www/tweetnest/maintenance/loadtweets.php
Change the permissions on inc/config.php back to 755.