Disable embedded

[Tomasz Dubiel]

Hello.

Firebird 3.0.12 Windows.

I want to disable embedded connections according to:

https://firebirdsql.org/file/documentation/html/en/firebirddocs/qsg3/firebird-3-quickstartguide.html

I changed firebird.conf, restarted Firebird service and since then I'm unable to connect to any database. All the time I get:

Error occurred during login, please check server firebird.log for details

Authentication error
unavailable database

No matter whether I'm using my Delphi program, IBExpert or ISQL. all the time no change.

Does it work for you?

Best regards,

Tomasz.

[Vlad Khorsun]

  You explicitly disables embedded connections for everyone, including Firebird server itself.

Regards,

Vlad

PS QSG should be reworked in this part, IMO

[Tomasz Dubiel]

OK, but does it mean this instruction is useless?

We want to get rid of embedded. We worked on Firebird 2.5 Classic before and we have a lot of connection strings without servername on our customers' servers.

Now we switched to Firebird 3.0 SuperServer, its enough for a one connection entering embedded like that and it blocks connections for others.

Best regards.

[Vlad Khorsun]

OK, but does it mean this instruction is useless?

It depends.

 

We want to get rid of embedded. We worked on Firebird 2.5 Classic before and we have a lot of connection strings without servername on our customers' servers.

Now we switched to Firebird 3.0 SuperServer, its enough for a one connection entering embedded like that and it blocks connections for others.

  Just make your apps to not use fbclient resided in server installation folder.

Create separate folder with fbclient.dll, firebird.msg and firebird.conf (optional), or put these files into folder with

your .exe files.

Regards,

Vlad

[Tomasz Dubiel]

It's not a problem with our application. It uses a connection string with a servername, but we have a lot of scripts on the database server doing something (isql scripts, recalculate statistics, gbak, gfix, etc) connecting to a database without a servername in connection string.

Best regards.

[Tomasz Dubiel]

Dmitry Yemanov suggested setting:

Providers = Remote,Loopback,Engine12

instead of the one suggested in your official instruction and it looks it works OK. I connected as embedded, then I connected with normal connectionstring with servername and it went fine.

It solves my problem, but after all it still doesn't disable embedded connections.

Best regards.

[Tomasz Dubiel]

Thanks.

[Dimitry Sibiryakov]

Tomasz Dubiel wrote 25.04.2024 10:19:
> OK, but does it mean this instruction is useless?

No, you just misunderstood its purpose.

> We want to get rid of embedded. We worked on Firebird 2.5 Classic before and we have a lot of connection strings without servername on our customers' servers.

You can do it on client side only. An attempt to disable embedded access for
Firebird Server itself will break it completely.
On client side after removing engine provider you can use remote connections
only.

--
WBR, SD.

[Tomasz Dubiel]

I would argue that simply this text is misleading: :-)

"If you don’t want any type of direct access, you may disable embedded mode (= direct filesystem-level access) altogether by opening firebird.conf and locating the Providers entry. The default (which is probably commented out) is:"

but ok, it's not that important already.

Best regards.

[Dimitry Sibiryakov]

Tomasz Dubiel wrote 25.04.2024 11:22:
> I would argue that simply this text is misleading: :-)

> "*If you don’t want any type of direct access, you may disable embedded mode (=

> direct filesystem-level access) altogether by opening firebird.conf and locating

> the Providers entry. The default (which is probably commented out) is:*"

> but ok, it's not that important already.

Keyword is "any". And you changed server's config. You should expect that
server will loose ANY access to local database files.

--
WBR, SD.

[Elmar Haneke]

"If you don’t want any type of direct access, you may disable embedded mode (= direct filesystem-level access) altogether by opening firebird.conf and locating the Providers entry. The default (which is probably commented out) is:"

It should be obvious that disabling direct filesystem-level access on server installation does disable the main purpose of the server.

The configuration is to be done on a client only firebird.conf

[Tomasz Dubiel]

That's what I think could be added:

"The configuration is to be done on a client only firebird.conf"

I have been working with Firebird for over 8 years and I haven't had any occasion to deal with such parameters ;) until now.

Best regards.