[SOLVED] PHP with Firebird

[evsuser]

Hi guys,

 

If anyone can help me solve this, they are a god in my eyes!

 

I have followed every guide available, and tried every solution given on forums all over the web, and I still cannot come right getting PHP to work with Firebird.

 

I am using Fedora Core 9, Apache 2.2.9, PHP 5.2.5, and Firebird 2.0.0 Classic i686.

 

This is what I did initially, in order, following guides on firebirdsql.org, and am now officialy stuck:

1. Installed Fedora Core 9 with ALL options/add-ons selected.

2. Download, extracted and installed FirebirdCS-2.0.0.12748-0.i686.tar.gz. (it complained about dependencies, which I resolved by running "yum install compat-lib*" in the terminal.)

3. In terminal, ran "yum install xinetd" (necessary for remote Firebird DB access)

4. Stopped and disabled "iptables" service.

5. Started and enabled xinetd service on startup.

6. Checked that httpd service was running and at startup.

7. Disabled SELinux protection.

 

Now, I have a basic php script that attempts to connect to an example DB, and I forever get the error "Fatal error: Call to undefined function ibase_connect() in /var/www/html/test.php on line 22"

Line 22 is: "$res = ibase_connect($dbname, $dbuser, $dbpass) or"

 

PHP cannot process this due to the ibase function not being accessible to it, or something of the sort.

 

I have tried copying the interbase.so file that PHP generates upon compiling with interbase option, to multiple locations, to no avail. I have tried configuring ini and config files to use the .so file, to no avail. I have tried almost 10 different step-by-step guides, using the exact version of each software that they use, to no avail. I have tried solutions on experts-exchange.com too, to no avail. (so much for the "experts" there). In Window$, this whole setup works like a charm.

 

The versions I have installed on my linux box currently, pretty much match what is used in the "Setting up PHP and Firebird on Linux" guide found on firebirdsql.org.

 

Are there any geniuses out there that know what else I can try? I've been battling with this one for days. I need to use linux though because of stability. Any assistance or words of hope are welcome!

 

Thanks in advance.

 

Regards,

Gareth

[DarkWater]

Try this for me:

 

php -m | grep "ibase" | head -n 1

[evsuser]

Thank you for your input, DarkWater. Much appreciated!

 

I am busy re-installing a clean Fedora Core 9, Firebird, Apache and PHP (with interbase support), because I suspect more conflicts have arisen whilst I was trying to resolve this issue.

 

I did try what you, said, in a terminal window, but no messages displayed, and nothing seemed to occur. I rebooted, but the test error was still the same.

 

I will try again after a clean install, and let you know.

 

Thanks again for your willingness to help!

 

Regards,

Gareth

[DarkWater]

That was just to check if PHP knew anything about an ibase module installed.  If there was no output, it should have just looked like:

 

someone@somecomp:~$ php -m | grep "ibase" | head -n 1

someone@somecomp:~$

 

That's what you saw, right?  Try this please:

 

yum search ibase

 

You may need to use sudo, I'm not sure.  Also, it may return a lot of results, but look for a relevant PHP one, if one exists.

[evsuser]

Yes, that is exactly what I saw.

 

But, not to worry, DarkWater. I came right by what seems like luck, after a clean install and playing around. I eventually discovered I was adding the interbase module to the php.ini file found in the path that phpinfo() showed me that it was installed. And also apache's config file needed something too, but gosh, I'll have to re-trace my steps again, as I cannot say what exactly I did, but now it's working!

 

I think soon I'll be able to answer all the forum posts around the net where others are having the same issue.

 

The "php -m" helped me see that interbase was not loaded initially, and then after the clean install using the apache/php source compiles/installs, it did show up there.

 

So, thank you very much once again!

 

Best Regards,

Gareth

[DarkWater]

Any time. =)  Please mark this topic as Solved when you get the chance.