Subject RE: [firebird-php] Compiling php_interbase.so on Suse Linux Enterprise 9 Opteron
Author Alan McDonald
these steps worked for me
These are steps to make PHP under Mandrake 10 aware of

Firebird 1.03.

My test machine is an i586 so I can't test for Firebird 1.5

1.- Install Mandrake 10 with Apache 2 and PHP included on

the installation disks.

2.- After the installtion completes install Firebird as

root

# rpm -Uvh FirebirdSS-1.0.3.972-0.i386.rpm

3.- Download the source code of PHP (php-4.3.5.tar.bz2)

4.- Extract the source code to any directory. For example

/home/someuser

5.- Go to the above diectory

# cd /home/someuser/php-4.3.5

6.- Compile PHP for interbase/firebird support

# ./configure --with-interbase=shared,/opt/interbase

# make

This steps generates the interbase.so library in

/home/someuser/php-4.3.5/modules

7.- Copy the interbase.so to /usr/lib/php4

# cp modules/interbase.so /usr/lib/php4

8.- Go to /etc/php and create the file interbase.ini

# cd /etc/php

# touch interbase.ini

9.- Add this line to interbase.ini:

extension=interbase.so

10.- Start or (Restart - if it running) Apache Server

# service httpd start

or

# service httpd restart

11.- To test use the following script:

<?

$coonection =

ibase_connect("localhost:/opt/interbase/examples/employee.gdb",\

"sysdba","masterkey"); //this in one line

$sql = "select * from customer";

$res = ibase_query($sql);

while ($row = ibase_fetch_row($res)) {

echo $row[0].' '.$row[1].'<br />';

}

?>

12.- Save the script in /var/www/html as fbtest.php

13.- Run the script in the web navigator by navigating to:

http://yourmandrakeserver.xxx/test.php

NOTES:

Steps 3, 4, 5 an 6 could be replaced with just one step

("download interbase.so from..." ). Perhaps IBPhoenix or

FirebirdSQL would agree to place the file (interbase.so -

about 128KB) in the download area? Or maybe there is even

someone who could produce and rpm to set up FB for PHP. I

saw a rpm like that for RH 7.x but making one myself is way

above my head at this point.

Alan

(from darius)

-----Original Message-----
From: Ian Wilson [mailto:ijwilson@...]
Sent: Friday, February 11, 2005 6:48 PM
To: firebird-php@yahoogroups.com
Subject: [firebird-php] Compiling php_interbase.so on Suse Linux
Enterprise 9 Opteron


Hello all,

Usually either the version of php just flat doesn't compile the
php_interbase.so or I am missing some obvious step. I think it could also
be
that I am using dual AMD opteron processors.

So I have tried php-4.3.10 and php-4.3.4(<-- the last version I got to
work)
with FirebirdCS-1.5.2.4731-0.(as well as FirebirdCS-1.0.3.972-0.64IO)

--output from ./configu_database in -lib_util... no
configure: error: libgdre --with-interbase=shared,/opt/firebird
checking for InterBase support... yes, shared
checking for isc_detach_database in -lgds... no
checking for isc_detach_database in -lib_util... no
configure: error: libgds or libib_util not found! Check config.log for
more
information.
--
I have the libraries libgds.so in /lib/libgds.so and /usr/lib/libgds.so
and libib_util.so in /lib/libib_util.so and /usr/lib/libib_util.so


In the config.log there are these lines....

configure:42587: gcc -o conftest -g -O2 -Wl,-rpath,/opt/firebird/lib
-L/opt/firebird/lib conftest.c -lgds -lresolv -lm -ldl -lnsl 1>&5

/usr/lib64/gcc-lib/x86_64-suse-linux/3.3.3/../../../../x86_64-suse-linux/bin
/ld:
skipping incompatible /lib/libgds.so when searching for -lgds

/usr/lib64/gcc-lib/x86_64-suse-linux/3.3.3/../../../../x86_64-suse-linux/bin
/ld:
skipping incompatible /usr/lib/libgds.so when searching for -lgds

/usr/lib64/gcc-lib/x86_64-suse-linux/3.3.3/../../../../x86_64-suse-linux/bin
/ld:
cannot find -lgds


So...as it seems it is finding the libraries I don't know what to do from
here?

Thanks in advance.

-Ian

Yahoo! Groups Sponsor
ADVERTISEMENT





----------------------------------------------------------------------------
--
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-php/

b.. To unsubscribe from this group, send an email to:
firebird-php-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]