PHP5/SQL5 Upgrades

[naemsmommy]

Originally Posted by GatorDaveC

Hi Ron,
Yes for at least a little while, we will keep PHP4 on the servers, but as a secondary environment. To use PHP4 you would simply use "AddHandler application/x-httpd-php4 php".

Is there something similar that will let us use MySQL4 still if we need to?

[quietFinn]

Originally Posted by naemsmommy

Is there something similar that will let us use MySQL4 still if we need to?

No, there is not.

[rmccown]

Originally Posted by Jaycee29

I am the site developer for a client who is hosted on hostgator, and I have a couple of questions about this upgrade.

1) Will short_open_tag be turned on by default on PHP5? I have quite a few scripts I've written with <? ?> declaring the PHP code sections.

2) If 'no' to the first question, how can I turn it on in my client's account? I saw someone mention that directory-level php.ini files are allowed. Would I just create one in the account's root directory with short_open_tag = 'on'?

Thanks for all your help and good luck with the upgrades.

OOh, I never thought of that. Crap!

[Jordanlw]

Ooh i thought opting out form was for them NOT to upgrade your SCRIPTS to PHP5 usable.
But it seems it been they wont update you... From 4 to 5 until August...
According to the stickie.

Originally Posted by Jordanlw

Ooh i thought opting out form was for them NOT to upgrade your SCRIPTS to PHP5 usable.
But it seems it been they wont update you... From 4 to 5 until August...
According to the stickie.

No; things will be changed over to PHP5 for pretty much everyone. Those that have asked to opt out will have the option of continuing to use PHP4 for a short while. The other sticky is to inform everyone that the php4 modules/binaries/options are slated to be completely removed from the servers, even if you're opting out of this transition now. In other words, it's to give people a heads up that PHP4 is going away, no matter what, in the near future.

[jakeryan10]

Is there a way that we can test out the mysql upgrade before our hosting package is upgraded to mysql5? Something similar to how we can use the .htaccess file to try out php5 would be great but I'm not sure how this could happen w/ mysql. 99% of my sites are database driven and I don't want to leave such a big question mark of "will it work w/ mysql5" w/ the amount of sites we have. It's never fun to scramble on implementation day!

Sorry if this is a repeat question!

The only other issues I can think of is will there still be support for CURL and GD library by default in PHP5 (similar to how PHP4 is currently configured in HG). Most likely these two things will be supported but I have to ask!

Thanks, Jake

[willow1872]

I have opted out of the upgrade but im using the php5 handler in .htaccess. Am i right in thinking that i will continue to use MySQL 4 for as long as i want or am i still only delaying the upgrade?

[rmccown]

Originally Posted by willow1872

I have opted out of the upgrade but im using the php5 handler in .htaccess. Am i right in thinking that i will continue to use MySQL 4 for as long as i want or am i still only delaying the upgrade?

Yea, maybe I'm confused, too.

I opted out of the upgrade, but I'm going through my scripts with the .htaccess 'patch', testing stuff. I'm assuming that starting in March, they'll be moving over to PHP5, and my stuff will get moved, but NOT UPDATED AUTOMATICALLY.

Is that correct?

Will APC be considered to install with PHP 5.2.5? I have enabled APC with my PHP 5.2.5 box and got a great performance boost, memory reduction and much less CPU consumption

[quietFinn]

No

Originally Posted by willow1872

I have opted out of the upgrade but im using the php5 handler in .htaccess. Am i right in thinking that i will continue to use MySQL 4 for as long as i want or am i still only delaying the upgrade?

No.
When the server is upgraded to use MySQL5 your site(s) will be using MySQL5. Unlike with PHP there is NO way you could use MySQL4 in that server any more.

[quietFinn]

Originally Posted by willow1872

Ive just spoken to Scott on the phone who has told me that by opting out i will continue to use MySQL 4 for as long as i want.

Im starting to get worried.

Either you or Scott is confused, you can continue using PHP4 (but not as long as you want, but just a few months), but you can not continue using MySQL4.

[willow1872]

Originally Posted by quietFinn

Either you or Scott is confused, you can continue using PHP4 (but not as long as you want, but just a few months), but you can not continue using MySQL4.

Does it make a difference that im on a Reseller account?

[Sam]

Originally Posted by willow1872

Does it make a difference that im on a Reseller account?

Nope, it doesn't

[quietFinn]

Originally Posted by willow1872

Does it make a difference that im on a Reseller account?

No, the only difference is that reseller servers will be updated after the shared servers.

[GatorBrent]

quietFinn is right.


Everyone is being moved to php5 / mysql5 on all our shared and reseller servers. Even if you fill out the opt out form you are still being moved. The opt out form only opts you out of us playing with your script. Most scripts will work seamlessly with us modifying them, but there is a chance a small percent of scripts will break which is why the opt out was created.

After the upgrade is completed you will still be able to use php4 by modifying your .htaccess file since it will be ran in dual environment with php5. There will be no way to use mysql5 since it can't be run in a dual environment. I hope this clears up any confusion.

[DannyD]

Well since the servers are going to be on PHP5 what if we want 1 or 2 accounts to be on PHP4 how can we switch just those 2 accounts?

Thanks

[gtgeorge]

Originally Posted by prilep

Well since the servers are going to be on PHP5 what if we want 1 or 2 accounts to be on PHP4 how can we switch just those 2 accounts?

Thanks

You will be able to control where you want php4 via .htaccess. Where ever you want php4 a .htaccess will change it in that directory and all subdirectories below it. Exactly the same way it works now to use php5

You can temporarily use php4 on the one or two accounts by setting the AddHandler in your .htaccess file for those accounts. However, that is not a long term solution, as PHP4 has reached it's end of life, is no longer actively developed, and will be removed from the servers later this year regardless. So it's best to plan ahead now.

[willow1872]

I dont have a problem with PHP 5 as ive been using the htaccess code for months now with no problems but i know for a fact that CubeCart does not play well with MySQL 5 so if Scott is wrong and i have no choice but to use MySQL 5 then its time for me to look for a new provider

[jakeryan10]

So there is no way for us to try out our sites w/ mysql5 prior to the upgrade? That's a pretty huge leap of faith for me to take w/ the amount of sites I have. Is there no way to have a test server available? Even on a case by case basis that we would have to request access to and be limited to only a few days?

Originally Posted by jakeryan10

So there is no way for us to try out our sites w/ mysql5 prior to the upgrade? That's a pretty huge leap of faith for me to take w/ the amount of sites I have. Is there no way to have a test server available? Even on a case by case basis that we would have to request access to and be limited to only a few days?

I'll see if we can do something like this. The difficulty of course would be setting up the domain again, dns updates, changing file paths/configurations, etc. In other words, mirroring an existing domain over would be a pain. Lots of software hardcodes paths and domain names inside the database after setup, which adds to the difficulty.

However, using a new domain name (like test.yourdomain.com) with a fresh install may be feasible. With that said, if you're thinking it'd be useful to be able to setup a new software install on a test box to see if there'd be a problem in general, maybe we can do something like that. I'll check.

[jakeryan10]

I have NO PROBLEM putting in a little extra work now to avoid a huge headache if there is a problem. So I will do whatever it takes to get this tested out now in a php5 and mysql5 environment.

Thanks for all your help, Jake

[DYN_DaTa]

Thanks for this upgrade .

[Elijah]

This upgrade caused me problems:


Fatal error: Using $this when not in object context in blah blah on line 37

My site is down

[kmaw]

Originally Posted by Elijah

This upgrade caused me problems:


Fatal error: Using $this when not in object context in blah blah on line 37

My site is down

The upgrade doesn't even start until March 8. Better look elsewhere for your problem.