[SOLVED] - FC2 MySQL update dependency issue
Moderator: General Moderators
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
[SOLVED] - FC2 MySQL update dependency issue
OK, my saga in the world of dedicated server software updates continues...
Having done a crapload of research on updating MySQL and PHP on a Fedora Core 2 dedicated server, I have decided that I want to do the following:
1. Uninstall MySQL 3.23
2. Install MySQL 4.1 (or 5.0 if it works - Still don't know that yet)
3. Update PHP from 4.3 to 5.X
Here's my problem...
Task 1 and 3 won't work at all because of these weird cyclical dependencies. When I try to uninstall MySQL 3.23 (rpm -e mysql) I get like five different dependency warnings (all of the members of the mysql package) about all the member packages depending on libmysql. So figured I'd uninstall the dependent apps first. But these are dependent on mysql. What the hell?!?!?!? If they are both dependent on eachother how in the world am I supposed to uninstall them to update them? I can't update mysql (rpm -Uvh mysql*.rpm) because of the same dependency issues.
PHP runs into the exact same thing. Can anyone offer some advice on how to handle this? If not, can someone PM me a quote for how much they would charge to do it for me? I am so wet behind the ears when it comes to Linux and I have a client whose network of 13 sites needs to be up like yesterday.
As always any help is much appreciated.
PS I have downloaded all of the RPMs for these packages to the server.
================================================================================
What I currently have
Fedora Core 2 (host says I cannot update the kernel)
MySQL 3.23.58
PHP 4.3
Apache web server 2.0.5
What I want
MySQL 5.0.18 (would settle for 4.1.14 but only as a last resort)
PHP 5.1.2
================================================================================
Having done a crapload of research on updating MySQL and PHP on a Fedora Core 2 dedicated server, I have decided that I want to do the following:
1. Uninstall MySQL 3.23
2. Install MySQL 4.1 (or 5.0 if it works - Still don't know that yet)
3. Update PHP from 4.3 to 5.X
Here's my problem...
Task 1 and 3 won't work at all because of these weird cyclical dependencies. When I try to uninstall MySQL 3.23 (rpm -e mysql) I get like five different dependency warnings (all of the members of the mysql package) about all the member packages depending on libmysql. So figured I'd uninstall the dependent apps first. But these are dependent on mysql. What the hell?!?!?!? If they are both dependent on eachother how in the world am I supposed to uninstall them to update them? I can't update mysql (rpm -Uvh mysql*.rpm) because of the same dependency issues.
PHP runs into the exact same thing. Can anyone offer some advice on how to handle this? If not, can someone PM me a quote for how much they would charge to do it for me? I am so wet behind the ears when it comes to Linux and I have a client whose network of 13 sites needs to be up like yesterday.
As always any help is much appreciated.
PS I have downloaded all of the RPMs for these packages to the server.
================================================================================
What I currently have
Fedora Core 2 (host says I cannot update the kernel)
MySQL 3.23.58
PHP 4.3
Apache web server 2.0.5
What I want
MySQL 5.0.18 (would settle for 4.1.14 but only as a last resort)
PHP 5.1.2
================================================================================
Last edited by RobertGonzalez on Tue Mar 21, 2006 9:27 pm, edited 1 time in total.
Might be worth looking at...
.. for a list of options that may help. Off the top of my head perhaps adding '--nodeps --force' may overcome the dependancy problems.
This is one of the reasons I tend to stay away from pre built packages for production servers in favour of rolling my own. It can be easy while upgrading one package to upgrade a dependancy which another package relies on and introduce an incompatability.
Most package managers will detect that and tell you that you need to upgrade the other package too but then, that's not always the desired result.
Code: Select all
rpm --helpThis is one of the reasons I tend to stay away from pre built packages for production servers in favour of rolling my own. It can be easy while upgrading one package to upgrade a dependancy which another package relies on and introduce an incompatability.
Most package managers will detect that and tell you that you need to upgrade the other package too but then, that's not always the desired result.
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
Thanks for the great conversation. redmonkey, you are right, updating using yum is not working. I think this has to do with the respository database or header information.
I have tried to use every flag for yum, except --nodeps, to install these apps. The reason I haven't used --nodeps is because everything I have read says not to violate the dependencies or you'll break the system.
I am all for running these apps from source... if I knew what the crap I was doing. This is my first venture into something non-Windows and it is becoming more and more painful by the day. I just want to be able to use the set up for production that I use for development. The only problem is that I have all the same apps (Apache, PHP5, MySQL5) loaded on my windows machine.
I will look into some of your guys' suggestions when I get home this afternoon. I prefer not to break the server if I can avoid it, although I am ready to try anything if I can get it to work.
I have tried to use every flag for yum, except --nodeps, to install these apps. The reason I haven't used --nodeps is because everything I have read says not to violate the dependencies or you'll break the system.
I am all for running these apps from source... if I knew what the crap I was doing. This is my first venture into something non-Windows and it is becoming more and more painful by the day. I just want to be able to use the set up for production that I use for development. The only problem is that I have all the same apps (Apache, PHP5, MySQL5) loaded on my windows machine.
I will look into some of your guys' suggestions when I get home this afternoon. I prefer not to break the server if I can avoid it, although I am ready to try anything if I can get it to work.
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
Is this something that is done by hand or is there a command I am supposed to enter? Sorry for sounding like a needy spouse, but I feel like I'm talking a different language when it comes to Linux (kinda like when I first started coding in PHPagtlewis wrote:Might want to update the repository list in yum.conf
You can do it either way. This explains it better than I can...
http://www.fedorafaq.org/#installsoftware
http://www.fedorafaq.org/#installsoftware
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
That is soooo odd. I was just on that same exact portion of that page. I was looking at the guy's yum.conf, which he said is changed. I think his yum.conf in now in an RPM that you have to install?!?!? Anyway, I may try that tonight. Who knows. I might just give up the hope of ever being up to date and just keep developing in the dark ages.
On a side note, thanks to all that have PM'ed me regarding this issue of mine. I do appreciate it.
On a side note, thanks to all that have PM'ed me regarding this issue of mine. I do appreciate it.
- Maugrim_The_Reaper
- DevNet Master
- Posts: 2704
- Joined: Tue Nov 02, 2004 5:43 am
- Location: Ireland
Welcome to the horrible world of interdependent applications. If possible get yum working - otherwise you'll be listing dependencies and removing deps and tracking a lot more updates than just PHP/Apache/MySQL.
Might be worth trying this all out on a home PC with Linux installed - have a few trial runs to familiarise yourself with a non-critical system you can let crash and burn with little worry.
Did your server come with any control panel app that could be updated in step?
Might be worth trying this all out on a home PC with Linux installed - have a few trial runs to familiarise yourself with a non-critical system you can let crash and burn with little worry.
Did your server come with any control panel app that could be updated in step?
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
Funny thing abut this situation is that the server is running FC2. It is almost as much work looking for a FC2 install CD! I have FC4 on my machine at home so I haven't really needed to toy with it much because the set up is almost what I want already.
There is a control panel, and it is listed as a dependency to mysql. The host that is providing the DS said that I can update as high as MySQL 5 without breaking the control panel. Same for PHP.
I was just about to try uninstalling mysql using --nodeps and see what we'll see. If I kill it, then I say we all go get a beer to celebrate the hunt and kill of an outdated Linux OS. And then I'll switch DS providers.
There is a control panel, and it is listed as a dependency to mysql. The host that is providing the DS said that I can update as high as MySQL 5 without breaking the control panel. Same for PHP.
I was just about to try uninstalling mysql using --nodeps and see what we'll see. If I kill it, then I say we all go get a beer to celebrate the hunt and kill of an outdated Linux OS. And then I'll switch DS providers.
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
[SOLVED] - FC2 MySQL update dependency issue
HOODALOLLIE! OKIEDAY!
Sorry for the excitement, but I just got done running laps around my house with my hands in the 'Rocky' victory position asking my neighborhood.... "WHO'S THE MAN?"
OK, now for a recap (and I think I am going to put this into my blog for others as well)...
I have successfully updated my Fedora Core 2 MySQL install from 3.23.58 to MySQL 4.1.18. This is on a dedicated server offered by GoDaddy/Wild West Domains. This is what I did (note, this is for MySQL ONLY!):
Man I hope this helps someone else who's trying to update their MySQL server. This was a royal pain the donkey if you get my drift.
Sorry for the excitement, but I just got done running laps around my house with my hands in the 'Rocky' victory position asking my neighborhood.... "WHO'S THE MAN?"
OK, now for a recap (and I think I am going to put this into my blog for others as well)...
I have successfully updated my Fedora Core 2 MySQL install from 3.23.58 to MySQL 4.1.18. This is on a dedicated server offered by GoDaddy/Wild West Domains. This is what I did (note, this is for MySQL ONLY!):
- wget all the mysql rpms from mysql (I used the generic statically linked i386 rpms)
- wget all the support rpms from the fedora core repository
- perl-DBD-MySQL-3.0002-2.2.2.i386.rpm
- php-mysql-5.1.2-5.i386.rpm
- mod_auth_mysql-3.0.0-3.i386.rpm
- Uninstall current 3.23 installation
- rpm -e --nodeps perl-DBD-MySQL
- rpm -e mysql
- rpm -e mysql-server
- rpm -e mod_auth_mysql
- rpm -e php_mysql
- install the support rpms (rpm -Uvh perl-DBD-MySQL-3.0002-2.2.2.i386.rpm (and so on))
- install the mysql client
- install the mysql server
- BEFORE trying to start the server, copy the my-medium.cnf file from /var/lib/mysql/ to /etc/my.cnf (cp -v /var/lib/mysql/my-medium.cnf /etc/my.cnf)
- edit the my.cnf according to your preference (I added skip-networking and skip-innodb)
- save my.cnf
- try to connect (mysql -u root -p)
Man I hope this helps someone else who's trying to update their MySQL server. This was a royal pain the donkey if you get my drift.
Re: [SOLVED] - FC2 MySQL update dependency issue
HiEverah wrote:
I have successfully updated my Fedora Core 2 MySQL install from 3.23.58 to MySQL 4.1.18. This is on a dedicated server offered by GoDaddy/Wild West Domains. This is what I did (note, this is for MySQL ONLY!):
.....................
................
I need Help too. I am in Godaddy, with Fedora Core 2
And I want to upgrade to Mysql 4
I am new in dedicated servers, and I need HELP to know if the following steps are ok?
My first question is:
1.-If I Uninstall mysql3, can I undone this? in case I can´t upgrade...
So, if I uninstall, with Yum could be possible to install again mysql 3?
2.-Second, if I upgrade to mysql 4, my existing databases does keep ok?
3.-And, when I wget a file, in wich directory I must download it?
in ROOT? in home?
Taking your steps, I wonder if for mysql 4, would be the following:
[*]wget all the mysql rpms from mysql (I used the generic statically linked i386 rpms)
From: http://dev.mysql.com/downloads/mysql/4.1.html
And choose by example:
wget http://dev.mysql.com/get/Downloads/MySQ ... ediris.es/
[*]wget all the support rpms from the fedora core repository
[*]perl-DBD-MySQL-3.0002-2.2.2.i386.rpm
[*]php-mysql-5.1.2-5.i386.rpm
(In this case, I think would be mysqlclient14-4.1.14-4.2.i386.rpm)
????????????????????
[*]mod_auth_mysql-3.0.0-3.i386.rpm
wget http://download.fedora.redhat.com/pub/f ... 2.i386.rpm
wget http://download.fedora.redhat.com/pub/f ... 2.i386.rpm
wget http://download.fedora.redhat.com/pub/f ... 3.i386.rpm
[*]Uninstall current 3.23 installation
- rpm -e --nodeps perl-DBD-MySQL
- rpm -e mysql
- rpm -e mysql-server
- rpm -e mod_auth_mysql
- rpm -e php_mysql
- install the support rpms (rpm -Uvh perl-DBD-MySQL-3.0002-2.2.2.i386.rpm (and so on))
- install the mysql client
rpm -Uvh mysqlclient14-4.1.14-4.2.i386.rpm
- install the mysql server
rpm -Uvh MySQL-server-4.1.19-0.i386.rpm - BEFORE trying to start the server, copy the my-medium.cnf file from /var/lib/mysql/ to /etc/my.cnf (cp -v /var/lib/mysql/my-medium.cnf /etc/my.cnf)
- edit the my.cnf according to your preference (I added skip-networking and skip-innodb)
- save my.cnf
- try to connect (mysql -u root -p)
Is this OK?
Thanks
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
Re: [SOLVED] - FC2 MySQL update dependency issue
The way I did things, I don't think you can reinstall with yum. The reason being is you are taking the application completely off your system and destroying the dependencies at the same time. In fact, after I did all this, I no longer found any reference to MySQL in my server's yum header (I think that is what it is called).tenoch wrote:1.-If I Uninstall mysql3, can I undone this? in case I can´t upgrade...
So, if I uninstall, with Yum could be possible to install again mysql 3?
Mine stayed fine. All my users, all my tables, everything was untouched. Of course, I did this on freshly apportioned server, so the risk for me was nil. But none of my data was affected by the upgrade.tenoch wrote:2.-Second, if I upgrade to mysql 4, my existing databases does keep ok?
I created a folder under my general user folder for all the things I was downloading. I rpm'ed them from there.tenoch wrote:3.-And, when I wget a file, in wich directory I must download it? in ROOT? in home?
All of the files I downloaded were to go from MySQL 3.23 to MySQL 4.1. I haven't moved to MySQL 5 yet, though I've heard that the updte is a little easier from 4.1 to 5.tenoch wrote:Taking your steps, I wonder if for mysql 4, would be the following: ...