Avatar billede mili Nybegynder
23. maj 2003 - 20:13 Der er 8 kommentarer og
2 løsninger

Phpmyadmin , user/pass Problem

jeg har sat en apache server op, med php [den nyeste]

så lagde jeg phpmyadmin på, men det giver bare root accees for alle og en hver :-(

jeg har prøvet mig fra, hjælp er en del guides.

men enten, gik det i fejl, eller også var der stadig root accees for alle og en hver...

nogen der kan hjælpe mig ???
Avatar billede fangel Nybegynder
23. maj 2003 - 20:15 #1
du skal kigge i "config.inc.php" filen... der står noget med auth-type... kig på den... skal ændres til fx "cookie"...

Morten
Avatar billede twm Nybegynder
23. maj 2003 - 20:17 #2
Du skal ind i config.inc.php og ændre denne linje fra 'config' til 'cookie':
$cfg['Servers'][$i]['auth_type']    = 'cookie';    // Authentication method (config, http or cookie based)?
Avatar billede dragen Nybegynder
23. maj 2003 - 20:28 #3
Så giver den en popup hvor den spørger efter brugernavn og kode.
Avatar billede fangel Nybegynder
23. maj 2003 - 20:30 #4
dragen => nej, ved "http" giver den pop-up... ved "cookie" er det en normal side med 2 felter...

Morten
Avatar billede dragen Nybegynder
23. maj 2003 - 20:32 #5
Det er rigtigt, sorry =)
Tag og brug http,  det virker fint og er nemt at forstå (man kan bare ikke logge ud og logge ind igen med den samme bruger uden at lukke vinduet i gamle explorer versioner....men hvor tit sker det?).
Avatar billede mili Nybegynder
23. maj 2003 - 21:14 #6
så har jeg bare et andet problem

phpMyAdmin - Fejl
phpMyAdmin was unable to read your configuration file!
This might happen if php finds a parse error in it or php cannot find the file.
Please call the configuration file directly using the link below and read the php error message(s) that you recieve. In most cases a quote or a semicolon is missing somewhere.
If you recieve a blank page, everything is fine.
Avatar billede fangel Nybegynder
23. maj 2003 - 21:17 #7
så har du nok lavet en parse-error... prøv at skriv den linie der har noget med sagen at gøre... så skal jeg sige dig fejlen...

Morten
Avatar billede mili Nybegynder
24. maj 2003 - 12:25 #8
her dea-pg sådan ser min config.ini.php ud :

<?php
/* $Id: config.inc.php,v 1.175 2003/05/09 12:40:46 lem9 Exp $ */
// vim: expandtab sw=4 ts=4 sts=4:

/**
* phpMyAdmin Configuration File
*
* All directives are explained in Documentation.html
*/


/**
* Sets the php error reporting - Please do not change this line!
*/
if (!isset($old_error_reporting)) {
    error_reporting(E_ALL);
    @ini_set('display_errors', '1');
}


/**
* Your phpMyAdmin url
*
* Complete the variable below with the full url ie
*    http://www.your_web.net/path_to_your_phpMyAdmin_directory/
*
* It must contain characters that are valid for a URL, and the path is
* case sensitive on some Web servers, for example Unix-based servers.
*
* In most cases you can leave this variable empty, as the correct value
* will be detected automatically. However, we recommend that you do
* test to see that the auto-detection code works in your system. A good
* test is to browse a table, then edit a row and save it.  There will be
* an error message if phpMyAdmin cannot auto-detect the correct value.
*
* If the auto-detection code does work properly, you can set to TRUE the
* $cfg['PmaAbsoluteUri_DisableWarning'] variable below.
*/
$cfg['PmaAbsoluteUri'] = '';


/**
* 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['PmaAbsoluteUri_DisableWarning'] = FALSE;

/**
* Disable the default warning that is displayed on the DB Details Structure page if
* any of the required Tables for the relationfeatures could not be found
*/
$cfg['PmaNoRelation_DisableWarning']  = FALSE;


/**
* Server(s) configuration
*/
$i = 0;
// The $cfg['Servers'] array starts with $cfg['Servers'][1].  Do not use $cfg['Servers'][0].
// You can disable a server config entry by setting host to ''.
$i++;
$cfg['Servers'][$i]['host']          = 'localhost'; // MySQL hostname
$cfg['Servers'][$i]['port']          = '';          // MySQL port - leave blank for default port
$cfg['Servers'][$i]['socket']        = '';          // Path to the socket - leave blank for default socket
$cfg['Servers'][$i]['connect_type']  = 'tcp';      // How to connect to MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['compress']      = FALSE;      // Use compressed protocol for the MySQL connection
                                                    // (requires PHP >= 4.3.0)
$cfg['Servers'][$i]['controluser']  = '';          // MySQL control user settings
                                                    // (this user must have read-only
$cfg['Servers'][$i]['controlpass']  = '';          // access to the "mysql/user"
                                                    // and "mysql/db" tables)
$cfg['Servers'][$i]['auth_type']    = 'http';    // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user']          = 'root';      // MySQL user
$cfg['Servers'][$i]['password']      = '';          // MySQL password (only needed
                                                    // with 'config' auth_type)
$cfg['Servers'][$i]['only_db']      = 'database';          // If set to a db-name, only
                                                    // this db is displayed
                                                    // at left frame
                                                    // It may also be an array
                                                    // of db-names
$cfg['Servers'][$i]['verbose']      = '';          // Verbose name for this host - leave blank to show the hostname

$cfg['Servers'][$i]['pmadb']        = '';          // Database used for Relation, Bookmark and PDF Features
                                                    // (see scripts/create_tables.sql)
                                                    //  - leave blank for no support
                                                    //    DEFAULT: 'phpmyadmin'
$cfg['Servers'][$i]['bookmarktable'] = '';          // Bookmark table
                                                    //  - leave blank for no bookmark support
                                                    //    DEFAULT: 'PMA_bookmark'
$cfg['Servers'][$i]['relation']      = '';          // table to describe the relation between links (see doc)
                                                    //  - leave blank for no relation-links support
                                                    //    DEFAULT: 'PMA_relation'
$cfg['Servers'][$i]['table_info']    = '';          // table to describe the display fields
                                                    //  - leave blank for no display fields support
                                                    //    DEFAULT: 'PMA_table_info'
$cfg['Servers'][$i]['table_coords']  = '';          // table to describe the tables position for the PDF schema
                                                    //  - leave blank for no PDF schema support
                                                    //    DEFAULT: 'PMA_table_coords'
$cfg['Servers'][$i]['pdf_pages']    = '';          // table to describe pages of relationpdf
                                                    //  - leave blank if you don't want to use this
                                                    //    DEFAULT: 'PMA_pdf_pages'
$cfg['Servers'][$i]['column_info']  = '';          // table to store column information
                                                    //  - leave blank for no column comments/mime types
                                                    //    DEFAULT: 'PMA_column_info'
$cfg['Servers'][$i]['history']      = '';          // table to store SQL history
                                                    //  - leave blank for no SQL query history
                                                    //    DEFAULT: 'PMA_history'
$cfg['Servers'][$i]['verbose_check'] = TRUE;        // set to FALSE if you know that your PMA_* tables
                                                    // are up to date. This prevents compatibility
                                                    // checks and thereby increases performance.
$cfg['Servers'][$i]['AllowDeny']['order']          // Host authentication order, leave blank to not use
                                    = '';
$cfg['Servers'][$i]['AllowDeny']['rules']          // Host authentication rules, leave blank for defaults
                                    = array();


$i++;
$cfg['Servers'][$i]['host']            = '';
$cfg['Servers'][$i]['port']            = '';
$cfg['Servers'][$i]['socket']          = '';
$cfg['Servers'][$i]['connect_type']    = 'tcp';
$cfg['Servers'][$i]['compress']        = FALSE;
$cfg['Servers'][$i]['controluser']    = '';
$cfg['Servers'][$i]['controlpass']    = '';
$cfg['Servers'][$i]['auth_type']      = 'config';
$cfg['Servers'][$i]['user']            = 'mili';
$cfg['Servers'][$i]['password']        = 'disa';
$cfg['Servers'][$i]['only_db']        = '';
$cfg['Servers'][$i]['verbose']        = '';
$cfg['Servers'][$i]['pmadb']          = ''; // 'phpmyadmin' - see scripts/create_tables.sql
$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_coords'
$cfg['Servers'][$i]['pdf_pages']      = ''; // 'PMA_pdf_page'
$cfg['Servers'][$i]['column_info']    = ''; // 'PMA_column_info'
$cfg['Servers'][$i]['history']        = ''; // 'PMA_history'
$cfg['Servers'][$i]['verbose_check']  = TRUE;
$cfg['Servers'][$i]['AllowDeny']['order']
                                      = '';
$cfg['Servers'][$i]['AllowDeny']['rules']
                                      = array();

$i++;
$cfg['Servers'][$i]['host']            = '';
$cfg['Servers'][$i]['port']            = '';
$cfg['Servers'][$i]['socket']          = '';
$cfg['Servers'][$i]['connect_type']    = 'tcp';
$cfg['Servers'][$i]['compress']        = FALSE;
$cfg['Servers'][$i]['controluser']    = '';
$cfg['Servers'][$i]['controlpass']    = '';
$cfg['Servers'][$i]['auth_type']      = 'config';
$cfg['Servers'][$i]['user']            = 'td-mili';
$cfg['Servers'][$i]['password']        = 'brorlort';
$cfg['Servers'][$i]['only_db']        = '';
$cfg['Servers'][$i]['verbose']        = '';
$cfg['Servers'][$i]['pmadb']          = ''; // 'phpmyadmin' - see scripts/create_tables.sql
$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_coords'
$cfg['Servers'][$i]['pdf_pages']      = ''; // 'PMA_pdf_page'
$cfg['Servers'][$i]['column_info']    = ''; // 'PMA_column_info'
$cfg['Servers'][$i]['history']        = ''; // 'PMA_history'
$cfg['Servers'][$i]['verbose_check']  = TRUE;
$cfg['Servers'][$i]['AllowDeny']['order']
                                      = '';
$cfg['Servers'][$i]['AllowDeny']['rules']
                                      = array();

// If you have more than one server configured, you can set $cfg['ServerDefault']
// to any one of them to autoconnect to that server when phpMyAdmin is started,
// or set it to 0 to be given a list of servers without logging in
// If you have only one server configured, $cfg['ServerDefault'] *MUST* be
// set to that server.
$cfg['ServerDefault'] = 1;              // Default server (0 = no default server)
$cfg['Server']        = '';
unset($cfg['Servers'][0]);


/**
* Other core phpMyAdmin settings
*/
$cfg['OBGzip']                = TRUE;  // use GZIP output buffering if possible
$cfg['PersistentConnections'] = FALSE;  // use persistent connections to MySQL database
$cfg['ExecTimeLimit']        = 300;    // maximum execution time in seconds (0 for no limit)
$cfg['SkipLockedTables']      = FALSE;  // mark used tables, make possible to show
                                        // locked tables (since MySQL 3.23.30)
$cfg['ShowSQL']              = TRUE;  // show SQL queries as run
$cfg['AllowUserDropDatabase'] = FALSE;  // show a 'Drop database' link to normal users
$cfg['Confirm']              = TRUE;  // confirm 'DROP TABLE' & 'DROP DATABASE'
$cfg['LoginCookieRecall']    = TRUE;  // recall previous login in cookie auth. mode or not
$cfg['UseDbSearch']          = TRUE;  // whether to enable the "database search" feature
                                        // or not

// Left frame setup
$cfg['LeftFrameLight']        = TRUE;  // use a select-based menu and display only the
                                        // current tables in the left frame.
$cfg['ShowTooltip']          = TRUE;  // display table comment as tooltip in left frame
$cfg['ShowTooltipAliasDB']    = FALSE;  // if ShowToolTip is enabled, this defines that table/db comments
$cfg['ShowTooltipAliasTB']    = FALSE;  // are shown (in the left menu and db_details_structure) instead of
                                        // table/db names

$cfg['LeftDisplayLogo']      = TRUE;  // display logo at top of left frame

// In the main frame, at startup...
$cfg['ShowStats']            = TRUE;  // allow to display statistics and space usage in
                                        // the pages about database details and table
                                        // properties
$cfg['ShowMysqlInfo']        = FALSE;  // whether to display the "MySQL runtime
$cfg['ShowMysqlVars']        = FALSE;  // information", "MySQL system variables", "PHP
$cfg['ShowPhpInfo']          = FALSE;  // information" and "change password" links for
$cfg['ShowChgPassword']      = FALSE;  // simple users or not
$cfg['SuggestDBName']        = TRUE;  // suggest a new DB name if possible (false = keep empty)

// In browse mode...
$cfg['ShowBlob']              = FALSE;  // display blob field contents
$cfg['NavigationBarIconic']  = TRUE;  // do not display text inside navigation bar buttons
$cfg['ShowAll']              = FALSE;  // allows to display all the rows
$cfg['MaxRows']              = 30;    // maximum number of rows to display
$cfg['Order']                = 'ASC';  // default for 'ORDER BY' clause (valid
                                        // values are 'ASC', 'DESC' or 'SMART' -ie
                                        // descending order for fields of type
                                        // TIME, DATE, DATETIME & TIMESTAMP,
                                        // ascending order else-)

// In edit mode...
$cfg['ProtectBinary']        = 'blob'; // disallow editing of binary fields
                                        // valid values are:
                                        //  FALSE  allow editing
                                        //  'blob' allow editing except for BLOB fields
                                        //  'all'  disallow editing
$cfg['ShowFunctionFields']    = TRUE;  // Display the function fields in edit/insert mode
$cfg['CharEditing']          = 'input';
                                        // Which editor should be used for CHAR/VARCHAR fields:
                                        //  input - allows limiting of input length
                                        //  textarea - allows newlines in fields

// For the export features...
$cfg['ZipDump']              = TRUE;  // Allow the use of zip/gzip/bzip
$cfg['GZipDump']              = TRUE;  // compression for
$cfg['BZipDump']              = TRUE;  // dump files

// Tabs display settings
$cfg['LightTabs']            = FALSE;  // use graphically less intense menu tabs
$cfg['DefaultTabServer']      = 'main.php';
                                  // Possible values:
                                  // 'main.php' = the welcome page
                                  // (recommended for multiuser setups)
                                  // 'server_databases.php' = list of databases
                                  // 'server_status.php' = runtime information
                                  // 'server_variables.php' = MySQL server variables
                                  // 'server_privileges.php' = user management
                                  // 'server_processlist.php' = process list
$cfg['DefaultTabDatabase']    = 'db_details_structure.php';
                                  // Possible values:
                                  // 'db_details_structure.php' = tables list
                                  // 'db_details.php' = sql form
                                  // 'db_search.php' = search query
$cfg['DefaultTabTable']      = 'tbl_properties_structure.php';
                                  // Possible values:
                                  // 'tbl_properties_structure.php' = fields list
                                  // 'tbl_properties.php' = sql form
                                  // 'tbl_select.php = select page
                                  // 'tbl_change.php = insert row page


/**
* Link to the official MySQL documentation.
* Be sure to include no trailing slash on the path.
* See http://www.mysql.com/documentation/index.html for more information
* about MySQL manuals and their types.
*/
$cfg['MySQLManualBase'] = 'http://www.mysql.com/doc/en';

/**
* Type of MySQL documentation:
*  old        - old style used in phpMyAdmin 2.3.0 and sooner
*  searchable - "Searchable, with user comments"
*  chapters  - "HTML, one page per chapter"
*  big        - "HTML, all on one page"
*  none      - do not show documentation links
*/
$cfg['MySQLManualType'] = 'searchable';


/**
* Language and charset conversion settings
*/
// Default language to use, if not browser-defined or user-defined
$cfg['DefaultLang'] = 'en-iso-8859-1';

// Force: always use this language - must be defined in
//        libraries/select_lang.lib.php
// $cfg['Lang']    = 'en-iso-8859-1';

// Default charset to use for recoding of MySQL queries, does not take
// any effect when charsets recoding is switched off by
// $cfg['AllowAnywhereRecoding'] or in language file
// (see $cfg['AvailableCharsets'] to possible choices, you can add your own)
$cfg['DefaultCharset'] = 'iso-8859-1';

// Allow charset recoding of MySQL queries, must be also enabled in language
// file to make harder using other language files than unicode.
// Default value is FALSE to avoid problems on servers without the iconv
// extension and where dl() is not supported
$cfg['AllowAnywhereRecoding'] = FALSE;

// You can select here which functions will be used for charset conversion.
// Possible values are:
//      auto  - automatically use available one (first is tested iconv, then
//              recode)
//      iconv  - use iconv or libiconv functions
//      recode - use recode_string function
$cfg['RecodingEngine'] = 'auto';

// Available charsets for MySQL conversion. currently contains all which could
// be found in lang/* files and few more.
// Charsets will be shown in same order as here listed, so if you frequently
// use some of these move them to the top.
$cfg['AvailableCharsets'] = array(
    'iso-8859-1',
    'iso-8859-2',
    'iso-8859-3',
    'iso-8859-4',
    'iso-8859-5',
    'iso-8859-6',
    'iso-8859-7',
    'iso-8859-8',
    'iso-8859-9',
    'iso-8859-10',
    'iso-8859-11',
    'iso-8859-12',
    'iso-8859-13',
    'iso-8859-14',
    'iso-8859-15',
    'windows-1250',
    'windows-1251',
    'windows-1252',
    'windows-1257',
    'koi8-r',
    'big5',
    'gb2312',
    'utf-8',
    'utf-7',
    'x-user-defined',
    'euc-jp',
    'ks_c_5601-1987',
    'tis-620',
    'SHIFT_JIS'
);

// Loads language file
require('./libraries/select_lang.lib.php');


/**
* Customization & design
*/
$cfg['LeftWidth']          = 150;          // left frame width
$cfg['LeftBgColor']        = '#D0DCE0';    // background color for the left frame
$cfg['RightBgColor']        = '#F5F5F5';    // background color for the right frame
$cfg['RightBgImage']        = '';          // path to a background image for the right frame
                                            // (leave blank for no background image)
$cfg['LeftPointerColor']    = '#CCFFCC';    // color of the pointer in left frame
                                            // (blank for no pointer)
$cfg['Border']              = 0;            // border width on tables
$cfg['ThBgcolor']          = '#D3DCE3';    // table header row colour
$cfg['BgcolorOne']          = '#CCCCCC';    // table data row colour
$cfg['BgcolorTwo']          = '#DDDDDD';    // table data row colour, alternate
$cfg['BrowsePointerColor']  = '#CCFFCC';    // color of the pointer in browse mode
                                            // (blank for no pointer)
$cfg['BrowseMarkerColor']  = '#FFCC99';    // color of the marker (visually marks row
                                            // by clicking on it) in browse mode
                                            // (blank for no marker)
$cfg['TextareaCols']        = 40;          // textarea size (columns) in edit mode
                                            // (this value will be emphasized (*2) for sql
                                            // query textareas and (*1.25) for query window)
$cfg['TextareaRows']        = 7;            // textarea size (rows) in edit mode
$cfg['TextareaAutoSelect']  = TRUE;        // autoselect when clicking in the textarea of the querybox
$cfg['CharTextareaCols']    = 40;          // textarea size (columns) for CHAR/VARCHAR
$cfg['CharTextareaRows']    = 2;            // textarea size (rows) for CHAR/VARCHAR
$cfg['LimitChars']          = 50;          // For text and blobs, max field data length in browse mode
$cfg['ModifyDeleteAtLeft']  = TRUE;        // show edit/delete links on left side of browse
                                            // (or at the top with vertical browse)
$cfg['ModifyDeleteAtRight'] = FALSE;        // show edit/delete links on right side of browse
                                            // (or at the bottom with vertical browse)
$cfg['DefaultDisplay']      = 'horizontal'; // default display direction
                                            // (horizontal|vertical|horizontalflipped)
$cfg['DefaultPropDisplay']  = 'horizontal'; // default display direction for altering/
                                            // creating columns (tbl_properties)
                                            // (horizontal|vertical)

$cfg['HeaderFlipType']      = 'css';        // table-header rotation via faking or css? (css|fake)
                                            // NOTE: CSS only works in IE browsers!
$cfg['ShowBrowseComments']  = TRUE;        // shows stored relation-comments in 'browse' mode.
$cfg['ShowPropertyComments']= TRUE;        // shows stored relation-comments in 'table property' mode.
$cfg['RepeatCells']        = 100;          // repeat header names every X cells? (0 = deactivate)

$cfg['QueryFrame']          = TRUE;        // displays a new frame where a link to a querybox is always displayed.
$cfg['QueryFrameJS']        = TRUE;        // whether to use JavaScript functions for opening a new window for SQL commands.
                                            // if set to 'false', the target of the querybox is always the right frame.
$cfg['QueryFrameDebug']    = FALSE;        // display JS debugging link (DEVELOPERS only)
$cfg['QueryWindowWidth']    = 550;          // Width of Query window
$cfg['QueryWindowHeight']  = 310;          // Height of Query window
$cfg['QueryHistoryDB']      = FALSE;        // Set to TRUE if you want DB-based query history.
                                            // If FALSE, this utilizes JS-routines to display
                                            // query history (lost by window close)
$cfg['QueryWindowDefTab']  = 'sql';        // which tab to display in the querywindow on startup
                                            // (sql|files|history|full)
$cfg['QueryHistoryMax']    = 25;          // When using DB-based query history, how many entries
                                            // should be kept?
$cfg['BrowseMIME']          = TRUE;        // Use MIME-Types (stored in column comments table) for
$cfg['MaxExactCount']      = 20000;        // When approximate count < this, PMA will get exact count for
                                            // table rows.

/**
* SQL Query box settings
* These are the links display in all of the SQL Query boxes
*/
$cfg['SQLQuery']['Edit']      = TRUE;      // Edit link to change a query
$cfg['SQLQuery']['Explain']  = TRUE;      // EXPLAIN on SELECT queries
$cfg['SQLQuery']['ShowAsPHP'] = TRUE;      // Wrap a query in PHP
$cfg['SQLQuery']['Validate']  = FALSE;      // Validate a query (see $cfg['SQLValidator'] as well)


/**
* web-server upload directory
*/
$cfg['UploadDir']            = '';        // for example, './upload/'; you must end it with
                                            // a slash, and you leave it empty for no upload
                                            // directory


/**
* SQL Parser Settings
*/
$cfg['SQP']['fmtType']      = 'html';      // Pretty-printing style to use on queries (html, text, none)
$cfg['SQP']['fmtInd']      = '1';          // Amount to indent each level (floats ok)
$cfg['SQP']['fmtIndUnit']  = 'em';        // Units for indenting each level (CSS Types - {em,px,pt})
$cfg['SQP']['fmtColor']    = array(        // Syntax colouring data
    'comment'            => '#808000',
    'comment_mysql'      => '',
    'comment_ansi'      => '',
    'comment_c'          => '',
    'digit'              => '',
    'digit_hex'          => 'teal',
    'digit_integer'      => 'teal',
    'digit_float'        => 'aqua',
    'punct'              => 'fuchsia',
    'alpha'              => '',
    'alpha_columnType'  => '#FF9900',
    'alpha_columnAttrib' => '#0000FF',
    'alpha_reservedWord' => '#990099',
    'alpha_functionName' => '#FF0000',
    'alpha_identifier'  => 'black',
    'alpha_variable'    => '#800000',
    'quote'              => '#008000',
    'quote_double'      => '',
    'quote_single'      => '',
    'quote_backtick'    => ''
);


/**
* If you wish to use the SQL Validator service, you should be
* aware of the following:
* All SQL statements are stored anonymously for statistical purposes.
* Mimer SQL Validator, Copyright 2002 Upright Database Technology.
* All rights reserved.
*/
$cfg['SQLValidator']['use']      = FALSE;  // Make the SQL Validator available
$cfg['SQLValidator']['username'] = '';      // If you have a custom username, specify it here (defaults to anonymous)
$cfg['SQLValidator']['password'] = '';      // Password for username

/**
* Developers ONLY!
* To use the following, please install the DBG extension from http://dd.cron.ru/dbg/
*/
$cfg['DBG']['enable'] = FALSE;              // Make the DBG stuff available
$cfg['DBG']['profile']['enable'] = FALSE;  // Produce profiling results of PHP
$cfg['DBG']['profile']['threshold'] = 0.5;  // Threshold of long running code to display
                                            // Anything below the threshold is not displayed


/**
* MySQL settings
*/
// Column types;
// varchar, tinyint, text and date are listed first, based on estimated popularity
$cfg['ColumnTypes'] = array(
  'VARCHAR',
  'TINYINT',
  'TEXT',
  'DATE',
  'SMALLINT',
  'MEDIUMINT',
  'INT',
  'BIGINT',
  'FLOAT',
  'DOUBLE',
  'DECIMAL',
  'DATETIME',
  'TIMESTAMP',
  'TIME',
  'YEAR',
  'CHAR',
  'TINYBLOB',
  'TINYTEXT',
  'BLOB',
  'MEDIUMBLOB',
  'MEDIUMTEXT',
  'LONGBLOB',
  'LONGTEXT',
  'ENUM',
  'SET'
);

// Atributes
$cfg['AttributeTypes'] = array(
  '',
  'BINARY',
  'UNSIGNED',
  'UNSIGNED ZEROFILL'
);

// Available functions
if ($cfg['ShowFunctionFields']) {
    $cfg['Functions'] = array(
      'ASCII',
      'CHAR',
      'SOUNDEX',
      'LCASE',
      'UCASE',
      'NOW',
      'PASSWORD',
      'MD5',
      'ENCRYPT',
      'RAND',
      'LAST_INSERT_ID',
      'COUNT',
      'AVG',
      'SUM',
      'CURDATE',
      'CURTIME',
      'FROM_DAYS',
      'FROM_UNIXTIME',
      'PERIOD_ADD',
      'PERIOD_DIFF',
      'TO_DAYS',
      'UNIX_TIMESTAMP',
      'USER',
      'WEEKDAY',
      'CONCAT'
    );
   
    // Which column types will be mapped to which Group?
    $cfg['RestrictColumnTypes'] = array(
      'VARCHAR'      => 'FUNC_CHAR',
      'TINYINT'      => 'FUNC_NUMBER',
      'TEXT'        => 'FUNC_CHAR',
      'DATE'        => 'FUNC_DATE',
      'SMALLINT'    => 'FUNC_NUMBER',
      'MEDIUMINT'    => 'FUNC_NUMBER',
      'INT'          => 'FUNC_NUMBER',
      'BIGINT'      => 'FUNC_NUMBER',
      'FLOAT'        => 'FUNC_NUMBER',
      'DOUBLE'      => 'FUNC_NUMBER',
      'DECIMAL'      => 'FUNC_NUMBER',
      'DATETIME'    => 'FUNC_DATE',
      'TIMESTAMP'    => 'FUNC_DATE',
      'TIME'        => 'FUNC_DATE',
      'YEAR'        => 'FUNC_DATE',
      'CHAR'        => 'FUNC_CHAR',
      'TINYBLOB'    => 'FUNC_CHAR',
      'TINYTEXT'    => 'FUNC_CHAR',
      'BLOB'        => 'FUNC_CHAR',
      'MEDIUMBLOB'  => 'FUNC_CHAR',
      'MEDIUMTEXT'  => 'FUNC_CHAR',
      'LONGBLOB'    => 'FUNC_CHAR',
      'LONGTEXT'    => 'FUNC_CHAR',
      'ENUM'        => '',
      'SET'          => ''
    );

    // Map above defined groups to any function
    $cfg['RestrictFunctions'] = array(
        'FUNC_CHAR'  => array(
            'ASCII',
            'CHAR',
            'SOUNDEX',
            'LCASE',
            'UCASE',
            'PASSWORD',
            'MD5',
            'ENCRYPT',
            'LAST_INSERT_ID',
            'USER',
            'CONCAT'
        ),

        'FUNC_DATE'  => array(
            'NOW',
            'CURDATE',
            'CURTIME',
            'FROM_DAYS',
            'FROM_UNIXTIME',
            'PERIOD_ADD',
            'PERIOD_DIFF',
            'TO_DAYS',
            'UNIX_TIMESTAMP',
            'WEEKDAY'
        ),

        'FUNC_NUMBER' => array(
            'ASCII',
            'CHAR',
            'MD5',
            'ENCRYPT',
            'RAND',
            'LAST_INSERT_ID',
            'COUNT',
            'AVG',
            'SUM'
        )
    );
   
} // end if


/**
* Unset magic_quotes_runtime - do not change!
*/
set_magic_quotes_runtime(0);

/**
* File Revision - do not change either!
*/
$cfg['FileRevision'] = '$Revision: 1.175 $';
?>
Avatar billede fangel Nybegynder
24. maj 2003 - 21:04 #9
kigger på det i morgen hvis jeg for tid...
Avatar billede power99 Nybegynder
28. september 2003 - 22:35 #10
Det er denne her du skal lave om:
$cfg['Servers'][$i]['auth_type']    = 'http';    // Authentication method (config, http or cookie based)?

Til:
$cfg['Servers'][$i]['auth_type']    = 'cookie';    // Authentication method (config, http or cookie based)?
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
IT-kurser om Microsoft 365, sikkerhed, personlig vækst, udvikling, digital markedsføring, grafisk design, SAP og forretningsanalyse.

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester