Subject | HELP: Error while trying to create file |
---|---|
Author | hexchaos |
Post date | 2009-06-26T02:30:49Z |
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!
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!