Subject Re: firbird 1.5 database creation error
Author wang960

I notice that file can't be created from a windows client app, what
I'm doing is:

login in as 'root'
create a file in isql,
SQL> create database '/home/fdb/test.fdb' page_size 8192;

but test.fdb is owned by root, have to:chown to firebird.firebird

then connect from a windows client, run a script to create tables.

if i login as 'firebird', and run isql, i got an error:

unable to open

why user firebird can not run isql?



--- In, Milan Babuskov <milanb@...>
> Helen Borrie wrote:
> > And don't forget that the 'firebird' user must have at least group
> > ownership permissions to the filesystem location and at least
> > group-level rwx permissions to the directory where the database file
> > is to be created/accessed.
> To be more exact: rwx for creation, r-x for access. Most of my
> are in this directory:
> drwxr-x--- 2 root firebird 888 2006-10-11 17:40 /baze/
> This ensures that only root can create databases, while regular
> users cannot.
> --
> Milan Babuskov