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

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

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

Received: (at 1063) by bugs.x2go.org; 24 Aug 2016 06:30:40 +0000
From arun.lisieux@gmail.com  Wed Aug 24 08:30:37 2016
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>
Subject: Re: CreateDB fails with error `DBI connect('dbname=/var/lib/x2go/x2go_sessions',
 '', ...) failed`
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)]

X2Go Developers <owner@bugs.x2go.org>. Last modified: Fri Apr 19 23:44:50 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/.

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

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