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

GSTAT does not work using the localhost connection string [CORE959] #1362

Closed
firebird-automations opened this issue Oct 22, 2006 · 20 comments
Closed

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @dyemanov

Is related to QA37
Relate to CORE3687

Since v1.5, it's possible to run GSTAT using a pseudo-remote connection string (localhost:<path>). This feature is broken in v2.0. As there's a workaround (not using localhost in the connection string), this issue won't be fixed in v2.0. Instead, the patch will be included into a v2.0.1 point release.

Commits: 5e95368 6c3b555

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

Fix Version: 2.1 [ 10041 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Fix Version: 2.1 Alpha 1 [ 10150 ]

Fix Version: 2.1.0 [ 10041 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Link: This issue is related to QA37 [ QA37 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @pcisar

Fix verified, test added.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

@firebird-automations
Copy link
Collaborator Author

Commented by: @pmakowski

This bug is not fixed :
[philippe@mdv2007-32 ~]$ /opt/firebird/bin/isql -user SYSDBA -password masterkey
Use CONNECT or CREATE DATABASE to specify a database
SQL> CREATE DATABASE 'localhost:/home/firebird/test/b1.fdb';
SQL> exit;
[philippe@mdv2007-32 ~]$ /opt/firebird/bin/gstat -a localhost:/home/firebird/test/b1.fdb -user SYSDBA -password masterkey
Permission denied

[philippe@mdv2007-32 ~]$ ls -l /home/firebird/test/b1.fdb
-rw------- 1 firebird firebird 659456 jan 21 14:23 /home/firebird/test/b1.fdb

[philippe@mdv2007-32 ~]$ ls -l /opt/firebird/bin/gstat
-r-xr-xr-x 1 root root 242772 jan 13 15:19 /opt/firebird/bin/gstat*

Suggestion : create databases -rw-rw---- 1 firebird firebird
in this case if the DBA is member of the firebird group he could use gstat

@firebird-automations
Copy link
Collaborator Author

Modified by: @pmakowski

status: Closed [ 6 ] => Reopened [ 4 ]

resolution: Fixed [ 1 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Workflow: jira [ 11264 ] => Firebird [ 15044 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

Philippe, do you see any difference if gstat is running using a local connection string and a localhost-based one? (database should be created using the localhost-based connection string in both cases).

@firebird-automations
Copy link
Collaborator Author

Commented by: @pmakowski

no I don't see any difference
but since we are not created databases with -rw-rw---- 1 firebird firebird rights, but only rw to firebird user not group, you need to be root or firebird user to run gstat -a or -h and I think it is not a good point

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

GSTAT always required a file-level access to read the database header page. It cannot work remotely only. While I could agree that the feature could add some confusion as one could think that he's now connected remotely, this is not true. This feature just adds a special processing of the localhost-based connection strings to GSTAT. It was broken and then fixed back. So, although your comments make sense, I don't think they should prevent this ticket from being closed :-)

@firebird-automations
Copy link
Collaborator Author

Commented by: @pmakowski

ok
but then I will create another related to file permission and owner

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pmakowski

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

Link: This issue block progress on CORE3687 [ CORE3687 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

Link: This issue block progress on CORE3687 [ CORE3687 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

Link: This issue relate to CORE3687 [ CORE3687 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test => Done successfully

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