ispCP - Board - Support
SSH access for user - Printable Version

+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Development Area (/forum-1.html)
+--- Forum: General discussion (/forum-11.html)
+--- Thread: SSH access for user (/thread-1025.html)

Pages: 1 2 3 4

SSH access for user - hendry - 07-23-2007 05:02 PM

One of my users needs a SSH login to the server so that he can use a ODBC connection to the database. Who can explain me how to do this? I don't want him to access the filesystem, he only needs the SSH to make a secure connection to the server so he can start the ODBC connection from his workstation to the MySQL database.

RE: SSH access for user - BeNe - 07-23-2007 05:12 PM

I see there no way!
A SSH Access is a SSH Access. I don´t know about to disable this Option.

But what abut JODBC with JAVA or via PHP ?

Greez BeNe

RE: SSH access for user - hendry - 07-23-2007 05:19 PM

BeNe Wrote:I see there no way!
A SSH Access is a SSH Access. I don´t know about to disable this Option.

But what abut JODBC with JAVA or via PHP ?

Greez BeNe

Hmm.. ok, but is there a way then to create a user with the same rights as the VU200x id of his website? If so, how to do that?

RE: SSH access for user - RatS - 07-23-2007 06:37 PM

The vu-Users have no SSH access because their shell is set to /bin/false.
If on of them needs SSH you can set it via
Code:
usermod -s /bin/bash vu200x
Hope I can help you.

RE: SSH access for user - BeNe - 07-23-2007 06:40 PM

Correction (uv -> vu)
Code:
usermod -s /bin/bash vu200x

But i hope you know that you do there Rolleyes

Greez BeNe

RE: SSH access for user - hendry - 07-23-2007 07:47 PM

BeNe Wrote:Correction (uv -> vu)
Code:
usermod -s /bin/bash vu200x

But i hope you know that you do there Rolleyes

Greez BeNe
I'm hoping the only thing the user can is killing his own website/ settings and not the server Wink

RE: SSH access for user - hendry - 07-23-2007 08:35 PM

what password is the user using? Is this the password set in the control panel for the domainname?

RE: SSH access for user - RatS - 07-23-2007 08:50 PM

hendry Wrote:what password is the user using? Is this the password set in the control panel for the domainname?

No there is no password set (/bin/false doesn't need one in my mind ... correct me if I'm wrong). I'm not sure if a home-dir is set. You have to try around a bit.
Code:
man adduser
is your best friend.

RE: SSH access for user - Zothos - 07-23-2007 11:34 PM

if the user has a shell account. He is able to kill the server.

Normaly all servers accept a strg + alt + entf by default..... And thats only the minor things which can happen.

My cosutomers dont get a shell account. And if they cancel because of this fact im not crying about them.

RE: SSH access for user - BeNe - 07-23-2007 11:38 PM

Only for ODBC - this is hard.
You could also try JDBC or PHP as i said.
May - a OpenVPN Newtwork so that he can connect local to the Server or something else....

Greez BeNe