On Fri, Apr 5, 2019 at 4:49 PM Mark Rotteveel mark@... [firebird-support] <firebird-support@yahoogroups.com> wrote:

 

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.

1. The host file:

127.0.0.1 localhost
127.0.0.1 Ubuntu_Machine

# The following lines are desirable for IPv6 capable hosts
::1 ip6-localhost ip6-loopback
fe00::0 ip6-localnet
ff00::0 ip6-mcastprefix
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters
192.168.0.4 WindowClientPC

 

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.

2. The service is up and running. I am trying to connect to the same database with both the strings. While the local connection string allows update commit records, the URL-Style connection does not connect.

> 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