Friday, March 14, 2014

php5 and firebird pdo on ubuntu / debian

The recommendd method is to use the official php5 source from ubuntu or debian and build only the pdo firebird extension and install it
sudo apt-get install php5-dev firebird2.5-dev php-pear devscripts debget

You need to build the pdo extension from php from ubuntu source code here is the source for php package (apt-get source will do the job for any release)
apt-get source php5
cd php5-*
cd ext/pdo_firebird
phpize
sudo ln -s /usr/include/php5 /usr/include/php
./configure
make
sudo make install 

Check to have in php.ini to have the next lines also with phpinfo() function

sudo pico/vi /etc/php5/conf.d/pdo.ini
# configuration for php PDO module
extension=pdo.so
extension=pdo_firebird.so


php -i | grep PDO
PDO
PDO support => enabled
PDO drivers => firebird
PDO_Firebird
PDO Driver for Firebird/InterBase => enabled

you can also check in apache if all is correct
by creating a page in /var/www/pdo_info.php
with this content



then in the browser press F3 and search PDO
to check if all is ok with the driver then create one small example that loads the driver and then is connecting to the database server



after the driver is loaded now you can use the pdo as usual , here is the fetch example

7 comments:

  1. Is there a way to set transaction isolation in firebird pdo? Thanks.

    ReplyDelete
  2. Incredible useful! some years later.. didn't know about apt-get source (:

    thanks

    ReplyDelete
  3. hi, how can i enable it for mac??

    ReplyDelete
  4. how did you installed on mac , usuall if is a binary package you need to search howto compile the firebird pdo extension only

    usually you go to the same php source version like the binary in the pdo firebird folder , execute phpize and then configure make , make install

    also you can ask on firebird-php list

    http://tech.groups.yahoo.com/group/firebird-php/

    ReplyDelete
  5. Very useful, Thanks a lot

    ReplyDelete
  6. Why is the bug of "https://bugs.php.net/bug.php?id=60052" not revised for a long term?
    For my program, this bug is fatal.
    Therefore PDO is not available.

    I cannot use many frameworks and libraries depending on PDO

    In addition, many bugs seem to be left elsewhere.

    ReplyDelete
  7. I will check the patch correctness

    There are a few bugs open but i need to check and verify if the patch or solutions are correct (debug and tests)

    ReplyDelete