From unknown Thu Mar 28 10:24:11 2024 X-Loop: owner@bugs.x2go.org Subject: Bug#708: [X2Go-Dev] Bug#708: x2gosqlitewrapper.pl reports "unable to open database" on session-resume, while the database is there. Reply-To: Mike Gabriel , 708@bugs.x2go.org Resent-From: Mike Gabriel Resent-To: x2go-dev@lists.x2go.org Resent-CC: X2Go Developers X-Loop: owner@bugs.x2go.org Resent-Date: Fri, 19 Dec 2014 13:10:02 +0000 Resent-Message-ID: Resent-Sender: owner@bugs.x2go.org X-X2Go-PR-Message: followup 708 X-X2Go-PR-Package: x2goserver X-X2Go-PR-Keywords: Received: via spool by 708-submit@bugs.x2go.org id=B708.141899448120712 (code B ref 708); Fri, 19 Dec 2014 13:10:02 +0000 Received: (at 708) by bugs.x2go.org; 19 Dec 2014 13:08:01 +0000 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 To: "Zuck, Daniel" , 708@bugs.x2go.org Cc: "Talvacchia, Claudio" In-Reply-To: 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 This message is in MIME format and has been PGP signed. --=_h63d7LNiuYgg_CVtrrAI_Q1 Content-Type: text/plain; charset=ISO-8859-1; format=flowed; DelSp=Yes Content-Disposition: inline Content-Transfer-Encoding: quoted-printable 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=20= =20 >=20two systems a session resume raises an error since the same day: > > DBD::SQLite::st execute failed: unable to open database file at=20=20 >=20/usr/lib/x2go/x2gosqlitewrapper.pl line 320. > syslog: invalid level/facility: error at=20=20 >=20/usr/lib/x2go/x2gosqlitewrapper.pl line 323 > > The message is shown by the X2Go-Client on a reconnect, right before=20= =20 >=20the "session-status-info-window" becomes visible. Now at the GUI=20=20 >=20"Suspend Session" (in German: Anhalten) is selected, after this a=20=20 >=20reconnect to the session to resume. On clicking "Suspend Session",=20= =20 >=20the error message is shown again. Then the session is selected and=20= =20 >=20"klicked", which results in a "normal" resume of the session, and=20=20 >=20the remote GUI becomes visible. > > The Syslog however has entries which read like the session is=20=20 >=20suspended/resumed correctly without any issues: > > Dec 19 10:15:35 mxxxxxxxxx02 /usr/bin/x2gosuspend-session: session=20=20 >=20with ID XYZAB-76-1417681012_stDGNOME_dp32 has been suspended=20=20 >=20successfully > Dec 19 10:16:30 mxxxxxxxxx02 /usr/bin/x2gosuspend-session: session=20=20 >=20with ID XYZAB-76-1417681012_stDGNOME_dp32 has been suspended=20=20 >=20successfully > Dec 19 10:16:39 mxxxxxxxxx02 /usr/bin/x2goresume-session: client=20=20 >=2010.43.142.67 has successfully resumed session with ID=20=20 >=20XYZAB-76-1417681012_stDGNOME_dp32 > Dec 19 10:16:49 mxxxxxxxxx02 /usr/bin/x2gosetkeyboard: Setting X=20=20 >=20keyboard according to=20=20 >=20/home/XYZAB/.x2go/C-XYZAB-76-1417681012_stDGNOME_dp32/keyboard > > Investigating further: When calling "x2golistsessions_root", the=20=20 >=20script lists a number of states, including the error-message above.=20= =20 >=20So it appears to me, there is a consistency issue with the=20=20 >=20SQLite-DB. I strongly assume, it can be worked-around by recreating=20= =20 >=20the DB, but I would like to sort out the reason, why it came to this=20= =20 >=20status. > > My questions: > Is this issue known? - I did not find anything like this at the bugtracke= r. > What information is needed for further investigations? - The system=20=20 >=20is 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=20=20 provide=20a new source for SLES packages. The x2goserver version you are=20= =20 using=20is a little outdated already. What makes me worry a bit is this message: """ syslog: invalid level/facility: error at=20=20 /usr/lib/x2go/x2gosqlitewrapper.pl=20line 323 """ I am not sure what perl-Syslog package version is shipped with SLES=20=20 11.3,=20but it seems it cannot handle the "error" logging facility. This=20= =20 is=20weird in the first place and maybe you can investigate your system=20= =20 a=20bit 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//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 --=20 DAS-NETZWERKTEAM mike=20gabriel, 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.x= fb --=_h63d7LNiuYgg_CVtrrAI_Q1 Content-Type: application/pgp-signature Content-Description: Digitale PGP-Signatur Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAABAgAGBQJUlCMuAAoJEJr0azAldxsxDvYP/0mju1DPuVpmyvnPAcjLaLN8 bOLjaIkaRbvS7przjvtIrD5YHAffpp7H8paPe4l+/n3VrJ66POD+b0eh5xtnf7I8 oFv1iF64RpfwfN3CGauPBFxDexuGpMAdAq+lM8cPLwKMoHcXdPlCZNOhMVwAnJXM uZyVKP8DkUBYp/KyZGhhoHm5K0q8M5vyNOx5DsuDqdf8qagviTqGOAP3ToATZ6dw JvL/cwNladdfyRYjQ5aY6eGB1+VDoeuHaEh0Zfast1Ix7KNJ0nCy/6j5WOzEOxNb d/z887iw5ozGokjEJ7ClbCFPBdHgTKtdIN+AtkLMpvIZ590rcaVMDG7N7mGL/Npq OPCTrdNVap9h39EDdG+yvGT12LnVDB9IEsQXDBzxtHYqlj0XJa5uc/2Z89QTX/uO KhmMUUrQHPBAv4wafFLAwLPohgSKqflrwLUD74JUDhlRhKdqW6FpXQf7c6oP7VHZ hC1r7w5fkuNALPoCC5iazOI1ixVtu/0jzv4aYTpNW0Mp0EDafrTyK1G0mE9tfiUZ EwNIBL1+TYvIRL/ytI8/iZZKAi/TU3rV7+YrdDRB82p0jl6wWgNf0fp7S84Gh0yE GB2EFowxfJYmNJT+X8fFD/D19FPrIsFGFkL/GQrH9QF0+FjqSb/m8UKtj+DDWkq3 vaHQjAYtY1GBCIRCDzem =2sqp -----END PGP SIGNATURE----- --=_h63d7LNiuYgg_CVtrrAI_Q1--