Wrong local database version reported on MariaDB

  • Resolved SingingDwarf

    (@singingdwarf)


    7 years, 10 months ago

    I am running MariaDB 10.0.27 (as confirmed via phpMyAdmin) on both the source and destination servers.

    The installer tool reports the following, but allows the installation to go ahead (successfully):

    ********************************************************************************
DATABASE-ROUTINES
********************************************************************************
--------------------------------------
SERVER ENVIROMENT
--------------------------------------
MYSQL VERSION:	This Server: 5.5.5 -- Build Server: 10.0.27
TIMEOUT:	5000
MAXPACK:	16777216
SQLMODE:	NOT_SET

    Do you know why there is a mismatch between the two MySQL versions?

    NB There is also a typo in the SERVER ENVIROMENT ??

    • This topic was modified 7 years, 10 months ago by SingingDwarf.
Viewing 3 replies - 1 through 3 (of 3 total)

  • Hey @singingdwarf,

    Thanks for bringing this to our attention.

    After some research it looks like it has to do with how the mysqli_get_server_info method works.

    For a MariaDB instance 10.0.*:

    on LINUX, this returns strings like “10.0.17-MariaDB-log”
    on WINDOWS environments, this returns strings like “5.5.5-10.0.*-MariaDB-log”

    Typically we parse out the first subset to do an actual version compare. I think we may be able to find another work-a-round or provide more details in the output. We will need to regress the tests as not to break it for others…

    Thread Starter SingingDwarf

    (@singingdwarf)

    My local server (to which I am importing the database) is certainly a Linux server (Ubuntu).

    I am not sure what the OS of the web host is, but I was thinking it was also Linux – at least phpMyAdmin shows

    Server: Localhost via UNIX socket

    • This reply was modified 7 years, 10 months ago by SingingDwarf.

    It could be that different variants of Linux return different results. The note was from the PHP docs…

    https://php.net/manual/en/mysqli.get-server-info.php

    Its been added to the back-log of items to look at ??

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Wrong local database version reported on MariaDB’ is closed to new replies.

Tags