Subject | Re: Getting Php to integrate Firebird 1.5 |
---|---|
Author | David at PFI |
Post date | 2005-01-15T18:13:26Z |
--- In firebird-php@yahoogroups.com, Todd Cary <todd@a...> wrote:
work with php,apache,linux below is what worked for me. I do however
use a 'package' that has apache and php already configured. I use it
on all our production boxes (with some security tweaks of course) and
testing systems. see www.apachefriends.org
download latest xampp-linux-1.X.X.tar.gz from above.
download latest xampp-linux-devel-1.X.X.tar.gz from above
download latest php-4.3.X.tar.gz from php.net
download FirebirdSS-NPTL.XX.rpm ****USE THE NPTL BUILD IF USING ANY
POSIX DISTRIBUTION LIKE RH9, MANDRAKE 9/10 Fedora ETC.*****
I find the SS version of Firebird easier to work with. The only
reason to use the CS version is if you *really* intend to work on a
multiprocessor system.
Php is only necessary to perform the recompile. Xampp php is the one
used in the final product below.
Note that the below will build you a devel or production system from
scratch. If you already have Firebird running just skip that step.
If you run apache/php already then just perform the recompile and
replace all the references to /opt/lampp with wherever php/apache
exists on your system. I use VMware extensively to save headache.
Although I use Fedora as my host, I keep Redhat as the guest OS as
VMware is a little sketchy running Fedora as a guest. Remember that
your RH or whatever build should include the kernel development and
software development packages or the make and make install will fail.
Hope this works for you!
[code]----------------------------------------------------------------
;;using Redhat 9.0
su root
tar xvfz xampp-linux-1.4.9a.tar.gz -C /opt
tar xvfz xampp-linux-devel-1.4.9.tar.gz -C /opt
rpm -ivh FirebirdSS*.rpm (1.5.1.4481-0 or 1.5.2.4731-0)**or NPTL
build??**
ln -s /opt/firebird /opt/interbase
;;;[this is because the default install directory for ver 1.5 is
/opt/firebird]
/opt/firebird/bin/gsec
modify sysdba -pw yournewpasswordhere
;;that step is important as the default SYSDBA 'masterkey' password
;;on Firebird is very well known.
quit
tar zxf php-4.3.9.tar.gz
cd php*
;;i recommend copying all the below into the prompt if you use putty
;;etc. unless you like typing.
CFLAGS="-I/opt/lampp/include/libpng -I/opt/lampp/include/ncurses
-I/opt/lampp/include -L/opt/lampp/lib" \
./configure --prefix=/opt/lampp --with-apxs2=/opt/lampp/bin/apxs
--with-config-file-path=/opt/lampp/etc \
--with-mysql=/opt/lampp --disable-debug --enable-bcmath
--enable-calendar --enable-ctype --enable-dbase \
--enable-discard-path --enable-exif --enable-filepro
--enable-force-cgi-redirect --enable-ftp \
--enable-gd-imgstrttf --enable-gd-native-ttf --with-ttf
--enable-magic-quotes --enable-memory-limit \
--enable-safe-mode --enable-shmop --enable-sigchild --enable-sysvsem
--enable-sysvshm --enable-track-vars \
--enable-trans-sid --enable-versioning --enable-wddx --enable-yp
--with-ftp --with-gdbm=/opt/lampp \
--with-jpeg-dir=/opt/lampp --with-png-dir=/opt/lampp
--with-tiff-dir=/opt/lampp --with-freetype-dir=/opt/lampp \
--without-xpm --with-zlib=yes --with-zlib-dir=/opt/lampp
--with-openssl=/opt/lampp --with-expat-dir=/opt/lampp \
--enable-xslt --with-xslt-sablot=/opt/lampp -with-ming=/opt/lampp
--with-dom=/opt/lampp --with-ldap=/opt/lampp \
--with-ncurses=/opt/lampp --with-gd --with-imap-dir=/opt/lampp
--with-imap-ssl --with-imap=/opt/lampp \
--with-gettext=/opt/lampp
--with-mysql-sock=/opt/lampp/var/mysql/mysql.sock
--with-mcrypt=/opt/lampp \
--with-mhash=/opt/lampp --enable-sockets --enable-mbstring=all
--with-curl=/opt/lampp --enable-mbregex \
--enable-zend-multibyte --with-zip=/opt/lampp --enable-exif
--with-bz2=/opt/lampp --with-interbase=shared,/opt/interbase
make && make install
vi /opt/lampp/etc/php.ini
;; turn sybase magic quotes=On and
;; add/uncomment extension="interbase.so"
[/code]-------------------------------------------------------
> I have compiled interbase.so, but even though I haveHi Todd. For the assistance of anyone who has tryed to make Firebird
>
> extension=interbase.so
>
> in the php.ini file, it is not part of PHP. Has anyone had success
> doing this?
>
> Todd
work with php,apache,linux below is what worked for me. I do however
use a 'package' that has apache and php already configured. I use it
on all our production boxes (with some security tweaks of course) and
testing systems. see www.apachefriends.org
download latest xampp-linux-1.X.X.tar.gz from above.
download latest xampp-linux-devel-1.X.X.tar.gz from above
download latest php-4.3.X.tar.gz from php.net
download FirebirdSS-NPTL.XX.rpm ****USE THE NPTL BUILD IF USING ANY
POSIX DISTRIBUTION LIKE RH9, MANDRAKE 9/10 Fedora ETC.*****
I find the SS version of Firebird easier to work with. The only
reason to use the CS version is if you *really* intend to work on a
multiprocessor system.
Php is only necessary to perform the recompile. Xampp php is the one
used in the final product below.
Note that the below will build you a devel or production system from
scratch. If you already have Firebird running just skip that step.
If you run apache/php already then just perform the recompile and
replace all the references to /opt/lampp with wherever php/apache
exists on your system. I use VMware extensively to save headache.
Although I use Fedora as my host, I keep Redhat as the guest OS as
VMware is a little sketchy running Fedora as a guest. Remember that
your RH or whatever build should include the kernel development and
software development packages or the make and make install will fail.
Hope this works for you!
[code]----------------------------------------------------------------
;;using Redhat 9.0
su root
tar xvfz xampp-linux-1.4.9a.tar.gz -C /opt
tar xvfz xampp-linux-devel-1.4.9.tar.gz -C /opt
rpm -ivh FirebirdSS*.rpm (1.5.1.4481-0 or 1.5.2.4731-0)**or NPTL
build??**
ln -s /opt/firebird /opt/interbase
;;;[this is because the default install directory for ver 1.5 is
/opt/firebird]
/opt/firebird/bin/gsec
modify sysdba -pw yournewpasswordhere
;;that step is important as the default SYSDBA 'masterkey' password
;;on Firebird is very well known.
quit
tar zxf php-4.3.9.tar.gz
cd php*
;;i recommend copying all the below into the prompt if you use putty
;;etc. unless you like typing.
CFLAGS="-I/opt/lampp/include/libpng -I/opt/lampp/include/ncurses
-I/opt/lampp/include -L/opt/lampp/lib" \
./configure --prefix=/opt/lampp --with-apxs2=/opt/lampp/bin/apxs
--with-config-file-path=/opt/lampp/etc \
--with-mysql=/opt/lampp --disable-debug --enable-bcmath
--enable-calendar --enable-ctype --enable-dbase \
--enable-discard-path --enable-exif --enable-filepro
--enable-force-cgi-redirect --enable-ftp \
--enable-gd-imgstrttf --enable-gd-native-ttf --with-ttf
--enable-magic-quotes --enable-memory-limit \
--enable-safe-mode --enable-shmop --enable-sigchild --enable-sysvsem
--enable-sysvshm --enable-track-vars \
--enable-trans-sid --enable-versioning --enable-wddx --enable-yp
--with-ftp --with-gdbm=/opt/lampp \
--with-jpeg-dir=/opt/lampp --with-png-dir=/opt/lampp
--with-tiff-dir=/opt/lampp --with-freetype-dir=/opt/lampp \
--without-xpm --with-zlib=yes --with-zlib-dir=/opt/lampp
--with-openssl=/opt/lampp --with-expat-dir=/opt/lampp \
--enable-xslt --with-xslt-sablot=/opt/lampp -with-ming=/opt/lampp
--with-dom=/opt/lampp --with-ldap=/opt/lampp \
--with-ncurses=/opt/lampp --with-gd --with-imap-dir=/opt/lampp
--with-imap-ssl --with-imap=/opt/lampp \
--with-gettext=/opt/lampp
--with-mysql-sock=/opt/lampp/var/mysql/mysql.sock
--with-mcrypt=/opt/lampp \
--with-mhash=/opt/lampp --enable-sockets --enable-mbstring=all
--with-curl=/opt/lampp --enable-mbregex \
--enable-zend-multibyte --with-zip=/opt/lampp --enable-exif
--with-bz2=/opt/lampp --with-interbase=shared,/opt/interbase
make && make install
vi /opt/lampp/etc/php.ini
;; turn sybase magic quotes=On and
;; add/uncomment extension="interbase.so"
[/code]-------------------------------------------------------