LinuxQuestions.org
Latest LQ Deal: Linux Power User Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 08-19-2014, 06:26 AM   #1
dwr
LQ Newbie
 
Registered: Aug 2014
Posts: 4

Rep: Reputation: Disabled
MySQL 5.1 and PHP 5.3 install


Hi. I'm new to Linux but not to IT. I have installed Ubuntu 14.04 Desktop 32bit with the aim of using as a development web server. Thing is I need MySQL 5.1 and PHP 5.3 due requirement of a particular piece of software (SuiteCRM). Can I install these specific versions rather than the default versions? And how? Cheers
 
Old 08-19-2014, 09:30 AM   #2
YankeePride13
Member
 
Registered: Aug 2012
Distribution: Ubuntu 10.04, CentOS 6.3, Windows 7
Posts: 262

Rep: Reputation: 54
You should use the server edition of Ubuntu instead of the Desktop edition.

You can install the specific releases by building them from source.
 
Old 08-19-2014, 09:55 AM   #3
dwr
LQ Newbie
 
Registered: Aug 2014
Posts: 4

Original Poster
Rep: Reputation: Disabled
Thank you for the reply. Happy to do that. Do you have a good link that explains how to "install the specific releases by building them from source" please?
 
Old 08-19-2014, 09:55 AM   #4
YankeePride13
Member
 
Registered: Aug 2012
Distribution: Ubuntu 10.04, CentOS 6.3, Windows 7
Posts: 262

Rep: Reputation: 54
It is on their respective websites in the installation instructions.
 
Old 08-19-2014, 08:03 PM   #5
MfromH
LQ Newbie
 
Registered: Jul 2014
Distribution: openSuse 12.2, SLES11.3, RHEL 5,
Posts: 15

Rep: Reputation: Disabled
Thumbs up mysql also available as tar file

Hey,

you may want to install several different mysql versions, so you should download the compressed tar archives instead of rpm packages from

http://downloads.mysql.com/archives/community/

Choose appropriate version and platform there and have a look at the bottom of that page, only the last two links below all the rpm packages are tar's for 32 and 64bit platforms. Bring the file to your server and unpack it there, you will need up to 2Gb space. Now it is already installed! You will get one single directory, and there you got everything you need for driving this special version of mysql: binaries, libraries, data, logs, scripts, server and client programs.

You can use several different of these directories, all running at the same time, even together with a package installed version, though that is not recommended. I would recommend, you create and mount a own volume for each tar installation.

Let me know if you need more assistance in starting a mysql server from a tar installation.

regards from H

M.
 
Old 08-19-2014, 09:08 PM   #6
astrogeek
Moderator
 
Registered: Oct 2008
Distribution: Slackware [64]-X.{0|1|2|37|-current} ::12<=X<=14, FreeBSD_10{.0|.1|.2}
Posts: 3,876
Blog Entries: 1

Rep: Reputation: 1998Reputation: 1998Reputation: 1998Reputation: 1998Reputation: 1998Reputation: 1998Reputation: 1998Reputation: 1998Reputation: 1998Reputation: 1998Reputation: 1998
Actually, contrary to other posters, I would strongly suggest that you try it with the versions that come with the distro, and only install a specific version if testing reveals any problems.

With both MySQL 5.1 and PHP 5.3, you should have zero issues running on top of MySQL 5.1 or greater or any version of PHP >=5.3.

I would NOT recommend trying to run multiple instances of MySQL at the same time - you WILL have problems including broken servers and corrupted data unless carefully planned and managed.

Additionally, although it is actually pretty easy to build MySQL from source (I do it frequently), it is also necessary at times to rebuild other packages that depend on it. This is even more true with PHP. If you build an older version of PHP then you will very likely encounter multiple other packages that depend on it and will need to be recompiled with the different version.

So I stringly recommend to stick with what comes in through your distro's package manager unless you actually encounter a specific issue with your CRM package. I bet it will run fine with newer MySQL and PHP.

Last edited by astrogeek; 08-19-2014 at 09:17 PM.
 
Old 08-20-2014, 02:51 AM   #7
MfromH
LQ Newbie
 
Registered: Jul 2014
Distribution: openSuse 12.2, SLES11.3, RHEL 5,
Posts: 15

Rep: Reputation: Disabled
different versions of mysql running at the same time on one host

Hi,

of course you should be aware of some standard configurations, that are different when running multiple mysql servers. I only wanted to show this possibility, that is provided by Mysql and well described in the manual. Especially for development purposes, and that is the background of this thread, you might need some more versions for evaluating your stuff. This way it is easy to do, even without root access (except for mounting volumes), and that is what I do frequently.

greetings from H

M.
 
Old 08-20-2014, 03:13 AM   #8
dwr
LQ Newbie
 
Registered: Aug 2014
Posts: 4

Original Poster
Rep: Reputation: Disabled
Smile

Thanks guys for your advice. I have installed default Apache2, MySQL and PHP with no issues. My main concern is with PHP and retired functions that may cause issues in software that specifically states use a specific version. I need to find a tutorial on how to install a tar.bz2 or tar.gz. Any tutorial links would be gratefully received.
 
Old 08-20-2014, 03:46 AM   #9
astrogeek
Moderator
 
Registered: Oct 2008
Distribution: Slackware [64]-X.{0|1|2|37|-current} ::12<=X<=14, FreeBSD_10{.0|.1|.2}
Posts: 3,876
Blog Entries: 1

Rep: Reputation: 1998Reputation: 1998Reputation: 1998Reputation: 1998Reputation: 1998Reputation: 1998Reputation: 1998Reputation: 1998Reputation: 1998Reputation: 1998Reputation: 1998
Quote:
Originally Posted by dwr View Post
Thanks guys for your advice. I have installed default Apache2, MySQL and PHP with no issues. My main concern is with PHP and retired functions that may cause issues in software that specifically states use a specific version. I need to find a tutorial on how to install a tar.bz2 or tar.gz. Any tutorial links would be gratefully received.
Glad that you were able to install the defaults - I think that is the only safe way forward for you, and I really don't think that you will encounter any incompatibilities as a result. If you see any PHP errors or messages please post them back here and someone will be able to help you tweak the php.ini (a normal thing, does not normally indicate versioning errors).

Usually you do not install tar.bz2 and tar.gz files. Depending on your distro and the origin of those files they may or may not be installable programs.

"tar" files are "tape archive" format archive files. bz2 and gz indicate a compression method used to reduce their size.

Literally anything can be inside such an archive file, but usually they contain program source code which must be compiled or further processed before it can be run or installed. The methods for doing that will be specific to the file. Simply opening a tar file as if it were an installable application can be harmful to your system! This is one reason that I originally suggested that you install from your distro's package repository, the straight forward and safe method!

The fact that you are not familiar with how to use them only reinforces that perspective.

Your system's package manager is designed to keep all dependencies and versions in sync, it is always best to let it do it's job. Installing non-packaged applications always requires a degree of awareness and care in order to not break your system, and to not end up with unresolved dependencies.

Last edited by astrogeek; 08-20-2014 at 03:48 AM. Reason: tpos, typs, typos...
 
Old 08-20-2014, 04:21 AM   #10
dwr
LQ Newbie
 
Registered: Aug 2014
Posts: 4

Original Poster
Rep: Reputation: Disabled
Cool. Good explanation. Thank you guys. One to look at when more experience gained. I'm comfortable with MS/IIS (is that a sudden intake of breath I hear? lol). I'm just looking to get more into Linux, but keen to get a development web server up and running, which I have. As a software developer I'm not keen to be a master of Linux, just know enough to get by for now.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Am trying to install packages like net-snmp, php-mysql, php-snmp, php but with errors Maj Linux - Newbie 1 07-26-2013 03:12 PM
[SOLVED] yum install php-mysql create problem to my running mysql database jsaravana87 Linux - Server 1 08-11-2011 04:24 AM
php/shell script to install mysql,apache and php automatically stranger_6_7 Linux - General 2 08-11-2009 03:07 AM
yum install php-mysql fails with mysql 5.1 - "Error: mysql conflicts with MySQL" rebelde Linux - Software 2 03-13-2009 11:32 AM
is there a client install for MySql so PHP can connect to MySQL Server? alar Linux - Software 8 07-03-2007 08:42 PM


All times are GMT -5. The time now is 02:30 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration