Webhost won't upgrade to 4.1

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
User avatar
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

Post by Ambush Commander »

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?
Charles256
DevNet Resident
Posts: 1375
Joined: Fri Sep 16, 2005 9:06 pm

Post by Charles256 »

get a new host. if your satisfaction was gaurenteed demand they upgrade or you want a refund since you aer NOT satisfied.. worth a try..
User avatar
Maugrim_The_Reaper
DevNet Master
Posts: 2704
Joined: Tue Nov 02, 2004 5:43 am
Location: Ireland

Post by Maugrim_The_Reaper »

4.0 is standard. Won't any 4.1 upgrading because of compatibility, and/or that it needs mysqli (I think) from PHP5.

Its a double whammy, don't expect a solution outside a small minority of shared hosts, or a dedicated server you can configure as you please...
User avatar
trukfixer
Forum Contributor
Posts: 174
Joined: Fri May 21, 2004 3:14 pm
Location: Miami, Florida, USA

Post by trukfixer »

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:

Code: Select all

select old_password('whatever_pass');
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!
User avatar
Ambush Commander
DevNet Master
Posts: 3698
Joined: Mon Oct 25, 2004 9:29 pm
Location: New Jersey, US

Post by Ambush Commander »

Hmm, Maugrim The Reaper, is that really true? I have access to two other hosting provider accounts, Bluehost and Dreamhost, and both use MySQL 4.1.

Edit - I know about the password issue: it was my biggest issue when I was setting up MySQL locally. But it can be done. :)
User avatar
Burrito
Spockulator
Posts: 4715
Joined: Wed Feb 04, 2004 8:15 pm
Location: Eden, Utah

Post by Burrito »

4.1 does NOT require mysqli for php 5.

Internally here we have 4.1 running on several servers wtih php 5 and have not had any issues (using mysql only).

I *think* the biggest problem (from the host's perspective) is the collation incompatiabilites between 4.1 and ealier versions.
d3ad1ysp0rk
Forum Donator
Posts: 1661
Joined: Mon Oct 20, 2003 8:31 pm
Location: Maine, USA

Post by d3ad1ysp0rk »

Oh stop whining, my company's test server runs 3.0. :P
User avatar
Ambush Commander
DevNet Master
Posts: 3698
Joined: Mon Oct 25, 2004 9:29 pm
Location: New Jersey, US

Post by Ambush Commander »

my company's test server runs 3.0
Haha... well, I guess I'll have to live without it for now.
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

The stability argument for 4.0 went away when 4.1 became the production release and is even less convincing now that 5.0 is production. Host is just lazy.

Mac
Grim...
DevNet Resident
Posts: 1445
Joined: Tue May 18, 2004 5:32 am
Location: London, UK

Post by Grim... »

twigletmac wrote:Host is just lazy.
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.
fastfingertips
Forum Contributor
Posts: 242
Joined: Sun Dec 28, 2003 1:40 am
Contact:

Post by fastfingertips »

I'm wondering when they will up to version 5 since i really need stored procedures :)
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

Grim... wrote:
twigletmac wrote:Host is just lazy.
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.
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.

Mac
User avatar
Ambush Commander
DevNet Master
Posts: 3698
Joined: Mon Oct 25, 2004 9:29 pm
Location: New Jersey, US

Post by Ambush Commander »

I just don't think the stability argument is a good one especially given that 4.0 is no longer supported.
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 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).
Ree
Forum Regular
Posts: 592
Joined: Fri Jun 10, 2005 1:43 am
Location: LT

Post by Ree »

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.
Post Reply