Subject RE: [firebird-support] Firebird 1.5.3 can't create new database on Linux
Author Nigel Weeks
> > [root@linux aguila]# /opt/firebird/bin/isql
> >
> > Use CONNECT or CREATE DATABASE to specify a database
> > SQL> create database "test1.fdb";
> > Statement failed, SQLCODE = -902
> >
> > I/O error for file "/opt/aguila/test1.fdb"
> > -Error while trying to create file
> > -Permission denied
> > SQL>
> >
> > The "/opt/aguila" directory is owned by the firebird user, and I am
> > logged in as root. The problem persists even if I change
> the ownership
> > of the directory to root. And there is plenty of free disk space on
> > the partition.

Your problem is right at the top.

Make sure you specify a user and password when you start isql

/opt/firebird/bin/isql -u sysdba -p masterkey (or whatever you've changed
your sysdba password to)

N.