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

>
> With SS, the user firebird must have permissions (rwx) in any directory where it is going to create databases or update them.

....
but, wherever you decide to store them, you need to take care of the filesystem permissions before trying to access them.

>

....

>
> ./heLen

Hi Helen,

thanks for pointing me in the right direction - oops!

As you said, the big mistake was moving 'employees.fdb' from the firebird directories to my home directory without changing group permissions on the host directory. I had followed the firebird howto adding user 'brent' to the firebird group but I did not go any further.

So in the host directory, I changed the group name to firebird and adjusted directory permissions to rd/wr/x and tried isql again simplified as you suggested,

brent@brent-desktop:~/ws/data$ isql-fb
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database 'test.fdb' user 'brent' password 'brent_1';
SQL> quit;

brent@brent-desktop:~/ws/data$ ls -l
total 3008
-rw-r--r-- 1 firebird firebird 1085440 2009-08-16 19:10 employee.fdb
-rw------- 1 firebird firebird 659456 2009-08-16 21:57 test1.fdb

- it worked.

I retried flameRobin locally and then flameRobin and IbExpert remotely and it all worked.


Many thanks.
Brent.



P.S - for novices like myself...

If you are daft enough to move the sample database away from the firebird directories, this is what you must do,

Your host data directory will start off looking something like this,
brent@brent-desktop:~/ws$ ls -l
drwxr-xr-x 2 brent brent 4096 2009-08-11 23:35 data

1) change the group name to firebird
brent@brent-desktop:~/ws$ chgrp firebird data
brent@brent-desktop:~/ws$ ls -l
drwxr-xr-x 2 brent firebird 4096 2009-08-11 23:35 data

2) change permissions to rwx (rw- is not sufficient)
brent@brent-desktop:~/ws$ chmod 770 data
brent@brent-desktop:~/ws$ ls -l
drwxrwx--- 2 brent firebird 4096 2009-08-11 23:35 data

3) Run isql-fb, as above, to create the database.

If you are using a GUI like flameRobin use the full path when specifying the location of the database even if you are on a remote connection.
in my case, '/home/brent/ws/data/test1.fdb'

Finally if you are using remote clients don't forget to open port 3050 on the firewall to allow your clients access to the server.

On Ubuntu 9.04, my client pc runs within a dhcp pool of 10.0.0.8 ~ 16

sudo ufw allow from 0.0.0.0/4 to any port 3050

None of the howtos I have seen cover this, good luck.
Brent