MySQL 5.1.44 is available for Debian 5.0 “Lenny”

February 21st, 2010 | by Guillaume Plessis |

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

This is primarily a bug fix release, but please read the Changelog carefully before upgrading.

Tags: , ,

  1. 36 Responses to “MySQL 5.1.44 is available for Debian 5.0 “Lenny””

  2. By m_ueberall on Feb 24, 2010 | Reply

    Hm… looks like there’s an upgrade problem (cleaning the cache and retrying didn’t work either):

    Preparing to replace mysql-common 5.1.41-3.dotdeb.1 (using …/mysql-common_5.1.44-0.dotdeb.0_all.deb) …
    Unpacking replacement mysql-common …
    dpkg: error processing /var/cache/apt/archives/mysql-common_5.1.44-0.dotdeb.0_all.deb (–unpack):
    unable to create `./etc/mysql/my.cnf’: Invalid argument
    Errors were encountered while processing:
    /var/cache/apt/archives/mysql-common_5.1.44-0.dotdeb.0_all.deb

  3. By Guillaume Plessis on Feb 24, 2010 | Reply

    @m_ueberall : please give me the output of the following command :

    “ls -al /etc/mysql/my.cnf ; file /etc/mysql/my.cnf”

    Which release of Debian are you using?

  4. By m_ueberall on Feb 24, 2010 | Reply

    # ls -al /etc/mysql/my.cnf ; file /etc/mysql/my.cnf ; cat /etc/debian_version
    -rw-r–r– 1 root root 4197 23. Jan 18:09 /etc/mysql/my.cnf
    /etc/mysql/my.cnf: ASCII English text
    5.0.4

  5. By Terry Hobart on Feb 25, 2010 | Reply

    I had problems upgrading from my lenny install too. I ran an update after the php5 security post ~ 02/22/2010. Then I changed my sources.lst to dotdeb and ran another update upgrade. I used the default answers to keep my my.cnf etc. After that mysql start failed.

    The syslog says ‘FEDERATED’ plugin disabled and mysql.plugin table missing.

    Finally the install says mysql-server5.1 & mysql-server were left unconfigured.

    Thanks in advance for any advice

  6. By Guillaume Plessis on Feb 25, 2010 | Reply

    @Terry Hobart : it’s better to install the package maintainer’s version of my.cnf and then backport your changes.
    For example, if you upgraded from MySQL 5.0, the former skip-bdb option will prevent the mysql-server-5.1 to start.

  7. By Terry Hobart on Feb 26, 2010 | Reply

    Thank you SO much. Commenting out that in my my.cnf file worked! I am such a moron! It says right in the comments that the property is dead as of 5.1.some low number.

    Thanks again for saving a fools face. I know I should use the new config files, I just had a brain seizure.

  8. By beginner on Feb 26, 2010 | Reply

    Is there any instruction available how I can upgrade my Debian (including PHP and MySQL). For me it alwyas shows the old version installed after the installation.

    A step by step instruction would be great as I am a beginner!

  9. By m_ueberall on Feb 26, 2010 | Reply

    Disregard my previous postings… the cause of the error must have been that the host file system had been damaged and required a manual fsck run.

  10. By Guillaume Plessis on Feb 28, 2010 | Reply

    @beginner : Instructions are here : http://www.dotdeb.org/instructions/

    After adding the Dotdeb-related entries to your sources.list, just run “apt-get update ; apt-get upgrade”.

  11. By jon Bennett on Mar 2, 2010 | Reply

    I’m trying to upgrade but keep getting the following error:

    Unpacking replacement mysql-server-5.1 …
    dpkg: error processing /var/cache/apt/archives/mysql-server-5.1_5.1.44-0.dotdeb.0_i386.deb (–unpack):
    trying to overwrite ‘/usr/sbin/mysqld’, which is also in package mysql-server-core-5.1 0:5.1.37-1ubuntu5.1
    dpkg-deb: subprocess paste killed by signal (Broken pipe)

    any ideas?

  12. By Guillaume Plessis on Mar 2, 2010 | Reply

    @jon Bennett : Just remove the mysql-server-core package from Ubuntu.
    FYI, Dotdeb should work with Ubuntu, but it does not provide any additional support.

  13. By jon Bennett on Mar 2, 2010 | Reply

    @Guillaume – ok, so I just do apt-get remove mysql-server-core ? Will that wipe out my databases?

    J

  14. By Guillaume Plessis on Mar 2, 2010 | Reply

    @jon Bennett : It should not wipe out your databases without any confirmation from you, but be sure to backup your data before any further manipulation (who said “as usual”? :) )

  15. By beginner on Mar 2, 2010 | Reply

    I did all steps as in the instructions but it still shows me the old mysql and php versions…not really sure what I am doing wrong…

  16. By Cyril on Mar 16, 2010 | Reply

    I used Debian etch and i need to upgrade mysql (5.0.32) to 5.1.X

    but is not working…

    please help me

  17. By Guillaume Plessis on Mar 16, 2010 | Reply

    @Cyril : take a look at http://archives.dotdeb.org/dists/etch/mysql-dfsg-5.1/5.1.43/ but please consider upgrading to Lenny.

  18. By Cyril on Mar 16, 2010 | Reply

    Je suis obliger d’upgrader vers Lenny ?

  19. By Guillaume Plessis on Mar 16, 2010 | Reply

    @Cyril : pas avec les paquets cités précédemment, mais Etch n’étant plus entretenue ni par Debian ni par Dotdeb en terme de sécurité, migrer vers Lenny est une bonne idée.

  20. By Cyril on Mar 16, 2010 | Reply

    D’accord je vais y penser.

    Lorsque je fais la manip “Instruction” je n’ai pas de message d’erreur par contre l’upgrade de mysql ne se fait pas :

    “0 packages upgraded, 0 newly installed, 0 to remove and 6 not upgraded.”

  21. By Guillaume Plessis on Mar 16, 2010 | Reply

    @Cyril : dans votre cas, la manipulation “Instructions” ne sert à rien, Etch ne fait plus partie du dépôt principal. Il faut donc récupérer les paquets un à un (selon votre architecture) à partir de http://archives.dotdeb.org/dists/etch/mysql-dfsg-5.1/5.1.43/

    Puis les installer avec dpkg -i *.deb

  22. By Cyril on Mar 16, 2010 | Reply

    D’accords et comment les installer a la main ?
    apt-get install “nom du paquet.deb” ???

  23. By Guillaume Plessis on Mar 16, 2010 | Reply

    @Cyril : avec dpkg. Un bon manuel d’utilisation, très facilement trouvé sur un moteur de recherche :

    http://doc.ubuntu-fr.org/dpkg

  24. By Cyril on Mar 16, 2010 | Reply

    Merci pour tout (merci de repondre si rapidement)

    Je teste tout ca

  25. By Cyril on Mar 16, 2010 | Reply

    j’y arrive pas, as tu un bon source.list pour etch (je vais essayer l’upgrade de la distrib)

  26. By Guillaume Plessis on Mar 16, 2010 | Reply

    @Cyril : manipuler le sources.list ne sert à rien, Etch ne fait plus partie des dépôts.

    mkdir /tmp/etch
    cd /tmp/etch
    wget http://archives.dotdeb.org/dists/etch/mysql-dfsg-5.1/5.1.43/binary-i386/libmysqlclient16_5.1.43-0.dotdeb.0_i386.deb
    wget http://archives.dotdeb.org/dists/etch/mysql-dfsg-5.1/5.1.43/binary-i386/mysql-client-5.1_5.1.43-0.dotdeb.0_i386.deb
    wget http://archives.dotdeb.org/dists/etch/mysql-dfsg-5.1/5.1.43/binary-i386/mysql-common_5.1.43-0.dotdeb.0_all.deb
    wget http://archives.dotdeb.org/dists/etch/mysql-dfsg-5.1/5.1.43/binary-i386/mysql-server-5.1_5.1.43-0.dotdeb.0_i386.deb
    dpkg -i *.deb

    En cas d’erreur : “apt-get -f install”

  27. By Cyril on Mar 16, 2010 | Reply

    pour lenny je voulais dire

    le probleme c’est qu’il veut ca : zlib1g-dev
    et je ne l’ai pas

  28. By Guillaume Plessis on Mar 16, 2010 | Reply

    @Cyril : http://www.debian.org/distrib/archive.fr.html

    te donne la liste suivante à ajouter dans ton sources.list pour satisfaire les dépendances :

    deb http://archive.debian.org/debian/ etch contrib main non-free

    Lance ensuite : apt-get update && apt-get -f install

    Rien de bien méchant, juste de la manipulation de paquet. N’hésite pas à chercher et à consulter la documentation de base de la distribution.

  29. By Cyril on Mar 16, 2010 | Reply

    Merci, je suis en train de mettre a jour vers Lenny.

    J’espere que ca va bien se passer.

  30. By Cyril on Mar 17, 2010 | Reply

    CA Y EST !!!

    >> Debian GNU/Linux 5.0 \n \l

    Merci pour tout, et a bientôt j’espère ^^

  31. By Jan on Mar 17, 2010 | Reply

    After the update it says the PHP MySQL version is 5.0.51a but MySQL server version is 5.1.44. Does it matter and how do I get them to match?

    I used aptitude update & upgrade.

  32. By Guillaume Plessis on Mar 17, 2010 | Reply

    @Jan : 5.0.51a is just the version of the libmysqlclient library PHP was built with. Don’t worry about that delta between the client side and the server side, it does not affect the PHP behaviour.

  33. By Jan on Mar 17, 2010 | Reply

    Great! Thanks, got a little worried… I guess alot of error message sounds omnious, bording doomsday warnings :)

  34. By oliver on Mar 17, 2010 | Reply

    When I try to upgrade from 5.0 to 5.1, I got following error in mysql.err:

    100317 18:45:31 [Note] Plugin ‘FEDERATED’ is disabled.
    100317 18:45:32 InnoDB: Started; log sequence number 123 1166503368
    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’) CHAR
    ACTER SET utf8 NOT ‘ at line 1
    100317 18:45:32 [ERROR] Aborting

    I found the query in postinst script and run it manually and there is no syntax error.

    Have you found the reason of this?

    Thanks.

  35. By Jaime Silva on Apr 8, 2010 | Reply

    Hello there, thanks a lot for this helpful repository… Kudos!

    I’m running your MySQL 5.1.45 in a Debian 5.0 (lenny) server.

    However I’m getting warnings from PHP because the php5-mysql (5.2.13-0.dotdeb.0) driver is depending on (and using) the old library libmysqlclient15off instead of the newer libmysqlclient16 you provide.

    Can this be fixed, please?

    Thanks a lot.

  36. By Cyril on Apr 9, 2010 | Reply

    Merci pour tout, j’ai partagé l’expérience sur mon blog :

    http://cyril-leblanc.fr/linux/354-comment-upgrader-debian-etch-4-0-vers-debian-lenny-5-0/

  1. 1 Trackback(s)

  2. Feb 21, 2010: Dotdeb » Blog Archive » MySQL 5.1.44 is available for Debian 5.0 … | Just linux！

Post a Comment