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
