Subject Re: [firebird-php] connecting to a db ...
Author Frank Schlottmann-Goedde
Jochem Maas schrieb:
> 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).

As it seems to be a 2.0 server you will probably need
isql-fb -user SYSDBA -password XXXXXXXX localhost:database_alias

Do you provide an username and password in your connct-string?

Frank
--
"Fascinating creatures, phoenixes, they can carry immensely heavy loads,
their tears have healing powers and they make highly faithful pets."
- J.K. Rowling