Subject Re: [firebird-support] Problems creating database with Firebird Super Server in Ubuntu 9.10
Author cris abar
Hi Helen...¬°Thank you very much for answering.!

Yes, I tried firebird.firebird or firebird: firebird and works of two ways.

It just seems that the server has no access.

Firebird users added to group:

myuser------------------->  SERVER: user 'SYSDBA' password 'masterke'

I tested with the classic version and works flawlessly.

Could it be that the installer had problems with my distribution?


--- El jue, 19/8/10, Helen Borrie <helebor@...> escribió:

De: Helen Borrie <helebor@...>
Asunto: Re: [firebird-support] Problems creating database with Firebird Super Server in Ubuntu 9.10
Fecha: jueves, 19 de agosto, 2010 21:42


At 11:11 AM 20/08/2010, you wrote:



>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...)


[Non-text portions of this message have been removed]