Hi All,
Could anyone tell me, how to correctly install MySQL4.1 on Centos 5 ? By default Centos 5 comes with mysql5… If I will compile mysql4 from sources to separate prefix, some features may be unavailable (unix sockets for example).
I’m moving some critical application (online booking) based on java, tomcat5, mysql4.1 from old server fedora 4 to new server running Centos 5. So, I don’t want update mysql to new version this time.
Thanks, SK
Sergej Kandyla wrote: ..
I’m moving some critical application (online booking) based on java, tomcat5, mysql4.1 from old server fedora 4 to new server running Centos 5. So, I don’t want update mysql to new version this time.
Why not go for Centos 4?
Mogens
Mogens Kjaer wrote:
Sergej Kandyla wrote: ..
I’m moving some critical application (online booking) based on java, tomcat5, mysql4.1 from old server fedora 4 to new server running Centos 5. So, I don’t want update mysql to new version this time.
Why not go for Centos 4?
I don’t want use outdated software and operation system, also I try not use testing distribs\soft in production. Centos (5), Debian stable (Etch), FreeBSD stable (6.3, 7.0) – it’s my choose.
Currently mysql4 is temporary solution. I must complete the migration of server at first. Second, developers of the application not sure, that all will work correctly under mysql5.
Sergej Kandyla wrote: ...
I don’t want use outdated software and operation system, also I try not use testing distribs\soft in production.
Why do you call Centos 4 outdated?
You'll get security updates until Feb 29, 2012.
Mogens
Mogens Kjaer wrote:
Sergej Kandyla wrote: ...
I don’t want use outdated software and operation system, also I try not use testing distribs\soft in production.
Why do you call Centos 4 outdated?
You'll get security updates until Feb 29, 2012.
I just want to use the latest stable OS and software. Also, I already have installed server with centos 5.
I don't choose operation system, please say me, how to right install mysql4.1 under centos 5 without compiling mysql from sources. I don't want make my server dirty, so i'm asking the right way to do this.
Thanks.
On Thu, 13 Mar 2008, Sergej Kandyla wrote:
Mogens Kjaer wrote:
Sergej Kandyla wrote: ...
I don?t want use outdated software and operation system, also I try not use testing distribs\soft in production.
Why do you call Centos 4 outdated?
You'll get security updates until Feb 29, 2012.
I just want to use the latest stable OS and software. Also, I already have installed server with centos 5.
I don't choose operation system, please say me, how to right install mysql4.1 under centos 5 without compiling mysql from sources. I don't want make my server dirty, so i'm asking the right way to do this.
There is no *sane* way to install MySQL 4 on CentOS 5 ... That's the reason why you've been pointed to using CentOS 4 that comes with MySQL 4 ... Reinstalling a server to use the right tool is not a big deal .. and i'd add that it's usually better to look that the software requirements prior to install an OS version ....
On Thu, 2008-03-13 at 15:16 +0200, Sergej Kandyla wrote:
I just want to use the latest stable OS and software. Also, I already have installed server with centos 5.
I don't choose operation system, please say me, how to right install mysql4.1 under centos 5 without compiling mysql from sources.
go to the mysql site and grab the binary distribution http://dev.mysql.com/downloads/mysql/4.1.html#linux
I don't want make my server dirty, so i'm asking the right way to do this.
the right way would be rolling your own rpm, in your own repository. name the rpms something liky mysql41 and make sure that the rpm provides "mysql" and all the other things that the original mysql package from centos provides.
Thanks.
have phun
On Thu, Mar 13, 2008 at 9:46 AM, Sebastian Schubert ssc-lists@space.net wrote:
On Thu, 2008-03-13 at 15:16 +0200, Sergej Kandyla wrote:
I just want to use the latest stable OS and software. Also, I already have installed server with centos 5.
I don't choose operation system, please say me, how to right install mysql4.1 under centos 5 without compiling mysql from sources.
go to the mysql site and grab the binary distribution http://dev.mysql.com/downloads/mysql/4.1.html#linux
I don't want make my server dirty, so i'm asking the right way to do this.
the right way would be rolling your own rpm, in your own repository. name the rpms something liky mysql41 and make sure that the rpm provides "mysql" and all the other things that the original mysql package from centos provides.
You could start with the Centos4 SRC.RPM for Mysql 4.1. It compiles without issue in Centos5. The only concerns that come to mind are the connectors to PHP, Python, Perl etc. I'm not sure, but some of these may work without issue, but some may need to recompile as well.
-Mauriat
On Thursday 13 March 2008 20:16:01 Sergej Kandyla wrote:
I just want to use the latest stable OS and software. Also, I already have installed server with centos 5.
I don't choose operation system, please say me, how to right install mysql4.1 under centos 5 without compiling mysql from sources. I don't want make my server dirty, so i'm asking the right way to do this.
Installing an old mysql into the latest centos is not the best way either. Why not installing the whole database into the new mysql? Unless it's using functions that are not available/compatible with mysql5, it will work OK.
Fajar Priyanto a écrit :
Installing an old mysql into the latest centos is not the best way either. Why not installing the whole database into the new mysql? Unless it's using functions that are not available/compatible with mysql5, it will work OK.
Wrong. I'm running a public library management software that requires MySQL 4 and will not run on MySQL 5. The MySQL documentation also states that some functions in MySQL 5 are *not* backwards-compatible.
cheers,
Niki
Compile it man! Set the flags so everything goes under /usr/local/mysql. What's the big deal? What was that about 'making my server dirty'? That's crazy talk. We've got similar apps that hook together tomcat, rmi and mysql 4.1 - we can't change versions for a variety of reasons - but when I added new servers - I justed rsync'd over the same version from another another machine. It's compiled for the same arch - and it's all self-contained.
-Peter -Cardiff, UK
On 14/03/2008, Niki Kovacs contact@kikinovak.net wrote:
Fajar Priyanto a écrit :
Installing an old mysql into the latest centos is not the best way either. Why not installing the whole database into the new mysql? Unless it's using functions that are not available/compatible with mysql5, it will work OK.
Wrong. I'm running a public library management software that requires MySQL 4 and will not run on MySQL 5. The MySQL documentation also states that some functions in MySQL 5 are *not* backwards-compatible.
cheers,
Niki
CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
On Friday 14 March 2008 12:12:45 Niki Kovacs wrote:
Fajar Priyanto a écrit :
Installing an old mysql into the latest centos is not the best way either. Why not installing the whole database into the new mysql? Unless it's using functions that are not available/compatible with mysql5, it will work OK.
Wrong. I'm running a public library management software that requires MySQL 4 and will not run on MySQL 5. The MySQL documentation also states that some functions in MySQL 5 are *not* backwards-compatible.
From what I've seen all these years, most of the time php and mysql bundled applications such as phpnuke, mambo, joomla, etc they all state: use mysql 'at least' version blabla. So the newer the mysql 'usually' the better.
It's the whole different thing regarding backward compatibility. Of course it's a pointless bad habit installing a web program that clearly states 'require at least mysql 5.x.x' into mysql 4.x.x :)
May I know the name of the library management program? KOHA?
Sergej Kandyla wrote:
Mogens Kjaer wrote:
Why not go for Centos 4?
I don’t want use outdated software and operation system, also I try not use testing distribs\soft in production.
Ermm. CentOS 4 is supported until February 29th 2012. And it's not really a "testing" distribution either.
Currently mysql4 is temporary solution. I must complete the migration of server at first. Second, developers of the application not sure, that all will work correctly under mysql5.
Well, then use 4.x until they are sure that it works on mysql 5 and then put a 5.x production server into use?
I don't know of a sane way to get MySQL 4 into CentOS 5.
Cheers,
Ralph
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Sergej Kandyla wrote:
Hi All,
Could anyone tell me, how to correctly install MySQL4.1 on Centos 5 ? By default Centos 5 comes with mysql5… If I will compile mysql4 from sources to separate prefix, some features may be unavailable (unix sockets for example).
I’m moving some critical application (online booking) based on java, tomcat5, mysql4.1 from old server fedora 4 to new server running Centos 5. So, I don’t want update mysql to new version this time.
In the time it takes you to figure out how to cleanly install MySQL 4.1 on CentOS 5 you could just use the included MySQL 5 and do some extensive tests to ensure that nothing breaks. You're going to have to do the testing for the 4.1 on CentOS so you may as well do the upgrade and be done with it, assuming that you ignore the advice to load CentOS 4 -- which already has the testing for MySQL 4.1 done.
Barry
Sergej Kandyla wrote:
Hi All,
Could anyone tell me, how to correctly install MySQL4.1 on Centos 5 ?
Thanks, all!
The problem is solved.
Also I've tried to run our application on default centos mysql5, but have some errors with sql queries. In our application used very big, long and difficult sql queries, and they don't work after updating to mysql5. I've tried to compile mysql4.1.22 and 4.1.20 by hand too, but also have errors. I've compiled with only options --prefix=/usr/local/mysql4 --exec-prefix=/usr/local/mysql4 All compiled ok, and works seems ok, but our application still not work correctly. I don't have ideas about this matter. May be some specific options required...I don't know.
In the end, I've downloaded precompiled mysql 4.1.22 (http://dev.mysql.com/downloads/mysql/4.1.html#linux-x86-32bit-rpms) unpacked it to /usr/local/mysql4, made some changes in mysql4 startup script, started... and all seems working fine now :) .
PS. sorry for my EN.
-
Barry L. Kline -
Fabian Arrotin -
Fajar Priyanto -
Mauriat M -
Mogens Kjaer -
Niki Kovacs -
Peter Farrell -
Ralph Angenendt -
Sebastian Schubert -
Sergej Kandyla