美元$ cfg[“服务器”][我][用户]…不可以

时间:2021-09-17 16:49:48

I recently upgraded from phpMyAdmin 3.5.3 to 4.1.4 and I'm having problems with some of the configuration storage settings. At least, it seems that I'm having problems. Maybe this is expected behavior but I want to be sure.

我最近从phpMyAdmin 3.5.3升级到4.1.4,我在一些配置存储设置上遇到了问题。至少,我似乎有问题。也许这是预期的行为,但我想确定。

My Procedure:

我的程序:

  • Downloaded and extracted new phpMyAdmin and copied it to /srv/www/htdocs/ (The previous version is still there but uses a different directory name - I didn't want to remove it until I got the new version working)
  • 下载并提取新的phpMyAdmin并将其复制到/srv/www/htdocs/(之前的版本还在那里,但是使用了一个不同的目录名——我不想删除它,直到我得到新版本的工作)
  • Used the setup web GUI to create a new config.inc.php. I know that it says to copy the old one but I figured there might be new fields since this is a new major version. Also, when I was done, I verified that the old config.inc.php and the new one have the same values for identical fields. I then copied it to the phpMyAdmin root.
  • 使用设置web GUI来创建一个新的config.inc.php。我知道它说要复制旧的,但我认为可能会有新的领域因为这是一个新的主要版本。而且,当我完成时,我验证了旧的config.inc。php和新版本对相同字段具有相同的值。然后将其复制到phpMyAdmin根。
  • Ran examples/create_tables.sql and noticed that it did create some new tables in the phpmyadmin database.
  • 跑/ create_tables例子。sql并注意到它确实在phpmyadmin数据库中创建了一些新表。
  • Logged in successfully and most features seem to be working fine.
  • 登录成功,大多数功能看起来运行良好。

Here's what I'm not sure about. It gave me the message: "The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why click here." And when I click there it has the following complaints:

这是我不确定的。它给我的信息是:“phpMyAdmin配置存储没有完全配置,一些扩展特性已经被停用。想知道为什么点击这里。当我点击它的时候,它有以下的抱怨:

$cfg['Servers'][$i]['users'] ...    not OK [ Documentation ]
$cfg['Servers'][$i]['usergroups'] ...   not OK [ Documentation ]
Configurable menus: Disabled

$cfg['Servers'][$i]['navigationhiding'] ...     not OK [ Documentation ]
Hide/show navigation items: Disabled

I figured it was because there were not yet any entries for those in config.inc.php but even when I enter those lines with blank values into config.inc.php, I still get the same messages.

我认为这是因为在config.inc.中还没有任何条目。php,但即使我将空白值输入到config.inc。php,我仍然得到相同的消息。

Maybe I'm misinterpreting this, but to me "not OK" indicates some kind of an error, not just that the value is being intentionally left blank. Is that correct? Did I miss something? Or is that phpMyAdmin's way of saying that it's not currently in use but that I have nothing to worry about?

也许我误解了这一点,但对我来说,“不OK”表示了某种错误,而不仅仅是它的价值被故意留空了。那是正确的吗?我错过什么了吗?或者phpMyAdmin的说法是,它目前没有使用,但我没有什么可担心的?

All the other configuration storage features are marked as "OK" and "Enabled" - it's just these new ones (which weren't in 3.5.3) that are "not OK."

所有其他的配置存储特性都被标记为“OK”和“Enabled”——只是这些新功能(不是3.5.3)“不行”。

Is something wrong or is this the way it should be if I don't want to use those features?

如果我不想使用这些特性,这是错误的吗?

3 个解决方案

#1


2  

You can:

您可以:

  • Check a similar question PhpMyAdmin error with config file to see if any of those answers help.

    用配置文件检查一个类似的PhpMyAdmin错误,看看这些答案是否有帮助。

  • Leave them blank to make phpMyAdmin use the default values.

    让它们保持空白,使phpMyAdmin使用默认值。

    e.g. $cfg['Servers'][$i]['usergroups '] = '';

    $cfg['Servers'][$i]['usergroups '] = ";

    http://wiki.phpmyadmin.net/pma/Config/Servers#usergroups

    http://wiki.phpmyadmin.net/pma/Config/Servers用户组

  • You can also manually look into phpmyadmin database to see in which table relevent data is stored

    您还可以手动查看phpmyadmin数据库,以查看存储了哪些表相关数据。

#2


0  

I ran into similar problem when trying to install a fresh copy of phpMyAdmin 4.1.13. It's because of the table name mapping issue.

我在尝试安装phpMyAdmin 4.1.13的新副本时遇到了类似的问题。这是因为表名映射问题。

Below the line:

下面一行:

$cfg['Servers'][$i]['password'] = 'password';

this is the code I ended up putting:

这是我最后写的代码:

$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$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_pages';
$cfg['Servers'][$i]['column_info'] = 'pma__column_info';
$cfg['Servers'][$i]['history'] = 'pma__history';
$cfg['Servers'][$i]['tracking'] = 'pma__tracking';
$cfg['Servers'][$i]['designer_coords'] = 'pma__designer_coords';
$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
$cfg['Servers'][$i]['recent'] = 'pma__recent';
$cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';
$cfg['Servers'][$i]['users'] = 'pma__users';
$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups'; 
$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding'; 

#3


0  

Just upgraded to version 4.2.7 on my localhost. Found these steps at the button of the page linked from "The phpMyAdmin configuration storage has been deactivated. To find out why click here."

在我的本地主机上刚刚升级到4.2.7版本。在与“phpMyAdmin配置存储已被停用”链接的页面的按钮上发现这些步骤。想知道为什么点击这里。

Quick steps to setup advanced features:

设置高级功能的快速步骤:

  1. Create the needed tables with the examples/create_tables.sql.
  2. 使用示例/create_tables.sql创建所需的表。
  3. Create a pma user and give access to these tables.
  4. 创建一个pma用户并访问这些表。
  5. Enable advanced features in configuration file (config.inc.php), for example by starting from config.sample.inc.php.
  6. 在配置文件(config.inc.php)中启用高级功能,例如从config.sample.inc.php开始。
  7. Re-login to phpMyAdmin to load the updated configuration file.
  8. 重新登录phpMyAdmin以加载更新后的配置文件。

Still had the problem but i added the following to my config.inc.php file

仍然有问题,但我在config.inc.中添加了以下内容。php文件

$cfg['Servers'][$i]['users'] = 'pma__users';
$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
$cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';

Re-login and check. It should work fine.

重新登录并检查。它应该工作很好。

For me, re-logging in was changing the value of $cfg['Servers'][$i]['auth_type'] from 'config' to 'cookie' and then closing the browser.

对我来说,重新登录是将cfg(服务器)的价值从“config”改为“cookie”,然后关闭浏览器。

#1


2  

You can:

您可以:

  • Check a similar question PhpMyAdmin error with config file to see if any of those answers help.

    用配置文件检查一个类似的PhpMyAdmin错误,看看这些答案是否有帮助。

  • Leave them blank to make phpMyAdmin use the default values.

    让它们保持空白,使phpMyAdmin使用默认值。

    e.g. $cfg['Servers'][$i]['usergroups '] = '';

    $cfg['Servers'][$i]['usergroups '] = ";

    http://wiki.phpmyadmin.net/pma/Config/Servers#usergroups

    http://wiki.phpmyadmin.net/pma/Config/Servers用户组

  • You can also manually look into phpmyadmin database to see in which table relevent data is stored

    您还可以手动查看phpmyadmin数据库,以查看存储了哪些表相关数据。

#2


0  

I ran into similar problem when trying to install a fresh copy of phpMyAdmin 4.1.13. It's because of the table name mapping issue.

我在尝试安装phpMyAdmin 4.1.13的新副本时遇到了类似的问题。这是因为表名映射问题。

Below the line:

下面一行:

$cfg['Servers'][$i]['password'] = 'password';

this is the code I ended up putting:

这是我最后写的代码:

$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$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_pages';
$cfg['Servers'][$i]['column_info'] = 'pma__column_info';
$cfg['Servers'][$i]['history'] = 'pma__history';
$cfg['Servers'][$i]['tracking'] = 'pma__tracking';
$cfg['Servers'][$i]['designer_coords'] = 'pma__designer_coords';
$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
$cfg['Servers'][$i]['recent'] = 'pma__recent';
$cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';
$cfg['Servers'][$i]['users'] = 'pma__users';
$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups'; 
$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding'; 

#3


0  

Just upgraded to version 4.2.7 on my localhost. Found these steps at the button of the page linked from "The phpMyAdmin configuration storage has been deactivated. To find out why click here."

在我的本地主机上刚刚升级到4.2.7版本。在与“phpMyAdmin配置存储已被停用”链接的页面的按钮上发现这些步骤。想知道为什么点击这里。

Quick steps to setup advanced features:

设置高级功能的快速步骤:

  1. Create the needed tables with the examples/create_tables.sql.
  2. 使用示例/create_tables.sql创建所需的表。
  3. Create a pma user and give access to these tables.
  4. 创建一个pma用户并访问这些表。
  5. Enable advanced features in configuration file (config.inc.php), for example by starting from config.sample.inc.php.
  6. 在配置文件(config.inc.php)中启用高级功能,例如从config.sample.inc.php开始。
  7. Re-login to phpMyAdmin to load the updated configuration file.
  8. 重新登录phpMyAdmin以加载更新后的配置文件。

Still had the problem but i added the following to my config.inc.php file

仍然有问题,但我在config.inc.中添加了以下内容。php文件

$cfg['Servers'][$i]['users'] = 'pma__users';
$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
$cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';

Re-login and check. It should work fine.

重新登录并检查。它应该工作很好。

For me, re-logging in was changing the value of $cfg['Servers'][$i]['auth_type'] from 'config' to 'cookie' and then closing the browser.

对我来说,重新登录是将cfg(服务器)的价值从“config”改为“cookie”,然后关闭浏览器。