Atomicorp

Security for Everyone
https://forums.atomicorp.com/

PHP 5.2.2 and Mysql 5 Issues

https://forums.atomicorp.com/viewtopic.php?t=1601

Page 1 of 2

PHP 5.2.2 and Mysql 5 Issues

Posted: Fri May 04, 2007 4:18 pm
by scott
Both are up and running on this site now. Please report any issues with the packages to this thread. Thanks!

Posted: Fri May 04, 2007 7:17 pm
by 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

Posted: Fri May 04, 2007 10:49 pm
by scott
Still catching it in mid-update, you guys move fast!

Posted: Sat May 05, 2007 5:10 am
by EvolutionCrazy
scott wrote:Still catching it in mid-update, you guys move fast!
ehehe :D

now mysqlclient14 is available :D

scheduling the update and then i'll do it :D

Cannot get channel

Posted: Mon May 07, 2007 4:28 pm
by 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

Posted: Mon May 07, 2007 5:17 pm
by EvolutionCrazy
update done this morning, everything fine as for now ;)

ty ART :wink:

Upgrade progress

Posted: Tue May 08, 2007 5:31 pm
by 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.

Re: Cannot get channel

Posted: Wed May 09, 2007 6:39 am
by breun
ScholarDave wrote: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/

Re: Cannot get channel

Posted: Wed May 09, 2007 10:25 am
by ScholarDave
breun wrote:
ScholarDave wrote: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.

Posted: Sat May 12, 2007 6:33 pm
by 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!

Posted: Tue May 15, 2007 10:05 am
by 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?

Posted: Tue May 15, 2007 4:50 pm
by 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.

Posted: Thu Jun 07, 2007 1:12 am
by 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

Posted: Thu Jun 07, 2007 7:28 am
by EvolutionCrazy
check out error reporting in php.ini

you are printing also the warnings...

Posted: Thu Jun 07, 2007 5:47 pm
by CrK01
yes, It's the solution

but I want to solve errors or warnings.

With 5.0.2 all was fine ;)
All times are UTC-04:00
Page 1 of 2

Powered by phpBB® Forum Software © phpBB Limited