Subject | RootDirectory and location of database files |
---|---|
Author | Marc Batchelor |
Post date | 2005-04-25T21:30:08Z |
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.
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.