Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: gregswallow on April 28, 2005, 11:43:51 PM

Title: SME7 Contribs (mysql 4.1 and phpmyadmin)
Post by: gregswallow on April 28, 2005, 11:43:51 PM

I don't want to take anything away from the testing and bug reports of SME7, but I wanted to share a couple contribs for SME7 - mysql 4.1 and phpmyadmin.  I don't want to start any big controversy over this though.  Lets just make it very clear from the start that this mysql upgrade will not make your server faster, and you shouldn't do it unless you have an application that has REQUIRES mysql4, not just a desire to have the latest and greatest.  And phpmyadmin is a possible security risk, so if you don't need it, then don't install that either.  Please see this page for more details:
http://no.longer.valid/phpwiki/index.php/SME7Contribs

Title: Re: SME7 Contribs (mysql 4.1 and phpmyadmin)
Post by: CharlieBrady on April 29, 2005, 12:21:25 AM

Quote from: "gregswallow"

I don't want to take anything away from the testing and bug reports of SME7, but I wanted to share a couple contribs for SME7 - mysql 4.1 and phpmyadmin.  I don't want to start any big controversy over this though.  Lets just make it very clear from the start that this mysql upgrade will not make your server faster, and you shouldn't do it unless you have an application that has REQUIRES mysql4, not just a desire to have the latest and greatest.

Greg, perhaps it would be worthwhile trying to built some mysql4 RPMs which can sit alongside mysql3. Users could then run mysql3 and mysql4 concurrently. mysql4 would just be an add-on, not used by IMP/twig/twiggy/etc, and can't/won't break standard apps or upgrade paths. You'd need different paths to the binaries, and different db directories and socket path, and different port if TCP access was enabled.

Title: SME7 Contribs (mysql 4.1 and phpmyadmin)
Post by: gregswallow on April 29, 2005, 12:47:35 AM

Sounds interesting/challenging - I found some documentation here:
http://dev.mysql.com/doc/mysql/en/multiple-unix-servers.html

A quick check of google didn't come up with any success stories of doing as you describe, but it is theoretically possible at least :-P  I'll look into it a bit more.

Title: Re: SME7 Contribs (mysql 4.1 and phpmyadmin)
Post by: Skydiver on April 29, 2005, 06:10:27 AM

Quote from: "gregswallow"

I don't want to take anything away from the testing and bug reports of SME7, but I wanted to share a couple contribs for SME7 - mysql 4.1 and phpmyadmin.  I don't want to start any big controversy over this though.  Lets just make it very clear from the start that this mysql upgrade will not make your server faster, and you shouldn't do it unless you have an application that has REQUIRES mysql4, not just a desire to have the latest and greatest.  And phpmyadmin is a possible security risk, so if you don't need it, then don't install that either.  Please see this page for more details:
http://no.longer.valid/phpwiki/index.php/SME7Contribs

Hi

Thanks Greg for the contrib

Has anyone tried these updates and did anyone note any issues.

Thanks

Title: Mysql Upgrade
Post by: Duckie on May 08, 2005, 04:20:56 AM

I am wondering if anyone has performed this upgrade.

I do not have access to a server i can test this on before doing it on my server.

If you have completed this upgrade can you let me know if if all went well.

Thank you

Title: Update MySql
Post by: Duckie on May 09, 2005, 07:57:33 AM

Hi

I did the upgrade and guess what, lucky for me it all worked since i didnt have a test server to test it on.

Thanks for the How To.

Items i needed this for are now operational.

 :-D