From unknown Thu Apr 09 03:17:27 2026 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 , 1063@bugs.x2go.org Resent-From: Sivachidambaram Somu Resent-To: x2go-dev@lists.x2go.org Resent-CC: X2Go Developers X-Loop: owner@bugs.x2go.org Resent-Date: Wed, 24 Aug 2016 06:35:01 +0000 Resent-Message-ID: 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: References: From: Sivachidambaram Somu Date: Wed, 24 Aug 2016 12:00:27 +0530 Message-ID: To: Mihai Moldovan Cc: 1063@bugs.x2go.org Content-Type: multipart/alternative; boundary=94eb2c068cfacd5a4a053acb6a07 --94eb2c068cfacd5a4a053acb6a07 Content-Type: text/plain; charset=UTF-8 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 * -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 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 > > > --94eb2c068cfacd5a4a053acb6a07 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi Mihai,

My apologies for the late rep= ly. 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 x2gos= qlitewrapper 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 happ= ens automatically after I install x2goserver.

Howe= ver, the client still gives out the error mentioned in my first email.

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

%=C2=A0 sudo ls -lhr= t /var/lib/x2go=C2=A0

total 16K

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


Contents of '/u= sr/lib64/x2go' folder:

% ls -lhrt /usr/lib6= 4/x2go=C2=A0

total 132K

-rw-r--r--=C2=A0 1 root root =C2=A0 =C2=A0 2= .0K Apr 27=C2=A0 2015 x2goutils.pm

-rwxr-xr-x=C2=A0 1 root root =C2=A0 =C2=A0 1= .3K Apr 27=C2=A0 2015 x2gosyslog

-rwxr-xr-x=C2=A0 1 root root =C2=A0 =C2=A0 1= .3K Apr 27=C2=A0 2015 x2gosuspend-agent

-rwxr-xr-x=C2=A0 1 root root=C2=A0 =C2=A0 = =C2=A0 18K Apr 27=C2=A0 2015 x2gosqlitewrapper.pl

-rwxr-xr-x=C2=A0 1 root root =C2=A0 =C2=A0 1= .3K Apr 27=C2=A0 2015 x2gormport

-rwxr-xr-x=C2=A0 1 root root =C2=A0 =C2=A0 1= .6K Apr 27=C2=A0 2015 x2gormforward

-rwxr-xr-x=C2=A0 1 root root =C2=A0 =C2=A0 1= .4K Apr 27=C2=A0 2015 x2goresume

-rw-r--r--=C2=A0 1 root root =C2=A0 =C2=A0 1= .8K Apr 27=C2=A0 2015 x2gologlevel.pm

-rwxr-xr-x=C2=A0 1 root root =C2=A0 =C2=A0 1= .1K Apr 27=C2=A0 2015 x2gologlevel

-rwxr-xr-x=C2=A0 1 root root =C2=A0 =C2=A0 1= .8K Apr 27=C2=A0 2015 x2golistsessions_sql

-rwxr-xr-x=C2=A0 1 root root =C2=A0 =C2=A0 1= .3K Apr 27=C2=A0 2015 x2goinsertsession

-rwxr-xr-x=C2=A0 1 root root =C2=A0 =C2=A0 1= .3K Apr 27=C2=A0 2015 x2goinsertport<= /p>

-rwxr-xr-x=C2=A0 1 root root =C2=A0 =C2=A0 1= .3K Apr 27=C2=A0 2015 x2gogetstatus

-rwxr-xr-x=C2=A0 1 root root =C2=A0 =C2=A0 1= .3K Apr 27=C2=A0 2015 x2gogetports

-rwxr-xr-x=C2=A0 1 root root =C2=A0 =C2=A0 1= .3K Apr 27=C2=A0 2015 x2gogetdisplays=

-rwxr-xr-x=C2=A0 1 root root =C2=A0 =C2=A0 1= .8K Apr 27=C2=A0 2015 x2gogetagentstate

-rwxr-xr-x=C2=A0 1 root root =C2=A0 =C2=A0 1= .3K Apr 27=C2=A0 2015 x2gogetagent

-rw-r--r--=C2=A0 1 root root=C2=A0 =C2=A0 = =C2=A0 22K Apr 27=C2=A0 2015 x2godbwrap= per.pm

-rwxr-xr-x=C2=A0 1 root root =C2=A0 =C2=A0 1= .4K Apr 27=C2=A0 2015 x2gocreatesession

-rwxr-xr-x=C2=A0 1 root root =C2=A0 =C2=A0 1= .3K Apr 27=C2=A0 2015 x2gochangestatus

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

drwxr-xr-x 14 root root =C2=A0 =C2=A0 4.0K A= ug 24 11:43 extensions

drwxr-xr-x=C2=A0 2 root root =C2=A0 =C2=A0 4= .0K Aug 24 11:43 bin

<= div class=3D"gmail_extra">
Regards,
Siva Chidambaram Somu

On Sun, Aug 14, 2016 at 7:40 AM, Mihai Moldo= van <ionic@ionic.de> wrote:
<= span class=3D"">On = 14.08.2016 03:12 AM, Sivachidambaram Somu wrote:
> When I run the command with elevated privileges, the created DB file i= s 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 x2gosql= itewrapper
(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



--94eb2c068cfacd5a4a053acb6a07--