Current time: 11-13-2024, 05:31 PM Hello There, Guest! (LoginRegister)


Post Reply 
SSH access for user
Author Message
hendry Offline
Junior Member
*

Posts: 77
Joined: Jul 2007
Reputation: 0
Post: #1
SSH access for user
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.
07-23-2007 05:02 PM
Visit this user's website Find all posts by this user Quote this message in a reply
BeNe Offline
Moderator
*****
Moderators

Posts: 5,899
Joined: Jan 2007
Reputation: 68
Post: #2
RE: SSH access for user
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
07-23-2007 05:12 PM
Visit this user's website Find all posts by this user Quote this message in a reply
hendry Offline
Junior Member
*

Posts: 77
Joined: Jul 2007
Reputation: 0
Post: #3
RE: SSH access for user
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?
07-23-2007 05:19 PM
Visit this user's website Find all posts by this user Quote this message in a reply
RatS Offline
Project Leader
******

Posts: 1,854
Joined: Oct 2006
Reputation: 17
Post: #4
RE: SSH access for user
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.
(This post was last modified: 07-23-2007 08:48 PM by RatS.)
07-23-2007 06:37 PM
Visit this user's website Find all posts by this user Quote this message in a reply
BeNe Offline
Moderator
*****
Moderators

Posts: 5,899
Joined: Jan 2007
Reputation: 68
Post: #5
RE: SSH access for user
Correction (uv -> vu)
Code:
usermod -s /bin/bash vu200x

But i hope you know that you do there Rolleyes

Greez BeNe
07-23-2007 06:40 PM
Visit this user's website Find all posts by this user Quote this message in a reply
hendry Offline
Junior Member
*

Posts: 77
Joined: Jul 2007
Reputation: 0
Post: #6
RE: SSH access for user
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
07-23-2007 07:47 PM
Visit this user's website Find all posts by this user Quote this message in a reply
hendry Offline
Junior Member
*

Posts: 77
Joined: Jul 2007
Reputation: 0
Post: #7
RE: SSH access for user
what password is the user using? Is this the password set in the control panel for the domainname?
07-23-2007 08:35 PM
Visit this user's website Find all posts by this user Quote this message in a reply
RatS Offline
Project Leader
******

Posts: 1,854
Joined: Oct 2006
Reputation: 17
Post: #8
RE: SSH access for user
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.
07-23-2007 08:50 PM
Visit this user's website Find all posts by this user Quote this message in a reply
Zothos Offline
Release Manager
*****
Dev Team

Posts: 1,262
Joined: Feb 2007
Reputation: 10
Post: #9
RE: SSH access for user
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.
07-23-2007 11:34 PM
Find all posts by this user Quote this message in a reply
BeNe Offline
Moderator
*****
Moderators

Posts: 5,899
Joined: Jan 2007
Reputation: 68
Post: #10
RE: SSH access for user
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
07-23-2007 11:38 PM
Visit this user's website Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 2 Guest(s)