Subject RE: [firebird-support] Cannot create new database: "Can not access lock files directory /tmp/firebird/"
Author Paul Beach
> <<I'm trying to create a new database, but after typing the "create database" command followed by the path and filename, hitting Enter and then typing in my username and password (the only user is sysdba and I did change the password) I get the following error message:
> Statement failed, SQLSTATE = 08006
> Can not access lock files directory /tmp/firebird/>>
>
> [...]

It all depends on the path you provide in CREATE DATABASE. If it is just
a local filesystem path, e.g. CREATE DATABASE "/somefolder/dbname.fdb",
then the FB instance handling your request is running with your current
user account (somewhat like embedded FB).
So, try what the rest of the error message suggests and do:
CREATE DATABASE "localhost:/somefolder/dbname.fdb" USER "SYSDBA"
PASSWORD "yourpassword";
This way you access the FB server via the network stack and the request
gets handled by the FB inet server, running with "firebird" account
priviledges.

What I said, but better. Make sure somefolder has the privileges to allow
another user (firebird) to write to it and access it.

Regards
Paul