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

Jump to bottom

Permission error message is displayed when the Metadata script is extracted using ISQL [CORE6118] #6367

Closed
firebird-automations opened this issue Aug 10, 2019 · 7 comments
Closed

Permission error message is displayed when the Metadata script is extracted using ISQL [CORE6118] #6367

firebird-automations opened this issue Aug 10, 2019 · 7 comments
Assignees
@AlexPeshkoff
Labels
affect-version: 3.0.4 component: isql priority: major resolution: wontfix type: bug

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @luronumen

Attachments:
ERROR.png

ACTUAL RESULT
The following error message is displayed when the Metadata script is extracted using ISQL:

Statement failed, SQLSTATE = 28000
no permission for read-write access to database C:\PROGRAM FILES\FIREBIRD\FIREBIRD_3_0\SECURITY3.FDB
-IProvider::attachDatabase failed when working with CREATE DATABASE grants

EXPECTED RESULTS
No error message should be displayed when the Metadata script is extracted using ISQL

STEPS TO REPRODUCE THE ISSUE
- Install the Firebird 3.0.4 without define a SYSDBA password
- Setup the SYSDBA password after the installation using the following command:
ALTER CURRENT USER SET PASSWORD 'SYSDBAPWD' USING PLUGIN LEGACY_USERMANAGER;
- Create a Firebird 3.0.4 database using the SYSDBA user and than add some tables on it
- Restart the Firebird 3.0.4 using the followong command:
net stop FirebirdServerDefaultInstance
net start FirebirdServerDefaultInstance
- Try to extract the Metadata script using the following command:
"%ProgramFiles%\Firebird\Firebird_3_0\isql.exe" -user SYSDBA -password SYSDBAPWD -extract -output "FB30_DDL.SQL" "<Path or alias to database>"
@firebird-automations
Copy link
Collaborator Author

Modified by: @luronumen

Attachment: ERROR.png [ 13370 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @luronumen

Retest result on Firebird 3.0.5.33220 (Official Firebird 3.0.5): - FAILED (#⁠motorolablocker)

@firebird-automations
Copy link
Collaborator Author

Commented by: @AlexPeshkoff

You are using embedded database access. For embedded access to work all involved database files should have enough access rights from OS point of view. There can be 2 ways to fix an issue:
- ask your sysadmin to grant you RW access to security database;
- access database via local server (for example add xnet:// prefix in the beginning of database name).

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

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

resolution: Won't Fix [ 2 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

@firebird-automations
Copy link
Collaborator Author

Commented by: @luronumen

Hi Alexander,

Thank you very much for your bug debug. I just tested your suggestions and I confirmed that they all work perfectly.

I just updated our databases metadata extract scripts according to your suggestions.

Now I have only the bug CORE6147 blocking the migration of my company (Motorola) databases to Firebird 3.0.x. Could you please take a look at it when you have time?

Best Regards,
Luciano

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

@AlexPeshkoff AlexPeshkoff

Labels
affect-version: 3.0.4 component: isql priority: major resolution: wontfix type: bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@AlexPeshkoff @firebird-automations