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 6 of 6

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

  1. #1

    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

    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,311

    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,387

    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

    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

    Default

    "IT claimed they were both setup the same."

    Biggest mistake ever to believe those words

+ 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
  •