Доброго дня, при переходе с Firebird 2.5 на 3.0 RC1 возникла следующая проблема:
При модификации пользователя, через API не получается установить нужный пароль.
Изначально данная проблема проявилась, когда для унификации подложили fbclient 3 для взаимодействия со всеми firebird базами (в том числе 2.5), на 2.5 выявилась следующая проблема - вместо указываемого пароля стал выставлятся user_name.
То, что удалось выловить при трассировке:
0 blr_version5,
1 blr_begin,
2 blr_message, 0, 15,0,
6 blr_long, 0,
8 blr_long, 0,
10 blr_short, 0,
12 blr_short, 0,
14 blr_short, 0,
16 blr_short, 0,
18 blr_short, 0,
20 blr_short, 0,
22 blr_short, 0,
24 blr_cstring, 129,1,
27 blr_cstring, 129,1,
30 blr_cstring, 65,0,
33 blr_cstring, 97,0,
36 blr_cstring, 97,0,
39 blr_cstring, 97,0,
42 bl...
0 ms
2016-02-09T12:44:52.1560 (4840:023F602C) ERROR AT jrd8_start_and_send
C:\PROGRAM FILES (X86)\FIREBIRD\FIREBIRD_2_5\SECURITY2.FDB (ATT_27, SYSDBA:NONE, NONE, TCPv4:127.0.0.1)
335544665 : violation of PRIMARY or UNIQUE KEY constraint "INTEG_2" on table "RDB$USERS"
335544382 : Problematic key value is ("RDB$USER_NAME" = 'RKG')
2016-02-09T12:44:52.1570 (4840:023F602C) ROLLBACK_TRANSACTION
C:\PROGRAM FILES (X86)\FIREBIRD\FIREBIRD_2_5\SECURITY2.FDB (ATT_27, SYSDBA:NONE, NONE, TCPv4:127.0.0.1)
(TRA_84, CONCURRENCY | WAIT | READ_WRITE)
0 ms, 3 write(s), 1 fetch(es), 1 mark(s)
2016-02-09T12:44:52.1570 (4840:023F602C) DETACH_DATABASE
C:\PROGRAM FILES (X86)\FIREBIRD\FIREBIRD_2_5\SECURITY2.FDB (ATT_27, SYSDBA:NONE, NONE, TCPv4:127.0.0.1)
2016-02-09T12:44:52.1570 (4840:023F602C) TRACE_FINI
SESSION_1 IBE_09.02.2016 12:44:36
2016-02-09T12:44:52.1620 (4840:023F6990) FAILED START_SERVICE
service_mgr, (Service 008EB8C8, SYSDBA, TCPv4:127.0.0.1, J:\CAPITAL\DEVELOP\CAP_5\TRUNK\Bin\admin.exe:5876)
"Add User"
-TRUSTED_SVC SYSDBA -ADD RKG -PW RKG
2016-02-09T12:44:52.1630 (4840:023F6990) DETACH_SERVICE
service_mgr, (Service 008EB8C8, SYSDBA, TCPv4:127.0.0.1, J:\CAPITAL\DEVELOP\CAP_5\TRUNK\Bin\admin.exe:5876)
2016-02-09T12:44:52.1630 (4840:023F6990) TRACE_FINI
SESSION_1 IBE_09.02.2016 12:44:36
2016-02-09T12:44:52.1970 (4840:023FDEB0) QUERY_SERVICE
service_mgr, (Service 003E85F0, SYSDBA, TCPv4:127.0.0.1, D:\temp\temp\IBExpert.exe:3796)
"Start Trace Session"
Send portion of the query:
set timeout: 1 Receive portion of the query:
retrieve as much of the server output as will fit in the supplied buffer
2016-02-09T12:44:53.1910 (4840:023F79C4) START_TRANSACTION
C:\PROGRAM FILES (X86)\FIREBIRD\FIREBIRD_2_5\SECURITY2.FDB (ATT_14, SYSDBA:NONE, NONE, <internal>)
(TRA_85, CONCURRENCY | WAIT | READ_ONLY)
2016-02-09T12:44:53.1920 (4840:023F79C4) ROLLBACK_TRANSACTION
C:\PROGRAM FILES (X86)\FIREBIRD\FIREBIRD_2_5\SECURITY2.FDB (ATT_14, SYSDBA:NONE, NONE, <internal>)
(TRA_85, CONCURRENCY | WAIT | READ_ONLY)
0 ms, 1 write(s), 1 fetch(es), 1 mark(s)
2016-02-09T12:44:53.1990 (4840:023FDEB0) QUERY_SERVICE
service_mgr, (Service 003E85F0, SYSDBA, TCPv4:127.0.0.1, D:\temp\temp\IBExpert.exe:3796)
"Start Trace Session"
Send portion of the query:
set timeout: 1 Receive portion of the query:
retrieve as much of the server output as will fit in the supplied buffer
2016-02-09T12:44:53.2240 (4840:023F6990) TRACE_INIT
SESSION_1 IBE_09.02.2016 12:44:36
2016-02-09T12:44:53.2240 (4840:023F6990) ATTACH_SERVICE
service_mgr, (Service 003E3BE8, SYSDBA, TCPv4:127.0.0.1, J:\CAPITAL\DEVELOP\CAP_5\TRUNK\Bin\admin.exe:5876)
2016-02-09T12:44:53.2350 (4840:023F602C) TRACE_INIT
SESSION_1 IBE_09.02.2016 12:44:36
2016-02-09T12:44:53.2350 (4840:023F602C) ATTACH_DATABASE
C:\PROGRAM FILES (X86)\FIREBIRD\FIREBIRD_2_5\SECURITY2.FDB (ATT_28, SYSDBA:NONE, NONE, TCPv4:127.0.0.1)
2016-02-09T12:44:53.2350 (4840:023F602C) START_TRANSACTION
C:\PROGRAM FILES (X86)\FIREBIRD\FIREBIRD_2_5\SECURITY2.FDB (ATT_28, SYSDBA:NONE, NONE, TCPv4:127.0.0.1)
(TRA_86, CONCURRENCY | WAIT | READ_WRITE)
2016-02-09T12:44:53.2370 (4840:023F602C) COMPILE_BLR
C:\PROGRAM FILES (X86)\FIREBIRD\FIREBIRD_2_5\SECURITY2.FDB (ATT_28, SYSDBA:NONE, NONE, TCPv4:127.0.0.1)
Похожим образом ведет себя и база 3.0 (по крайней мере по симптомам, что c новым паролем пользователь зайти не может, т.к. валится ошибка "
Your user name and password are not defined. Ask your database administrator to set up a Firebird login. ")
Может есть какие-то известные варианты, в каком направлении двигаться для поиска решения?
