[Maria-discuss] MariaDB upgrade 10.1 to 10.2 CentOS7
All, Did anyone face issues after upgrading the mariadb from 10.1 to 10.2 to login to root user as shown below: mysql -u root I got the error - unix_socket not loaded. I noticed that the unix_socket authentication is required after the upgrade for root login from localhost. Can anyone confirm whether this is part of the feature after upgrades. In my previous version: select user, plugin from mysql.user; +-----------+------+-------------+ | Host | User | plugin | +-----------+------+-------------+ | localhost | root | | ------------------------------------ After upgrade: select user, plugin from mysql.user; +-----------+------+-------------+ | Host | User | plugin | +-----------+------+-------------+ | localhost | root | unix_socket | --------------------------------------- Regards, Karthick
After the upgrade { 1) stop mariadb service, 2) yum remove and 3) yum install mariadb-server }, I executed the script mysql_upgrade and I go the unix_socket not loaded error. # mysql_upgrade
Version check failed. Got the following error when calling the 'mysql' command line client ERROR 1524 (HY000): Plugin 'unix_socket' is not loaded FATAL ERROR: Upgrade failed
Later, I tried to mysqld-safe --skip-grant-tables and logged into MariaDB, noticed that root user for localhost contains plugin as unix_socket. On Mon, Nov 13, 2017 at 2:46 PM, Reindl Harald <h.reindl@thelounge.net> wrote:
Am 13.11.2017 um 10:11 schrieb Karthick Subramanian:
All,
Did anyone face issues after upgrading the mariadb from 10.1 to 10.2 to login to root user as shown below
did you run mysql_upgrade?
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Hi Karthick, On 11/13/2017 11:11 AM, Karthick Subramanian wrote:
All,
Did anyone face issues after upgrading the mariadb from 10.1 to 10.2 to login to root user as shown below:
mysql -u root
I got the error - unix_socket not loaded.
I noticed that the unix_socket authentication is required after the upgrade for root login from localhost. Can anyone confirm whether this is part of the feature after upgrades.
This is strange, upgrade to packages *provided by MariaDB* shouldn't do it. Packages provided by another party could be a different story. Could you please paste the output of rpm -qa | grep -iE 'mariadb|mysql' or alike?
In my previous version:
select user, plugin from mysql.user;
+-----------+------+-------------+ | Host | User | plugin | +-----------+------+-------------+ | localhost | root | | ------------------------------------
After upgrade:
select user, plugin from mysql.user;
+-----------+------+-------------+ | Host | User | plugin | +-----------+------+-------------+ | localhost | root | unix_socket | ---------------------------------------
The other way round is more common -- some variations of 10.1 did set unix_socket authentication for local root and could have it enabled by default, and then after upgrade to regular 10.2 unix_socket would become disabled while root would still require it. Is it possible that your previous installation points at a different data directory, while the old one that 10.2 now uses had this kind of configuration before? Regards, Elena
Regards, Karthick
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Hi Elena, [root@one server ~]# rpm -qa | grep -iE 'mariadb|mysql' MariaDB-client-10.2.9-1.el7.centos.x86_64 MariaDB-compat-10.2.9-1.el7.centos.x86_64 MariaDB-common-10.2.9-1.el7.centos.x86_64 MariaDB-server-10.2.9-1.el7.centos.x86_64 [root@another server~]# rpm -qa | grep -iE 'mariadb|mysql' pcp-pmda-mysql-3.10.6-2.el7.x86_64 MariaDB-client-10.2.10-1.el7.centos.x86_64 MariaDB-server-10.2.10-1.el7.centos.x86_64 MariaDB-common-10.1.18-1.el7.centos.x86_64 Steps: I did the upgrade in two servers: In both servers (both 10.1), I follow the below steps and got ssame unix-socket not loaded error. set-up repo: curl -sS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo bash *yum update MariaDB-server MariaDB-client* MariaDB-Client installed successfully, but MariaDB-server thrown error that it couldn't update. then I remove the mariaDb-Server using below command: *yum remove MariaDB-server* then install: *yum install MariaDB-server* then mysql-upgrade: I got the error with unix-socket. Do you think yum update MariaDB-server caused this issue? Do I need to remove and then install, instead of update. Please advise. On Mon, Nov 13, 2017 at 4:49 PM, Elena Stepanova <elenst@montyprogram.com> wrote:
Hi Karthick,
On 11/13/2017 11:11 AM, Karthick Subramanian wrote:
All,
Did anyone face issues after upgrading the mariadb from 10.1 to 10.2 to login to root user as shown below:
mysql -u root
I got the error - unix_socket not loaded.
I noticed that the unix_socket authentication is required after the upgrade for root login from localhost. Can anyone confirm whether this is part of the feature after upgrades.
This is strange, upgrade to packages *provided by MariaDB* shouldn't do it. Packages provided by another party could be a different story. Could you please paste the output of rpm -qa | grep -iE 'mariadb|mysql' or alike?
In my previous version:
select user, plugin from mysql.user;
+-----------+------+-------------+ | Host | User | plugin | +-----------+------+-------------+ | localhost | root | | ------------------------------------
After upgrade:
select user, plugin from mysql.user;
+-----------+------+-------------+ | Host | User | plugin | +-----------+------+-------------+ | localhost | root | unix_socket | ---------------------------------------
The other way round is more common -- some variations of 10.1 did set unix_socket authentication for local root and could have it enabled by default, and then after upgrade to regular 10.2 unix_socket would become disabled while root would still require it.
Is it possible that your previous installation points at a different data directory, while the old one that 10.2 now uses had this kind of configuration before?
Regards, Elena
Regards, Karthick
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Am 13.11.2017 um 12:43 schrieb Karthick Subramanian:
set-up repo:
curl -sShttps://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo bash don't get me wrong but nobody right in his mind pipes a URL to sudo bash and if somebody put that as instructions on a website - well, better not say what i think
;) I got what you are saying. Actually I manually write it in repo file instead of pipe sudo bash, but for simplicity sake for the steps, I mentioned from the instruction from the site. But its a good pointer that you have mentioned about this. On Mon, Nov 13, 2017 at 5:17 PM, Reindl Harald <h.reindl@thelounge.net> wrote:
Am 13.11.2017 um 12:43 schrieb Karthick Subramanian:
set-up repo:
curl -sShttps://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo bash
don't get me wrong but nobody right in his mind pipes a URL to sudo bash and if somebody put that as instructions on a website - well, better not say what i think
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Am 13.11.2017 um 12:50 schrieb Karthick Subramanian:
;)
I got what you are saying. Actually I manually write it in repo file instead of pipe sudo bash, but for simplicity sake for the steps, I mentioned from the instruction from the site.
But its a good pointer that you have mentioned about this.
that bullshit is really on a offical page? even Adobe is capable making release packages containing repo-files and the GPG key [harry@rh:~]$ rpm -q --filesbypkg adobe-release-x86_64-1.0-1.noarch adobe-release-x86_64 /etc/pki/rpm-gpg/RPM-GPG-KEY-adobe-linux adobe-release-x86_64 /etc/yum.repos.d/adobe-linux-x86_64.repo
On Mon, Nov 13, 2017 at 5:17 PM, Reindl Harald <h.reindl@thelounge.net <mailto:h.reindl@thelounge.net>> wrote:
Am 13.11.2017 um 12:43 schrieb Karthick Subramanian:
set-up repo:
curl -sShttps://downloads.mariadb.com/MariaDB/mariadb_repo_setup <http://downloads.mariadb.com/MariaDB/mariadb_repo_setup> | sudo bash
don't get me wrong but nobody right in his mind pipes a URL to sudo bash and if somebody put that as instructions on a website - well, better not say what i think
Hi Elena, Do you think the yum update causing issue instead of yum remove and yum install in the first place. Please advise. On Nov 13, 2017 5:13 PM, "Karthick Subramanian" < ksubramanian@paycommerce.com> wrote:
Hi Elena,
[root@one server ~]# rpm -qa | grep -iE 'mariadb|mysql' MariaDB-client-10.2.9-1.el7.centos.x86_64 MariaDB-compat-10.2.9-1.el7.centos.x86_64 MariaDB-common-10.2.9-1.el7.centos.x86_64 MariaDB-server-10.2.9-1.el7.centos.x86_64
[root@another server~]# rpm -qa | grep -iE 'mariadb|mysql' pcp-pmda-mysql-3.10.6-2.el7.x86_64 MariaDB-client-10.2.10-1.el7.centos.x86_64 MariaDB-server-10.2.10-1.el7.centos.x86_64 MariaDB-common-10.1.18-1.el7.centos.x86_64
Steps:
I did the upgrade in two servers:
In both servers (both 10.1), I follow the below steps and got ssame unix-socket not loaded error.
set-up repo:
curl -sS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo bash
*yum update MariaDB-server MariaDB-client*
MariaDB-Client installed successfully, but MariaDB-server thrown error that it couldn't update.
then I remove the mariaDb-Server using below command:
*yum remove MariaDB-server*
then install:
*yum install MariaDB-server*
then mysql-upgrade:
I got the error with unix-socket.
Do you think yum update MariaDB-server caused this issue? Do I need to remove and then install, instead of update. Please advise.
On Mon, Nov 13, 2017 at 4:49 PM, Elena Stepanova <elenst@montyprogram.com> wrote:
Hi Karthick,
On 11/13/2017 11:11 AM, Karthick Subramanian wrote:
All,
Did anyone face issues after upgrading the mariadb from 10.1 to 10.2 to login to root user as shown below:
mysql -u root
I got the error - unix_socket not loaded.
I noticed that the unix_socket authentication is required after the upgrade for root login from localhost. Can anyone confirm whether this is part of the feature after upgrades.
This is strange, upgrade to packages *provided by MariaDB* shouldn't do it. Packages provided by another party could be a different story. Could you please paste the output of rpm -qa | grep -iE 'mariadb|mysql' or alike?
In my previous version:
select user, plugin from mysql.user;
+-----------+------+-------------+ | Host | User | plugin | +-----------+------+-------------+ | localhost | root | | ------------------------------------
After upgrade:
select user, plugin from mysql.user;
+-----------+------+-------------+ | Host | User | plugin | +-----------+------+-------------+ | localhost | root | unix_socket | ---------------------------------------
The other way round is more common -- some variations of 10.1 did set unix_socket authentication for local root and could have it enabled by default, and then after upgrade to regular 10.2 unix_socket would become disabled while root would still require it.
Is it possible that your previous installation points at a different data directory, while the old one that 10.2 now uses had this kind of configuration before?
Regards, Elena
Regards, Karthick
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Hi Karthick, On 11/13/2017 03:30 PM, Karthick Subramanian wrote:
Hi Elena,
Do you think the yum update causing issue instead of yum remove and yum install in the first place. Please advise.
No, I don't see how the failed yum update could possibly cause this. The failure itself upon yum update is easily reproducible and sadly expected, currently major upgrades of the server package are not supported. It does not cause the magic appearance of unix_socket in the root configuration. I tried it just in case, in different variations (hence the delay with the answer), and it does nothing of the kind. There is a known easy way to get this problem. If your 10.1.18 was installed from the *enterprise* set of packages, it would have had exactly this configuration, single local root with unix_socket and the plugin linked statically and enabled. Then, after you switch to the community 10.2 server, it of course preserves the datadir, including user configuration, but it does not have the statically linked plugin; it's a dynamic library there, not loaded by default. So, when you start the server, you can't connect. At first it seemed to contradict the output you pasted in the initial email:
In my previous version:
select user, plugin from mysql.user;
+-----------+------+-------------+ | Host | User | plugin | +-----------+------+-------------+ | localhost | root | | ------------------------------------
It reads as if that's what you had on 10.1. But after your last lists of RPM packages I'm not so sure. If this is *not* the output from the 10.1 server before the upgrade, then the explanation above is by far the most likely one. If you are sure that's the output from 10.1 before the upgrade, the next question is how reliable it is. It is obviously edited, but unclear to which extent. Regards, Elena
On Nov 13, 2017 5:13 PM, "Karthick Subramanian" <ksubramanian@paycommerce.com <mailto:ksubramanian@paycommerce.com>> wrote:
Hi Elena,
[root@one server ~]# rpm -qa | grep -iE 'mariadb|mysql' MariaDB-client-10.2.9-1.el7.centos.x86_64 MariaDB-compat-10.2.9-1.el7.centos.x86_64 MariaDB-common-10.2.9-1.el7.centos.x86_64 MariaDB-server-10.2.9-1.el7.centos.x86_64
[root@another server~]# rpm -qa | grep -iE 'mariadb|mysql' pcp-pmda-mysql-3.10.6-2.el7.x86_64 MariaDB-client-10.2.10-1.el7.centos.x86_64 MariaDB-server-10.2.10-1.el7.centos.x86_64 MariaDB-common-10.1.18-1.el7.centos.x86_64
Steps:
I did the upgrade in two servers:
In both servers (both 10.1), I follow the below steps and got ssame unix-socket not loaded error.
set-up repo:
curl -sShttps://downloads.mariadb.com/MariaDB/mariadb_repo_setup <https://downloads.mariadb.com/MariaDB/mariadb_repo_setup> | sudo bash
*yum update MariaDB-server MariaDB-client*
MariaDB-Client installed successfully, but MariaDB-server thrown error that it couldn't update.
then I remove the mariaDb-Server using below command:
*yum remove MariaDB-server*
then install:
*yum install MariaDB-server*
then mysql-upgrade:
I got the error with unix-socket.
Do you think yum update MariaDB-server caused this issue? Do I need to remove and then install, instead of update. Please advise.
On Mon, Nov 13, 2017 at 4:49 PM, Elena Stepanova <elenst@montyprogram.com <mailto:elenst@montyprogram.com>> wrote:
Hi Karthick,
On 11/13/2017 11:11 AM, Karthick Subramanian wrote:
All,
Did anyone face issues after upgrading the mariadb from 10.1 to 10.2 to login to root user as shown below:
mysql -u root
I got the error - unix_socket not loaded.
I noticed that the unix_socket authentication is required after the upgrade for root login from localhost. Can anyone confirm whether this is part of the feature after upgrades.
This is strange, upgrade to packages *provided by MariaDB* shouldn't do it. Packages provided by another party could be a different story. Could you please paste the output of rpm -qa | grep -iE 'mariadb|mysql' or alike?
In my previous version:
select user, plugin from mysql.user;
+-----------+------+-------------+ | Host | User | plugin | +-----------+------+-------------+ | localhost | root | | ------------------------------------
After upgrade:
select user, plugin from mysql.user;
+-----------+------+-------------+ | Host | User | plugin | +-----------+------+-------------+ | localhost | root | unix_socket | ---------------------------------------
The other way round is more common -- some variations of 10.1 did set unix_socket authentication for local root and could have it enabled by default, and then after upgrade to regular 10.2 unix_socket would become disabled while root would still require it.
Is it possible that your previous installation points at a different data directory, while the old one that 10.2 now uses had this kind of configuration before?
Regards, Elena
Regards, Karthick
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss <https://launchpad.net/~maria-discuss> Post to : maria-discuss@lists.launchpad.net <mailto:maria-discuss@lists.launchpad.net> Unsubscribe : https://launchpad.net/~maria-discuss <https://launchpad.net/~maria-discuss> More help : https://help.launchpad.net/ListHelp <https://help.launchpad.net/ListHelp>
participants (3)
-
Elena Stepanova -
Karthick Subramanian -
Reindl Harald