SSH access for user

[hendry]

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.

[BeNe]

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

[hendry]

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?

[RatS]

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.

[BeNe]

Correction (uv -> vu)

Code:

usermod -s /bin/bash vu200x

But i hope you know that you do there

Greez BeNe

[hendry]

BeNe Wrote:Correction (uv -> vu)

Code:

usermod -s /bin/bash vu200x

But i hope you know that you do there

Greez BeNe

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

[hendry]

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

[RatS]

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.

[Zothos]

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.

[BeNe]

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