Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error "Missing security context for .....\SECURITY3.FDB" [CORE4659] #4972

Closed
firebird-issue-importer opened this issue Jan 6, 2015 · 18 comments

Comments

@firebird-issue-importer
Copy link

firebird-issue-importer commented Jan 6, 2015

Submitted by: Imam Chalimi (virgonia)

Is related to CORE4607

Attachments:
bug_pic.jpg
bug_text.txt
attach_4659.zip
fb_snapshot.jpg

an Error "Missing security context for .....\SECURITY3.FDB" when create new user (create user ...) or select security table (select * from sec$users) on per database user configuration.

This error occurs on firebird 3 snapshot build Firebird-3.0.0.31514-0_Win32 - Firebird-3.0.0.31530-0_Win32 (last today snapshot).
on Firebird-3.0.0.31512-0_Win32 is fine.

** database.conf **
koko = D:\koko\koko_new.fb
{
SecurityDatabase = koko
}

** script **
C:\fb30.b1>isql /3064:koko -user sysdba -pass masterkey
Database: /3064:koko, User: sysdba
SQL> select * from sec$users;

SEC$USER_NAME SEC$FIRST_NAME SEC$MIDDLE_NAME
SEC$LAST_NAME SEC$ACTIVE SEC$ADMIN SEC$DE
SCRIPTION SEC$PLUGIN
=============================== ================================ ===============
================= ================================ ========== ========= ========
========= ===============================
Statement failed, SQLSTATE = 28000
Missing security context for C:\FB30.B1\SECURITY3.FDB
SQL> quit;

C:\fb30.b1>isql /3064:koko -user sysdba -pass masterkey
Database: /3064:koko, User: sysdba
SQL> create user test123 password '123';
Statement failed, SQLSTATE = 28000
Missing security context for C:\FB30.B1\SECURITY3.FDB
SQL>

Commits: 76df787 FirebirdSQL/fbt-repository@f4793f7

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 6, 2015

Modified by: Imam Chalimi (virgonia)

Attachment: bug_pic.jpg [ 12659 ]

Attachment: bug_text.txt [ 12660 ]

description: an Error "Missing security context for .....\SECURITY3.FDB" when create new user (create user ...) or select security table (select * from sec$users) on per database user configuration.

This error occurs on firebird 3 snapshot build Firebird-3.0.0.31514-0_Win32 - Firebird-3.0.0.31530-0_Win32 (last today snapshot).
on Firebird-3.0.0.31514-0_Win32 is fine.

** database.conf **
koko = D:\koko\koko_new.fb
{
SecurityDatabase = koko
}

** script **
C:\fb30.b1>isql /3064:koko -user sysdba -pass masterkey
Database: /3064:koko, User: sysdba
SQL> select * from sec$users;

SEC$USER_NAME SEC$FIRST_NAME SEC$MIDDLE_NAME
SEC$LAST_NAME SEC$ACTIVE SEC$ADMIN SEC$DE
SCRIPTION SEC$PLUGIN
=============================== ================================ ===============
================= ================================ ========== ========= ========
========= ===============================
Statement failed, SQLSTATE = 28000
Missing security context for C:\FB30.B1\SECURITY3.FDB
SQL> quit;

C:\fb30.b1>isql /3064:koko -user sysdba -pass masterkey
Database: /3064:koko, User: sysdba
SQL> create user test123 password '123';
Statement failed, SQLSTATE = 28000
Missing security context for C:\FB30.B1\SECURITY3.FDB
SQL>

=>

an Error "Missing security context for .....\SECURITY3.FDB" when create new user (create user ...) or select security table (select * from sec$users) on per database user configuration.

This error occurs on firebird 3 snapshot build Firebird-3.0.0.31514-0_Win32 - Firebird-3.0.0.31530-0_Win32 (last today snapshot).
on Firebird-3.0.0.31512-0_Win32 is fine.

** database.conf **
koko = D:\koko\koko_new.fb
{
SecurityDatabase = koko
}

** script **
C:\fb30.b1>isql /3064:koko -user sysdba -pass masterkey
Database: /3064:koko, User: sysdba
SQL> select * from sec$users;

SEC$USER_NAME SEC$FIRST_NAME SEC$MIDDLE_NAME
SEC$LAST_NAME SEC$ACTIVE SEC$ADMIN SEC$DE
SCRIPTION SEC$PLUGIN
=============================== ================================ ===============
================= ================================ ========== ========= ========
========= ===============================
Statement failed, SQLSTATE = 28000
Missing security context for C:\FB30.B1\SECURITY3.FDB
SQL> quit;

C:\fb30.b1>isql /3064:koko -user sysdba -pass masterkey
Database: /3064:koko, User: sysdba
SQL> create user test123 password '123';
Statement failed, SQLSTATE = 28000
Missing security context for C:\FB30.B1\SECURITY3.FDB
SQL>

security: Developers [ 10012 ] =>

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 9, 2015

Modified by: Imam Chalimi (virgonia)

Component: API / Client Library [ 10040 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 12, 2015

Modified by: @AlexPeshkoff

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 12, 2015

Commented by: @AlexPeshkoff

I can't reproduce a bug on build 3.0.0.31534. Please attach your *.conf files here.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 12, 2015

Commented by: Imam Chalimi (virgonia)

Many thanks for reponse,
I include the following attachment file (ZIP format)

Attached file content :

new reproduce with Firebird-3.0.0.31532-0_Win32 and Firebird-3.0.0.31512-0_Win32.

1. TEST_BUG.FB (case test), original path c:\fb30.b1
2. firebird.conf, server config
3. databases.conf , per database config
4. isql_31512_perdb_ok.jpg, reproduce on build 31512 with perdatabase config (OK)
5. isql_31532_perserver_ok.jpg, reproduce on build 31532 without perdatabase config (OK)
6. isql_31532_perdb_direct_bad.jpg, reproduce on build 31532 with perdatabase config & using direct path (BAD)
7. isql_31532_perdb_alias_bad.jpg, reproduce on build 31532 with perdatabase config & using alias (BAD)

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 12, 2015

Modified by: Imam Chalimi (virgonia)

Attachment: attach_4659.zip [ 12662 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 12, 2015

Commented by: Imam Chalimi (virgonia)

note / correction:
last reproduce above using Firebird-3.0.0.31534-0_Win32 not Firebird-3.0.0.31532-0_Win32.

error only occurs when using perdatabase configuration (SecurityDatabase=...)

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 13, 2015

Commented by: @hvlad

Patch is committed, please verify it using tomorrow's snapshot build

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 13, 2015

Modified by: @AlexPeshkoff

Version: 3.0 Beta 2 [ 10586 ]

Fix Version: 3.0 Beta 2 [ 10586 ]

Version: 3.0 Beta 1 [ 10332 ] =>

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 14, 2015

Commented by: Imam Chalimi (virgonia)

Still Error on snapshot build Firebird-3.0.0.31541-0_Win32

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 14, 2015

Modified by: Imam Chalimi (virgonia)

Attachment: fb_snapshot.jpg [ 12664 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 14, 2015

Commented by: @dyemanov

Fixed build number is 31543, please wait for the today's snapshot.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 14, 2015

Commented by: Imam Chalimi (virgonia)

Fixed on Firebird-3.0.0.31543 .. thanks

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 14, 2015

Modified by: @AlexPeshkoff

Link: This issue is related to CORE4607 [ CORE4607 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 14, 2015

Commented by: @AlexPeshkoff

A bug was introduced when implementing multiple user managers support

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 14, 2015

Modified by: @AlexPeshkoff

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Sep 23, 2015

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 18, 2016

Modified by: @pavel-zotov

status: Closed [ 6 ] => Closed [ 6 ]

QA Status: No test

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants