Nginx : Install Wiki.js2024/05/31

mysql

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 50
Server version: 10.11.7-MariaDB-2ubuntu2 Ubuntu 24.04

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> create database wikijs; 
Query OK, 1 row affected (0.00 sec)

MariaDB [(none)]> grant all privileges on wikijs.* to wikijs@'localhost' identified by 'password'; 
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> exit
Bye

mkdir /var/www/wikijs

useradd -d /var/www/wikijs -s /sbin/nologin wikijs

wget https://github.com/Requarks/wiki/releases/latest/download/wiki-js.tar.gz

tar zxvf wiki-js.tar.gz -C /var/www/wikijs/

chown -R wikijs:wikijs /var/www/wikijs

cp /var/www/wikijs/config.sample.yml /var/www/wikijs/config.yml

# line 23 : change for your database setting
db:
  type: mariadb

  # PostgreSQL / MySQL / MariaDB / MS SQL Server only:
  host: localhost
  port: 3306
  user: wikijs
  pass: password
  db: wikijs
  ssl: false

# line 102 : change listening IP address
bindIP: 127.0.0.1

[Unit]
Description=wiki.js app server
After=network.target

[Service]
Type=simple
ExecStart=/usr/bin/node server
Restart=always

User=wikijs
Environment=NODE_ENV=production
WorkingDirectory=/var/www/wikijs

[Install]
WantedBy=multi-user.target

systemctl daemon-reload

systemctl enable --now wikijs

# replace the hostname and certificate for yours
server {
        listen      80;
        listen      [::]:80;
        listen      443 ssl http2;
        listen      [::]:443 ssl http2;
        server_name rx-7.srv.world;
        root   /var/www/wikijs;

        ssl_certificate "/etc/letsencrypt/live/rx-7.srv.world/fullchain.pem";
        ssl_certificate_key "/etc/letsencrypt/live/rx-7.srv.world/privkey.pem";
        ssl_session_cache shared:SSL:1m;
        ssl_session_timeout  10m;

        location / {
                proxy_pass http://127.0.0.1:3000/;
                proxy_set_header    X-Real-IP $remote_addr;
                proxy_set_header    X-Forwarded-For $proxy_add_x_forwarded_for;
                proxy_set_header    Host $http_host;
        }
}

cd /etc/nginx/sites-enabled

ln -s /etc/nginx/sites-available/wikijs.conf ./

systemctl reload nginx