Webhost won't upgrade to 4.1
Moderator: General Moderators
- Ambush Commander
- DevNet Master
- Posts: 3698
- Joined: Mon Oct 25, 2004 9:29 pm
- Location: New Jersey, US
Webhost won't upgrade to 4.1
My Webhost (ICDSoft) won't upgrade to MySQL 4.1. This is a major blow to my efforts for i18n, as 4.1 added extensive unicode support. They say that 4.0 is more stable and making the change would cause lots of compatibility problems (old applications, etc). I say bah.
What should I do?
What should I do?
-
Charles256
- DevNet Resident
- Posts: 1375
- Joined: Fri Sep 16, 2005 9:06 pm
- Maugrim_The_Reaper
- DevNet Master
- Posts: 2704
- Joined: Tue Nov 02, 2004 5:43 am
- Location: Ireland
- trukfixer
- Forum Contributor
- Posts: 174
- Joined: Fri May 21, 2004 3:14 pm
- Location: Miami, Florida, USA
well teh biggest issue is simply a matter of a change in how mysql stores passwords between 4.0 and 4.1 Debian is now making mysql 4.1 standard on all upgrades - you dont need php5 or mysqli for 4.1 - the only issue is in how mysql's password() function works , we easily work around that by first:
and take the value it gives and do our database grants , and any php code that does a mysql query using password() needs the function changed to use old_password() in the code, to port over to mysql 4.1 . other than those two issues, we have had no problems upgrading to mysql 4.1
Bri!
Code: Select all
select old_password('whatever_pass');Bri!
- Ambush Commander
- DevNet Master
- Posts: 3698
- Joined: Mon Oct 25, 2004 9:29 pm
- Location: New Jersey, US
-
d3ad1ysp0rk
- Forum Donator
- Posts: 1661
- Joined: Mon Oct 20, 2003 8:31 pm
- Location: Maine, USA
- Ambush Commander
- DevNet Master
- Posts: 3698
- Joined: Mon Oct 25, 2004 9:29 pm
- Location: New Jersey, US
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK
-
fastfingertips
- Forum Contributor
- Posts: 242
- Joined: Sun Dec 28, 2003 1:40 am
- Contact:
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK
You have to upgrade at some point, IIRC MySQL only support two versions at a time and currently they are 4.1 and 5.0. I appreciate that 4.1 would break people's login scripts where they've been (incorrectly) using MySQL's PASSWORD() function. However, if a host knows what the major issues will be then giving plenty of warning and advice should be acceptable. I just don't think the stability argument is a good one especially given that 4.0 is no longer supported.Grim... wrote:That's not fair. If the host upgraded, there's a chance that suddenly everyone's code on the server will stop working due to depreciated methods.twigletmac wrote:Host is just lazy.
Mac
- Ambush Commander
- DevNet Master
- Posts: 3698
- Joined: Mon Oct 25, 2004 9:29 pm
- Location: New Jersey, US
Actually, that's not true: according to the docs, MySQL 4.0 is "Recent, still supported". Unless you and I are talking about different types of support.I just don't think the stability argument is a good one especially given that 4.0 is no longer supported.
I suggested making a dual setup, were the client could chose with version to use, but they said it would be too difficult to do.
Here's the funny thing: they won't offer PHP5 because it is unstable, but their version of PHP is 4.4.2-dev (something I've never heard of). And nonetheless, ICDSoft is one of the most stable hosts I've been with out of all three I've tried. Dreamhost has mysteriously gone AWOL once before, and Bluehost has a penchant for using cutting edge software (4.4.0 and all those variable reference issues).
Definately get another host. It's no argument for 4.0, 4.1 has a very nice unicode support which I would be dead without. From my own experience, my host had 4.0 installed by default and when I asked 'look, where's unicode support?' they kindly suggested an upgrade to 4.1 themselves. IMO it's just a matter of your host's willingness to help you and keep you as their client.