FB_CONFDIR change breaks installation

[Vít Kabele]

Hello,

I created native package of Firebird database for the Synology DSM. I am fixing the latest issues before publishing the package.

I am now trying to change the FB_CONFDIR to a different location than the general PREFIX of the package (to preserve config across updates), but it seems to affect the behavior of unrelated things.

What I observe when changing the FB_CONFDIR location:

- fbguard fails to start the firebird, because it looks for the binary in FB_CONFDIR/bin/firebird, despite the FB_SBINDIR still pointing to the proper install prefix.

- when firebird is started manually, it fails with security database error, printing the PROPER security4.fdb path and claiming that the database was not found.

Could someone point me in the right direction to overcome this problem?

Best regards,

Vit Kabele

https://github.com/SynoCommunity/spksrc/pull/5837

[Mark Rotteveel]

Your question is probably more suitable for the firebird-devel group at
https://groups.google.com/g/firebird-devel

Mark - moderator firebird-support

--
Mark Rotteveel

[Vít Kabele]

Thank you, I was not sure. I will re-post there.

Dne sobota 19. srpna 2023 v 10:09:25 UTC+2 uživatel ma...@lawinegevaar.nl napsal:

[liviuslivius]

Hi

Which version of FB do you use that you have FBGuard?

Regards,

Karol Bieniaszewski

-------- Oryginalna wiadomość --------

Od: Vít Kabele <vitek...@gmail.com>

Data: 19.08.2023 10:12 (GMT+01:00)

Do: firebird-support <firebird...@googlegroups.com>

Temat: Re: [firebird-support] FB_CONFDIR change breaks installation

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/ed7b7a3a-b1c1-49f1-911b-d999ccf93938n%40googlegroups.com.

[Vít Kabele]

Ah yes, my bad. I am using the latest v4.0.3. I hope this is the proper way to run firebird as a daemon.

VK

Dne sobota 19. srpna 2023 v 13:49:42 UTC+2 uživatel liviuslivius napsal:

[AlexPeshkoff]

 

> I am now trying to change the FB_CONFDIR to a different location than
> the general PREFIX of the package (to preserve config across updates),
> but it seems to affect the behavior of unrelated things.
> What I observe when changing the FB_CONFDIR location:
> - fbguard fails to start the firebird, because it looks for the binary
> in FB_CONFDIR/bin/firebird, despite the FB_SBINDIR still pointing to the
> proper install prefix.
> - when firebird is started manually, it fails with security database
> error, printing the PROPER security4.fdb path and claiming that the
> database was not found.
>
> Could someone point me in the right direction to overcome this problem?
>

For a number of historical reasons we treat all directories relative to firebird root directory. When FB_CONFDIR is not set that's PREFIX, when set - fbroot is FB_CONFDIR.

To make all that work as you want set all (FB_SBINDIR, FB_BINDIR, FB_LIBDIR, etc.) explicilty.

[Vít Kabele]

Hello,

thank you for your reply, it helped me solve the problem.

What is a little confusing though, is this comment https://github.com/FirebirdSQL/firebird/blob/master/src/include/gen/autoconfig.h.in#L143 on line 143.

I states that the default plugdir is PREFIX, while in the installation it seems that the plugins are located

in PREFIX/plugins. This took me some time to figure out when I was setting the explicit paths.

Maybe the comment should be updated?

The wrong path to plugins dir also resulted in the error I've seen before with failed to connect to the security4.fdb.

Thank you for your prompt responses!

Vit Kabele

Dne pondělí 21. srpna 2023 v 11:38:03 UTC+2 uživatel alexander...@gmail.com napsal:

[Alex Peshkoff]

On 8/23/23 11:40, Vít Kabele wrote:
> What is a little confusing though, is this
> comment https://github.com/FirebirdSQL/firebird/blob/master/src/include/gen/autoconfig.h.in#L143
> on line 143.
> I states that the default plugdir is PREFIX, while in the installation
> it seems that the plugins are located
> in PREFIX/plugins. This took me some time to figure out when I was
> setting the explicit paths.
> Maybe the comment should be updated?
>

https://github.com/FirebirdSQL/firebird/commit/5432699f284dad21443eff5ed86b9f717614fa6f