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