View source for Tutorial: Setting Up DigitalOcean

Hello! This is [https://wychwit.ch/ wych(witch)]’s tutorial on how to get lorekeeper running on your digitalocean droplet!

===Please do not follow this guide yet. It is in the process of being rewritten!===

First, special thanks to Cy for creating lorekeeper in the first place, and special thanks to Juni for writing their own visual guide for dreamhost here. 

Warning: This is just how I personally set up lorekeeper, and as such, I decided to forgo local-side testing. If you want to do this yourself, follow the instructions on the wiki! They’ll work regardless of your server’s config.

'''Also, to make this guide easier to read, go to View -> Print Layout and uncheck it!''' 

Please check the changelog to see the last time this guide was updated! If you’re reading this significantly after this date and run into problems, there’s a good chance it is out of date! Please go to the lorekeeper wiki here for more up-to-date information.

Also, once you’re done reading through this guide I Highly recommend you look at the troubleshooting section! It will help prepare you for any errors you might encounter during or even post-installation.

'''Programs you need to have installed on your local (windows) computer:'''

   [https://www.chiark.greenend.org.uk/~sgtatham/putty/ Putty]

   [https://filezilla-project.org/ FileZilla]

   [https://www.sourcetreeapp.com/ Sourcetree]

[https://code.visualstudio.com/ Visual Studio Code] (or really, any text-editor better than default notepad)

'''If you are uncomfortable with setting up git, hold off on installing sourcetree until the section on it farther down.'''

Text in a dark blue background like the following
{| class="wikitable"
|- style="background-color:#282A36; color:#F8F8F2"
|$ List

$ Of

$ Commands
|}
Are commands you need to run one at a time, hitting enter each time. However '''Do not type the $ symbol''', that’s just there to show you the beginning of the command when there are several in one block! Everything after the '''$''' must be entered as one long string

Meanwhile text like this:
{| class="wikitable"
|Output text that is

Very

Very

helpful
|}
Is command-line output provided as an example. 

Finally text like this:
{| class="wikitable"
|This is a 

File you need to

Copy and paste
|}
Is a file you’ll need to copy and paste as specified!

Also, whenever I type something in green like '''this''' it is recommended to save the info I’m referring somewhere like in a .txt file that you can easily access!

Also, one last word of warning, once you’re done with this guide '''Do Not edit or upload files directly on the server through filezilla''', it will get your git repository out of wack and you won’t be able to push updates or install extensions to it. '''If you want to make changes, please make them locally and push through git!'''

If you don’t understand what that means just yet, don’t worry! Once you’re done with this tutorial you’ll get it!

With the basics all out of the way, let’s begin!

Change-log:

   May 11 2020 - First written!

   May 12 2020 - minor typos corrected

   May 13 2020 - Provided section on how to fix a phpmyadmin bug!

   May 29th 2020 - Fixed git stash error, and added some resources to learn git!

   July 25th 2020 - added section on how to install extensions, including how to backup your database just to be safe!

   August 14th 2020 - further clarified which programs need to be installed where

   August 21st 2020 - added warning about editing files through filezilla

   September 1st 2020 - Added section on cronjobs

   November 30th 2020 - added note about sourcetree error  
<br />

=Digitalocean Setup=
Select debian 9, and make sure to choose standard and the 5 dollar a month plan!

Select the one-time password option (even if it says its less secure) 

Choose a name! Preferably your site’s name, but it doesn’t have to be!

I also recommend enabling backups, just in case anything goes wrong!

Wait for the site to get the droplet up and running! It will take under a minute

Now, go to email and get the root password that was emailed to you.

Return to digital ocean, click on your droplet, and hit console


(Ignore the text after login: ) type root and Copy and paste (with ctrl-V) your password!

When it says Changing Password for root you need to paste it one more time, then input your '''NEW password!''' Please save this somewhere safe, like on a text file on your computer.

After you’re signed into root, you need to now make a new normal user! Enter the following commands,  but change <username> to an actual username
{| class="wikitable"
|$ adduser <username>

$ usermod -aG sudo <username>
|}
Be sure to save this '''password''' too!

Once this is done, you need to update your server so you can install new software! Run the following command:
{| class="wikitable"
|$ apt-get update
|}
Then run the following to install a program called ssh, so we can use a much better program to control your server with.
{| class="wikitable"
|$ apt-get install ssh
|}


You might need to edit this file to allow ssh connections:

* <code>sudo nano /etc/ssh/sshd_config</code> 

sudo systemctl restart ssh

Note to self wych: edit this and make sure its needed (PasswordAuthentication to yes, and uncomment the passwordkey thing)

chmod 644 /etc/resolv.conf


With this, close out the console window! Now you need to install a new program called putty if you haven’t already on your local computer.

=SSH, Putty, and keys=
Download it, install it, and once you launch it you should see something like this.

Go back to digitalocean and find your ip either here:

Or here:

And '''save it!''' You’ll be using it a lot, so keep it somewhere safe.

Copy that ip into the hostname box (1), name your settings (2) and hit save (3)! After that, hit open (4)!

Remember, the username is CASE SENSITIVE mine here is incorrect (i had to fix it later)

You will get this alert, this is totally fine. Hit Yes.

Now type in your password!

Now you are logged in! Now that we have verified that SSH is working, we now need to setup some ssh keys for use with git and putty! An ssh key is a file that allows you to connect to your server without having to type in your password every time. 

Go to the folder where you installed putty, or search “puttygen” in your windows search bar and open the program.

Hit generate, and move your mouse around in the indicated area as instructed!

You’ll now get something like this:

Save both the public key(1) and the private key(2) somewhere safe and easily locatable! Be sure to make it clear in the file names which is public and which is private (we will be using them both!)

You’ll get a message like this, hit yes! 

Once you’ve saved them both, close out puttygen

Now it's time to use FileZilla! Install it if you haven’t already onto your local computer, and open it up.


Fill out your ip address, username, and password! Also make sure you type 22 in the port box! 

Also, make sure that you navigate to the folder with your ssh keys! On the left-side!

Once you’ve done these both, hit quickconnect!

Drag and drop the public key into the server!

After it is transferred, go back to your putty window and run the following commands. Remember to replace sitepublickey with what you named your public key!!

'''Important note:''' When you want to paste something in putty, you just need to right click the window. I know it's weird, but bear with it! (btw, copying something from putty is automatically done when you select text too! It’s weird but you’ll get used to it)
{| class="wikitable"
|$ cd ~

$ mkdir .ssh

$ chmod 700 .ssh

$ ssh-keygen -i -f sitepublickey>> ~/.ssh/authorized_keys

$ chmod 600 ~/.ssh/authorized_keys

$ rm sitepublickey
|}
Close out your putty window and open putty again

Select the profile you saved before (1) and hit load (2)

On the lefthand side, select the ssh button (1), then Auth(2), and browse to select your private sshkey! (3)

Select session (1), hit save to save (2) your private key settings! Then hit open! (3)

It should sign you in without using your password! Next we need to setup git!

=Git Setup=
First install sourcetree if you haven’t already

Keep these default settings! You’ll have to make a bitbucket account but dont worry, it’s free!

Now once you got it installed, hit clone.

In the source path / url box, put in the lorekeeper’s github url <nowiki>[https://github.com/corowne/lorekeeper]</nowiki> and select an empty directory to host it in! I recommend you name it the your site’s name 

Once you’re done, hit clone!

Next you should see something like this 

If so, you’re done with sourcetree for the moment! Now switch back to putty and input the following commands 

First we need to install git 
{| class="wikitable"
|$ sudo apt-get install git
|}
If this is your first time running sudo you’ll get a message like this. This is totally normal! Just type in your password at the prompt:
{| class="wikitable"
|We trust you have received the usual lecture from the local System

Administrator. It usually boils down to these three things:

   #1) Respect the privacy of others.

   #2) Think before you type.

   #3) With great power comes great responsibility.

[sudo] password for wych:
|}
When it asks you Do you want to continue? [Y/n] type y and hit enter

Now its time to create your site’s directory and get it set up for git! Remember to change site-name to your actual site’s name.
{| class="wikitable"
|$ cd ~

$ mkdir site-name.com

$ cd site-name.com

$ mkdir www

$ cd www

$ git init

$ cd ..

$ mkdir site_hub.git

$ cd site_hub.git

$ git --bare init
|}
Now back in source tree, we need to add your private sshkey

Select this option!

Fill out your name (it doesn't need to be your real one) and your email address (1). Then browse to your private ssh key! (2) after that, hit ok!

Next, close soucetree and open it again (I know, sounds useless but its to apply the settings!)

Next go to settings

Hit add!

Now you need to fill out the connect! Name your remote (1), then in the url / path (2), insert the following

<nowiki>ssh://username@</nowiki><ip address>/~/site-name.com/site_hub.git

Replace username with the username you created, and your ip with your droplet’s ip, then hit ok!

Next, you need to edit the lorekeeper’s profile. Select it (1) and hit edit (2). '''If your sourcetree crashes when clicking edit, you must instead delete the origin remote and add it back again as a non-default remote.''' This is a bug that has not been fixed as of writing.

Now uncheck default remote (1)  rename the origin hose to Lorekeeper (2)! This is so you don't accidentally attempt to push changes to the lorekeeper github.

On the left side you should see this 

If you do, you configured it correctly!

If 

Next hit push, select your server, (1)(2), check (3), and hit push! (4)

You might get a message like this 

It's okay! Hit yes

If it ran successfully, now it’s time to return to putty and run the following commands
{| class="wikitable"
|$ cd ../www

$ git remote add hub ../site_hub.git
|}
Check to make sure it's working by typing git remote show hub and seeing if it matches the following output
{| class="wikitable"
|$ git remote show hub

<nowiki>*</nowiki> remote hub

  Fetch URL: ../site_hub.git

  Push  URL: ../site_hub.git

  HEAD branch: master

  Remote branch:

   master new (next fetch will store in remotes/hub)
|}
Next, you need to run git pull hub master to update the site!
{| class="wikitable"
|remote: Counting objects: 3223, done.

remote: Compressing objects: 100% (956/956), done.

remote: Total 3223 (delta 2168), reused 3223 (delta 2168)

Receiving objects: 100% (3223/3223), 3.31 MiB | 0 bytes/s, done.

Resolving deltas: 100% (2168/2168), done.

From ../site_hub

<nowiki>*</nowiki> branch            master     -> FETCH_HEAD

<nowiki>*</nowiki> [new branch]      master     -> hub/master
|}
Once that’s done, type the command ls and see if there are files in the folder. If so, you did it correctly!

Now we need to set up some files to run git pull hub master automatically for us!
{| class="wikitable"
|$ cd .git/hooks

$ nano post-commit
|}
You should now see the putty window change and look like this

Paste the following text into it (remember, use right click!)
{| class="wikitable"
|#!/bin/sh

echo

echo "**** Pushing changes to Hub [Prime's post-commit hook]"

echo

git push hub
|}
Hit ctrl+X, hit y, then enter

Now type chmod +x post-commit to allow the system to run that file!

Now we need to make one more

Now run these commands! 
{| class="wikitable"
|$ cd ../../../site_hub.git/hooks

$ nano post-update
|}
Now you need to copy and paste the following into it. Remember to change site-name to your actual site’s name
{| class="wikitable"
|#!/bin/sh

echo

echo "**** Pulling changes into Prime [Hub's post-update hook]"

echo

cd $HOME/site-name.com/www||exit

unset GIT_DIR

git pull hub master

exec git-update-server-info
|}
Hit Ctrl + X, y, enter just like before and type chmod +x post-update again just like before!

Now we need to make sure the git is configured correctly!

First, navigate to your local git’s folder, or hit this button in sourcetree to open it for you!

Create a new txt file and name it something you’ll recognize, like GitTest.txt

Go back to sourcetree, and you should see that it’s slightly changed.

Now, select file status (1) and iIn unstaged files should be the file you just created!  Hit Stage All (2), then type in a commit message (3). You can type anything you want here!

After that, hit commit in the bottom right corner

Now go back to history (1) and you should see the new change! Now hit the push button (2)

Again, make sure you’re posting to your site and not the github! (1) and push! (2)

Once you’re done, type the following commands on the server:
{| class="wikitable"
|$ cd ../../www

$ ls
|}
If you see the .txt file in the list of files, it worked! 

=Installing LAMP, and configuring the database=
Next we need to install a few programs onto the server and configure the database!
{| class="wikitable"
|$ sudo apt install apache2 apache2-utils

$ sudo apt install curl

$ sudo apt install mariadb-server mariadb-client

$ sudo apt-get install wget
|}

===Database configuration===
Next,  you need to configure your database! Run this command.
{| class="wikitable"
|$ sudo mysql_secure_installation
|}
You’ll get the following message
{| class="wikitable"
|NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB

      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!

In order to log into MariaDB to secure it, we'll need the current

password for the root user.  If you've just installed MariaDB, and

you haven't set the root password yet, the password will be blank,

so you should just press enter here.

Enter current password for root (enter for none):
|}
Hit enter (since this is your first time using  this)
{| class="wikitable"
|OK, successfully used password, moving on...

Setting the root password ensures that nobody can log into the MariaDB

root user without the proper authorisation.

Set root password? [Y/n]
|}
Set your root password here! Again, '''save this root password''' in your notepad!
{| class="wikitable"
|By default, a MariaDB installation has an anonymous user, allowing anyone

to log into MariaDB without having to have a user account created for

them.  This is intended only for testing, and to make the installation

go a bit smoother.  You should remove them before moving into a

production environment.

Remove anonymous users? [Y/n]
|}
Hit y here!
{| class="wikitable"
|Normally, root should only be allowed to connect from 'localhost'.  This

ensures that someone cannot guess at the root password from the network.

Disallow root login remotely? [Y/n]
|}
Hit Y here too! Despite what it sounds like, you can still log into your database thru ssh (and later phpmyadmin)
{| class="wikitable"
|By default, MariaDB comes with a database named 'test' that anyone can

access.  This is also intended only for testing, and should be removed

before moving into a production environment.

Remove test database and access to it? [Y/n]
|}
Y on  this as well!
{| class="wikitable"
|Reloading the privilege tables will ensure that all changes made so far

will take effect immediately.

Reload privilege tables now? [Y/n]
|}
Hit Y here as well!

===PHP7.2 installation===
Next we need to install php7.2 Run these commands
{| class="wikitable"
|$ sudo apt-get install ca-certificates apt-transport-https
$ wget -q <nowiki>https://packages.sury.org/php/apt.gpg</nowiki> -O- | sudo apt-key add - 

echo "deb <nowiki>https://packages.sury.org/php/</nowiki> stretch main" | sudo tee /etc/apt/sources.list.d/php.list

$ sudo apt-get update
|}
Now paste this long command!
{| class="wikitable"
|$ sudo apt install php7.4 libapache2-mod-php7.4 php7.4-mysql php-common php7.4-cli php7.4-common php7.4-json php7.4-opcache php7.4-readline php7.4-curl php7.4-mbstring php7.4-mysql php7.4-zip php7.4-xml php7.4-gd php-gettext
|}
Now that php is installed, you need to enable it! Type these commands:
{| class="wikitable"
|$ sudo a2enmod php7.4
$ sudo a2enmod rewrite
|}

===Apache Configuration===
Next, open up your apache2’s settings
{| class="wikitable"
|$ sudo nano /etc/apache2/sites-available/000-default.conf
|}
Change 
{| class="wikitable"
|DocumentRoot /var/www/html
|}
to 
{| class="wikitable"
|DocumentRoot /home/username/site-name.com/www/public
|}
Now, run this command to edit another apache2 config!
{| class="wikitable"
|$ sudo nano /etc/apache2/apache2.conf
|}
Use ^W to search for the section you need to replace in nano (type it out, don't paste), which is a text editor within the command-line. The caret symbol (^) represents the CTRL key on your keyboard.

Replace this:
{| class="wikitable"
|'''<Directory />'''

        Options FollowSymLinks

        AllowOverride None

        Require all denied

'''</Directory>'''
|}
With this:
{| class="wikitable"
|'''<Directory />'''

      Options Indexes FollowSymLinks Includes ExecCGI

        AllowOverride All

        Require all granted

'''</Directory>'''
|}
Finally, reload apache2  with this command!
{| class="wikitable"
|sudo systemctl restart apache2
|}
Next we need to install a program called phpmyadmin
{| class="wikitable"
|sudo apt install phpmyadmin
|}
When it runs you'll get a screen like this

Hit space, then enter

You'll get this screen next

Hit enter!!

Then you'll be prompted to choose a password. Type one out and hit enter! (remember to '''save it!''')

Now, see if your phpmyadmin is installed correctly by going to <ip address>/phpmyadmin

You should see this:

Next we need to create a user specifically for PHPmyadmin! Type the following command:
{| class="wikitable"
|sudo mysql -p -u root
|}
You’ll get a new prompt onscreen, now you need to type the following, but remember to replace pmuser and passward_here with a new username and password! Also '''Save both of them'''!
{| class="wikitable"
|CREATE USER 'pmauser'@'localhost' IDENTIFIED BY 'password_here';
|}
Now paste this in there too. Remember, replace pmuser with the same one you just created!
{| class="wikitable"
|GRANT ALL PRIVILEGES ON *.* TO 'pmauser'@'localhost' WITH GRANT OPTION;
|}
Now type quit; to quit the prompt! Now return to the site and type the username you just created for the username, then the password you picked for the password! If you are having problems signing in, go down to troubleshooting for a way to reset your  password.

Once you sign in, click on the '''Databases''' link at the top and you should see a page like this:

Pick a name for the database(1) and hit create!(2)

Now, '''remember to write down the name of your database somewhere ''AND'' the port highlighted here,''' then switch back to putty

Next we should further secure our phpmyadmin page with an additional password! There’s actually a fantastic tutorial on how to do it here: <nowiki>https://www.digitalocean.com/community/tutorials/how-to-install-and-secure-phpmyadmin-on-ubuntu-18-04#step-3-%E2%80%94-securing-your-phpmyadmin-instance</nowiki>

If you choose not to it should still be fine, it’s just something you should keep in mind for security reasons!

One thing I should mention is imo you should choose a different name than the “phusar” you chose before!! The password can be the same though, just '''Make sure to Save This As Well!!'''

Now, restart the apache with this command:
{| class="wikitable"
|sudo service apache2 restart
|}
Now we gotta install a program called composer!  Installing this is a little different than before, but bear with me!

Navigate to your www/ folder
{| class="wikitable"
|cd ~/sitename.com/www
|}
Run the following command under Command-line Installation section of this page:

<nowiki>https://getcomposer.org/download/</nowiki>

Now run these commands to make sure you have enough memory to run it
{| class="wikitable"
|$ sudo /bin/dd if=/dev/zero of=/var/swap.1 bs=1M count=1024

$ sudo /sbin/mkswap /var/swap.1

$ sudo /sbin/swapon /var/swap.1
|}
Next, run this command!
{| class="wikitable"
|php composer.phar install
|}
This will take a while! While it installs we can set up some api keys!

=API keys=

===Deviant Art Setup===
First, go to deviantart’s developer portal

Hit register application

Copy this into notepad or another text editor, make sure there are no line-breaks (they have to be one long line separated only by spaces!) and replace the site-name with your actual site names!
{| class="wikitable"
|<nowiki>https://site-name/</nowiki> <nowiki>http://site-name/</nowiki> <nowiki>https://www.site-name/</nowiki> <nowiki>http://www.site-name/</nowiki> <nowiki>https://site-name</nowiki> <nowiki>http://site-name</nowiki> <nowiki>https://www.site-name</nowiki> <nowiki>http://www.site-name</nowiki>
|}
You’ll get this message, but that’s totally okay!

It will look like this!

Scroll down and select the options like so, and hit save!

You'll now see a page like this

'''Save the secret and id somewhere safe'''! 

===Cloudflare Setup===
Next we need to get our nameservers on cloudflare! Go there, and create a new account!

After you create your account, you need to transfer your nameservers to cloudflare from your domain registrar. Since every domain registrar has different ways of doing this, I can't cover them all here. Instead, after you make your account if you’re having problems following their automated instructions (they should be pretty clear once you enter your domain name!) go here and follow the instructions for your domain registrar if it's listed.

<nowiki>https://support.cloudflare.com/hc/en-us/articles/205195708-Changing-your-domain-nameservers-to-Cloudflare</nowiki>

Once you’re done and your site’s nameservers have been successfully ported over, you’ll see a screen like this:

First turn on development mode(1) while you’re setting up the site, then hit dns! (2)

If this pops up, its okay! Just hit confirm!

You will see something similar to this (I have already filled out some of this for my own projects, don't mind me) On your end, if you aren’t using your registrar's email options or anything, feel free to delete all of these records (except the www CNAME, if it exists)

Fill out the information as follows, and hit save!

Now, let’s go to sendgrid and get the email set up! Don’t close out your cloudflare tab yet though, we’ll be returning here momentarily to add some more domain records

Make a new account, but be sure to select the free option. This should be good enough for smaller sites!

Once you’re done you should get to this page! 

On the left, hit settings(1), and hit Sender Authentication(2)

Select Domain authentication!

Next, select your dns host (that would be cloudflare)

Then be sure to hit Yes on this, that way the emails will correctly say they’re from your site!

Fill out your domain name here and hit Next

You will now see these domain-names that you need to install into cloudflare! I recommend having both sites open in two windows side-by-side so you can easily copy-paste between them.

First, hit copy on the one in the host column.

Then, change type from A to CNAME

Paste what you just copied into the Name box 

Now copy the the address in the value column here

Paste the value to the target box, then hit save!

Now you have it added! Now you need to dp the same for every other item in the hosts and value columns!

Once they’re all added, make sure to click on the Proxied orange clouds, and make them gray and say DNS only!

Now that that’s done, scroll down and hit verify! This may take a few minutes to work, so even if it says an error try again in a few minutes!

Next, hit API keys under settings and hit create new

Hit create and view!

Once your api key is created, '''be sure to save it'''!! It will never be shown to you again. If you lose it somehow, you’ll just have to generate a new apikey!

Once you’re ready, hit done and now we’re ready to return to putty!

=Installing the site=
Next, we need to add a file to the www folder

Let's return to your site’s folder! 

cd ~/site-name/www  

Create a file called .env
{| class="wikitable"
|nano .env
|}
Copy and paste this into the .env file, but be sure to only edit the lines indicated!
{| class="wikitable"
|APP_NAME=site_name_with_no_spaces

APP_ENV=

APP_KEY=

APP_DEBUG=

APP_URL=

CONTACT_ADDRESS=your_contact_address@site-name.com

DEVIANTART_ACCOUNT=your-dA-group-account-username

LOG_CHANNEL=stack

DB_CONNECTION=mysql

DB_HOST=

DB_PORT=

DB_DATABASE=

DB_USERNAME=

DB_PASSWORD=

BROADCAST_DRIVER=log

CACHE_DRIVER=file

QUEUE_CONNECTION=sync

SESSION_DRIVER=file

SESSION_LIFETIME=120

REDIS_HOST=127.0.0.1

REDIS_PASSWORD=null

REDIS_PORT=6379

MAIL_DRIVER=smtp

MAIL_HOST=smtp.sendgrid.net

MAIL_PORT=587

MAIL_USERNAME=apikey

MAIL_PASSWORD=your_sendgrid_api_key

MAIL_FROM_ADDRESS=noreply@site-name.com

MAIL_FROM_NAME=mail_sender_name

AWS_ACCESS_KEY_ID=

AWS_SECRET_ACCESS_KEY=

AWS_DEFAULT_REGION=us-east-1

AWS_BUCKET=

PUSHER_APP_ID=

PUSHER_APP_KEY=

PUSHER_APP_SECRET=

PUSHER_APP_CLUSTER=mt1

MIX_PUSHER_APP_KEY="${PUSHER_APP_KEY}"

MIX_PUSHER_APP_CLUSTER="${PUSHER_APP_CLUSTER}"

DEVIANTART_CLIENT_ID=your_deviantart_client_id

DEVIANTART_CLIENT_SECRET=your_deviantart_secret

DEVIANTART_CALLBACK_URL=/
|<= Replace with your site’s name!

<= Replace with your email

<= replace with your da group username 

<= Put localhost

<= Put the database port you saved earlier

<= Put your database name!

<= Put the database user you created earlier

<= Put your database user’s password!

<= replace with the sendgrid key you saved

<= replace with noreply@<yoursiteurl>

<= replace with whatever you want! They’ll be the one who sent the one who “sent” the email, so if you have a main OC you can put their name here!

<= replace with your DA client ID

<= Replace with your DA Secret!
|}
Hit ctrl+X, y and Enter to save!

Now run the following commands:
{| class="wikitable"
|$ php artisan key:generate

$ php artisan migrate

$ php artisan add-site-settings

$ php artisan add-text-pages

$ php artisan copy-default-images
|}
Now we need to create our admin user with this command!
{| class="wikitable"
|php artisan setup-admin-user
|}
Now you need to change some permissions! 
{| class="wikitable"
|$ sudo chmod 777 -R /home/username/site-name.com/www/

$ sudo chown www-data:www-data /home/username/site-name.com/www/public -R
|}
The 777 permissions are actually a bit ''too'' lenient, so we’re using it to test first!

Now, the moment we’ve been waiting for, go to your site’s url and see if it works! If it does, great! You’re almost done!!!!

Now we need to correct the bad permissions by running this script created by Paws

It needs to be run in the site-name.com folder, so lets cd there (replacing site-name.com with your actual folder’s name)
{| class="wikitable"
|cd ~/site-name.com
|}
Then run the script, and one more command 
{| class="wikitable"
|$  wget <nowiki>https://wychwitch.neocities.org/scripts/fixfolderperms.sh</nowiki> && sudo chmod +x fixfolderperms.sh && sudo sh fixfolderperms.sh
|}
Doublecheck the site to make sure it works with the new permissions!

Next we need to test a few things

Log in with your admin account and password, then click on the little crown by your name

Click on request another email

Now make sure to check your spam folder!! with the two sites I've set up thru this, I have always had the initial email get stuck in spam.

Verify, then log out!

Next you need to create a new user. This can be your main, non-admin account, or it can just be a test account! Either way, sign up as a new user and verify if everything is working correctly on that end.

If that works, then you’re almost done! Now we need to install https!!

Go back to putty (i promise this will be the last time)

Run these commands
{| class="wikitable"
|$ sudo apt-get install certbot python-certbot-apache

$ sudo certbot --apache
|}
Enter your email address, type A to agree, select yes or no to the next prompt (it doesn’t matter what you choose), then finally enter your site name (no www!) 
{| class="wikitable"
|Enter email address (used for urgent renewal and security notices) (Enter 'c' to

cancel): wychwitchcraft@gmail.com

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Please read the Terms of Service at

<nowiki>https://letsencrypt.org/documents/LE-SA-v1.2-November-15-2017.pdf</nowiki>. You must

agree in order to register with the ACME server at

<nowiki>https://acme-v02.api.letsencrypt.org/directory</nowiki>

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

(A)gree/(C)ancel: a

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Would you be willing to share your email address with the Electronic Frontier

Foundation, a founding partner of the Let's Encrypt project and the non-profit

organization that develops Certbot? We'd like to send you email about our work

encrypting the web, EFF news, campaigns, and ways to support digital freedom.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

(Y)es/(N)o: n

No names were found in your configuration files. Please enter in your domain

name(s) (comma and/or space separated)  (Enter 'c' to cancel): wychwitch.monster
|}
After it completes the challenges, type 2 

Next go to cloudflare and change the ssl to Full

Return to your site and make sure it still connects like before.

If it does, great! Now we need to enable automatic renewal with the following command:
{| class="wikitable"
|sudo certbot renew --dry-run
|}
Next, we need to install the auto-scheduler so it will run laravel-related tasks.

Run this command:
{| class="wikitable"
|crontab -e
|}
Then copy and paste this in, changing site-name.com to your domain-name
{| class="wikitable"
|* * * * * cd ~/site-name.com/www && php artisan schedule:run >> /dev/null 2>&1
|}
Save it once you’re done!

If so, you’re finally done!!

But Please continue reading this tutorial for some important tips!

=How to use Git=
If this is your first time using git, it’s important to understand how it works. Here are some great resources

Here’s a pretty easy to understand writeup on how git works! If you’re more of a visual/audio learner, here's a good video too.

This is a great interactive git tutorial. While it focuses on the command line, it’s actually how sourcetree works in the background!! This is the one I recommend for complete beginners since it has a easy to understand example of git branches.

Another interactive tutorial, only this one lets you actually use it with github! I suggest this after you do the above one.

Now that you understand how git generally works, here are a few more examples!

This will be a short example of how to use git to customize your site!!

For some things, making a .css file and uploading through your <nowiki>https://site-name.com/admin/images</nowiki> page is perfectly fine and preferred, but for things that it can't change you’ll have to go into your git files and edit directly! Here’s one example

Open your git directory on your local computer, and go to public\css and open lorekeeper.css in notepad++ and scroll down to line 138
{| class="wikitable"
|.sidebar .sidebar-header {

   background-color: #343a40;

}
|}
Change background color to any color you want! Just make sure it’s a hexcode (im picking #9500ff, obviously)

Save the file and open sourcetree up!

You’ll see uncommitted changes be there yet again, and that’s normal! Hit the commit button in the top left

Just like before, stage the files (1), make a comment(2) and hit commit(3)! Click on history and push the changes to your site’s server!

=Installing Extensions=
A couple users on the discord have worked together to add some extensions to Lorekeeper! One of them has created not only a git for them, but also a helpful wiki with instructions on each one!

First, find the extension you want on the wiki [[:Category:Extensions|here]]. Be sure to keep its instructions open during the installation! 

Next, if you’re adding an extension that makes changes to the database (such as adding new fields to items, prompts, etc) then its best to back up your database!

Log into phpmyadmin and select your database, and hit export as shown here:

If you get a scary warning about errors, hit ignore all

Ignore the template settings, and just select quick, SQL, and hit go

Save the exported database somewhere safe (and be sure to type the date in the filename! It’ll be useful if you need to restore later)

Now that the backups is out of the way, switch to source tree

With your repository open, hit the settings button:

Hit add

Name the remote name whatever you’d like! For the url, you must first click on the github link (using isOnline as an example)

Hit the Code button and hit the copy button

Paste the url you copied into the url field! 

After that hit OK!

Now, hit the fetch button in the top left

Before we do this part, make sure that any uncommitted changes you have are fully committed! If you’re unsure what that means, head back up to the How To Use Git section.

Expand the remotes menu, and right click the extensions remote you added! Next, select “pull from extensions”

At first, it’ll look as though the remote branches box is completely empty. Don't worry! Just click on it and you’ll see the full list of extensions

Select what you want, and hit pull!

I Can’t take screenshots of this next part, so forgive me 

Once it tries pulling, one of two things will happen:

#the merge completed easily, in which case you’re ready to push!
#there were conflicts, in which case we have a couple more steps to take
##In the file status window (that should’ve automatically opened) you’ll see the conflicting files.
##Right click on them, and select “Resolve using theirs”
##Do that for every conflicting file, and once you’re done, you should be ready to commit and push the merge!

After this, you’re nearly done! However, the steps to take after this section changes depending on what extension you’re installing. Go back to the extension page and look at the '''Installation''' section.

Follow it’s instructions! Usually, it just requires going to your www/ folder and running the php artisan migrate command again, but sometimes there’s no further instructions!

Also, check out the '''Configuration''' section, as that also has some important details for finishing up your installation depending on your extension!

Of course, if you run into any problems please stop by the discord and ask for help! Lots of people make use of these extensions so you’ll be able to get the help you need!

=Troubleshooting=
First, here are the locations of error logs that will eventually become useful to know! If you run into an error, especially laravel errors, an important part of troubleshooting (or even getting help) is looking at the error logs! Here are two of the most often access error log directories:

Laravel error logs - www/storage/logs

Apache error logs - /var/log/apache2/

Note you might need to use sudo when opening some of these in nano! Or log into ftp as root if you wanna download and read them in a more comfortable text editor (highly recommended!)

==404  Forbidden Error when visiting the site==
First, make sure you’ve correctly followed the configuration specified here! Remember that the directory needs to be to the correct location in order to work.

If it still doesn’t seem to work, go to your www/public folder and create this file for testing
{| class="wikitable"
|nano phpinfo.php
|}
Then paste this in there.
{| class="wikitable"
|<?php

phpinfo();
|}
Save it, and go to <url>/phpinfo.php

If you see something like this

Then the problem is probably in your /etc/apache2/apache2.conf ! If you don’t get this page, the problem is probably with your document root in the /etc/apache2/sites-available/000-default.conf file!

==Forgot the Your Database Password==
If you forget your database’s password, here are the steps I used to reset it.

First, run the following commands.
{| class="wikitable"
|killall -9 mysqld mysqld_safe

sudo mysqld_safe --skip-grant-tables --skip-networking &

mysql -u root
|}
Then,  run the following, replacing the PASSWORD with an actual password and USERNAME with the username (you can even type root if you forgot the root password!)
{| class="wikitable"
|flush privileges;

update mysql.user set password=password('PASSWORD') where user='USERNAME';

flush privileges;

update mysql.user set plugin='mysql_native_password' where user='USERNAME';

flush privileges;
|}
Then shut down the safe-database and launch it again!
{| class="wikitable"
|killall -9 mysqld mysqld_safe

mysql
|}

==Problems Pushing changes to the server==
If you try to push something, and it doesn’t change on the site, there are several things that could be wrong. But first, it’s good to make sure that development mode is turned on in cloudflare! It makes sure that you always get the latest version of your site, but it turns itself off after only 3 hours. So make sure it’s still on!

If it is on and you’re still not seeing any changes,  the most common issue I’ve found is that you changed something on the site’s www folder directly that is then in conflict with something you’re trying to push! A way to test this is to type the following command in your www folder:
{| class="wikitable"
|git pull hub master
|}
If you get something like this
{| class="wikitable"
|From ../site_hub

<nowiki>*</nowiki> branch            master     -> FETCH_HEAD

Updating e59ceaf..73c71db

error: Your local changes to the following files would be overwritten by merge:

        GitTest.txt

Please commit your changes or stash them before you merge.

Aborting
|}
Then you have a file conflict! If you don’t care about the server-side settings, you have a couple options

1: You can stash the file so you could possibly bring them back (replacing the text that are written <like this>:
{| class="wikitable"
|git stash save <conflicting file(s)>
|}
Then run git pull hub master again and it should work!

2: If you made a mistake and really want to reset to your current computer’s git version, run this command. Warning, this WILL reset EVERYTHING to the current git status, which will delete stuff such as composer.phar, and any other files that haven’t been committed. If you want to see what would be deleted, run git status. This will show you all the modified or untracked that will be deleted. 

If you’re sure about it, run the following command.
{| class="wikitable"
|$ git fetch --all

$ git reset --hard hub/master
|}
Your git should now automatically update as normal!