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

Jump to bottom

Firebird is validating initial chars in password only... [CORE3342] #3708

Closed
firebird-automations opened this issue Feb 9, 2011 · 7 comments
Closed

Firebird is validating initial chars in password only... [CORE3342] #3708

firebird-automations opened this issue Feb 9, 2011 · 7 comments
Labels
affect-version: 2.5.0 component: engine priority: major resolution: wontfix type: bug

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Andres Jaimes (ajaimes)

Is replaced by CORE1898

I am using isql to connect to some test databases and noticed that it does not matter what you type on the password field as long as it starts with the word 'masterkey' will let you connect to a database.

Here are some examples:

SQL> connect 'c:\test.dbf' user 'sysdba' password '';
Statement failed, SQLSTATE = 28000
Your user name and password are not defined. Ask your database administrator to set up a Firebird login.

SQL> connect 'c:\test.dbf' user 'sysdba' password 'a';
Statement failed, SQLSTATE = 28000
Your user name and password are not defined. Ask your database administrator to set up a Firebird login.

SQL> connect 'c:\test.dbf' user 'sysdba' password 'masterk';
Statement failed, SQLSTATE = 28000
Your user name and password are not defined. Ask your database administrator to set up a Firebird login.

SQL> connect 'c:\test.dbf' user 'sysdba' password 'masterkey3';
Server version:
WI-V2.5.0.26074 Firebird 2.5
WI-V2.5.0.26074 Firebird 2.5/XNet (MXQU1004607DT)/P12
WI-V2.5.0.26074 Firebird 2.5/XNet (MXQU1004607DT)/P12
Database: 'c:\test.dbf', User: sysdba

SQL> connect 'c:\test.dbf' user 'sysdba' password 'masterkeyfasdfasfas';
Server version:
WI-V2.5.0.26074 Firebird 2.5
WI-V2.5.0.26074 Firebird 2.5/XNet (MXQU1004607DT)/P12
WI-V2.5.0.26074 Firebird 2.5/XNet (MXQU1004607DT)/P12
Database: 'c:\test.dbf', User: sysdba
@firebird-automations
Copy link
Collaborator Author

Commented by: Andres Jaimes (ajaimes)

The command used to create this database was:

connect 'c:\test.dbf' user 'sysdba' password 'masterkey';

Right now, the database is empty (no tables, no nothing)

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

When you start to read documentation, you'll see that only 8 chars of password is matters

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Won't Fix [ 2 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @AlexPeshkoff

Will be fixed in FB3

@firebird-automations
Copy link
Collaborator Author

Commented by: Umberto Masotti (umasotti)

So it's not closed, but depends on CORE1898

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Link: This issue is replaced by CORE1898 [ CORE1898 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
affect-version: 2.5.0 component: engine priority: major resolution: wontfix type: bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@firebird-automations