# Installing nodejs, nginx, mysql, junco, and ghost on Digital Ocean Droplet Week of November 10, 2013 markdown=yes ## Buying a Domain Name I used networksolutions.com to buy a domain name. ## Web Hosting at Digital Ocean * http://digitalocean.com * create an account * purchase the $5 per month Droplet. * I used Ubuntu Linux. * Digital Ocean will e-mail the username and password for the Linux server. This info is used to log into the server with SSH. * while logged into the web-based Digital Ocean dashboard: * click DNS and add the domain name purchased above. the domain name will be associated with the droplet created, but also need to add the domain name to the DNS setting. * add the Digital Ocean name servers to the Network Solutions account for the domain name. * Linux server * use remote shell/SSH to log into the Digital Ocean server and change the password. * they provide root access to the server. * may need to change config so that root cannot log into the server remotely. create a new user account to login with and then su to root. * it's a clean, simple, bare-bones Linux install. * need to install gcc. * need to install unzip. * need to isntall curl. ## Installing Node.js https://www.digitalocean.com/community/articles/how-to-install-an-upstream-version-of-node-js-on-ubuntu-12-04 sudo apt-get update sudo apt-get install build-essential sudo apt-get install curl echo 'export PATH=$HOME/local/bin:$PATH' >> ~/.bashrc . ~/.bashrc mkdir ~/local mkdir ~/node-latest-install cd ~/node-latest-install curl http ://nodejs.org/dist/node-latest.tar.gz | tar xz --strip-components=1 ./configure --prefix=~/local make install curl https ://npmjs.org/install.sh | sh node -v ## Installing Nginx http://0v.org/installing-ghost-on-ubuntu-nginx-and-mysql sudo apt-get install nginx sudo mkdir /var/cache/nginx sudo chown web-data:web-data /var/cache/nginx sudo mkdir /var/www sudo chown web-data:web-data /var/www vi /etc/nginx/nginx.conf Delete everything and replace it with the text below. code.user web-data; worker_processes 4; pid /run/nginx.pid; events { worker_connections 768; # multi_accept on; } http { proxy_cache_path /var/cache/nginx levels=1:2 keys_zone=one:8m max_size=3000m inactive=600m; proxy_temp_path /var/tmp; include mime.types; default_type application/octet-stream; sendfile on; keepalive_timeout 65; gzip on; gzip_comp_level 6; gzip_vary on; gzip_min_length 1000; gzip_proxied any; gzip_types text/plain text/css application/json application/x-javascript text/xml application/xml application/xml+rss text/javascript; gzip_buffers 16 8k; upstream ghost_upstream { server 127.0.0.1:2368; keepalive 64; } server { listen 80; server_name YOUR_DOMAIN www.YOUR_DOMAIN; if ($host = 'YOUR_DOMAIN' ) { rewrite ^/(.*)$ http://www.YOUR_DOMAIN/$1 permanent; } # location ~ ^/(ghost/signup/) { # rewrite ^/(.*)$ http://YOUR_DOMAIN/ permanent; # } location ~ ^/(img/|css/|lib/|vendor/|fonts/|robots.txt|humans.txt) { root /var/www/core/client/assets; access_log off; expires max; } location ~ ^/(shared/|built/) { root /var/www/core; access_log off; expires max; } location ~ ^/(favicon.ico) { root /var/www/core/shared; access_log off; expires max; } location ~ ^/(content/images/) { root /var/www; access_log off; expires max; } location / { proxy_redirect off; proxy_set_header X-Real-IP $remote_addr; proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for; proxy_set_header X-Forwarded-Proto $scheme; proxy_set_header Host $http_host; proxy_set_header X-NginX-Proxy true; proxy_set_header Connection ""; proxy_http_version 1.1; proxy_cache one; proxy_cache_key ghost$request_uri$scheme; proxy_pass http://ghost_upstream; } } access_log /var/log/nginx/access.log; error_log /var/log/nginx/error.log; include /etc/nginx/conf.d/*.conf; include /etc/nginx/sites-enabled/*; } code.. Now you need to edit the contents and replace everywhere it says YOUR_DOMAIN with your actual domain like example.com. You can now restart nginx: ``` sudo /etc/init.d/nginx restart ``` ### Configuring Nginx https://library.linode.com/web-servers/nginx/configuration/basic ### Sub Domains **13Nov2013** How to add a subdomain? "You can add subdomains as either A or CNAME records. A records you would point them to a specific IP, and with CNAME records you can point them to a canonical name." **I created CNAME records:** * --_enter name:_-- ++ghost++ * --_enter hostname:_-- ++@++ Then from this: https://www.digitalocean.com/community/articles/how-to-set-up-nginx-virtual-hosts-server-blocks-on-ubuntu-12-04-lts--3 **Create the New Virtual Host File** The next step is to create a new file that will contain all of our virtual host information. nginx provides us with a layout for this file in the sites-available directory (/etc/nginx/sites-available), and we simply need to copy the text into a new custom file: ``` sudo cp /etc/nginx/sites-available/default /etc/nginx/sites-available/ghost.soupmode.com ``` Open up the new virtual host file— you will see all the information you need to set up virtual host within. ``` sudo vim /etc/nginx/sites-available/ghost.soupmode.com ``` We need to make a couple of changes in these few lines: server { listen 80; ## listen for ipv4; this line is default and implied # listen [::]:80 default ipv6only=on; ## listen for ipv6 root /home/ghost/default; index index.html index.htm; # Make site accessible from http://localhost/ server_name ghost.soupmode.com; } Uncomment "listen 80" so that all traffic coming in through that port will be directed toward the site Change the root extension to match the directory that we made in Step One. If the document root is incorrect or absent you will not be able to set up the virtual host. Change the server name to your DNS approved domain name or, if you don't have one, you can use your IP address You do not need to make any other changes to this file. Save and Exit. The last step is to activate the host by creating a symbolic link between the sites-available directory and the sites-enabled directory. In apache, the command to accomplish this is "a2ensite." nginx does not have an equivalent shortcut, but it's an easy command nonetheless. ``` sudo ln -s /etc/nginx/sites-available/example.com /etc/nginx/sites-enabled/ghost.soupmode.com ``` To both avoid the "conflicting server name error" and ensure that going to your site displays the correct information, you can delete the default nginx server block: ``` sudo rm /etc/nginx/sites-enabled/default ``` **Step Six—Restart nginx** We’ve made a lot of the changes to the configuration. Restart nginx and make the changes visible. ``` sudo service nginx restart ``` Possibly other helpful pages: * https://www.digitalocean.com/community/articles/how-to-set-up-a-host-name-with-digitalocean * http://blog.martinfjordvald.com/2010/07/nginx-primer/ * https://www.digitalocean.com/community/questions/how-do-i-setup-subdomains-for-my-droplet * https://www.digitalocean.com/community/articles/how-to-set-up-apache-virtual-hosts-on-ubuntu-12-04-lts ## Installing and Configuring Ghost > **Update** currently running Ghost from /home/ghost instead of /var/www. http://0v.org/installing-ghost-on-ubuntu-nginx-and-mysql http://docs.ghost.org/installation/ http://ghosted.co/install-ghost-digitalocean/ download the zipped source code https://ghost.org/download/ copy .zip file to Digital Ocean server install the unzip utility ``` sudo apt-get install unzip ``` unzip the ghost source code ``` unzip ghost-0.3.3.zip ``` In top-level directory where contents were unzipped: npm install --production npm install forever -g vi /var/www/starter.sh Paste in the script below: code.#!/bin/sh if [ $(ps aux | grep node | grep -v grep | wc -l | tr -s "\n") -eq 0 ] then export PATH=/usr/local/bin:$PATH export NODE_ENV=production NODE_ENV=production forever start --sourceDir /var/www index.js >> /var/log/nodelog.txt 2>&1 fi code.. Now enter this command: ``` sudo chmod +x /var/www/starter.sh ``` Next up we want to fix all the permissions: ``` sudo chown -R web-data:web-data /var/www/ ``` Now we need to add a line to your crontab: ``` sudo crontab -e ``` If this is the first time you've used crontab -e then it will ask you which editor to use. I prefer nano for simple edits, but you can choose anything. Place this line at the end of the file and save: ``` @reboot /var/www/starter.sh ``` If not unzipped in /var/www, then: ``` cp config.js /var/www ``` The Ghost config.js file is up next. Open it up to edit: Edit the lines with "url:" right under development and production declarations replacing the default URL with yours: code.development: { // The url to use when providing links to the site, E.g. in RSS and email. url: 'http:// YOUR_DOMAIN', code.. and code.production: { url: 'http:// YOUR_DOMAIN', code.. I did not edit the database section of the config.js file, since I'm using the default sqlite. You are now done. Ghost should be ready to go. Get into the /var/www directory and enter this command: Next command is not working at the moment. Using the commands in the notes section below. ``` sudo ./starter.sh ``` That should start Ghost, nginx was already running, as was mysql. Visit http://YOUR_DOMAIN and you should see the default page. ## Other Ghost Install Links to Read http://ghost.centminmod.com/how-to-install-ghost-blogging-platform/ init.d script to run Ghost under a service account. https://gist.github.com/emiller42/7191554 ## Notes i unzipped the ghost code in /home/ghost. http://0v.org/installing-ghost-on-ubuntu-nginx-and-mysql recommended : q. Download the zip file from your ghost.org account. Get it unzipped and uploaded. Make sure you put the files into /var/www. Now go into /var/www and run these commands: q.. ``` sudo npm install --production sudo npm install mysql sudo npm install forever -g ``` The Ov.org user chose mysql instead of sqlite. Other options for starting and stopping ghost. cd /home/ghost forever start index.js forever stop index.js ## Installing MySQL if want to use a different database. This is another simple one. Run this command: ``` sudo apt-get install mysql-client mysql-server ``` While its running it will ask you to set a root password. Make sure to remember this. Now lets add a couple ghost databases and a user. Enter this command to get into mysql's command line interface: (it will ask for the root password you set earlier) ``` mysql -uroot -p ``` You should see output like this: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1269 Server version: 5.5.32-0ubuntu0.13.04.1 (Ubuntu) Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> At the "mysql>" prompt you need to enter these commands one at a time: (replace YOUR_PASSWORD with a password you will remember) create database ghostdev; create database ghost; create user 'ghost'@'localhost' identified by 'YOUR_PASSWORD'; grant all privileges on ghost.* to 'ghost'@'localhost'; grant all privileges on ghostdev.* to 'ghost'@'localhost'; flush privileges; quit You now have mysql setup with a production and development database. ## Using Ghost http://docs.ghost.org/usage/ The home page and the default test post that came with the Ghost code should display fine. Now it's time to create an account to create new content. Navigate to your new blog in your favourite browser, and then change the URL to http://yourURL/ghost/signup Fill in your Full Name as the name you want to appear as the author of blog posts. Then enter your Email Address - make sure it's valid, and carefully enter a sensible Password (it needs to be at least 8 characters long). Hit the big blue Sign Up button, and you will be logged in to your blog. That's it! You can now start writing blog posts. Message will be displayed: "Ghost is currently unable to send e-mail. See http://docs.ghost.org/mail for instructions" This isn't critical to setting up your blog so you can get started writing, but it is a good idea to mosey on over to the email documentation at some point, and learn about configuring Ghost to send email. This is currently only used to send you a reset email if you forget your password. Not important for blogging, but really useful if you ever need it! http://yourdomain/ghost/signin/ ### Creating a new post Click the "New Post" link in upper left part of site. Ghost uses Markdown. For a new test post, I used the text from this post: http://jothut.com/cgi-bin/junco.pl/blogpost/5118/19Sep2013/Perl-ForecastIO-module-README-for-GitHub The above ForecastIO readme for GitHub was created in Markdown. ## Configuring Ghost http://docs.ghost.org/usage/configuration/ index.js config.js Ghost provides test and production environments. ### Ghost Settings http://docs.ghost.org/usage/settings/ ### Writing Posts http://docs.ghost.org/usage/writing/ h2. Install lighttpd sudo apt-get install lighttpd vim /etc/lighttpd/lighttpd.conf add line: server.port = 8080 service lighttpd start or service lighttpd restart ## Executing Perl on Nginx *14Nov2013* http://nginxlibrary.com/perl-fastcgi/ apt-get install libfcgi-perl code.server { listen 80; server_name example.com www.example.com; root /var/www/example.com; access_log /var/www/logs/example.com.access.log; location / { index index.html index.htm index.pl; } location ~ \.pl|cgi$ { try_files $uri =404; gzip off; fastcgi_pass 127.0.0.1:8999; fastcgi_index index.pl; fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name; include fastcgi_params; } } code.. mkdir /var/www/example.com chown -R www-data:www-data /var/www/example.com wget http://nginxlibrary.com/downloads/perl-fcgi/fastcgi-wrapper -O /usr/bin/fastcgi-wrapper.pl wget http://nginxlibrary.com/downloads/perl-fcgi/perl-fcgi -O /etc/init.d/perl-fcgi chmod +x /usr/bin/fastcgi-wrapper.pl chmod +x /etc/init.d/perl-fcgi update-rc.d perl-fcgi defaults -insserv perl-fcgi- cd /etc/init.d ./perl-fcgi start **[X]** http://serverfault.com/questions/254191/how-to-combine-url-rewriting-and-fastcgi-in-nginx code.location / { root /path.to.app/; index index.php index.html; rewrite ^/(.*)$ /index.php?query=$1 break; fastcgi_pass 127.0.0.1:9000; fastcgi_index index.php; fastcgi_param SCRIPT_FILENAME /path.to.app/$fastcgi_script_name; include fastcgi_params; } code.. http://stackoverflow.com/questions/11771564/nginx-fastcgi-configuration-for-cgiapplication-app http://wiki.nginx.org/HttpFastcgiModule#fastcgi_split_path_info http://flask.pocoo.org/docs/deploying/fastcgi/ https://wiki.debian.org/nginx/FastCGI ## Working Nginx config As of Nov 15, 2013. At the moment, storing all domain info in the main config file, located at /etc/nginx/nginx.conf May split info up later into multiple files to be included in the main config, but only Ghost config info is lengthy. [[soupmode nginx config]] ## Installing Junco downloaded/ftped Junco-15Nov2013.tar.gz to the Digital Ocean Linux server into /home/junco Unzip and untar in one step: ``` tar xvfz Junco-15Nov2013.tar.gz ``` This produces /home/junco/Junco (I need test this by using the nginx config file to use files in the locations after unzipping and untarring, but for now, will manually copy certain files to key locations such as cgi-bin and html root.) ### CGI cp Junco/cgi/junco.pl cgi-bin cd cgi-bin vim junco.pl Change the following line to be: ``` use lib '/home/junco/Junco/lib' ``` Save and exit and the file. chmod 755 junco.pl chown ghost:ghost junco.pl cd .. (I'm still running things as user ghost.) ### CSS and JS Earlier, I created the html docs/root directory called html. Within the /home/junco directory: mkdir html/css mkdir html/javascript mkdir html/javascript/buttons mkdir html/javascript/mousestrap mkdir html/javascript/meanmenu mkdir html/javascript/splitscreen cp Junco/css/* html/css cp -R Junco/javascript/* html/javascript chown -R ghost:ghost html ### MySQL ``` cd Junco/sql ``` Execute based upon the info used when installing the mysql database above: mysql -ujunco -pyourpassword -D junco < junco-content.sql Will receive syntax error about Type=MyISAM. http://stackoverflow.com/questions/12428755/1064-error-in-create-table-type-myisam q. 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line xxx q.. Response in the stack overflow thread: q. Note The older TYPE option was synonymous with ENGINE. TYPE was deprecated in MySQL 4.0 and removed in MySQL 5.5. When upgrading to MySQL 5.5 or later, you must convert existing applications that rely on TYPE to use ENGINE instead. q.. code.CREATE TABLE dave_bannedwords( id INT(11) NOT NULL AUTO_INCREMENT, word VARCHAR(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY id(id) -- this is superfluous in the presence of your PK, ergo unnecessary ) ENGINE = MyISAM ; code.. Edit the .sql files and change ``` TYPE=MyISAM; ``` to ``` ENGINE=MyISAM; ``` Then execute the following: mysql -ujunco -pyourpassword -D junco < junco-content.sql mysql -ujunco -pyourpassword -D junco < junco-users.sql mysql -ujunco -pyourpassword -D junco < junco-tags.sql mysql -ujunco -pyourpassword -D junco < junco-backlinks.sql mysql -ujunco -pyourpassword -D junco < junco-sessionids.sql mysql -ujunco -pyourpassword -D junco < junco-following.sql ### YAML ``` cd /home/junco/Junco/yaml ``` Edit junco.yaml and make appropriate changes. template_home site_name home_page email_host css_dir_url maincss_url database_host database_name database_username database_password #webhosting - #nodejs - #javascript - #ghost - #blogging