Categories
MySQL

MySQL 5.1.44 is available for Debian 5.0 “Lenny”

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.

36 replies on “MySQL 5.1.44 is available for Debian 5.0 “Lenny””

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

# 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

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

@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.

By Post Author

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.

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!

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.

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?

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

J

@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”? 🙂 )

By Post Author

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…

@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.

By Post Author

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.”

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.

@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.

By Post Author

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

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.

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.

Comments are closed.