Join us now. It is free, and it takes less than 1 minute to register.
Register now
Subscribe to our daily newsletter. It is free, and it comes with many benefits.


+ Reply to Thread
Results 1 to 7 of 7

Thread: Two "exact" same server, two different outcomes... Redhat PHP/MySQL Issue

  1. #1
    Grandmaster
    Join Date
    Jan 2014
    Posts
    2,432
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Two "exact" same server, two different outcomes... Redhat PHP/MySQL Issue

    So I inherited 2 servers, pre-prod and production. IT claimed they were both setup the same.

    This is for a company's front-facing site done in Wordpress.

    Today I decided it's time for a backup, and ran the backup plugin we have installed there, but it keeps failing when extracting on the database. It's all-in-one-migration if you were wondering.

    The error on live:

    mysql_connect(): Headers and client library minor version mismatch. Headers:50556 Library:50637

    So I did a quick sanity check and found MySQL 5.7 installed on there, whereas preprod was running 5.6 (which was working fine)

    Upgraded preprod to the same versions, made sure live was also updated

    Both servers running PHP 5.4.16 (cli) with MySQL Ver 14.14 Distrib 5.7.21

    There's no differences in either install I can pick up, but live keeps giving above error when running the backup

    Redhat distro doesn't have mysqlnd available as a package and I've tried reinstalling the php-mysql package/rebooted to no avail.

    No idea what could be wrong with this.

  2. #2
    Grandmaster
    Join Date
    May 2005
    Location
    Cape Town
    Posts
    4,858
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If you don't have these managed by config management with private repo's (where you can guarantee the software version won't change) then you can't guarantee that these are exactly the same. Tell IT to piss off...

  3. #3
    Super Grandmaster Rocket-Boy's Avatar
    Join Date
    Jul 2007
    Location
    East London
    Posts
    7,347
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Quote Originally Posted by jsheed_sa View Post
    If you don't have these managed by config management with private repo's (where you can guarantee the software version won't change) then you can't guarantee that these are exactly the same. Tell IT to piss off...
    ^This
    Also Kubernetes or Docker would solve the problem of different releases etc.
    A computer programmer is someone who, when told to "Go to Hell", sees
    the "Go to", rather than the destination, as harmful."

  4. #4
    Super Grandmaster Gnome's Avatar
    Join Date
    Sep 2005
    Location
    Cape Town
    Posts
    5,460
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Quote Originally Posted by envo View Post
    mysql_connect(): Headers and client library minor version mismatch. Headers:50556 Library:50637
    According to this your client library is trying to connect with a 5.5 version header.

    I don't use PHP nor have any insight into how it binds to mysql, but what happens on the box when you run:

    which mysql # Get the path for later
    `which mysql` --version # Get the version

    If those two line up with what you expect, you should investigate this library you are using.

    That is where I would begin at least.

  5. #5
    Grandmaster
    Join Date
    Jan 2014
    Posts
    2,432
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for the input. Everything lines up to what I expect and what is on preprod. I.T claims they have no knowledge of linux and that the company uses a 3rd party vendor for linux support, however after about 12 months I have had heard nothing from this supposed 3rd party...

  6. #6
    Grandmaster
    Join Date
    Jan 2016
    Posts
    1,002
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    "IT claimed they were both setup the same."

    Biggest mistake ever to believe those words

  7. #7
    Master IndigoIdentity's Avatar
    Join Date
    May 2010
    Posts
    633
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Run php -m on both machines, any differences in the modules that have been compiled?

    Edit:

    See this too: https://stackoverflow.com/a/14774808/2110294

    So running: php -r 'foreach (get_loaded_extensions() as $extension) echo "$extension: " . phpversion($extension) . "\n";'

    Is going to give you the version numbers of the modules what have been compiled.

    This: https://stackoverflow.com/a/10768766/2110294

    Indicates that you're going to see a version difference within the mysql / mysqli modules and this is the cause of the issue?
    Last edited by IndigoIdentity; 21-03-2018 at 02:14 AM.
    For exceptional domain support, website hosting and cloud server options visit Domains.co.za!

+ Reply to Thread

Similar Threads

  1. Replies: 15
    Last Post: 13-06-2016, 03:36 PM
  2. Replies: 6
    Last Post: 09-07-2013, 06:25 PM
  3. XBOX ONE: "Game Mode" issue with the atuomatic HDMI in switching?
    By RogerWilcoZA in forum Gaming Consoles: PS4, XBox 360,PS3, PSP, Wii, PC Vita, Wii U, 3DS, 3DS XL
    Replies: 5
    Last Post: 16-06-2013, 04:04 PM
  4. MySQL determining if there are more rows "left over" when using LIMIT.
    By redarrow in forum Software and Web Development
    Replies: 4
    Last Post: 19-03-2010, 10:40 AM
  5. Sony gains RROD sized issue as PS3 stops "doing everything"
    By I am Penguin in forum Gaming Consoles: PS4, XBox 360,PS3, PSP, Wii, PC Vita, Wii U, 3DS, 3DS XL
    Replies: 25
    Last Post: 03-03-2010, 11:02 AM

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •