Subject | RE: [firebird-support] Firebird 1.5.3 can't create new database on Linux |
---|---|
Author | Nigel Weeks |
Post date | 2006-02-15T23:01:55Z |
> > [root@linux aguila]# /opt/firebird/bin/isqlYour problem is right at the top.
> >
> > 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.
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.