[X2go-dev] x2goserver 3.0.99: cannot terminate session from command line

[Gerry Reno]

On 02/04/2011 01:48 AM, Oleksandr Shneyder wrote:
> Am 04.02.2011 04:13, schrieb Gerry Reno:
>   
>> I upgraded the server to 3.0.99 and configured postgresql.
>>
>> But when I try to terminate a session from the command line I see these
>> errors:
>>
>>     # sudo /usr/bin/x2goterminate-session ubuntu-51-1296672519_stDGNOME_dp24
>>     DBD::Pg::st execute failed: ERROR:  permission denied for relation
>>     sessions_view at /usr/lib/x2go/x2godbwrapper.pm line 449.
>>     Died at /usr/lib/x2go/x2godbwrapper.pm line 449.
>>     DBD::Pg::st execute failed: ERROR:  permission denied for relation
>>     sessions_view at /usr/lib/x2go/x2godbwrapper.pm line 348.
>>     Died at /usr/lib/x2go/x2godbwrapper.pm line 348.
>>     kill: usage: kill [-s sigspec | -n signum | -sigspec] pid | jobspec
>>     ... or kill -l [sigspec]
>>     DBD::Pg::st execute failed: ERROR:  permission denied for relation
>>     sessions_view at /usr/lib/x2go/x2godbwrapper.pm line 476.
>>     Died at /usr/lib/x2go/x2godbwrapper.pm line 476.
>>
>>
>> What is wrong here?
>>
>>     
> Hello Gary,
>
> The user can update/delete entries in pgsql only if they was inserted by
> himself. That mean, that you must execute "x2goterminate-session" as
> user, who have started this session. If you not this user, try to
> execute sudo su <user> -c "x2goterminate-session
> ubuntu-51-1296672519_stDGNOME_dp24"
>
> regards,
> alex
>   
>

Alex,
    Thanks.  That appears to work.

    # sudo su ubuntu -c "x2goterminate-session
    ubuntu-51-1296672519_stDGNOME_dp24"
    DISPLAY=51
    #
    # sudo  x2golistsessions_sql  $(hostname)
    #



Regards,
Gerry