Subject Re: [firebird-php] Re: Installing PHP-Firebird
Author Milan Babuskov
vengfulsquirrel wrote:
> Well now when a php script comes across an ibase_connect() command
> I get:
>
> Warning: ibase_connect(): operating system directive open failed
> Permission denied in zaddplant.php on line 47
> Cannot Connect.

It looks like Firebird doesn't have enough rights to read database file,.

> I thought I had permissions wrong but now I think firebird is not
> running at all. Can you connect using isql to a database like
> /opt/firebird/bin/isql /opt/firebird/examples/employee.gdb
> without actually having the server runnning?

With Classic server you can. With SS no.

> What is the process that should be running for me to connect to?

That depends on system. It's probably inetd or xinetd on your system.
You should check whether inet deamon is configured to listen to Firebird
TCP port (3050). If you install Firebird from .rpm file this should be
configured automatically. Perhaps your inetd is down?

> I thought fb_lock_mgr was it, but that does not seem to work with that
> running.
> I was trying /opt/firebird/bin/isql
> localhost:/opt/firebird/examples/employee.gdb
> this does not work, and I added localhost and localhost.localdoman to
> hosts.equiv. And the install did create the file
> /etc/xinetd.d/firebird file for the service gds_db. I am kind of
> clueless to how this all ties in some insight would be very helpful
> thanks.

You're getting close ;)
Xinetd listens to port 3050. When client tries to make a connection,
xinetd launches firebird server process, and "gives" the connection to it.

> Should I just use CS1.0 and not CS1.5 or is SS an easier install?

IMHO, both SS and CS are very easy if you install from .rpm file. CS
scales better if you combine "heavy" and ligth queries for the same
server, but uses more memory. SS is good if you have many "short and
light" transactions. To make long story short: SS is good for OLTP, CS
is good for OLAP.

> By the way I didn't see any errors when I started apache with rcapache
> start or (whatever the startup script is called) when I just deleted
> the interbase.so module while keeping the entry in the conf file.

Is PHP compiled in Apache as module or not?
Have you tried to run php from shell?

--
Milan Babuskov
http://fbexport.sourceforge.net