| Subject | Re: [firebird-support] Having problems trying to create a database |
|---|---|
| Author | Helen Borrie |
| Post date | 2004-09-26T08:07:38Z |
At 04:12 PM 26/09/2004 +1000, you wrote:
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.
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
>HelloNo, cross-posting is sending the same message to multiple lists. But it
>
>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?
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 IOk, make a point of reading the release notes for Firebird 1.5. It should
>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.
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