I have firebird 2.1 SuperServer installed on an Ubuntu 9.04 i386 based machine with employee.fdb located in my /home/brent directory.

I can access employee.fdb locally with flameRobin and with isql-fb. I can also access it remotely from a second machine via IBExpert on XP and via flameRobin on ubuntu 9.04 (dual boot).

If I try to create a new database, even as sysdba, it fails. Using FlameRobin locally, I get this error report,

*** IBPP::SQLException ***
Context: Database::Create
Message: isc_dsql_execute_immediate failed

SQL Message : -902
Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements

Engine Code : 335544344
Engine Message :
I/O error for file "/home/brent/ws/data/scubiedb.fdb"
Error while trying to create file
Permission denied

The message is the same when I try to create the database
remotely.


If I forget the GUI clients and try isql from the
command line.

sudo isql-fb

SQL> create database /home/brent/xxx.fdb page_size 8192 length 1000 user sysdba password xxxxxxx
CON> default character set iso8559_1;

it responds,

Statement failed, SQLCODE = -104
SQL error code = -104
-Token unknown
SQL>

At first I thought I was making a mistake with the gui applications but isql fails too, so I think something is wrong with Firebird. The errors are different so perhaps I'm making a few syntactic mistakes here - I don't know. Please, can someone help.

regards,
Brent