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?
Regards, Gerry
On Thu, 2011-02-03 at 22:13 -0500, Gerry Reno wrote:
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? <snip> I haven't played with 3.0.99 yet so I don't know what is involved in the upgrade. Any chance you're using the old database schema? Although that wouldn't make sense if you can terminate from the GUI which I think you are implying you can do. Just a thought - John
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"
Oleksandr Shneyder Dipl. Informatik X2go Core Developer Team
email: oleksandr.shneyder@obviously-nice.de web: www.obviously-nice.de
--> X2go - everywhere@home
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