Atomicorp

Following:
http://www.atomicorp.com/wiki/index.php/Mysql

Output:
yum update
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* atomic: www6.atomicorp.com
Setting up Update Process
Resolving Dependencies
--> Running transaction check
--> Processing Dependency: libmysqlclient.so.15()(64bit) for package: psa-mail-qc-driver
--> Processing Dependency: libmysqlclient.so.15()(64bit) for package: psa-backup-manager
--> Processing Dependency: libmysqlclient.so.15()(64bit) for package: asl-php-mysql
--> Processing Dependency: libmysqlclient.so.15()(64bit) for package: libdbi-dbd-mysql
--> Processing Dependency: libmysqlclient.so.15()(64bit) for package: ossec-hids-server
--> Processing Dependency: libmysqlclient.so.15()(64bit) for package: psa-fileserver
--> Processing Dependency: libmysqlclient.so.15()(64bit) for package: ruby-mysql
--> Processing Dependency: libmysqlclient.so.15()(64bit) for package: psa-drweb-configurator
--> Processing Dependency: libmysqlclient.so.15()(64bit) for package: psa-hotfix3-9.2.3
--> Processing Dependency: libmysqlclient.so.15()(64bit) for package: dovecot
--> Processing Dependency: libmysqlclient.so.15()(64bit) for package: mysql-connector-odbc
--> Processing Dependency: libmysqlclient.so.15()(64bit) for package: psa-mail-driver-common
--> Processing Dependency: libmysqlclient.so.15()(64bit) for package: roadsend-php-libs
--> Processing Dependency: libmysqlclient.so.15()(64bit) for package: cs-gs
--> Processing Dependency: libmysqlclient.so.15()(64bit) for package: perl-DBD-MySQL
--> Processing Dependency: libmysqlclient.so.15()(64bit) for package: php-mysql
--> Processing Dependency: libmysqlclient.so.15()(64bit) for package: psa-kav
--> Processing Dependency: libmysqlclient.so.15()(64bit) for package: psa
--> Processing Dependency: libmysqlclient.so.15()(64bit) for package: psa-spamassassin
--> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15)(64bit) for package: asl-php-mysql
--> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15)(64bit) for package: libdbi-dbd-mysql
--> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15)(64bit) for package: ossec-hids-server
--> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15)(64bit) for package: psa-fileserver
--> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15)(64bit) for package: ruby-mysql
--> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15)(64bit) for package: php-mysql
--> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15)(64bit) for package: dovecot
--> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15)(64bit) for package: mysql-connector-odbc
--> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15)(64bit) for package: psa-drweb-configurator
--> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15)(64bit) for package: cs-gs
--> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15)(64bit) for package: perl-DBD-MySQL
--> Processing Dependency: libmysqlclient_r.so.15()(64bit) for package: mysql-connector-odbc
--> Processing Dependency: libmysqlclient_r.so.15()(64bit) for package: MySQL-python
--> Processing Dependency: libmysqlclient_r.so.15(libmysqlclient_15)(64bit) for package: mysql-connector-odbc
--> Processing Dependency: libmysqlclient_r.so.15(libmysqlclient_15)(64bit) for package: MySQL-python
---> Package mysql.i386 0:5.1.49-1.el5.art set to be updated
--> Processing Dependency: mysql-libs = 5.1.49-1.el5.art for package: mysql
--> Processing Dependency: libmysqlclient_r.so.16 for package: mysql
--> Processing Dependency: libmysqlclient.so.16 for package: mysql
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16) for package: mysql
--> Processing Dependency: libmysqlclient_r.so.16(libmysqlclient_16) for package: mysql
---> Package mysql.x86_64 0:5.1.49-1.el5.art set to be updated
---> Package mysql-server.x86_64 0:5.1.49-1.el5.art set to be updated
---> Package nmap.x86_64 2:4.85-1.el5.art set to be updated
---> Package perl-Archive-Tar.noarch 1:1.39.1-2.el5.art set to be updated
---> Package perl-Font-AFM.noarch 0:1.19-4.el5.art set to be updated
---> Package perl-HTML-Format.noarch 0:2.04-6.el5.art set to be updated
---> Package perl-HTML-Tree.noarch 1:3.23-9.el5.art set to be updated
--> Processing Dependency: php <= 5.2.0 for package: php-sqlite2
---> Package php.x86_64 0:5.2.14-2.el5.art set to be updated
---> Package php-cli.x86_64 0:5.2.14-2.el5.art set to be updated
---> Package php-common.x86_64 0:5.2.14-2.el5.art set to be updated
---> Package php-devel.x86_64 0:5.2.14-2.el5.art set to be updated
---> Package php-gd.x86_64 0:5.2.14-2.el5.art set to be updated
---> Package php-imap.x86_64 0:5.2.14-2.el5.art set to be updated
---> Package php-ldap.x86_64 0:5.2.14-2.el5.art set to be updated
---> Package php-mbstring.x86_64 0:5.2.14-2.el5.art set to be updated
---> Package php-mysql.x86_64 0:5.2.14-2.el5.art set to be updated
---> Package php-pdo.x86_64 0:5.2.14-2.el5.art set to be updated
---> Package php-pear.noarch 1:1.7.2-2.el5.art set to be updated
---> Package php-xml.x86_64 0:5.2.14-2.el5.art set to be updated
---> Package psa-atmail.noarch 1:1.03-6.el5.art set to be updated
---> Package psa-kronolith.noarch 0:2.1.8-2.el5.art set to be updated
---> Package recode.x86_64 0:3.6-28.el5.art set to be updated
---> Package roadsend-php-libs.x86_64 0:2.9.8-9.el5.art set to be updated
---> Package spamassassin.x86_64 1:3.2.5-1.el5.art set to be updated
--> Running transaction check
---> Package mysql-libs.i386 0:5.1.49-1.el5.art set to be updated
---> Package mysql-libs.x86_64 0:5.1.49-1.el5.art set to be updated
---> Package mysqlclient15.x86_64 0:5.0.90-1.el5.art set to be updated
--> Processing Dependency: php <= 5.2.0 for package: php-sqlite2
--> Finished Dependency Resolution
php-sqlite2-5.1.6-200705230937.x86_64 from installed has depsolving problems
--> Missing Dependency: php <= 5.2.0 is needed by package php-sqlite2-5.1.6-200705230937.x86_64 (installed)
Error: Missing Dependency: php <= 5.2.0 is needed by package php-sqlite2-5.1.6-200705230937.x86_64 (installed)
You could try using --skip-broken to work around the problem
You could try running: package-cleanup --problems
package-cleanup --dupes
rpm -Va --nofiles --nodigest
The program package-cleanup is found in the yum-utils package.

php must be upgraded first?
Current:
PHP Version: 5.1.6
MYSQL Version: 5.0.77-log

I followed:
http://www.question-defense.com/2009/07 ... -ispconfig
#yum update php returned the same output as above.

I would like to upgrade mysql.
Can anyone suggest what I should do?

Try removing php-sqlite2, that looks to me like its the barrier.

I have managed to erase plesk billing & site builder + php-sqlite2

I have upgraded mysql according to:
http://www.atomicorp.com/wiki/index.php/Mysql

So far, so good, sort of...

One error during the update from atomic repo:
Failed loading /usr/lib64/php/modules//php_ioncube_loader_lin_5.1_x86_64.so: /usr/lib64/php/modules//php_ioncube_loader_lin_5.1_x86_64.so: undefine
d symbol: zend_unmangle_property_name_ex

Installed:
php-ioncube-loader.x86_64 1:3.3.20-2.el5.art
(again)

However...
Site error: the file /path/to/index.php requires the ionCube PHP Loader ioncube_loader_lin_5.2.so to be installed by the site administrator.

(I can see ioncube_loader_lin_5.2.so in a sub folder of the program that is sending the above error)

Any ideas on how I resolve this little one?

maybe this:
http://www.atomicorp.com/forums/viewtop ... f=2&t=2929

edit /etc/php.d/ioncube-loader.ini
zend_extension=/usr/lib64/php/modules//php_ioncube_loader_lin_5.2_x86_64.so
- seems to have done it.

I would just like to take a moment to thank those of you who answer my newb questions in this forum.

Thank you.

And to the ASL support team whom I bug constantly.

Thank you.

This "risk management" caper is a definite learning curve but I am always moving forwards.

Maybe one day I will be experienced enough to reciprocate.

Who knows?

Our pleasure, and I'm very glad to see the community helped you too. There are some wonderful folks on these forums so thank you everyone!

Risk Management is quite complex. We're always looking for ways to make that easier for you and everyone else, so hearing from you about what your struggles are helps us to help you.

If we dont know, we can't research it!

One last little bug...

php -v
PHP Warning: Module 'ionCube Loader' already loaded in Unknown on line 0
The ionCube PHP Loader is disabled because of startup problems.
PHP 5.2.14 (cli) (built: Aug 12 2010 16:03:48)
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2010 Zend Technologies
with the ionCube PHP Loader v3.1.28, Copyright (c) 2002-2007, by ionCube Ltd., and

There is a post in the forum that suggests removing /etc/php.d/ioncube.ini after making the edit mentioned above to /etc/php.d/ioncube-loader.ini

# cat 'ioncube.ini' | less
zend_extension=/usr/lib64/php/ioncube/ioncube_loader_lin_5.2.so
# cat 'ioncube-loader.ini' | less
zend_extension=/usr/lib64/php/modules//php_ioncube_loader_lin_5.2_x86_64.so

I renamed /etc/php.d/ioncube.ini as ioncube.ini_disabled and I think this worked.
Did I select the preferred .ini file or doesn't it matter, anyway?

NOW:
php -v
PHP 5.2.14 (cli) (built: Aug 12 2010 16:03:48)
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2010 Zend Technologies
with the ionCube PHP Loader v3.1.28, Copyright (c) 2002-2007, by ionCube Ltd

Yeah you did, I think the other one gets added by plesk sitebuilder.

ioncube.ini is created by:
Aug 24 02:04:35 Updated: 1:php-ioncube-loader-3.3.20-3.el5.art.x86_64
See:
-rw-r--r-- 1 root root 64 Aug 24 02:04 ioncube.ini

So I ran the updates from mysql 4.1 to mysql 5.1 on centos 4 plesk 8.6 and now half the databases on the server have tables that show as corrupt. mysql_upgrade just spits out a ton of:

Error : Incorrect key file for table 'jos_components'; try to repair it
error : Corrupt

for example. It seems that according to http://bugs.mysql.com/bug.php?id=37631 there is simply no way to upgrade from mysql 5.0.62 or earlier to mysql 5.1, you have to go to mysql 5.0.62 first, let it convert the tables to a new format, then go to 5.1 and let it again convert the tables. Otherwise, you're going to end up with random table crashes in 5.1 like I've just done, so now I'm trying to figure out how to back out the ART 5.1 package to 5.0.x if I can find one or back down to 4.1 which probably won't be possible now that I've attempted the mysql_upgrade command.

Good grief. That's not good.