Error when duplicating user in different plug-ins
-------------------------------------------------
Key: CORE-4657
URL: http://tracker.firebirdsql.org/browse/CORE-4657
Project: Firebird Core
Issue Type: Bug
Affects Versions: 3.0 Beta 1
Environment: FB 3.0.0.31529 x64, Windows x64, ISQL
Reporter: Simonov Denis
Priority: Minor
Tried to create a SYSDBA Legacy_UserManager. In firebird.conf set UserManager =
Srp, Legacy_UserManager
In Srp SYSDBA already existed.
c:\Program Files\Firebird\Firebird_3_0>gsec -user sysdba
GSEC> add sysdba -pw masterkey -admin yes
GSEC> quit
SQL> connect 'localhost/3051:test' user 'sysdba' password 'masterkey';
Database: 'localhost/3051:test', User: sysdba
SQL> create user sysdba password 'masterkey' using plugin Legacy_UserManager;
Statement failed, SQLSTATE = 23000
add record error
-violation of PRIMARY or UNIQUE KEY constraint "INTEG_2" on table "PLG$USERS"
-Problematic key value is ("PLG$USER_NAME" = 'SYSDBA')
SQL> commit;
SQL> set list on;
SQL> select * from sec$users;
SEC$USER_NAME SYSDBA
SEC$FIRST_NAME <null>
SEC$MIDDLE_NAME <null>
SEC$LAST_NAME <null>
SEC$ACTIVE <true>
SEC$ADMIN <true>
SEC$DESCRIPTION <null>
SEC$PLUGIN Srp
SEC$USER_NAME SYSDBA
SEC$FIRST_NAME Sql
SEC$MIDDLE_NAME Server
SEC$LAST_NAME Administrator
SEC$ACTIVE <null>
SEC$ADMIN <true>
SEC$DESCRIPTION <null>
SEC$PLUGIN Legacy_UserManager
SQL> show version;
ISQL Version: WI-T3.0.0.31529 Firebird 3.0 Beta 2
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T3.0.0.31529
Firebird 3.0 Beta 2"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-T3.0.0.31529
Firebird 3.0 Beta 2/tcp (Den-PC)/P13:C"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-T3.0.0.31529
Firebird 3.0 Beta 2/tcp (Den-PC)/P13:C"
on disk structure version 12.0
SQL>
Ie upon user is created and it can even connect via Legacy_Auth, but for some
reason when creating Firebird gives an error.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Dive into the World of Parallel Programming! The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
