Subject RootDirectory and location of database files
Author Marc Batchelor
Hey all,

On my new server configuration, I'm taking advantage of aliases
(alias.conf) and the setting in the firebird.conf called
DatabaseAccess. What I can't figure out though is why (under Windows)
the default location it tries to create a database is under
C:\Windows\System32, even though I've specified what my RootDirectory
is in the configuration file.

My ideal is that remote users creating databases should have no
knowledge that firebird is on the E: drive, in a specific directory.

For example, I imagined that the creator of a new database should be
able to use syntax like this:

create database 'theserver:data/newdb.fdb'

Something like that.

Anyway, I get the following error when I attempt to do that:

Access to database "C:\WINDOWS\SYSTEM32\DATA\TEST.FDB" is denied by
server administrator

The only way for a remote user to create a database in my
E:\Firebird_1_5\data directory is for them to expressly specify that path.

Shouldn't RootDirectory somehow get involved here and at least let
stuff get created relative to RootDirectory?

By the way - I tried creating a special user for the fbguard and
fbserver services, and set it's home directory to E:\Firebird_1_5.
Same problem.
Am I missing a setting somewhere?

Thanks for your help.