|
|
|
@@ -29,15 +29,15 @@ Index: config.sample.inc.php
|
|
|
|
|
* This is needed for cookie based authentication to encrypt password in
|
|
|
|
|
* cookie
|
|
|
|
|
+ * YOU MUST FILL IN THIS FOR COOKIE AUTH!
|
|
|
|
|
+ */
|
|
|
|
|
*/
|
|
|
|
|
-$cfg['blowfish_secret'] = 'a8b7c6d'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
|
|
|
|
|
+$cfg['blowfish_secret'] = '';
|
|
|
|
|
+
|
|
|
|
|
+/*
|
|
|
|
|
+ * Disable the default warning about $cfg['PmaAbsoluteUri'] not being set
|
|
|
|
|
+ * You should use this if and ONLY if the PmaAbsoluteUri auto-detection
|
|
|
|
|
+ * works perfectly.
|
|
|
|
|
*/
|
|
|
|
|
-$cfg['blowfish_secret'] = 'a8b7c6d'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
|
|
|
|
|
+ */
|
|
|
|
|
+$cfg['PmaAbsoluteUri_DisableWarning'] = false;
|
|
|
|
|
+
|
|
|
|
|
+/*
|
|
|
|
@@ -55,7 +55,7 @@ Index: config.sample.inc.php
|
|
|
|
|
|
|
|
|
|
/*
|
|
|
|
|
* Servers configuration
|
|
|
|
|
@@ -25,43 +66,230 @@ $i = 0;
|
|
|
|
|
@@ -25,47 +66,247 @@ $i = 0;
|
|
|
|
|
* First server
|
|
|
|
|
*/
|
|
|
|
|
$i++;
|
|
|
|
@@ -134,97 +134,18 @@ Index: config.sample.inc.php
|
|
|
|
|
/*
|
|
|
|
|
* phpMyAdmin configuration storage settings.
|
|
|
|
|
*/
|
|
|
|
|
+$cfg['Servers'][$i]['controlhost'] = '';
|
|
|
|
|
+
|
|
|
|
|
+$cfg['Servers'][$i]['controlhost'] = 'localhost';
|
|
|
|
|
|
|
|
|
|
-/* User used to manipulate with storage */
|
|
|
|
|
-// $cfg['Servers'][$i]['controlhost'] = '';
|
|
|
|
|
-// $cfg['Servers'][$i]['controlport'] = '';
|
|
|
|
|
-// $cfg['Servers'][$i]['controluser'] = 'pma';
|
|
|
|
|
-// $cfg['Servers'][$i]['controlpass'] = 'pmapass';
|
|
|
|
|
+// MySQL control user settings (this user must have read-only
|
|
|
|
|
+// access to the "mysql/user" and "mysql/db" tables).
|
|
|
|
|
+// The controluser is also used for all relational features (pmadb)
|
|
|
|
|
+$cfg['Servers'][$i]['controluser'] = '';
|
|
|
|
|
+
|
|
|
|
|
+// The password needed for the controluser to login
|
|
|
|
|
+// (see $cfg['Servers'][$i]['controluser'])
|
|
|
|
|
+$cfg['Servers'][$i]['controlpass'] = '';
|
|
|
|
|
+
|
|
|
|
|
+// Database used for Relation, Bookmark and PDF Features
|
|
|
|
|
+// (see _docdir/examples/create_tables.sql)
|
|
|
|
|
+// - leave blank for no support
|
|
|
|
|
+// DEFAULT: 'phpmyadmin'
|
|
|
|
|
+$cfg['Servers'][$i]['pmadb'] = '';
|
|
|
|
|
+
|
|
|
|
|
+// Bookmark table
|
|
|
|
|
+// - leave blank for no bookmark support
|
|
|
|
|
+// DEFAULT: 'pma_bookmark'
|
|
|
|
|
+$cfg['Servers'][$i]['bookmarktable'] = '';
|
|
|
|
|
+
|
|
|
|
|
+// table to describe the relation between links (see doc)
|
|
|
|
|
+// - leave blank for no relation-links support
|
|
|
|
|
+// DEFAULT: 'pma_relation'
|
|
|
|
|
+$cfg['Servers'][$i]['relation'] = '';
|
|
|
|
|
+
|
|
|
|
|
+// table to describe the display fields
|
|
|
|
|
+// - leave blank for no display fields support
|
|
|
|
|
+// DEFAULT: 'pma_table_info'
|
|
|
|
|
+$cfg['Servers'][$i]['table_info'] = '';
|
|
|
|
|
+
|
|
|
|
|
+// table to describe the tables position for the PDF schema
|
|
|
|
|
+// - leave blank for no PDF schema support
|
|
|
|
|
+// DEFAULT: 'pma_table_coords'
|
|
|
|
|
+$cfg['Servers'][$i]['table_coords'] = '';
|
|
|
|
|
+
|
|
|
|
|
+// table to describe pages of relationpdf
|
|
|
|
|
+// - leave blank if you don't want to use this
|
|
|
|
|
+// DEFAULT: 'pma_pdf_pages'
|
|
|
|
|
+$cfg['Servers'][$i]['pdf_pages'] = '';
|
|
|
|
|
+
|
|
|
|
|
+// table to store column information
|
|
|
|
|
+// - leave blank for no column comments/mime types
|
|
|
|
|
+// DEFAULT: 'pma_column_info'
|
|
|
|
|
+$cfg['Servers'][$i]['column_info'] = '';
|
|
|
|
|
+
|
|
|
|
|
+// table to store SQL history
|
|
|
|
|
+// - leave blank for no SQL query history
|
|
|
|
|
+// DEFAULT: 'pma_history'
|
|
|
|
|
+$cfg['Servers'][$i]['history'] = '';
|
|
|
|
|
+
|
|
|
|
|
+// Table to store user interface enhancement data.
|
|
|
|
|
+// - Leave blank to disable.
|
|
|
|
|
+// DEFAULT: 'pma_table_uiprefs'
|
|
|
|
|
+$cfg['Servers'][$i]['table_uiprefs'] = 'pma_table_uiprefs';
|
|
|
|
|
+
|
|
|
|
|
+// Table to store version/change tracking data
|
|
|
|
|
+// - leave blank to disable
|
|
|
|
|
+// DEFAULT: 'pma_tracking'
|
|
|
|
|
+$cfg['Servers'][$i]['tracking'] = 'pma_tracking';
|
|
|
|
|
+
|
|
|
|
|
+// Table in which to store information for the designer feature.
|
|
|
|
|
+// DEFAULT: 'pma_designer_coords'
|
|
|
|
|
+$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
|
|
|
|
|
+
|
|
|
|
|
+// Table to store user preferences -- allows users to set most
|
|
|
|
|
+// preferences by themselves and store them in the phpMyAdmin
|
|
|
|
|
+// configuration storage database.
|
|
|
|
|
+// If you don't allow for storing preferences in pmadb, users can
|
|
|
|
|
+// still personalize phpMyAdmin, but settings will be saved in
|
|
|
|
|
+// browser's local storage, or, it is is unavailable, until the end
|
|
|
|
|
+// of session.
|
|
|
|
|
+// DEFAULT: 'pma_userconfig'
|
|
|
|
|
+$cfg['Servers'][$i]['userconfig'] = 'pma_userconfig';
|
|
|
|
|
+
|
|
|
|
|
+// Table to store a list of recently used tables to be shown in the
|
|
|
|
|
+// left navigation frame. It helps you to jump across table directly,
|
|
|
|
|
+// without the need to select the database, and then select the table.
|
|
|
|
|
+// Using $cfg['LeftRecentTable'] you can configure the maximum number
|
|
|
|
|
+// of recent tables shown.
|
|
|
|
|
+// Without configuring the storage, you can still access the recently
|
|
|
|
|
+// used tables, but it will disappear after you logout.
|
|
|
|
|
+// DEFAULT: 'pma_recent'
|
|
|
|
|
+$cfg['Servers'][$i]['recent'] = 'pma_recent';
|
|
|
|
|
|
|
|
|
|
-/* User used to manipulate with storage */
|
|
|
|
|
-// $cfg['Servers'][$i]['controlhost'] = '';
|
|
|
|
|
-// $cfg['Servers'][$i]['controluser'] = 'pma';
|
|
|
|
|
-// $cfg['Servers'][$i]['controlpass'] = 'pmapass';
|
|
|
|
|
-
|
|
|
|
|
-/* Storage database and tables */
|
|
|
|
|
-// $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
|
|
|
|
|
-// $cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';
|
|
|
|
@@ -239,6 +160,102 @@ Index: config.sample.inc.php
|
|
|
|
|
-// $cfg['Servers'][$i]['designer_coords'] = 'pma__designer_coords';
|
|
|
|
|
-// $cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
|
|
|
|
|
-// $cfg['Servers'][$i]['recent'] = 'pma__recent';
|
|
|
|
|
-// $cfg['Servers'][$i]['users'] = 'pma__users';
|
|
|
|
|
-// $cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
|
|
|
|
|
-// $cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
|
|
|
|
|
+// The password needed for the controluser to login
|
|
|
|
|
+// (see $cfg['Servers'][$i]['controluser'])
|
|
|
|
|
+$cfg['Servers'][$i]['controlpass'] = '';
|
|
|
|
|
+
|
|
|
|
|
+// Database used for Relation, Bookmark and PDF Features
|
|
|
|
|
+// (see _docdir/examples/create_tables.sql)
|
|
|
|
|
+// - leave blank for no support
|
|
|
|
|
+// DEFAULT: 'phpmyadmin'
|
|
|
|
|
+$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
|
|
|
|
|
+
|
|
|
|
|
+// Bookmark table
|
|
|
|
|
+// - leave blank for no bookmark support
|
|
|
|
|
+// DEFAULT: 'pma_bookmark'
|
|
|
|
|
+$cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';
|
|
|
|
|
+
|
|
|
|
|
+// table to describe the relation between links (see doc)
|
|
|
|
|
+// - leave blank for no relation-links support
|
|
|
|
|
+// DEFAULT: 'pma_relation'
|
|
|
|
|
+$cfg['Servers'][$i]['relation'] = 'pma__relation';
|
|
|
|
|
+
|
|
|
|
|
+// table to describe the display fields
|
|
|
|
|
+// - leave blank for no display fields support
|
|
|
|
|
+// DEFAULT: 'pma_table_info'
|
|
|
|
|
+$cfg['Servers'][$i]['table_info'] = 'pma__table_info';
|
|
|
|
|
+
|
|
|
|
|
+// table to describe the tables position for the PDF schema
|
|
|
|
|
+// - leave blank for no PDF schema support
|
|
|
|
|
+// DEFAULT: 'pma_table_coords'
|
|
|
|
|
+$cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';
|
|
|
|
|
+
|
|
|
|
|
+// table to describe pages of relationpdf
|
|
|
|
|
+// - leave blank if you don't want to use this
|
|
|
|
|
+// DEFAULT: 'pma_pdf_pages'
|
|
|
|
|
+$cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';
|
|
|
|
|
+
|
|
|
|
|
+// table to store column information
|
|
|
|
|
+// - leave blank for no column comments/mime types
|
|
|
|
|
+// DEFAULT: 'pma_column_info'
|
|
|
|
|
+$cfg['Servers'][$i]['column_info'] = 'pma__column_info';
|
|
|
|
|
+
|
|
|
|
|
+// table to store SQL history
|
|
|
|
|
+// - leave blank for no SQL query history
|
|
|
|
|
+// DEFAULT: 'pma_history'
|
|
|
|
|
+$cfg['Servers'][$i]['history'] = 'pma__history';
|
|
|
|
|
+
|
|
|
|
|
+// Table to store user interface enhancement data.
|
|
|
|
|
+// - Leave blank to disable.
|
|
|
|
|
+// DEFAULT: 'pma_table_uiprefs'
|
|
|
|
|
+$cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';
|
|
|
|
|
+
|
|
|
|
|
+// Table to store version/change tracking data
|
|
|
|
|
+// - leave blank to disable
|
|
|
|
|
+// DEFAULT: 'pma_tracking'
|
|
|
|
|
+$cfg['Servers'][$i]['tracking'] = 'pma__tracking';
|
|
|
|
|
+
|
|
|
|
|
+// Table in which to store information for the designer feature.
|
|
|
|
|
+// DEFAULT: 'pma_designer_coords'
|
|
|
|
|
+$cfg['Servers'][$i]['designer_coords'] = 'pma__designer_coords';
|
|
|
|
|
+
|
|
|
|
|
+// Table to store user preferences -- allows users to set most
|
|
|
|
|
+// preferences by themselves and store them in the phpMyAdmin
|
|
|
|
|
+// configuration storage database.
|
|
|
|
|
+// If you don't allow for storing preferences in pmadb, users can
|
|
|
|
|
+// still personalize phpMyAdmin, but settings will be saved in
|
|
|
|
|
+// browser's local storage, or, it is is unavailable, until the end
|
|
|
|
|
+// of session.
|
|
|
|
|
+// DEFAULT: 'pma_userconfig'
|
|
|
|
|
+$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
|
|
|
|
|
+
|
|
|
|
|
+// Table to store a list of recently used tables to be shown in the
|
|
|
|
|
+// left navigation frame. It helps you to jump across table directly,
|
|
|
|
|
+// without the need to select the database, and then select the table.
|
|
|
|
|
+// Using $cfg['LeftRecentTable'] you can configure the maximum number
|
|
|
|
|
+// of recent tables shown.
|
|
|
|
|
+// Without configuring the storage, you can still access the recently
|
|
|
|
|
+// used tables, but it will disappear after you logout.
|
|
|
|
|
+// DEFAULT: 'pma_recent'
|
|
|
|
|
+$cfg['Servers'][$i]['recent'] = 'pma__recent';
|
|
|
|
|
+
|
|
|
|
|
+// You can create different user groups with menu items attached to them.
|
|
|
|
|
+// Users can be assigned to these groups and the logged in user
|
|
|
|
|
+// would only see menu items configured to the usergroup he is assigned to.
|
|
|
|
|
+// To do this it needs two tables “usergroups” (storing allowed menu items for each user group)
|
|
|
|
|
+// and “users” (storing users and their assignments to user groups).
|
|
|
|
|
+// DEFAULT: 'pma_users'
|
|
|
|
|
+// DEFAULT: 'pma_usergroups'
|
|
|
|
|
+$cfg['Servers'][$i]['users'] = 'pma__users';
|
|
|
|
|
+$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
|
|
|
|
|
+
|
|
|
|
|
+// You can hide/show items in the navigation tree.
|
|
|
|
|
+// DEFAULT: 'pma_navigationhiding'
|
|
|
|
|
+$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
|
|
|
|
|
+
|
|
|
|
|
/* Contrib / Swekey authentication */
|
|
|
|
|
-// $cfg['Servers'][$i]['auth_swekey_config'] = '/etc/swekey-pma.conf';
|
|
|
|
|
+// The name of the file containing Swekey ids and login names for
|
|
|
|
@@ -253,10 +270,10 @@ Index: config.sample.inc.php
|
|
|
|
|
+ */
|
|
|
|
|
+
|
|
|
|
|
+/*
|
|
|
|
|
++$i++;
|
|
|
|
|
++$cfg['Servers'][$i]['host'] = 'localhost';
|
|
|
|
|
++$cfg['Servers'][$i]['port'] = '';
|
|
|
|
|
++$cfg['Servers'][$i]['socket'] = '';
|
|
|
|
|
+$i++;
|
|
|
|
|
+$cfg['Servers'][$i]['host'] = 'localhost';
|
|
|
|
|
+$cfg['Servers'][$i]['port'] = '';
|
|
|
|
|
+$cfg['Servers'][$i]['socket'] = '';
|
|
|
|
|
+$cfg['Servers'][$i]['ssl'] = false;
|
|
|
|
|
+$cfg['Servers'][$i]['connect_type'] = 'socket';
|
|
|
|
|
+$cfg['Servers'][$i]['extension'] = 'mysqli';
|
|
|
|
@@ -275,28 +292,31 @@ Index: config.sample.inc.php
|
|
|
|
|
+$cfg['Servers'][$i]['AllowDeny']['order'] = '';
|
|
|
|
|
+$cfg['Servers'][$i]['AllowDeny']['rules'] = array();
|
|
|
|
|
+*/
|
|
|
|
|
|
|
|
|
|
/*
|
|
|
|
|
+
|
|
|
|
|
+/*
|
|
|
|
|
+ * phpMyAdmin configuration storage settings.
|
|
|
|
|
+ */
|
|
|
|
|
+
|
|
|
|
|
+/*
|
|
|
|
|
+$cfg['Servers'][$i]['controlhost'] = '';
|
|
|
|
|
|
|
|
|
|
/*
|
|
|
|
|
+$cfg['Servers'][$i]['controlhost'] = 'localhost';
|
|
|
|
|
+$cfg['Servers'][$i]['controluser'] = '';
|
|
|
|
|
+$cfg['Servers'][$i]['controlpass'] = '';
|
|
|
|
|
+$cfg['Servers'][$i]['pmadb'] = '';
|
|
|
|
|
+$cfg['Servers'][$i]['bookmarktable'] = '';
|
|
|
|
|
+$cfg['Servers'][$i]['relation'] = '';
|
|
|
|
|
+$cfg['Servers'][$i]['table_info'] = '';
|
|
|
|
|
+$cfg['Servers'][$i]['table_coords'] = '';
|
|
|
|
|
+$cfg['Servers'][$i]['pdf_pages'] = '';
|
|
|
|
|
+$cfg['Servers'][$i]['column_info'] = '';
|
|
|
|
|
+$cfg['Servers'][$i]['history'] = '';
|
|
|
|
|
+$cfg['Servers'][$i]['table_uiprefs'] = 'pma_table_uiprefs';
|
|
|
|
|
+$cfg['Servers'][$i]['tracking'] = 'pma_tracking';
|
|
|
|
|
+$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
|
|
|
|
|
+$cfg['Servers'][$i]['userconfig'] = 'pma_userconfig';
|
|
|
|
|
+$cfg['Servers'][$i]['recent'] = 'pma_recent';
|
|
|
|
|
+$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
|
|
|
|
|
+$cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';
|
|
|
|
|
+$cfg['Servers'][$i]['relation'] = 'pma__relation';
|
|
|
|
|
+$cfg['Servers'][$i]['table_info'] = 'pma__table_info';
|
|
|
|
|
+$cfg['Servers'][$i]['table_coords'] = 'pma__table_cords';
|
|
|
|
|
+$cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';
|
|
|
|
|
+$cfg['Servers'][$i]['column_info'] = 'pma__column_info';
|
|
|
|
|
+$cfg['Servers'][$i]['history'] = 'pma__history';
|
|
|
|
|
+$cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';
|
|
|
|
|
+$cfg['Servers'][$i]['tracking'] = 'pma__tracking';
|
|
|
|
|
+$cfg['Servers'][$i]['designer_coords'] = 'pma__designer_coords';
|
|
|
|
|
+$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
|
|
|
|
|
+$cfg['Servers'][$i]['recent'] = 'pma__recent';
|
|
|
|
|
+$cfg['Servers'][$i]['users'] = 'pma__users';
|
|
|
|
|
+$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
|
|
|
|
|
+$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
|
|
|
|
|
+$cfg['Servers'][$i]['auth_swekey_config'] = '/etc/phpMyAdmin/swekey-pma_02.conf';
|
|
|
|
|
+*/
|
|
|
|
|
+
|
|
|
|
@@ -314,9 +334,9 @@ Index: config.sample.inc.php
|
|
|
|
|
+/***************************************
|
|
|
|
|
* End of servers configuration
|
|
|
|
|
*/
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Index: libraries/vendor_config.php
|
|
|
|
|
===================================================================
|
|
|
|
|
===================================================================
|
|
|
|
|
--- libraries/vendor_config.php.orig
|
|
|
|
|
+++ libraries/vendor_config.php
|
|
|
|
|
@@ -17,18 +17,18 @@ if (! defined('PHPMYADMIN')) {
|
|
|
|
|