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
Comments
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). ** database.conf ** ** script ** SEC$USER_NAME SEC$FIRST_NAME SEC$MIDDLE_NAME C:\fb30.b1>isql /3064:koko -user sysdba -pass masterkey => 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). ** database.conf ** ** script ** SEC$USER_NAME SEC$FIRST_NAME SEC$MIDDLE_NAME C:\fb30.b1>isql /3064:koko -user sysdba -pass masterkey security: Developers [ 10012 ] => |
Modified by: Imam Chalimi (virgonia)Component: API / Client Library [ 10040 ] |
Modified by: @AlexPeshkoffassignee: Alexander Peshkov [ alexpeshkoff ] |
Commented by: @AlexPeshkoff I can't reproduce a bug on build 3.0.0.31534. Please attach your *.conf files here. |
Commented by: Imam Chalimi (virgonia) Many thanks for reponse, 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 |
Modified by: Imam Chalimi (virgonia)Attachment: attach_4659.zip [ 12662 ] |
Commented by: Imam Chalimi (virgonia) note / correction: error only occurs when using perdatabase configuration (SecurityDatabase=...) |
Commented by: @hvlad Patch is committed, please verify it using tomorrow's snapshot build |
Modified by: @AlexPeshkoffVersion: 3.0 Beta 2 [ 10586 ] Fix Version: 3.0 Beta 2 [ 10586 ] Version: 3.0 Beta 1 [ 10332 ] => |
Commented by: Imam Chalimi (virgonia) Still Error on snapshot build Firebird-3.0.0.31541-0_Win32 |
Modified by: Imam Chalimi (virgonia)Attachment: fb_snapshot.jpg [ 12664 ] |
Commented by: @dyemanov Fixed build number is 31543, please wait for the today's snapshot. |
Commented by: Imam Chalimi (virgonia) Fixed on Firebird-3.0.0.31543 .. thanks |
Modified by: @AlexPeshkoff |
Commented by: @AlexPeshkoff A bug was introduced when implementing multiple user managers support |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
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
The text was updated successfully, but these errors were encountered: