Subject | Permission denied |
---|---|
Author | Ted Miglautsch |
Post date | 2012-12-12T11:23:53Z |
It happened again. Suddenly I lost the ability to locally access a
database. This is firebird 2.1 running on Ubuntu 10.04.
If I try and access the database using isql I get "Permission denied."
However, "ls -l" shows I have ownership and rights to the file. I can
even dump the file. It seems firebird is trying to access some other
file besides the database when I try to connect to the database. When I
reboot the machine I have normal access again. The firebird log file
contains absolutely nothing.
ted@migmar11:~/dbs$ isql exp_dm
Statement failed, SQLCODE = -902
operating system directive open failed
-Permission denied
Use CONNECT or CREATE DATABASE to specify a database
SQL> quit;
ted@migmar11:~/dbs$ ls -l exp_dm
-rw-rw---- 1 ted ted 1531904 2012-12-12 15:12 exp_dm
ted@migmar11:~/dbs$ hexdump -C exp_dm |head
00000000 01 00 39 30 7c 10 00 00 00 00 00 00 00 00 00 00
|..90|...........|
00000010 00 20 0b 80 03 00 00 00 00 00 00 00 ce 0f 00 00 |.
..............|
00000020 cf 0f 00 00 d0 0f 00 00 00 00 02 00 af db 00 00
|................|
00000030 4c 85 d0 17 a6 00 00 00 00 00 00 00 13 00 01 00
|L...............|
00000040 01 00 66 00 00 00 00 00 01 00 00 00 cf 0f 00 00
|..f.............|
00000050 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|................|
00000060 06 04 20 4e 00 00 00 00 00 00 00 00 00 00 00 00 |..
N............|
00000070 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|................|
*
00002000 02 00 39 30 4b 00 00 00 00 00 00 00 bb 00 00 00
|..90K...........|
ted@migmar11:~/dbs$
database. This is firebird 2.1 running on Ubuntu 10.04.
If I try and access the database using isql I get "Permission denied."
However, "ls -l" shows I have ownership and rights to the file. I can
even dump the file. It seems firebird is trying to access some other
file besides the database when I try to connect to the database. When I
reboot the machine I have normal access again. The firebird log file
contains absolutely nothing.
ted@migmar11:~/dbs$ isql exp_dm
Statement failed, SQLCODE = -902
operating system directive open failed
-Permission denied
Use CONNECT or CREATE DATABASE to specify a database
SQL> quit;
ted@migmar11:~/dbs$ ls -l exp_dm
-rw-rw---- 1 ted ted 1531904 2012-12-12 15:12 exp_dm
ted@migmar11:~/dbs$ hexdump -C exp_dm |head
00000000 01 00 39 30 7c 10 00 00 00 00 00 00 00 00 00 00
|..90|...........|
00000010 00 20 0b 80 03 00 00 00 00 00 00 00 ce 0f 00 00 |.
..............|
00000020 cf 0f 00 00 d0 0f 00 00 00 00 02 00 af db 00 00
|................|
00000030 4c 85 d0 17 a6 00 00 00 00 00 00 00 13 00 01 00
|L...............|
00000040 01 00 66 00 00 00 00 00 01 00 00 00 cf 0f 00 00
|..f.............|
00000050 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|................|
00000060 06 04 20 4e 00 00 00 00 00 00 00 00 00 00 00 00 |..
N............|
00000070 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|................|
*
00002000 02 00 39 30 4b 00 00 00 00 00 00 00 bb 00 00 00
|..90K...........|
ted@migmar11:~/dbs$