MySQL 5.1.39 released for Debian “Etch” and “Lenny”

October 1st, 2009 | by Guillaume Plessis |

MySQL 5.1.39 is now available on Dotdeb for Debian 4.0 “Etch” / Debian 5.0 “Lenny” in amd64/i386 flavours.

This maintenance release fixes a lot of bugs. Please note that the Lenny version introduces some hardening features.

As usual, please read the list of changes in 5.1.39 before upgrading.

Tags: , ,

  1. 15 Responses to “MySQL 5.1.39 released for Debian “Etch” and “Lenny””

  2. By vbanos on Oct 2, 2009 | Reply

    The latest innodb plugin (1.0.4) does not work with this version. Mysql server does not start at all. I’m reverting back to mysql-5.1.37…

  3. By Vide on Oct 8, 2009 | Reply

    Hi

    it seems that the postinst script doesn’t work very well. I always get this error when configuring the package

    ERROR: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ALTER TABLE user ADD column Show_view_priv enum(‘N’,'Y’) CHARACTER SET utf8 NOT ‘ at line 1

    This is weird cause the postinstall script seems just fine. Anyway I had to put an exit 0 on top of it and run mysql_upgrade manually and I get it working ok. Anyone experiencing the same problem?

  4. By Guillaume Plessis on Oct 23, 2009 | Reply

    @vbanos : I’m building new 5.1.39 packages that include a working innodb plugin. They should be available soon.

  5. By Edgard Pineda on Oct 23, 2009 | Reply

    The same here. There is a problem with these packages: they are not compiled against libmysqlclient16 !!!

  6. By Guillaume Plessis on Oct 23, 2009 | Reply

    @Edgard Pineda : What makes you say that?

    # dpkg -I mysql-server-5.1_5.1.39-0.dotdeb.1_amd64.deb
    (...)
    Depends: mysql-client-5.1 (>= 5.1.39-0.dotdeb.1), libdbi-perl, perl (>= 5.6), libc6 (>= 2.7-1), libgcc1 (>= 1:4.1.1), libmysqlclient16 (>= 5.1.36), libstdc++6 (>= 4.1.1), libwrap0 (>= 7.6-4~), zlib1g (>= 1:1.1.4), debconf (>= 0.5) | debconf-2.0, psmisc, passwd, lsb-base (>= 3.0-10)

  7. By Edgard Pineda on Oct 24, 2009 | Reply

    Well… generally we don’t use mysql-server alone, then when you try to use php5-mysql, this package is not compiled against libmysqlclient16, then the connection between apache2 and php and mysql is not good, you’ll see warning of possible conflicts.

    For example, a new compiled php5-mysql against libmysqlclient16 is missing.

  8. By Guillaume Plessis on Oct 24, 2009 | Reply

    @Edgard Pineda : Compiling PHP modules against MySQL 5.1/libmysqlclient16 would cause more pain than it brings features : In fact, there will be issues when MySQL5.0-linked Apache modules (such as auth_mysql) and MySQL5.1-linked PHP extensions are loaded together.
    Segfaults will occur as soon as a MySQL function is called.

    This behavior has changed with mysql PHP 5.3 (preview) packages as mysql native driver has replaced libmysqlclient in all the MySQL-related extensions : http://docs.php.net/manual/en/mysqli.mysqlnd.php

    Otherwise, if you want to build PHP against MySQL 5.1 (at your own risks), follow these steps :
    apt-get install libmysqlclient-dev (ensure that it’s the 5.1 version)
    apt-get source -b php5

    Good luck.

  9. By Guillaume Plessis on Oct 24, 2009 | Reply

    @Edgard Pineda : as said many times on this site, these warnings (from PHPMyAdmin?) are useless.

  10. By Edgard Pineda on Oct 24, 2009 | Reply

    Guillaume, Thank you a lot!!!

  11. By Vide on Oct 27, 2009 | Reply

    @Guillame: can you post an update when the new compilation is online in your repo? InnoDB plugin is still broken, at least for me:

    091027 16:59:49 [ERROR] Can’t open shared library ‘ha_innodb.so’ (errno: 0 API version for STORAGE ENGINE plugin is too different)

  12. By Guillaume Plessis on Oct 27, 2009 | Reply

    @Vide : I planned to upload new 5.1.39 packages, but MySQL 5.1.40 is on its way, so you’ll need a little bit more patience :)

    If you can’t wait, you’ll have to install libmysqlclient-dev that contains the appropriate .so (but it depends on libc6-dev…)

  13. By Vide on Oct 27, 2009 | Reply

    @Guillaume: mmmh just installed libmysqlclient-dev and all its dependencies and still no luck. The error is the same I’ve reported in my previous comment. Any idea?

  14. By Vide on Oct 27, 2009 | Reply

    Ok, I’m stupid, the dev package PROVIDES /usr/lib/mysql/plugin/ha_innodb_plugin.so so no need for separate plugin from innodb.com

    Sorry :)

  15. By Guillaume Plessis on Nov 2, 2009 | Reply

    @Vide : MySQL 5.1.40 has been uploaded on Dotdeb with InnoDB plugin in mysql-server-5.1

  1. 1 Trackback(s)

  2. Oct 1, 2009: Dotdeb » Blog Archive » MySQL 5.1.39 released for Debian “Etch … | Just linux！

Post a Comment