Subject | Problems creating database with Firebird Super Server in Ubuntu 9.10 |
---|---|
Author | cris abar |
Post date | 2010-08-19T23:11:29Z |
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.
Regards.
[Non-text portions of this message have been removed]
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.
Regards.
[Non-text portions of this message have been removed]