FC2 , PSA 7.5.4 need upgrade help to mysql 4.1.x and latest

pspcrazy · Unread post by **pspcrazy** » Thu Nov 03, 2005 8:37 pm

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

Stucco · Unread post by **Stucco** » Fri Nov 04, 2005 1:35 am

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.

pspcrazy · Unread post by **pspcrazy** » Fri Nov 04, 2005 2:55 am

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?

pspcrazy · Unread post by **pspcrazy** » Fri Nov 04, 2005 3:11 am

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

Stucco · Unread post by **Stucco** » Fri Nov 04, 2005 2:03 pm

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

Unread post by **scott** » Fri Nov 04, 2005 7:11 pm

You could always just use vi like the rest of us

sexshun · Unread post by **sexshun** » Tue Feb 07, 2006 7:46 pm

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.

Code: Select all

http://3es.atomicrocketturtle.com/3rd-party/updates/3/RPMS/repodata/repomd.xml: [Errno 4] IOError: HTTP Error 404: Not Found
Trying other mirror.
Cannot open/read repomd.xml file for repository: updates
failure: repodata/repomd.xml from updates: [Errno 256] No more mirrors to try.

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.

Stucco · Unread post by **Stucco** » Tue Feb 07, 2006 9:12 pm

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

I'll edit the post too.

sexshun · Unread post by **sexshun** » Tue Feb 07, 2006 9:16 pm

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.

Code: Select all

# yum list
Repository base already added, not adding again
Setting up Repos
http://www.atomicrocketturtle.com/atomic/psa-7.5/3/repodata/repomd.xml: [Errno 4] IOError: HTTP Error 404: Not Found
Trying other mirror.
Cannot open/read repomd.xml file for repository: psa-7.5
failure: repodata/repomd.xml from psa-7.5: [Errno 256] No more mirrors to try.

why is it looking in www.atomicrocketturtle.com instead of 3es.atomicrocketturtle.com.

Stucco · Unread post by **Stucco** » Tue Feb 07, 2006 9:21 pm

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.

sexshun · Unread post by **sexshun** » Tue Feb 07, 2006 9:28 pm

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.

sexshun · Unread post by **sexshun** » Tue Feb 07, 2006 9:33 pm

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

Stucco · Unread post by **Stucco** » Tue Feb 07, 2006 9:55 pm

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

sexshun · Unread post by **sexshun** » Tue Feb 07, 2006 9:57 pm

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?

Stucco · Unread post by **Stucco** » Tue Feb 07, 2006 10:15 pm

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.