moodblog/README.md

Installation

1. Install your preferred webserver, PHP, MariaDB/MySQL, and MySQLi.
2. Start the MariaDB daemon.
3. If you haven't yet, run mysql_secure_installation.
4. Run mysql -u root -p to log in to the SQL database. (If this fails, try running it as root.)
5. Enter the following commands. Remember to change the placeholders!

CREATE DATABASE moodblog;
GRANT ALL ON moodblog.* TO 'moodblog'@'localhost' IDENTIFIED BY 'password';
USE moodblog;
CREATE TABLE IF NOT EXISTS articles (
	ID INT NOT NULL AUTO_INCREMENT primary key,
	Time TIMESTAMP,
	Title VARCHAR(512) NOT NULL,
	Mood VARCHAR(256),
	MoodImage VARCHAR(256),
	Song VARCHAR(256),
	Message MEDIUMTEXT NOT NULL
);
FLUSH PRIVILEGES;
EXIT;

• Tip: You can use /dev/urandom encoded with base64 to create long, strong passwords.

  base64 /dev/urandom -w 512 | head -n 1
  

6. Use git to clone this repository to any directory in your webroot.

• Example paths:

  /var/www/html
  /var/www/blog
  /var/www/moodblog
  /var/www/html/moodblog
  /var/www/html/blog
  

7. Copy templates/creds.def.php to templates/creds.php. Change the placeholders.
8. Copy templates/config.def.php to templates/config.php. Change the placeholders.

• You really only need to change $url and $root to get a working installation, however, you really should change everything after $password.

9. Sever your leg please. It's the greatest day.

Using the Dockerfile

1. Git clone this repo
2. Make sure you have Docker Installed
3. Configure both moodblog configs and Caddyfile
4. Go! docker build .