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

ISQL: presence of credentials ('-user SYSDBA -pas masterkey') causes "Different logins in connect and attach packets - client library error" if new DB is created by privileged user #8385

Open
pavel-zotov opened this issue Jan 13, 2025 · 0 comments

Comments

@pavel-zotov
Copy link

Consider following script:

set echo on;
set bail on;
shell if exist C:\temp\tmp4test.fdb del C:\temp\tmp4test.fdb;
show version;
create or alter user tmp_boss password '123';
commit;
grant create database to user tmp_boss;
show users;
commit;

create database 'localhost:C:\temp\tmp4test.fdb' user tmp_boss password '123';
drop database;
quit;

Run it:
C:\FB\60SS\isql /:employee -i C:\FBTESTING\qa\firebird-qa\tests\bugs\tmp1.sql -user sysdba -pas masterkey

Output since 6.0.0.570 will be:

set bail on;
shell if exist C:\temp\tmp4test.fdb del C:\temp\tmp4test.fdb;
show version;
ISQL Version: WI-T6.0.0.570 Firebird 6.0 Initial
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T6.0.0.570 Firebird 6.0 Initial"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-T6.0.0.570 Firebird 6.0 Initial/tcp (PZ)/P19:C"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-T6.0.0.570 Firebird 6.0 Initial/tcp (PZ)/P19:C"
on disk structure version 14.0
create or alter user tmp_boss password '123';
commit;
grant create database to user tmp_boss;
show users;
Users in the database
  2 #SYSDBA
  0  TMP_BOSS
commit;

create database 'localhost:C:\temp\tmp4test.fdb' user tmp_boss password '123';
Statement failed, SQLSTATE = 28000
Your user name and password are not defined. Ask your database administrator to set up a Firebird login.
-Different logins in connect and attach packets - client library error

Builds 5.x and up to 6.0.0.565 complete normally:

create or alter user tmp_boss password '123';
commit;
grant create database to user tmp_boss;
show users;
Users in the database
  2 #SYSDBA
  0  TMP_BOSS
commit;

create database 'localhost:C:\temp\tmp4test.fdb' user tmp_boss password '123';
drop database;
quit;
@mrotteveel mrotteveel changed the title ISQL: presense of credentials ('-user SYSDBA -pas masterkey') causes "Different logins in connect and attach packets - client library error" if anew DB is created by privileged user ISQL: presence of credentials ('-user SYSDBA -pas masterkey') causes "Different logins in connect and attach packets - client library error" if new DB is created by privileged user Jan 13, 2025
pavel-zotov added a commit to FirebirdSQL/firebird-qa that referenced this issue Jan 13, 2025
…entials = False' to prevent ISQL from using '-USER ... -PASS ...'. IMO, this is bug; see FirebirdSQL/firebird#8385
pavel-zotov added a commit to FirebirdSQL/firebird-qa that referenced this issue Jan 13, 2025
…porary ?) 'credentials = False' to prevent ISQL from using '-USER ... -PASS ...'. IMO, this is bug; see FirebirdSQL/firebird#8385
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant