Ubuntu Xenial 16.04 - Cannot upgrade to i-MSCP version 1.4.4 when using MariaDB

  • I have two servers both with ubuntu 16.04 and imscp 1.4.3.


    On the first server I did upgrade to version 1.4.4 without any problems. On the second server I get the error that is in the attachment.


    On the first server there is php 7.0 while on the second server there is php 7.1.


    If I connect to the mysql server from the command line with the same credentials it connects without problems.


    How can I fix the problem?

  • @ndstyle


    If you try to connect on command line without user and password, what is the result?


    Code
    1. # mysql


    ???

    badge.php?id=1239063037&bid=2518&key=1747635596&format=png&z=547451206

  • Hi @Nuxwin.


    Thanks for reply. Here the result:



    I connect without asking for any login.


    When I configured the server I used the following command to protect mysql: mysql_secure_installation. If I run it again, it tells me that the root user is already protected by a password.

  • @ndstyle



    When I configured the server I used the following command to protect mysql: mysql_secure_installation. If I run it again, it tells me that the root user is already protected by a password.

    No need to run that script ;) The i-MSCP installer is doing the same job for you...


    Well, do you have any /root/.my.cnf file ?


    If you cannot figure out alone, give us access to the server. Right now, I cannot reproduce.

    badge.php?id=1239063037&bid=2518&key=1747635596&format=png&z=547451206

  • @Nuxwin


    I do not have that file in any of the two servers.


    Now I reset a server backup with version 1.4.3. If you need access to the server, I can send you the credentials as a private message.

  • I can send you the credentials as a private message.

    Sure, then, I'll do the update for you after eating ;) I would want be able to reproduce at least on one server to commit a fix in our development branch if needed;)

    badge.php?id=1239063037&bid=2518&key=1747635596&format=png&z=547451206

  • @ndstyle


    Don't forget to provide me with SQL root pwd ;)


    Thanks ;)

    badge.php?id=1239063037&bid=2518&key=1747635596&format=png&z=547451206

  • @ndstyle


    Done.


    Problem was due to the fact that mariadb-server was removed by i-MSCP installer due to a missing package in distribution packages file. To resume, the MariaDB server (mariadb-server-core-10.1 package) depends on the libmysqlclient18 package but other packages that are provided by Ubuntu Xenial such as libdbd-mysql-perl depends on libmysqlclient20 ...


    If you need rerun the i-MSCP installer, do it from the /usr/local/src/imscp-1.4.4/ directory for which the distribution packages file is fixed already.



    Thank you.

    badge.php?id=1239063037&bid=2518&key=1747635596&format=png&z=547451206