View on Evernote.com

My quick note on setting up my personnel Ubuntu Server nodes. I update this as I ran up with issues setting up any components.

MySQL

Install packages

sudo apt-get install mysql-server mysql-client libmysql-java tomcat7
Access mysql console
mysql -u root password root
Granting privileges to users
grant all privileges on [database].* to [user]@localhost identified by "[password]"; flush privileges;
This is how I create my "Super User" privileges (although I would normally specify a host).
 GRANT ALL PRIVILEGES ON mydb. TO 'myuser'@'%' WITH GRANT OPTION;
nginx

Install packages

service nginx start | stop | restart
Setting as reverse proxy

location /sc2/ {
  proxyhttpversion 1.1;
  proxysetheader Upgrade $httpupgrade;
  proxysetheader Connection "upgrade";
  proxysetheader Host $host;
}
http://blog.ejci.net/2013/05/25/node-js-development-stack-on-amazon-ec2/

Config directory     -     /etc/nginx
Static resources     -    /usr/share/nginx/html

Tomcat

Directories & Files     -
     /var/lib/tomcat7/webapps
     /usr/share/tomcat7/llib
     /var/log/tomcat7/catalina.out

http://www.unixmen.com/install-apache-ant-maven-tomcat-centos-76-5/

Rabbit MQ

Install -

echo "deb http://www.rabbitmq.com/debian/ testing main"  | sudo tee  /etc/apt/sources.list.d/rabbitmq.list > /dev/null
sudo wget http://www.rabbitmq.com/rabbitmq-signing-key-public.asc
sudo apt-key add rabbitmq-signing-key-public.asc
sudo apt-get update
sudo apt-get install rabbitmq-server -y
sudo service rabbitmq-server start
sudo rabbitmq-plugins enable rabbitmqmanagement
sudo service rabbitmq-server restart
Default username / password will be guest / guest and port will be 15672. Use rabbitmqctl to change the username and password or add new user.
sudo rabbitmqctl adduser username passwordforthisuser
sudo rabbitmqctl setusertags username administrator
sudo rabbitmqctl setpermissions -p / user_name "." "." ".”
Delete guest user 
sudo rabbitmqctl deleteuser guest
Resources 

http://www.ekito.fr/people/mqtt-benchmarks-rabbitmq-activemq/
http://stackoverflow.com/questions/8808909/simple-way-to-install-rabbitmq-in-ubuntu

Plex

Download and install - https://plex.tv/downloads

sudo dpkg -i plexmediaserver0.9.8.18.290-11b7fddamd64.deb 


URL's


http://madhu.noip.me:32400/library/parts/983/file.mp4?X-Plex-Token=RmhrpmociZKsCY2bc4ZW

http://192.168.0.112:32400/library/sections/2/all

https://my.plexapp.com/pms/system/library/sections?X-Plex-Token=L8unPjK1n3Rpy55Fm4mA

old---
http://madhu.noip.me:32400/library/parts/2329/file.mp4?X-Plex-Token=ynxnRy9Ked6h6yeLeBJY

LuksOpen

 sudo cryptsetup luksOpen /media/downloads/backup  vol
 sudo mount /dev/mapper/vol /data

Backup config files using ETC Keeper

git@github.com:dhval/etc-keeper.git

http://askubuntu.com/questions/9135/how-to-backup-settings-and-list-of-installed-packages
http://duncanlock.net/blog/2013/08/27/comprehensive-linux-backups-with-etckeeper-backupninja/
https://help.ubuntu.com/lts/serverguide/etckeeper.html
https://coderwall.com/p/v1agsg/installing-etckeeper-to-store-config-with-autopush-to-git-in-ubuntu-14-04-lts

Dropbox

http://www.dropboxwiki.com/tips-and-tricks/install-dropbox-centos-gui-required

SQL Scripts

$ mysql -u root -p

mysql> create database emotherearth;
mysql> use mydatabase;
mysql> show tables;

create user 'dbo@localhost' IDENTIFIED BY ’secret'

CREATE TABLE motherearth.users (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  name VARCHAR(120),
  login VARCHAR(75) NOT NULL,
  password VARCHAR(75) NOT NULL
 );


insert into users (name,login,password) VALUES ("dhval", "admin", "hello");