Topic: Why mySQL and PHP are old versions?

[mishoboss]

mysql-4.1.12
php-4.3.9
and also the other related php components. Why it is so?

[dsemuk]

SME7 is based on Centos42.

You will see that Centos uses the versions of MySQL & PHP that you mention.


Dave

[gordonr]

SME7 is based on Centos42.

You will see that Centos uses the versions of MySQL & PHP that you mention.

Correct. We will always use the stable, tested versions from CentOS/RHEL over the "latest".

[mishoboss]

SME7 is based on Centos42.

You will see that Centos uses the versions of MySQL & PHP that you mention.

Correct. We will always use the stable, tested versions from CentOS/RHEL over the "latest".

There are stable versions for php and mysql versions 5.

[gordonr]

SME7 is based on Centos42.

You will see that Centos uses the versions of MySQL & PHP that you mention.

Correct. We will always use the stable, tested versions from CentOS/RHEL over the "latest".

There are stable versions for php and mysql versions 5.

Yes, but CentOS/RHEL have not moved to them yet and we gain major benefits from staying strictly aligned with CentOS/RHEL.

If you wish to install later versions, that's fine. But the base will stay aligned with CentOS/RHEL.

[Rigger]

mysql-4.1.12
php-4.3.9
and also the other related php components. Why it is so?

Here is an upgrade script to MySQL 5.0.19. It is for SME 7 (pre/rc) versions. It uses the REHL4 standard builds.

LINK PULLED FOR FURTHER TESTING

I have tested this script on a clean install pre1, pre4 and rc1 testbed system. If you have any problems let me know so I can get it fixed. I will post to the regular contribs area once I get a response on my logon information.

Rigger
(DMusty)

[mishoboss]

Thanks a lot Rigger, this is really nice. I will test it when I install SME 7 (after about 4-5 days). It would be really great if there is such script for upgrading php to version 5. This is very important to me because I have a CMS I wrote with a lot of php 5 functions. One more time - thanks!

[gordonr]

Thanks a lot Rigger, this is really nice. I will test it when I install SME 7 (after about 4-5 days). It would be really great if there is such script for upgrading php to version 5. This is very important to me because I have a CMS I wrote with a lot of php 5 functions. One more time - thanks!

A word of caution. Pushing ahead of the base will cause issues with the next system upgrade. We spent a lot of time in SME7 development undoing the effects of update scripts and ensuring that we had a stable, consistent base.

We don't plan to mitigate the effects of update scripts in future releases. Pushing ahead of the base is absolutely your choice. But if you do so, you are on your own when things break with the next upgrade.

[gregswallow]

I'll second what Gordon just said.  And I would really prefer that scripts that update included components are not published on contribs.org.  There will definitly NOT be an "upgrade script" for SME7.

I'd also caution that the mysql5 rpms you chose to install are perhaps not the best choice.

[gregswallow]

And I would really prefer that scripts that update included components are not published on contribs.org.

OK, I thought about this (It was late when I wrote the first response)...

Rigger, would you mind doing these things?:

1.  Make a New Feature Request bug for SME Server Future suggesting that we upgrade to mysql5.  As Gordon said, at this point there is no plan to do so, but if there is a bug open, then we can track comments like "I need mysql5 for x to work", and it's good to keep the developers informed on what people think needs upgrading.
2.  Come up with a way to reverse what the script does, to get back to mysql4, and include that script/instructions as well.  
3.  Consider making it a howto rather than a script.  I remember from previous examples that sometimes the scripts ran too fast for services to start/stop before the next command was executed.
4.  Post the script (or howto) as an attachment to the SME Server Future Bug Report you make, and in the forums people can be directed to look at the bug report, rather than pointed directly to the script/howto.

Thanks, is that ok?

[gordonr]

4.  Post the script (or howto) as an attachment to the SME Server Future Bug Report you make, and in the forums people can be directed to look at the bug report, rather than pointed directly to the script/howto.

Sounds like a good approach to me. There will be people who need MySQL5/PHP5, but (from history) there will also be a lot of people who upgrade "because it is there".

[gregswallow]

4.  Post the script (or howto) as an attachment to the SME Server Future Bug Report you make, and in the forums people can be directed to look at the bug report, rather than pointed directly to the script/howto.

Sounds like a good approach to me. There will be people who need MySQL5/PHP5, but (from history) there will also be a lot of people who upgrade "because it is there".

It took a good nights sleep and a few cups of coffee to think of it

I alluded to some rpms I thought were a better choice....IE,  the mysql, mysql-server and mysqlclient14 rpms from:
http://dev.centos.org/centos/4/testing/i386/RPMS/
They will be moved to the centosplus directory on all the Centos mirrors once they've had more testing, so they're likely to be kept up to date.

I emailed Doug my version of a howto to install these rpms - I think anyone that _needs_ mysql5 should hold off for a little while until it's been sorted out what the best/safest way is to do so.

[Rigger]

4.  Post the script (or howto) as an attachment to the SME Server Future Bug Report you make, and in the forums people can be directed to look at the bug report, rather than pointed directly to the script/howto.

Sounds like a good approach to me. There will be people who need MySQL5/PHP5, but (from history) there will also be a lot of people who upgrade "because it is there".

It took a good nights sleep and a few cups of coffee to think of it

I alluded to some rpms I thought were a better choice....IE,  the mysql, mysql-server and mysqlclient14 rpms from:
http://dev.centos.org/centos/4/testing/i386/RPMS/
They will be moved to the centosplus directory on all the Centos mirrors once they've had more testing, so they're likely to be kept up to date.

I emailed Doug my version of a howto to install these rpms - I think anyone that _needs_ mysql5 should hold off for a little while until it's been sorted out what the best/safest way is to do so.

Greg - got your email and I have pulled the link to my update script. I have a system set up now for purely testing and I will post as suggested to the Bug report after Iv'e tried the test install on at least pre1, pre4 and rc1.

In my case I am trying to get a system running with PHP5 and MySQL5. We have a windows system at work using XAMPP with php5 and mysql5. I am trying to match the php and mysql at home so I can test things out at home prior to bringing them in to work.

Just as a warning though to any new comers here... Greg and Gordon are correct. Any upgrades beyond the official SME release package should not be taken lightly and taken with the understanding that these are not meant for production servers. It's on your shoulders if you think the need is worth the risk or if you just want to be the first on your block saying look what I got..... Go for it. Gotta keep the corporate machine running 24/7 you'll have to explain it to your boss if it gets knackered.