Newbie isql-fb help on ubuntu

[David Troendle]

I installed firebird 3.0 server on Ubuntu 20.04.  I am trying to create my first test database, and used the following:

isql-fb
Use CONNECT or CREATE DATABASE to specify a database
SQL> CREATE DATABASE '/home/david/test.fdb' USER 'SYSDBA' PASSWORD 'masterkey';
Statement failed, SQLSTATE = HY000
operating system directive access failed
-Not a directory
SQL> CREATE DATABASE 'test.fdb' USER 'SYSDBA' PASSWORD 'masterkey';
Statement failed, SQLSTATE = HY000
operating system directive access failed
-Not a directory
SQL>

My eventual goal is to use RazorSQL on a JDBC connection, but I figure I best get a test database created first using the builtin tools.

Thanks in advance.

David

[Mark Rotteveel]

On 28-10-2021 14:25, David Troendle wrote:
> I installed firebird 3.0 server on Ubuntu 20.04.  I am trying to create
> my first test database, and used the following:
>

> *isql-fb

> Use CONNECT or CREATE DATABASE to specify a database
> SQL> CREATE DATABASE '/home/david/test.fdb' USER 'SYSDBA' PASSWORD
> 'masterkey';
> Statement failed, SQLSTATE = HY000
> operating system directive access failed
> -Not a directory
> SQL> CREATE DATABASE 'test.fdb' USER 'SYSDBA' PASSWORD 'masterkey';
> Statement failed, SQLSTATE = HY000
> operating system directive access failed
> -Not a directory

> SQL> *

>
> My eventual goal is to use RazorSQL on a JDBC connection, but I figure I
> best get a test database created first using the builtin tools.

Is your user in the firebird group? If not, you probably do not have
access to the shared lock directory. Add your user to the firebird
group. Alternatively, try to use TCP/IP connection strings (e.g.
localhost:<path-to-db> or inet://localhost/<path-to-db> so you connect
through the Firebird server (but then you need to use a different
directory, because the server won't have access to your home directory).

Mark
--
Mark Rotteveel

[David Troendle]

Many thanks for the help.  I completely missed the need to put my userID in the firebird group.  I can now create and access my database in RazorSQL.  Life is good.

David