Hallo zusammen,
nach dem Aufspielen von SuSE Leap 15 auf einem neuen Rechner und einem für, für mich, holprigen Start durch die Verschiedenen Neuereungen in Leap 15, z.B.: firewalld, die Einrichtung von MySQL8.0.
Meine Fehlermeldung jetzt von phpMyAdmin lautet: mysqli_real_connect(): (HY000/2002): No such file or directory
Die Fehlermeldung in journalctl lautet: "phpMyAdmin[5181]: user denied: root (mysql-denied) from 192.168.0.2"
beim Versuch vom "localhost" ändert sich nur die IP-Adresse auf "::1".
Meine bisherige Internetrecherche hat mich bis jetzt leider nicht weitergebracht.
Ich setzte heute mal wieder auf Eure Fachkenntniss.
Zu erst meine Konfiguration:
SuSE Leap 15, Apache2, MySQL 8.0 Community Server, PHP7, phpMyAdmin 4.8.3-lp150.2.9.1
Erste große Änderung für mich, phpMyAdmin verwendet jetzt wie Ubuntu den Verzeichnisspfad "/etc/phpMyAdmin/" für die Konfiguration und nicht mehr '/srv/www/htdocs/phpMyAdmin/".
Zweite große Änderung, die "/etc/my.cnf" ist fast leer!
Hier mal beide Config-Dateien
Das PHP-Modul "mysqli" scheint für mich geladen zu sein.
Eine Änderung der "config.ini.php" wie in zahlreichen Seiten beschrieben:
Den Host von "localhost" zu '127.0.0.1' ändern und den Port von '' zu '3306' ändern bringt eine zusätzliche Meldung.
[*] Die Anmeldung am MySQL-Server ist fehlgeschlagen
[*] mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
[*]mysqli_real_connect(): (HY000/2054): The server requested authentication method unknown to the client
Fehlermeldung in journalctl weiterhin:
Die Anmeldung über die Shell läuft ohne Probleme ab.
Hier entstehen keine LOG-Einträge
Ist phpMyAdmin und PHP7 nicht mehr Kompatibel?
Welches Verzeichniss wird gesucht, wo sollte es sein und wo wird es Eingetragen?
Es Grüßt nach Tagelangem suchen
daddy.k
nach dem Aufspielen von SuSE Leap 15 auf einem neuen Rechner und einem für, für mich, holprigen Start durch die Verschiedenen Neuereungen in Leap 15, z.B.: firewalld, die Einrichtung von MySQL8.0.
Meine Fehlermeldung jetzt von phpMyAdmin lautet: mysqli_real_connect(): (HY000/2002): No such file or directory
Die Fehlermeldung in journalctl lautet: "phpMyAdmin[5181]: user denied: root (mysql-denied) from 192.168.0.2"
beim Versuch vom "localhost" ändert sich nur die IP-Adresse auf "::1".
Meine bisherige Internetrecherche hat mich bis jetzt leider nicht weitergebracht.
Ich setzte heute mal wieder auf Eure Fachkenntniss.
Zu erst meine Konfiguration:
SuSE Leap 15, Apache2, MySQL 8.0 Community Server, PHP7, phpMyAdmin 4.8.3-lp150.2.9.1
Erste große Änderung für mich, phpMyAdmin verwendet jetzt wie Ubuntu den Verzeichnisspfad "/etc/phpMyAdmin/" für die Konfiguration und nicht mehr '/srv/www/htdocs/phpMyAdmin/".
Zweite große Änderung, die "/etc/my.cnf" ist fast leer!
Hier mal beide Config-Dateien
Code:
<?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 in the doc/ folder
* or at <https://docs.phpmyadmin.net/>.
*
* @package PhpMyAdmin
*/
/**
* 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
*
* Default: false
*/
/* $cfg['PmaNoRelation_DisableWarning'] = true;
/**
* Zero Configuration mode.
*
* Enables Zero Configuration mode in which the user will be offered a choice
* to create phpMyAdmin configuration storage in the current database or use
* the existing one, if already present.
*
* Note: If there is no central configuration storage defined then you may end
* up with different set of phpMyAdmin configuration storage tables for
* different databases.
*
* Default: true
*/
$cfg['ZeroConf'] = false;
/**
* Disable the default warning that is displayed if Suhosin is detected
*
* Default: false
*/
/* $cfg['SuhosinDisableWarning'] = true;
/**
* Default language to use, if not browser-defined or user-defined
*
* Default: en
*/
/* $cfg['DefaultLang'] = 'de';
/**
* This is needed for cookie based authentication to encrypt password in
* cookie. Needs to be 32 chars long.
*
* YOU MUST FILL IN THIS FOR COOKIE AUTH!
*/
$cfg['blowfish_secret'] = '9VBvL2pHBjJZRcBkBKZbem1kPjy04mIW3I4of1kVcayDVu';
/**
* Servers configuration
*
* for more info/explanation about these VARS have look at
* libraries/config.default.php
*/
$i = 0;
/**
* First server
*/
$i++;
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['ssl'] = false;
$cfg['Servers'][$i]['connect_type'] = 'socket';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['AllowNoPassword'] = false;
$cfg['Servers'][$i]['AllowRoot'] = true;
$cfg['Servers'][$i]['SignonSession'] = '';
$cfg['Servers'][$i]['SignonURL'] = '';
$cfg['Servers'][$i]['LogoutURL'] = '';
$cfg['Servers'][$i]['only_db'] = '';
$cfg['Servers'][$i]['verbose'] = '';
$cfg['Servers'][$i]['verbose_check'] = true;
$cfg['Servers'][$i]['AllowDeny']['order'] = '';
$cfg['Servers'][$i]['AllowDeny']['rules'] = array();
/**
* phpMyAdmin configuration storage settings.
*
* for more info/explanation about these VARS have look at
* libraries/config.default.php
*/
/* User used to manipulate with storage */
$cfg['Servers'][$i]['controlhost'] = 'localhost';
$cfg['Servers'][$i]['controlport'] = '';
/*
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = 'pmapass';
/**
* The name of the database containing the phpMyAdmin configuration storage.
*
* For a whole set of additional features (bookmarks, comments, SQL-history,
* tracking mechanism, PDF-generation, column contents transformation, etc.)
* you need to create a set of special tables. Those tables can be located in
* your own database, or in a central database for a multi-user installation
* (this database would then be accessed by the controluser, so no other user
* should have rights to it).
*
* Default: ''
*
*/
/* $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
/* Other Storage tables */
$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]['userconfig'] = 'pma__userconfig';
$cfg['Servers'][$i]['recent'] = 'pma__recent';
$cfg['Servers'][$i]['favorite'] = 'pma__favorite';
$cfg['Servers'][$i]['users'] = 'pma__users';
$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
$cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';
$cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';
$cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';
$cfg['Servers'][$i]['export_templates'] = 'pma__export_templates';
/* $cfg['Servers'][$i]['auth_swekey_config'] = '';
/**
* Second Server
*/
/*
$i++;
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['ssl'] = false;
$cfg['Servers'][$i]['connect_type'] = 'socket';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['AllowNoPassword'] = false;
$cfg['Servers'][$i]['AllowRoot'] = true;
$cfg['Servers'][$i]['SignonSession'] = '';
$cfg['Servers'][$i]['SignonURL'] = '';
$cfg['Servers'][$i]['LogoutURL'] = '';
$cfg['Servers'][$i]['only_db'] = '';
$cfg['Servers'][$i]['verbose'] = '';
$cfg['Servers'][$i]['verbose_check'] = true;
$cfg['Servers'][$i]['AllowDeny']['order'] = '';
$cfg['Servers'][$i]['AllowDeny']['rules'] = array();
*/
/*
* phpMyAdmin configuration storage settings.
*/
/*
$cfg['Servers'][$i]['controlhost'] = 'localhost';
$cfg['Servers'][$i]['controlport'] = '';
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = 'pmapass';
$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_cords';
$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]['userconfig'] = 'pma__userconfig';
$cfg['Servers'][$i]['recent'] = 'pma__recent';
$cfg['Servers'][$i]['users'] = 'pma__users';
$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
$cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';
$cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';
$cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';
$cfg['Servers'][$i]['export_templates'] = 'pma__export_templates';
*/
/**
* 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.
*
* Default server (0 = no default server)
*/
$cfg['ServerDefault'] = 1;
$cfg['Server'] = '0';
unset($cfg['Servers'][0]);
/**
* End of servers configuration
*/
/**
* Directories for saving/loading files from server
*/
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
/**
* Whether to display icons or text or both icons and text in table row
* action segment. Value can be either of 'icons', 'text' or 'both'.
* default = 'both'
*/
//$cfg['RowActionType'] = 'icons';
/**
* 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".
* Possible values: 25, 50, 100, 250, 500
* default = 25
*/
//$cfg['MaxRows'] = 50;
/**
* Disallow editing of binary fields
* valid values are:
* false allow editing
* 'blob' allow editing except for BLOB fields
* 'noblob' disallow 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';
/**
* 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;
/**
* Whether or not to query the user before sending the error report to
* the phpMyAdmin team when a JavaScript error occurs
*
* Available options
* ('ask' | 'always' | 'never')
* default = 'ask'
*/
//$cfg['SendErrorReports'] = 'always';
/**
* You can find more configuration options in the documentation
* in the doc/ folder or at <https://docs.phpmyadmin.net/>.
*/
Code:
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html
[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove the leading "# " to disable binary logging
# Binary logging captures changes between backups and is enabled by
# default. It's default setting is log_bin=binlog
# disable_log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
#
# Remove leading # to revert to previous value for default_authentication_plugin,
# this will increase compatibility with older clients. For background, see:
# https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_authentication_plugin
# default-authentication-plugin=mysql_native_password
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysql/mysqld.log
pid-file=/var/run/mysql/mysqld.pid
Das PHP-Modul "mysqli" scheint für mich geladen zu sein.
Code:
server0:/etc # php -m | grep mysqli
mysqli
server0:/etc #
Den Host von "localhost" zu '127.0.0.1' ändern und den Port von '' zu '3306' ändern bringt eine zusätzliche Meldung.
[*] Die Anmeldung am MySQL-Server ist fehlgeschlagen
[*] mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
[*]mysqli_real_connect(): (HY000/2054): The server requested authentication method unknown to the client
Fehlermeldung in journalctl weiterhin:
Code:
Sep 05 00:15:12 server0 phpMyAdmin[17876]: user denied: root (mysql-denied) from 192.168.0.2
Code:
server0:/etc/phpMyAdmin # mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 8.0.12 MySQL Community Server - GPL
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
Ist phpMyAdmin und PHP7 nicht mehr Kompatibel?
Welches Verzeichniss wird gesucht, wo sollte es sein und wo wird es Eingetragen?
Es Grüßt nach Tagelangem suchen
daddy.k