ArchLinux:Nginx: Difference between revisions

From Wiki³
No edit summary
Line 51: Line 51:
{{Console|1=mariadb-install-db --user{{=}}mysql --basedir{{=}}/usr --datadir{{=}}/nginx/sql}}
{{Console|1=mariadb-install-db --user{{=}}mysql --basedir{{=}}/usr --datadir{{=}}/nginx/sql}}
{{margin}}
{{margin}}
{{Console|1=echo -e "" | tee /etc/my.cnf.d/server.cnf
{{Console|1=/etc/my.cnf.d/server.cnf}}




[[Category:Arch Linux]]
[[Category:Arch Linux]]

Revision as of 11:06, 28 April 2021

Icon Introduction

Icon NGINX

Beforehand be sure to determine weather the web server will be using MySQL (ie. MariaDB) or PostreSQL.

# pikaur -S composer curl minify nginx php-fpm sassc wget
 
# pikaur -S php-gd php-geoip php-imagic php-intl php-memcache php-pgsql php-sqlite php-sodium xdebug

Next create the environment for the web server.

# sudo mkdir -p /nginx/conf.d /nginx/https /nginx/logs /nginx/sql /nginx/ssl /nginx/vhosts.d
 
# sudo chmod -R 770 /nginx
 
# sudo chmod 750 /nginx/sql
 
# sudo gpasswd -a username http

Icon PostgreSQL

Using postgresql as a back-end will require the following setup and configuration.

# pikaur -S postgresql
 
# sudo chown postgres:postgres /nginx/sql
 
# sudo gpasswd -a username postgres

Swap over to the postgresql user account.

# sudo -iu postgres

Run the database initialization.

# initdb --locale en_US.UTF-8 -E UTF8 -D '/nginx/sql/data'

Return to the normal user account.

# exit

Modify the systemd service file to reflect the new data directory.

# sudo systemctl edit postgresql.service
 
filename: postgresql.service
Environment=PGROOT=/nginx/sql
PIDFile=/nginx/sql/postmaster.pid

Start and enable the systemd service.

# sudo systemctl enable --now postgresql.service

Swap back over to the postgresql user account.

# sudo -iu postgres

Create a new postgres user account.

# createuser -P --interactive
Enter name of role to add: username
Enter password for new role: ********
Enter it again: ********
Shall the new role be a superuser? (y/n) n
Shall the new role be allowed to create databases? (y/n) y
Shall the new role be allowed to create more new roles? (y/n) n

Icon MariaDB

If mariadb is to be used for the back-end, the following will be required.

# pikaur -S mariadb
 
# sudo chown mysql:mysql /nginx/sql
 
# sudo gpasswd -a username mysql
 
# mariadb-install-db --user=mysql --basedir=/usr --datadir=/nginx/sql
 
# /etc/my.cnf.d/server.cnf