servers:nginx:phpmyadmin
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
servers:nginx:phpmyadmin [2016/05/30 08:20] – Sean Rhone | servers:nginx:phpmyadmin [2016/06/26 11:50] (current) – [PHP-FPM Socket] Sean Rhone | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== Information ====== | ||
+ | * phpMyAdmin | ||
+ | * [[Information: | ||
+ | * https:// | ||
+ | |||
+ | ===== Prerequisites ===== | ||
+ | |||
+ | * [[Distros: | ||
+ | * [[Servers: | ||
+ | * [[Servers: | ||
+ | * [[Servers: | ||
+ | |||
+ | ====== Dependencies ====== | ||
+ | |||
+ | **** | ||
+ | |||
+ | sudo zypper install git-core php-composer | ||
+ | |||
+ | ====== Download Source ====== | ||
+ | |||
+ | **** | ||
+ | |||
+ | sudo git clone -b ' | ||
+ | |||
+ | ===== Composer Dependencies ===== | ||
+ | |||
+ | sudo su ' | ||
+ | |||
+ | cd '/ | ||
+ | |||
+ | ====== Database ====== | ||
+ | |||
+ | mysql -u ' | ||
+ | |||
+ | mysql -u ' | ||
+ | |||
+ | GRANT SELECT, INSERT, UPDATE, DELETE ON phpmyadmin.* to ' | ||
+ | |||
+ | ====== nginx + PHP-FPM Configuration ====== | ||
+ | |||
+ | ===== PHP-FPM Socket ===== | ||
+ | |||
+ | sudo -e '/ | ||
+ | |||
+ | [phpmyadmin] | ||
+ | user = nginx | ||
+ | group = nginx | ||
+ | listen = / | ||
+ | listen.owner = nginx | ||
+ | listen.group = nginx | ||
+ | listen.allowed_clients = 127.0.0.1 | ||
+ | pm = ondemand | ||
+ | pm.max_children = 8 | ||
+ | pm.process_idle_timeout = 10s | ||
+ | |||
+ | ===== FastCGI ===== | ||
+ | |||
+ | sudo -e '/ | ||
+ | |||
+ | location ~ \.php$ { | ||
+ | try_files $uri =404; | ||
+ | include fastcgi.conf; | ||
+ | fastcgi_intercept_errors on; | ||
+ | fastcgi_index index.php; | ||
+ | fastcgi_param SCRIPT_FILENAME | ||
+ | fastcgi_param HTTPS on; | ||
+ | fastcgi_pass unix:/ | ||
+ | } | ||
+ | |||
+ | ===== Server Block ===== | ||
+ | |||
+ | sudo -e '/ | ||
+ | |||
+ | server { | ||
+ | listen ' | ||
+ | server_name ' | ||
+ | root '/ | ||
+ | index ' | ||
+ | | ||
+ | include '/ | ||
+ | | ||
+ | #access_log / | ||
+ | #error_log / | ||
+ | | ||
+ | location / { | ||
+ | allow 192.168.1.0/ | ||
+ | deny all; | ||
+ | } | ||
+ | } | ||
+ | |||
+ | ====== Settings ====== | ||
+ | |||
+ | ===== Copy Sample Config ===== | ||
+ | |||
+ | **** | ||
+ | |||
+ | sudo cp '/ | ||
+ | |||
+ | ===== Edit Config ===== | ||
+ | |||
+ | * Uncomment the entire **Storage database and tables** section and change the following | ||
+ | * '' | ||
+ | |||
+ | sudo -e '/ | ||
+ | |||
+ | $cfg[' | ||
+ | | ||
+ | $cfg[' | ||
+ | | ||
+ | $cfg[' | ||
+ | $cfg[' | ||
+ | |||
+ | ====== Services ====== | ||
+ | |||
+ | ===== Updater ===== | ||
+ | |||
+ | ==== Service ==== | ||
+ | |||
+ | sudo -e '/ | ||
+ | |||
+ | [Service] | ||
+ | User=nginx | ||
+ | Group=nginx | ||
+ | Type=oneshot | ||
+ | ExecStart='/ | ||
+ | ExecStart='/ | ||
+ | ExecStart='/ | ||
+ | |||
+ | ==== Timer ==== | ||
+ | |||
+ | sudo -e '/ | ||
+ | |||
+ | [Unit] | ||
+ | Description=phpMyAdmin Git Updater | ||
+ | Wants=network-online.target | ||
+ | | ||
+ | [Timer] | ||
+ | OnCalendar=*-*-* 01:30:00 | ||
+ | Persistent=true | ||
+ | | ||
+ | [Install] | ||
+ | WantedBy=timers.target |
/var/www/wiki/data/pages/servers/nginx/phpmyadmin.txt · Last modified: 2016/06/26 11:50 by Sean Rhone