PhpMyAdmin - Revision history

Vincent: Use shared template for open_basedir

2017-06-24T08:52:04Z

Use shared template for open_basedir

← Older revision		Revision as of 08:52, 24 June 2017
Line 20:		Line 20:

	=== PHP ===		=== PHP ===
	~~Edit file <code>[[~~PHP~~#Common_configuration~~\|~~/etc/php/7.0/mods-available/local-common.ini]]</code> and add~~ folders ~~<code>~~/usr/share/phpmyadmin/:/etc/phpmyadmin/:/var/lib/phpmyadmin/~~</code> to the [[PHP#Limit_File_Access\|<code>open_basedir</code> setting]].~~		{{PHP/open basedir\|folders=/usr/share/phpmyadmin/:/etc/phpmyadmin/:/var/lib/phpmyadmin/}}

	=== Nginx ===		=== Nginx ===

Vincent: PHP7.0

2017-06-24T08:46:46Z

PHP7.0

← Older revision		Revision as of 08:46, 24 June 2017
Line 4:		Line 4:
	== Install ==		== Install ==
	<syntaxhighlight lang="console">		<syntaxhighlight lang="console">
	# apt install phpmyadmin		$ sudo apt install phpmyadmin
	</syntaxhighlight>		</syntaxhighlight>

Line 20:		Line 20:

	=== PHP ===		=== PHP ===
	Edit file <code>[[PHP#Common_configuration\|/etc/~~php5~~/mods-available/local-common.ini]]</code> and add folders <code>/usr/share/phpmyadmin/:/etc/phpmyadmin/:/var/lib/phpmyadmin/</code> to the [[PHP#Limit_File_Access\|<code>open_basedir</code> setting]].		Edit file <code>[[PHP#Common_configuration\|/etc/php/7.0/mods-available/local-common.ini]]</code> and add folders <code>/usr/share/phpmyadmin/:/etc/phpmyadmin/:/var/lib/phpmyadmin/</code> to the [[PHP#Limit_File_Access\|<code>open_basedir</code> setting]].

	=== Nginx ===		=== Nginx ===
Line 63:		Line 63:
	try_files $uri =404;		try_files $uri =404;
	include fastcgi.conf;		include fastcgi.conf;
	fastcgi_pass ~~php5~~;		fastcgi_pass php;
	}		}
	} }}		} }}

Vincent: Add absolute URI

2016-07-17T09:02:57Z

Add absolute URI

← Older revision		Revision as of 09:02, 17 July 2016
Line 67:		Line 67:
	} }}		} }}
	[[Category:Linux Server]]		[[Category:Linux Server]]

			=== Absolute URI ===
			When placed behind a reverse proxy, phpMyAdmin might have trouble generating correct URLs. One manifestation is that after successful login, the URL you are redirected to is broken.

			Fixing that is quite easy. Just create file <code>/etc/phpmyadmin/conf.d/absoluteuri.inc.php</code> with the following content:<syntaxhighlight lang="php">
			<?php
			$cfg['PmaAbsoluteUri'] = 'https://phpmyadmin.example.org';
			</syntaxhighlight>

Vincent: Update phpmyadmin folders

2016-07-17T08:49:36Z

Update phpmyadmin folders

← Older revision		Revision as of 08:49, 17 July 2016
Line 20:		Line 20:

	=== PHP ===		=== PHP ===
	Edit file <code>[[PHP#Common_configuration\|/etc/php5/mods-available/local-common.ini]]</code> and add ~~folder~~ <code>/usr/share/phpmyadmin/</code> to the [[PHP#Limit_File_Access\|<code>open_basedir</code> setting]].		Edit file <code>[[PHP#Common_configuration\|/etc/php5/mods-available/local-common.ini]]</code> and add folders <code>/usr/share/phpmyadmin/:/etc/phpmyadmin/:/var/lib/phpmyadmin/</code> to the [[PHP#Limit_File_Access\|<code>open_basedir</code> setting]].

	=== Nginx ===		=== Nginx ===

Vincent: Use template for web server configuration

2016-05-13T06:24:55Z

Use template for web server configuration

← Older revision		Revision as of 06:24, 13 May 2016
Line 23:		Line 23:

	=== Nginx ===		=== Nginx ===
	~~Create file <code>/etc/nginx/sites-available~~/phpmyadmin~~</code> <syntaxhighlight lang~~=~~"nginx">~~
	server {		{{Nginx/New Site\|domain = phpmyadmin.example.org\|config = server {
	include snippets/listen-http.conf;		include snippets/listen-http.conf;
	server_name phpmyadmin.example.~~com~~;		server_name phpmyadmin.example.org;

	access_log /var/log/nginx/phpmyadmin.access.log;		access_log /var/log/nginx/phpmyadmin.example.org.access.log;
	error_log /var/log/nginx/phpmyadmin.error.log info;		error_log /var/log/nginx/phpmyadmin.example.org.error.log info;

	include snippets/acme-challenge.conf;		include snippets/acme-challenge.conf;
Line 37:		Line 37:
	server {		server {
	include snippets/listen-https.conf;		include snippets/listen-https.conf;
	server_name phpmyadmin.example.~~com~~;		server_name phpmyadmin.example.org;

	access_log /var/log/nginx/phpmyadmin.access.log;		access_log /var/log/nginx/phpmyadmin.example.org.access.log;
	error_log /var/log/nginx/phpmyadmin.error.log info;		error_log /var/log/nginx/phpmyadmin.example.org.error.log info;

	include snippets/acme-challenge.conf;		include snippets/acme-challenge.conf;

	#include snippets/ssl.conf;		#include snippets/ssl.conf;
	#ssl_certificate /etc/letsencrypt/live/phpmyadmin.example.~~com~~/fullchain.pem;		#ssl_certificate /etc/letsencrypt/live/phpmyadmin.example.org/fullchain.pem;
	#ssl_certificate_key /etc/letsencrypt/live/phpmyadmin.example.~~com~~/privkey.pem;		#ssl_certificate_key /etc/letsencrypt/live/phpmyadmin.example.org/privkey.pem;
	#include snippets/hsts.conf;		#include snippets/hsts.conf;

Line 62:		Line 61:

	location ~ \.php$ {		location ~ \.php$ {
	try_files $uri =404;		try_files $uri =404;
	include fastcgi.conf;		include fastcgi.conf;
	fastcgi_pass php5;		fastcgi_pass php5;
	}		}
	}		} }}
	~~</syntaxhighlight>Activate the configuration with<syntaxhighlight lang="console">~~
	~~# ln -s /etc/nginx/sites-available/phpmyadmin /etc/nginx/sites-enabled/~~
	~~# service nginx reload~~
	~~</syntaxhighlight>~~

	~~=== TLS Certificate ===~~
	~~Edit file <code>[[Let’s Encrypt#Renewal_Script\|/usr/local/sbin/renew_certificates]]</code> and add the following to the config list<syntaxhighlight lang="python">~~
	{
	~~'domains': ['phpmyadmin.example.com'],~~
	~~'reload': [['service', 'nginx', 'reload']]~~
	}
	~~</syntaxhighlight>and get your certificate{{Let’s Encrypt/New Cert Command\|domain = phpmyadmin.example.com\|command = service nginx restart~~}~~}Now uncomment the ssl related lines in <code>/etc/nginx/sites-available/phpmyadmin</code> and run<syntaxhighlight lang="console">~~
	~~# service nginx reload~~
	~~</syntaxhighlight>~~
	[[Category:Linux Server]]		[[Category:Linux Server]]

Vincent: Use Let’s Encrypt template

2016-03-20T23:23:58Z

Use Let’s Encrypt template

@@ Line 78: / Line 78: @@
      'reload': [['service', 'nginx', 'reload']]
+}
-</syntaxhighlight>and get your certificate<syntaxhighlight lang="console">
+</syntaxhighlight>and get your certificate{{Let’s Encrypt/New Cert Command|domain = phpmyadmin.example.com|command = service nginx restart}}Now uncomment the ssl related lines in <code>/etc/nginx/sites-available/phpmyadmin</code> and run<syntaxhighlight lang="console">
 # service nginx reload
 </syntaxhighlight>
 [[Category:Linux Server]]

Vincent: Let’s Encrypt links

2016-03-20T21:38:19Z

Let’s Encrypt links

← Older revision		Revision as of 21:38, 20 March 2016
Line 1:		Line 1:
	== Prerequisite ==		== Prerequisite ==
	To install PhpMyAdmin, you will need to have [[Nginx]], [[PHP]] and [[~~MariaDB~~]] installed.		To install PhpMyAdmin, you will need to have [[Nginx]], [[PHP]], [[MariaDB]] and [[Let’s Encrypt]] installed.

	== Install ==		== Install ==
Line 73:		Line 73:

	=== TLS Certificate ===		=== TLS Certificate ===
	Edit file [[~~TLS~~\|/usr/local/sbin/renew_certificates]] and add the following to the config list<syntaxhighlight lang="python">		Edit file <code>[[Let’s Encrypt#Renewal_Script\|/usr/local/sbin/renew_certificates]]</code> and add the following to the config list<syntaxhighlight lang="python">
	{		{
	'domains': ['phpmyadmin.example.com'],		'domains': ['phpmyadmin.example.com'],

Vincent: Refactor installation questions

2016-03-20T21:34:22Z

Refactor installation questions

← Older revision		Revision as of 21:34, 20 March 2016
Line 5:		Line 5:
	<syntaxhighlight lang="console">		<syntaxhighlight lang="console">
	# apt install phpmyadmin		# apt install phpmyadmin
	</syntaxhighlight>~~Answer to~~ the ~~question asked during install~~		</syntaxhighlight>
	* Web server to reconfigure automatically? ~~None~~
	* Configure database for phpmyadmin with dbconfig-common? Yes		The installer will ask you several questions. Here are the answers:
	* Password of the database's administrative user? Enter ~~the database~~ root user password		;Web server to reconfigure automatically?
	* MySQL application password for phpmyadmin? Keep it empty to get a random one. You will never need to enter this password		:Choose none. Nginx will be configured later.
			;Configure database for phpmyadmin with dbconfig-common?
			:Yes
			;Password of the database's administrative user?
			:Enter your [[MariaDB]] root user password.
			;MySQL application password for phpmyadmin?
			:Keep it empty to get a random one. You will never need to enter this password

	== Configure ==		== Configure ==

Vincent: /* PHP */ fix links

2016-03-20T10:02:29Z

PHP: fix links

← Older revision		Revision as of 10:02, 20 March 2016
Line 14:		Line 14:

	=== PHP ===		=== PHP ===
	Edit file [[PHP\|/etc/php5/mods-available/local-common.ini]] and add folder <code>/usr/share/phpmyadmin/</code> to the [[PHP\|open_basedir setting]].		Edit file <code>[[PHP#Common_configuration\|/etc/php5/mods-available/local-common.ini]]</code> and add folder <code>/usr/share/phpmyadmin/</code> to the [[PHP#Limit_File_Access\|<code>open_basedir</code> setting]].

	=== Nginx ===		=== Nginx ===

Vincent: Category:Linux Server

2016-03-20T09:59:18Z

Category:Linux Server

← Older revision		Revision as of 09:59, 20 March 2016
Line 93:		Line 93:
	# service nginx reload		# service nginx reload
	</syntaxhighlight>		</syntaxhighlight>
			[[Category:Linux Server]]