Subject Re: [firebird-support] Ubuntu 18.04 Firebird 3.03 Server Connection String: Local Works, URL-Style Fails
Author Mark Rotteveel
On 2019-04-05 12:22, LtColRDSChauhan rdsc1964@...
[firebird-support] wrote:
> Hello,
>
> 1. The following connection string works:
>
> /home/ubuntu_user/Documents/Sample.FDB
>
> 2. While following connection strings fails:
> Ubuntu_Machine:/home/ubuntu_user/Documents/Sample.FDB
>
> localhost:/home/ubuntu_user/Documents/Sample.FDB
>
> 127.0.0.1:/home/ubuntu_user/Documents/Sample.FDB

Given the config used for RemoteBindAddress, the URL with Ubuntu_Machine
is unlikely to work (unless it resolves to 127.0.0.1, which isn't
common), localhost could potentially not work if it resolves to IPv6 ::1
instead of IPv4 127.0.0.1. The last one should work **if** Firebird is
up and running, and **if** the Firebird server process has read/write
access to the database file in your home directory (and to be clear
giving server processes read/write access to the home directory of
another user is not a good idea). You should put the database in a
location that is accessible to the Firebird server process.

> 3. The message (through FlameRobin) :
>
> Unsuccessful execution caused by unavailable resource.
> Engine Code: 335544375
> Engine Message:
> Unavailable database
>
> 4. My config file is as under:
>
> DatabaseAccess = Full
>
> Providers = Remote,Engine12,Loopback
>
> RemoteAccess = true
>
> RemoteBindAddress = 127.0.0.1
>
> RemoteServiceName = gds_db
>
> RemoteServicePort = 3050
>
> ServerMode = Super
>
> UdfAccess = None