[X2Go-User] Problem restoring connection on Ubuntu 18.04

[EI]

I have a very strange problem with x2goserver running on Ubuntu 18.04. I
get an error message on the client side when I try to suspend the
connection. I also, can't reconnect to existing connections. I haven't had
this problem with 16.04.

I tried debugging the problem and I discovered that
/var/lib/x2go/x2go_sessions database is not getting updated when connection
is created. I tried erasing and re-creating the database, same problem.

Even running perl script manually:
/usr/lib/x2go/libx2go-server-db-sqlite3-wrapper.pl
insertsession,50,blah,blah-50-1536602027_stRkonsole_dp
doesn't change the database.

I installed x2goserver from ppa:x2go/stable following instructions on x2go
page.

What could be the reason for this? How do I debug it further?
Thank you.


Here's version info:
~$ x2goversion
x2goserver: 4.1.0.2
x2goserver-common: 4.1.0.2
x2goserver-extensions: 4.1.0.2
x2goserver-fmbindings: 4.1.0.2
x2goserver-printing: 4.1.0.2
x2goserver-x2goagent: 3.5.99.16
x2goserver-xsession: 4.1.0.2

[Robert Dinse]

I am running Ubuntu 18.04 and Mate and not having either of these
problems. I am running the nightly build though rather than the main line.

-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-
Eskimo North Linux Friendly Internet Access, Shell Accounts, and Hosting.
Knowledgeable human assistance, not telephone trees or script readers.
See our web site: http://www.eskimo.com/ [phone] or [phone].

Date: Tue, 11 Sep 2018 11:02:47 -0700
Subject: [X2Go-User] Problem restoring connection on Ubuntu 18.04
I have a very strange problem with x2goserver running on Ubuntu 18.04. I
get an error message on the client side when I try to suspend the
connection. I also, can't reconnect to existing connections. I haven't had
this problem with 16.04.
I tried debugging the problem and I discovered that
/var/lib/x2go/x2go_sessions database is not getting updated when connection
is created. I tried erasing and re-creating the database, same problem.
/usr/lib/x2go/libx2go-server-db-sqlite3-wrapper.pl
insertsession,50,blah,blah-50-1536602027_stRkonsole_dp
doesn't change the database.
I installed x2goserver from ppa:x2go/stable following instructions on x2go
page.
What could be the reason for this? How do I debug it further?
Thank you.
~$ x2goversion
x2goserver: 4.1.0.2
x2goserver-common: 4.1.0.2
x2goserver-extensions: 4.1.0.2
x2goserver-fmbindings: 4.1.0.2
x2goserver-printing: 4.1.0.2
x2goserver-x2goagent: 3.5.99.16
x2goserver-xsession: 4.1.0.2

[Mihai Moldovan]

I have a very strange problem with x2goserver running on Ubuntu 18.04. I get an
error message on the client side when I try to suspend the connection. I also,
can't reconnect to existing connections. I haven't had this problem with 16.04.
I tried debugging the problem and I discovered that /var/lib/x2go/x2go_sessions
database is not getting updated when connection is created. I tried erasing and
re-creating the database, same problem. 
/usr/lib/x2go/libx2go-server-db-sqlite3-wrapper.pl
<http://libx2go-server-db-sqlite3-wrapper.pl>
insertsession,50,blah,blah-50-1536602027_stRkonsole_dp 
doesn't change the database.

Likely caused because the server is running in an LXC (or other nom-du-jour)
container without necessary permissions.


Note that the database is supposed to be modified via a setuid root binary,
which then calls the actual perl script. The perl script is not supposed to work
correctly when called directly as an unprivileged user.

LXC is known to have problems with setuid binaries for unprivileged containers,
but that seems to be a design choice.



Mihai

[EI]

I'm not running any of the containers on the system, so it doesn't look
like a permission issue.
I looked at the libx2go-server-db-sqlite3-wrapper.pl and
/usr/share/perl5/X2Go/Server/DB.pm and just ran perl commands to add a new
port to used_ports table. It worked (as root) and I can see the new entries
in x2go_sessions. However, nothing is added when I connect from remote
server using x2go.

Since nobody else seems to have this problem, it's probably something
related to my system, although I checked all the libraries and file
permissions. I finally gave up an switched to postgresql backend. It was a
pain to configure, but it works and I can suspend and restore connections
now.

Thank you.

Post by EI

Post by EI
I have a very strange problem with x2goserver running on Ubuntu 18.04. I

get an

Post by EI
error message on the client side when I try to suspend the connection. I

also,

Post by EI
can't reconnect to existing connections. I haven't had this problem with

16.04.

Post by EI
I tried debugging the problem and I discovered that

/var/lib/x2go/x2go_sessions

Post by EI
database is not getting updated when connection is created. I tried

erasing and

Post by EI
re-creating the database, same problem.
/usr/lib/x2go/libx2go-server-db-sqlite3-wrapper.pl
<http://libx2go-server-db-sqlite3-wrapper.pl>
insertsession,50,blah,blah-50-1536602027_stRkonsole_dp
doesn't change the database.

Likely caused because the server is running in an LXC (or other nom-du-jour)
container without necessary permissions.
Note that the database is supposed to be modified via a setuid root binary,
which then calls the actual perl script. The perl script is not supposed to work
correctly when called directly as an unprivileged user.
LXC is known to have problems with setuid binaries for unprivileged containers,
but that seems to be a design choice.
Mihai