X2Go Bug report logs - #1063
CreateDB fails with error `DBI connect('dbname=/var/lib/x2go/x2go_sessions','',...) failed`

version graph

Package: x2goserver; Maintainer for x2goserver is X2Go Developers <x2go-dev@lists.x2go.org>; Source for x2goserver is src:x2goserver.

Reported by: Sivachidambaram Somu <arun.lisieux@gmail.com>

Date: Tue, 26 Jul 2016 06:05:02 UTC

Severity: normal

Tags: moreinfo

Found in version 4.0.1.19-3.el6

Full log

🔗 View this message in rfc822 format

X-Loop: owner@bugs.x2go.org
Subject: Bug#1063: CreateDB fails with error `DBI connect('dbname=/var/lib/x2go/x2go_sessions', '', ...) failed`
Reply-To: Sivachidambaram Somu <arun.lisieux@gmail.com>, 1063@bugs.x2go.org
Resent-From: Sivachidambaram Somu <arun.lisieux@gmail.com>
Resent-To: x2go-dev@lists.x2go.org
Resent-CC: X2Go Developers <x2go-dev@lists.x2go.org>
X-Loop: owner@bugs.x2go.org
Resent-Date: Wed, 24 Aug 2016 06:35:01 +0000
Resent-Message-ID: <handler.1063.B1063.147202024025402@bugs.x2go.org>
Resent-Sender: owner@bugs.x2go.org
X-X2Go-PR-Message: followup 1063
X-X2Go-PR-Package: x2goserver
X-X2Go-PR-Keywords: moreinfo
Received: via spool by 1063-submit@bugs.x2go.org id=B1063.147202024025402
          (code B ref 1063); Wed, 24 Aug 2016 06:35:01 +0000
Received: (at 1063) by bugs.x2go.org; 24 Aug 2016 06:30:40 +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=0.7 required=3.0 tests=BAYES_50,DKIM_SIGNED,
	DKIM_VALID,DKIM_VALID_AU,FREEMAIL_FROM,HTML_MESSAGE,URIBL_BLOCKED
	autolearn=ham version=3.3.2
Received: from localhost (localhost [127.0.0.1])
	by ymir.das-netzwerkteam.de (Postfix) with ESMTP id CB44C5DEFE
	for <1063@bugs.x2go.org>; Wed, 24 Aug 2016 08:30:36 +0200 (CEST)
X-Virus-Scanned: Debian amavisd-new at ymir.das-netzwerkteam.de
Received: from ymir.das-netzwerkteam.de ([127.0.0.1])
	by localhost (ymir.das-netzwerkteam.de [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id KyhbCMPtGcGZ for <1063@bugs.x2go.org>;
	Wed, 24 Aug 2016 08:30:30 +0200 (CEST)
Received: from mail-qk0-f193.google.com (mail-qk0-f193.google.com [209.85.220.193])
	by ymir.das-netzwerkteam.de (Postfix) with ESMTPS id A9F325DDEA
	for <1063@bugs.x2go.org>; Wed, 24 Aug 2016 08:30:29 +0200 (CEST)
Received: by mail-qk0-f193.google.com with SMTP id r128so572628qkc.1
        for <1063@bugs.x2go.org>; Tue, 23 Aug 2016 23:30:29 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20120113;
        h=mime-version:in-reply-to:references:from:date:message-id:subject:to
         :cc;
        bh=bISRtb/Ujc2BuwdG6gUbbB2Y0o0Bi8H2mv7YfeyM0QE=;
        b=JCOSVh2rcQg6q14aYYMY1ovGlVY/ecSP4Ys7dWRBH305i3FAKuPk9OkEc9N4Eps1KY
         z0MvLIRfWBT9Z7ot/pe+MdbUlLfUs+iaAA8izOmN2ySlT12YztwoUieW4t+tpBLgp3yS
         PMhdiRS8i003yMFenn4zhiUT3pJguja0nA/olziVi01aFg1Jme6+ZWln7z+OHtUfHfH1
         7/srffypYWsGyepOPi3yP2GgYyyylkYxpPfPCgt4rnI22lj59skL3yPYoXoP3QxWncdy
         FEmoIZlnCPJCGGInnlmNG2kU1rZj/GOOuifiJ2psSC51V1hsdC1zyv9asV7c0JJ3vy6N
         rYIw==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20130820;
        h=x-gm-message-state:mime-version:in-reply-to:references:from:date
         :message-id:subject:to:cc;
        bh=bISRtb/Ujc2BuwdG6gUbbB2Y0o0Bi8H2mv7YfeyM0QE=;
        b=PoYP27obTDDIK9vZso3l0aUHBNFEOScKIb5Hzr+fHFNi3VxMfXIEzqjvst7mebQcW7
         o4VlMooTSh8v2FZhB5eZ0KTTVJb6V5dALQeqk1aSj0C2Vkhiy+LL/UycfpXrEeCSCX6C
         VuPOSQVBAEgt2IpTLw+mqnO4mOS596PhW/EPWkAyOrvs7sU2E7pIHwb0tHw4fUePI37O
         wOMVxEzz7DMLo84JlOIE2wPa9jHHfETpmNVUNer0O6znIBnRr6BAhEDZEMX5Bg/oKfyl
         H+jMOH7PWS1M6aNzeWS1YbndR1HOmt91jfZx1LZqAFIm/nhL03rtY+5vZicPM3oI/fIN
         K9EA==
X-Gm-Message-State: AE9vXwMSiOJ1nCEUXzNi+pZHLU7VMsyasCwfoDwG0LD7EtdD14V2aamBO8B5Ca4FSEZMRI/Lnd057fBXkL7QNA==
X-Received: by 10.55.166.86 with SMTP id p83mr1426344qke.101.1472020228166;
 Tue, 23 Aug 2016 23:30:28 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.55.175.197 with HTTP; Tue, 23 Aug 2016 23:30:27 -0700 (PDT)
In-Reply-To: <edc5bbf9-38b5-7e67-054c-0f0b526062dc@ionic.de>
References: <CAC5R9dkj8BfkaHTAhLy0U4nzMRJRtkLw5Ss1be_YM4Y64ZG8Lw@mail.gmail.com>
 <bf97b5ef-9b19-2b68-c5dd-352dcb43dbac@ionic.de> <CAC5R9dnZzc+1enWSTBb6-fuXYSSK6ZAwRLS+miipKUduj01krw@mail.gmail.com>
 <edc5bbf9-38b5-7e67-054c-0f0b526062dc@ionic.de>
From: Sivachidambaram Somu <arun.lisieux@gmail.com>
Date: Wed, 24 Aug 2016 12:00:27 +0530
Message-ID: <CAC5R9dndn6xiS2fCQpovBLZn6yUkUw2F33XEkpZhqXrFbME9Sw@mail.gmail.com>
To: Mihai Moldovan <ionic@ionic.de>
Cc: 1063@bugs.x2go.org
Content-Type: multipart/alternative; boundary=94eb2c068cfacd5a4a053acb6a07

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

My apologies for the late reply. I had to undergo a minor surgery and was
out of my machine for a couple of weeks.

Coming back to your question, I do find x2gosqlitewrapper under
'/usr/lib64/x2go' folder (complete contents are listed below). I also find
the 'x2go_sessions' file under '/var/lib/x2go' folder, which is owned by
x2gouser in root domain. This happens automatically after I install
x2goserver.

However, the client still gives out the error mentioned in my first email.

*Contents of '/var/lib/x2go' folder:*

%  sudo ls -lhrt /var/lib/x2go

total 16K

-rw-rw---- 1 root x2gouser 13K Aug 24 11:43 x2go_sessions

*Contents of '/usr/lib64/x2go' folder:*

% ls -lhrt /usr/lib64/x2go

total 132K

-rw-r--r--  1 root root     2.0K Apr 27  2015 x2goutils.pm

-rwxr-xr-x  1 root root     1.3K Apr 27  2015 *x2gosyslog*

-rwxr-xr-x  1 root root     1.3K Apr 27  2015 *x2gosuspend-agent*

-rwxr-xr-x  1 root root      18K Apr 27  2015 *x2gosqlitewrapper.pl
<http://x2gosqlitewrapper.pl>*

-rwxr-xr-x  1 root root     1.3K Apr 27  2015 *x2gormport*

-rwxr-xr-x  1 root root     1.6K Apr 27  2015 *x2gormforward*

-rwxr-xr-x  1 root root     1.4K Apr 27  2015 *x2goresume*

-rw-r--r--  1 root root     1.8K Apr 27  2015 x2gologlevel.pm

-rwxr-xr-x  1 root root     1.1K Apr 27  2015 *x2gologlevel*

-rwxr-xr-x  1 root root     1.8K Apr 27  2015 *x2golistsessions_sql*

-rwxr-xr-x  1 root root     1.3K Apr 27  2015 *x2goinsertsession*

-rwxr-xr-x  1 root root     1.3K Apr 27  2015 *x2goinsertport*

-rwxr-xr-x  1 root root     1.3K Apr 27  2015 *x2gogetstatus*

-rwxr-xr-x  1 root root     1.3K Apr 27  2015 *x2gogetports*

-rwxr-xr-x  1 root root     1.3K Apr 27  2015 *x2gogetdisplays*

-rwxr-xr-x  1 root root     1.8K Apr 27  2015 *x2gogetagentstate*

-rwxr-xr-x  1 root root     1.3K Apr 27  2015 *x2gogetagent*

-rw-r--r--  1 root root      22K Apr 27  2015 x2godbwrapper.pm

-rwxr-xr-x  1 root root     1.4K Apr 27  2015 *x2gocreatesession*

-rwxr-xr-x  1 root root     1.3K Apr 27  2015 *x2gochangestatus*

-rwxr-sr-x  1 root x2gouser 5.1K Apr 27  2015 x2gosqlitewrapper

drwxr-xr-x 14 root root     4.0K Aug 24 11:43 *extensions*

drwxr-xr-x  2 root root     4.0K Aug 24 11:43 *bin*

Regards,
Siva Chidambaram Somu

On Sun, Aug 14, 2016 at 7:40 AM, Mihai Moldovan <ionic@ionic.de> wrote:

> On 14.08.2016 03:12 AM, Sivachidambaram Somu wrote:
> > When I run the command with elevated privileges, the created DB file is
> owned by
> > root and it remains unaccessible when the client tries to establish a
> connection.
>
> That's both true and expected.
>
> The x2goserver scripts (for instance x2golistsessions) call a setuid/setgid
> binary called libx2go-server-db-sqlite3-wrapper (nightlies) or
> x2gosqlitewrapper
> (release version.)
>
> They should reside in /usr/lib/x2go/.
>
> Due to that the session DB can be read even as a user.
>
> Are these binaries not correctly installed on your system?
>
>
>
> Mihai
>
>
>

[Message part 2 (text/html, inline)]

Send a report that this bug log contains spam.

X2Go Developers <owner@bugs.x2go.org>. Last modified: Thu Nov 21 15:03:25 2024; Machine Name: ymir.das-netzwerkteam.de

X2Go Bug tracking system

Debbugs is free software and licensed under the terms of the GNU Public License version 2. The current version can be obtained from https://bugs.debian.org/debbugs-source/.

Copyright © 1999 Darren O. Benham, 1997,2003 nCipher Corporation Ltd, 1994-97 Ian Jackson, 2005-2017 Don Armstrong, and many other contributors.