Server Fault Asked by Bastien Abadie on December 23, 2021
I have a Postgresql database full of user accounts, and i would like to allow these user to access a server through ssh, using only public keys authentification.
So far, i have setup these parts on an Ubuntu Server:
Is there a simpler way to go around this problem ? I have issues setting up correctly the nss configuration (lack of documentation & logs).
Thanks for your time & help.
I would dump your users from DB into LDAP and load it into local LDAP. You can automate updates easily. This would make your OS to query users from LDAP and it would be much more portable - libnss-pgsql2 is not on every UNIX-like system, if you would ever like to move out from Linux. You never know ;)
Answered by Jiri B on December 23, 2021
you can use ssh tunneling to allow user to connect to your database. such as
ssh -L local_port:IP address/hostname:server_port user@IP address/hostname.
here user will be OS user so it best to provide postgres superuser to connect.
But keep in mind that the postgresql database server must be on that server.
once done u can connect using simple psql command as
psql -h hostname/IP address -p port -U user -d database
Answered by user234918 on December 23, 2021
Get help from others!
Recent Answers
Recent Questions
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP