Now I find another scenario I did not take into account and it makes
zero-installation-ready-to-use-configuration application hard to
distribute. I was planning on using .zip packages.

If site has installed firebird server according to locale-sensitive
"program files" folder.
c:/program files/firebird2/db/mydb.fdb
c:/Ohjelma tiedostot/firebird2/db/mydb.fdb
c:/programmes/firebird2/db/mydb.fdb

JDBC-url problem or any native client:
Firebird url must know _the server folder_ where database file is
stored. But it may change due to windows locales.

"aliases.conf" file should isolate the problem and jdbc url may use
"mydb.fdb" name without full path.

But aliases.conf must always be edited manually. And is it possible to
create database if aliases.conf is activated?

As I stated in a message below, Firebird tries to create database to
"bin" folder if I dont give a path. I think its not a good folder
keeping database files.

Then "../db/mydb.fdb" path did not work as I expected. Anyway maybe
its just good, because relative path could be a security hazard.

Is it possible to configure like this:
Default database folder:
c:/xxxxxx/firebird2/db/

Creating a database with name "mydb.fdb" should put file to given db
folder.

Relative path "test/mydb.fdb" should go to "db/test/mydb.fdb" file.
All relative paths should be capped to given root folder, so
"../../../mydb.fdb" is illegal entry.

--- In firebird-support@yahoogroups.com, "mailmur" <mailmur@...> wrote:
>
> I have RESTRICT settings applied.
>
> firebird.conf:
> ## Keep .fdb files in the folder
> ## c:/program files/firebird2/db/ folder
> DatabaseAccess = Restrict db
>
> If I use FlameRobin to create a new database and give database path
> without explicit local folder structure:
> test.fdb
> -> "access to db "c:/program files/firebird2/bin/test.fdb" is denied..."
>
> db\test.fdb
> -> "access to db "c:/program files/firebird2/bin/db/test.fdb" is
> denied..."
>
> ..\db\test.fdb
> -> "access to db "c:/program
> files/firebird2/bin/firebird2/db/test.fdb" is denied..." !!! look at
> the folder server was about to use !!!
>
> And using "aliases.conf" file it goes even more difficult to _remote_
> administrate Firebird installation. I'd say its a rather impossible
> and remotedesktop and/or VNC connection is mandatory with access to
> server's local folder structure.
>
> And then dbclients should know it even less, so aliases.conf is
> mandatory. But then it must manually be edited.
>
> How do you maintain server in a way that dbadmin and dbclients does
> not need to know the physical folder structure?
>
> How do you drop database?
>
> I had no problems in MySQL and MSSQL server adminstration, but I find
> this a problem in Firebird.