Annotation type | Annotation details |
---|---|
2 @message |
Authentification problem firebird.qa.plugin.ExecutionError: ISQL execution failed LOG DETAILS: 2024-05-09 21:54:22.839 2024-05-09 21:54:22.839 act = <firebird.qa.plugin.Action object at [hex]> 2024-05-09 21:54:22.839 test_role = <firebird.qa.plugin.Role object at [hex]> 2024-05-09 21:54:22.839 tmp_file = WindowsPath('R:/temp/qa/fbqa/test_11386/c6469_tmp.sql') 2024-05-09 21:54:22.840 capsys = <_pytest.capture.CaptureFixture object at [hex]> 2024-05-09 21:54:22.840 2024-05-09 21:54:22.840 @pytest.mark.version('>=4.0') 2024-05-09 21:54:22.840 @pytest.mark.platform('Windows') 2024-05-09 21:54:22.840 def test_1(act: Action, test_role: Role, tmp_file: Path, capsys): 2024-05-09 21:54:22.840 with act.trace(db_events=trace_win): 2024-05-09 21:54:22.840 > run_script(act, tmp_file) 2024-05-09 21:54:22.840 2024-05-09 21:54:22.840 tests\bugs\core_6469_test.py:191: 2024-05-09 21:54:22.840 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 2024-05-09 21:54:22.840 2024-05-09 21:54:22.840 act = <firebird.qa.plugin.Action object at [hex]> 2024-05-09 21:54:22.840 tmp_file = WindowsPath('R:/temp/qa/fbqa/test_11386/c6469_tmp.sql') 2024-05-09 21:54:22.840 2024-05-09 21:54:22.840 def run_script(act: Action, tmp_file: Path): 2024-05-09 21:54:22.840 #__tracebackhide__ = True 2024-05-09 21:54:22.840 THIS_COMPUTER_NAME = socket.gethostname() 2024-05-09 21:54:22.840 CURRENT_WIN_ADMIN = getpass.getuser() 2024-05-09 21:54:22.840 script = f""" 2024-05-09 21:54:22.840 set bail on; 2024-05-09 21:54:22.840 set list on; 2024-05-09 21:54:22.840 set echo on; 2024-05-09 21:54:22.840 connect '{act.db.dsn}' user '{act.db.user}' password '{act.db.password}'; 2024-05-09 21:54:22.840 grant tmp$r6469 to "{THIS_COMPUTER_NAME}\\{CURRENT_WIN_ADMIN}"; 2024-05-09 21:54:22.840 commit; 2024-05-09 21:54:22.840 2024-05-09 21:54:22.840 -- We have to use here "create mapping trusted_auth ... from any user to user" otherwise get 2024-05-09 21:54:22.841 -- Statement failed, SQLSTATE = 28000 /Missing security context for C:\\FBTESTING\\QA\\MISC\\C5887.FDB 2024-05-09 21:54:22.841 -- on connect statement which specifies COMPUTERNAME:USERNAME instead path to DB: 2024-05-09 21:54:22.841 create or alter mapping trusted_auth using plugin win_sspi from any user to user; 2024-05-09 21:54:22.841 2024-05-09 21:54:22.841 -- We have to use here "create mapping win_admins ... DOMAIN_ANY_RID_ADMINS" otherwise get 2024-05-09 21:54:22.841 -- Statement failed, SQLSTATE = 0P000 / Your attachment has no trusted role 2024-05-09 21:54:22.841 create or alter mapping win_admins using plugin win_sspi from predefined_group domain_any_rid_admins to role tmp$r6469; 2024-05-09 21:54:22.841 commit; 2024-05-09 21:54:22.841 2024-05-09 21:54:22.841 -- We have to GRANT ROLE, even to SYSDBA. Otherwise: 2024-05-09 21:54:22.841 -- Statement failed, SQLSTATE = 0P000 2024-05-09 21:54:22.841 -- Role TMP$R6469 is invalid or unavailable 2024-05-09 21:54:22.841 grant TMP$R6469 to sysdba; 2024-05-09 21:54:22.841 commit; 2024-05-09 21:54:22.841 show role; 2024-05-09 21:54:22.841 show grants; 2024-05-09 21:54:22.841 show mapping; 2024-05-09 21:54:22.841 2024-05-09 21:54:22.841 set autoddl off; 2024-05-09 21:54:22.841 commit; 2024-05-09 21:54:22.841 2024-05-09 21:54:22.841 -- Following management statements are taken from 2024-05-09 21:54:22.841 -- doc/sql.extensions/README.management_statements_psql.md: 2024-05-09 21:54:22.841 -- ######################################################## 2024-05-09 21:54:22.841 alter session reset; 2024-05-09 21:54:22.841 set session idle timeout 1800 second; 2024-05-09 21:54:22.842 set statement timeout 190 second; 2024-05-09 21:54:22.842 set bind of decfloat to double precision; 2024-05-09 21:54:22.842 set decfloat round ceiling; 2024-05-09 21:54:22.842 set decfloat traps to Division_by_zero; 2024-05-09 21:54:22.842 set time zone 'America/Sao_Paulo'; 2024-05-09 21:54:22.842 set role tmp$r6469; 2024-05-09 21:54:22.842 commit; 2024-05-09 21:54:22.842 2024-05-09 21:54:22.842 connect '{THIS_COMPUTER_NAME}:{act.db.db_path}' role tmp$r6469; 2024-05-09 21:54:22.842 2024-05-09 21:54:22.842 select mon$user,mon$role,mon$auth_method from mon$attachments where mon$attachment_id = current_connection; 2024-05-09 21:54:22.842 commit; 2024-05-09 21:54:22.842 2024-05-09 21:54:22.842 set trusted role; 2024-05-09 21:54:22.842 commit; 2024-05-09 21:54:22.842 2024-05-09 21:54:22.842 connect '{act.db.dsn}' user {act.db.user} password '{act.db.password}'; 2024-05-09 21:54:22.842 drop mapping trusted_auth; 2024-05-09 21:54:22.842 drop mapping win_admins; 2024-05-09 21:54:22.842 commit; 2024-05-09 21:54:22.842 """ 2024-05-09 21:54:22.842 tmp_file.write_text(script) 2024-05-09 21:54:22.842 2024-05-09 21:54:22.842 > act.isql(switches=['-n'], input_file = tmp_file, connect_db = False, credentials = False) 2024-05-09 21:54:22.842 E firebird.qa.plugin.ExecutionError: ISQL execution failed 2024-05-09 21:54:22.842 2024-05-09 21:54:22.842 tests\bugs\core_6469_test.py:185: ExecutionError 2024-05-09 21:54:22.843 ---------------------------- Captured stdout setup ---------------------------- 2024-05-09 21:54:22.843 Cached db: db-13.0-None-None-NONE.fdb [page_size=None, sql_dialect=None, charset='NONE' 2024-05-09 21:54:22.843 CREATE role: TMP$R6469 2024-05-09 21:54:22.843 -------------------------- Captured ISQL stdout call -------------------------- 2024-05-09 21:54:22.845 connect 'localhost:R:\temp\qa\fbqa\test_11386\test.fdb' user 'SYSDBA' password 'masterkey'; 2024-05-09 21:54:22.845 grant tmp$r6469 to "HOME-AUX2\zotov"; 2024-05-09 21:54:22.845 commit; 2024-05-09 21:54:22.845 2024-05-09 21:54:22.845 -- We have to use here "create mapping trusted_auth ... from any user to user" otherwise get 2024-05-09 21:54:22.845 -- Statement failed, SQLSTATE = 28000 /Missing security context for C:\FBTESTING\QA\MISC\C5887.FDB 2024-05-09 21:54:22.845 -- on connect statement which specifies COMPUTERNAME:USERNAME instead path to DB: 2024-05-09 21:54:22.845 create or alter mapping trusted_auth using plugin win_sspi from any user to user; 2024-05-09 21:54:22.845 2024-05-09 21:54:22.845 -- We have to use here "create mapping win_admins ... DOMAIN_ANY_RID_ADMINS" otherwise get 2024-05-09 21:54:22.845 -- Statement failed, SQLSTATE = 0P000 / Your attachment has no trusted role 2024-05-09 21:54:22.845 create or alter mapping win_admins using plugin win_sspi from predefined_group domain_any_rid_admins to role tmp$r6469; 2024-05-09 21:54:22.845 commit; 2024-05-09 21:54:22.845 2024-05-09 21:54:22.845 -- We have to GRANT ROLE, even to SYSDBA. Otherwise: 2024-05-09 21:54:22.845 -- Statement failed, SQLSTATE = 0P000 2024-05-09 21:54:22.845 -- Role TMP$R6469 is invalid or unavailable 2024-05-09 21:54:22.845 grant TMP$R6469 to sysdba; 2024-05-09 21:54:22.846 commit; 2024-05-09 21:54:22.846 show role; 2024-05-09 21:54:22.846 TMP$R6469 2024-05-09 21:54:22.846 2024-05-09 21:54:22.846 show grants; 2024-05-09 21:54:22.846 2024-05-09 21:54:22.846 /* Grant permissions for this database */ 2024-05-09 21:54:22.846 GRANT TMP$R6469 TO HOME-AUX2\zotov 2024-05-09 21:54:22.846 GRANT TMP$R6469 TO SYSDBA 2024-05-09 21:54:22.846 show mapping; 2024-05-09 21:54:22.846 TRUSTED_AUTH USING PLUGIN WIN_SSPI FROM ANY USER TO USER 2024-05-09 21:54:22.846 WIN_ADMINS USING PLUGIN WIN_SSPI FROM PREDEFINED_GROUP DOMAIN_ANY_RID_ADMINS TO ROLE TMP$R6469 2024-05-09 21:54:22.846 2024-05-09 21:54:22.846 set autoddl off; 2024-05-09 21:54:22.846 commit; 2024-05-09 21:54:22.846 2024-05-09 21:54:22.846 -- Following management statements are taken from 2024-05-09 21:54:22.846 -- doc/sql.extensions/README.management_statements_psql.md: 2024-05-09 21:54:22.846 -- ######################################################## 2024-05-09 21:54:22.846 alter session reset; 2024-05-09 21:54:22.846 set session idle timeout 1800 second; 2024-05-09 21:54:22.846 set statement timeout 190 second; 2024-05-09 21:54:22.846 set bind of decfloat to double precision; 2024-05-09 21:54:22.846 set decfloat round ceiling; 2024-05-09 21:54:22.846 set decfloat traps to Division_by_zero; 2024-05-09 21:54:22.846 set time zone 'America/Sao_Paulo'; 2024-05-09 21:54:22.846 set role tmp$r6469; 2024-05-09 21:54:22.846 commit; 2024-05-09 21:54:22.847 2024-05-09 21:54:22.847 connect 'HOME-AUX2:R:\temp\qa\fbqa\test_11386\test.fdb' role tmp$r6469; 2024-05-09 21:54:22.847 2024-05-09 21:54:22.847 select mon$user,mon$role,mon$auth_method from mon$attachments where mon$attachment_id = current_connection; 2024-05-09 21:54:22.847 2024-05-09 21:54:22.847 MON$USER HOME-AUX2\ZOTOV 2024-05-09 21:54:22.847 MON$ROLE TMP$R6469 2024-05-09 21:54:22.847 MON$AUTH_METHOD Mapped from Win_Sspi 2024-05-09 21:54:22.847 2024-05-09 21:54:22.847 2024-05-09 21:54:22.847 commit; 2024-05-09 21:54:22.847 2024-05-09 21:54:22.847 set trusted role; 2024-05-09 21:54:22.847 commit; 2024-05-09 21:54:22.847 2024-05-09 21:54:22.847 connect 'localhost:R:\temp\qa\fbqa\test_11386\test.fdb' user SYSDBA password 'masterkey'; 2024-05-09 21:54:22.847 drop mapping trusted_auth; 2024-05-09 21:54:22.847 drop mapping win_admins; 2024-05-09 21:54:22.847 commit; 2024-05-09 21:54:22.847 2024-05-09 21:54:22.847 -------------------------- Captured ISQL stderr call -------------------------- 2024-05-09 21:54:22.847 Use CONNECT or CREATE DATABASE to specify a database 2024-05-09 21:54:22.847 -------------------------- Captured stdout teardown --------------------------- 2024-05-09 21:54:22.847 DROP role: TMP$R6469 |
3 #text |
act = <firebird.qa.plugin.Action pytest object at [hex]> test_role = <firebird.qa.plugin.Role pytest object at [hex]> tmp_file = WindowsPath('R:/temp/qa/fbqa/test_11386/c6469_tmp.sql') capsys = <_pytest.capture.CaptureFixture pytest object at [hex]> @pytest.mark.version('>=4.0') @pytest.mark.platform('Windows') def test_1(act: Action, test_role: Role, tmp_file: Path, capsys): with act.trace(db_events=trace_win): > run_script(act, tmp_file) tests\bugs\core_6469_test.py:191: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ act = <firebird.qa.plugin.Action pytest object at [hex]> tmp_file = WindowsPath('R:/temp/qa/fbqa/test_11386/c6469_tmp.sql') def run_script(act: Action, tmp_file: Path): #__tracebackhide__ = True THIS_COMPUTER_NAME = socket.gethostname() CURRENT_WIN_ADMIN = getpass.getuser() script = f""" set bail on; set list on; set echo on; connect '{act.db.dsn}' user '{act.db.user}' password '{act.db.password}'; grant tmp$r6469 to "{THIS_COMPUTER_NAME}\\{CURRENT_WIN_ADMIN}"; commit; -- We have to use here "create mapping trusted_auth ... from any user to user" otherwise get -- Statement failed, SQLSTATE = 28000 /Missing security context for C:\\FBTESTING\\QA\\MISC\\C5887.FDB -- on connect statement which specifies COMPUTERNAME:USERNAME instead path to DB: create or alter mapping trusted_auth using plugin win_sspi from any user to user; -- We have to use here "create mapping win_admins ... DOMAIN_ANY_RID_ADMINS" otherwise get -- Statement failed, SQLSTATE = 0P000 / Your attachment has no trusted role create or alter mapping win_admins using plugin win_sspi from predefined_group domain_any_rid_admins to role tmp$r6469; commit; -- We have to GRANT ROLE, even to SYSDBA. Otherwise: -- Statement failed, SQLSTATE = 0P000 -- Role TMP$R6469 is invalid or unavailable grant TMP$R6469 to sysdba; commit; show role; show grants; show mapping; set autoddl off; commit; -- Following management statements are taken from -- doc/sql.extensions/README.management_statements_psql.md: -- ######################################################## alter session reset; set session idle timeout 1800 second; set statement timeout 190 second; set bind of decfloat to double precision; set decfloat round ceiling; set decfloat traps to Division_by_zero; set time zone 'America/Sao_Paulo'; set role tmp$r6469; commit; connect '{THIS_COMPUTER_NAME}:{act.db.db_path}' role tmp$r6469; select mon$user,mon$role,mon$auth_method from mon$attachments where mon$attachment_id = current_connection; commit; set trusted role; commit; connect '{act.db.dsn}' user {act.db.user} password '{act.db.password}'; drop mapping trusted_auth; drop mapping win_admins; commit; """ tmp_file.write_text(script) > act.isql(switches=['-n'], input_file = tmp_file, connect_db = False, credentials = False) E firebird.qa.plugin.ExecutionError: ISQL execution failed tests\bugs\core_6469_test.py:185: ExecutionError |
Full history of outcomes and elapsed time, ms:
|