maria-discuss team mailing list archive

[Karthick Subramanian <ksubramanian@xxxxxxxxxxxxxxx>]

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