New configuration directives/language variables for following patches (see
[phpmyadmin/crack.git] / config.inc.php3
bloba7c64d391777bafc55ce0edf77c39c5458a6a7fe
1 <?php
2 /* $Id$ */
3 // vim: expandtab sw=4 ts=4 sts=4:
5 /**
6 * phpMyAdmin Configuration File
8 * All directives are explained in Documentation.html
9 */
12 /**
13 * Sets the php error reporting - Please do not change this line!
15 if (!isset($old_error_reporting)) {
16 error_reporting(E_ALL);
17 @ini_set('display_errors', '1');
21 /**
22 * Your phpMyAdmin url
24 * Complete the variable below with the full url ie
25 * http://www.your_web.net/path_to_your_phpMyAdmin_directory/
27 * It must contain characters that are valid for a URL, and the path is
28 * case sensitive on some Web servers, for example Unix-based servers.
30 * In most cases you can leave this variable empty, as the correct value
31 * will be detected automatically. However, we recommend that you do
32 * test to see that the auto-detection code works in your system. A good
33 * test is to browse a table, then edit a row and save it. There will be
34 * an error message if phpMyAdmin cannot auto-detect the correct value.
36 * If the auto-detection code does work properly, you can set to TRUE the
37 * $cfg['PmaAbsoluteUri_DisableWarning'] variable below.
39 $cfg['PmaAbsoluteUri'] = '';
42 /**
43 * Disable the default warning about $cfg['PmaAbsoluteUri'] not being set
44 * You should use this if and ONLY if the PmaAbsoluteUri auto-detection
45 * works perfectly.
47 $cfg['PmaAbsoluteUri_DisableWarning'] = FALSE;
49 /**
50 * Disable the default warning that is displayed on the DB Details Structure page if
51 * any of the required Tables for the relationfeatures could not be found
53 $cfg['PmaNoRelation_DisableWarning'] = FALSE;
56 /**
57 * Server(s) configuration
59 $i = 0;
60 // The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use $cfg['Servers'][0].
61 // You can disable a server config entry by setting host to ''.
62 $i++;
63 $cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname
64 $cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port
65 $cfg['Servers'][$i]['socket'] = ''; // Path to the socket - leave blank for default socket
66 $cfg['Servers'][$i]['connect_type'] = 'tcp'; // How to connect to MySQL server ('tcp' or 'socket')
67 $cfg['Servers'][$i]['compress'] = FALSE; // Use compressed protocol for the MySQL connection
68 // (requires PHP >= 4.3.0)
69 $cfg['Servers'][$i]['controluser'] = ''; // MySQL control user settings
70 // (this user must have read-only
71 $cfg['Servers'][$i]['controlpass'] = ''; // access to the "mysql/user"
72 // and "mysql/db" tables)
73 $cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?
74 $cfg['Servers'][$i]['user'] = 'root'; // MySQL user
75 $cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed
76 // with 'config' auth_type)
77 $cfg['Servers'][$i]['only_db'] = ''; // If set to a db-name, only
78 // this db is displayed
79 // at left frame
80 // It may also be an array
81 // of db-names
82 $cfg['Servers'][$i]['verbose'] = ''; // Verbose name for this host - leave blank to show the hostname
84 $cfg['Servers'][$i]['pmadb'] = ''; // Database used for Relation, Bookmark and PDF Features
85 // - leave blank for no support
86 $cfg['Servers'][$i]['bookmarktable'] = ''; // Bookmark table - leave blank for no bookmark support
87 $cfg['Servers'][$i]['relation'] = ''; // table to describe the relation between links (see doc)
88 // - leave blank for no relation-links support
89 $cfg['Servers'][$i]['table_info'] = ''; // table to describe the display fields
90 // - leave blank for no display fields support
91 $cfg['Servers'][$i]['table_coords'] = ''; // table to describe the tables position for the PDF
92 // schema - leave blank for no PDF schema support
93 $cfg['Servers'][$i]['pdf_pages'] = ''; // table to describe pages of relationpdf
94 // - leave blank if you don't want to use this
95 $cfg['Servers'][$i]['column_comments'] // table to store columncomments
96 = ''; // - leave blank if you don't want to use this
97 $cfg['Servers'][$i]['AllowDeny']['order'] // Host authentication order, leave blank to not use
98 = '';
99 $cfg['Servers'][$i]['AllowDeny']['rules'] // Host authentication rules, leave blank for defaults
100 = array();
103 $i++;
104 $cfg['Servers'][$i]['host'] = '';
105 $cfg['Servers'][$i]['port'] = '';
106 $cfg['Servers'][$i]['socket'] = '';
107 $cfg['Servers'][$i]['connect_type'] = 'tcp';
108 $cfg['Servers'][$i]['compress'] = FALSE;
109 $cfg['Servers'][$i]['controluser'] = '';
110 $cfg['Servers'][$i]['controlpass'] = '';
111 $cfg['Servers'][$i]['auth_type'] = 'config';
112 $cfg['Servers'][$i]['user'] = 'root';
113 $cfg['Servers'][$i]['password'] = '';
114 $cfg['Servers'][$i]['only_db'] = '';
115 $cfg['Servers'][$i]['verbose'] = '';
116 $cfg['Servers'][$i]['pmadb'] = '';
117 $cfg['Servers'][$i]['bookmarktable'] = '';
118 $cfg['Servers'][$i]['relation'] = '';
119 $cfg['Servers'][$i]['table_info'] = '';
120 $cfg['Servers'][$i]['table_coords'] = '';
121 $cfg['Servers'][$i]['pdf_pages'] = '';
122 $cfg['Servers'][$i]['column_comments'] = '';
123 $cfg['Servers'][$i]['AllowDeny']['order']
124 = '';
125 $cfg['Servers'][$i]['AllowDeny']['rules']
126 = array();
128 $i++;
129 $cfg['Servers'][$i]['host'] = '';
130 $cfg['Servers'][$i]['port'] = '';
131 $cfg['Servers'][$i]['socket'] = '';
132 $cfg['Servers'][$i]['connect_type'] = 'tcp';
133 $cfg['Servers'][$i]['compress'] = FALSE;
134 $cfg['Servers'][$i]['controluser'] = '';
135 $cfg['Servers'][$i]['controlpass'] = '';
136 $cfg['Servers'][$i]['auth_type'] = 'config';
137 $cfg['Servers'][$i]['user'] = 'root';
138 $cfg['Servers'][$i]['password'] = '';
139 $cfg['Servers'][$i]['only_db'] = '';
140 $cfg['Servers'][$i]['verbose'] = '';
141 $cfg['Servers'][$i]['pmadb'] = '';
142 $cfg['Servers'][$i]['bookmarktable'] = '';
143 $cfg['Servers'][$i]['relation'] = '';
144 $cfg['Servers'][$i]['table_info'] = '';
145 $cfg['Servers'][$i]['table_coords'] = '';
146 $cfg['Servers'][$i]['pdf_pages'] = '';
147 $cfg['Servers'][$i]['column_comments'] = '';
148 $cfg['Servers'][$i]['AllowDeny']['order']
149 = '';
150 $cfg['Servers'][$i]['AllowDeny']['rules']
151 = array();
153 // If you have more than one server configured, you can set $cfg['ServerDefault']
154 // to any one of them to autoconnect to that server when phpMyAdmin is started,
155 // or set it to 0 to be given a list of servers without logging in
156 // If you have only one server configured, $cfg['ServerDefault'] *MUST* be
157 // set to that server.
158 $cfg['ServerDefault'] = 1; // Default server (0 = no default server)
159 $cfg['Server'] = '';
160 unset($cfg['Servers'][0]);
164 * Other core phpMyAdmin settings
166 $cfg['OBGzip'] = TRUE; // use GZIP output buffering if possible
167 $cfg['PersistentConnections'] = FALSE; // use persistent connections to MySQL database
168 $cfg['ExecTimeLimit'] = 300; // maximum execution time in seconds (0 for no limit)
169 $cfg['SkipLockedTables'] = FALSE; // mark used tables, make possible to show
170 // locked tables (since MySQL 3.23.30)
171 $cfg['ShowSQL'] = TRUE; // show SQL queries as run
172 $cfg['AllowUserDropDatabase'] = FALSE; // show a 'Drop database' link to normal users
173 $cfg['Confirm'] = TRUE; // confirm 'DROP TABLE' & 'DROP DATABASE'
174 $cfg['LoginCookieRecall'] = TRUE; // recall previous login in cookie auth. mode or not
175 $cfg['UseDbSearch'] = TRUE; // whether to enable the "database search" feature
176 // or not
178 // Left frame setup
179 $cfg['LeftFrameLight'] = TRUE; // use a select-based menu and display only the
180 // current tables in the left frame.
181 $cfg['ShowTooltip'] = TRUE; // display table comment as tooltip in left frame
182 $cfg['ShowTooltipAliasDB'] = FALSE; // if ShowToolTip is enabled, this defines that table/db comments
183 $cfg['ShowTooltipAliasTB'] = FALSE; // are shown (in the left menu and db_details_structure) instead of
184 // table/db names
186 $cfg['LeftDisplayLogo'] = TRUE; // display logo at top of left frame
188 // In the main frame, at startup...
189 $cfg['ShowStats'] = TRUE; // allow to display statistics and space usage in
190 // the pages about database details and table
191 // properties
192 $cfg['ShowMysqlInfo'] = FALSE; // whether to display the "MySQL runtime
193 $cfg['ShowMysqlVars'] = FALSE; // information", "MySQL system variables", "PHP
194 $cfg['ShowPhpInfo'] = FALSE; // information" and "change password" links for
195 $cfg['ShowChgPassword'] = FALSE; // simple users or not
196 $cfg['SuggestDBName'] = TRUE; // suggest a new DB name if possible (false = keep empty)
198 // In browse mode...
199 $cfg['ShowBlob'] = FALSE; // display blob field contents
200 $cfg['NavigationBarIconic'] = TRUE; // do not display text inside navigation bar buttons
201 $cfg['ShowAll'] = FALSE; // allows to display all the rows
202 $cfg['MaxRows'] = 30; // maximum number of rows to display
203 $cfg['Order'] = 'ASC'; // default for 'ORDER BY' clause (valid
204 // values are 'ASC', 'DESC' or 'SMART' -ie
205 // descending order for fields of type
206 // TIME, DATE, DATETIME & TIMESTAMP,
207 // ascending order else-)
209 // In edit mode...
210 $cfg['ProtectBinary'] = 'blob'; // disallow editing of binary fields
211 // valid values are:
212 // FALSE allow editing
213 // 'blob' allow editing except for BLOB fields
214 // 'all' disallow editing
215 $cfg['ShowFunctionFields'] = TRUE; // Display the function fields in edit/insert mode
216 $cfg['CharEditing'] = 'input';
217 // Which editor should be used for CHAR/VARCHAR fields:
218 // input - allows limiting of input length
219 // textarea - allows newlines in fields
221 // For the export features...
222 $cfg['ZipDump'] = TRUE; // Allow the use of zip/gzip/bzip
223 $cfg['GZipDump'] = TRUE; // compression for
224 $cfg['BZipDump'] = TRUE; // dump files
226 // Default Tabs display settings
227 $cfg['DefaultTabServer'] = 'main.php3';
228 // Possible values:
229 // 'main.php3' = the welcome page
230 // (recommended for multiuser setups)
231 // 'server_databases.php3' = list of databases
232 // 'server_status.php3' = runtime information
233 // 'server_variables.php3' = MySQL server variables
234 // 'server_privileges.php3' = user management
235 // 'server_processlist.php3' = process list
236 $cfg['DefaultTabDatabase'] = 'db_details_structure.php3';
237 // Possible values:
238 // 'db_details_structure.php3' = tables list
239 // 'db_details.php3' = sql form
240 // 'db_search.php3' = search query
241 $cfg['DefaultTabTable'] = 'tbl_properties_structure.php3';
242 // Possible values:
243 // 'tbl_properties_structure.php3' = fields list
244 // 'tbl_properties.php3' = sql form
245 // 'tbl_select.php3 = select page
246 // 'tbl_change.php3 = insert row page
250 * Link to the official MySQL documentation.
251 * Be sure to include no trailing slash on the path.
252 * See http://www.mysql.com/documentation/index.html for more information
253 * about MySQL manuals and their types.
255 $cfg['MySQLManualBase'] = 'http://www.mysql.com/doc/en';
258 * Type of MySQL documentation:
259 * old - old style used in phpMyAdmin 2.3.0 and sooner
260 * searchable - "Searchable, with user comments"
261 * chapters - "HTML, one page per chapter"
262 * big - "HTML, all on one page"
263 * none - do not show documentation links
265 $cfg['MySQLManualType'] = 'searchable';
269 * Language and charset conversion settings
271 // Default language to use, if not browser-defined or user-defined
272 $cfg['DefaultLang'] = 'en-iso-8859-1';
274 // Force: always use this language - must be defined in
275 // libraries/select_lang.lib.php3
276 // $cfg['Lang'] = 'en-iso-8859-1';
278 // Default charset to use for recoding of MySQL queries, does not take
279 // any effect when charsets recoding is switched off by
280 // $cfg['AllowAnywhereRecoding'] or in language file
281 // (see $cfg['AvailableCharsets'] to possible choices, you can add your own)
282 $cfg['DefaultCharset'] = 'iso-8859-1';
284 // Allow charset recoding of MySQL queries, must be also enabled in language
285 // file to make harder using other language files than unicode.
286 // Default value is FALSE to avoid problems on servers without the iconv
287 // extension and where dl() is not supported
288 $cfg['AllowAnywhereRecoding'] = FALSE;
290 // You can select here which functions will be used for charset conversion.
291 // Possible values are:
292 // auto - automatically use available one (first is tested iconv, then
293 // recode)
294 // iconv - use iconv or libiconv functions
295 // recode - use recode_string function
296 $cfg['RecodingEngine'] = 'auto';
298 // Available charsets for MySQL conversion. currently contains all which could
299 // be found in lang/* files and few more.
300 // Charsets will be shown in same order as here listed, so if you frequently
301 // use some of these move them to the top.
302 $cfg['AvailableCharsets'] = array(
303 'iso-8859-1',
304 'iso-8859-2',
305 'iso-8859-3',
306 'iso-8859-4',
307 'iso-8859-5',
308 'iso-8859-6',
309 'iso-8859-7',
310 'iso-8859-8',
311 'iso-8859-9',
312 'iso-8859-10',
313 'iso-8859-11',
314 'iso-8859-12',
315 'iso-8859-13',
316 'iso-8859-14',
317 'iso-8859-15',
318 'windows-1250',
319 'windows-1251',
320 'windows-1252',
321 'windows-1257',
322 'koi8-r',
323 'big5',
324 'gb2312',
325 'utf-8',
326 'utf-7',
327 'x-user-defined',
328 'euc-jp',
329 'ks_c_5601-1987',
330 'tis-620',
331 'SHIFT_JIS'
334 // Loads language file
335 require('./libraries/select_lang.lib.php3');
339 * Customization & design
341 $cfg['LeftWidth'] = 150; // left frame width
342 $cfg['LeftBgColor'] = '#D0DCE0'; // background color for the left frame
343 $cfg['RightBgColor'] = '#F5F5F5'; // background color for the right frame
344 $cfg['RightBgImage'] = ''; // path to a background image for the right frame
345 // (leave blank for no background image)
346 $cfg['LeftPointerColor'] = '#CCFFCC'; // color of the pointer in left frame
347 // (blank for no pointer)
348 $cfg['Border'] = 0; // border width on tables
349 $cfg['ThBgcolor'] = '#D3DCE3'; // table header row colour
350 $cfg['BgcolorOne'] = '#CCCCCC'; // table data row colour
351 $cfg['BgcolorTwo'] = '#DDDDDD'; // table data row colour, alternate
352 $cfg['BrowsePointerColor'] = '#CCFFCC'; // color of the pointer in browse mode
353 // (blank for no pointer)
354 $cfg['BrowseMarkerColor'] = '#FFCC99'; // color of the marker (visually marks row
355 // by clicking on it) in browse mode
356 // (blank for no marker)
357 $cfg['TextareaCols'] = 40; // textarea size (columns) in edit mode
358 // (this value will be emphasized (*2) for sql
359 // query textareas)
360 $cfg['TextareaRows'] = 7; // textarea size (rows) in edit mode
361 $cfg['TextareaAutoSelect'] = TRUE; // autoselect when clicking in the textarea of the querybox
362 $cfg['CharTextareaCols'] = 40; // textarea size (columns) for CHAR/VARCHAR
363 $cfg['CharTextareaRows'] = 2; // textarea size (rows) for CHAR/VARCHAR
364 $cfg['LimitChars'] = 50; // max field data length in browse mode
365 $cfg['ModifyDeleteAtLeft'] = TRUE; // show edit/delete links on left side of browse
366 // (or at the top with vertical browse)
367 $cfg['ModifyDeleteAtRight'] = FALSE; // show edit/delete links on right side of browse
368 // (or at the bottom with vertical browse)
369 $cfg['DefaultDisplay'] = 'horizontal'; // default display direction
370 // (horizontal|vertical|horizontalflipped)
371 $cfg['HeaderFlipType'] = 'css'; // table-header rotation via faking or css? (css|fake)
372 $cfg['ShowBrowseComments'] = TRUE; // shows stored relation-comments in 'browse' mode.
373 $cfg['ShowPropertyComments']= TRUE; // shows stored relation-comments in 'table property' mode.
374 $cfg['RepeatCells'] = 100; // repeat header names every X cells? (0 = deactivate)
376 $cfg['QueryFrame'] = TRUE; // displays a new frame where a link to a querybox is always displayed.
377 $cfg['QueryFrameJS'] = TRUE; // whether to use JavaScript functions for opening a new window for SQL commands.
378 // if set to 'false', the target of the querybox is always the right frame.
379 $cfg['QueryFrameDebug'] = FALSE; // display JS debugging link (DEVELOPERS only)
380 $cfg['QueryFrameWidth'] = 750; // Width of Query window
381 $cfg['QueryFrameHeight'] = 300; // Height of Query window
383 +$cfg['BrowseMIME'] = TRUE; // Use MIME-Types (stored in column comments table) for
386 * SQL Query box settings
387 * These are the links display in all of the SQL Query boxes
389 $cfg['SQLQuery']['Edit'] = TRUE; // Edit link to change a query
390 $cfg['SQLQuery']['Explain'] = TRUE; // EXPLAIN on SELECT queries
391 $cfg['SQLQuery']['ShowAsPHP'] = TRUE; // Wrap a query in PHP
392 $cfg['SQLQuery']['Validate'] = FALSE; // Validate a query (see $cfg['SQLValidator'] as well)
396 * web-server upload directory
398 $cfg['UploadDir'] = ''; // for example, './upload/'; you must end it with
399 // a slash, and you leave it empty for no upload
400 // directory
404 * SQL Parser Settings
406 $cfg['SQP']['enable'] = TRUE; // Totally turn off the SQL Parser (not recommended)
407 $cfg['SQP']['fmtType'] = 'html'; // Pretty-printing style to use on queries (html, text, none)
408 $cfg['SQP']['fmtInd'] = '1'; // Amount to indent each level (floats ok)
409 $cfg['SQP']['fmtIndUnit'] = 'em'; // Units for indenting each level (CSS Types - {em,px,pt})
410 $cfg['SQP']['fmtColor'] = array( // Syntax colouring data
411 'comment' => '#808000',
412 'comment_mysql' => '',
413 'comment_ansi' => '',
414 'comment_c' => '',
415 'digit' => '',
416 'digit_hex' => 'teal',
417 'digit_integer' => 'teal',
418 'digit_float' => 'aqua',
419 'punct' => 'fuchsia',
420 'alpha' => '',
421 'alpha_columnType' => '#FF9900',
422 'alpha_columnAttrib' => '#0000FF',
423 'alpha_reservedWord' => '#990099',
424 'alpha_functionName' => '#FF0000',
425 'alpha_identifier' => 'black',
426 'alpha_variable' => '#800000',
427 'quote' => '#008000',
428 'quote_double' => '',
429 'quote_single' => '',
430 'quote_backtick' => ''
435 * If you wish to use the SQL Validator service, you should be
436 * aware of the following:
437 * All SQL statements are stored anonymously for statistical purposes.
438 * Mimer SQL Validator, Copyright 2002 Upright Database Technology.
439 * All rights reserved.
441 $cfg['SQLValidator']['use'] = FALSE; // Make the SQL Validator available
442 $cfg['SQLValidator']['username'] = ''; // If you have a custom username, specify it here (defaults to anonymous)
443 $cfg['SQLValidator']['password'] = ''; // Password for username
446 * Developers ONLY!
447 * To use the following, please install the DBG extension from http://dd.cron.ru/dbg/
449 $cfg['DBG']['enable'] = FALSE; // Make the DBG stuff available
450 $cfg['DBG']['profile']['enable'] = FALSE; // Produce profiling results of PHP
451 $cfg['DBG']['profile']['threshold'] = 0.5; // Threshold of long running code to display
452 // Anything below the threshold is not displayed
456 * MySQL settings
458 // Column types;
459 // varchar, tinyint, text and date are listed first, based on estimated popularity
460 $cfg['ColumnTypes'] = array(
461 'VARCHAR',
462 'TINYINT',
463 'TEXT',
464 'DATE',
465 'SMALLINT',
466 'MEDIUMINT',
467 'INT',
468 'BIGINT',
469 'FLOAT',
470 'DOUBLE',
471 'DECIMAL',
472 'DATETIME',
473 'TIMESTAMP',
474 'TIME',
475 'YEAR',
476 'CHAR',
477 'TINYBLOB',
478 'TINYTEXT',
479 'BLOB',
480 'MEDIUMBLOB',
481 'MEDIUMTEXT',
482 'LONGBLOB',
483 'LONGTEXT',
484 'ENUM',
485 'SET'
488 // Atributes
489 $cfg['AttributeTypes'] = array(
491 'BINARY',
492 'UNSIGNED',
493 'UNSIGNED ZEROFILL'
496 // Available functions
497 if ($cfg['ShowFunctionFields']) {
498 $cfg['Functions'] = array(
499 'ASCII',
500 'CHAR',
501 'SOUNDEX',
502 'LCASE',
503 'UCASE',
504 'NOW',
505 'PASSWORD',
506 'MD5',
507 'ENCRYPT',
508 'RAND',
509 'LAST_INSERT_ID',
510 'COUNT',
511 'AVG',
512 'SUM',
513 'CURDATE',
514 'CURTIME',
515 'FROM_DAYS',
516 'FROM_UNIXTIME',
517 'PERIOD_ADD',
518 'PERIOD_DIFF',
519 'TO_DAYS',
520 'UNIX_TIMESTAMP',
521 'USER',
522 'WEEKDAY',
523 'CONCAT'
525 } // end if
529 * Unset magic_quotes_runtime - do not change!
531 set_magic_quotes_runtime(0);
534 * File Revision - do not change either!
536 $cfg['FileRevision'] = '$Revision$';