Atomicorp

Greetings All.

Okay, the general information first:

RedHat Enterprise Linux 3 with all RHN up2dates complete.
Plesk 8.0.1 with all "autoupdaters" complete.

(excuse the excessive Information)
Current PHP Version: 4.3.2-36.ent
Configure Command
'./configure' '--host=i386-redhat-linux' '--build=i386-redhat-linux' '--target=i386-redhat-linux-gnu' '--program-prefix=' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/usr/com' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--cache-file=../config.cache' '--with-config-file-path=/etc' '--with-config-file-scan-dir=/etc/php.d' '--enable-force-cgi-redirect' '--disable-debug' '--enable-pic' '--disable-rpath' '--enable-inline-optimization' '--with-bz2' '--with-db4=/usr' '--with-curl' '--with-dom=/usr' '--with-exec-dir=/usr/bin' '--with-freetype-dir=/usr' '--with-png-dir=/usr' '--with-gd' '--enable-gd-native-ttf' '--with-ttf' '--with-gettext' '--with-ncurses' '--with-gmp' '--with-iconv' '--with-jpeg-dir=/usr' '--with-openssl' '--with-png' '--with-pspell' '--with-regex=system' '--with-xml' '--with-expat-dir=/usr' '--with-pcre-regex=/usr' '--with-zlib' '--with-layout=GNU' '--enable-bcmath' '--enable-exif' '--enable-ftp' '--enable-magic-quotes' '--enable-safe-mode' '--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-discard-path' '--enable-track-vars' '--enable-trans-sid' '--enable-yp' '--enable-wddx' '--enable-mbstring' '--enable-mbstr-enc-trans' '--enable-mbregex' '--with-pear=/usr/share/pear' '--with-imap=shared' '--with-imap-ssl' '--with-kerberos=/usr/kerberos' '--with-ldap=shared' '--with-mysql=shared,/usr' '--with-pgsql=shared' '--with-unixODBC=shared' '--enable-memory-limit' '--enable-bcmath' '--enable-shmop' '--enable-versioning' '--enable-calendar' '--enable-dbx' '--enable-dio' '--enable-mcal' '--with-apxs2filter=/usr/sbin/apxs'

Current MySQL: MySQL 3.23.58-16.RHEL3.1
phpinfo for MySQL:
Active Persistent Links 2
Active Links 3
Client API version 3.23.58
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient

Directive Local Value Master Value
mysql.allow_persistent On On
mysql.connect_timeout -1 -1
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off

Now for the $25,000 Question:

If I run up2date using the ART channel and allow it to install 4.1.21 2.rhel3.art is it going to break anything?

I've been seeing some really crappy performance out of MySQL after the last RHN up2date run, and it's really making my life miserable.

It also appears that I can't turn off Innodb or skip it's configuration because it breaks Plesk 8.0.1 and half a dozen other things.

I'm not ready to upgrade to PHP 5, for fear that it'll break my current Joomla and other PHP Open Source applications that were written for 4.

Any advice would be helpful, as this is a production server that has kept me awake for the last 3 days. This may be worded a little loopy because of lack of sleep.

Thanks a Bundle.

The ART updates are designed to not break anything on a Plesk box. If you're not sure about updating a production server, get a separate test box.

The main thing that breaks in going from 3.x to 4.1.x is the password change. The only thing you should need to do is edit my.cnf and add this line in the mysqld section

Well immediately after the upgrade was completed, and I edited the my.cnf file to include the oldpasswords statement, mysql wouldn't start.

I decided to completly reboot the server, and I'll try it again after that.

Right now it's broken and I'm hoping It'll come back.

Error Message:
nnoDB: in this failed attempt. InnoDB only wrote those files full of
InnoDB: zeros, but did not yet use them in any way. But be careful: do not
InnoDB: remove old data files which contain your precious data!
061010 9:21:32 [ERROR] Can't init databases
061010 9:21:32 [ERROR] Aborting

Rebooting your server doesn't generally help with services not starting. Did you check /var/log/mysqld.log?

Okay, it's up and running now. Apparently there was a misconfiguration in the My.cnf file with regard to the ibdata file size.

I corrected that and restarted the server and it came back, and has been running better.

So far I've had no reports of php applications not working.