ArchLinux:Nginx: Difference between revisions
m (→MariaDB) |
mNo edit summary |
||
| Line 5: | Line 5: | ||
= {{Icon24|sitemap}} NGINX = | = {{Icon24|sitemap}} NGINX = | ||
Beforehand be sure to determine weather the web server will be using MySQL (ie. MariaDB) or | Beforehand be sure to determine weather the web server will be using MySQL (ie. MariaDB) or PostgreSQL. | ||
Begin by installing NGINX, PHP and other required utilities. | |||
{{Console|1=pikaur -S composer curl minify nginx php-fpm sassc wget}} | {{Console|1=pikaur -S composer curl minify nginx php-fpm sassc wget}} | ||
Install all of the required PHP extensions. | |||
{{Console|1=pikaur -S php-gd php-geoip php-imagic php-intl php-memcache php-pgsql php-sqlite php-sodium xdebug}} | {{Console|1=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. | Next create the environment for the web server. | ||
| Line 42: | Line 44: | ||
== {{Icon|notebook}} MariaDB == | == {{Icon|notebook}} MariaDB == | ||
Using {{mono|mariadb}} as a back-end will require the following setup and configuration. | |||
{{Console|1=pikaur -S mariadb}} | {{Console|1=pikaur -S mariadb}} | ||
{{margin}} | {{margin}} | ||
{{Console|1=sudo chown mysql:mysql /nginx/sql}} | {{Console|1=sudo chown mysql:mysql /nginx/sql}} | ||
Give the current logged in user access. | |||
{{Console|1=sudo gpasswd -a {{cyanBold|username}} mysql}} | {{Console|1=sudo gpasswd -a {{cyanBold|username}} mysql}} | ||
Create and initialize the data directory. | |||
{{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}} | ||
Revision as of 11:17, 28 April 2021
Back to Category:Arch Linux
Introduction
Introduction NGINX
Beforehand be sure to determine weather the web server will be using MySQL (ie. MariaDB) or PostgreSQL.
Begin by installing NGINX, PHP and other required utilities.
| # pikaur -S composer curl minify nginx php-fpm sassc wget |
Install all of the required PHP extensions.
| # 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 |
PostgreSQL
PostgreSQLUsing 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 |
| 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 |
MariaDB
Using mariadb as a back-end will require the following setup and configuration.
| # pikaur -S mariadb |
| # sudo chown mysql:mysql /nginx/sql |
Give the current logged in user access.
| # sudo gpasswd -a username mysql |
Create and initialize the data directory.
| # mariadb-install-db --user=mysql --basedir=/usr --datadir=/nginx/sql |
| # /etc/my.cnf.d/server.cnf |
