Web Server Setup & Applications

MariaDB Installation and Configuration

MariaDB Installation and Configuration

Overview

This page provides step-by-step instructions for installing MariaDB on buzz.deome.net and configuring it to work with applications like BookStack and the photo gallery.

1. Installing MariaDB

  1. Update the System:

    • Ensure all packages are up-to-date. 
      sudo apt update && sudo apt upgrade -y

  2. Install MariaDB Server:

    • Use the following command to install MariaDB: 
      sudo apt install mariadb-server -y

  3. Start and Enable MariaDB:

    • Start the MariaDB service and enable it to start on boot: 
      sudo systemctl start mariadb
sudo systemctl enable mariadb

  4. Verify Installation:

    • Check the MariaDB version to confirm it is installed: 
      mysql --version
    • You should see output confirming the MariaDB version, as shown in your initial check.

2. Initial MariaDB Configuration

  1. Run the Security Script:

    • MariaDB provides a security script to help you configure common security settings. 
      sudo mysql_secure_installation
    • This script will prompt you to:
      • Set a root password.
      • Remove anonymous users.
      • Disallow remote root login.
      • Remove test databases.
    • Answer each prompt as needed to secure the installation.

  2. Log in as the Root User:

    • After configuring security, log in to MariaDB: 
      sudo mysql -u root -p

  3. Create a New Database and User for Each Application:

    • Database for BookStack: 
      CREATE DATABASE bookstackdb;
CREATE USER 'bookstackuser'@'localhost' IDENTIFIED BY 'your_password';
GRANT ALL PRIVILEGES ON bookstackdb.* TO 'bookstackuser'@'localhost';
FLUSH PRIVILEGES;
    • Database for Photo Gallery: 
      CREATE DATABASE gallerydb;
CREATE USER 'galleryuser'@'localhost' IDENTIFIED BY 'your_password';
GRANT ALL PRIVILEGES ON gallerydb.* TO 'galleryuser'@'localhost';
FLUSH PRIVILEGES;
    • Replace your_password with secure passwords.

  4. Exit MariaDB:

    • Once databases and users are set up, exit MariaDB: 
      EXIT;

3. Basic MariaDB Configuration Options

  1. Optimize Settings (Optional):

    • Open the MariaDB configuration file: 
      sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf
    • Modify settings under [mysqld] as needed. Example optimizations: 
      max_connections = 100
innodb_buffer_pool_size = 256M
    • Save and close the file.

  2. Restart MariaDB:

    • Apply changes by restarting the MariaDB service: 
      sudo systemctl restart mariadb

4. Testing and Verification

  1. Verify Databases and Users:

    • Log in as root and list the databases to confirm they were created: 
      sudo mysql -u root -p
SHOW DATABASES;

  2. Connect Using Each Application’s Credentials:

    • Use the created usernames and passwords to confirm access for BookStack and the gallery: 
      mysql -u bookstackuser -p
mysql -u galleryuser -p

  3. Connection from Applications:

    • Ensure that BookStack and the photo gallery application can connect to MariaDB using the specified database names and credentials.

5. Maintenance and Backup

  1. Automate Backups:

    • Create a cron job to back up each database: 
      mysqldump -u root -p bookstackdb > /path/to/backup/bookstackdb.sql
mysqldump -u root -p gallerydb > /path/to/backup/gallerydb.sql

  2. Update MariaDB:

    • Periodically check for updates to keep MariaDB secure and optimized: 
      sudo apt update && sudo apt upgrade mariadb-server

Apache Web Server Installation and Configuration

Apache Web Server Installation and Configuration

Overview

This page provides instructions for setting up and configuring Apache on buzz.deome.net. It includes steps for installing Apache, configuring virtual hosts for multiple sites, securing with SSL certificates, and basic performance tuning.

1. Apache Installation

  1. Update System Packages:

    • Start by updating the package list and upgrading existing packages: 
      sudo apt update && sudo apt upgrade -y

  2. Install Apache:

    • Install Apache with the following command: 
      sudo apt install apache2 -y

  3. Start and Enable Apache:

    • Start the Apache service and enable it to run on boot: 
      sudo systemctl start apache2
sudo systemctl enable apache2

  4. Verify Installation:

    • Check the Apache status to ensure it’s running: 
      sudo systemctl status apache2

2. Basic Apache Configuration

  1. Main Configuration File:

    • The main Apache configuration file is located at: 
      /etc/apache2/apache2.conf

  2. Enable Recommended Modules:

    • Enable commonly used modules: 
      sudo a2enmod rewrite ssl headers
    • Restart Apache to apply the changes: 
      sudo systemctl restart apache2

3. Setting Up Virtual Hosts

  1. Create a New Virtual Host:

    • For each site, create a configuration file in /etc/apache2/sites-available/. For example, for wiki.deome.net: 
      sudo nano /etc/apache2/sites-available/wiki.deome.net.conf
    • Add the following configuration: 
      <VirtualHost *:80>
  ServerName wiki.deome.net
  DocumentRoot /var/www/wiki
  <Directory /var/www/wiki>
      AllowOverride All
  </Directory>
  ErrorLog ${APACHE_LOG_DIR}/wiki_error.log
  CustomLog ${APACHE_LOG_DIR}/wiki_access.log combined
</VirtualHost>

  2. Enable the Virtual Host:

    • Use a2ensite to enable each virtual host: 
      sudo a2ensite wiki.deome.net.conf
    • Reload Apache to apply changes: 
      sudo systemctl reload apache2

  3. Repeat for Additional Sites:

    • Create similar configuration files for gallery.deome.net, buzz.deome.net, and any other sites you plan to host.

4. SSL Configuration with Let’s Encrypt

  1. Install Certbot:

    • Install Certbot to automate SSL certificate generation: 
      sudo apt install certbot python3-certbot-apache -y

  2. Generate SSL Certificates:

    • Use Certbot to obtain SSL certificates for each virtual host: 
      sudo certbot --apache -d wiki.deome.net
sudo certbot --apache -d gallery.deome.net
    • Certbot will automatically configure SSL for the specified domains.

  3. Set Up Auto-Renewal:

    • To ensure certificates renew automatically: 
      sudo certbot renew --dry-run

5. Performance and Optimization

  1. Adjust Apache Settings:

    • Open the main Apache configuration file: 
      sudo nano /etc/apache2/apache2.conf
    • Consider modifying these settings under the mpm_prefork_module or mpm_worker_module: 
      KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 5

  2. Enable Caching:

    • Install and enable Apache caching modules if desired: 
      sudo a2enmod cache
sudo a2enmod cache_disk
sudo systemctl restart apache2

  3. Optimize Logging:

    • Adjust log levels or configure centralized logging if needed. Logging configuration is in each virtual host file and /etc/apache2/apache2.conf.

6. Maintenance and Monitoring

  1. Monitor Apache Status:

    • Check Apache’s status periodically: 
      sudo systemctl status apache2

  2. Check Logs:

    • Access logs for each virtual host in /var/log/apache2/, e.g.: 
      sudo tail -f /var/log/apache2/wiki_access.log
sudo tail -f /var/log/apache2/wiki_error.log

  3. Restarting Apache:

    • Restart Apache after any configuration changes: 
      sudo systemctl restart apache2

This wiki page provides a thorough guide for Apache installation, virtual host setup, SSL configuration, and performance tuning. Let me know if you’d like any additional details or further customization for your setup!

BookStack Installation and Configuration on wiki.deome.net

Overview

This page provides a complete guide to setting up BookStack on wiki.deome.net, including installation, configuration, database setup, and SSL configuration with Let’s Encrypt.

1. Prerequisites

  1. Web Server: Apache (refer to the Apache wiki page for installation).
  2. Database: MariaDB (refer to the MariaDB wiki page for installation and configuration).
  3. PHP: BookStack requires PHP 7.3 or higher. Install necessary PHP modules. 
    sudo apt install php php-mysql php-xml php-mbstring php-zip php-gd -y

2. Download and Install BookStack

  1. Create the Document Root Directory:

    • Create a directory for BookStack: 
      sudo mkdir -p /var/www/wiki

  2. Download BookStack:

    • Navigate to the web root and download the latest version: 
      cd /var/www/wiki
sudo git clone https://github.com/BookStackApp/BookStack.git ./
sudo git checkout release

  3. Set File Permissions:

    • Ensure Apache can read/write to the BookStack files: 
      sudo chown -R www-data:www-data /var/www/wiki
sudo chmod -R 755 /var/www/wiki

3. Configure the Database

  1. Log in to MariaDB:

    sudo mysql -u root -p

  2. Create Database and User:

    • Create a database for BookStack: 
      CREATE DATABASE bookstackdb;
CREATE USER 'bookstackuser'@'localhost' IDENTIFIED BY 'your_password';
GRANT ALL PRIVILEGES ON bookstackdb.* TO 'bookstackuser'@'localhost';
FLUSH PRIVILEGES;
EXIT;

4. Configure Environment Variables

  1. Copy the Environment File:

    • BookStack uses an .env file for configuration. Copy the example: 
      sudo cp .env.example .env

  2. Edit the .env File:

    • Open the .env file to configure your database and site settings: 
      sudo nano .env
    • Update the following lines: 
      # Database configuration
DB_HOST=localhost
DB_DATABASE=bookstackdb
DB_USERNAME=bookstackuser
DB_PASSWORD=your_password

# Application URL
APP_URL=https://wiki.deome.net

  3. Save and Close: Press Ctrl + X, then Y, and Enter to save changes.

5. Set Up Apache Virtual Host for wiki.deome.net

  1. Create the Virtual Host File:

    sudo nano /etc/apache2/sites-available/wiki.deome.net.conf

  2. Configure the Virtual Host:

    • Add the following configuration: 
      <VirtualHost *:80>
  ServerName wiki.deome.net
  DocumentRoot /var/www/wiki/public
  <Directory /var/www/wiki/public>
      AllowOverride All
      Require all granted
  </Directory>
  ErrorLog ${APACHE_LOG_DIR}/wiki_error.log
  CustomLog ${APACHE_LOG_DIR}/wiki_access.log combined
</VirtualHost>

  3. Enable the Site and Rewrite Module:

    sudo a2ensite wiki.deome.net.conf
sudo a2enmod rewrite
sudo systemctl reload apache2

6. Set Up SSL with Let’s Encrypt

  1. Install Certbot:

    • If Certbot is not already installed: 
      sudo apt install certbot python3-certbot-apache -y

  2. Generate SSL Certificate:

    sudo certbot --apache -d wiki.deome.net

  3. Auto-Renewal Setup:

    • Certbot will auto-renew SSL certificates by default. To verify: 
      sudo certbot renew --dry-run

7. Complete BookStack Setup

  1. Run the BookStack Installation Commands:

    • Navigate to the BookStack directory and run the following commands to finish the setup: 
      cd /var/www/wiki
sudo -u www-data php artisan key:generate --force
sudo -u www-data php artisan migrate --force

  2. Set Permissions (again, if necessary):

    • Ensure permissions are still correct after setup: 
      sudo chown -R www-data:www-data /var/www/wiki
sudo chmod -R 755 /var/www/wiki

8. Testing and Verification

  1. Access BookStack:

    • Go to https://wiki.deome.net in your web browser.
    • Follow the on-screen instructions to set up the admin account.

  2. Check Logs:

    • Monitor Apache logs if there are any issues: 
      sudo tail -f /var/log/apache2/wiki_access.log
sudo tail -f /var/log/apache2/wiki_error.log

9. Ongoing Maintenance

  1. Database Backups:

    • Set up a cron job to regularly back up the BookStack database: 
      mysqldump -u root -p bookstackdb > /path/to/backup/bookstackdb.sql

  2. Updating BookStack:

    • Periodically pull the latest updates from the BookStack repository: 
      cd /var/www/wiki
sudo -u www-data git pull origin release
sudo -u www-data php artisan migrate --force

This setup guide for BookStack covers installation, configuration, and basic maintenance. Let me know if you'd like additional details or specific troubleshooting steps included!

Piwigo Installation and Configuration on gallery.deome.net

Overview

This page provides step-by-step instructions to install and configure Piwigo as a photo gallery on gallery.deome.net. This includes setting up the Apache virtual host, database configuration, and SSL with Let’s Encrypt.

1. Prerequisites

  1. Web Server: Apache (see Apache wiki page).
  2. Database: MariaDB (refer to MariaDB setup page).
  3. PHP: Ensure PHP is installed along with the necessary modules: 
    sudo apt install php php-mysql php-xml php-mbstring php-gd php-curl -y

2. Download and Install Piwigo

  1. Create the Document Root Directory:

    • Create a directory for Piwigo: 
      sudo mkdir -p /var/www/gallery

  2. Download Piwigo:

    • Navigate to the gallery directory and download the latest Piwigo release: 
      cd /var/www/gallery
sudo wget https://piwigo.org/download/dlcounter.php?code=latest -O piwigo.zip
sudo unzip piwigo.zip
sudo mv piwigo/* ./
sudo rm -rf piwigo piwigo.zip

  3. Set File Permissions:

    • Make sure Apache has the correct permissions to access and modify the files: 
      sudo chown -R www-data:www-data /var/www/gallery
sudo chmod -R 755 /var/www/gallery

3. Configure the Database

  1. Log in to MariaDB:

    sudo mysql -u root -p

  2. Create a Database and User for Piwigo:

    CREATE DATABASE piwigodb;
CREATE USER 'piwigouser'@'localhost' IDENTIFIED BY 'your_password';
GRANT ALL PRIVILEGES ON piwigodb.* TO 'piwigouser'@'localhost';
FLUSH PRIVILEGES;
EXIT;

4. Configure Apache Virtual Host for gallery.deome.net

  1. Create the Virtual Host File:

    • Open a new virtual host configuration file for gallery.deome.net: 
      sudo nano /etc/apache2/sites-available/gallery.deome.net.conf

  2. Add the Virtual Host Configuration:

    • Use the following configuration: 
      <VirtualHost *:80>
  ServerName gallery.deome.net
  DocumentRoot /var/www/gallery
  <Directory /var/www/gallery>
      AllowOverride All
      Require all granted
  </Directory>
  ErrorLog ${APACHE_LOG_DIR}/gallery_error.log
  CustomLog ${APACHE_LOG_DIR}/gallery_access.log combined
</VirtualHost>

  3. Enable the Site and Rewrite Module:

    • Enable the virtual host and rewrite module, then reload Apache: 
      sudo a2ensite gallery.deome.net.conf
sudo a2enmod rewrite
sudo systemctl reload apache2

5. Set Up SSL with Let’s Encrypt

  1. Install Certbot:

    • If Certbot is not already installed: 
      sudo apt install certbot python3-certbot-apache -y

  2. Generate SSL Certificate:

    • Use Certbot to obtain an SSL certificate for gallery.deome.net: 
      sudo certbot --apache -d gallery.deome.net

  3. Enable Auto-Renewal:

    • Certbot will automatically handle renewal. Test the setup with: 
      sudo certbot renew --dry-run

6. Complete Piwigo Setup

  1. Access the Piwigo Installation Wizard:

    • Open a browser and go to https://gallery.deome.net. You should see the Piwigo setup wizard.

  2. Follow the Setup Wizard:

    • Enter the database information:
      • Database Name: piwigodb
      • Database User: piwigouser
      • Database Password: your_password
    • Configure the admin account and complete the setup.

7. Testing and Verification

  1. Access Piwigo:

    • Verify that Piwigo loads correctly at https://gallery.deome.net.

  2. Check Logs:

    • Monitor the Apache logs if any issues arise: 
      sudo tail -f /var/log/apache2/gallery_access.log
sudo tail -f /var/log/apache2/gallery_error.log

8. Maintenance and Updates

  1. Database Backup:

    • Set up regular database backups: 
      mysqldump -u root -p piwigodb > /path/to/backup/piwigodb.sql

  2. Updating Piwigo:

    • Periodically check for updates in the Piwigo admin dashboard.

This setup should get Piwigo running smoothly on gallery.deome.net. Let me know if you need any specific configurations or additional settings!