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

Properties of user created in Legacy_UserManager padded with space up to 10 character [CORE4430] #4750

Closed
firebird-automations opened this issue May 15, 2014 · 6 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @mrotteveel

A test in Jaybird (org.firebirdsql.management.TestUserManager) adds a user through the services API and then retrieves the created user to compare the properties. When this test is run against Firebird 3.0 the username, firstname, middlename and lastname properties are padded with spaces (0x20) up to a length of 10 (no padding occurs if the actual value is longer). This only happens when the usermanager is Legacy_UserManager. The properties are not padded when the Srp manager is configured in firebird.conf. Padding also doesn't occur with Firebird 2.5 and earlier.

I am not sure if the problem is with creating or with listing the users, but it also occurs when the user has been created with a CREATE USER statement instead of the service API.

Currently tests on Jaybird use Legacy_UserManager because it doesn't support the new protocol yet.

Note: I have seen the behavior at least since 3.0 Alpha 2 (AFAIR it didn't occur with Alpha 1, but I am not 100%sure), but I didn't have time to investigate closely until today. I tested with the snapshot of today (3.0.0.31135).

Commits: 7108452 FirebirdSQL/jaybird@6182925 FirebirdSQL/fbt-repository@af2c2a4 FirebirdSQL/fbt-repository@9375a59

====== Test Details ======

Confirmed padded output in WI-T3.0.0.30809 Firebird 3.0 Alpha 2.

@firebird-automations
Copy link
Collaborator Author

Modified by: @mrotteveel

summary: Properties of user created in Legacy_UserManager padded with space upto 10 character => Properties of user created in Legacy_UserManager padded with space up to 10 character

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @AlexPeshkoff

I've changed format of that fields to be like in 2.5, therefore fresh security database should be used - fix primarily depends not upon code, but upon sec.db format

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

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

resolution: Fixed [ 1 ]

Fix Version: 3.0 Beta 1 [ 10332 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: Done successfully

Test Details: Confirmed padded output in WI-T3.0.0.30809 Firebird 3.0 Alpha 2.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment