php upgrade 5.2.8 and sqlite2 dependencies

mdtiberi · Unread post by **mdtiberi** » Tue Jan 06, 2009 2:20 pm

Yes, I am one of those people who use Sitebuilder and sqlite2 is unfortunately still required. I am trying to upgrade php to 5.2.8 but yum complains with the following error:

--> Processing Dependency: php <= 5.2.0 for package: php-sqlite2
--> Finished Dependency Resolution
Error: Missing Dependency: php <= 5.2.0 is needed by package php-sqlite2

How can I exclude this package from from yum update? Should I just update each package individually?

Thanks all

mdtiberi · Unread post by **mdtiberi** » Tue Jan 06, 2009 4:34 pm

Sorry, posted in the wrong place for php issues. Haven't been to your site for awhile and things have changed a bit I see.

Unread post by **scott** » Tue Jan 06, 2009 6:43 pm

Upgrading to 5.2.x would break that I think. Your only option would be to remove php-sqlite2

j0ney3 · Unread post by **j0ney3** » Tue Jan 06, 2009 7:02 pm

Yikes....looks like it's got hooks in just about everything psa...

Are mdtiberi and I the only ones having this issue?

Code: Select all

--> Processing Dependency: any-php-sqlite2 for package: sb-publish
--> Processing Dependency: php-pdo for package: php-mysql
--> Restarting Dependency Resolution with new changes.
--> Populating transaction set with selected packages. Please wait.
---> Package php-mysql.i386 0:5.2.8-1.el4.art set to be erased
---> Package sb-publish.noarch 0:3.0.1-200610111446 set to be erased
--> Running transaction check
--> Processing Dependency: php-mysql for package: psa-php4-configurator
--> Restarting Dependency Resolution with new changes.
--> Populating transaction set with selected packages. Please wait.
---> Package psa-php4-configurator.noarch 0:1.4.0-cos4.build86080722.02 set to be erased
--> Running transaction check
--> Processing Dependency: psa-php-configurator >= 1.4.0 for package: psa
--> Restarting Dependency Resolution with new changes.
--> Populating transaction set with selected packages. Please wait.
---> Package psa.i586 0:8.6.0-cos4.build86080722.02 set to be erased
--> Running transaction check
--> Processing Dependency: psa = 8.6.0 for package: psa-api
--> Processing Dependency: psa = 8.6.0 for package: psa-backup-manager
--> Processing Dependency: psa for package: asl-web-gui
--> Processing Dependency: psa >= 8.0.0 for package: psa-horde
--> Processing Dependency: /usr/local/psa/admin/bin/php for package: psa-api-rpc
--> Processing Dependency: psa >= 8.0.0 for package: psa-horde
--> Processing Dependency: /usr/local/psa/admin/bin/php for package: psa-api
--> Processing Dependency: psa = 8.6.0 for package: psa-api-rpc
--> Processing Dependency: psa >= 8.6.0 for package: psa-tomcat-configurator
--> Processing Dependency: psa >= 7.5.3 for package: psa-turba
--> Processing Dependency: psa >= 8.0.0 for package: psa-horde
--> Processing Dependency: psa >= 8.6.0 for package: psa-awstats-configurator
--> Processing Dependency: psa >= 8.0.0 for package: psa-libpam-plesk
--> Processing Dependency: psa for package: atomic-yum
--> Processing Dependency: psa >= 8.6.0 for package: SSHTerm
--> Processing Dependency: psa = 8.6.0 for package: psa-migration-manager
--> Restarting Dependency Resolution with new changes.
--> Populating transaction set with selected packages. Please wait.
---> Package atomic-yum.noarch 0:0.4-3.el4.art set to be erased
---> Package psa-horde.noarch 0:3.1.3-cos4.build81070322.16 set to be erased
---> Package psa-migration-manager.i586 0:8.6.0-cos4.build86080930.08 set to be erased
---> Package psa-api-rpc.noarch 0:8.6.0-cos4.build86080930.08 set to be erased
---> Package psa-horde.noarch 0:3.1.5-cos4.build83071218.20 set to be erased
---> Package psa-backup-manager.i586 0:8.6.0-cos4.build86080930.08 set to be erased
---> Package SSHTerm.noarch 0:0.2.2-cos4.build86080722.02 set to be erased
---> Package asl-web-gui.noarch 0:1.0.3-2.el4.art set to be erased
---> Package psa-libpam-plesk.i586 0:8.6.0-cos4.build86080722.02 set to be erased
---> Package psa-horde.noarch 0:3.1.7-cos4.build86080722.02 set to be erased
---> Package psa-turba.noarch 0:2.1.7-cos4.build86080722.02 set to be erased
---> Package psa-awstats-configurator.noarch 0:1.0.0-cos4.build86080722.02 set to be erased
---> Package psa-tomcat-configurator.noarch 0:8.6.0-cos4.build86080722.02 set to be erased
---> Package psa-api.noarch 0:8.6.0-cos4.build86080930.08 set to be erased
--> Running transaction check
--> Processing Dependency: psa-horde for package: psa-imp
--> Processing Dependency: psa-horde for package: psa-mnemo
--> Processing Dependency: psa-horde >= 3 for package: psa-kronolith
--> Restarting Dependency Resolution with new changes.
--> Populating transaction set with selected packages. Please wait.
---> Package psa-mnemo.noarch 0:2.1.2-cos4.build86080722.02 set to be erased
---> Package psa-kronolith.noarch 0:2.1.8-1.el4.art set to be erased
---> Package psa-imp.noarch 0:4.1.6-cos4.build86080722.02 set to be erased
--> Running transaction check
--> Processing Dependency: psa-imp for package: psa-ingo
--> Processing Dependency: psa-imp for package: psa-mimp
--> Processing Dependency: psa-imp for package: psa-passwd
--> Restarting Dependency Resolution with new changes.
--> Populating transaction set with selected packages. Please wait.
---> Package psa-passwd.noarch 0:3.0.1-cos4.build86080722.02 set to be erased
---> Package psa-ingo.noarch 0:1.1.5-cos4.build86080722.02 set to be erased
---> Package psa-mimp.noarch 0:1.0.2-cos4.build86080722.02 set to be erased
--> Running transaction check




Dependencies Resolved

=============================================================================
 Package                 Arch       Version          Repository        Size
=============================================================================
Removing:
 php-pdo                 i386       5.2.8-1.el4.art  installed         107 k
Removing for dependencies:
 SSHTerm                 noarch     0.2.2-cos4.build86080722.02  installed         4.9 M
 asl-web-gui             noarch     1.0.3-2.el4.art  installed         254 k
 atomic-yum              noarch     0.4-3.el4.art    installed         715 k
 php-mysql               i386       5.2.8-1.el4.art  installed         156 k
 psa                     i586       8.6.0-cos4.build86080722.02  installed          52 M
 psa-api                 noarch     8.6.0-cos4.build86080930.08  installed         4.3 M
 psa-api-rpc             noarch     8.6.0-cos4.build86080930.08  installed         1.2 M
 psa-awstats-configurator  noarch     1.0.0-cos4.build86080722.02  installed          0.0
 psa-backup-manager      i586       8.6.0-cos4.build86080930.08  installed         675 k
 psa-horde               noarch     3.1.7-cos4.build86080722.02  installed          14 M
 psa-horde               noarch     3.1.5-cos4.build83071218.20  installed          23 M
 psa-horde               noarch     3.1.3-cos4.build81070322.16  installed          23 M
 psa-imp                 noarch     4.1.6-cos4.build86080722.02  installed         8.4 M
 psa-ingo                noarch     1.1.5-cos4.build86080722.02  installed         3.5 M
 psa-kronolith           noarch     2.1.8-1.el4.art  installed         8.8 M
 psa-libpam-plesk        i586       8.6.0-cos4.build86080722.02  installed         146 k
 psa-migration-manager   i586       8.6.0-cos4.build86080930.08  installed         7.6 M
 psa-mimp                noarch     1.0.2-cos4.build86080722.02  installed         1.8 M
 psa-mnemo               noarch     2.1.2-cos4.build86080722.02  installed         2.9 M
 psa-passwd              noarch     3.0.1-cos4.build86080722.02  installed         3.0 M
 psa-php4-configurator   noarch     1.4.0-cos4.build86080722.02  installed          0.0
 psa-tomcat-configurator  noarch     8.6.0-cos4.build86080722.02  installed          0.0
 psa-turba               noarch     2.1.7-cos4.build86080722.02  installed         4.1 M
 sb-publish              noarch     3.0.1-200610111446  installed          0.0

Transaction Summary
=============================================================================
Install      0 Package(s)
Update       0 Package(s)
Remove      25 Package(s)
Total download size: 0
Is this ok [y/N]:

mdtiberi · Unread post by **mdtiberi** » Tue Jan 06, 2009 7:11 pm

I actually have php 5.2.8-1.el5.art installed with no complaints from Sitebuilder which is the only reason I have sqlite2 (5.1.6) installed.

I tried checking which package is calling out the "any-php-sqlite2" dependency. I checked most of the packages using yum deplist to see who is calling it out but to no avail. I thought that the double dash following a yum transaction check meant that it is dependent on the preceding package. For example from yum update:

Resolving Dependencies
--> Running transaction check
---> Package php.x86_64 0:5.2.8-3.el5.art set to be updated
--> Processing Dependency: any-php-sqlite2 for package: sb-publish
---> Package php-mbstring.x86_64 0:5.2.8-3.el5.art set to be updated
---> Package php-common.x86_64 0:5.2.8-3.el5.art set to be updated
---> Package php-ldap.x86_64 0:5.2.8-3.el5.art set to be updated
---> Package php-imap.x86_64 0:5.2.8-3.el5.art set to be updated
---> Package php-cli.x86_64 0:5.2.8-3.el5.art set to be updated
---> Package php-pdo.x86_64 0:5.2.8-3.el5.art set to be updated
---> Package php-gd.x86_64 0:5.2.8-3.el5.art set to be updated
--> Processing Dependency: libt1.so.5()(64bit) for package: php-gd
---> Package php-xml.x86_64 0:5.2.8-3.el5.art set to be updated
---> Package php-mysql.x86_64 0:5.2.8-3.el5.art set to be updated
--> Running transaction check
---> Package t1lib.x86_64 0:5.1.2-2.el5.art set to be updated
--> Processing Dependency: any-php-sqlite2 for package: sb-publish
--> Finished Dependency Resolution
Error: Missing Dependency: any-php-sqlite2 is needed by package sb-publish

So here it appears that the dependency involves php.x86_64 but I am not sure. I tried yum --exclude for "sb-publish" but that didn't work either. Really can't remove php-sqlite2.php as there are tonnes of psa dependencies.

j0ney3 · Unread post by **j0ney3** » Wed Jan 07, 2009 10:24 am

Yeah, I'm actually running 5.2.8 right now as well, it's just this most recent update that cries about the deps. I'd remove sitebuilder as I don't use it, but that won't do the trick as seen by my post above. Keep me posted if you figure anything out.

BerArt · Unread post by **BerArt** » Wed Jan 07, 2009 10:45 am

I had the same problem on one server:

--> Running transaction check
---> Package php-mbstring.i386 0:5.2.8-3.el5.art set to be updated
---> Package php-mysql.i386 0:5.2.8-3.el5.art set to be updated
---> Package php-cli.i386 0:5.2.8-3.el5.art set to be updated
---> Package php-xml.i386 0:5.2.8-3.el5.art set to be updated
---> Package php-devel.i386 0:5.2.8-3.el5.art set to be updated
---> Package php.i386 0:5.2.8-3.el5.art set to be updated
---> Package php-pdo.i386 0:5.2.8-3.el5.art set to be updated
---> Package php-gd.i386 0:5.2.8-3.el5.art set to be updated
--> Processing Dependency: libt1.so.5 for package: php-gd
--> Processing Dependency: any-php-sqlite2 for package: sb-publish
---> Package unhide.i386 0:20080519-1.el5.art set to be updated
---> Package php-imap.i386 0:5.2.8-3.el5.art set to be updated
---> Package php-common.i386 0:5.2.8-3.el5.art set to be updated
--> Running transaction check
---> Package php-sqlite2.i386 0:5.1.6-200705230938 set to be updated
--> Processing Dependency: php <= 5.2.0 for package: php-sqlite2
---> Package t1lib.i386 0:5.1.2-2.el5.art set to be updated
--> Finished Dependency Resolution
Error: Missing Dependency: php <= 5.2.0 is needed by package php-sqlite2
.. upgrade failed!

mail send to @support ...

j0ney3 · Unread post by **j0ney3** » Wed Jan 07, 2009 11:57 am

The interesting thing about this is that mine is calling for php <= 4.4.0 !!! I've not been on php 4 for a really long time

Code: Select all

Error: Missing Dependency: php <= 4.4.0 is needed by package php-sqlite2

Ber,

Let us know what you hear back from support!

Thanks,
Jonas

Unread post by **scott** » Wed Jan 07, 2009 11:58 am

You should probably exclude that then, I'll bet its coming from the plesk repo.

j0ney3 · Unread post by **j0ney3** » Wed Jan 07, 2009 12:01 pm

Ok, per Scott's suggestion, I've disabled the Plesk repo and tried again:

Code: Select all

Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Package php-imap.i386 0:5.2.8-3.el4.art set to be updated
---> Package unhide.i386 0:20080519-1.el4.art set to be updated
---> Package php-ldap.i386 0:5.2.8-3.el4.art set to be updated
---> Package php-xml.i386 0:5.2.8-3.el4.art set to be updated
---> Package php-mysql.i386 0:5.2.8-3.el4.art set to be updated
---> Package php-mbstring.i386 0:5.2.8-3.el4.art set to be updated
---> Package php-common.i386 0:5.2.8-3.el4.art set to be updated
---> Package php.i386 0:5.2.8-3.el4.art set to be updated
---> Package php-cli.i386 0:5.2.8-3.el4.art set to be updated
---> Package rkhunter.noarch 0:1.3.4-1.el4.art set to be updated
---> Package php-gd.i386 0:5.2.8-3.el4.art set to be updated
---> Package php-pdo.i386 0:5.2.8-3.el4.art set to be updated
---> Package php-devel.i386 0:5.2.8-3.el4.art set to be updated
--> Running transaction check
--> Processing Dependency: libt1.so.5 for package: php-gd
--> Processing Dependency: any-php-sqlite2 for package: sb-publish
--> Restarting Dependency Resolution with new changes.
--> Populating transaction set with selected packages. Please wait.
---> Package t1lib.i386 0:5.1.2-2.el4.art set to be updated
--> Running transaction check
--> Processing Dependency: any-php-sqlite2 for package: sb-publish
--> Finished Dependency Resolution
Error: Missing Dependency: any-php-sqlite2 is needed by package sb-publish

Looks like I'm in the same boat with mdtiberi now...

BerArt · Unread post by **BerArt** » Wed Jan 07, 2009 12:19 pm

Excluding does not work, any other ideas? What is using php-sqlite2, only sitebuider? Would it help if you uninstall it?

Unread post by **scott** » Wed Jan 07, 2009 12:21 pm

what happens when you remove sitebuilder? Seriously, short of me putting out a fake sitebuilder package to break it (which would be pretty mean) theres not really anything i can do from this side about it.

j0ney3 · Unread post by **j0ney3** » Wed Jan 07, 2009 12:21 pm

j0ney3 wrote:Yikes....looks like it's got hooks in just about everything psa...

Are mdtiberi and I the only ones having this issue?

Code: Select all

--> Processing Dependency: any-php-sqlite2 for package: sb-publish
--> Processing Dependency: php-pdo for package: php-mysql
--> Restarting Dependency Resolution with new changes.
--> Populating transaction set with selected packages. Please wait.
---> Package php-mysql.i386 0:5.2.8-1.el4.art set to be erased
---> Package sb-publish.noarch 0:3.0.1-200610111446 set to be erased
--> Running transaction check
--> Processing Dependency: php-mysql for package: psa-php4-configurator
--> Restarting Dependency Resolution with new changes.
--> Populating transaction set with selected packages. Please wait.
---> Package psa-php4-configurator.noarch 0:1.4.0-cos4.build86080722.02 set to be erased
--> Running transaction check
--> Processing Dependency: psa-php-configurator >= 1.4.0 for package: psa
--> Restarting Dependency Resolution with new changes.
--> Populating transaction set with selected packages. Please wait.
---> Package psa.i586 0:8.6.0-cos4.build86080722.02 set to be erased
--> Running transaction check
--> Processing Dependency: psa = 8.6.0 for package: psa-api
--> Processing Dependency: psa = 8.6.0 for package: psa-backup-manager
--> Processing Dependency: psa for package: asl-web-gui
--> Processing Dependency: psa >= 8.0.0 for package: psa-horde
--> Processing Dependency: /usr/local/psa/admin/bin/php for package: psa-api-rpc
--> Processing Dependency: psa >= 8.0.0 for package: psa-horde
--> Processing Dependency: /usr/local/psa/admin/bin/php for package: psa-api
--> Processing Dependency: psa = 8.6.0 for package: psa-api-rpc
--> Processing Dependency: psa >= 8.6.0 for package: psa-tomcat-configurator
--> Processing Dependency: psa >= 7.5.3 for package: psa-turba
--> Processing Dependency: psa >= 8.0.0 for package: psa-horde
--> Processing Dependency: psa >= 8.6.0 for package: psa-awstats-configurator
--> Processing Dependency: psa >= 8.0.0 for package: psa-libpam-plesk
--> Processing Dependency: psa for package: atomic-yum
--> Processing Dependency: psa >= 8.6.0 for package: SSHTerm
--> Processing Dependency: psa = 8.6.0 for package: psa-migration-manager
--> Restarting Dependency Resolution with new changes.
--> Populating transaction set with selected packages. Please wait.
---> Package atomic-yum.noarch 0:0.4-3.el4.art set to be erased
---> Package psa-horde.noarch 0:3.1.3-cos4.build81070322.16 set to be erased
---> Package psa-migration-manager.i586 0:8.6.0-cos4.build86080930.08 set to be erased
---> Package psa-api-rpc.noarch 0:8.6.0-cos4.build86080930.08 set to be erased
---> Package psa-horde.noarch 0:3.1.5-cos4.build83071218.20 set to be erased
---> Package psa-backup-manager.i586 0:8.6.0-cos4.build86080930.08 set to be erased
---> Package SSHTerm.noarch 0:0.2.2-cos4.build86080722.02 set to be erased
---> Package asl-web-gui.noarch 0:1.0.3-2.el4.art set to be erased
---> Package psa-libpam-plesk.i586 0:8.6.0-cos4.build86080722.02 set to be erased
---> Package psa-horde.noarch 0:3.1.7-cos4.build86080722.02 set to be erased
---> Package psa-turba.noarch 0:2.1.7-cos4.build86080722.02 set to be erased
---> Package psa-awstats-configurator.noarch 0:1.0.0-cos4.build86080722.02 set to be erased
---> Package psa-tomcat-configurator.noarch 0:8.6.0-cos4.build86080722.02 set to be erased
---> Package psa-api.noarch 0:8.6.0-cos4.build86080930.08 set to be erased
--> Running transaction check
--> Processing Dependency: psa-horde for package: psa-imp
--> Processing Dependency: psa-horde for package: psa-mnemo
--> Processing Dependency: psa-horde >= 3 for package: psa-kronolith
--> Restarting Dependency Resolution with new changes.
--> Populating transaction set with selected packages. Please wait.
---> Package psa-mnemo.noarch 0:2.1.2-cos4.build86080722.02 set to be erased
---> Package psa-kronolith.noarch 0:2.1.8-1.el4.art set to be erased
---> Package psa-imp.noarch 0:4.1.6-cos4.build86080722.02 set to be erased
--> Running transaction check
--> Processing Dependency: psa-imp for package: psa-ingo
--> Processing Dependency: psa-imp for package: psa-mimp
--> Processing Dependency: psa-imp for package: psa-passwd
--> Restarting Dependency Resolution with new changes.
--> Populating transaction set with selected packages. Please wait.
---> Package psa-passwd.noarch 0:3.0.1-cos4.build86080722.02 set to be erased
---> Package psa-ingo.noarch 0:1.1.5-cos4.build86080722.02 set to be erased
---> Package psa-mimp.noarch 0:1.0.2-cos4.build86080722.02 set to be erased
--> Running transaction check




Dependencies Resolved

=============================================================================
 Package                 Arch       Version          Repository        Size
=============================================================================
Removing:
 php-pdo                 i386       5.2.8-1.el4.art  installed         107 k
Removing for dependencies:
 SSHTerm                 noarch     0.2.2-cos4.build86080722.02  installed         4.9 M
 asl-web-gui             noarch     1.0.3-2.el4.art  installed         254 k
 atomic-yum              noarch     0.4-3.el4.art    installed         715 k
 php-mysql               i386       5.2.8-1.el4.art  installed         156 k
 psa                     i586       8.6.0-cos4.build86080722.02  installed          52 M
 psa-api                 noarch     8.6.0-cos4.build86080930.08  installed         4.3 M
 psa-api-rpc             noarch     8.6.0-cos4.build86080930.08  installed         1.2 M
 psa-awstats-configurator  noarch     1.0.0-cos4.build86080722.02  installed          0.0
 psa-backup-manager      i586       8.6.0-cos4.build86080930.08  installed         675 k
 psa-horde               noarch     3.1.7-cos4.build86080722.02  installed          14 M
 psa-horde               noarch     3.1.5-cos4.build83071218.20  installed          23 M
 psa-horde               noarch     3.1.3-cos4.build81070322.16  installed          23 M
 psa-imp                 noarch     4.1.6-cos4.build86080722.02  installed         8.4 M
 psa-ingo                noarch     1.1.5-cos4.build86080722.02  installed         3.5 M
 psa-kronolith           noarch     2.1.8-1.el4.art  installed         8.8 M
 psa-libpam-plesk        i586       8.6.0-cos4.build86080722.02  installed         146 k
 psa-migration-manager   i586       8.6.0-cos4.build86080930.08  installed         7.6 M
 psa-mimp                noarch     1.0.2-cos4.build86080722.02  installed         1.8 M
 psa-mnemo               noarch     2.1.2-cos4.build86080722.02  installed         2.9 M
 psa-passwd              noarch     3.0.1-cos4.build86080722.02  installed         3.0 M
 psa-php4-configurator   noarch     1.4.0-cos4.build86080722.02  installed          0.0
 psa-tomcat-configurator  noarch     8.6.0-cos4.build86080722.02  installed          0.0
 psa-turba               noarch     2.1.7-cos4.build86080722.02  installed         4.1 M
 sb-publish              noarch     3.0.1-200610111446  installed          0.0

Transaction Summary
=============================================================================
Install      0 Package(s)
Update       0 Package(s)
Remove      25 Package(s)
Total download size: 0
Is this ok [y/N]:

See above deps on removal of sqlite2...it's deep in psa unfortunately

BerArt · Unread post by **BerArt** » Wed Jan 07, 2009 12:23 pm

I have the same problem, but sitebuilder is NOT running, and howcome PHP 5.2.8.-1 was/is not having this problem. Wil it be solved in PHP 5.2.8-4?

Unread post by **scott** » Wed Jan 07, 2009 12:24 pm

What parts of it are installed? I cant duplicate it here because Ive never had it installed