Page 1 of 1

Fedora Core 2 - Update MySQL

Posted: Wed Jun 21, 2006 8:22 pm
by jefwic
Hello,

I am running Fedora Code 2 with MySQL 3.23.58 and Plesk 7.5.4. Which files would I have to use to update MySQL to 4.1.x without breaking Plesk?

Thanks.

Regards,
Jeff Wickenheiser

Posted: Thu Jun 22, 2006 7:31 am
by scott
just run yum update, it will tell you

Posted: Fri Jun 23, 2006 11:03 am
by Unga
HI, whell I did upgrade my MySQL 3.2.x to 4.1.x using yum and your resources. just tiping:
# yum install mysql
Well now all is working fine but when istalling the new scripts like mambo, modern bill, ect.. I'm gotting the errors lieke: "Database error 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client"

Whell I dont wont to make an mistake by installing something unsupported.

Please Scot could you advice what exactelly do I have to install ?

Currently I'm using PLESK 8.0.0 under the Fedora core 2
# mysql -V
mysql Ver 14.7 Distrib 4.1.19, for redhat-linux-gnu (i686) using readline 4.3

my Yum.conf is like that:

[main]
cachedir=/var/cache/yum
debuglevel=2
logfile=/var/log/yum.log
pkgpolicy=newest
distroverpkg=redhat-release
tolerant=1
exactarch=1
retries=20

[base]
name=Fedora Core $releasever - $basearch - Base
baseurl=http://mirror.web-ster.com/fedora/core/ ... search/os/

[updates-released]
name=Fedora Core $releasever - $basearch - Released Updates
baseurl=http://mirror.web-ster.com/fedora/core/ ... $basearch/

[atomic-testing]
name= Atomic Rocket Turtle - $releasever - Atomic Testing
baseurl=http://3es.atomicrocketturtle.com/atomi ... eleasever/

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

[atomic-app-vault]
name=Atomic Rocket Turtle - $releasever - Atomic PSA App Vault RPMS
baseurl=http://3es.atomicrocketturtle.com/atomic/app-vault/

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

[dries]
name=Extra Fedora rpms dries - $releasever - $basearch
baseurl=http://ftp.belnet.be/packages/dries.uly ... arch/dries



When I'm tiping yum update gotting the following :

# yum update


Resolving dependencies
....Unable to satisfy dependencies
Package php-domxml needs php = 4.3.10-2.4, this is not available.

could you please advice how to upgrade MySQL client atlist?

Thanks

Posted: Fri Jun 23, 2006 11:40 am
by scott
Using install on the first part was part of the culprit there, an install event is not the same as an upgrade event, so it probably missed a bunch of dependencies when you did that. Always start with a yum upgrade, and look to see what its doing before you start screwing around with something more specific, like yum update packagename or yum install packagename.

Now you're stuck in a situation where you'll need to remove parts of php til it can resolve the issue. Start with removing domxml

Posted: Fri Jun 23, 2006 11:45 am
by Unga
But now I on ready installed MySQL like that,
how can I fix that and upgrade the client for it?

If I'm tiping yum update mysql, then gotting that :

# yum update mysql
Gathering header information file(s) from server(s)
Server: Atomic Rocket Turtle - 2 - Atomic PSA App Vault RPMS
Server: Atomic Rocket Turtle - 2 - Atomic Testing
Server: Atomic Rocket Turtle - 2 - Base OS RPMS mirror
Server: Extra Fedora rpms dries - 2 - i386
Server: Atomic Rocket Turtle - 2 - SW-Soft PSA 8.0 RPMS
Server: Fedora Core 2 - i386 - Released Updates
Finding updated packages
Downloading needed headers
mysql is installed and the latest version.
No actions to take

Posted: Fri Jun 23, 2006 1:53 pm
by scott
Yep, you wanted to run "yum update" not "yum update mysql". You'll miss things when you declare a specific package.

Posted: Fri Jun 23, 2006 1:59 pm
by Unga
Well man I know that now :) , but how to fix the situation please help my if you know.

Posted: Fri Jun 23, 2006 5:23 pm
by scott
like i said before, remove that domxml rpm thats giving you trouble

Posted: Fri Jun 23, 2006 6:24 pm
by Unga
ok removed , now update was sucessful, exept one think,
After the reboot apache is down.
when starting apache manually it says :

Unable to make action: Unable to manage service by websrvmng: websrvmng: Service httpd failed to start

0: /usr/local/psa/admin/plib/common_func.php3:174
psaerror(string 'Unable to make action: Unable to manage service by websrvmng: websrvmng: Service httpd failed to start')
1: /usr/local/psa/admin/htdocs/server/restart_services.php:30

Posted: Fri Jun 23, 2006 8:00 pm
by scott
what happens when you try to start it the normal way (/etc/init.d/httpd start)? It's probably missing some dependency inside of php

Posted: Fri Jun 23, 2006 8:20 pm
by Unga
No I'll fixed . it was not about dependencies

well the problem was that installer didn't fix the *.ini files her : /etc/php.d

al libraries was in default location and ini files wanted them her : /usr/lib/php4 so I just moved the copies of :

imap.so
mbstring.so
mysql.so
mysqli.so
pgsql.so

to : /etc/php.d

So basically apache couldn't start because of php, and php needed the libraries.

Also I had to fix manually the file /etc/httpd/conf.d/php.conf

to change libphp4.so to version 5.

well I thought server is gone man :) there is about 40 domains :)

but now I have one more think, I'm dotting the error from cron like :

PHP Warning: mysql_connect(): Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2) in
/var/www/vhosts/hosting-ie.com/httpdocs/billing/include/misc/mod_adodb/drivers/adodb-mysql.inc.php on line
354
[SQL Error] SELECT * FROM config ORDER BY config_type
Can't connect to local
MySQL server through socket '/var/lib/mysql/mysql.sock'

her I'm not sure what to do :(

I thought MySQL will be fixed finally but it looks there is some more problems ?[/code]

Posted: Sat Jun 24, 2006 8:17 am
by Unga
It seems now plesk is stable :

# php -v
PHP 5.0.4 (cli) (built: Jan 29 2006 21:49:59)
Copyright (c) 1997-2004 The PHP Group
Zend Engine v2.0.4-dev, Copyright (c) 1998-2004 Zend Technologies
with the ionCube PHP Loader v3.1.22, Copyright (c) 2002-2006, by ionCube Ltd.

Posted: Sat Jun 24, 2006 9:35 am
by Unga
Well I've got an other misconfiguration
when installing the mambo from aplication vault I'm gotting the error:

PHP version The component version on the server does not satisfy the site application's requirements. == 4.x.x 5.0.4-13.rhfc2.art

Do you know skott where may fix that?
or how :)