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`