Subject Re: [firebird-support] Problems creating database with Firebird Super Server in Ubuntu 9.10
Author Helen Borrie
At 11:11 AM 20/08/2010, you wrote:
>Hi.
>
>I'm testing the first Firebird and for that I have it installed on my computer with Ubuntu 9.10.
>The version that I have installed is the Firebird Super Server 2.1.3.
>
>To test if it works the connection to a database, try the following:
>
>SQL>connect "localhost:/path/employee.fdb" user 'SYSDBA' password 'masterke';
>
>This allows me to see that table contains the database. OK.
>
>The problem occurs when I try to create a database, for this I do the following:
>
>I create a folder called BD, I change the permissions and owner:
>
>$sudo chmod 777 -R /path/BD
>$sudo chown -R firebird.firebird /path/BD
>
>Then proceed to create the database:
>
>SQL>create database "localhost:/path/BD/BDatos.fdb" user 'SYSDBA' password 'masterke';
>
>This gives me the following error:
>
>Statement failed, SQLCODE = -902
>I/O error for file "/path/BD/BDatos.fdb"
>-Error while trying to create file
>-Permission denied
>
>I wonder what would be my mistake.

firebird:firebird, not firebird.firebird ?

(Do ls -l on the /BD directory and see what ownership you actually got there...)

./heLen