Ошибка при чтении конфигурационного файла phpmyadmin

Logged In: YES
user_id=326580

You put the config.inc.php into ./ and not into ./libraries/?
You made the config.inc.php not writable by the webserver?

— Original author: cybot_tm

— status: open —> pending

— Original author: cybot_tm

Logged In: YES
user_id=682994

Yes, I made a barebones config.inc.php in the top level directory and after trying
several things I could not get it to stop giving the error indicating that the
socket could not be found. Of course there was no socket on the server. The
whole point was I was specifying an external host in the config.

In order to narrow down the problem I installed 2.7.0 and simply moved the
config file. When I did so 2.7.0 worked immediately. Also, the error message
did not change on 2.8.0.3 whether there was a config file there or not.

— Original author: dasil003

— status: pending —> open

— Original author: dasil003

Logged In: YES
user_id=326580

the error was not at start? can you please attach your
config file? please remove/replace passwords, usernames and
hostnames

— Original author: cybot_tm

Logged In: YES
user_id=1510142

See problem # 1476615

The fix is probably (I have v2.8.0.2) to fix the
./config.inc.php file. The one I copied from ./libraries has
broken syntax. look for the lines:
$cfg[‘Servers’][$i][‘AllowDeny’][‘order’]
$cfg[‘Servers’][$i][‘AllowDeny’][‘rules’]

They should be:
$cfg[‘Servers’][$i][‘AllowDeny’][‘order’] = ‘’;
$cfg[’Servers’][$i][‘AllowDeny’][‘rules’] = array();

Hope that helps!

— Original author: tompotts

Logged In: YES
user_id=997838

I’m having the same problem with 2.8.0.3. I’ve never used
phpmyadmin before, but I’ve heard great things… thus far,
it just doesn’t work, though.

I’ve fgrep’ed through the entire directory structure and
there’s no “require” or “include” for a “config.inc.php”
file, so there’s no way it’s getting read by any of the scripts.

I don’t know what’s broken, but something definately is.

— Original author: blentz

Logged In: YES
user_id=326580

yes for sure, ther is no require ‘config.inc.php’ line

the config is loaded inside the PMA_Config class, which is
called in common.lib.php:

$SESSION[‘PMA_Config’] = new PMAConfig(‘./config.inc.php’);

you downloaded and extracted phpMyAdmin and than you get an
error when running it? if you not configure phpMyAdmin than
it trys to connect to localhost with user root and without
password.

— Original author: cybot_tm

Logged In: YES
user_id=326580

@dasil003: your problem should be fixed with bug #1476615
, or?

@blentz: if you have created a config file and it is not
read than phpMyAdmin should display an error message that it
cannot read the created config file

— Original author: cybot_tm

Logged In: YES
user_id=997838

Yes, I get an error. It behaves as if there’s no config file
at all, repeatedly trying to connect to MySQL via
root@localhost. I can use ./scripts/setup.php to create a
configuration file (in the properly-created) ./config/
directory, and per the instructions, I move
./config/config.inc.php to ./config.inc.php and remove the
./config directory.

It completely ignores ./config.inc.php, even if it exists,
is secure, contains valid information (generated by
./scripts/setup.php), and is located where the documentation
expects it to be, in the top-level directory with ./index.php.

— Original author: blentz

Logged In: YES
user_id=210714

blentz: did you close all your browser windows after you
moved config.inc.php in the top dir, then try again?

— Original author: lem9

Logged In: YES
user_id=682994

I finally went in and figured out what the problem is (at least in my case). It’s
simply that the SESSION stores the config filename, and once set only ever
uses that filename. So if you load up the PMA front page before putting a
config.inc.php file in place you will continue to use libraries/
config.default.php until your session is reset.

IMO, it should always do an explicit check for the config.inc.php file before
going to the SESSION. At least when the user is not logged in.

— Original author: dasil003

Logged In: YES
user_id=38481

What retard decided to try to put the path in a SESSION
variable? Whoever did that should be REMOVED from the
phpMyAdmin developers CVS access IMMEDIATELY.

— Original author: lancelight

Logged In: YES
user_id=568376

Hi All

New install of 2.8.1 and I copied the files into my web
directory and browsed to the page to confirm it was available.

Got the ‘you should use setup script’ message and proceeded
to do so, referring to the instructions.

config.inc.php is not being read by my setup.
libraries/config.default.php is being read.

I am currently running ok by ignoring all the instructions
and editing libraries/config.default.php

A full server reboot and browser shutdown made no
difference, and having wasted an hour figuring this out, I
can only say that whatever the process is that is causing
this it is wasting one hell of a lot of time for a lot of
people by the looks of the comments in this list.

Linux RH/ Apache/PHP/MySQL setup.

— Original author: thowden

Logged In: YES
user_id=210714

Ok, let’s try to fix this in the best possible way.

The problem with editing config.default.php is that, in
future versions, this file will change. What will you do?
reedit it?

We always wanted to keep the possibility of copying an older
config.inc.php into the directory of any future phpMyAdmin
version.

I don’t understand why your config.inc.php was not read,
after a full browser shutdown.

— Original author: lem9

Logged In: YES
user_id=682994

sigh I reported AND diagnosed this bug, but people still don’t get it.

thowden – please re-read my latest response. The cause of the bug is due to
the default config filename getting stored in your session. The workaround is
a) don’t open PMA until your config file is in place, or b) delete your session
cookie.

lem9 – a browser shutdown doesn’t kill a session cookie. I don’t know about
‘the best possible solution’, but it seems like the kind of thing that should
immediately be patched with a “check the filesystem for a config file before
using session filename”. I’m sure this was done for efficiency’s sake, but
when it’s driving people batshit insane, I’d say it’s worth the millisecond to do
a filesystem check.

— Original author: dasil003

Logged In: YES
user_id=997838

Amen, brother! batshit insane just scratches the surface of
how frustrating this problem was. A shoutout to lancelight,
too, that’s a fantastic suggestion for fixing this problem.

I never ever ever would’ve imagined that dumping my browser
cookies would’ve been the solution to getting a server-based
web application to read it’s own config file.

In fact, I don’t think I ever got this working until I
cycled apache all the way and invalidated all previous
session ids!

— Original author: blentz

Logged In: YES
user_id=1006674

Heh! I’ve had this problem in the past, but only after
upgrades, e.g. having to kill the cookies. This has
happened to me with any number of PHP programs, not just
PMA, so this is hardly a unique problem.

Really, it’s not a good idea to leave these cookies laying
around anyway. For instance, let’s say you’re on a public
terminal — someone can come behind you and see your
username, even if you’re logged out, by simply going to the
login page — or they can stick a USB thumbdrive in the
machine and steal your entire browser profile, including all
your cookies — whatever! It’s a very unsecure thing to do…

Anyway, what I did with PMA is make an ‘exception’ to the
cookie rules in Firefox. The PMA cookie is only allowed to
exist for the length of the session. When I close my
browser, the cookie automatically goes bye-bye! End of problem!

— Original author: vindsl

Logged In: YES
user_id=210714

$cfg[LoginCookieRecall] boolean
Define whether the previous login should be recalled or
not in cookie authentication mode.

By default it’s true.

— Original author: lem9

Logged In: YES
user_id=326580

can someone please check latest CVS if the problem still
exists, i cannot reproduce the problems reported here – so i
cannot check by myself, but i changed something for another
problem, possible it helps you too …

btw.: the

@lancelight: it was me! can you please explain what is your
problem? and which one was your contribution to phpMyAdmin?

@dasil003: i cannot reproduce the behaviour your report
here: “It’s simply that the SESSION stores the config file
name, and once set only ever uses that file name.”

default config file name is stored in
PMA_Config->$default_source and user config file name is
stored in PMA_Config->$source

@dasil003: the session is cookie is not stored between
browser sessions – if you close your browser your session
WILL BE terminated – if not something is wrong with your
browser – cause session cookies have zero lifetime, so they
will be deleted with browser shutdown.

— Original author: cybot_tm

Logged In: YES
user_id=210714

Sebastian, looks good!

Here is what I tested:
1. install PMA in a fresh directory without config.inc.php
2. start it: normal error message about config not being there
3. place in the directory a config.inc.php
4. reload: message is gone, login panel appears
5. remove config.inc.php again
6. reload: normal error message about config not being there
7. put back config.inc.php
8. reload: message is gone

Now, I hope everyone who wrote in this thread take a few
minutes to test the latest CVS HEAD version and report back
here. Please…

— Original author: lem9

Logged In: YES
user_id=682994

@cybot_tm Yeah, you’re right. I don’t know what I was thinking. Maybe it’s
because when you close the window in Safari it doesn’t end the session like it
does in IE (right?), you have to quit the whole browser. At any rate, I’m glad this
appears to be fixed. Sorry I dont have time to test it at the moment, but I
appreciate your attention to it, and I’ll test it next time I’m installing a copy of
PMA.

— Original author: dasil003

— assigned_to: nobody —> cybot_tm

— Original author: lem9

Logged In: YES
user_id=210714

I mark this as fixed, hoping to get more feedback.

— Original author: lem9

— priority: 5 —> 1
— summary: Config File Not Being Read —> (ok 2.9.0) Config File Not Being Read
— status: open —> open-fixed

— Original author: lem9

Logged In: YES
user_id=682994

Okay, I just installed the latest release version and deliberately loaded it up in
Safari before installing the config. I then copied the config.inc.php in and it
worked fine in the same browser window. Problem fixed as far as I can tell.

— Original author: dasil003

— status: open-fixed —> closed-fixed

— Original author: lem9

• Status: closed-fixed —> fixed

• Original author: nijel

Установил как положено  http://ktonanovenkogo.ru/vokrug-da-okol … rojka.html
но выдает ошибку когда пытаюсь зайти: #2002 Невозможно подключиться к серверу MySQL

Судя по ошибке, вы допустили опечатку в конфигурационном файле. Покажите ваш config.inc.php.

Это означает, что либо хост MySQL задан неверно, либо доступа к MySQL нет.

<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
* phpMyAdmin sample configuration, you can use it as base for
* manual configuration. For easier setup you can use setup/
*
* All directives are explained in Documentation.html and on phpMyAdmin
* wiki <http://wiki.phpmyadmin.net>.
*
* @package PhpMyAdmin
*/

/*
* This is needed for cookie based authentication to encrypt password in
* cookie
*/
$cfg[‘blowfish_secret’] = ‘пароль’;
/*
* Servers configuration
*/
$i = 0;

/*
* First server
*/
$i++;
/* Authentication type */
$cfg[«Servers»][$i][«auth_type»] = «config»;
$cfg[«Servers»][$i][«user»] = «юзер»;
$cfg[«Servers»][$i][«password»] = «пароль»;’;
/* Server parameters */
$cfg[‘Servers’][$i][‘host’] = ‘localhost’;
$cfg[‘Servers’][$i][‘connect_type’] = ‘tcp’;
$cfg[‘Servers’][$i][‘compress’] = false;
/* Select mysql if your server does not have mysqli */
$cfg[‘Servers’][$i][‘extension’] = ‘mysqli’;
$cfg[‘Servers’][$i][‘AllowNoPassword’] = false;

/*
* phpMyAdmin configuration storage settings.
*/

/* User used to manipulate with storage */
// $cfg[‘Servers’][$i][‘controlhost’] = »;
// $cfg[‘Servers’][$i][‘controluser’] = ‘pma’;
// $cfg[‘Servers’][$i][‘controlpass’] = ‘pmapass’;

/* Storage database and tables */
// $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][‘table_uiprefs’] = ‘pma_table_uiprefs’;
// $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’;
/* Contrib / Swekey authentication */
// $cfg[‘Servers’][$i][‘auth_swekey_config’] = ‘/etc/swekey-pma.conf’;

/*
* End of servers configuration
*/

/*
* Directories for saving/loading files from server
*/
$cfg[‘UploadDir’] = »;
$cfg[‘SaveDir’] = »;

/**
* Defines whether a user should be displayed a «show all (records)»
* button in browse mode or not.
* default = false
*/
//$cfg[‘ShowAll’] = true;

/**
* Number of rows displayed when browsing a result set. If the result
* set contains more rows, «Previous» and «Next».
* default = 30
*/
//$cfg[‘MaxRows’] = 50;

/**
* Use graphically less intense menu tabs
* default = false
*/
//$cfg[‘LightTabs’] = true;

/**
* disallow editing of binary fields
* valid values are:
*   false  allow editing
*   ‘blob’ allow editing except for BLOB fields
*   ‘all’  disallow editing
* default = blob
*/
//$cfg[‘ProtectBinary’] = ‘false’;

/**
* Default language to use, if not browser-defined or user-defined
* (you find all languages in the locale folder)
* uncomment the desired line:
* default = ‘en’
*/
//$cfg[‘DefaultLang’] = ‘en’;
//$cfg[‘DefaultLang’] = ‘de’;

/**
* default display direction (horizontal|vertical|horizontalflipped)
*/
//$cfg[‘DefaultDisplay’] = ‘vertical’;

/**
* How many columns should be used for table display of a database?
* (a value larger than 1 results in some information being hidden)
* default = 1
*/
//$cfg[‘PropertiesNumColumns’] = 2;

/**
* Set to true if you want DB-based query history.If false, this utilizes
* JS-routines to display query history (lost by window close)
*
* This requires configuration storage enabled, see above.
* default = false
*/
//$cfg[‘QueryHistoryDB’] = true;

/**
* When using DB-based query history, how many entries should be kept?
*
* default = 25
*/
//$cfg[‘QueryHistoryMax’] = 100;

/*
* You can find more configuration options in Documentation.html
* or here: http://wiki.phpmyadmin.net/pma/Config
*/
?>

Думаю опечатка в этой строке:

$cfg["Servers"][$i]["password"] = "пароль";';

Правильно будет:

$cfg["Servers"][$i]["password"] = "пароль";

Подскажите, у меня такая же ситуация :  Ошибка при чтении конфигурационного файла

Вот содержание моего config.inc, вроде все перепроверил, опечаток не вижу

<?php
  $i = 0;
  $i++;
  $cfg[‘Servers’][$i][‘host’] = ‘localhost’;
  $cfg[‘Servers’][$i][‘extension’] = ‘mysqli’;
  $cfg[‘Servers’][$i][‘connect_type’] = ‘tcp’;
  $cfg[‘Servers’][$i][‘compress’] = false;
  $cfg[‘Servers’][$i][‘auth_type’] = ‘config’;
  $cfg[‘Servers’][$i][‘user’] = ‘root’;
  $cfg[‘Servers’][$i][‘password’] = ‘1234’;
  $cfg[‘Servers’][$i][‘controlhost’] = ‘localhost’;
  $cfg[‘Servers’][$i][‘controluser’] = ‘pma’;
  $cfg[‘Servers’][$i][‘controlpass’] = ‘1234’;
  $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’;
?>

Спасибо, жду ответа.

Опечаток нет. Возможно конфигурационный файл был сохранен в Блокноте, который добавляет Бом-байт. Попробуйте сохранить конфигурационный файл в Notepad++, или отредактируйте тот, что идет по умолчанию.

Пжста, проверьте мой тоже, аналогичная проблема

<h1>Ошибка при чтении конфигурационного файла</h1>Обычно это означает наличие синтаксических ошибок, пожалуйста, проверьте выведенные ниже ошибки.<br /><br /><iframe src=»show_config_errors.php» />

<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
* phpMyAdmin sample configuration, you can use it as base for
* manual configuration. For easier setup you can use setup/
*
* All directives are explained in Documentation.html and on phpMyAdmin
* wiki <http://wiki.phpmyadmin.net>.
*
* @package PhpMyAdmin
*/

/*
* This is needed for cookie based authentication to encrypt password in
* cookie
*/
$cfg[‘blowfish_secret’] = ‘a8b7c6d’; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

/*
* Servers configuration
*/
$i = 0;

/*
* First server
*/
$i++;
/* Authentication type */
$cfg[‘Servers’][$i][‘auth_type’] = ‘config’;
/* Server parameters */
$cfg[‘Servers’][$i][‘host’] = ‘127.0.0.1’;
$cfg[‘Servers’][$i][‘connect_type’] = ‘tcp’;
$cfg[‘Servers’][$i][‘compress’] = false;
/* Select mysql if your server does not have mysqli */
$cfg[‘Servers’][$i][‘extension’] = ‘mysqli’;
$cfg[‘Servers’][$i][‘AllowNoPassword’] = 3PNG7XGpzp9B5KNK;

/*
* phpMyAdmin configuration storage settings.
*/

/* User used to manipulate with storage */
$cfg[‘Servers’][$i][‘controlhost’] = ‘localhost’;
$cfg[‘Servers’][$i][‘controluser’] = ‘root’;
$cfg[‘Servers’][$i][‘controlpass’] = »;

/* Storage database and tables */
$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][‘table_uiprefs’] = ‘pma_table_uiprefs’;
$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’;
/* Contrib / Swekey authentication */
// $cfg[‘Servers’][$i][‘auth_swekey_config’] = ‘/etc/swekey-pma.conf’;

/*
* End of servers configuration
*/

/*
* Directories for saving/loading files from server
*/
$cfg[‘UploadDir’] = ‘/tmp’;
$cfg[‘SaveDir’] = ‘/tmp’;

/**
* Defines whether a user should be displayed a «show all (records)»
* button in browse mode or not.
* default = false
*/
//$cfg[‘ShowAll’] = true;

/**
* Number of rows displayed when browsing a result set. If the result
* set contains more rows, «Previous» and «Next».
* default = 30
*/
//$cfg[‘MaxRows’] = 50;

/**
* Use graphically less intense menu tabs
* default = false
*/
//$cfg[‘LightTabs’] = true;

/**
* disallow editing of binary fields
* valid values are:
*   false  allow editing
*   ‘blob’ allow editing except for BLOB fields
*   ‘all’  disallow editing
* default = blob
*/
//$cfg[‘ProtectBinary’] = ‘false’;

/**
* Default language to use, if not browser-defined or user-defined
* (you find all languages in the locale folder)
* uncomment the desired line:
* default = ‘en’
*/
$cfg[‘DefaultLang’] = ‘ru’;
//$cfg[‘DefaultLang’] = ‘de’;

/**
* default display direction (horizontal|vertical|horizontalflipped)
*/
//$cfg[‘DefaultDisplay’] = ‘vertical’;

/**
* How many columns should be used for table display of a database?
* (a value larger than 1 results in some information being hidden)
* default = 1
*/
//$cfg[‘PropertiesNumColumns’] = 2;

/**
* Set to true if you want DB-based query history.If false, this utilizes
* JS-routines to display query history (lost by window close)
*
* This requires configuration storage enabled, see above.
* default = false
*/
//$cfg[‘QueryHistoryDB’] = true;

/**
* When using DB-based query history, how many entries should be kept?
*
* default = 25
*/
//$cfg[‘QueryHistoryMax’] = 100;

/*
* You can find more configuration options in Documentation.html
* or here: http://wiki.phpmyadmin.net/pma/Config
*/
?>

rasel@rasel-Dell:~$ sudo -s
rasel@rasel-Dell:~$ type your password
root@rasel-Dell:/# cd /opt/lampp/phpmyadmin
root@rasel-Dell:/opt/lampp/phpmyadmin# chmod 644 config.inc.php
root@rasel-Dell:/opt/lampp/phpmyadmin# cd /
root@rasel-Dell: /opt/lampp/lampp restart

That’s all, it works for me.

For OSX Mavericks and XAMPP 1.8.2-5 and 1.8.3-4 versions, you need to use the same chmod 644 mentioned above, but the directory is different.

cd /Applications/XAMPP/xamppfiles/phpmyadmin/
sudo chmod 644 config.inc.php
[enter your password]

answered Apr 17, 2014 at 4:24

cd /Applications/XAMPP/xamppfiles/phpmyadmin/
sudo chmod 777 config.inc.php
[enter your password]

After you change your config.inc.php, you need to type:

sudo chmod 644 config.inc.php

Only sudo chmod 644 didnt work for me.