PhpMyAdmin - Revision history

Tgurr: /* Update */

2020-06-25T12:10:28Z

Update

← Older revision		Revision as of 14:10, 25 June 2020
Line 184:		Line 184:
	{{Root\|emerge phpmyadmin}}		{{Root\|emerge phpmyadmin}}

	{{Root\|webapp-config -h phpmyadmin.<domain> -d / -U phpmyadmin 4.8.4}}		{{Root\|webapp-config -h phpmyadmin.<domain> -d / -U phpmyadmin 5.0.3}}

	{{Root\|<nowiki>CONFIG_PROTECT="/var/www/phpmyadmin.<domain>/htdocs//libraries" etc-update</nowiki> }}		{{Root\|<nowiki>CONFIG_PROTECT="/var/www/phpmyadmin.<domain>/htdocs//libraries" etc-update</nowiki> }}

	{{Root\|emerge -C phpmyadmin-<oldversion>}}		{{Root\|emerge -C phpmyadmin-<oldversion>}}

Tgurr at 12:10, 25 June 2020

2020-06-25T12:10:02Z

← Older revision		Revision as of 14:10, 25 June 2020
Line 76:		Line 76:
	pm.max_spare_servers = 3		pm.max_spare_servers = 3

	php_admin_value[open_basedir] = /var/www/phpmyadmin.<domain>:/usr/bin:/usr/share/php		php_admin_value[date.timezone] = Europe/Berlin
	php_admin_value[~~upload_tmp_dir~~] = ~~/var/www/phpmyadmin.<domain>/tmp~~		php_admin_value[mysqli.default_socket] = /run/mysqld/mysqld.sock
			php_admin_value[open_basedir] = /var/www/phpmyadmin.<domain>:/usr/bin:/usr/share/php:/run/mysqld
			php_admin_value[post_max_size] = 50M
	php_admin_value[session.save_path] = /var/www/phpmyadmin.<domain>/session		php_admin_value[session.save_path] = /var/www/phpmyadmin.<domain>/session
	php_admin_value[sys_temp_dir] = /var/www/phpmyadmin.<domain>/tmp		php_admin_value[sys_temp_dir] = /var/www/phpmyadmin.<domain>/tmp
	~~php_admin_value[date.timezone] = Europe/Berlin~~
	~~php_admin_value[post_max_size] = 50M~~
	php_admin_value[upload_max_filesize] = 50M		php_admin_value[upload_max_filesize] = 50M
			php_admin_value[upload_tmp_dir] = /var/www/phpmyadmin.<domain>/tmp

	; enable logging		; enable logging
Line 102:		Line 103:
	{{Root\|emerge phpmyadmin}}		{{Root\|emerge phpmyadmin}}

	{{Root\|webapp-config -h phpmyadmin.<domain> -d / -I phpmyadmin 4.8.4}}		{{Root\|webapp-config -h phpmyadmin.<domain> -d / -I phpmyadmin 5.0.2}}

	{{Root\|mysql -u root -p < /usr/share/webapps/phpmyadmin/<version>/htdocs/sql/create_tables.sql}}		{{Root\|mysql -u root -p < /usr/share/webapps/phpmyadmin/<version>/htdocs/sql/create_tables.sql}}

	{{Root\|mysql -u root -p}}		{{Root\|mysql -u root -p}}

			{{Code\|Generate password hash\|<pre>
			SELECT PASSWORD('some_pass');
			</pre>}}

	{{Code\|Creating phpmyadmin control user\|<pre>		{{Code\|Creating phpmyadmin control user\|<pre>
	CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY '~~some_pass~~';		CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED VIA mysql_native_password USING 'some_hash';
	</pre>}}		</pre>}}

	{{Code\|Granting phpmyadmin control user access to the phpMyAdmin database\|<pre>		{{Code\|Granting phpmyadmin control user access to the phpMyAdmin database\|<pre>
	GRANT SELECT, INSERT, UPDATE, DELETE ON phpmyadmin.* TO 'phpmyadmin'@'localhost';		GRANT SELECT, INSERT, UPDATE, DELETE ON phpmyadmin.* TO 'phpmyadmin'@'localhost';
	~~</pre>}}~~

	~~{{Code\|Granting phpmyadmin control user access to the MySQL system databases\|<pre>~~
	~~GRANT USAGE ON mysql.* TO 'phpmyadmin'@'localhost' IDENTIFIED BY 'some_pass';~~
	~~GRANT SELECT (~~
	~~Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv,~~
	~~Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv,~~
	~~File_priv, Grant_priv, References_priv, Index_priv, Alter_priv,~~
	~~Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv,~~
	~~Execute_priv, Repl_slave_priv, Repl_client_priv~~
	~~) ON mysql.user TO 'phpmyadmin'@'localhost';~~
	~~GRANT SELECT ON mysql.db TO 'phpmyadmin'@'localhost';~~
	~~GRANT SELECT ON mysql.host TO 'phpmyadmin'@'localhost';~~
	~~GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv)~~
	~~ON mysql.tables_priv TO 'phpmyadmin'@'localhost';~~
	</pre>}}		</pre>}}

Tgurr: /* Configuration */

2018-12-20T18:03:27Z

Configuration

← Older revision		Revision as of 20:03, 20 December 2018
Line 143:		Line 143:
	$i++;		$i++;
	$cfg['Servers'][$i]['host'] = 'localhost';		$cfg['Servers'][$i]['host'] = 'localhost';
	~~$cfg['Servers'][$i]['connect_type'] = 'tcp';~~
	$cfg['Servers'][$i]['compress'] = false;		$cfg['Servers'][$i]['compress'] = false;
	$cfg['Servers'][$i]['auth_type'] = 'cookie';		$cfg['Servers'][$i]['auth_type'] = 'cookie';

Tgurr: /* Configuration */

2018-12-20T18:03:16Z

Configuration

← Older revision		Revision as of 20:03, 20 December 2018
Line 135:		Line 135:
	{{File\|/var/www/phpmyadmin.<domain>/htdocs/config.inc.php\|		{{File\|/var/www/phpmyadmin.<domain>/htdocs/config.inc.php\|
	<pre>		<pre>
			<?php

	/* Servers configuration */		/* Servers configuration */
	$i = 0;		$i = 0;
Line 182:		Line 184:
	$cfg['VersionCheck'] = 0;		$cfg['VersionCheck'] = 0;
	$cfg['TempDir'] = '/var/www/phpmyadmin.<domain>/tmp';		$cfg['TempDir'] = '/var/www/phpmyadmin.<domain>/tmp';

			?>
	</pre>		</pre>
	}}		}}

Tgurr: /* Installation */

2018-12-20T17:19:14Z

Installation

← Older revision		Revision as of 19:19, 20 December 2018
Line 105:		Line 105:

	{{Root\|mysql -u root -p < /usr/share/webapps/phpmyadmin/<version>/htdocs/sql/create_tables.sql}}		{{Root\|mysql -u root -p < /usr/share/webapps/phpmyadmin/<version>/htdocs/sql/create_tables.sql}}

			{{Root\|mysql -u root -p}}

	{{Code\|Creating phpmyadmin control user\|<pre>		{{Code\|Creating phpmyadmin control user\|<pre>

Tgurr: /* Configuration */

2018-12-20T17:18:28Z

Configuration

← Older revision		Revision as of 19:18, 20 December 2018
Line 179:		Line 179:
	$cfg['SaveDir'] = '';		$cfg['SaveDir'] = '';
	$cfg['VersionCheck'] = 0;		$cfg['VersionCheck'] = 0;
			$cfg['TempDir'] = '/var/www/phpmyadmin.<domain>/tmp';
	</pre>		</pre>
	}}		}}

Tgurr: /* Update */

2018-12-20T16:51:15Z

Update

← Older revision		Revision as of 18:51, 20 December 2018
Line 188:		Line 188:
	{{Root\|emerge phpmyadmin}}		{{Root\|emerge phpmyadmin}}

	{{Root\|webapp-config -h phpmyadmin.~~example.com~~ -d / -U phpmyadmin 4.6.0}}		{{Root\|webapp-config -h phpmyadmin.<domain> -d / -U phpmyadmin 4.8.4}}

	{{Root\|<nowiki>CONFIG_PROTECT="/var/www/phpmyadmin.~~example.com~~/htdocs//libraries" etc-update</nowiki> }}		{{Root\|<nowiki>CONFIG_PROTECT="/var/www/phpmyadmin.<domain>/htdocs//libraries" etc-update</nowiki> }}

	{{Root\|emerge -C phpmyadmin-<oldversion>}}		{{Root\|emerge -C phpmyadmin-<oldversion>}}

Tgurr: /* Installation */

2018-12-20T16:50:28Z

Installation

← Older revision		Revision as of 18:50, 20 December 2018
Line 102:		Line 102:
	{{Root\|emerge phpmyadmin}}		{{Root\|emerge phpmyadmin}}

	{{Root\|webapp-config -h phpmyadmin.~~example.com~~ -d / -I phpmyadmin 4.8.4}}		{{Root\|webapp-config -h phpmyadmin.<domain> -d / -I phpmyadmin 4.8.4}}

	{{Root\|mysql -u root -p < /usr/share/webapps/phpmyadmin/<version>/htdocs/sql/create_tables.sql}}		{{Root\|mysql -u root -p < /usr/share/webapps/phpmyadmin/<version>/htdocs/sql/create_tables.sql}}

Tgurr: /* Installation */

2018-12-20T16:49:27Z

Installation

← Older revision		Revision as of 18:49, 20 December 2018
Line 102:		Line 102:
	{{Root\|emerge phpmyadmin}}		{{Root\|emerge phpmyadmin}}

	{{Root\|webapp-config -h phpmyadmin.example.com -d / -I phpmyadmin 4.6.0}}		{{Root\|webapp-config -h phpmyadmin.example.com -d / -I phpmyadmin 4.8.4}}

	{{Root\|mysql -u root -p < /usr/share/webapps/phpmyadmin/<version>/htdocs/sql/create_tables.sql}}		{{Root\|mysql -u root -p < /usr/share/webapps/phpmyadmin/<version>/htdocs/sql/create_tables.sql}}

Tgurr: /* PHP-FPM Configuration */

2018-12-20T16:48:52Z

PHP-FPM Configuration

← Older revision		Revision as of 18:48, 20 December 2018
Line 54:		Line 54:

	{{Root\|useradd --system --shell /bin/false --no-create-home --home /var/www/phpmyadmin.<domain> -g apache www-phpmyadmin}}		{{Root\|useradd --system --shell /bin/false --no-create-home --home /var/www/phpmyadmin.<domain> -g apache www-phpmyadmin}}

			{{File\|/etc/php/fpm-php7.2/fpm.d/phpmyadmin.<domain>.conf\|
			<pre>
			[phpmyadmin.<domain>]

			prefix = /var/www/$pool

			user = www-phpmyadmin
			group = apache

			listen = /run/php-fpm-$pool.sock

			listen.owner = www-phpmyadmin
			listen.group = apache
			listen.mode = 0660

			pm = dynamic
			pm.max_children = 50
			pm.start_servers = 2
			pm.min_spare_servers = 1
			pm.max_spare_servers = 3

			php_admin_value[open_basedir] = /var/www/phpmyadmin.<domain>:/usr/bin:/usr/share/php
			php_admin_value[upload_tmp_dir] = /var/www/phpmyadmin.<domain>/tmp
			php_admin_value[session.save_path] = /var/www/phpmyadmin.<domain>/session
			php_admin_value[sys_temp_dir] = /var/www/phpmyadmin.<domain>/tmp
			php_admin_value[date.timezone] = Europe/Berlin
			php_admin_value[post_max_size] = 50M
			php_admin_value[upload_max_filesize] = 50M

			; enable logging
			catch_workers_output = yes
			php_admin_flag[display_errors] = off
			php_admin_flag[log_errors] = on
			php_admin_value[error_log] = /var/log/php-fpm.phpmyadmin.<domain>.log
			</pre>
			}}

	== Installation ==		== Installation ==

← Older revision		Revision as of 14:10, 25 June 2020
Line 184:		Line 184:
	{{Root\|emerge phpmyadmin}}		{{Root\|emerge phpmyadmin}}

	{{Root\|webapp-config -h phpmyadmin.<domain> -d / -U phpmyadmin 4.8.4}}		{{Root\|webapp-config -h phpmyadmin.<domain> -d / -U phpmyadmin 5.0.3}}

	{{Root\|<nowiki>CONFIG_PROTECT="/var/www/phpmyadmin.<domain>/htdocs//libraries" etc-update</nowiki> }}		{{Root\|<nowiki>CONFIG_PROTECT="/var/www/phpmyadmin.<domain>/htdocs//libraries" etc-update</nowiki> }}

	{{Root\|emerge -C phpmyadmin-<oldversion>}}		{{Root\|emerge -C phpmyadmin-<oldversion>}}

← Older revision		Revision as of 19:19, 20 December 2018
Line 105:		Line 105:

	{{Root\|mysql -u root -p < /usr/share/webapps/phpmyadmin/<version>/htdocs/sql/create_tables.sql}}		{{Root\|mysql -u root -p < /usr/share/webapps/phpmyadmin/<version>/htdocs/sql/create_tables.sql}}

			{{Root\|mysql -u root -p}}

	{{Code\|Creating phpmyadmin control user\|<pre>		{{Code\|Creating phpmyadmin control user\|<pre>

← Older revision		Revision as of 18:51, 20 December 2018
Line 188:		Line 188:
	{{Root\|emerge phpmyadmin}}		{{Root\|emerge phpmyadmin}}

	{{Root\|webapp-config -h phpmyadmin.~~example.com~~ -d / -U phpmyadmin 4.6.0}}		{{Root\|webapp-config -h phpmyadmin.<domain> -d / -U phpmyadmin 4.8.4}}

	{{Root\|<nowiki>CONFIG_PROTECT="/var/www/phpmyadmin.~~example.com~~/htdocs//libraries" etc-update</nowiki> }}		{{Root\|<nowiki>CONFIG_PROTECT="/var/www/phpmyadmin.<domain>/htdocs//libraries" etc-update</nowiki> }}

	{{Root\|emerge -C phpmyadmin-<oldversion>}}		{{Root\|emerge -C phpmyadmin-<oldversion>}}

← Older revision		Revision as of 18:50, 20 December 2018
Line 102:		Line 102:
	{{Root\|emerge phpmyadmin}}		{{Root\|emerge phpmyadmin}}

	{{Root\|webapp-config -h phpmyadmin.~~example.com~~ -d / -I phpmyadmin 4.8.4}}		{{Root\|webapp-config -h phpmyadmin.<domain> -d / -I phpmyadmin 4.8.4}}

	{{Root\|mysql -u root -p < /usr/share/webapps/phpmyadmin/<version>/htdocs/sql/create_tables.sql}}		{{Root\|mysql -u root -p < /usr/share/webapps/phpmyadmin/<version>/htdocs/sql/create_tables.sql}}

← Older revision		Revision as of 18:49, 20 December 2018
Line 102:		Line 102:
	{{Root\|emerge phpmyadmin}}		{{Root\|emerge phpmyadmin}}

	{{Root\|webapp-config -h phpmyadmin.example.com -d / -I phpmyadmin 4.6.0}}		{{Root\|webapp-config -h phpmyadmin.example.com -d / -I phpmyadmin 4.8.4}}

	{{Root\|mysql -u root -p < /usr/share/webapps/phpmyadmin/<version>/htdocs/sql/create_tables.sql}}		{{Root\|mysql -u root -p < /usr/share/webapps/phpmyadmin/<version>/htdocs/sql/create_tables.sql}}