On 23.08.2018 at 17:53, 'Paul Beach' [email protected] [firebird-support] wrote: > > <<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. good luck Tomasz -- __--==============================--__ __--== Tomasz Tyrakowski ==--__ __--== SOL-SYSTEM ==--__ __--== http://www.sol-system.pl ==--__ __--==============================--__
