sqlite2 install & php 5.2.8

[wdriver]

sqlite2 install & php 5.2.6

Hi,
I have just purchased Sitebuilder 100 Lease licence and i have SiteBuilder running fine.

But when Publishing (i am publishing on the same server) it says SQLite2 required. I have spent a long time trying to find a solution because when i run:
yum install php-sqlite2
it wants to upgrade from php 5.2.6 to 5.2.8

I am currently running PSA 8.6 and i have read a lot of problems in this forum about running PSA 8.6 & PHP 5.2.8 together.

Does anyone have any suggestions about how to install sqlite2 to run under PSA 8.6 with PHP 5.2.6?

Thanks in Advance
Wayne.

Also, here is my check.php's for both SiteBuilder & the Publishing areas fyi:

---------------------------------------------------------------------------
OK : supported version of PHP found (5.1.X or newer - 5.2.1)
OK : extension sitebuilder3 in state on found
OK : extension pdo in state on found
OK : extension pdo_mysql in state on found
OK : extension sqlite in state on found
OK : extension dom in state on found
OK : extension libxml in state on found
OK : extension xml in state on found
OK : extension xsl in state on found
OK : extension spl in state on found
OK : extension pcre in state on found
OK : extension session in state on found
OK : extension simplexml in state on found
OK : extension ftp in state on found
OK : extension openssl in state on found
OK : extension mbstring in state on found
OK : extension soap in state on found
OK : extension gd in state on found
OK : extension ctype in state on found
OK : extension zlib in state on found
OK : extension iconv in state on found
OK : extension curl in state on found
OK : extension posix in state on found
OK : extension mysql in state on found
OK : supported SQLite version 2.x found
OK : SQLite UTF-8 encoding found
OK : GD library PNG support found
OK : GD library GIF support found
OK : GD library JPG support found
OK : GD library WBMP support found
OK : supported GD library version 2.0.1 (or newer) found
OK : setting magic_quotes_gpc in state off found
OK : setting magic_quotes_runtime in state off found
OK : setting open_basedir in state off found
OK : setting safe_mode in state off found
OK : setting zend.ze1_compatibility_mode in state off found
OK : setting mbstring.internal_encoding in state UTF-8 found
OK : config file was successfully parsed
OK : connection to MySQL database was established
OK : database and code versions are the same
---------------------------------------------------------------------------

---------------------------------------------------------------------------
ioncube=ok os= phpVersion=5.2.6 mbstring=ok zlib=ok session=ok dom=ok domxml_xslt=ok sqlite=fail gd_png=ok gd_gif=ok gd_jpg=ok gd_wbmp=ok gd=2.0.34 mail=ok curl=ok serverApi=Apache Handler
---------------------------------------------------------------------------

 

[Dmitry Frantsev]

You can try to compile sqlite.so extension for existing PHP 5.2.6 installation using the following article: http://kb.odin.com/en/5460.

 

[wdriver]

Hi Dmitry,

Thanks for your prompt answer.
I will have to install php-devel-5.2.6 to complete sqlite. Then it should work.

Next challenge

Wayne.

 

[wdriver]

Hi Dmitry,
I know this isn't really a Parallels related question but do you know where i could get php-devel-5.2.6 for CentOS 4.5? - so i can finish installing SiteBuilder.
Current repos i use are:
4plesk
4psa
atomic
Centos-Base
Centos-Media

or happy to rpm if available - just can't find one anywhere ...

Tks,
Wayne.

 

[Dmitry Frantsev]

You can try to find it somewhere in internet. I found the following package:

www.sourcemirrors.org/scotth/centos/4/php/php-devel-5.2.6-1.i386.rpm

# rpm -qpi php-devel-5.2.6-1.i386.rpm
Name : php-devel Relocations: (not relocatable)
Version : 5.2.6 Vendor: (none)
Release : 1 Build Date: Tue Sep 9 06:02:39 2008
Install Date: (not installed) Build Host: centos4.6.vm.login.com
Group : Development/Libraries Source RPM: php-5.2.6-1.src.rpm
Size : 2818824 License: PHP
Signature : (none)
URL : http://www.php.net/
Summary : Files needed for building PHP extensions
Description :
The php-devel package contains the files needed for building PHP
extensions. If you need to compile your own PHP extensions, you will
need to install this package.

It could probably suit for your needs.

 

[wdriver]

I did find that earlier and have come up with the following:

[root@host1 wayne]# yum install php-devel-5.2.6-1.i386.rpm
Setting up Install Process
Setting up repositories
4PSA 100% |=========================| 1.1 kB 00:00
4PLESK 100% |=========================| 951 B 00:00
update 100% |=========================| 951 B 00:00
base 100% |=========================| 1.1 kB 00:00
atomic 100% |=========================| 951 B 00:00
addons 100% |=========================| 951 B 00:00
extras 100% |=========================| 1.1 kB 00:00
Reading repository metadata in from local files
primary.xml.gz 100% |=========================| 27 kB 00:00
4PSA : ################################################## 79/79
Added 0 new packages, deleted 0 old in 1.47 seconds
Parsing package install arguments
Examining php-devel-5.2.6-1.i386.rpm: php-devel - 5.2.6-1.i386
Marking php-devel-5.2.6-1.i386.rpm to be installed
Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Package php-devel.i386 0:5.2.6-1 set to be updated
--> Running transaction check
--> Processing Dependency: php = 5.2.6-1 for package: php-devel
--> Finished Dependency Resolution
Error: Missing Dependency: php = 5.2.6-1 is needed by package php-devel

which i don't understand because when i run:

[root@host1 wayne]# yum list php
Setting up repositories
Reading repository metadata in from local files
Installed Packages
php.i386 5.2.6-1.el4.art installed
Available Packages
php.i386 5.2.8-3.el4.art atomic

it shows i have 5.2.6-1 installed?

Looked online for a solution to this and can't work out what the remaining dependency is?, have you come across this before? Any ideas?

Tks,
Wayne.

 

[Dmitry Frantsev]

This should be checked on your server environment. You can try to install this php-devel package with '--nodeps' option I guess:

# rpm -Uhv php-devel-5.2.6-1.i386.rpm --nodeps

if you are sure that appropriate PHP version is installed on the server. It should work.

 

[wdriver]

Hi Dmitry,
Thanks for the --nodeps option, I have run your command above and it has installed. I don't know unfortunately to what outcome.

However, i now have a further error where i run:
./configure --with-sqlite --with-php-config=/usr/bin/php-config
from you URL:
http://kb.odin.com/en/5460

and i get the following returned:
checking for egrep... grep -E
checking for a sed that does not truncate output... //bin/sed
checking for gcc... no
checking for cc... no
checking for cc... no
checking for cl... no
configure: error: no acceptable C compiler found in $PATH

I know that if i sit here i will eventually get it installed, but i have already worked on getting sitebuilder up and running for days now. You are part of Parallels and obviously know what you are doing. Are you able to give me a quote please on getting this up and running. It appears from the SiteBuilder check.php files i only need to get sqlite running and job is done.

Tks,
Wayne.