Issue Details (XML | Word | Printable)

Key: CORE-3411
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: Unassigned
Reporter: Олег Короткий
Votes: 0
Watchers: 4
Operations

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

Cannot attach to user manager with non-ascii symbols in password

Created: 25/Mar/11 01:25 AM   Updated: 25/Mar/11 08:07 AM
Component/s: Charsets/Collation, GSEC
Affects Version/s: 2.5.0, 2.5.1
Fix Version/s: None

Environment: tested with server on WinXP, Win2008 R2 SP1, firebird: Firebird-2.5.0.26074_1_Win32, Firebird-2.5.1.26240-0_Win32, Firebird-2.5.1.26240-0_x64. Server version Firebird-2.1.4.18393_0_Win32 is not affected by this bug.


 Description  « Hide
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

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Adriano dos Santos Fernandes added a comment - 25/Mar/11 02:04 AM
This is probably due to different code pages (OEM vs ANSI). Windows converts command line arguments from OEM to ANSI in the console.

Олег Короткий added a comment - 25/Mar/11 03:32 AM
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>

Alexander Peshkov added a comment - 25/Mar/11 08:07 AM
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.