X2Go Bug report logs - #708
x2gosqlitewrapper.pl reports "unable to open database" on session-resume, while the database is there.

Full log

Message #10 received at 708@bugs.x2go.org (full text, mbox, reply):

Received: (at 708) by bugs.x2go.org; 19 Dec 2014 13:08:01 +0000
From mike.gabriel@das-netzwerkteam.de  Fri Dec 19 14:07:59 2014
X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on
	ymir.das-netzwerkteam.de
X-Spam-Level: 
X-Spam-Status: No, score=-1.9 required=5.0 tests=BAYES_00,URIBL_BLOCKED
	autolearn=ham version=3.3.2
Received: from freya.das-netzwerkteam.de (freya.das-netzwerkteam.de [88.198.48.199])
	by ymir.das-netzwerkteam.de (Postfix) with ESMTPS id 4E2C35DB26
	for <708@bugs.x2go.org>; Fri, 19 Dec 2014 14:07:59 +0100 (CET)
Received: from grimnir.das-netzwerkteam.de (grimnir.das-netzwerkteam.de [78.46.204.98])
	by freya.das-netzwerkteam.de (Postfix) with ESMTPS id F08003812;
	Fri, 19 Dec 2014 14:07:58 +0100 (CET)
Received: from localhost (localhost [127.0.0.1])
	by grimnir.das-netzwerkteam.de (Postfix) with ESMTP id E4F743BC10;
	Fri, 19 Dec 2014 14:07:58 +0100 (CET)
X-Virus-Scanned: Debian amavisd-new at grimnir.das-netzwerkteam.de
Received: from grimnir.das-netzwerkteam.de ([127.0.0.1])
	by localhost (grimnir.das-netzwerkteam.de [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id 8wbuyIHel0Df; Fri, 19 Dec 2014 14:07:58 +0100 (CET)
Received: from grimnir.das-netzwerkteam.de (localhost [127.0.0.1])
	by grimnir.das-netzwerkteam.de (Postfix) with ESMTPS id A09AF3B9B3;
	Fri, 19 Dec 2014 14:07:58 +0100 (CET)
Received: from 134.245.44.2 ([134.245.44.2]) by mail.das-netzwerkteam.de
 (Horde Framework) with HTTP; Fri, 19 Dec 2014 13:07:58 +0000
Date: Fri, 19 Dec 2014 13:07:58 +0000
Message-ID: <20141219130758.Horde.p4guu4PgSj1lV--lqrKbig1@mail.das-netzwerkteam.de>
From: Mike Gabriel <mike.gabriel@das-netzwerkteam.de>
To: "Zuck, Daniel" <Daniel.Zuck@six-group.com>, 708@bugs.x2go.org
Cc: "Talvacchia, Claudio" <Claudio.Talvacchia@six-group.com>
Subject: Re: [X2Go-Dev] Bug#708: x2gosqlitewrapper.pl reports "unable to
 open database" on session-resume, while the database is there.
In-Reply-To: <B62526E3DA9E30409AE8B69A0AC2F588A32332AE@mpzhwmbx15.base.dom>
User-Agent: Internet Messaging Program (IMP) H5 (6.2.2)
Accept-Language: en,de
Organization: DAS-NETZWERKTEAM
X-Originating-IP: 134.245.44.2
X-Remote-Browser: Mozilla/5.0 (X11; Linux x86_64; rv:32.0) Gecko/20100101
 Firefox/32.0 Iceweasel/32.0
Content-Type: multipart/signed; boundary="=_h63d7LNiuYgg_CVtrrAI_Q1";
 protocol="application/pgp-signature"; micalg=pgp-sha1
MIME-Version: 1.0

[Message part 1 (text/plain, inline)]

HI Daniel,

On  Fr 19 Dez 2014 11:14:13 CET, Zuck, Daniel wrote:

> Package: x2goserver
> Version: 4.0.1.15
>
> Hello
>
> The environment ist:
> x2goagent: 3.5.0.27
> x2goserver: 4.0.1.15
> x2goserver-compat: 4.0.1.15
> x2goserver-extensions: 4.0.1.15
> x2goserver-fmbindings: 4.0.1.15
> x2goserver-printing: 4.0.1.15
> x2goserver-pyhoca: 4.0.1.15
> x2goserver-xsession: 4.0.1.15
> running on SLES11SP3. We have several servers running X2go, where at  
> two systems a session resume raises an error since the same day:
>
> DBD::SQLite::st execute failed: unable to open database file at  
> /usr/lib/x2go/x2gosqlitewrapper.pl line 320.
> syslog: invalid level/facility: error at  
> /usr/lib/x2go/x2gosqlitewrapper.pl line 323
>
> The message is shown by the X2Go-Client on a reconnect, right before  
> the "session-status-info-window" becomes visible. Now at the GUI  
> "Suspend Session" (in German: Anhalten) is selected, after this a  
> reconnect to the session to resume. On clicking "Suspend Session",  
> the error message is shown again. Then the session is selected and  
> "klicked", which results in a "normal" resume of the session, and  
> the remote GUI becomes visible.
>
> The Syslog however has entries which read like the session is  
> suspended/resumed correctly without any issues:
>
> Dec 19 10:15:35 mxxxxxxxxx02 /usr/bin/x2gosuspend-session: session  
> with ID XYZAB-76-1417681012_stDGNOME_dp32 has been suspended  
> successfully
> Dec 19 10:16:30 mxxxxxxxxx02 /usr/bin/x2gosuspend-session: session  
> with ID XYZAB-76-1417681012_stDGNOME_dp32 has been suspended  
> successfully
> Dec 19 10:16:39 mxxxxxxxxx02 /usr/bin/x2goresume-session: client  
> 10.43.142.67 has successfully resumed session with ID  
> XYZAB-76-1417681012_stDGNOME_dp32
> Dec 19 10:16:49 mxxxxxxxxx02 /usr/bin/x2gosetkeyboard: Setting X  
> keyboard according to  
> /home/XYZAB/.x2go/C-XYZAB-76-1417681012_stDGNOME_dp32/keyboard
>
> Investigating further: When calling "x2golistsessions_root", the  
> script lists a number of states, including the error-message above.  
> So it appears to me, there is a consistency issue with the  
> SQLite-DB. I strongly assume, it can be worked-around by recreating  
> the DB, but I would like to sort out the reason, why it came to this  
> status.
>
> My questions:
> Is this issue known? - I did not find anything like this at the bugtracker.
> What information is needed for further investigations? - The system  
> is still in this state, so we can pull further infos.

This is indeed a weird issue.

First thing: please note that shortly the X2Go upstream team will  
provide a new source for SLES packages. The x2goserver version you are  
using is a little outdated already.

What makes me worry a bit is this message:

"""
syslog: invalid level/facility: error at  
/usr/lib/x2go/x2gosqlitewrapper.pl line 323
"""

I am not sure what perl-Syslog package version is shipped with SLES  
11.3, but it seems it cannot handle the "error" logging facility. This  
is weird in the first place and maybe you can investigate your system  
a bit more on this. (What version of perl-Syslog is installed, etc.)

Next question is: what file permissions are set on

  /var/lib/x2go/x2go_sessions
  /usr/<lib>/x2go/x2gosqlitewrapper

Next question:

  getent passwd x2gouser
  getent group x2gouser

Once you have provided those infos, you can consider running:

  sudo rm /var/lib/x2go/x2go_sessions
  sudo x2godbadmin --createdb

... and test again...

Mike

-- 

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

GnuPG Key ID 0x25771B31
mail: mike.gabriel@das-netzwerkteam.de, http://das-netzwerkteam.de

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

[Message part 2 (application/pgp-signature, inline)]

Send a report that this bug log contains spam.