Subject Re: [firebird-php] connecting to a db ...
Author Jochem Maas
Antonio, et al,

thanks for your suggestions, unfortunately no luck in getting it to work
so far.

Antonio Galicia wrote:
> On 4/4/06, Jochem Maas <jochem@...> wrote:
>
>
>>the isql cmdline tool but connection from php gives me the following:
>
>
>> Warning: ibase_connect(): Unable to complete network request to host "localhost".
>> Failed to establish a connection. Permission denied in ...
>
>
> Check if the apache user (www-data) have permision to read/write for
> the database file *AND* for the security database
> (/var/lib/firebird2/system/security.fdb). For security just add apache
> user to firebird group.

firebird group has read+write perms for the DB file and the security DB.
apache user (www-data) is a member of the firebird group.

>
>
>>I'm sure that someone here can put me out of my misery, how do I get it too connect?
>
>
> Try:
>
> # su - www-data
> $ isql-fb database_alias

works

> $ isql-fb localhost:database_alias

doesn't work (for either root or www-data users).

I have also tried changing the permissions of all the relevant files to 777
but that doesn't help either.

I have also tried adding rules in the firewall to allow incoming UPD and TCP traffic
on port 3050 and port 2401 - which makes no difference either (I tried 2 different
forms of firewall rule: 1. allow from localhost and 2. allow from any host).

no joy.

any taker on what idiotic thing I'm missing here?

rgds,
Jochem