View unanswered posts | View active topics It is currently Sun Sep 22, 2019 8:49 pm



Post new topic Reply to topic  [ 13 posts ]  Go to page Previous  1, 2
 Trouble with apache config on Fedora 
Author Message

Joined: Mon Jan 25, 2010 4:55 am
Posts: 11
Reply with quote
Post [Solved] Re: Trouble with apache config on Fedora
Well.... after 3 days of trial and error I managed to get the xplico interface functioning...

php-pdo in Fedora does not include support for sqlite v2 databases, only v3. Sqlite v2 support is included in php5+ but on Fedora php is compiled '--without-sqlite'. Instead of recompiling the whole of php I have just added the sqlite module as per the long-winded instructions below:

******************************************************
Download php-sqlite-1.0.2-3.rf.src.rpm from Dag Wiers

Install it

cd ~/rpmbuild/SOURCES
extract SQLite-1.0.2.tgz
cd SQLite-1.0.2

Instructions below borrowed from: http://www.phpbuilder.com/board/showthr ... t=10307306
-------------------------------------------
Edit sqlite.c, comment out the following line:

Code:
/* static unsigned char arg3_force_ref[] = {3, BYREF_NONE, BYREF_NONE, BYREF_FORCE }; */

And then change these lines:
function_entry sqlite_functions[] = {
PHP_FE(sqlite_open, arg3_force_ref)
PHP_FE(sqlite_popen, arg3_force_ref)

to:
function_entry sqlite_functions[] = {
PHP_FE(sqlite_open, third_arg_force_ref)
PHP_FE(sqlite_popen, third_arg_force_ref)

------------------------------------------------------------
cd ~/rpmbuild/SOURCES
tar czvf SQLite-1.0.2.tgz SQLite-1.0.2

Edit ~/rpmbuild/SPECS/php-sqlite.spec
Replace:
%{__install} -Dp -m0755 sqlite.so %{buildroot}%{libdir}/php4/sqlite.so

with:
%{__install} -Dp -m0755 sqlite.so %{buildroot}%{libdir}/php/sqlite.so

and:
%{libdir}/php4/*.so

with
%{libdir}/php/*.so

rpmbuild -ba SPECS/php-sqlite.spec

Install the resulting binary rpm

# add sqlite extension to php
cat << EOF > /etc/php.d/sqlite.ini
extension=sqlite.so
EOF
******************************************************

In any event, once the new xplico version comes out with a sqlite3 format db this will no longer be required.

I have packaged up (rpm) xplico with GeoIP and pcl included if anyone is interested, but due to this messy situation I'll wait for the next xplico version before making it available.

Thanks for all your assistance, looking forward to 0.5.5

cheers

killboy


Wed Jan 27, 2010 7:39 am
Profile

Joined: Wed Sep 16, 2009 10:45 pm
Posts: 128
Reply with quote
Post Re: Trouble with apache config on Fedora
Ok, thank you, we will look forward you when 0.5.5 is finished.
Thanks again.


Wed Jan 27, 2010 11:54 am
Profile

Joined: Mon Jan 25, 2010 4:55 am
Posts: 11
Reply with quote
Post Re: Trouble with apache config on Fedora
Update: If anyone is attempting to follow the procedure in my last post, it doesn't work on Fed 12, I had to download php source rpm, modify and rebuild to generate the php-sqlite rpm

<edit>moved to suggestions</edit>

cheers


Wed Jan 27, 2010 11:50 pm
Profile
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 13 posts ]  Go to page Previous  1, 2


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by Vjacheslav Trushkin for Free Forums/DivisionCore.