3 * Description of options with non-standard values, list of persistent options
4 * and validator assignments.
6 * By default data types are taken from config.default.php, here we define
7 * only allowed values for select fields and type overrides.
9 * @package phpMyAdmin-setup
10 * @license http://www.gnu.org/licenses/gpl.html GNU GPL 2.0
14 if (!defined('PHPMYADMIN')) {
21 require_once('./libraries/vendor_config.php');
25 // path to config file, relative to phpMyAdmin's root path
26 $cfg_db['_config_file_path'] = SETUP_CONFIG_FILE
;
30 * o array - select field, array contains allowed values
31 * o string - type override
33 * Use normal array, paths won't be expanded
35 $cfg_db['Servers'] = array(1 => array(
37 'connect_type' => array('tcp', 'socket'),
38 'extension' => array('mysql', 'mysqli'),
39 'auth_type' => array('config', 'http', 'signon', 'cookie'),
41 'order' => array('', 'deny,allow', 'allow,deny', 'explicit')),
42 'only_db' => 'array'));
43 $cfg_db['RecodingEngine'] = array('auto', 'iconv', 'recode');
44 $cfg_db['DefaultCharset'] = $GLOBALS['cfg']['AvailableCharsets'];
45 $cfg_db['OBGzip'] = array('auto', true, false);
46 $cfg_db['ShowTooltipAliasTB'] = array('nested', true, false);
47 $cfg_db['DisplayDatabasesList'] = array('auto', true, false);
48 $cfg_db['LeftLogoLinkWindow'] = array('main', 'new');
49 $cfg_db['LeftDefaultTabTable'] = array(
50 'tbl_structure.php', // fields list
51 'tbl_sql.php', // SQL form
52 'tbl_select.php', // search page
53 'tbl_change.php', // insert row page
54 'sql.php'); // browse page
55 $cfg_db['NavigationBarIconic'] = array(true, false, 'both');
56 $cfg_db['Order'] = array('ASC', 'DESC', 'SMART');
57 $cfg_db['ProtectBinary'] = array(false, 'blob', 'all');
58 $cfg_db['CharEditing'] = array('input', 'textarea');
59 $cfg_db['PropertiesIconic'] = array(true, false, 'both');
60 $cfg_db['DefaultTabServer'] = array(
61 'main.php', // the welcome page (recommended for multiuser setups)
62 'server_databases.php', // list of databases
63 'server_status.php', // runtime information
64 'server_variables.php', // MySQL server variables
65 'server_privileges.php', // user management
66 'server_processlist.php'); // process list
67 $cfg_db['DefaultTabDatabase'] = array(
68 'db_structure.php', // tables list
69 'db_sql.php', // SQL form
70 'db_search.php', // search query
71 'db_operations.php'); // operations on database
72 $cfg_db['DefaultTabTable'] = array(
73 'tbl_structure.php', // fields list
74 'tbl_sql.php', // SQL form
75 'tbl_select.php', // search page
76 'tbl_change.php', // insert row page
77 'sql.php'); // browse page
78 $cfg_db['QueryWindowDefTab'] = array(
80 'files', // Import files
81 'history', // SQL history
82 'full'); // All (SQL and SQL history)
83 $cfg_db['Import']['format'] = array(
86 'ldi', // CSV using LOAD DATA
88 $cfg_db['Import']['sql_compatibility'] = array(
89 'NONE', 'ANSI', 'DB2', 'MAXDB', 'MYSQL323', 'MYSQL40', 'MSSQL', 'ORACLE',
90 // removed; in MySQL 5.0.33, this produces exports that
91 // can't be read by POSTGRESQL (see our bug #1596328)
94 $cfg_db['Import']['ldi_local_option'] = array('auto', true, false);
95 $cfg_db['Export']['format'] = array('codegen', 'csv', 'excel', 'htmlexcel',
96 'htmlword', 'latex', 'ods', 'odt', 'pdf', 'sql', 'texytext', 'xls', 'xml',
98 $cfg_db['Export']['compression'] = array('none', 'zip', 'gzip', 'bzip2');
99 $cfg_db['Export']['charset'] = array_merge(array(''), $GLOBALS['cfg']['AvailableCharsets']);
102 * Config options which will be placed in config file even if they are set
103 * to their default values (use only full paths)
105 $persist_keys = array(
114 'Servers/1/extension',
115 'Servers/1/connect_type',
116 'Servers/1/auth_type',
118 'Servers/1/password');
121 * Default values overrides
122 * Use only full paths
124 $cfg_db['_overrides'] = array();
125 $cfg_db['_overrides']['Servers/1/extension'] = extension_loaded('mysqli')
126 ?
'mysqli' : 'mysql';
129 * Validator assignments (functions from validate.lib.php and 'validators'
130 * object in scripts.js)
131 * Use only full paths and form ids
133 $cfg_db['_validators'] = array(
134 'Server' => 'validate_server',
135 'Server_pmadb' => 'validate_pmadb',
136 'Servers/1/port' => 'validate_port_number',
137 'Servers/1/hide_db' => 'validate_regex',
138 'TrustedProxies' => 'validate_trusted_proxies',
139 'LoginCookieValidity' => 'validate_positive_number',
140 'LoginCookieStore' => 'validate_non_negative_number',
141 'QueryHistoryMax' => 'validate_positive_number',
142 'LeftFrameTableLevel' => 'validate_positive_number',
143 'MaxRows' => 'validate_positive_number',
144 'CharTextareaCols' => 'validate_positive_number',
145 'CharTextareaRows' => 'validate_positive_number',
146 'InsertRows' => 'validate_positive_number',
147 'ForeignKeyMaxLimit' => 'validate_positive_number',
148 'Import/skip_queries' => 'validate_non_negative_number');