Issue Details (XML | Word | Printable)

Key: CORE-6115
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: Unassigned
Reporter: John Franck
Votes: 0
Watchers: 0

If you were logged in you would be able to see more operations.
Firebird Core

Problem with passwords when creating a batch of users

Created: 05/Aug/19 12:24 PM   Updated: 05/Aug/19 12:47 PM
Component/s: Engine
Affects Version/s: 3.0.4
Fix Version/s: None

File Attachments: 1. Zip Archive BUG FireBird User Login (1.61 MB)
2. File users_long.sql (146 kB)
3. File users_short.sql (120 kB)

Environment: CentOS 7 64bit (tested on two very different VMs, a powerful VMWare production server and a desktop VirtualBox test VM)

QA Status: No test

 Description  « Hide
I've generated a script for creating a batch (~3000) of users on my Firebird installation. Some of them have had difficulties logging in (Your user name and password are not defined).

After investigation it appears like their passwords were not defined. This conclusion is because creating the same user again results in "violation of PRIMARY or UNIQUE KEY constraint "INTEG_5" on table "PLG$SRP" " (so the user is there) and an "alter user USERNAME password 'mypassword' " solves the login problem.

The script is as simple as:
create user U0001 password 'mypass0123';
create user U0002 password 'mypass0123';
create user U0003 password 'mypass0123';
create user U0004 password 'mypass0123';
create user U0005 password 'mypass0123';
create user U0006 password 'mypass0123';
create user U0007 password 'mypass0123';
create user U0008 password 'mypass0123';
create user U0009 password 'mypass0123';
create user U0010 password 'mypass0123';
(this for a lot of users)

Statistically more or less every hundred users created there's one with this kind of problem. It seems (but I've not done extensive testing) that with longer usernames there's more chance that the problem arises (more frequent users with login problems).

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
John Franck added a comment - 05/Aug/19 12:28 PM
These are two scripts I've used to test this issue, one with short usernames and another with longer ones. The longer ones resulted in more users not being able to login until password is set again with "alter user ... password ...".

Dmitry Yemanov added a comment - 05/Aug/19 12:36 PM
Looks like a duplicate for CORE-6038.

John Franck added a comment - 05/Aug/19 12:43 PM
I've attached a Delphi program to test the login capability of a list of users. Set the server host name or IP, database name and password (for this purpose it must be the same for all users), copy all usernames in the first memo box and click "Test users", the ones with problems will be copied in the second memo box.

John Franck added a comment - 05/Aug/19 12:47 PM
Oh, yes maybe it's the same as, didn't find this issue when searching for my problem. So it should be fixed in 3.0.5, good news.