Atomicorp

Hi i have a unix FC2 server , it has an outdated version of mysql, i need it to update the mysql version to the latest my sql 4 version. Ive looked thorught hte forums and read about rpms and such , but i still dont understnad how to do this. If any of you guys here have an artilcle , tutorial written on how to use this from step one, or can write one up for me i will greatlyu appreciate it and even donate 15 dollars to you guys(if it matter at all). I need the upgrade badly at this point. Thanks

Configure yum
#joe /etc/yum.conf to look like this (Don't replace the $releasever, it will work as is)
------------------------------
[main]
cachedir=/var/cache/yum
debuglevel=2
logfile=/var/log/yum.log
pkgpolicy=newest
distroverpkg=redhat-release
tolerant=1
exactarch=1
retries=20
obsoletes=1
gpgcheck=1

# PUT YOUR REPOS HERE OR IN separate files named file.repo
# in /etc/yum.repos.d

# THIS CHANNEL CONTAINS MY PSA COMPATIBLE RPMS (php, mysql, qmail-scanner, etc)
[atomic]
name=Atomic Rocket Turtle - $releasever - Atomic PSA-Compatible RPMS
baseurl=http://3es.atomicrocketturtle.com/atomi ... eleasever/

[psa-7.5]
name=Atomic Rocket Turtle - $releasever - SW-Soft PSA 7.5 RPMS
baseurl=http://3es.atomicrocketturtle.com/atomi ... eleasever/

[base]
name=Atomic Rocket Turtle - $releasever - Base OS RPMS mirror
baseurl=http://3es.atomicrocketturtle.com/3rd-p ... eleasever/

[updates]
name=Atomic Rocket Turtle - $releasever - OS Update RPMS mirror
baseurl=http://3es.atomicrocketturtle.com/3rd-p ... eleasever/
------------------------------

Not sure if this applies to FC2, but
#cd /etc/yum.repos.d
edit each file and set enabled=0. ones enabled by default are fedora.repo and fedora-updates.repo

run "yum list" to test yum connections and repositories

#wget http://www.atomicrocketturtle.com/RPM-GPG-KEY.art.txt
#rpm --import RPM-GPG-KEY.art.txt
#rm RPM-GPG-KEY.art.txt
#rpm --import /usr/share/rhn/RPM-GPG-KEY-fedora

#yum update mysql mysql-server

You may have problems with passwords and such, make sure old_passwords=1 in my.cnf, and use
set password for 'youruser'@'yourhost' = OLD_PASSWORD('yourpassword');
if you get errors about a client being out of date when trying to connect.

Whats the #joe command supposed to be , i found i have yum on my server but whats the full command i enter in ssh to configure yum?

how do i even edit the conf file if i dont have joe isntalled on my FC2?

vi or pico will also work

you could also manually install joe by doing

#wget http://3es.atomicrocketturtle.com/3rd-p ... 9.i386.rpm

#rpm -iVh joe-2.9.8-9.i386.rpm

Then joe should work.

Stucco

You could always just use vi like the rest of us

Ok, I have pretty much the same question as the first op of this thread except i'm running FC3 with Plesk 7.5
So i'm just trying to update my mysql version from 3.x to 4.1x and that's it for now until i feel its safe to do more..

After editing my yum.cnf file to Stucco's suggestions, i ran "yum list" and i get a 404 on that repomd.xml file. Can someone tell me how I can fix this?

Also, it would be nice to have some stickys on these forums for common questions like this.

The structure changed slightly since that post. Remove the RPMS/ from the end of the updates channel.

I'll edit the post too.

Stucco wrote:The structure changed slightly since that post. Remove the RPMS/ from the end of the updates channel.

I'll edit the post too.

Hi stucko, yeah i figured the sturcture had changed. Well I took off the rpms/ and I still get the same error.
why is it looking in www.atomicrocketturtle.com instead of 3es.atomicrocketturtle.com.

whoops...and the structure changed again.

There are no more downloads at www, only at 3es. Remove the www links. Again I will edit the post above.

Stucco wrote:whoops...and the structure changed again.

There are no more downloads at www, only at 3es. Remove the www links. Again I will edit the post above.

ok stucko....works now...
I'm going to close my eyes and type "yum update mysql mysql-server "

I hope everything goes well.

Damn, guess i got screwed...

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)



Any ideas on what could've gone wrong Stucco?

Update seemed to have gone ok.
http://pastebin.com/544295

restart it with /etc/rc.d/init.d/mysqld restart

it will probably fail to shut down the first time, and then start correctly. You should be able to connect after that.

You can find more mysql stuff here...
http://www.gadberry.com/aaron/2006/01/0 ... -commands/

Stucco

Stucco wrote:restart it with /etc/rc.d/init.d/mysqld restart

it will probably fail to shut down the first time, and then start correctly. You should be able to connect after that.

You can find more mysql stuff here...
http://www.gadberry.com/aaron/2006/01/0 ... -commands/

Stucco

Thanks stucco, was just about to post that i just had to restart it... lol how embarrassing.

1 more thing stucko, i went into my.cnf and I don't see a place to set mysql to use the old style passwords. Where can i find that?

nevermind, i'm an idiot. I have to add that onto the my.cnf file right?

You can just add the line old-passwords=1 into your my.cnf.

For the record, a lot of people use old-passwords, a lot of people use old_passwords. I don't know which way is right.

If you figure it out post it back here.