Subject | Permission denied on create database |
---|---|
Author | Garrett Smith |
Post date | 2005-06-17T02:02:56Z |
I just installed FirebirdSS rpm package on Linux and I'm having a heck
of a time trying to create a database. I'm able to connect to databases
and modify them, but not create them. Here's what I'm seeing:
[garrett@www garrett]$ isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database 'foo.fdb' user 'sysdba' password 'foobar';
Statement failed, SQLCODE = -902
I/O error for file "/home/garrett/foo.fdb"
-Error while trying to create file
-Permission denied
I certainly have write access to my home directory. I can run as root
with the same result.
I'm wondering if the Firebird deamon is trying to create/modify
something in the background and can't because of file permissions. This
is just blind speculation.
Has anyone else run into this?
-- Garrett
of a time trying to create a database. I'm able to connect to databases
and modify them, but not create them. Here's what I'm seeing:
[garrett@www garrett]$ isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database 'foo.fdb' user 'sysdba' password 'foobar';
Statement failed, SQLCODE = -902
I/O error for file "/home/garrett/foo.fdb"
-Error while trying to create file
-Permission denied
I certainly have write access to my home directory. I can run as root
with the same result.
I'm wondering if the Firebird deamon is trying to create/modify
something in the background and can't because of file permissions. This
is just blind speculation.
Has anyone else run into this?
-- Garrett