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

Cannot attach to user manager with non-ascii symbols in password [CORE3411] #3774

Open
firebird-automations opened this issue Mar 25, 2011 · 3 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Олег Короткий (олег короткий)

When I create a new user with password containig non-ascii symbols(like cyrillic), I can attach to database with this password, but I can't change this password using gsec:
>gsec -add test -pw тест -user sysdba -pass masterkey

>gsec -modify test -pw 777 -user test -pass тест
use gsec -? to get help
Your user name and password are not defined. Ask your database administrator to
set up a Firebird login.
unable to open database

>gsec -modify sysdba -pw тест -user sysdba -pass masterkey

>gsec -modify sysdba -pw 777 -user sysdba -pass тест
use gsec -? to get help
Your user name and password are not defined. Ask your database administrator to
set up a Firebird login.
unable to open database

@firebird-automations
Copy link
Collaborator Author

Commented by: @asfernandes

This is probably due to different code pages (OEM vs ANSI). Windows converts command line arguments from OEM to ANSI in the console.

@firebird-automations
Copy link
Collaborator Author

Commented by: Олег Короткий (олег короткий)

But it's working properly with Firebird-2.1.4.18393_0_Win32 SS, so in firebird 2.5 it's been broken?
I've tested with gsec and IBExpert, results the same, 2.1 working good, 2.5 - throws an error.

Firebird-2.1.4.18393_0_Win32:

D:\bin\firebird\bin>gsec -add test -pw тест -user sysdba -pass masterkey

D:\bin\firebird\bin>gsec -modify test -pw 777 -user test -pass тест

D:\bin\firebird\bin>

@firebird-automations
Copy link
Collaborator Author

Commented by: @AlexPeshkoff

Could not it happen due to the fact that password is converted to and
from UTF-8 when attaching to service, but not - when starting user_mod
service from gsec? At the first glance looks like very possible reason
for a bug with non-ascii passwords.

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

No branches or pull requests

1 participant