PHP5/SQL5 Upgrades

[Schack]

Originally Posted by Rockoids

The issue I would have is whether the APC cache would cause any problems on a HostGator server, and whether it would be useful for other than vBulletin forums.

If it would work, perhaps I can get assistance from a PHP expert here to install it on my dedicated box.

A PHP opcode cache like APC will increase performance on most PHP applications.
I've been running it for years on some of my servers without any problems at all.

[Rockoids]

Originally Posted by Schack

A PHP opcode cache like APC will increase performance on most PHP applications.
I've been running it for years on some of my servers without any problems at all.

Any downsides?

Any volunteers to help me install it?

[Rockoids]

Never mind, I had support do it, since i have a dedicated box.

Things seem snapper now, but, as a consequence, you need to disable any caching plugins for WordPress, or at least WP Super Cache, since it totally discombobulated my blog and delivered an Internal Server Error. But once all vestiges of the caching utility and the appropriate entry in the "config" file were removed, it seems all right.

So far.

If anyone has any horror stories I need check, let me know.

[busy]

I've created a wiki page with information on how to easily tell if you have been upgraded yet.

Users - feel free to contribute the status of your server.
http://hgphp5.wikispaces.com/

Hostgator - no rush on these, take all the time you need to do it right. Hopefully this will ease the burden on support staff having to answer the same upgrade related questions over and over.

[Rockoids]

I wanted to update you folks about installing APC on my server, with HostGator's help, and with its removal, also with their gracious help. Thanks guys.

In any case, I found it a waste of time, really.

As you know, it has a problem with Zend, but since I don't use any Zend-savvy scripts, that didn't trouble me.

However, I failed to find any improvement in my forums and WordPress sites.

If anyone has actually seen any improvement with any of these server-side caching utilities -- and they don't deliver problems of their own -- let me know.

[X Prime]

...I have the feeling that Hostgator is messing up the upgrade on gator25 in a big way. And I opted out of having my tables and PHP messed with no less.

[CathInfo]

Well, I got my site working in PHP5, but not on Hostgator!

Fortunately I am the site admin for a client who owns their own webserver. So I installed PHP 5.2.5, and tested out my same codebase and everything works perfectly!

So I think the reason I can't get my site to work on Hostgator is one of their default settings (register_globals = off) or something similar. I used php.ini uploaded EVERYWHERE and in fact I verified that it was set by using php_info() -- but perhaps there's some place I missed, or some other configuration issue.

Long story short -- on a normal machine that I have full control of, using the default settings of EasyApache (and a modification to PHP.INI -- mostly register_globals and register_long_arrays) I got my site to work.

Yet for whatever reason, there are problems WITH THAT SAME WEBSITE when I turn PHP5 on in my Hostgator account. Why?

Matthew

[slapshotw]

Originally Posted by X Prime

...I have the feeling that Hostgator is messing up the upgrade on gator25 in a big way. And I opted out of having my tables and PHP messed with no less.

FYI-- as far as has been announced, no tables were going to be changed, but you can't opt-out of the MySQL 5 upgrade (not sure if by "tables messed with" you were referring to the MySQL upgrade or their automatic-fixing of problems).

[SandyFish]

WOW! I'm pretty new at web building - and barely know WHAT php is... Has the change been made? It's hard to tell from the posts dates on other forum pages. NO problems with any of my sites

[drewla]

Hi

Is there a guide to when particular servers are scheduled for mySQL/PHP upgrade?

From what I can see, mine hasn't yet been done. I'm in the middle of migrating to HG and ideally need to get this finished within a couple of weeks. The move includes a vbulletin forum which is itself about to be upgraded, and they recommend versions 5 of PHP and mySQL. Would be good to have an idea so that I can plan.

Thanks.

[commando]

Originally Posted by SandyFish

WOW! I'm pretty new at web building - and barely know WHAT php is...

http://www.urbandictionary.com/define.php?term=php

[::Quick::]

Originally Posted by drewla

Hi

Is there a guide to when particular servers are scheduled for mySQL/PHP upgrade?

From what I can see, mine hasn't yet been done. I'm in the middle of migrating to HG and ideally need to get this finished within a couple of weeks. The move includes a vbulletin forum which is itself about to be upgraded, and they recommend versions 5 of PHP and mySQL. Would be good to have an idea so that I can plan.

Thanks.

It's already been mentioned at least 10 times in this thread.

Add the below code to your htaccess file and you'll have PHP5. Can't do this with MySQL though.

AddHandler application/x-httpd-php5 .php

[Prezadent]

Originally Posted by commando

http://www.urbandictionary.com/define.php?term=php

LOL, I've never seen someone link to ud for a tech acronym. o.O

[GatorPatrick]

Please see our General Announcements forum for up to date progress reports on our migrations. Last night I migrated gator13-23 and tonight I will go ahead and migrate gator24-34. We're going to take it slow on these first few batches then we will do a larger amount of servers per run. I will be posting nightly and looking for feedback as we progress.

[Prezadent]

Originally Posted by GatorPatrick

Please see our network status forum for up to date progress reports on our migrations.

Isn't that here? Anyway, nice to see some progress, looks like the updates are coming pretty fast now.

[commando]

Originally Posted by Prezadent

LOL, I've never seen someone link to ud for a tech acronym. o.O

It seemed the most amusing place to link to

[GatorPatrick]

I apologize, I meant our General Announcement forums for updates. Edited in original post.

[Abomb]

With the 50 servers a week estimate, I would guess the alphabetical name ones won't even be started on until late June or early July? By the opt out drop down list, there will be 387 total gatorXXX and with 55 roughly done, that leaves another 332 left. Divide that by the 10 a night 5 nights a week, it will be another 6 to 7 weeks on the gatorXXX ones.

With the fact that the php has been updated from the version they are putting on, how long will we have the latest of that? 5.2.6 had some security fixes to it but HG is putting on 5.2.2 if not mistaken. Not to mention the updates to MySQL.

To quote a famous great dane, "Rut roh, Shaggy."

Will our sites be open to these security holes that have been plugged?

[Abomb]

http://www.php.net/ChangeLog-5.php#5.2.6

So you can see the fixes with this update

[Rockoids]

Originally Posted by Abomb

http://www.php.net/ChangeLog-5.php#5.2.6

So you can see the fixes with this update

If you have a dedicated server, you can upgrade Apache and PHP using cPanel's Easy:Apache feature and get PHP 5.2.6. The simple installation scheme is just to retain your configuration, but modify it for the newer PHP update. That's what I did last night and everything works perfectly across all my sites.

But if you're not experienced at this stuff, ask HG to do it for you, or even cPanel support, because these installations are draconian and can occasionally fail.

[Abomb]

Originally Posted by Rockoids

If you have a dedicated server, you can upgrade Apache and PHP using cPanel's Easy:Apache feature and get PHP 5.2.6. The simple installation scheme is just to retain your configuration, but modify it for the newer PHP update. That's what I did last night and everything works perfectly across all my sites.

But if you're not experienced at this stuff, ask HG to do it for you, or even cPanel support, because these installations are draconian and can occasionally fail.

Yep. If I was on a dedicated server, I wouldn't need to even think about when things are being updated at all. Unfortunately, I'm not so posted the information here.

[Jules]

Originally Posted by Rockoids

Never mind, I had support do it, since i have a dedicated box.

Things seem snapper now, but, as a consequence, you need to disable any caching plugins for WordPress, or at least WP Super Cache, since it totally discombobulated my blog and delivered an Internal Server Error. But once all vestiges of the caching utility and the appropriate entry in the "config" file were removed, it seems all right.

So far.

If anyone has any horror stories I need check, let me know.

Hi Rock, can you be more specific on what changes you made to make your wordpress work again?
I'm in a similar situation... 500 error everywhere, i also completely removed any traces of WPSC and overwrote all the wp files ( v 2.5.1), but nothing changed, internal error keeps popping out.

[Rockoids]

Originally Posted by Jules

Hi Rock, can you be more specific on what changes you made to make your wordpress work again?
I'm in a similar situation... 500 error everywhere, i also completely removed any traces of WPSC and overwrote all the wp files ( v 2.5.1), but nothing changed, internal error keeps popping out.

Make sure your wp-config file is edited to remove the cache entry.

[Jules]

Originally Posted by Rockoids

Make sure your wp-config file is edited to remove the cache entry.

Done and i didn't get rid of that 500 error
BTW, After a clean install of wordpress (+ wp-db content & plugins restore), the super cache plugin now works again.
Weird, indeed.

[SmittenKitten]

Are you upgrading all the forums or web sites? What kind of effect will this have on my forums since I am running alot of HTML on it?

I tried to get onto my forums and recieved this message:

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, webmaster@kittenspalace.org and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.


Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.


--------------------------------------------------------------------------------

Apache/1.3.37 Server at kittenspalace.org Port 80

I'm back on them now but did the message have something to do with the upgrade?