phpadmin的配制的困惑

blueriver

UID: 31243
帖子: 1
积分: 2
在线时间: 10 分钟

1^# blueriver 发表于 2003-05-14 14:07

phpadmin的配制的困惑

我是redhat8.0,装了phpmyadmin -2.50-rc1
$cfg['PmaAbsoluteUri'] = '';-----------怎么配制?
$cfg['Servers'][$i]['host']       = 'localhost'; // MySQL hostname
$cfg['Servers'][$i]['port']       = '';
$cfg['Servers'][$i]['auth_type']    = 'http';
$cfg['Servers'][$i]['user']       = 'root';    // MySQL user
$cfg['Servers'][$i]['password']    = 'fsdfsfs';
上面这样配制可以吗?

我能连接http://xxx/phpadmin/
进去了,提示错误
----------------------------------------------------------------------------------------------
必须在您的配置文件中设定 $cfg['PmaAbsoluteUri'] 指令!
-----------------------------------------------------------------------------------------------

下方有:
------------------------------------------------------------------------
错误
使用链接表的额外特性尚未激活。要查出原因，请单击此处。
-------------------------------------------------------------------------

点记"此处"-进去了,提示 :
-------------------------------------
数据库 nuke  运行于 localhost
PMA Database ... 不好[ 文档 ]
一般关系特性已禁用
--------------------------------------

redhat71

UID: 16066
帖子: 126
积分: 289
在线时间: 22 小时

2^# redhat71 发表于 2003-05-14 17:55

每行后面都有注释信息，看完了再折腾不是更省事？！

好象这个
// MySQL password (only needed
// with 'config' auth_type)
写的很清楚了，只有上面的auth_type设置为config，才需要直接在这个文件里设置用户和密码
你上面设成http，下面又设用户密码。。。

$cfg['PmaAbsoluteUri']
这个就更清楚了，就在它上面的注释里有现成的例子：
/**
* Your phpMyAdmin url
*
* Complete the variable below with the full url ie
* http://www.your_web.net/path_to_your_phpMyAdmin_directory/

照你上面说的，你给它这行就完了
$cfg['PmaAbsoluteUri'] = ''http://xxx/phpadmin/ ';

看清楚再动手，是一种乐趣。。。

blueriver

UID: 31243
帖子: 1
积分: 2
在线时间: 10 分钟

3^# blueriver 发表于 2003-05-14 18:30

--呵呵,不好意思,可能我的意思可能表达不是很明白
---------------------好象这个
// MySQL password (only needed
// with 'config' auth_type)
写的很清楚了，只有上面的auth_type设置为config，才需要直接在这个文件里设置用户和密码
你上面设成http，下面又设用户密码。。。

---------------------这样也能连接,用浏览器连接时输入用户名和密码就能进去了,我的主要问题是.
..错误
使用链接表的额外特性尚未激活。要查出原因，请单击此处。
-------------------------------------------------------------------------

点记"此处"-进去了,提示 :
-------------------------------------
数据库 nuke 运行于 localhost
PMA Database ... 不好[ 文档 ]
一般关系特性已禁用
谢谢你

redhat71

UID: 16066
帖子: 126
积分: 289
在线时间: 22 小时

4^# redhat71 发表于 2003-05-14 18:38

唉。。。因为你已经设置了HTTP的AUTH＿TYPE，它根本就不理会下面设置的用户和密码了！

你是能用，但你就不想想为什么你已经设置了用户密码，怎么调用的时候还要你再输入呢？

‘额外特性’那个错误我没见过

‘...不好[文档]’这部分是什么意思？你省略了原文？

redhat71

UID: 16066
帖子: 126
积分: 289
在线时间: 22 小时

5^# redhat71 发表于 2003-05-14 18:41

如果你不怕麻烦的话，用英文语言进去，把详细的错误提示贴上或发给我，截图也行

我可以帮你看看，不过不要指望我一定能看懂
我和你一样菜，只是喜欢看文档，用GOOGLE。。。

blueriver

UID: 31243
帖子: 1
积分: 2
在线时间: 10 分钟

6^# blueriver 发表于 2003-05-14 18:54

[code:1]Error
The additional Features for working with linked Tables have been deactivated. To find out why click here.
只要点记了here
PMA Database ... not OK[ Documentation ]---不是省略的,上面就这样显示
General relation features Disabled

[/code:1]

blueriver

UID: 31243
帖子: 1
积分: 2
在线时间: 10 分钟

7^# blueriver 发表于 2003-05-14 18:57

我马上就贴我的config出来[/code]

blueriver

UID: 31243
帖子: 1
积分: 2
在线时间: 10 分钟

8^# blueriver 发表于 2003-05-14 19:03

[/code]<?php
/* $Id: config.inc.php,v 1.174 2003/04/11 11:59:27 nijel 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'] = 'http://xxxx.3322.org/phpadmin/';

/**
* 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']    = 'gddgdf';       // 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

blueriver

UID: 31243
帖子: 1
积分: 2
在线时间: 10 分钟

9^# blueriver 发表于 2003-05-14 19:05

//    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']          = 'root';
$cfg['Servers'][$i]['password']       = '';
$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();

blueriver

UID: 31243
帖子: 1
积分: 2
在线时间: 10 分钟

10^# blueriver 发表于 2003-05-14 19:08

下面的肯定没该过的