Howto:Building #php 5.3.x Firebird driver (php_interbase.dll) with #VC9

I have finished my guide to build the Firebird (2.5) driver for php 5.3
I have spend two weekends but the results are great now anyone can build and compile
Firebird 2.5 from source on any windows machine and anyone can build a driver for php 5.3.x and greater after that.
Rebuilding of Firebird 2.5 is not normally necesarry for normal mortals but is necesarry so that firebird driver to be included in the main build scripts and testing machines for php.net

ps: it's a tinny dll but it took some hours to make it work (~two weekends) and in that time i have created also the firebird 2.5 compilation movie on windows
How can you show me support ? you can donate for firebird fundation and that would make me happy (core developers will be happy and they will work to squish the bugs in the core and drivers but that doesn't meat that is the only contribution you can do: there are other ways : spread the word about firebird 2.5 release  , fix/triage some bugs , write some documentation  , blog about firebird ...)
also you can test and comment if there are any errors in the steps
ps: i will try to revive my mingw firebird compilation guide and i will add the php instructions too
I'm sorry that php core develpers are NOT using the very good mingw compiler and that they are using and persuading the usage of visual studio from ... Microsoft ...doh

Installing jaws #php #cms on #ubuntu lucid and #firebird backend

This is tutorial on how to install  jaws-cms on ubuntu and with firebird 2.1 backend

cd /var/www
sudo wget http://bits.jaws-project.com/releases/jaws-0.8.13/jaws-complete-0.8.13.tar.gz
sudo tar -zxvf jaws-complete-0.8.13.tar.gz
sudo mv html jaws

sudo chmod -R g+rw jaws
sudo chown -R www-data.www-data jaws

create an new database with flamerobin /var/lib/firebird/2.1/data/jaws.fdb

create a symlink , seems that if you put only jaws.fdb in the database field
then it needs to be located in jaws/data

cd /var/www/jaws/data
ln -s  /var/lib/firebird/2.1/data/jaws.fdb

start the installer http://localhost/jaws/install/
fill in the username for database and password
at database put jaws.fdb
Some screenshots created during the install process

All requirements are OK check the green results field
Also for php gd i had to install it this way

sudo apt-get install php5-gd

and for firebird php driver
check if is installed with

sudo apt-get install php5-interbase

and then restart the apache server so that php driver to be really loaded after install

sudo /etc/init.d/apache2 restart

and here is the administration area that you can access with
http://localhost/jaws/admin

If you play with the gadgets and add them to the Layout area in a few seconds you have a blog, rss feed (i have added firebirdnews rss feed) and visitor count and then a search box
So a community style of site can be created in a few steps and it's very easy to start it

I was reading sed tutorials over the net and I almost forgot about sed -i option
to replace and save the file in the same time

http://spiralbound.net/2007/12/12/php-and-sed-for-string-substitution

I need it to replace some files , maybe it could be done in php more elegant
but later

also json_encode and decode function are really fun
for me , I have an . file where I save the values in json format and then get them in array format
for php

Experimental fastcgi process manager code tests

Benchmark on a 256mb xen vps:
apache2+mod_php+xcache = 42 req/sec
nginx+xcache+php-fpm = 150 req/sec

NginX and PHP will be compiled from Source as these are softwares with a very fast development, and pre-compiled packages are often prehistoric and are not suitable to apply custom patches (like php-Fpm).

http://www.yawn.it/2008/04/30/nginx-php-php-fpm-on-debian-etch-40/

Another article with fastcgi load balancing

To configure Nginx to load balance multiple FastCgi servers use this type of configuration

And the last line said something about php-fpm - it's first time i heard about it

If you’re using spawn-fcgi from lighttpd consider replacing it with php-fpm.
[ED: i will do it soon and got a new acronym derived from the LEMP stack


FLEPS stack (Firebird ,Linux, EngineX,PHP,SSH/SSL)]

ffmpeg + mplayer + mencoder script for fedora/centos or any linux host (debian / ubuntu )

needed for this php class where generic install is described bellow

also is now added to google code

http://code.google.com/p/build-ffmpeg/source/checkout



#1 get som prerequizite

#. On Fedora.Centos
# yum install ruby subversion gcc

apt-get install ruby subversion gcc git-core automake unzip



#2.Get faad2 (here are some details)
#http://packages.ubuntu.com/source/intrepid/faad2
wget http://archive.ubuntu.com/ubuntu/pool/universe/f/faad2/faad2_2.6.1.orig.tar.gz
tar -zxvf faad2_2.6.1.orig.tar.gz
cd faad2
./bootstrap
./configure --prefix=/usr;make;make install ;cd ..

#3.Get liba52 - a free ATSC A/52 stream decoder
#http://liba52.sourceforge.net/


wget http://liba52.sourceforge.net/files/a52dec-0.7.4.tar.gz
tar -zxvf a52dec-0.7.4.tar.gz
cd a52dec-0.7.4
./configure --prefix=/usr;make;make install ;cd ..

#4.Get libgsm http://packages.qa.debian.org/libg/libgsm.html

wget http://ftp.debian.org/debian/pool/main/libg/libgsm/libgsm_1.0.12.orig.tar.gz
tar -zxf libgsm_1.0.12.orig.tar.gz
cd gsm-1.0-pl12
./configure --prefix=/usr;make;make install ;cd ..

#5.Get Faac

wget http://surfnet.dl.sourceforge.net/sourceforge/faac/faac-1.26.tar.gz
tar -zxf faac-1.26.tar.gz
cd faac
./bootstrap
./configure --prefix=/usr;make;make install ;cd ..


#6.Get Lame
wget http://mesh.dl.sourceforge.net/sourceforge/lame/lame-3.97.tar.gz
tar -zxf lame-3.97.tar.gz
cd lame-3.97
./configure --prefix=/usr;make;make install;cd ..

#7.Get xvidcore
wget http://downloads.xvid.org/downloads/xvidcore-1.1.3.tar.bz2
tar -jxf xvidcore-1.1.3.tar.bz2
cd xvidcore-1.1.3/build/generic/
./configure --prefix=/usr;make;make install
cd ../../../


#8.From http://www.penguin.cz/~utx/amr download amrnb-7.0.0.2.tar.bz2 and amrwb-7.0.0.3.tar.bz2

wget http://ftp.penguin.cz/pub/users/utx/amr/amrnb-7.0.0.2.tar.bz2
wget http://ftp.penguin.cz/pub/users/utx/amr/amrwb-7.0.0.3.tar.bz2
tar -jxvf amrwb-7.0.0.3.tar.bz2
cd amrwb-7.0.0.3
./configure --prefix=/usr;make;make install;cd ..
tar -jxvf amrnb-7.0.0.2.tar.bz2
cd amrnb-7.0.0.2
./configure --prefix=/usr;make;make install;cd ..

#9.Get theora from here http://theora.org/svn/

svn co http://svn.xiph.org/trunk/theora
cd theora
./autogen.sh
./configure --prefix=/usr;make;make install;cd ..


#10.GEt x264 from here http://www.videolan.org/developers/x264.html

wget ftp://ftp.videolan.org/pub/videolan/x264/snapshots/x264-snapshot-20080625-2245.tar.bz2
tar -jxvf x264-snapshot-20080625-2245.tar.bz2
cd x264-snapshot-20080625-2245
./configure --prefix=/usr --disable-asm --enable-pic ;make ;make install
cd ..


#11.Finally ffmpeg from svn trunk

svn checkout svn://svn.mplayerhq.hu/ffmpeg/trunk ffmpeg
cd ffmpeg
./configure --prefix=/usr --enable-libamr-nb --enable-libamr-wb --enable-libvorbis --enable-libxvid --enable-liba52 --enable-libmp3lame --enable-libx264 --enable-libtheora --enable-libfaad --enable-gpl --enable-shared --enable-pthreads --enable-libfaac --enable-nonfree --enable-postproc
make ; make install; cd ..


#Needed for extension after php5-dev is installed
#http://ffmpeg-php.sourceforge.net/
#12.Get ffmpeg-php


wget http://dfn.dl.sourceforge.net/sourceforge/ffmpeg-php/ffmpeg-php-0.5.3.1.tbz2
tar -jxvf ffmpeg-php-0.5.3.1.tbz2
cd ffmpeg-php-0.5.3.1

phpize
./configure;make ; make install

#and enable it in php.ini
#echo 'extension=/usr/local/lib/php/extensions/ no-debug-non-zts-20020429/ffmpeg.so' >> /usr/local/Zend/etc/php.ini
#Restart Apache to load FFMPEG-PHP (Depends on OS, this is for RHEL/CentOS)
#service httpd restart

#Verify if it works

php -r 'phpinfo();' | grep ffmpeg



#13.Get mplayer

wget http://www2.mplayerhq.hu/MPlayer/releases/MPlayer-1.0rc2.tar.bz2
wget http://www2.mplayerhq.hu/MPlayer/releases/codecs/essential-20061022.tar.bz2
tar -jxvf essential-20061022.tar.bz2
tar -jxvf MPlayer-1.0rc2.tar.bz2

mkdir -p /usr/lib/codecs/
cd essential-20061022
mv * /usr/lib/codecs/
cd ..
cd MPlayer-1.0rc2/
./configure --prefix=/usr
make; make install;cd ..

#14.Get flvtool2

wget http://rubyforge.org/frs/download.php/17497/flvtool2-1.0.6.tgz
tar -zxvf flvtool2-1.0.6.tgz
cd flvtool2-1.0.6

ruby setup.rb config
ruby setup.rb setup
ruby setup.rb install
cd ..

i agree with this article that is simpler to write hello world in php than using mod_perl

<?php
echo "goodbye world";
?>

Than installing modperl and configure-ing the app (I'm working as sys admin)
maybe simple_mod_perl should interpret all *.pl and after that an use an templating system
<?perl
say "goodbye world";
?>