h1. Creating ToledoWinter.com

Oct 23, 2014

1. Network Solutions
 - Register domain name


2. Digital Ocean
 - DNS
 - Add Domain:
 - - name=toledowinter.com
 - - ipaddress=
 - - Select a Droplet=soupmode.com
 - Create Domain


3. Digital Ocean 
 - DNS
 - toledowinter.com
 - Add Record:
 - - CNAME
 - - Enter Name=WWW
 - - Enter Hostname=@


4. Network Solutions
 - Manage Account
 - toledowinter.com
 - Change Where Domain Points
 - Domain Name Server
 - - NS1.DIGITALOCEAN.COM
 - - NS2.DIGITALOCEAN.COM
 - - NS3.DIGITALOCEAN.COM
 - Apply Changes 
 - It may take 24 to 48 hours for the changes to take affect throughout the Internet


5. Digital Ocean Server
 - remote shell login
 - cd /home
 - mkdir toledowinter
 - cd toledowinter
 - within /home/toledowinter, execute 
 - - git clone https://github.com/jrsawvel/Grebe.git
 - that will create a directory called Grebe, which contains the code
 - @cd /home@ 
 - @chown -R owner:group toledowinter@ with the appropriate "owner" and "group" info


6. MySQL

Change to the directory that contains the database files.  
@cd /home/grebe/Grebe/sql@

This assumes that MySQL is installed.

Create a new database and database user for Grebe. If planning to use an existing database, then skip these steps.

Enter this command to get into the mysql command line interface: (it will ask for the root password)  
@mysql -uroot -p@

At the `mysql>` prompt, enter the following commands, one at a time:  

@create database toledoweatherdb;@

`create user 'toledoweather'@'localhost' identified by 'password_here';`

`grant all privileges on toledoweatherdb.* to 'toledoweather'@'localhost';`

`flush privileges;`

`quit;`

Create the Grebe database tables.

`mysql -utoledoweather -pyourpassword -D toledoweatherdb < grebe-users.sql`

`mysql -utoledoweather -pyourpassword -D toledoweatherdb < grebe-posts.sql`

`mysql -utoledoweather -pyourpassword -D toledoweatherdb < grebe-tags.sql`

`mysql -utoledoweather -pyourpassword -D toledoweatherdb < grebe-sessionids.sql`