php upgrade 5.2.8 and sqlite2 dependencies

[bartje333]

Hi,

Thanks for putting php-sqlite2 into the repo, but it doesnt work for some 64bit distro's (Centos5 in my case).
Reason: http://kb.parallels.com/en/5460

If publication host has x86_64 architecture it is suggested to use source files from here http://cvs.php.net/viewvc.cgi/pecl/sqli ... ev=PHP_5_2 and make sure that SQLite library has version 2.8.17 or upper.

The once you use is from SQLite-1.0.3.tgz tarball, I could see this in your spec file. You could use the once which is already in the official php 5.2 package /ext/sqlite or the official php-cvs package. They both have already an updated sqlite extension from the cvs.

Greetings,
Bart

[scott]

or *you* could do that and send me a patch.

[zooming]

I had this problem before, solved by Paralells with a compiled sqlite.so:
http://forum.parallels.com/showthread.php?t=85104

[groenman]

Hello,

I am having the same issue... cannot upgrade PHP to the latest version available from the atomic repos.

Error: Missing Dependency: php <= 5.2.0 is needed by package php-sqlite2-5.1.6-200705230938.i386 (installed)

I've tried removing sb-publish and then upgrading PHP but no use... it seems php-sqlite has been removed from the atomic repo? Strangely enough, another server has it installed and it definitely was in the repo (php-sqlite2-5.2.9-1.el5.art).

Installed Packages
Name : php-sqlite2
Arch : i386
Version : 5.2.9
Release : 1.el5.art
Size : 329 k
Repo : installed
Summary : Advanced protection system for PHP installations
URL : http://www.php.net
License : PHP License
Description: Sqlite2 module for php

Both servers running CentOS 5.3

Any advice appreciated!

[groenman]

If anyone else has the same issue, you can fix it yourself;

1.) Remove php-sqlite2 & sb-publish
2.) Upgrade rest of PHP to latest using arts repo
3.) Grab art spec file which can be found here: http://3es.atomicrocketturtle.com/packa ... lite2.spec
4.) Grab the SQLite source code as outlined in the spec file
5.) Modify spec file - remove/comment patch section
6.) Read http://kb.parallels.com/en/5460 and make alterations to the SQLite source code - remember to repack the tgz once done
7.) rpmbuild -ba php-sqlite2.spec
8.) Install the new rpm and then sb-publish too

This worked for me, it might not work for you... I take no responsibility if you screw up your server

There are some other dependencies which you will need to install in order to build the rpm... you can safely install them and remove once done.

The sitebuilder check script returns the following which indicates there shouldn't be a problem with publishing;

ioncube=ok
os=
phpVersion=5.2.11
mbstring=ok
zlib=ok
session=ok
dom=ok
domxml_xslt=ok
sqlite=2.8.14
sqliteEncoding=UTF-8
gd_png=ok
gd_gif=ok
gd_jpg=ok
gd_wbmp=ok
gd=2.0.34
mail=ok
curl=ok
serverApi=Apache Handler

[scott]

So basically you just duplicated exactly what the .spec file already did?