Koozali.org: home of the SME Server

Obsolete Releases => SME 7.x Contribs => Topic started by: superwormy on June 03, 2009, 10:17:15 PM

Title: MySQL 5.x on SME Server?
Post by: superwormy on June 03, 2009, 10:17:15 PM: 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
Title: Re: MySQL 5.x on SME Server?
Post by: Igi2003 on June 03, 2009, 11:50:10 PM: 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.
Title: Re: MySQL 5.x on SME Server?
Post by: Franco on June 04, 2009, 12:04:37 AM: Quote from: superwormy on June 03, 2009, 10:17:15 PM
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
Title: Re: MySQL 5.x on SME Server?
Post by: kevinb on June 04, 2009, 01:49:11 AM: Doesn't "yum upgrade mysql --enablerepo=centosplus" do it?
Title: Re: MySQL 5.x on SME Server?
Post by: Franco on June 04, 2009, 02:22:56 AM: Here are the instructions:
http://wiki.contribs.org/PHP#PHP_5
Title: Re: MySQL 5.x on SME Server?
Post by: janet on June 04, 2009, 06:11:06 AM: Quote from: kevinb on June 04, 2009, 01:49:11 AM
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.
Title: Re: MySQL 5.x on SME Server?
Post by: superwormy on June 04, 2009, 12:59:54 PM: 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...
Title: Re: MySQL 5.x on SME Server?
Post by: janet on June 04, 2009, 01:21:09 PM: superwormy

rpm -q --whatrequires mysql

Also do an advanced search on these forums for mysql5 for more answers
Title: Re: MySQL 5.x on SME Server?
Post by: Franco on June 04, 2009, 02:05:32 PM: Quote from: superwormy on June 04, 2009, 12:59:54 PM
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.
Quote
I wonder why it would cause any issues
Only you can tell us that. In my case no problems so far.
Title: Re: MySQL 5.x on SME Server?
Post by: superwormy on June 04, 2009, 02:19:47 PM: 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.
Title: Re: MySQL 5.x on SME Server?
Post by: superwormy on June 04, 2009, 03:05:46 PM: 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...
Title: Re: MySQL 5.x on SME Server?
Post by: superwormy on June 04, 2009, 03:12:44 PM: Doing this seems to bring the server-manager/ back to life... still testing to make sure everything else is OK.
yum install perl-suidperl
Title: Re: MySQL 5.x on SME Server?
Post by: superwormy on June 04, 2009, 03:16:22 PM: 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.
Title: Re: MySQL 5.x on SME Server?
Post by: Franco on June 04, 2009, 03:34:55 PM: 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.
Title: Re: MySQL 5.x on SME Server?
Post by: kevinb on June 04, 2009, 04:35:26 PM: 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 ....