Topic: MySQL 5.x on SME Server?

[superwormy]

Has anyone installed MySQL 5.x on SME Server? Is it possible?

I need to be able to replicate from an existing MySQL 5 server to MySQL on SME Server, but MySQL won't do 5.x to 4.x replication...


UPDATE:
I was able to upgrade to MySQL 5.0.68 by doing the following at a command prompt:

yum upgrade mysql --enablerepo=centosplus
signal-event post-upgrade; signal-event reboot

mysql_upgrade
signal-event post-upgrade; signal-event reboot

I then got errors like this in /var/log/httpd/admin_access_log:
Premature end of script headers (index.cgi)
Can’t do setuid (cannot exec sperl)

Which I fixed by doing this:
yum install perl-suidperl
signal-event post-upgrade; signal-event reboot

[Igi2003]

No, it´s not possible to update MySQL from 4.X to 5.X.
You mmust use the beta3 of SME 8.0. There is MySQL 5.0 installed and PHP 5.X

K.r.

[Franco]

Has anyone installed MySQL 5.x on SME Server? Is it possible?

Sure, it runs fine. There are instructions on the wiki. Read the entire article:

Code: [Select]

[root@sme7 ~]# rpm -q mysql
mysql-5.0.62-1.el4_6


[kevinb]

Doesn't "yum upgrade mysql --enablerepo=centosplus" do it?

[Franco]

Here are the instructions:
http://wiki.contribs.org/PHP#PHP_5

[janet]

Doesn't "yum upgrade mysql --enablerepo=centosplus" do it?

Definitely not advisable to do this, as you will have incompatibility and upgrade issues.
Keep in mind that sme is a very tight combination of package versions that have been proven to work together.

[superwormy]

Franco:
Those instructions are for upgrading to PHP 5, not MySQL 5. I need MySQL 5.

Can anyone confirm whether or not this will cause problems with my existing setup, a vanilla installation of SME 7.4? I wonder why it would cause any issues, MySQL 5.x is almost entirely backwards compatible with MySQL 4.x...

[janet]

superwormy

rpm -q --whatrequires mysql

Also do an advanced search on these forums for mysql5 for more answers

[Franco]

Franco:
Those instructions are for upgrading to PHP 5, not MySQL 5. I need MySQL 5.

Oops where was I
Like Mary said there are instructions here in the forums.

I wonder why it would cause any issues

Only you can tell us that. In my case no problems so far.

[superwormy]

Thanks, I'm going to upgrade it right now and see what happens. I searched quite a bit, but most of the threads are just filled with "warning, you shouldn't do this!" or other "go search the forums" responses. Not exactly helpful.

I looked at the list of items that depend on it, and it seems like really the only things that depend on it are Horde and Turba, neither of which I'm using.

I'll post back here and let everyone know if I have any issues.

[superwormy]

Ah, well, that broke things.

I did:
yum upgrade mysql --enablerepo=centosplus

It did upgrade MySQL, and I can log in to MySQL and it seems to run fine. However, the server-manager/ URL is broken. Apache reports a 500 error. Looking in /var/log/httpd/admin_access_log I see errors that look like:

Premature end of script headers (index.cgi)
Can’t do setuid (cannot exec sperl)

I'm looking into it to see if I can find out what's going on...

[superwormy]

Doing this seems to bring the server-manager/ back to life... still testing to make sure everything else is OK.
yum install perl-suidperl

[superwormy]

Everything seems great! I've tested most things and everything seems to be chugging right along without any problems.

I'll post back if I have any problems.

[Franco]

There we go!
I was looking here to see something I did, but I don't think I had any problems, including not problems with horde.

[kevinb]

Well, and like Mary said "do this at your own risk", I have a test machine running eGroupware 1.6 after updating everything from centosplus.

Code: [Select]

yum --enablerepo=centosplus install update
I have not had any issues to date (but I am only testing eGroupware) and am planning a test upgrade to SME 8.3 B3 soon. However, "yum update" has dependency issues with packages from the SME repositories and will not update without manual intervention.

Centosplus is an approved and supported repository by Centos but not by SME.

I would not try this on a production server ....