Have a situation where I am either going to have to update entire system to CentOS 4 (don't want to do that) or install MySQL 4 on CentOS 3 system.
I can see rpm's for RHEL 3 on MySQL's web site.
I didn't see any packages for MySQL 4 in dev.centos.org or centosplus so I would suspect that the MySQL site is where I should get them.
Anybody recommend otherwise? Other than doing an dump of all the db's prior to installing, should I do anything else?
Craig
Craig White wrote:
try building the centos4 .src.rpm for mysql4 on your machine ? that _should_ work, and also give you some sort of an upgrade / update path. I've not tried this so cant confirm, but its well worth a try.
On 4/5/06, Karanbir Singh mail-lists@karan.org wrote:
Also, the mysql.org SRPM for MySQL 4.x on rhel3 works wonderfully. Been using it for a while. Problem is if you need other parts of the system like apache or php to be linked against MySQL 4, in which case these packages (of which there are many) need to be rebuilt AFAIK.
Cheers...james
On Wed, 2006-04-05 at 10:17 -0700, Craig White wrote:
yes, that is one horrible gotcha...but can't I keep the client library for mysql3 in place and still use php-mysql ?
Grab the mysql and mysqlclient10 SRPMs from Fedora Core 4.
As everyone seems to suggest go with the CentOS SRPM rather than the MySQL AB one. In the past when i rebuilt the MySQL AB one (on CentOS 3.5) it does not install and setup permissions as expected (i had to copy the configuration from the centOS one). There was also the mysql client library hassle. Don't forget the "old passwords" gotcha and remember to backup your existing db.
It takes ages so get the Godfather DVD and watch it :)
Improve the mailing list by performing a simple search before posting and reading the faq/etiquette. Thank you!!
__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
On Wed, 2006-04-05 at 11:12 -0700, Craig White wrote:
The CentOS-4.3 SRPM won't build as written as there is a require (in the configure.in file) for an autoconf that is newer than the one in CentOS-3.6.
I patched the SRPM to use autoconf 2.57 (which is the version in CentOS-3.6) ... it seems to be building now.
I'll let you know if it builds properly.
On Wed, 2006-04-05 at 19:19 -0700, Craig White wrote:
Nope :(
My only centos-3 build machine is in a chroot and it fails the tcp connect check for mysql.
You can d/l the SRPM here and build it on a C3 machine though, it should work if done outside a chroot:
On Wed, 2006-04-05 at 21:36 -0500, Johnny Hughes wrote:
---- fair enough. I am downloading right now but I think I am gonna go to bookstore and to dinner first before tackling this adventure and will report back. I presume that I will have to build mysqlclient10 separately and that doesn't get built by this SRPM - right?
Craig
On Wed, 2006-04-05 at 23:02 -0500, Les Mikesell wrote:
---- I'm not sure that it's easier, but I am sure that I didn't estimate the time necessary to do that migration to the client.
I am trying to work in vtiger and I had installed it before but didn't pay attention to the fact that it was a CentOS 4 box that I installed it on and in the requirements of vtiger, is MySQL 4.
So I am trying to slip in a MySQL upgrade without making it a big project.
Craig
On Wed, 2006-04-05 at 19:51 -0700, Craig White wrote:
you're welcome :)
The mysqlclient is building now, it doesn't seem to need any mods to the SRPM ... I think it will fail a similar check though as the MYSQL running on localhost on my buildmachine (outside the chroot) is on centos4.
On Wed, 2006-04-05 at 21:43 -0700, Craig White wrote:
OK ... the mysqlclient RPMS are available here ... the SRPM did not require changes, so the original one in CentOS-4.3 is applicable:
On Thu, 2006-04-06 at 05:54 -0500, Johnny Hughes wrote:
---- Early report - WOW - thanks
Using the mysql-4.1.12-3, mysql-server, mysql-devel built from the SRPMS that you created and client above...
rpm -Uvh those packages all at once and they completely replaced the equiv 3.23.58-x packages and mysql started right up and apparently the mysqldump that I did wasn't even necessary (holding on to it as a just in case).
my horde setup connected immediately (php-mysql is apparently happy) and life seems to be really, really good.
Thanks for the help. I can give you the binary RPM's that I created from your SRPMS (and the build logs) if you wish but I do have to confess...this is one of the few machines that I set up with Whitebox and haven't migrated over (in fact, John has been pretty good lately about releasing updates though the yum updates still are slow)...I'm thinking that I will maybe get 6 months to a year more from this box before I have to do something in a major type of upgrade.
Anyway - thanks for the help, it really seems to have worked wonderfully. I would suppose that if upstream releases a new SRPM (and likewise CentOS), then the spec file that I have now should be able to build it?
Craig
On Thu, 2006-04-06 at 20:55 -0700, Craig White wrote:
Yes ... if you add the last patch listed in the modified SPEC file to the new spec file from the new SRPM, you should be able to build it.
The mysqlclient built and worked as is.
Glad it worked for you.
We'll get our C3 guys to build it if they want to put it in C3 CentOSPlus.
Thanks, Johnny Hughes
-
Craig White -
Ignacio Vazquez-Abrams -
James Olin Oden -
Johnny Hughes -
Karanbir Singh -
Les Mikesell -
Matt Hyclak -
Mike Stankovic