-
Notifications
You must be signed in to change notification settings - Fork 627
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
SSH file is not able to read and change when the server is shared on server-mode #7306
Comments
Hi @nabe1653 |
HI, @anilsahoo20 , thank you for checking. That SSH DB and server-mode pgadmin aree office servers so I can not share the details. Sample code repo (for pgadmin and ssh server): https://github.com/nabe1653/pgadmin4-ssh-sample Screen recording is below:
2, Trying ssh connection from shared-user
|
I am unable to reproduce it with the local setup. |
@nabe1653
Also please turn on logging by specifying log level in environment variable -
However I am able to reproduce the 2nd issue mentioned in 2nd scenario i.e. ssh info can not be updated of shared server by shared user. I will be fixing it. |
A1. Folder permissions The permissions visible from within the container have already been written in the sample repo: https://github.com/nabe1653/pgadmin4-ssh-sample This is rocky server's permissions that reported at first: #### docker runs as root user and 5050 is pgadmin user in the container
# ls -al bind/storage/
total 8
drwx------ 2 5050 root 55 Mar 27 11:42 .
drwxr-xr-x 4 root root 101 May 9 14:52 ..
-rw-r--r-- 1 root root 14 Mar 21 16:18 .gitkeep
-rw-r--r-- 1 5050 root 419 Mar 21 14:16 secret_key
#### Folder itself has been changed uid as I mentionded in sample repo.
#### Of cause file itself has been uploaded from pgadmin page's file manager so 644 is default. This is of windows to reproduce to report: > ls .\bind\storage\
Mode LastWriteTime Length Name
---- ------------- ------ ----
-a--- 2024/04/01 11:35 419 pg-test
> (Get-Acl ./bind/storage/).Access | select IdentityReference
IdentityReference
-----------------
BUILTIN\Administrators
BUILTIN\Administrators
NT AUTHORITY\SYSTEM
NT AUTHORITY\SYSTEM
NT AUTHORITY\Authenticated Users
NT AUTHORITY\Authenticated Users
BUILTIN\Users
BUILTIN\Users A2. Set PGADMIN_CONFIG_CONSOLE_LOG_LEVEL I tried to change log level but I couldn't find output log, it has only network error about 401. |
…les available in the shared storage.pgadmin-org#7306
…les available in the shared storage.pgadmin-org#7306
…les available in the shared storage.pgadmin-org#7306
…les available in the shared storage.pgadmin-org#7306
…ntity files available in the shared storage.pgadmin-org#7306" This reverts commit a9997a7.
…les available in the shared storage.pgadmin-org#7306
…les available in the shared storage.pgadmin-org#7306
…les available in the shared storage.pgadmin-org#7306
…les available in the shared storage.pgadmin-org#7306
…les available in the shared storage.pgadmin-org#7306
… identity files from a shared storage. #7306
…ntity files available in the shared storage.pgadmin-org#7306" This reverts commit b1d12cb.
…ntity files available in the shared storage.pgadmin-org#7306" This reverts commit b1d12cb.
…les available in the shared storage.pgadmin-org#7306
…ntity files available in the shared storage.pgadmin-org#7306" This reverts commit a9997a7.
Issue fixed. Verified on snapshot build and docker snapshot image. Env: |
I've updated docker-image to v8.9 on reported server then both are resolved. Thank you so much! |
Please note that security bugs or issues should be reported to [email protected].
Describe the bug
SSH file is not able to read and change when the server is shared therefore shared server is not abled to connect from other users.
e.g.
No password or public key available!
error when use as it. (maybe due to failed to read ssh file.)It failed too even if UserA uses secret key from "SHARED_STORAGE" at 1st step. UserB can downalod it from storage-manager but failed to connect.
To Reproduce
Setup docker server as server-mode
Create docker container with
config_local.py
and binding volume.Change bind folder permission as same as container uid
Create shared user and register ssh server on UserA
Try to connect "Server1" from UserB
Expected behavior
Anyway, I wish share ssh-tunneling server info.
Error message
No password or public key available!
Screenshots
Desktop (please complete the following information):
Additional context
The text was updated successfully, but these errors were encountered: