Avatar billede Slettet bruger
27. juli 2002 - 18:03 Der er 17 kommentarer og
1 løsning

Opsætning af phpMyAdmin-2.3.0-rc3

Hej jeg har et problem med at få denne fil opsat er der en der kan hjælpe,

skriv til mig på 56665642

<?php
/* $Id: config.inc.php,v 1.118 2002/07/14 20:43:45 rabus Exp $ */


/**
* 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);
}


/**
* 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 alone, as the correct value
* will be detected automatically. However, we recommened that you do
* test to see that the auto-detection code works in your system.
*
* If the auto-detection code does work properly, you can set 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;


/**
* 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]['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']    = 'config';    // 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']      = '';          // 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
                                                    // - leave blank for no support
$cfg['Servers'][$i]['bookmarktable'] = '';          // Bookmark table - leave blank for no bookmark support
$cfg['Servers'][$i]['relation']      = '';          // table to describe the relation between links (see doc)
                                                    //  - leave blank for no relation-links support
$cfg['Servers'][$i]['table_info']    = '';          // table to describe the display fields
                                                    //  - leave blank for no display fields support
$cfg['Servers'][$i]['table_coords']  = '';          // table to describe the tables position for the PDF
                                                    //  schema - leave blank for no PDF schema support
$cfg['Servers'][$i]['column_comments']              // table to store columncomments
                                    = '';
                                                    // - leave blank if you don't want to use this
$cfg['Servers'][$i]['pdf_pages']    = '';          // table to describe pages of relationpdf
$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]['controluser']    = '';
$cfg['Servers'][$i]['controlpass']    = '';
$cfg['Servers'][$i]['auth_type']      = 'config';
$cfg['Servers'][$i]['user']            = 'root';
$cfg['Servers'][$i]['password']        = '';
$cfg['Servers'][$i]['only_db']        = '';
$cfg['Servers'][$i]['verbose']        = '';
$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]['column_comments'] = '';
$cfg['Servers'][$i]['pdf_pages']      = '';
$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]['controluser']    = '';
$cfg['Servers'][$i]['controlpass']    = '';
$cfg['Servers'][$i]['auth_type']      = 'config';
$cfg['Servers'][$i]['user']            = 'root';
$cfg['Servers'][$i]['password']        = '';
$cfg['Servers'][$i]['only_db']        = '';
$cfg['Servers'][$i]['verbose']        = '';
$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]['column_comments'] = '';
$cfg['Servers'][$i]['pdf_pages']      = '';
$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

// 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

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

// Default Tabs display settings
$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
*/
$cfg['ManualBaseShort'] = 'http://www.mysql.com/doc';


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

// 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.
$cfg['AllowAnywhereRecoding'] = TRUE;

// Force: always use this language - must be defined in
//        libraries/select_lang.lib.php
// $cfg['Lang']    = 'en';
// 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['LeftPointerColor']    = '#CCFFCC';    // color of the pointer in left frame
                                            // (blank for no pointer)
$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['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)
$cfg['TextareaRows']        = 7;            // textarea size (rows) in edit mode
$cfg['LimitChars']          = 50;          // 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)
$cfg['RepeatCells']        = 100;          // repeat header names every X cells? (0 = deactivate)

// Syntax coloring (Note: this feature will be implemented after 2.3.0)
$cfg['UseSyntaxColoring']  = TRUE;        // use syntaxcoloring on output of SQL, might be a little slower
$cfg['colorFunctions']      = '#FF0000';    // Colors used for Syntaxcoloring of SQL Statements
$cfg['colorKeywords']      = '#990099';
$cfg['colorStrings']        = '#008000';
$cfg['colorColType']        = '#FF9900';
$cfg['colorAdd']            = '#0000FF';


/**
* 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'
);


/**
* 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'
    );
} // end if

// Keywords for syntax coloring
if ($cfg['UseSyntaxColoring']) {
    $cfg['keywords'] = array(
        'SELECT',
        'INSERT',
        'LEFT',
        'INNER',
        'UPDATE',
        'REPLACE',
        'EXPLAIN',
        'FROM',
        'WHERE',
        'LIMIT',
        'INTO',
        'ALTER',
        'ADD',
        'DROP',
        'GROUP',
        'ORDER',
        'CHANGE',
        'CREATE',
        'DELETE',
        'VALUES'
    );
} // end if

// Other reserved words for syntax coloring
if ($cfg['UseSyntaxColoring']) {
    $cfg['additional'] = array(
        'TABLE',
        'DEFAULT',
        'NULL',
        'NOT',
        'INDEX',
        'PRIMARY',
        'KEY',
        'UNIQUE',
        'BINARY',
        'UNSIGNED',
        'ZEROFILL',
        'AUTO_INCREMENT',
        'AND',
        'OR',
        'DISTINCT',
        'DISTINCTROW',
        'BY',
        'ON',
        'JOIN',
        'BETWEEN',
        'IN',
        'IF',
        'ELSE',
        'SET'
    );
}


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


/**
* File Revision - do not change either!
*/
$cfg['FileRevision'] = '$Revision: 1.118 $';
?>
Avatar billede tipsen Nybegynder
27. juli 2002 - 18:27 #1
Hvorfor satser du ikke på at få installeret v. 2.2.6 i stedet for en release candidate 3 af v. 2.2.3 ?
Avatar billede Slettet bruger
27. juli 2002 - 18:35 #2
Fordi at jeg har hørt at phpMyAdmin-2.3.0-rc3 understøtter login på en NT server.
Avatar billede lauer Nybegynder
27. juli 2002 - 18:41 #3
man kan jo lige så godt bruge den sidste nye, der er nok ikke nogen væsenlige fejl i.

Hvorfor ser du ikke i Documentation.html?

eller på phpmyadmin.net, efter manualen, det er slet ikke så svært at sætte op.
derefter kan du skrive her hvis der kommer nogen fejl.

lauer
Avatar billede mikkel_robin Nybegynder
27. juli 2002 - 18:42 #4
hvis du kigger øvers i filen kan du her vælge auth metode - config, http, cookie - her skal du vælge cookie, så understøtter IIS det!
Avatar billede binderup Nybegynder
27. juli 2002 - 19:00 #5
$cfg['PmaAbsoluteUri'] = '';

Har du prøvet at udfylde den?
Avatar billede Slettet bruger
27. juli 2002 - 19:01 #6
Ja men det virker bare ikke.
Avatar billede lauer Nybegynder
27. juli 2002 - 19:07 #7
hvad virker ikke... hvad sker der når du går ind på siden?
fortæl dog lidt mere

lauer
Avatar billede Slettet bruger
27. juli 2002 - 19:11 #8
Can not load iconv or recode extension needed for charset conversion, configure php to allow using these extensions or disable charset conversion in phpMyAdmin

Du kan også prøve at gå ind på webshop.dyndns.dk
Avatar billede binderup Nybegynder
27. juli 2002 - 19:14 #9
så ligger problemet jo ikke i phpmyadmins configfiler, men i PHP.ini
Avatar billede Slettet bruger
27. juli 2002 - 19:15 #10
Hvad er det jeg skal gøre der ?
Avatar billede binderup Nybegynder
27. juli 2002 - 19:17 #11
Der er en hel sektion med extensions - dem du mangler har sikkert et ; ud foran sig.

Brokker den sig herefter over at den ikke kan finde stien til dine extensions så skal du rette extension_path til at være den komplette adresse til extension biblioteket
Avatar billede Slettet bruger
27. juli 2002 - 19:19 #12
Den forstår jeg ikke. kan du ikke forklar det !!!
Avatar billede lauer Nybegynder
27. juli 2002 - 19:30 #13
Problem with 2.3.0-rc3:
If you only see a blank page, or get a message about "can not use iconv...", it's because of a wrong default value in the config file. Please set $cfg['AllowAnywhereRecoding'] to FALSE. This happens when PHP does not have recode or iconv support.

hvis du fatter det?

lauer
Avatar billede Slettet bruger
27. juli 2002 - 19:39 #14
Ja, så kommer det næste problem..

The host name is empty!
Warning: Cannot add header information - headers already sent by (output started at C:\PHPADMIN\config.inc.php:469) in C:\PHPADMIN\index.php on line 45
Avatar billede Slettet bruger
27. juli 2002 - 19:40 #15
Warning: Cannot add header information - headers already sent by (output started at C:\PHPADMIN\config.inc.php:469) in C:\PHPADMIN\index.php on line 45
Avatar billede lauer Nybegynder
27. juli 2002 - 19:44 #16
ja, du skal jo sætte dine mysqloplysninger...
f.eks. localhost i hostname, hvis din ftpserver ligger på samme computer som din apache/php

lauer
Avatar billede Slettet bruger
27. juli 2002 - 19:46 #17
Jeg har rette de oplysninger. da de er standart.
Avatar billede Slettet bruger
28. juli 2002 - 00:54 #18
Da jeg ikke kan få den hjælp jeg skal bruge har jeg valgt at glemme det for en tid.
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
Vi tilbyder markedets bedste kurser inden for webudvikling

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