Subject RE: [firebird-support] Permission denied on create database
Author Alan McDonald
>
> 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

does the server have permission to right in your home dir?
Alan