[Maria-discuss] MariaDB upgrade 10.1 to 10.2 CentOS7

newer
[Maria-discuss] MariaDB GUI: BSL...

older
[Maria-discuss] RPM CMake build...

Karthick Subramanian

13 Nov 2017 13 Nov '17

10:11 a.m.

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

Attachments:

attachment.html (text/html — 1.3 KB)

Show replies by date

Reindl Harald

13 Nov 13 Nov

10:16 a.m.

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?

Karthick Subramanian

10:23 a.m.

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 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

Elena Stepanova

12:19 p.m.

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

Karthick Subramanian

12:43 p.m.

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 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

Reindl Harald

12:47 p.m.

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

Karthick Subramanian

12:50 p.m.

;) 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 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

Reindl Harald

12:56 p.m.

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 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

Karthick Subramanian

2:30 p.m.

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 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

Elena Stepanova

4:16 p.m.

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" 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 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

2507

Age (days ago)

2507

Last active (days ago)

List overview

Download

9 comments

3 participants

participants (3)

Elena Stepanova
Karthick Subramanian
Reindl Harald

[Maria-discuss] MariaDB upgrade 10.1 to 10.2 CentOS7

tags

participants (3)