PHP 5.2.2 and Mysql 5 Issues

[scott]

Both are up and running on this site now. Please report any issues with the packages to this thread. Thanks!

[EvolutionCrazy]

Centos 4.4

Code: Select all

Added 25 new packages, deleted 0 old in 0.37 seconds
Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Downloading header for php-gd to pack into transaction set.
php-gd-5.2.2-2.el4.art.i3 100% |=========================|  12 kB    00:00
---> Package php-gd.i386 0:5.2.2-2.el4.art set to be updated
---> Downloading header for php-imap to pack into transaction set.
php-imap-5.2.2-2.el4.art. 100% |=========================|  12 kB    00:00
---> Package php-imap.i386 0:5.2.2-2.el4.art set to be updated
---> Downloading header for php-pear to pack into transaction set.
php-pear-1.5.0-5.el4.art. 100% |=========================|  26 kB    00:00
---> Package php-pear.noarch 1:1.5.0-5.el4.art set to be updated
---> Downloading header for php-mbstring to pack into transaction set.
php-mbstring-5.2.2-2.el4. 100% |=========================|  11 kB    00:00
---> Package php-mbstring.i386 0:5.2.2-2.el4.art set to be updated
---> Downloading header for mysql-server to pack into transaction set.
mysql-server-5.0.27-1.el4 100% |=========================|  33 kB    00:00
---> Package mysql-server.i386 0:5.0.27-1.el4.art set to be updated
---> Downloading header for php-devel to pack into transaction set.
php-devel-5.2.2-2.el4.art 100% |=========================|  41 kB    00:00
---> Package php-devel.i386 0:5.2.2-2.el4.art set to be updated
---> Downloading header for php to pack into transaction set.
php-5.2.2-2.el4.art.i386. 100% |=========================|  13 kB    00:00
---> Package php.i386 0:5.2.2-2.el4.art set to be updated
---> Downloading header for mysql to pack into transaction set.
mysql-5.0.27-1.el4.art.i3 100% |=========================|  35 kB    00:00
---> Package mysql.i386 0:5.0.27-1.el4.art set to be updated
---> Downloading header for php-xml to pack into transaction set.
php-xml-5.2.2-2.el4.art.i 100% |=========================|  12 kB    00:00
---> Package php-xml.i386 0:5.2.2-2.el4.art set to be updated
---> Downloading header for php-mysql to pack into transaction set.
php-mysql-5.2.2-2.el4.art 100% |=========================|  12 kB    00:00
---> Package php-mysql.i386 0:5.2.2-2.el4.art set to be updated
--> Running transaction check
--> Processing Dependency: libmysqlclient.so.14 for package: php-mysql
--> Processing Dependency: libmysqlclient.so.14 for package: perl-DBD-MySQL
--> Processing Dependency: php-common = 5.2.2-2.el4.art for package: php-gd
--> Processing Dependency: php-common = 5.2.2-2.el4.art for package: php-xml
--> Processing Dependency: php-cli for package: php-pear
--> Processing Dependency: php-common = 5.2.2-2.el4.art for package: php-mysql
--> Processing Dependency: php-common = 5.2.2-2.el4.art for package: php-imap
--> Processing Dependency: php-cli = 5.2.2-2.el4.art for package: php
--> Processing Dependency: php-pdo for package: php-mysql
--> Processing Dependency: php-common = 5.2.2-2.el4.art for package: php-mbstring
--> Processing Dependency: libmysqlclient.so.14(libmysqlclient_14) for package: php-mysql
--> Processing Dependency: php-common = 5.2.2-2.el4.art for package: php
--> Restarting Dependency Resolution with new changes.
--> Populating transaction set with selected packages. Please wait.
---> Downloading header for php-common to pack into transaction set.
php-common-5.2.2-2.el4.ar 100% |=========================|  15 kB    00:00
---> Package php-common.i386 0:5.2.2-2.el4.art set to be updated
---> Downloading header for php-cli to pack into transaction set.
php-cli-5.2.2-2.el4.art.i 100% |=========================|  13 kB    00:00
---> Package php-cli.i386 0:5.2.2-2.el4.art set to be updated
---> Downloading header for php-pdo to pack into transaction set.
php-pdo-5.2.2-2.el4.art.i 100% |=========================|  12 kB    00:00
---> Package php-pdo.i386 0:5.2.2-2.el4.art set to be updated
--> Running transaction check
--> Processing Dependency: libmysqlclient.so.14 for package: php-mysql
--> Processing Dependency: libmysqlclient.so.14(libmysqlclient_14) for package: php-mysql
--> Processing Dependency: libmysqlclient.so.14 for package: perl-DBD-MySQL
--> Finished Dependency Resolution
Error: Missing Dependency: libmysqlclient.so.14 is needed by package php-mysql
Error: Missing Dependency: libmysqlclient.so.14 is needed by package perl-DBD-MySQL
Error: Missing Dependency: libmysqlclient.so.14(libmysqlclient_14) is needed by package php-mysql

Code: Select all

yum check-update
Setting up repositories
Reading repository metadata in from local files

mysql.i386                               5.0.27-1.el4.art       atomic
mysql-server.i386                        5.0.27-1.el4.art       atomic
php.i386                                 5.2.2-2.el4.art        atomic
php-devel.i386                           5.2.2-2.el4.art        atomic
php-gd.i386                              5.2.2-2.el4.art        atomic
php-imap.i386                            5.2.2-2.el4.art        atomic
php-mbstring.i386                        5.2.2-2.el4.art        atomic
php-mysql.i386                           5.2.2-2.el4.art        atomic
php-pear.noarch                          1:1.5.0-5.el4.art      atomic
php-xml.i386                             5.2.2-2.el4.art        atomic

Code: Select all

yum list | grep mysql
mysql.i386                               4.1.21-2.rhel4.art     installed
mysql-server.i386                        4.1.21-2.rhel4.art     installed
php-mysql.i386                           5.0.4-13.rhel4.art     installed
freeradius-mysql.i386                    1.0.1-3.RHEL4.3        base
libdbi-dbd-mysql.i386                    0.6.5-10.RHEL4.1       base
mod_auth_mysql.i386                      1:2.6.1-2.2            base
mysql.i386                               5.0.27-1.el4.art       atomic
mysql-bench.i386                         5.0.27-1.el4.art       atomic
mysql-devel.i386                         5.0.27-1.el4.art       atomic
mysql-server.i386                        5.0.27-1.el4.art       atomic
mysql-test.i386                          5.0.27-1.el4.art       atomic
mysqlclient10.i386                       3.23.58-4.RHEL4.1      base
mysqlclient10-devel.i386                 3.23.58-4.RHEL4.1      base
php-mysql.i386                           5.2.2-2.el4.art        atomic
php51-mysql.i386                         5.1.4-20060823.rhas4   plesk-8.1.0
php51-mysqli.i386                        5.1.4-20060823.rhas4   plesk-8.1.0
php51-pdo_mysql.i386                     5.1.4-20060823.rhas4   plesk-8.1.0
psa-ruby-mysql.i386                      2.7-200610081251       plesk-8.1.0
pyicq-t-mysql.noarch                     0.8-3.el4.art          atomic

[scott]

Still catching it in mid-update, you guys move fast!

[EvolutionCrazy]

Still catching it in mid-update, you guys move fast!

ehehe

now mysqlclient14 is available

scheduling the update and then i'll do it

[ScholarDave]

I have a clean 1and1 box which I have used AOOI on and have tried to do the upgrade to PHP5.2. and MySql but cannot find it in the channels.

I am very new to this but have noted one typo at http://www.atomicorp.com/channels/plesk/8.1.0/ where the channel has http://http:// in front of it, I presume it should only be one...

The only php version it finds =============================================================================
Package Arch Version Repository Size
=============================================================================
Installing:
php i386 5.0.4-13.rhel4.art atomic 4.0 M

Transaction Summary

[EvolutionCrazy]

update done this morning, everything fine as for now

ty ART

[ScholarDave]

Scott,
Problems I have:
Step 1 – Remove php-sqlite2. Didn’t have to as it wasn’t installed.
Step 2 – Upgade to php5.2 did this with yum upgrade but it clashed with php-pear
- So removed php-pear
- Upgrade worked, I get php5.2.2
- Can’t reinstall php-pear as it gives:
Error: Missing Dependency: php = 4.3.9-3.22.4 is needed by package php-pear

1and1 box with CentOS installed via your wonderful AOOI.

[breun]

I have a clean 1and1 box which I have used AOOI on and have tried to do the upgrade to PHP5.2. and MySql but cannot find it in the channels.

I think you may be looking at the old archive. Take a look here: http://www.atomicorp.com/channels/atomic/

[ScholarDave]

I have a clean 1and1 box which I have used AOOI on and have tried to do the upgrade to PHP5.2. and MySql but cannot find it in the channels.

I think you may be looking at the old archive. Take a look here: http://www.atomicorp.com/channels/atomic/

Thanks, indeed that was my problem at first but it then moved on to not being able to reinstall php-pear. As it's a clean box I may try reinstalling just in case I messed something up with using the wrong channel.

[Fenice]

One question - anybody had to do some extra steps upgrading from mysql 4.1 to mysql 5?

I have rebuilt the php package to add some extra options I seriously needed, so I should install mysql 5 separately.

Thanks!

[Troy McClure]

I have updated my servers to these version and just have one small issue that others might like to know. I connect to MySQL using EMS MySQL Manager. When I do I get an error that mysql.proc doesn't exist. Some functions within the program don't work correctly, most notable extracting a database. I haven't noticed anywhere else that this causes any problems (php, mysqldump, etc.). I have found the solution is to run mysql_upgrade http://dev.mysql.com/doc/refman/5.0/en/ ... grade.html. I have run this on my testing machine and everything seems ok, but I am a little nervous to run this on my production box. Has anyone had any experience running this?

[Troy McClure]

Well, I have found that when trying to create stored procedures through MySQL Manager or through the shell gives the same error. So there is no way to create a stored procedure. This same thing has happened on all my boxes (1 test, 2 production). Anyone else with this same issue? After running the fix I suggested above, my test box seems to add stored procedures ok.

[CrK01]

hello

I have updated from the new repo, php 5.2.2 and mysql from 4.0 to 5.0

now some webs have lots and lots of errors ( webs like phpnuke ):


[Thu Jun 07 07:10:01 2007] [error] [client 62.15.128.2xx] PHP Warning: mktime() expects parameter 1 to be long, string given in /var/www/vhosts/HOST.com/httpdocs/blocks/block-Calendar.php on line 85

For example... repeated every 1 second.. and the HTTP loads are growing and growing ! Any qay to rescue it ? or make compatible... and it's a continue loop...

PD: I have fedora core 4 , plesk 8.1.1

[EvolutionCrazy]

check out error reporting in php.ini

you are printing also the warnings...

[CrK01]

yes, It's the solution

but I want to solve errors or warnings.

With 5.0.2 all was fine