Page 1 of 2
[SOLVED] - FC2 MySQL update dependency issue
Posted: Mon Mar 20, 2006 12:31 pm
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
================================================================================
Posted: Mon Mar 20, 2006 1:36 pm
by redmonkey
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.
Posted: Mon Mar 20, 2006 1:57 pm
by Benjamin
Install yum
yum update mysql apache php
Posted: Mon Mar 20, 2006 2:03 pm
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?
Posted: Mon Mar 20, 2006 2:12 pm
by Benjamin
Might want to update the repository list in yum.conf
Posted: Mon Mar 20, 2006 3:06 pm
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.
Posted: Mon Mar 20, 2006 3:17 pm
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

).
Posted: Mon Mar 20, 2006 3:26 pm
by Benjamin
You can do it either way. This explains it better than I can...
http://www.fedorafaq.org/#installsoftware
Posted: Mon Mar 20, 2006 3:59 pm
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.
Posted: Tue Mar 21, 2006 5:49 am
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?
Posted: Tue Mar 21, 2006 8:18 am
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.
[SOLVED] - FC2 MySQL update dependency issue
Posted: Tue Mar 21, 2006 9:51 pm
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!):
- 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)
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.
Posted: Tue Mar 21, 2006 10:45 pm
by Benjamin
Awesome, I bet next time it will be easier... if there ever is a next time lol.
Re: [SOLVED] - FC2 MySQL update dependency issue
Posted: Sun May 14, 2006 3:51 am
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
Re: [SOLVED] - FC2 MySQL update dependency issue
Posted: Sun May 14, 2006 10:47 am
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.