After MySQL-Update: "Headers and client library minor version mismatch"

Discussion in 'Installation/Configuration' started by bax, Apr 3, 2014.

  1. bax

    bax Member

    Hi!

    Yesterday I updated MySQL on my Wheezy server.

    Now I'm getting this error in my Cron log:

    Code:
    PHP Warning:  mysqli::mysqli(): Headers and client library minor version mismatch. Headers:50535 Library:50617 in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 62
    Is there anything I can do about this?
    Should I be worried?

    Thank you!
     
  2. srijan

    srijan New Member HowtoForge Supporter

    Please paste the output of

    Br//
    Srijan
     
  3. bax

    bax Member

    Hi @Srijan,

    Thanks for your reply.
    This is my output:

    Code:
    php5-mysqlnd - MySQL module for php5 (Native Driver)
    I'm using php 5.5 with PHP-FPM (nginx).
     
  4. srijan

    srijan New Member HowtoForge Supporter

    Hi

    Please install

    Br//
    Srijan
     
    vtochq likes this.
  5. bax

    bax Member

    Hi srijan,

    I just did.
    What is the benefit of php5-mysqlnd over php5-mysql?
    I will report back when I see that the logs stopped.
     
  6. srijan

    srijan New Member HowtoForge Supporter

    Hi

    It will remove the Mysql headers and client library minor version mismatch.

    Br//
    Srijan
     
  7. bax

    bax Member

    I know, the errors have stopped. Thank you!

    But what else is the difference between the two versions!

    Thank you!
     
  8. Ovidiu

    Ovidiu Active Member

    Didn't work for me. Same problem except I actually do have a mismatch:

    Code:
    mysql -V
    mysql  Ver 14.14 Distrib 5.6.17, for debian-linux-gnu (x86_64) using  EditLine wrapper
    Code:
    apt-get install mysql-server -u -s
    Reading package lists... Done
    Building dependency tree
    Reading state information... Done
    The following packages were automatically installed and are no longer required:
      mysql-server-5.5 mysql-server-core-5.5
    Use 'apt-get autoremove' to remove them.
    The following extra packages will be installed:
      mysql-server-5.6
    Suggested packages:
      tinyca
    The following NEW packages will be installed:
      mysql-server-5.6
    The following packages will be upgraded:
      mysql-server
    1 upgraded, 1 newly installed, 0 to remove and 1 not upgraded.
    Inst mysql-server-5.6 (5.6.17-1~dotdeb.1 packages.dotdeb.org:stable [amd64])
    Inst mysql-server [5.5.35+dfsg-0+wheezy1] (5.6.17-1~dotdeb.1 packages.dotdeb.org:stable [all])
    Conf mysql-server-5.6 (5.6.17-1~dotdeb.1 packages.dotdeb.org:stable [amd64])
    Conf mysql-server (5.6.17-1~dotdeb.1 packages.dotdeb.org:stable [all])
    Now how exactly did I get this mismatch? Any help/ideas?
     
  9. srijan

    srijan New Member HowtoForge Supporter

    Hi

    Did you installed php5-mysqlnd ??

    Br//
    Srijan
     
  10. Ovidiu

    Ovidiu Active Member

    yes and I did restart php5-fpm and was still getting the errors.
    I guess its because I really have a version mismatch?

    can try again tonight, maybe there was some caching happening somewhere but restarting php5-fpm empties the APC cache too so that shouldn't be the problem :-/
     
  11. Ovidiu

    Ovidiu Active Member

    no luck . other ideas?
     
  12. srijan

    srijan New Member HowtoForge Supporter

    HI

    Please do
    Then re-install mysql-server-5.6

    Further reinstalling
    helped at my end, may be this will help you.

    Br//
    Srijan
     
  13. Ovidiu

    Ovidiu Active Member

    no idea why but installing php5-mysqlnd again worked now.
    thanks for your help.
     

Share This Page