At 06:54 PM 15/04/2005 +1000, you wrote:

>Any help appreciated - thanks
>
>I'm attempting to create my first ever firebird (1.5.2.4731-0 ) database
>in SuSE 9.1 ...
>
> - in a directory which is in mode 777
> - I'm logged in as root
> - the directory owner and group is root
>
>and isql is reporting ...
>
>SQL> CREATE DATABASE '/root/samba_share/fbclimate/prd.fdb' user 'sysdba'
>password 'yg53dd&0';
>Statement failed, SQLCODE = -902
>
>I/O error for file "/root/samba_share/fbclimate/prd.fdb"
>-Error while trying to create file
>-Permission denied
>SQL>

Yup. Several problems here.

1) (main one) - you can't access a database on an SMB share. The path must
be one that is local to the host machine.

2) then ... the firebird user (i.e. the unix user named firebird, which was
created when you installed Firebird) has to have rwx permissions on both
the database file AND the directory tree where the database file is located.

3) it is not a Good Thing (TM) to grant other users privileges in root's
home directory. I suggest you create a filesystem tree called /data (or
similar) and make that the firebird user's "patch".

4) if you installed Classic (rather than Superserver) then you may find
that you also need to grant rwx perms on the database file to any local
unix user who wants to access it with a local connect, i.e. using the
libfbemb.so client.

5) Don't do Firebird stuff as root!!!!!!!!!!!

./hb