Thanks Helen!

greetings from down south.

Andrew



--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> At 04:12 PM 26/09/2004 +1000, you wrote:
> >Hello
> >
> >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:
> >
> >SQL> CREATE DATABASE './xsecore.gdb' DEFAULT CHARACTER SET UNICODE;
> >Statement failed, SQLCODE = -902
> >
> >I/O error for file "/home/sshlogin/fb/xsecore.gdb"
> >-Error while trying to create file
> >-Permission denied
> >SQL>
> >
> >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 www.ibphoenix.com, in the section

Main

> Downloads. In the Linux installation section are some instructions

about

> permissions.
>
> 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
> CON> DEFAULT CHARACTER SET UNICODE_FSS;
>
> 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
> ./heLen