--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> At 12:02 PM 17/06/2005, you wrote:
> >I just installed FirebirdSS rpm package on Linux and I'm having a heck
> >of a time trying to create a database. I'm able to connect to databases
> >and modify them, but not create them. Here's what I'm seeing:
> >
> > [garrett@www garrett]$ isql
> > Use CONNECT or CREATE DATABASE to specify a database
> > SQL> create database 'foo.fdb' user 'sysdba' password 'foobar';
> > Statement failed, SQLCODE = -902
> >
> > I/O error for file "/home/garrett/foo.fdb"
> > -Error while trying to create file
> > -Permission denied
> >
> >I certainly have write access to my home directory. I can run as root
> >with the same result.
> >
> >I'm wondering if the Firebird deamon is trying to create/modify
> >something in the background and can't because of file permissions. This
> >is just blind speculation.
> >
> >Has anyone else run into this?
>
> This is a matter of Unix filesystem permissions. In order to create a
> database, the Unix user named firebird ("the firebird user") has to

create

> a file. Therefore, you need to make sure that the firebird user has

rwx

> filesystem permissions to the directory where the db is being
> created. It's recommended to create a firebird group that contains the
> firebird user and any other Unix users that might need file-level

access to

> the database file, and to grant these permissions to the group.
>
> ./hb

Yep -- my mistake was pretty stupid -- my home dir had read permission
turned off, so the firebird user couldn't see the directory I had so
carefully designated for it.

Thanks and sorry for the extra noise :-/