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

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