Subject HELP: Error while trying to create file
Author hexchaos
Hi everyone.
I've installed Firebird 2.1 on my Ubuntu Linux box, and finally managed to get it running.

(Installing it wasn't enough - I had to type "sudo dpkg-reconfigure firebird2.1-super" to get the service running, which the official documentation didn't make any mention of whatsoever(!), and required HOURS of frustrating googling to discover - but I digress)

Point is, I am unable to create a database anywhere but the default location:

---
SQL> create database '~/test.fdb' user 'SYSDBA' password 'xxxxx';
Statement failed, SQLCODE = -902
I/O error for file "/home/infinity/test.fdb"
-Error while trying to create file
-Permission denied
---

The only way to get it working was to create the database in the standard location:

---
SQL> create database '/var/lib/firebird/2.1/data/test.fdb' user 'infinity' password 'xxxxx';
SQL> exit;
---

...then MOVE it to where I wanted it, and launch isql-fb again:

---
SQL> connect /mnt/accumulator/Database/test.fdb user infinity password xxxxx;
Database: /mnt/accumulator/Database/test.fdb, User: infinity
SQL> show tables;
There are no tables in this database
SQL> exit;
---

So uhmm.....what gives, guys? Why can't I create databases in /mnt/accumulator/Database? The permissions are full across the board - look:

---
infinity@underling:~$ ls -l /mnt/ | grep accumulator
drwxrwxrwx 1 infinity infinity 8192 2009-06-25 23:09 accumulator

infinity@underling:~$ ls -l /mnt/accumulator/ | grep Database
drwxrwxrwx 1 infinity infinity 0 2009-06-25 23:12 Database

infinity@underling:~$ ls -l /mnt/accumulator/Database/ | grep test
-rwxrwxrwx 1 infinity infinity 659456 2009-06-25 23:25 test.fdb
---

And yes, I know I changed usernames halfway through. That doesn't appear to make any difference.

Any help would be appreciated!