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:

Firebird------------------>
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?

Regards.

--- 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
Para: firebird-support@yahoogroups.com
Fecha: jueves, 19 de agosto, 2010 21:42







 









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

























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