Per Jessen wrote:

How about installing the mysql5 package from 10.1?

That would be fine, I guess. But where do I find it? There are no 10.1 packages available in YOU or on the MySQL Web site. Peter -- Check the headers for your unsubscription address For additional commands send e-mail to suse-linux-e-help@suse.com Also check the archives at http://lists.suse.com Please read the FAQs: suse-linux-e-faq@suse.com

Per Jessen wrote:

ftp://ftp.gwdg.de/linux/suse/opensuse/distribution/SL-10.1/inst-source/suse/i586/mysql-5.0.18-16.i586.rpm

If there are no 10.1 packages in YOU, it's presumably because you have not added a 10.1 install source.

Ah! I didn't know you could do that. How is it done? And is it safe to add version 10.1 packages to a 10.0 system? I tried using the YaST Installation Source dialog, but it came up with an error saying E_no_instsrc_on_media. This was after I'd given ftp.gwdg.de as the server and /linux/suse/opensuse/distribution/SL-10.1/inst-source/suse/i586 as the directory on the server. Also, is this the right place to get stuff for AMD64? As I mentioned in the OP, my system is AMD64 x 2 (dual core). Thanks Peter -- Check the headers for your unsubscription address For additional commands send e-mail to suse-linux-e-help@suse.com Also check the archives at http://lists.suse.com Please read the FAQs: suse-linux-e-faq@suse.com

On 7/11/06, Per Jessen wrote:

Peter Bradley wrote:

...

Ah! I didn't know you could do that. How is it done?

Somewhere in YaST I think. I'm not sure

...

And is it safe to add version 10.1 packages to a 10.0 system?

Probably :-)

I would not try it. If you want to add packages from a newer/older version, then download the source rpm and recompile. If you search the archives for my name and ruby (ie. freemyer ruby) I think you will find instructions on how to do it. (I had to ask, but now I've forgotten the answer.) Greg -- Greg Freemyer The Norcross Group Forensics for the 21st Century -- Check the headers for your unsubscription address For additional commands send e-mail to suse-linux-e-help@suse.com Also check the archives at http://lists.suse.com Please read the FAQs: suse-linux-e-faq@suse.com

Keep in mind the following chain: Apache depends on PHP, PHP depends on MySQL. Updating MySQL can and will have ramifications for packages other than MySQL. Per Jessen wrote:

Greg Freemyer wrote:

...

On 7/11/06, Per Jessen wrote:

...

Peter Bradley wrote:

...

Ah! I didn't know you could do that. How is it done?

Somewhere in YaST I think. I'm not sure

...

And is it safe to add version 10.1 packages to a 10.0 system?

Probably :-)

I would not try it.

Why not Greg? If it works, it works - if it doesn't, it doesn't even install. 10.1 and 10.0 are not that fundamentally different. Given that Peter would rather not build from scratch, but still wants mysql5, trying out the package from 10.1 is a pretty good option, IMHO. Even if it installs and then for some unknown reason still doesn't work, it's easy to delete it, and re-install mysql4 from 10.0.

...

If you want to add packages from a newer/older version, then download the source rpm and recompile.

True - but Peter did not want to mess with that.

...

If you search the archives for my name and ruby (ie. freemyer ruby) I think you will find instructions on how to do it. (I had to ask, but now I've forgotten the answer.)

Something like "rpm -bb" ?

/Per

-- --Moby They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety. -- Benjamin Franklin First they came for the Jews and I did not speak out because I was not a Jew. Then they came for the Communists and I did not speak out because I was not a Communist. Then they came for the trade unionists and I did not speak out because I was not a trade unionist. Then they came for me and there was no one left to speak out for me. -- Pastor Martin Niemöller -- Check the headers for your unsubscription address For additional commands send e-mail to suse-linux-e-help@suse.com Also check the archives at http://lists.suse.com Please read the FAQs: suse-linux-e-faq@suse.com

Moby wrote:

Keep in mind the following chain: Apache depends on PHP, PHP depends on MySQL. Updating MySQL can and will have ramifications for packages other than MySQL.

Well, yeah - I should have added a YMMV somewhere, but isn't that almost implied? Again, if installing mysql5 should make your php and/or apache fall over - which I doubt very much - just delete and reinstall mysql4. It's not really a big deal. Nor is your top-posting, but I though I'd mention it anyway :-) /Per Jessen, Zürich -- Check the headers for your unsubscription address For additional commands send e-mail to suse-linux-e-help@suse.com Also check the archives at http://lists.suse.com Please read the FAQs: suse-linux-e-faq@suse.com

Moby wrote:

I tried updating to MySQL 5 on SuSE 10 and did have Apache and PHP pass out, as well as Perl DBI stuff. I am updating some servers at my site to SuSE 10.1 just to be able to get MySQL 5.

OK, I stand corrected - I'm almost tempted to try this myself now, but I don't think we've got any 10.0 servers around. /Per Jessen, Zürich -- Check the headers for your unsubscription address For additional commands send e-mail to suse-linux-e-help@suse.com Also check the archives at http://lists.suse.com Please read the FAQs: suse-linux-e-faq@suse.com

Dave Howorth wrote:

On Tue, 2006-07-11 at 13:30 -0500, Moby wrote:

...

Keep in mind the following chain: Apache depends on PHP, PHP depends on MySQL. Updating MySQL can and will have ramifications for packages other than MySQL.

I'm sorry?

Apache is a web server, extremely popular and independent of pretty much anything else.*

MySQL is a database, very popular and independent of pretty much anything else.*

PHP is a language, popular among those who care about popularity, and most often used with a web server, in which case it depends on the web server and, if you care, on the database.

So what 'chain' are you talking about?

Sure, the MySQL version is important for any programs that depend on it, but that's a tautology, no?!

Cheers, Dave

* PS Of course, there are dependencies, but neither Apache nor MySQL depends on PHP.

Dave, you are absolutely correct as to what Apache, PHP, and MySQL are. Apache, at least in the most popular configuration, invokes PHP via Apache APXS PHP modules. Hence the dependency on your installation of PHP and Apache - the PHP module for Apache is tied to both your PHP installation and your Apache installation. Now, PHP has a vast library of modules, including one for connecting to MySQL. The PHP module for connecting to MySQL invokes MySQL client libraries and the version of the PHP MySQL module you use is very much dependent on the version of the MySQL client library that particular PHP instance was compiled with - hence the tie-in between PHP and MySQL. Tautological or not, I agree with you that, academically speaking, Apache, PHP, and MySQL are completely orthogonal products. However, as implemented on most systems, especially SuSE 10 (the original question was about nuances of updating to MySQL 5 on SuSE 10) a person will have serious issues, and that is what I had attempted to warn the person about, the possible dangers of simply installing MySQL 5 on a SuSE 10 system that also has Apache and PHP on it. -- Check the headers for your unsubscription address For additional commands send e-mail to suse-linux-e-help@suse.com Also check the archives at http://lists.suse.com Please read the FAQs: suse-linux-e-faq@suse.com

On 7/11/06, Peter Bradley wrote:

Greg Freemyer wrote:

...

If you search the archives for my name and ruby (ie. freemyer ruby) I think you will find instructions on how to do it. (I had to ask, but now I've forgotten the answer.)

How do you do that. I clicked the archive link at the bottom of (every) email, but there doesn't appear to be any search facility - only browse.

Personally I have the "Mailing list ARChives" bookmarked for searching this list. http://marc.theaimsgroup.com/?l=suse-linux-e&r=1&w=2

From there I found the message I was talking about: http://marc.theaimsgroup.com/?l=suse-linux-e&m=113441658808504&w=2

Greg -- Greg Freemyer The Norcross Group Forensics for the 21st Century -- Check the headers for your unsubscription address For additional commands send e-mail to suse-linux-e-help@suse.com Also check the archives at http://lists.suse.com Please read the FAQs: suse-linux-e-faq@suse.com