maria-discuss team mailing list archive

[Karthick Subramanian <ksubramanian@xxxxxxxxxxxxxxx>]

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@xxxxxxxxxxxxxxxx>
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@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~maria-discuss
>> More help   : https://help.launchpad.net/ListHelp
>>
>>