MySQL 5.0.54 respin (to 5.0.54a)
February 8, 2008 by Jason · 56 Comments
Just a quick note, I did a respin of MySQL 5.0.54 with a patch for bug #33814. This wasn't really necessary since my binaries use OpenSSL rather than yaSSL (and the vulnerability is with the bundled yaSSL) but I know that quite a few people download my source RPMs and rebuild them, so I updated it just in case.
Since the source package used is still 5.0.54 and I am manually patching during the build process I have kept the version number at "5.0.54" and just incremented the release to "jason.2". Rest assured though, it is equivalent to 5.0.54a.
MySQL 5.0.54a Release Notes
Update (9/24/2009): Packages deleted, use the yum repository instead.
Thanks,
Always stay latest with Utter Ramblings repo., everything's fine.
I'm using RHEL4 64 bit, and was wondering how I'm suppose to install your RPMS, also will this install the mysqld in /usr/libexec/mysqld?
I mean is it like RHEL4 MySQL 4.1 stuff?
@goojs,
I would recommend that you install 'yum' and use the information at the link below. If you don't like 'yum', it is possible to use 'up2date' with a yum repository. Instructions for both are given at the link below.
http://www.jasonlitka.com/yum-repository/
Oh, and yes, 'mysqld' is installed to /usr/libexec.
Jason, for RHEL, why do you recommend yum over up2date?
Is one safer than the other?
@Jeff,
'up2date' is technically more flexible as it supports rhn, yum, and apt repos and 'yum' only supports yum repos. On the other hand, I've always found 'up2date' to be kind of slow and I've had it flake out a few times when you start to add multiple package sources.
Just letting you know that 5.0.56 was released.
Jason,
When building 5.0.56 I hit a bug in testing where I had:
subselect [ fail ]
and
"ERROR 21000: Subquery returns more than 1 row "
This patch fixes the issue if you get it:
http://lists.mysql.com/commits/42663
@Johnny,
Yup, I ran into that as well. I also added the patch for bug 33758 where "ORDER BY ... ASC" works but DESC returns an empty set (link below).
http://bugs.mysql.com/bug.php?id=33758
One thing I have not been able to do is get the package to compile under EL5. Both my 32-bit and 64-bit builds are failing before they get to the testing phase. Do you create EL5 builds or just EL4 for centosplus?
Hello Jason,
Thanks for your effort.
I am using the default rpm packages from RHEL 4. If I install your packages, am I need to uninstall the original packages first? If I donn't uninstall them, will 2 mysql, httpd.....(your packages and the default packages) running at the same time?
Thanks.
@Max,
If you update your system using up2date or yum then the old packages should be automatically removed (your data will stay behind).
It looks like 5.0.58 was released: http://dev.mysql.com/doc/refman/5.0/en/releasenotes-es-5-0-58.html
There is already an 'important security' fix in the unreleased 5.0.60, so there may be a quicker release of another new version: http://dev.mysql.com/doc/refman/5.0/en/releasenotes-es-5-0-60.html
@Jesse,
5.0.58 binaries are already up.
@Jeff,
There's no bug number next to that note. If you can find the bug or patch then I'll certainly include it in a respin.
@Jason,
In regards to the bug Jeff was talking about, it's listed as http://bugs.mysql.com/bug.php?id=32167, but currently locked since it's a security issue...
Anyway we could get a respin with http://bugs.mysql.com/32942 included since it's a performance regression?
@Jesse,
I've got the patch checked into BK for #32942 but #32167 is proving to be a bit of an annoyance... I've got a preliminary patch made but I haven't compiled yet to see if it works.
I'll let the 32-bit EL4 build run tonight and if it works I'll do the other three builds tomorrow and push it out. Note though that since the info on the bug is locked, I really won't have any way to test and make sure it's fixed.
I'm using the RHEL5 64 bit mysql-server, and I am getting this error trying to start the server:
[ERROR] Error message file '/usr/share/mysql/english/errmsg.sys' had only 463 error messages,
but it should contain at least 476 error messages
Just an update, I built the srpm on another 64-bit centos 5.1 server, installed, and all went OK. The errmsg.sys was a different size, so I overwrote the copy installed by your YUM repo and everything seems to be fine.
@Jason,
It looks like 5.1 series became production with 5.1.24 (http://dev.mysql.com/doc/refman/5.1/en/news-5-1-24.html). They've removed the RC stamp from it.
I'm getting the following error when attempting a "yum install php-cache":
http://www.jasonlitka.com/media/EL5/x86_64/php-xcache-5.2.5_1.2.2-jason.3.x86_64.rpm: [Errno -1] Header is not complete.
any ideas?
@Jesse,
I'll take a look at 5.1 sometime over the next few days. I'm not going to force 5.1 out to people though so once I get some working packages I'll probably just post links for people to download.
@Ben,
Try clearing your yum cache and then running the update again. You might have gotten a bad download.
Hey Jason, any chance you will post the 5.0.58 src.rpm? Or maybe even enable directory browsing on http://www.jasonlitka.com/media/SRPMS/
Scratch that... proxy was giving me problems. Directory browsing is on. Just missing the 5.0.58 src.rpm
I'm also using the RHEL5 64 bit mysql-server, and I am also getting this error trying to start the server:
[ERROR] Error message file '/usr/share/mysql/english/errmsg.sys' had only 463 error messages,
but it should contain at least 476 error messages
I removed the mysql packages with yum and then installed them again with yum, but I keep getting this error when I try to start up mysqld.
Anyone know a fix?
I read more carefully and installed the mysql respin source rpm.
This enabled me to start mysqld with no problems.
Thanks to Jason for providing these packages/repo/info! You're my hero today.
I noticed that the instructions to add your repository you said:
>There is one caveat to the above statement... If your 64-bit
>system includes both 32-bit and 64-bit packages by the same name
>(such as "mysql.i386" and "mysql.x86_64" ) then you will
>experience a problem unless you remove the 32-bit packages from
>your system
How might I go about removing the 32-bit packages from my system?
@Ben
The easiest way is use "yum remove "
Hi Jason,
I think I am going mad... I am using your 5.0.54a on a replicating system on Centos 5.1, but mysqld as slave is crashing consistently on a couple of simple queries:
DELETE FROM contest_score WHERE cid IN (1, 2) AND period_start >= FROM_UNIXTIME(1186347600)
DELETE FROM captcha WHERE created<DATE_SUB(NOW(),INTERVAL 1 HOUR)
(contest_score has three primary unique indices, and captcha is in memory.)
The slave doesn't crash I exclude the databases that use these queries from replicating.
My problem is that I want to compile the srpm without stripping symbols to get a meaningful stack trace.
I managed to unpack the srpm, modify the spec file to use --with-debug, but every time the symbols are stripped, even if I rename /usr/bin/strip to something else.
%define __os_install_post /usr/lib/rpm/brp-compress didn't help either (but not sure where to put it!)
What else would I have to modify to get a real debug version of the code?
Cheers,
Andy.
Jason,
I am running CentOS 4.6 with Interworx control panel on a VPS. I am interested in upgrading to MySQL 5, but for various reasons, I need to keep PHP 4 around for a little while longer. I'm actually running PHP 5 (built from source) in an alternate location, so that I have a choice of either PHP 4 or PHP 5 via suPHP.
I was directed to your site from a post on the Interworx forums. You came highly recommended, and from the comments here, I feel I can trust that your packages are legit.
I've installed your utterramblings repo in yum, but set enabled=0 to ensure that I don't upgrade anything (like PHP) accidentally. I then use the command:
yum --enablerepo=utterramblings update mysql*
Yum does its thing and eventually spits out a list of what it will update. This includes a few php dependancies (php-common, php-pdo, and php-mysql). Obviously php-mysql needs to be updated, but php-pdo is PHP 5-only and I'm not sure about php-common). Is it safe to let yum install these and keep PHP 4 working? Or is it even possible to upgrade MySQL and not PHP? Any help you can provide will be greatly appreciated.
FWIW, my "alternate" PHP5 install already has PDO and its working great.
--Jason
Kodiak,
yum --enablerepo=utterramblings --exclude=php* update mysql*
@Brian:
Thanks! I thought about doing that but I wasn't sure if it would work or not. I tried it and it worked great.
--Jason
@Jason,
Anyway you could release 5.0.66a?
http://mirror.provenscaling.com/mysql/enterprise/source/5.0/mysql-5.0.66a.tar.gz
Thank you in advance
Jesse
Are you still updating? Everything seems inactive lately.
Im angry. I did research into who was spamming me soooo fucking much on my email, and half of the websites come back to this domain. Please make a stand and do something to get rid of them. You must know how annoying it is. Below are the websites attached as the ass end of their email ie; [email protected]
Burnonly.com
bagswarn.com
laughadd.com
getfall.com
tripuse.com
about 80% of all of my spam websites link to yours actually, and thats really dumb
Hi,
I made a yum install with Jason's repository on a new VPS (CentOS5, 64Bit). I got an error message that some MySQL files conflict so I stopped the service and yum removed mysql. After that the yum install happened without any problem.
Unfortunately now MySQL does not seem to be installed.
#rpm mysql -q
mysql-5.0.45-7.el5
mysql-5.0.58-jason.2
But there should be more. Also I don't find any mysqld file on the whole server. Needless to say that 'service mysal start' only returns 'unrecognized service'. When I try to start the client (as root) it says:
#mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
I tried to install or update mysql again using yum, but now yum does not seem to work properly any more:
#yum install mysql
Loading "fastestmirror" plugin
Loading mirror speeds from cached hostfile
* utterramblings: http://www.jasonlitka.com
* base: mirror.webhost.co.nz
* updates: mirror.webhost.co.nz
* addons: mirror.webhost.co.nz
* extras: mirror.webhost.co.nz
updates : ################################################## 429/429
addons 100% |=========================| 951 B 00:00
primary.xml.gz 100% |=========================| 157 B 00:00
(process:18149): GLib-CRITICAL **: g_timer_stop: assertion `timer != NULL' failed
(process:18149): GLib-CRITICAL **: g_timer_destroy: assertion `timer != NULL' failed
Traceback (most recent call last):
File "/usr/bin/yum", line 29, in ?
yummain.main(sys.argv[1:])
File "/usr/share/yum-cli/yummain.py", line 105, in main
result, resultmsgs = base.doCommands()
File "/usr/share/yum-cli/cli.py", line 289, in doCommands
self._getTs()
File "/usr/lib/python2.4/site-packages/yum/depsolve.py", line 85, in _getTs
self._getTsInfo()
File "/usr/lib/python2.4/site-packages/yum/depsolve.py", line 91, in _getTsInfo
self._tsInfo.setDatabases(self.rpmdb, self.pkgSack)
File "/usr/lib/python2.4/site-packages/yum/__init__.py", line 537, in
pkgSack = property(fget=lambda self: self._getSacks(),
File "/usr/lib/python2.4/site-packages/yum/__init__.py", line 392, in _getSacks
self.repos.populateSack(which=repos)
File "/usr/lib/python2.4/site-packages/yum/repos.py", line 242, in populateSack
sack.populate(repo, mdtype, callback, cacheonly)
File "/usr/lib/python2.4/site-packages/yum/yumRepo.py", line 168, in populate
dobj = repo_cache_function(xml, csum)
File "/usr/lib64/python2.4/site-packages/sqlitecachec.py", line 42, in getPrimary
self.repoid))
TypeError: Can not open SQL database: unable to open database file
-------------
Sorry to post this much stuff here. I just don't know what to do now.
I tried 'yum clean all' and 'rm -f /var/lib/rpm/__db*' and 'rpm --rebuilddb. but no luck.
Any hint would be greatly appreciated.
Cheers!
Anatol
Yet another one lost to the engagement.. he's probably got nice shirts, and a haircut by now.
RIP, nerdling.
Jason, is this repository still active? Are you planning to package subversion 1.5.x?
That is too bad. Are there any alternatives available ? I do need php5 on RHEL 4.
Jason,
Are you still alive???
If anyone just needs MySQL builds, Percona now has builds which also include their high-performance and diagnostic patches!
http://www.percona.com/percona-lab.html
remi provides a repository for mysql & php: http://blog.famillecollet.com/pages/Config-en
But I haven't tested this yet. It also is missing the apache rpms.
you are a fucking moron
I think the guy died...
He was apparently alive in September (http://www.engadget.com/profile/2218801/).
I hope he's just got really busy on something else or building a family.
Meanwhile, if you're looking for later versions of php/mysql on Centos 5 then try
http://www.atomicorp.com/channels/atomic/
atomic-release-1.0-7.el5.art
I'm using this for http://ce-faci.ro and is working well.
Jason, hope you're OK... please give us a sign!
Andy.
http://yum.aclub.net/pub/linux/centos/5/umask/
Will you release RPMs for MySQL 5.1 ? Seems quite difficult to find them.
I found that link: http://blog.famillecollet.com/pages/Config-en
Luca, you can find mysql51 package now in my testing repo:
http://yum.aclub.net/pub/linux/centos/5/umask-testing/
after testing I'll push it into release repo (just 'umask' repo).
After install umask-testing repo just type `yum install mysql51' (note: mysql51 conflicts with mysql-5.0.*).
Thanks Jason! Peculiarity for me under CentOS 5.2... trying to install packages for mysql-devel with only
perl-DBD-MySQL-3.0007-2.el5
mysql-5.0.58-jason.2
mysql-server-5.0.58-jason.2
installed (ie. your packages), yum wants to install mysql-5.0.45-7.el5 (???) which of course fails a bunch of dependencies/causes a bunch of conflicts. Anybody got any ideas about this one?
So while this repository was once wonderful and an answer to all our prayers, it looks like it is now dead. This, the most recent post, is more than a year old. Even CentosPlus has more recent versions of MySQL, though only barely.
There are known critical DoS vulnerabilities in these early versions of mysql.
Anyone found any up-to-date php/apache/mysql repositories?