Subject: Bug#309: [X2Go-Dev] Bug#309: Make x2goterminate-session / x2gosuspend-session operable as root

From: Mike Gabriel <[email-masked]>
Date: Mon, 23 Sep 2013 23:27:33 +0200

Hi Stefan,

On Mo 23 Sep 2013 12:51:07 CEST Stefan Baur wrote:

> Am 23.09.2013 12:23, schrieb Mike Gabriel:
>> Package: x2goserver
>> Severity: wishlist
>>
>> Currently, only the user owning a session can suspend/terminate  
>> that session.
>>
>> The super-user root should also be eligible to act on user sessions  
>> with those commands.
>>
>> This should work from any x2goserver (in a multi-node farm) and  
>> with SQLite and PostgreSQL db backend.
>
> We're only using single node mode, but here, terminating sessions  
> from root works (or at least, it did last time we needed it).
> x2golistsessions_root | awk -F '|' '{ print $2 " " $12 "@" $8 }' #  
> lists session-IDs followed by username@clientname
> x2goterminate-session $SESSIONID # this terminates the session with  
> the named ID when called by root

With the SQLite backend this surely is the case.

> Never tried suspend, but there's x2gosuspend-session which should  
> work the same way.
>
> So, either you missed that or your bug report should contain a few  
> more details as to what functionality you need and what is missing,  
> I'd say. ;-)

With PostgreSQL, you get this:

"""
x2goterminate-session mga-54-1379970522_stRTERMINAL_dp24
DBD::Pg::st execute failed: ERROR:  permission denied for relation  
sessions_view at /usr/share/perl5/X2Go/Server/DB/PostgreSQL.pm line 417.
Died at /usr/share/perl5/X2Go/Server/DB/PostgreSQL.pm line 417.
DBD::Pg::st execute failed: ERROR:  permission denied for relation  
sessions_view at /usr/share/perl5/X2Go/Server/DB/PostgreSQL.pm line 328.
Died at /usr/share/perl5/X2Go/Server/DB/PostgreSQL.pm line 328.
"""

Nowadays, the x2gocleansessions daemon script can handle  
suspend/terminate through a change in the session database.

x2goterminate-session and x2gosuspend-session should utilize this new feature.

Mike

-- 

DAS-NETZWERKTEAM
mike gabriel, herweg 7, 24357 fleckeby
fon: +49 (1520) 1976 148

GnuPG Key ID 0x25771B31
mail: [email-masked], http://das-netzwerkteam.de

freeBusy:
https://mail.das-netzwerkteam.de/freebusy/m.gabriel%40das-netzwerkteam.de.xfb