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

Access Violation when trying to add an user that already exists [CORE2728] #3123

Closed
firebird-automations opened this issue Nov 3, 2009 · 16 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Daniel (defcon1_es)

Attachments:
screenshot-1.jpg
screenshot-2.jpg

GSEC gives an Access Violation when trying to add an user that already exists, instead of an DBKey violation.

This doesn't happen with 1.5 version.

Commits: 3a9931e dde6cc6 34d79c9

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @AlexPeshkoff

Damiel, your bugreport was definitely useful - I've found problems in 2.5 and 3.0. But what about 2.1 - failed to reproduce. Please describe better what did you do to have AV.

@firebird-automations
Copy link
Collaborator Author

Commented by: @AlexPeshkoff

Daniel commented on CORE2728:
------------------------------

Open windows command prompt and type this:

CD\
CD Archivos de Programa\FireBird\Firebird_2_1\bin
SET ISC_USER=SYSDBA
SET ISC_PASSWORD=masterkey
GSEC
ADD DANIEL -PW DANIEL -> it works at first time
ADD DANIEL -PW DANIEL -> Second time, gives an Access violation

@firebird-automations
Copy link
Collaborator Author

Commented by: @AlexPeshkoff

Daniel, just to make sure - do you have correct fbclient in your path?

@firebird-automations
Copy link
Collaborator Author

Commented by: @AlexPeshkoff

No response from author, could not reproduce in mentioned version 2.1 - therefore closing.
Marked as 'Fixed' cause was reproduced in 2.5 and 3.0.

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

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

resolution: Fixed [ 1 ]

Fix Version: 2.5 RC2 [ 10372 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: Daniel (defcon1_es)

Attachment: screenshot-1.jpg [ 11566 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: Daniel (defcon1_es)

I tried many times last few weeks to attach the screenshot, but I was unable to login FireBird Tracker.

See the screenshot.

@firebird-automations
Copy link
Collaborator Author

Commented by: @AlexPeshkoff

Daniel, I see you do have this bug. But I've asked not about gsec versions, but about fbclient version. The simplest way to make sure is use isql (from same place where gsec faults):

#⁠ ./isql -user sysdba -pas masterkey -z localhost:employee

Output will be:

ISQL Version: LI-V2.0.5.13206 Firebird 2.0
Server version:
LI-T3.0.0.27582 Firebird 3.0 Unstable
LI-T3.0.0.27582 Firebird 3.0 Unstable/tcp (fbs2)/P10
LI-V2.0.5.13206 Firebird 2.0/tcp (fbs2)/P10
Database: localhost:employee, User: sysdba

If fbclient is OK, the only remaining thing is to ask you to provide remote access to the box where it's reproducible - none of developers were able to reproduce the bug.

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

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

resolution: Fixed [ 1 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: Daniel (defcon1_es)

Attachment: screenshot-2.jpg [ 11567 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @AlexPeshkoff

Daniel, can you try 2.1 snapshot build?

@firebird-automations
Copy link
Collaborator Author

Commented by: Anderson Farias (afarias)

Could not reproduce with FB 2.1.3, SS, 32bits on Windows 7 64

gsec version WI-V2.1.3.18185 Firebird 2.1

GSEC> add USER_NAME -pw 123456
An error occurred while attempting to add the user.
violation of PRIMARY or UNIQUE KEY constraint "INTEG_2" on table "RDB$USERS"

ISQL Version: WI-V2.1.3.18185 Firebird 2.1
Server version:
WI-V2.1.3.18185 Firebird 2.1
WI-V2.1.3.18185 Firebird 2.1/tcp (Primus)/P11
WI-V2.1.3.18185 Firebird 2.1/tcp (Primus)/P11

regards,

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

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

resolution: Cannot Reproduce [ 5 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 3.0 Alpha 1 [ 10331 ] =>

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

2 participants