Subject Re: [firebird-support] Having problems trying to create a database
Author Helen Borrie
At 04:12 PM 26/09/2004 +1000, you wrote:
>Sorry I am a newbie to this support group/mailing list. I also put a note
>on Yahoo groups - does that mean I am cross posting?

No, cross-posting is sending the same message to multiple lists. But it
pays to be a little bit patient. We are all volunteers here and we
moderate the initial posting by every new member to reduce spam attacks.

>I hope not. Anyway I
>am having problems trying to create a database in my fresh install of
>Firebird 1.5 - here's what happens:
>Statement failed, SQLCODE = -902
>I/O error for file "/home/sshlogin/fb/xsecore.gdb"
>-Error while trying to create file
>-Permission denied
>Platform is Redhat Fedora core 2, lots of disk space.

Ok, make a point of reading the release notes for Firebird 1.5. It should
be in your firebird /doc directory but, if it's not, get it from the
Firebird 1.5 downloads page at, in the section Main
Downloads. In the Linux installation section are some instructions about

Create a firebird group. Create a sysdba user. Make the firebird user and
sysdba members of that group (along with any other users (database owners)
who will need access to database at file level. Database users otherwise
don't need to belong to the firebird group.

Decide a place where you will have databases. For example, I confine
databases to a partition called /data. You might prefer to use the
database owner's or sysdba's home directory. Some people create a
subdirectory in /var. The place where you are attempting to create your
database - the firebird /bin directory - is not a suitable place.

Right, now, give rwx permissions to group to your database space.

If you want to use isql to create a database in your prepared /data
directory, with owner sysdba (simplest to start with) do this from the
/opt/firebird/bin directory (it's all one command, broken here for clarity):

bin]$ ./isql -user sysdba -password yt654eeu
Use CREATE or CONNECT....blah
SQL>create '/data/bxsecore.gdb'
CON> user 'sysdba' password 'yt654eeu'
CON> page_size 8192

That creates the database and puts it online. To understand what you're
doing from here on, either buy my book (PLUG!!) or grab the OpsGuide.pdf
and LangRef.pdf from somewhere on the net (just google those filenames) ---
IB6 beta docs.

cheers from the Central Coast