[SOLVED] - FC2 MySQL update dependency issue

Whether you are using Linux on the desktop or as a server, it's still good that you're using Linux. Linux related questions go here.

Moderator: General Moderators

User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

[SOLVED] - FC2 MySQL update dependency issue

Post by RobertGonzalez »

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
================================================================================
Last edited by RobertGonzalez on Tue Mar 21, 2006 9:27 pm, edited 1 time in total.
redmonkey
Forum Regular
Posts: 836
Joined: Thu Dec 18, 2003 3:58 pm

Post by redmonkey »

Might be worth looking at...

Code: Select all

rpm --help
.. 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.
User avatar
Benjamin
Site Administrator
Posts: 6935
Joined: Sun May 19, 2002 10:24 pm

Post by Benjamin »

Install yum

yum update mysql apache php
redmonkey
Forum Regular
Posts: 836
Joined: Thu Dec 18, 2003 3:58 pm

Post by redmonkey »

From a previous thread on the subject....
Everah wrote:I tried using yum to update mysql and php, but I get a message that both packages are already up to date (MySQL 3.23.58 and PHP 4.3.11).
So I'm guessing that's not an option?
User avatar
Benjamin
Site Administrator
Posts: 6935
Joined: Sun May 19, 2002 10:24 pm

Post by Benjamin »

Might want to update the repository list in yum.conf
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

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.
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

agtlewis wrote:Might want to update the repository list in yum.conf
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 PHP :oops: ).
User avatar
Benjamin
Site Administrator
Posts: 6935
Joined: Sun May 19, 2002 10:24 pm

Post by Benjamin »

You can do it either way. This explains it better than I can...

http://www.fedorafaq.org/#installsoftware
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

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.
User avatar
Maugrim_The_Reaper
DevNet Master
Posts: 2704
Joined: Tue Nov 02, 2004 5:43 am
Location: Ireland

Post by Maugrim_The_Reaper »

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?
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

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.
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

[SOLVED] - FC2 MySQL update dependency issue

Post by RobertGonzalez »

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!):
  1. wget all the mysql rpms from mysql (I used the generic statically linked i386 rpms)
  2. 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
  3. 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
  4. install the support rpms (rpm -Uvh perl-DBD-MySQL-3.0002-2.2.2.i386.rpm (and so on))
  5. install the mysql client
  6. install the mysql server
  7. 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)
  8. edit the my.cnf according to your preference (I added skip-networking and skip-innodb)
  9. save my.cnf
  10. try to connect (mysql -u root -p)
At first I was getting this stupid "ERROR 2002 (HY000) - can't conect to local MySQL server socket ('/var/lib/mysql/mysql.sock')". After racking my brain for hours and hours, I realized (by accident) that I couldn't start the server because I had no configuration file. MySQL installs several to choose from in /var/lib/mysql (they are names my-small.cnf, my-medium.cnf, my-large.cnf, my-huge.cnf and my-innodb.cnf). But you have to copy one of the them to /etc/my.cnf so the MySQL server knows what to do when it is asked to start up.

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.
User avatar
Benjamin
Site Administrator
Posts: 6935
Joined: Sun May 19, 2002 10:24 pm

Post by Benjamin »

Awesome, I bet next time it will be easier... if there ever is a next time lol.
tenoch
Forum Newbie
Posts: 2
Joined: Sun May 14, 2006 3:31 am

Re: [SOLVED] - FC2 MySQL update dependency issue

Post by tenoch »

Everah 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!):
.....................
................
Hi

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
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Re: [SOLVED] - FC2 MySQL update dependency issue

Post by RobertGonzalez »

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?
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:2.-Second, if I upgrade to mysql 4, my existing databases does keep ok?
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:3.-And, when I wget a file, in wich directory I must download it? in ROOT? in home?
I created a folder under my general user folder for all the things I was downloading. I rpm'ed them from there.
tenoch wrote:Taking your steps, I wonder if for mysql 4, would be the following: ...
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.
Post Reply