Board index » delphi » Store RDB$USERS failed

Store RDB$USERS failed


2006-03-13 03:55:35 AM
delphi247
When I try to create a database with EUA-enabled on IB7.5 with sp1
(version 7.5.1.80) I get this message.
When I rollback the server to version 7.5.0.174 all works as it should.
Has anyone encountered the same experience?
Gelein van de Voorde.
--
 
 

Re:Store RDB$USERS failed

Gelein van de Voorde writes:
Quote
When I try to create a database with EUA-enabled on IB7.5 with sp1
(version 7.5.1.80) I get this message.
How are you creating the database? The API? IBDatabase.CreateDatabase?
isql? ...
--
Bill Todd (TeamB)
 

Re:Store RDB$USERS failed

Gelein van de Voorde writes:
Quote
When I try to create a database with EUA-enabled on IB7.5 with sp1
(version 7.5.1.80) I get this message.
When I rollback the server to version 7.5.0.174 all works as it
should. Has anyone encountered the same experience?
Make sure you create the database to be dialect 3.
--
Wayne Niddery - Logic Fundamentals, Inc. (www.logicfundamentals.com)
RADBooks: www.logicfundamentals.com/RADBooks.html
"Nature abhors the vacuum tube." - J.R. Pierce, Bell Labs engineer who
coined the term 'transistor'
 

Re:Store RDB$USERS failed

Bill Todd writes:
Quote
Gelein van de Voorde writes:

>When I try to create a database with EUA-enabled on IB7.5 with sp1
>(version 7.5.1.80) I get this message.

How are you creating the database? The API? IBDatabase.CreateDatabase?
isql? ...
I tried all possible methods, including isql.
I ran into this testing a new beta release for IBConsole. I checked
this on 5 different servers (all windows2003) and 2 XP-machines, all
with the same result. I can create an EUA-enabled database with a
version 7.5.0 server but not with a version 7.5.1 server. After
creating I can also
switch EUA on and off with a version 7.5.1 server.
That is why I am wondering if there could be a bug in the database
creation with a 7.5.1 server.
Gelein van de Voorde.
--
 

Re:Store RDB$USERS failed

Wayne Niddery [TeamB] writes:
Quote
Gelein van de Voorde writes:
>When I try to create a database with EUA-enabled on IB7.5 with sp1
>(version 7.5.1.80) I get this message.
>When I rollback the server to version 7.5.0.174 all works as it
>should. Has anyone encountered the same experience?

Make sure you create the database to be dialect 3.
Wayne,
I'm aware of that.
See my answer on Bills question.
Gelein van de Voorde.
--
 

Re:Store RDB$USERS failed

Gelein van de Voorde writes:
Quote
Bill Todd writes:

>Gelein van de Voorde writes:
>
>>When I try to create a database with EUA-enabled on IB7.5 with sp1
>>(version 7.5.1.80) I get this message.
>
>How are you creating the database? The API?
>IBDatabase.CreateDatabase? isql? ...

I tried all possible methods, including isql.
I ran into this testing a new beta release for IBConsole. I checked
this on 5 different servers (all windows2003) and 2 XP-machines, all
with the same result. I can create an EUA-enabled database with a
version 7.5.0 server but not with a version 7.5.1 server. After
creating I can also
switch EUA on and off with a version 7.5.1 server.
That is why I am wondering if there could be a bug in the database
creation with a 7.5.1 server.

Gelein van de Voorde.
I suppose there could be a problem, although I thought I had created an
EUA database with 7.5.1. Perhaps it was 7.5.0.
--
Bill Todd (TeamB)
 

Re:Store RDB$USERS failed

Should all I need to do is execute the following in isql:
create database 'foo.ib' with admin option;
This works for me with InterBase 7.5.1 SP1.
Gelein van de Voorde writes:
Quote
When I try to create a database with EUA-enabled on IB7.5 with sp1
(version 7.5.1.80) I get this message.
When I rollback the server to version 7.5.0.174 all works as it should.
Has anyone encountered the same experience?

Gelein van de Voorde.

 

Re:Store RDB$USERS failed

Quinn Wildman writes:
Quote
Should all I need to do is execute the following in isql:

create database 'foo.ib' with admin option;

This works for me with InterBase 7.5.1 SP1.

Gelein van de Voorde writes:
>When I try to create a database with EUA-enabled on IB7.5 with sp1
>(version 7.5.1.80) I get this message.
>When I rollback the server to version 7.5.0.174 all works as it
>should. Has anyone encountered the same experience?
>
>Gelein van de Voorde.
>
Quinn,
That is right, but the following failes:
create database 'foo.ib' user etc.
commit;
alter database add admin option;
Then I get an error message 'Store RDB$USERS failed'.
On a 7.5.0 server it works correct.
--
 

Re:Store RDB$USERS failed

Hmm, I get this error with 7.5.0 too. I have added this problem to our bug
tracking system for probable inclusion in the next release of InterBase.
Gelein van de Voorde writes:
Quote
>>

Quinn,

That is right, but the following failes:
create database 'foo.ib' user etc.
commit;
alter database add admin option;

Then I get an error message 'Store RDB$USERS failed'.

On a 7.5.0 server it works correct.