From arun.lisieux@gmail.com Tue Jul 26 08:03:26 2016 Received: (at submit) by bugs.x2go.org; 26 Jul 2016 06:03:29 +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 20C8A5DDF5 for ; Tue, 26 Jul 2016 08:03:26 +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 FCNrOI1IKFk2 for ; Tue, 26 Jul 2016 08:03:17 +0200 (CEST) Received: from mail-qt0-f182.google.com (mail-qt0-f182.google.com [209.85.216.182]) by ymir.das-netzwerkteam.de (Postfix) with ESMTPS id 85DE35DA97 for ; Tue, 26 Jul 2016 08:03:16 +0200 (CEST) Received: by mail-qt0-f182.google.com with SMTP id 52so111656269qtq.3 for ; Mon, 25 Jul 2016 23:03:16 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:from:date:message-id:subject:to; bh=4C0rV5qxKeQoRso+ibrvNthj38ZMdMOn64D8X5uC9v4=; b=kdGPDKP3sxA3I6fDC8FZmRNJ6TK/ivvkkGvptJFUOMSzdrlgcaxbBc2vult8nZBgQt yLPogSi9pvF326+SnPLvj/gXPBQVW52x2h1NFmF2i5aZtP4LZir2nBJaZgqCH4Bzw+iA f7ogpFOlnq8E71bh9vZ1KDH2momwTnh3+Ak939vwE2nb39KFJAXSJZ2q/Ntfk+Bjnpeh l8225ML656DuwWx7Q0JAEw5YXG+Cv48FKVgAOmTLzc/5e+kt2uyELGef432lj/NgwQ3t ppldq1/iYXYhTfzSNheI4A/1rDK3uj4GiFnwd0aEAAYk7cvJGihdgygfR1bNIchDR6OR pQzw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=4C0rV5qxKeQoRso+ibrvNthj38ZMdMOn64D8X5uC9v4=; b=h1ZMieIsLzwUW8pZx4f3xhrNd7qQx5fvBpJRM3PDFNoXayJZLMrxfiFQ6ww+cmhbfF uroajvTq5C5p2dKaGkRe+ONPVfhdjnzYcua5KB1qmN1q9R8+DtfUtcfr1GcxQ8BLu82A Bh7w/KpAJ1ZrlzuLKm/kNVA1Ebtg8PPS4Mnot37qcUy/tcKRQ1xZ4/fiuUbx13wVXEI6 zPP+kMuno3zbkU6dPLoQHo+oCnhqGd9adEXayGLWwizRrO/nlaxmYbTwMBU+/sh3wjlo 7RTCDF3LvW26cWUfQ+7oDoQFfknvROpEa7S5P+ZMCS3p+2sz1WjXi9PO1mZQC8F+ucKT u4Aw== X-Gm-Message-State: AEkooutaM5OZ0m5HTl6tVmWw1CRDTMxRWnPdOoc1L/wzLgBJmXarkUZNtOQS8k0PKWJgOiiMqpMQWRpeJsKm0w== X-Received: by 10.237.34.65 with SMTP id o1mr35107021qtc.78.1469512995203; Mon, 25 Jul 2016 23:03:15 -0700 (PDT) MIME-Version: 1.0 Received: by 10.55.79.3 with HTTP; Mon, 25 Jul 2016 23:03:14 -0700 (PDT) From: Sivachidambaram Somu Date: Tue, 26 Jul 2016 11:33:14 +0530 Message-ID: Subject: CreateDB fails with error `DBI connect('dbname=/var/lib/x2go/x2go_sessions','',...) failed` To: submit@bugs.x2go.org Content-Type: multipart/alternative; boundary=001a113dd73a1270fc053883a824 --001a113dd73a1270fc053883a824 Content-Type: text/plain; charset=UTF-8 Package: x2goserver Version: 4.0.1.19-3.el6 Upon installing x2goserver, when "x2godbadmin" script is used with create DB option, a DBI connect error is thrown by the script. As a result, upon suspending/terminating the first session, the client refuses to reconnect to the server displaying the error message given below. *Complete Error Message:* % x2godbadmin --createdb DBI connect('dbname=/var/lib/x2go/x2go_sessions','',...) failed: unable to open database file at /usr/sbin/x2godbadmin line 103 backend=sqlite at /usr/sbin/x2godbadmin line 103. *System Details:* Host type: EC2 Server OS: Amazon Linux Bare Metal Release 2012.03 Kernel Linux 3.2.45-0.6.acc.624.45.283.amzn1acc.x86_64 GNOME 2.28.2 *Installation History:* % sudo yum install x2goserver Loaded plugins: fastestmirror, priorities, refresh-packagekit, security Setting up Install Process Loading mirror speeds from cached hostfile * dev-dsk-main: dev-desktop-repos.amazon.com * dev-dsk-updates: dev-desktop-repos.amazon.com * epel: epel.mirrors.ovh.net * nux-dextop: mirror.li.nux.ro Resolving Dependencies --> Running transaction check ---> Package x2goserver.x86_64 0:4.0.1.19-3.el6 will be installed --> Processing Dependency: x2goagent >= 3.5.0.25 for package: x2goserver-4.0.1.19-3.el6.x86_64 --> Running transaction check ---> Package x2goagent.x86_64 0:3.5.0.32-3.el6 will be installed --> Finished Dependency Resolution Dependencies Resolved ================================================================================================================================================================================== Package Arch Version Repository Size ================================================================================================================================================================================== Installing: x2goserver x86_64 4.0.1.19-3.el6 epel 98 k Installing for dependencies: x2goagent x86_64 3.5.0.32-3.el6 epel 16 k Transaction Summary ================================================================================================================================================================================== Install 2 Package(s) Total download size: 115 k Installed size: 329 k Is this ok [y/N]: y Downloading Packages: (1/2): x2goagent-3.5.0.32-3.el6.x86_64.rpm | 16 kB 00:00 (2/2): x2goserver-4.0.1.19-3.el6.x86_64.rpm | 98 kB 00:00 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Total 119 kB/s | 115 kB 00:00 Running rpm_check_debug Running Transaction Test Transaction Test Succeeded Running Transaction Installing : x2goserver-4.0.1.19-3.el6.x86_64 1/2 Installing : x2goagent-3.5.0.32-3.el6.x86_64 2/2 Verifying : x2goagent-3.5.0.32-3.el6.x86_64 1/2 Verifying : x2goserver-4.0.1.19-3.el6.x86_64 2/2 Installed: x2goserver.x86_64 0:4.0.1.19-3.el6 Dependency Installed: x2goagent.x86_64 0:3.5.0.32-3.el6 Complete! % sudo ls -lhrt /var/lib/x2go total 16K -rw-rw---- 1 root x2gouser 13K Jul 26 11:09 x2go_sessions % x2godbadmin --createdb DBI connect('dbname=/var/lib/x2go/x2go_sessions','',...) failed: unable to open database file at /usr/sbin/x2godbadmin line 103 backend=sqlite at /usr/sbin/x2godbadmin line 103. --001a113dd73a1270fc053883a824 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Package:=C2=A0x2goserver
Version: 4.0.1.19-3.el6

Upon installing x2goserver, when "x2godbadmin" sc= ript is used with create DB option, a DBI connect error is thrown by the sc= ript. As a result, upon suspending/terminating the first session, the clien= t refuses to reconnect to the server displaying the error message given bel= ow.

Complete Error Message:

% x2godba= dmin --createdb

DBI connect(&= #39;dbname=3D/var/lib/x2go/x2go_sessions','',...) failed: unabl= e to open database file at /usr/sbin/x2godbadmin line 103

backend=3Dsql= ite at /usr/sbin/x2godbadmin line 103.


= System Details:

Host type: EC2 Serve= r

OS:

Amazon Linux Bare M= etal=C2=A0
Release 2012.03
Kernel Linux 3.2.45-0.6.acc.= 624.45.283.amzn1acc.x86_64
GNOME 2.28.2

= Installation History:

% sudo yum install x2goserver

Loaded plugins: fastestm= irror, priorities, refresh-packagekit, security

Setting up Install Process

Loadin= g mirror speeds from cached hostfile

=C2=A0* dev-dsk-main: dev-desktop-repos.amazon.com

=C2=A0* dev-dsk-= updates: dev-desktop-repos.= amazon.com

=C2=A0* epel: epel.mirr= ors.ovh.net

=C2=A0* nux-dextop: mirror= .li.nux.ro

Resolving Dependencies

--> Running transaction check

=

---> Packa= ge x2goserver.x86_64 0:4.0.1.19-3.el6 will be installed

--> Processing Dep= endency: x2goagent >=3D 3.5.0.25 for package: x2goserver-4.0.1.19-3.el6.= x86_64

--> Running transaction check

---> Package x2goagent.x86_64 0:3.5.0.= 32-3.el6 will be installed

--> Finished Dependency Resolution

=


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

=C2=A0Package =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Arch=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 Version=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 Repository =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Size<= /p>

=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=

In= stalling:

=C2=A0x2goserver=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 x86_64= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 4.0.1.19-3.el6 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 epel =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 98 k

Installing for dependencies:

=C2=A0x2goagent =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 x86_64=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 3.5.= 0.32-3.el6 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 epel =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 16 k


Transaction Summary

=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D

Install =C2=A0 =C2=A0 =C2=A0 2 Package(s)


<= p style=3D"margin:0px;font-size:14px;line-height:normal;font-family:menlo">= Total download= size: 115 k

Installed size: 329 k

Is this ok [y/N]: y

Downloading Packages:<= /p>

(1/2): x2g= oagent-3.5.0.32-3.el6.x86_64.rpm =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 |=C2=A0 16 kB =C2= =A0 =C2=A0 00:00=C2=A0 =C2=A0 =C2=A0

(2/2): x2goserver-4.0.1.19-3.el6.x86_64.r= pm=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 |=C2=A0 98 kB =C2=A0 =C2=A0 00:00=C2=A0 =C2=A0 =C2= =A0

--------------------------------------------------------------------------= ---------------------------------------------------------------------------= -----------------------------

Total =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 119 kB/s | 115 kB =C2=A0 =C2=A0 00:00=C2=A0 =C2=A0 =C2=A0

=

Running rpm_c= heck_debug

Running Transaction Test

Transaction Test Succeeded

Running Transaction

=C2= =A0 Installing : x2goserver-4.0.1.19-3.el6.x86_64 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 1/2=C2=A0

=C2=A0 Installing := x2goagent-3.5.0.32-3.el6.x86_64=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 2/2=C2=A0

=C2=A0 Verifying=C2=A0 : x2go= agent-3.5.0.32-3.el6.x86_64=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 1/2=C2=A0

=C2=A0 Verifying=C2=A0 : x2goserver-= 4.0.1.19-3.el6.x86_64 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 2/2=C2=A0


Installed:

=C2=A0 x2goserver.x86= _64 0:4.0.1.19-3.el6 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0


Dependency Installed:

=C2=A0 x2goagent.x86_64 0:3.5.0.32-3.= el6=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0


Complete!=

% sudo ls -lhrt /var/lib/x2go<= /span>

tot= al 16K

-r= w-rw---- 1 root x2gouser 13K Jul 26 11:09 x2go_sessions


% x2godbadmin --createdb

DBI connect('dbname= =3D/var/lib/x2go/x2go_sessions','',...) failed: unable to open = database file at /usr/sbin/x2godbadmin line 103

ba= ckend=3Dsqlite at /usr/sbin/x2godbadmin line 103.

--001a113dd73a1270fc053883a824-- From ionic@ionic.de Sat Aug 13 23:11:26 2016 Received: (at 1063) by bugs.x2go.org; 13 Aug 2016 21:11:28 +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.6 required=3.0 tests=BAYES_05,DKIM_SIGNED, DKIM_VALID,DKIM_VALID_AU,SPF_HELO_PASS,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 EAB443C11D for <1063@bugs.x2go.org>; Sat, 13 Aug 2016 23:11:25 +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 A-DdTmXQb4wL for <1063@bugs.x2go.org>; Sat, 13 Aug 2016 23:11:19 +0200 (CEST) Received: from Root24.de (powered.by.root24.eu [5.135.3.88]) by ymir.das-netzwerkteam.de (Postfix) with ESMTP id 183653C11B for <1063@bugs.x2go.org>; Sat, 13 Aug 2016 23:11:18 +0200 (CEST) Received: from nopileos.local (178.162.222.41.adsl.inet-telecom.org [178.162.222.41]) by mail.ionic.de (Postfix) with ESMTPSA id 25CB04F03466; Sat, 13 Aug 2016 23:11:18 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=ionic.de; s=default; t=1471122678; bh=/KJrjNu0NZHO+9UpWYd/gsROgYY8Tv4YiQF1PKuVi78=; h=Subject:To:References:From:Date:In-Reply-To:From; b=dkqbxYUggbtnjSSeujEuxVCxVc+82GKsSphgBvYmmO5v2G7aG9SfqpGb4nMrAs6Ol Nr780vmIfuYRJQKoaCs2gmCxhL5LD1AXV2l02/gT9bBEsHkp+2phrcf83ild/7ekNo 5L6OOlrqivuu8pC81g9tpfJdZNEfGRbzKtgsEdSU= Subject: Re: CreateDB fails with error `DBI connect('dbname=/var/lib/x2go/x2go_sessions', '', ...) failed` To: Sivachidambaram Somu , 1063@bugs.x2go.org References: From: Mihai Moldovan Message-ID: Date: Sat, 13 Aug 2016 23:11:14 +0200 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:45.0) Gecko/20100101 Thunderbird/45.2.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="EbD0SJo5oiVuDPm1dKx1fCh6rh2DKB3pL" This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --EbD0SJo5oiVuDPm1dKx1fCh6rh2DKB3pL Content-Type: multipart/mixed; boundary="2xUxN2bgVgNXHiSCDUpKSAarIKxMkMtDt" From: Mihai Moldovan To: Sivachidambaram Somu , 1063@bugs.x2go.org Message-ID: Subject: Re: CreateDB fails with error `DBI connect('dbname=/var/lib/x2go/x2go_sessions', '', ...) failed` References: In-Reply-To: --2xUxN2bgVgNXHiSCDUpKSAarIKxMkMtDt Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable Control: tag -1 moreinfo On 26.07.2016 08:03 AM, Sivachidambaram Somu wrote: > Package: x2goserver > Version: 4.0.1.19-3.el6 >=20 > Upon installing x2goserver, when "x2godbadmin" script is used with crea= te DB > option, a DBI connect error is thrown by the script. As a result, upon > suspending/terminating the first session, the client refuses to reconne= ct to the > server displaying the error message given below. >=20 > *_Complete Error Message:_* >=20 > %x2godbadmin --createdb >=20 > DBI connect('dbname=3D/var/lib/x2go/x2go_sessions','',...) failed: unab= le to open > database file at /usr/sbin/x2godbadmin line 103 >=20 > backend=3Dsqlite at /usr/sbin/x2godbadmin line 103. Not quite sure what you do here or what the bug is. You're trying to create the DB as a user - which won't work. sudo x2godbadmin --createdb should work, instead, and judging from the DB's size (13 KB), it looks li= ke it was created successfully by the RPM scriptlets. So what's the *real* problem? Mihai --2xUxN2bgVgNXHiSCDUpKSAarIKxMkMtDt-- --EbD0SJo5oiVuDPm1dKx1fCh6rh2DKB3pL Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQIcBAEBCgAGBQJXr4z0AAoJEB/WLtluJTqHKEUQAJi7kq8Qe5I69Sv2iC4zAVtN fTjHea2jYjWysyciztNujRfsu/LJj7ntMqV5gFpgYD0MgyM6NturbM+3bI+hHoQn INRbc/Ous50pUPs+qgjeYQ0GO0g9QaVxNwuL/ESDYuEDueIWm2wG2tP1GiJdORj1 uN2SNKqTFHQXN8mPWQ81zFzpG9MVbFPLYYQ5uygOidukFhemviTK2pQgKtey/5W/ Oc69Yvzb98WoeLO2NCfXMp7Nq1yoY7DiP4SuNMI6ZqvM3aYaYa0Bnpc5hvgRliH5 DyKhAie/uFzi7sdrZqPO4+qMuTPPoVmZRSrBGwrYGChfJEgiRrCROamZg7Idp1KG KQMxbqghLIiSAZmRFQBytZ0xPByf6trx2yv8o8v1z1zbb77X+/DBmMjBOyQR0aCR HHAZlFOjM158NS22vu1YhjbFpwdyEeQEsXKOIgjW4ife7n0WudiwGJaPCyL0xQVL sHMC3WkEXK/LRc1Hne0N23phtVaUKtKdP7mjUWqP99XztZKRia7yn4OXTyr/iULe rUUHOTRDgK2ivhwFRBXWV91T6RGz2QqP8gHMLslS1RAeBHVfLZu6pfkQYSpE81i8 bQZSSGfSsfMa0Iq8aZV1TcjrQSodRzYA0z6jB9a5mDhPDq9XkRJkUuAMT71+bBFx NdHZ6ck3CqRk/29I2BL+ =1dEA -----END PGP SIGNATURE----- --EbD0SJo5oiVuDPm1dKx1fCh6rh2DKB3pL-- From arun.lisieux@gmail.com Sun Aug 14 03:13:04 2016 Received: (at 1063) by bugs.x2go.org; 14 Aug 2016 01:13:06 +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 38EAD5DEFE for <1063@bugs.x2go.org>; Sun, 14 Aug 2016 03:13:04 +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 QhaVd2jvjRLD for <1063@bugs.x2go.org>; Sun, 14 Aug 2016 03:12:57 +0200 (CEST) Received: from mail-qt0-f181.google.com (mail-qt0-f181.google.com [209.85.216.181]) by ymir.das-netzwerkteam.de (Postfix) with ESMTPS id 0447F5DDF4 for <1063@bugs.x2go.org>; Sun, 14 Aug 2016 03:12:57 +0200 (CEST) Received: by mail-qt0-f181.google.com with SMTP id x25so9025299qtx.2 for <1063@bugs.x2go.org>; Sat, 13 Aug 2016 18:12:56 -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=hu3HHHLJ8W+YY+it5OAeE0EdeNE3AAMT7OHwbk73Ij8=; b=WHdRSR93LOWqbdwyTr9skBvsGUnGVKkVVecdGeXb1aI1cXDl9A6+Dw/wNrnV6VbGvE MvtJ4IH5BwSG0CB66fuY5v6NlVEJYUBc7g0NZ0Xtux2KmVwzDrgrvN4JZ3DQMaW5BlmB Ocdeb6Le9Cw1wZe6XFqtP31nubggOO1jLeontnpTSjXRVEU5pq/S3cqQRNj1vYXGt/xQ noHIe2ZodIY//ApL+U/ghYR21e/DMA4NtFqxKaO4hxyFCZ4724R+OFw9VkWIlrM89aOV aN+rmKsGi+DFeMHJ9GapBvw2M9IFFmtJewX6cRbU6M0bNaFUQbSd3ZnQ5mC6+MNeHiDt 43xA== 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=hu3HHHLJ8W+YY+it5OAeE0EdeNE3AAMT7OHwbk73Ij8=; b=gKjuZvre9d7UWxj1SC5u8nzTomsDLc8LSCMz/veM5NBdFwaPUCb6D+fCFO4qwXwu0R PZtzZTVTtqlH9wv+U4C/vLwqrGUFiyv6AOqjg83RuMV/SsJnpAE0TrdRNAfM49lEUeWc /s3FTcxqDj4SEvIT+YukURybWj7WqeJlrGcI8e1vajNB+ayT3LFsVJdQ/z++Mr1LnSvI tZrHGDhVXoC3R2uKVW8vE1SJa4Ei35S/rohcxoo1Ncvjg+okIjrNRYZRDaiRMQQPlCaV r9y1ctHY7/jZwYHq9mu00bprBn+RcC79BWSDcEICCSS1gzQ/SufKYu4h+LHnaSG4CFc6 uWiA== X-Gm-Message-State: AEkooutq6KoZ0Y+kTTecn/tmdFSKZQZJgdS6dVAL9LZKm9+loJmo7rYwh6X3c1J/QeWgmjgZBV4NE9UPCtqDDQ== X-Received: by 10.237.36.112 with SMTP id s45mr25317404qtc.7.1471137175758; Sat, 13 Aug 2016 18:12:55 -0700 (PDT) MIME-Version: 1.0 Received: by 10.55.79.3 with HTTP; Sat, 13 Aug 2016 18:12:54 -0700 (PDT) Received: by 10.55.79.3 with HTTP; Sat, 13 Aug 2016 18:12:54 -0700 (PDT) In-Reply-To: References: From: Sivachidambaram Somu Date: Sun, 14 Aug 2016 06:42:54 +0530 Message-ID: Subject: Re: CreateDB fails with error `DBI connect('dbname=/var/lib/x2go/x2go_sessions', '', ...) failed` To: Mihai Moldovan Cc: 1063@bugs.x2go.org Content-Type: multipart/alternative; boundary=001a113fecdec6ecec0539fdd02e --001a113fecdec6ecec0539fdd02e Content-Type: text/plain; charset=UTF-8 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. On Aug 14, 2016 2:41 AM, "Mihai Moldovan" wrote: > Control: tag -1 moreinfo > > On 26.07.2016 08:03 AM, Sivachidambaram Somu wrote: > > Package: x2goserver > > Version: 4.0.1.19-3.el6 > > > > Upon installing x2goserver, when "x2godbadmin" script is used with > create DB > > option, a DBI connect error is thrown by the script. As a result, upon > > suspending/terminating the first session, the client refuses to > reconnect to the > > server displaying the error message given below. > > > > *_Complete Error Message:_* > > > > %x2godbadmin --createdb > > > > DBI connect('dbname=/var/lib/x2go/x2go_sessions','',...) failed: unable > to open > > database file at /usr/sbin/x2godbadmin line 103 > > > > backend=sqlite at /usr/sbin/x2godbadmin line 103. > > Not quite sure what you do here or what the bug is. > > You're trying to create the DB as a user - which won't work. > > sudo x2godbadmin --createdb > > should work, instead, and judging from the DB's size (13 KB), it looks > like it > was created successfully by the RPM scriptlets. > > So what's the *real* problem? > > > > Mihai > > --001a113fecdec6ecec0539fdd02e Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

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.

--001a113fecdec6ecec0539fdd02e-- From ionic@ionic.de Sun Aug 14 04:10:48 2016 Received: (at 1063) by bugs.x2go.org; 14 Aug 2016 02:10:50 +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.1 required=3.0 tests=BAYES_20,DKIM_SIGNED, DKIM_VALID,DKIM_VALID_AU,SPF_HELO_PASS,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 E31835DEFE for <1063@bugs.x2go.org>; Sun, 14 Aug 2016 04:10:47 +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 ecpnLXNoND5q for <1063@bugs.x2go.org>; Sun, 14 Aug 2016 04:10:41 +0200 (CEST) Received: from Root24.de (powered.by.root24.eu [5.135.3.88]) by ymir.das-netzwerkteam.de (Postfix) with ESMTP id 252A55DDF4 for <1063@bugs.x2go.org>; Sun, 14 Aug 2016 04:10:40 +0200 (CEST) Received: from nopileos.local (178.162.222.41.adsl.inet-telecom.org [178.162.222.41]) by mail.ionic.de (Postfix) with ESMTPSA id 600754F0346E; Sun, 14 Aug 2016 04:10:40 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=ionic.de; s=default; t=1471140640; bh=qAm4fggRr16vYgCWUXg+T542Uh2U/CtaWhF5e0j/vvc=; h=Subject:To:References:From:Date:In-Reply-To:From; b=ZcB4J2rGGCiFBTwPfNdvcDq5H506UFYMi8gS1qv2xIXuNj56sKjAXIzWO2LS9YVRB p0RA0W040mKTi5OUIsDUgTHkYxCaSajDkzkMmlduKyR2MQKNb1yUfpY3v2yvoZo6zt jaTnZi+8+eWQdVXQ4AT+e70XB4evBbnmJdzQmNgo= Subject: Re: CreateDB fails with error `DBI connect('dbname=/var/lib/x2go/x2go_sessions', '', ...) failed` To: Sivachidambaram Somu , 1063@bugs.x2go.org References: From: Mihai Moldovan Message-ID: Date: Sun, 14 Aug 2016 04:10:37 +0200 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:45.0) Gecko/20100101 Thunderbird/45.2.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="L4VoUb6QN9UBrjnd0xuIdUijmNEkiFmeI" This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --L4VoUb6QN9UBrjnd0xuIdUijmNEkiFmeI Content-Type: multipart/mixed; boundary="VEHaLPqwVfTL1iFGs4CgFCCkdED1aNFV1" From: Mihai Moldovan To: Sivachidambaram Somu , 1063@bugs.x2go.org Message-ID: Subject: Re: CreateDB fails with error `DBI connect('dbname=/var/lib/x2go/x2go_sessions', '', ...) failed` References: In-Reply-To: --VEHaLPqwVfTL1iFGs4CgFCCkdED1aNFV1 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable 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 c= onnection. That's both true and expected. The x2goserver scripts (for instance x2golistsessions) call a setuid/setg= id binary called libx2go-server-db-sqlite3-wrapper (nightlies) or x2gosqlite= wrapper (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 --VEHaLPqwVfTL1iFGs4CgFCCkdED1aNFV1-- --L4VoUb6QN9UBrjnd0xuIdUijmNEkiFmeI Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQIcBAEBCgAGBQJXr9MeAAoJEB/WLtluJTqH+3cQALi3qRWfmKWTfWVk6AE1BULa UboP9R0ok4Cf9t5IKXQxEEubIvQtZ6PgavicPI46fFOyh5Kk5PXLF2dNCGCAKoJE B1uZAuok/zc4XK6qIafByRo1DyMphhW0sxJqTrzd8cHvKU0pAqTaotacDFgTmiGr VO3viKivF6u++fPMjAfp46heUuRW1izyzQ5t/9XJgwbAGsNl2htGXzlwRnwoxGRN a0i7xufbEVw4nGQEzLBhOhbRNeQNHJmS35ZwKrBCVRwhVHIPhLRVpxForLIyMXQs XQ/rKFwDiFLJf6JV5flywfduumDmRBTP/vJsyNMAeJjGKlUh8ogmDltXv/g/Cvw0 xTjgHRLHLdUMNigA3L0sfx9IBVs7muG7FAnC3kueW3w4prMyP/Qe5bDK/0erWGWK XBdykQbR2FgU95vSH194CYQkVICWdnF2W0h7BSY/cbtV0ENbnjZRAJmj+jwz8YBI vfNjxFzdQQqQ7g4SREe0PkwgeKCWLXKPWi5IMPnqkYUa52nwQMDDvLrJXlXR1vnX /7brw6+ulCQlIglAhmD8NTS1nBgzoXTAEGYWAwVmjK4n86LObjLm1kOFB4/4ZPoO kDbP8xClQjPA9EzsjLKXvtbKuuBweHzMeBJxAXEqUhJfupdP3DVevP6+H79NcZxd guf9b4I4/gp308S7ohGr =oU+t -----END PGP SIGNATURE----- --L4VoUb6QN9UBrjnd0xuIdUijmNEkiFmeI-- From arun.lisieux@gmail.com Wed Aug 24 08:30:37 2016 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: Subject: Re: CreateDB fails with error `DBI connect('dbname=/var/lib/x2go/x2go_sessions', '', ...) failed` 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-- From ionic@ionic.de Wed Aug 24 21:20:10 2016 Received: (at 1063) by bugs.x2go.org; 24 Aug 2016 19:20:15 +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=-2.0 required=3.0 tests=BAYES_00,DKIM_SIGNED, DKIM_VALID,DKIM_VALID_AU,SPF_HELO_PASS,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 0327E5DEFE for <1063@bugs.x2go.org>; Wed, 24 Aug 2016 21:20:10 +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 whyXhLf5GVWi for <1063@bugs.x2go.org>; Wed, 24 Aug 2016 21:20:03 +0200 (CEST) Received: from Root24.de (powered.by.root24.eu [5.135.3.88]) by ymir.das-netzwerkteam.de (Postfix) with ESMTP id 603945DA8E for <1063@bugs.x2go.org>; Wed, 24 Aug 2016 21:20:01 +0200 (CEST) Received: from nopileos.local (178.162.222.41.adsl.inet-telecom.org [178.162.222.41]) by mail.ionic.de (Postfix) with ESMTPSA id 0B4214F03514; Wed, 24 Aug 2016 21:20:00 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=ionic.de; s=default; t=1472066401; bh=OCEPokSzzoP6vGj2ASTl/hAj5XO6zzS5z66/no6iH7I=; h=Subject:To:References:Cc:From:Date:In-Reply-To:From; b=RD5ZXWq4mYfn4ZeyiKvHWY+Q7m5dBdi893Hm6KEYNkpq+RlkX5GOwAq1uPPIaipG+ OhqEMkHCB2l6HI5X7LY/RjPjvOo2sOrOowhXfsy2cju8WGiulUT8WlJ8KO/W6BdE/r Ww1HpgSw3i1JrmCisJfyjjCaeJRQhI73ypt7nWW8= Subject: Re: CreateDB fails with error `DBI connect('dbname=/var/lib/x2go/x2go_sessions', '', ...) failed` To: Sivachidambaram Somu References: Cc: 1063@bugs.x2go.org From: Mihai Moldovan Message-ID: <6b41f5b6-82ff-273c-ff64-390c17a44dea@ionic.de> Date: Wed, 24 Aug 2016 21:19:59 +0200 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:45.0) Gecko/20100101 Thunderbird/45.2.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="mBNGG9lEHRqfkME37LUhsaQUQ1wr92D5t" This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --mBNGG9lEHRqfkME37LUhsaQUQ1wr92D5t Content-Type: multipart/mixed; boundary="oxhRhasWGfnnnqc47o8q3vWxnxgw1XBbl" From: Mihai Moldovan To: Sivachidambaram Somu Cc: 1063@bugs.x2go.org Message-ID: <6b41f5b6-82ff-273c-ff64-390c17a44dea@ionic.de> Subject: Re: CreateDB fails with error `DBI connect('dbname=/var/lib/x2go/x2go_sessions', '', ...) failed` References: In-Reply-To: --oxhRhasWGfnnnqc47o8q3vWxnxgw1XBbl Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable On 24.08.2016 08:30 AM, Sivachidambaram Somu wrote: > Hi Mihai, >=20 > My apologies for the late reply. I had to undergo a minor surgery and w= as out of > my machine for a couple of weeks. Oh, that's definitely more important. I hope everything is fine again. > Coming back to your question, I do find x2gosqlitewrapper under > '/usr/lib64/x2go' folder (complete contents are listed below). I also f= ind the > 'x2go_sessions' file under '/var/lib/x2go' folder, which is owned by x2= gouser in > root domain. This happens automatically after I install x2goserver. >=20 > However, the client still gives out the error mentioned in my first ema= il. >=20 > _*Contents of '/var/lib/x2go' folder:*_ >=20 > % sudo ls -lhrt /var/lib/x2go=20 >=20 > total 16K >=20 > -rw-rw---- 1 root x2gouser 13K Aug 24 11:43 x2go_sessions Okay. > *_Contents of '/usr/lib64/x2go' folder:_* >=20 > %ls -lhrt /usr/lib64/x2go=20 >=20 > total 132K >=20 > [...] > -rwxr-sr-x 1 root x2gouser 5.1K Apr 27 2015 x2gosqlitewrapper > [...] That's okay as well. Hmm... did you somehow disable SUID support? Maybe via the "nosuid" mount= option for /var? So... just to make that clear, x2golistsessions_root works fine as root, = but x2golistsessions fails as a normal user when ran via SSH? Mihai --oxhRhasWGfnnnqc47o8q3vWxnxgw1XBbl-- --mBNGG9lEHRqfkME37LUhsaQUQ1wr92D5t Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQIcBAEBCgAGBQJXvfNgAAoJEB/WLtluJTqH2i8P/3s8CRvPcsn7zRgHibWH5Tzu BZxrl4TuKwhLcJFqNtxYm9gmt+OwhLwGlsM/NgDzNEHGNEjN8i4o/m0IY6NZji2t 4TPihPoy+hb8js0R9IIQOSoKZhJYpbQ7JPIFqN5aVNmyLzMdLiI8BmIcO9jjYoYV VCaHR+zJpNQ662NDhNWqnDC+aECIEb/J16OPppZbrA5pfwKdHuDCuwwJOGNHmpg8 P3/oWmiMhUj9j3T4MPUaWrdy9E5NHbAWgG3Bf/tFB0e65QGg2S02FF+UUB0KR9QZ yl9Zrit0NF/6NPxB1U+P1IZ+kbHHzIj3N2Xdtsp4R3zC9lLHYw4RLcLDGYsow0Bs sQKcn+dI5zUoL+GKDk8BM1sNWb65OyIpznuNxM68whLSV+my08T09GzjPBNwLFzu XX2fsQEKkAEDkTDSK6Z8AmhAWigWY9bO+6D1/87KDKWisXtvtTpml1PUPfApSncG hvXukC5PdoNb2QyC4FJimgIufPfJiJt2Dxe7XDz3Zh9gSRKUHIeCTauYgt4YV+BV G6qwKOjJqtW9m8w8sStnPuHOJ6HnkyLcVSlFQ3E8MCROD6ZiiNcfOzXMItsv1YEy vYF+Bj9VEOR56kco1yGDpAxSSr2FktSV8z+HcfoWbxN5KOlNXKcrB4Fdtnk6Exyl UleiMGsaQTX5cEkulV9I =JFB8 -----END PGP SIGNATURE----- --mBNGG9lEHRqfkME37LUhsaQUQ1wr92D5t-- From arun.lisieux@gmail.com Sat Aug 27 12:38:23 2016 Received: (at 1063) by bugs.x2go.org; 27 Aug 2016 10:38:25 +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 915A85DEFE for <1063@bugs.x2go.org>; Sat, 27 Aug 2016 12:38:23 +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 M31fm67erMiV for <1063@bugs.x2go.org>; Sat, 27 Aug 2016 12:38:16 +0200 (CEST) Received: from mail-qt0-f182.google.com (mail-qt0-f182.google.com [209.85.216.182]) by ymir.das-netzwerkteam.de (Postfix) with ESMTPS id 1556B5DA8E for <1063@bugs.x2go.org>; Sat, 27 Aug 2016 12:38:15 +0200 (CEST) Received: by mail-qt0-f182.google.com with SMTP id u25so49071312qtb.1 for <1063@bugs.x2go.org>; Sat, 27 Aug 2016 03:38:15 -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=9NdmbAPBYqtcrN+BQkTIxZ2Ic6efSxfUBcVKOaQTrIs=; b=PWdfCB4qvDSbybZ7tSFMC3EZ2ei0no/sej9i/kQ5JhRBKDmRm/fCHOJYVNXfNLFMkD p5azCHhFrs8hleMFM4ssuwczRmQUHVXH1Gm3B1N+GTlfVH05vDCC/HXBcIj6n6OAC8qZ gBnRBpP98Enbgq4v05YydQjL4CAIQtBn72Xhyf/bC4CYyx0aSl7rDZqs6RlkHpBjuUKF x2NrvP2Sx1SMXpYfSEdBnXUkK4nyEjlze2WnAal0vXnVgCF8IfntThwEvufhcTII1z58 hlsrhJYDapVyc3n+ceM1F+6dyHaMpsjVoll3Asu7squ0U5Ji2gLOBxkOgH5K5M3MJLe8 nDxg== 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=9NdmbAPBYqtcrN+BQkTIxZ2Ic6efSxfUBcVKOaQTrIs=; b=fPNYJG25uw/Wm4JMNazsZg7ybVx8tSCb/+sW46kADoUPrU5UilA7Uli34VeNPS9mIk mo8NTR7RpQPbcFSxcM5JH+xQcdPiEEK711J2PUgnfUuRh0K7MCe7cgneAUDVTqe/zAip EKPh2qYeb3R21Uez/hBkuh9RPCpXt4l/Bv4ZnLqb2uAaM2Jn1xDANUkg2lv9U/6qYbvz OGWWmr6jy80fFwdSSF8qwOkxZF1LZ/P/Ig91r4XMo7b39v77U4HbRX45tXAODyhPcYhf OPcYsBsXes6771jjABt129XwoO3idjfacoMfoza2b2cIbDBorx+rN2nD6R82qUtFTURu afgQ== X-Gm-Message-State: AE9vXwMgD0ZVBwPOAq0LZxTE3RpeZ2nlXIJ6G6JtoSwxWIKVDvsCpwm1db3AOUGAHAW0OcdBmly0+mes7P/erQ== X-Received: by 10.237.36.173 with SMTP id t42mr8475379qtc.89.1472294294678; Sat, 27 Aug 2016 03:38:14 -0700 (PDT) MIME-Version: 1.0 Received: by 10.55.175.197 with HTTP; Sat, 27 Aug 2016 03:38:13 -0700 (PDT) Received: by 10.55.175.197 with HTTP; Sat, 27 Aug 2016 03:38:13 -0700 (PDT) In-Reply-To: <6b41f5b6-82ff-273c-ff64-390c17a44dea@ionic.de> References: <6b41f5b6-82ff-273c-ff64-390c17a44dea@ionic.de> From: Sivachidambaram Somu Date: Sat, 27 Aug 2016 16:08:13 +0530 Message-ID: Subject: Re: CreateDB fails with error `DBI connect('dbname=/var/lib/x2go/x2go_sessions', '', ...) failed` To: Mihai Moldovan Cc: 1063@bugs.x2go.org Content-Type: multipart/alternative; boundary=001a114060be707152053b0b3a7c --001a114060be707152053b0b3a7c Content-Type: text/plain; charset=UTF-8 Health is better now. Thanks for asking :) About the SUID, I have not disabled it myself. Let me check the OS defaults again and give an update on that. Also, I'm able to open them file 'x2golistsessions' in Vim as root. As you have pointed out, the operation fails as a normal user. On Aug 25, 2016 12:50 AM, "Mihai Moldovan" wrote: > On 24.08.2016 08:30 AM, Sivachidambaram Somu wrote: > > 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. > > Oh, that's definitely more important. I hope everything is fine again. > > > > 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 > > Okay. > > > > *_Contents of '/usr/lib64/x2go' folder:_* > > > > %ls -lhrt /usr/lib64/x2go > > > > total 132K > > > > [...] > > -rwxr-sr-x 1 root x2gouser 5.1K Apr 27 2015 x2gosqlitewrapper > > [...] > > That's okay as well. > > > Hmm... did you somehow disable SUID support? Maybe via the "nosuid" mount > option > for /var? > > > So... just to make that clear, x2golistsessions_root works fine as root, > but > x2golistsessions fails as a normal user when ran via SSH? > > > > Mihai > > --001a114060be707152053b0b3a7c Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

Health is better now. Thanks for asking :)

About the SUID, I have not disabled it myself. Let me check = the OS defaults again and give an update on that.

Also, I'm able to open them file 'x2golistsessions&#= 39; in Vim as root. As you have pointed out, the operation fails as a norma= l user.


On Aug 25, 2016 1= 2:50 AM, "Mihai Moldovan" <i= onic@ionic.de> wrote:
On 24.08.2016 08:30 AM, Sivachidambaram Somu wrote:
> 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.

Oh, that's definitely more important. I hope everything is fine again.<= br>

> 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, whi= ch 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 em= ail.
>
> _*Contents of '/var/lib/x2go' folder:*_
>
> %=C2=A0 sudo ls -lhrt /var/lib/x2go
>
> total 16K
>
> -rw-rw---- 1 root x2gouser 13K Aug 24 11:43 x2go_sessions

Okay.


> *_Contents of '/usr/lib64/x2go' folder:_*
>
> %ls -lhrt /usr/lib64/x2go
>
> total 132K
>
> [...]
> -rwxr-sr-x=C2=A0 1 root x2gouser 5.1K Apr 27=C2=A0 2015 x2gosqlitewrap= per
> [...]

That's okay as well.


Hmm... did you somehow disable SUID support? Maybe via the "nosuid&quo= t; mount option
for /var?


So... just to make that clear, x2golistsessions_root works fine as root, bu= t
x2golistsessions fails as a normal user when ran via SSH?



Mihai

--001a114060be707152053b0b3a7c-- From ionic@ionic.de Sat Aug 27 18:33:20 2016 Received: (at 1063) by bugs.x2go.org; 27 Aug 2016 16:33:35 +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.1 required=3.0 tests=BAYES_20,DKIM_SIGNED, DKIM_VALID,DKIM_VALID_AU,SPF_HELO_PASS,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 6DD145DEFE for <1063@bugs.x2go.org>; Sat, 27 Aug 2016 18:33:20 +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 FsNWsc6PILLX for <1063@bugs.x2go.org>; Sat, 27 Aug 2016 18:33:14 +0200 (CEST) Received: from Root24.de (powered.by.root24.eu [5.135.3.88]) by ymir.das-netzwerkteam.de (Postfix) with ESMTP id DD67F5DA8E for <1063@bugs.x2go.org>; Sat, 27 Aug 2016 18:33:13 +0200 (CEST) Received: from nopileos.local (178.162.222.41.adsl.inet-telecom.org [178.162.222.41]) by mail.ionic.de (Postfix) with ESMTPSA id 10A734F0004F; Sat, 27 Aug 2016 18:33:12 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=ionic.de; s=default; t=1472315593; bh=FdYBM6q+drJwcACYXHmpW3YsgGQR0W73RIC5wbvsdYI=; h=Subject:To:References:From:Date:In-Reply-To:From; b=Sdo8vtmjNDfccOvflUeDhdFwvxuTGPWWi2VgENLNov0hKw+lWwH/EMZgU/4CMvLtR q3DyZKpFLdwUVVJclOL7Q/qlNjnjbpaWL8YefCPgmmzNT+aZSJLx/rp1JWK7Er3PgI MSbQKeLEgAx7V+qkvLcnBEViJF7AbElZJuoW58qE= Subject: Re: CreateDB fails with error `DBI connect('dbname=/var/lib/x2go/x2go_sessions', '', ...) failed` To: Sivachidambaram Somu , 1063@bugs.x2go.org References: <6b41f5b6-82ff-273c-ff64-390c17a44dea@ionic.de> From: Mihai Moldovan Message-ID: <406759e0-2a96-8582-cc8e-46cd28a2779b@ionic.de> Date: Sat, 27 Aug 2016 18:33:11 +0200 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:45.0) Gecko/20100101 Thunderbird/45.2.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="lnnR2H23b5uXjhvnkKiMqVekjdJdbdR11" This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --lnnR2H23b5uXjhvnkKiMqVekjdJdbdR11 Content-Type: multipart/mixed; boundary="Ebgp9DUL1fwrdbBPQDokuvEPkCuNjGbTm" From: Mihai Moldovan To: Sivachidambaram Somu , 1063@bugs.x2go.org Message-ID: <406759e0-2a96-8582-cc8e-46cd28a2779b@ionic.de> Subject: Re: CreateDB fails with error `DBI connect('dbname=/var/lib/x2go/x2go_sessions', '', ...) failed` References: <6b41f5b6-82ff-273c-ff64-390c17a44dea@ionic.de> In-Reply-To: --Ebgp9DUL1fwrdbBPQDokuvEPkCuNjGbTm Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable On 27.08.2016 12:38 PM, Sivachidambaram Somu wrote: > About the SUID, I have not disabled it myself. Let me check the OS defa= ults > again and give an update on that. Looks like I haven't been explicit enough, sorry. What's the output of "mount"? > Also, I'm able to open them file 'x2golistsessions' in Vim as root. As = you have > pointed out, the operation fails as a normal user. Wait... do you *really* mean x2golistsessions, or rather the database fil= e called x2go_sessions? The script itself (x2golistsessions) should always be read- and executabl= e by any user. I've also been looking around if disabling SUID support directly in the k= ernel is possible, but haven't found anything related to this. Looks like the o= nly way to achieve that is via a mount flag. If that's not the case, I'm running = dry here. Mihai --Ebgp9DUL1fwrdbBPQDokuvEPkCuNjGbTm-- --lnnR2H23b5uXjhvnkKiMqVekjdJdbdR11 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQIcBAEBCgAGBQJXwcDHAAoJEB/WLtluJTqH9hUQAIIgR8Si3vazRMbvJhhhUkd7 Ke4PeiiHfb0Qrng3bhIysADOv6HqTBfu1baM37cWjLRwaf8K2zOkhB0eLea4sX1h Q4JDC3+niwnPJtV2rqukaj/h02E/fbBb1tnaGNIA+2d+i6gTt3VthHAtukuGxnVl JqiVZosPMUQiVh4BSJzE+xyBC9r+Qbzi4Q3Okxdqk1KLTP8zq6QPqefwWquSshbn TZIaQEUMO0GlxoXBK3voyG2PBy+AE11hMUcvmzjlgVxeLCK33Pi3SZ/+USjAs7op 7q4QqyGoLG172VKi2f7xw7la8DwCxnyuuVKK8ssEAUXLoFVv3pPgbpeKxeI71Oid drrBc0iapPsLCzaWkBALCc/TpSedlcqo2sBassA3VNOC5HrWcxGdjurW401ANBeF f4H/xLFV2Pmxm+IoANxB1S6iI8v5l3NFxOY8UKr4s7vg0L+U7UuWNYTVC9dDaDyx bMTnFXDOyx0J5QUeInQav3NZVyHIXBkS223F62INSm4drs+HTgVPHt/H91fjYFeu /67ufk+G6eEHGY8/6Wk/pI/X+56FJ7TSxWrPGL5JbJv0XeHfvJBisFr6gzVldZwe OVImCciIz2TaYcD666QLI5YQO55mFOD2mYoO8N03k+EU3Pa5xh4QXM4CSnWGhcam e0vGr3ZdwGAROTNtzWEW =xKwu -----END PGP SIGNATURE----- --lnnR2H23b5uXjhvnkKiMqVekjdJdbdR11-- From arun.lisieux@gmail.com Mon Aug 29 11:33:48 2016 Received: (at 1063) by bugs.x2go.org; 29 Aug 2016 09:33:51 +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 5A9B85DA95 for <1063@bugs.x2go.org>; Mon, 29 Aug 2016 11:33:48 +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 zjRiWVrFskaW for <1063@bugs.x2go.org>; Mon, 29 Aug 2016 11:33:41 +0200 (CEST) Received: from mail-qk0-f172.google.com (mail-qk0-f172.google.com [209.85.220.172]) by ymir.das-netzwerkteam.de (Postfix) with ESMTPS id 75BC55DA8E for <1063@bugs.x2go.org>; Mon, 29 Aug 2016 11:33:41 +0200 (CEST) Received: by mail-qk0-f172.google.com with SMTP id l2so132107992qkf.3 for <1063@bugs.x2go.org>; Mon, 29 Aug 2016 02:33:41 -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=Xto6CQCbwxeK2t1u7e8YxiPCSQUUgaPBVSAx4VNM6uQ=; b=I65PeBdCu6nOh1qMCVLIwkj7O/B7obs8hUAQra/baeBe1JvcqmWjQooOFAD+OxM4RT fEQIFK72ySnWok1yLwZxLbJFB3zLs8P07oRccr1cE5lXi1+kwElUnF6LRVAUyz8MXMzY j1c869+10+UCpo0aS9lFC/bsGoWH7TMVsqYR6r102qyrgnW0yBiARvx2fC62HhBeqc5X LmErGOApkUQPQmiVb3cFffEdt9XjCFvfdWHJNPu2opEWuGy/0kmP2W+pPKoECd0P91uc ieXpLEl1Bi1dV4FtdHniZXrU6YwJKsPiTPwX7Yg8iytKoSHM8kCW2VO+C+Y99Rn6tZ/R uUKA== 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=Xto6CQCbwxeK2t1u7e8YxiPCSQUUgaPBVSAx4VNM6uQ=; b=Pjtcl3YI2Ox3GIWSgQijiomPK25Cj15hNPictuVD2TpNIgNTnKv9qAnRZG7CPNNGkd Wdrgmok7CkKBeMbkjPnhNBoJ++5MEELKpVwSDBIdfo3Uln4/tDKr46Px8IvL28qz8+Mc zI8JCRI5lt4S14qu3ucQAL3I5WgFKMRMHWuGdVrR6e1fXGq6W9qT1wquFHpSOMSroEt2 fMFzaP8Xurdky6IBCBQXjB5+61yHvXDWszEnDS5LcnQAI+2i+2g8y6c54ySqj/Wbr7yG fv59sF7K6BxWH+nRHN2Dzl46yMF3xjYWKQItRxuqxQNLOBMQ4CU2u8JFOyWvxcARNEH1 xH8Q== X-Gm-Message-State: AE9vXwO5c66jC/NAzm2UiRkdSTyY6b+c3wDNKEitUZUEcAS1BIBJQ2mtC13w0kF7rkjMtghHHcSLctasyobAsg== X-Received: by 10.55.130.70 with SMTP id e67mr17186491qkd.101.1472463220174; Mon, 29 Aug 2016 02:33:40 -0700 (PDT) MIME-Version: 1.0 Received: by 10.55.175.197 with HTTP; Mon, 29 Aug 2016 02:33:39 -0700 (PDT) In-Reply-To: <406759e0-2a96-8582-cc8e-46cd28a2779b@ionic.de> References: <6b41f5b6-82ff-273c-ff64-390c17a44dea@ionic.de> <406759e0-2a96-8582-cc8e-46cd28a2779b@ionic.de> From: Sivachidambaram Somu Date: Mon, 29 Aug 2016 15:03:39 +0530 Message-ID: Subject: Re: CreateDB fails with error `DBI connect('dbname=/var/lib/x2go/x2go_sessions', '', ...) failed` To: Mihai Moldovan Cc: 1063@bugs.x2go.org Content-Type: multipart/alternative; boundary=94eb2c074b0a2ef3e8053b328fb3 --94eb2c074b0a2ef3e8053b328fb3 Content-Type: text/plain; charset=UTF-8 My bad. I have given below the output of the mount command on my machine. % mount /dev/xvda1 on / type auto (rw,noatime) proc on /proc type proc (rw) sysfs on /sys type sysfs (rw) devpts on /dev/pts type devpts (rw,gid=5,mode=620) tmpfs on /dev/shm type tmpfs (rw) /dev/mapper/ephemeralVG-ephemeral on /local type ext4 (rw) none on /proc/sys/fs/binfmt_misc type binfmt_misc (rw) fusectl on /sys/fs/fuse/connections type fusectl (rw) Also, I meant "x2go_sessions" file. The x2golistsessions script is executable by all users and present under /usr/bin as you said. % ls -lhrt /usr/bin/x2golist* -rwxr-xr-x 1 root root 3.3K Apr 27 2015 */usr/bin/x2golistsessions* -rwxr-xr-x 1 root root 1.4K Apr 27 2015 */usr/bin/x2golistmounts* -rwxr-xr-x 1 root root 3.0K Apr 27 2015 */usr/bin/x2golistdesktops* Regards, Siva Chidambaram Somu On Sat, Aug 27, 2016 at 10:03 PM, Mihai Moldovan wrote: > On 27.08.2016 12:38 PM, Sivachidambaram Somu wrote: > > About the SUID, I have not disabled it myself. Let me check the OS > defaults > > again and give an update on that. > > Looks like I haven't been explicit enough, sorry. > > What's the output of "mount"? > > > > Also, I'm able to open them file 'x2golistsessions' in Vim as root. As > you have > > pointed out, the operation fails as a normal user. > > Wait... do you *really* mean x2golistsessions, or rather the database file > called x2go_sessions? > > The script itself (x2golistsessions) should always be read- and executable > by > any user. > > > I've also been looking around if disabling SUID support directly in the > kernel > is possible, but haven't found anything related to this. Looks like the > only way > to achieve that is via a mount flag. If that's not the case, I'm running > dry here. > > > > Mihai > > --94eb2c074b0a2ef3e8053b328fb3 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
My bad. I have given below the output of the mount command= on my machine.

% mount

/dev/xvda1 on / type auto (rw,noatime)

proc on /proc type proc (rw)

sysfs on /sys type sysfs (rw)

devpts on /dev/pts type devpts (rw,gid=3D5,m= ode=3D620)

tmpfs on /dev/shm type tmpfs (rw)

/dev/mapper/ephemeralVG-ephemeral on /local = type ext4 (rw)

none on /proc/sys/fs/binfmt_misc type binfmt= _misc (rw)

fusectl on /sys/fs/fuse/connections type fus= ectl (rw)

Also, I meant &q= uot;x2go_sessions" file. The x= 2golistsessions script is executable by all users and present under /usr/bi= n as you said.

% ls -lhrt /usr/bin/x2golist*

-rwxr-xr-x 1 root root 3.3K Apr 27=C2=A0 2015 /= usr/bin/x2golistsessions

-rwxr= -xr-x 1 root root 1.4K Apr 27=C2=A0 2015 /usr/bi= n/x2golistmounts

-rwxr-xr-x 1 root root 3.0K Apr 2= 7=C2=A0 2015 /usr/bin/x2golistdesktops


Regards,
Siva = Chidambaram Somu

On Sat, Aug 27, 2016 at 10:03 PM, Mihai Mold= ovan <ionic@ionic.de> wrote:
= On 27.08.2016 12:38 PM, Sivachidambaram Somu wrote:
> About the SUID, I have not disabled it myself. Let me check the OS def= aults
> again and give an update on that.

Looks like I haven't been explicit enough, sorry.

What's the output of "mount"?


> Also, I'm able to open them file 'x2golistsessions' in Vim= as root. As you have
> pointed out, the operation fails as a normal user.

Wait... do you *really* mean x2golistsessions, or rather the databas= e file
called x2go_sessions?

The script itself (x2golistsessions) should always be read- and executable = by
any user.


I've also been looking around if disabling SUID support directly in the= kernel
is possible, but haven't found anything related to this. Looks like the= only way
to achieve that is via a mount flag. If that's not the case, I'm ru= nning dry here.



Mihai


--94eb2c074b0a2ef3e8053b328fb3-- From ionic@ionic.de Tue Aug 30 05:33:19 2016 Received: (at 1063) by bugs.x2go.org; 30 Aug 2016 03:33:21 +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=-2.0 required=3.0 tests=BAYES_00,DKIM_SIGNED, DKIM_VALID,DKIM_VALID_AU,SPF_HELO_PASS,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 7D8E63C11F for <1063@bugs.x2go.org>; Tue, 30 Aug 2016 05:33:19 +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 vjvaXervz5DA for <1063@bugs.x2go.org>; Tue, 30 Aug 2016 05:33:13 +0200 (CEST) Received: from Root24.de (powered.by.root24.eu [5.135.3.88]) by ymir.das-netzwerkteam.de (Postfix) with ESMTP id EECC03C11D for <1063@bugs.x2go.org>; Tue, 30 Aug 2016 05:33:12 +0200 (CEST) Received: from nopileos.local (178.162.222.41.adsl.inet-telecom.org [178.162.222.41]) by mail.ionic.de (Postfix) with ESMTPSA id B4DC54F0061E; Tue, 30 Aug 2016 05:33:11 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=ionic.de; s=default; t=1472527992; bh=3saWLA3llE3Ie3nCBatoEcrR2kTdIxTNMKg/cGmLHVY=; h=Subject:To:References:Cc:From:Date:In-Reply-To:From; b=Cym7aYBhWKqU4IKgZP1MC1rSHlyJlfCYoFkLA3Gz9W2Y2WtUYnhqOZ7WH2bhz861m sfmSy35DsS0L/UY50zSLy0TlVI0c0z6bmIbjNMukPKeA0Qqj6peNLehDoZRn0GOyM2 ypEreYSl5LRAlALAuazl7Pbd/UnkVV7oVxVhA9Y8= Subject: Re: CreateDB fails with error `DBI connect('dbname=/var/lib/x2go/x2go_sessions', '', ...) failed` To: Sivachidambaram Somu References: <6b41f5b6-82ff-273c-ff64-390c17a44dea@ionic.de> <406759e0-2a96-8582-cc8e-46cd28a2779b@ionic.de> Cc: 1063@bugs.x2go.org From: Mihai Moldovan Message-ID: <6fffe69a-2581-66a2-755f-93b84067e2be@ionic.de> Date: Tue, 30 Aug 2016 05:33:08 +0200 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:45.0) Gecko/20100101 Thunderbird/45.2.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="2Dkd74P5DsdIxIuBJ2VHBhB0xRtsg0jj2" This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --2Dkd74P5DsdIxIuBJ2VHBhB0xRtsg0jj2 Content-Type: multipart/mixed; boundary="c8XgBFVdTGfgXaoW8nvSbjJvPTf9Duf0B" From: Mihai Moldovan To: Sivachidambaram Somu Cc: 1063@bugs.x2go.org Message-ID: <6fffe69a-2581-66a2-755f-93b84067e2be@ionic.de> Subject: Re: CreateDB fails with error `DBI connect('dbname=/var/lib/x2go/x2go_sessions', '', ...) failed` References: <6b41f5b6-82ff-273c-ff64-390c17a44dea@ionic.de> <406759e0-2a96-8582-cc8e-46cd28a2779b@ionic.de> In-Reply-To: --c8XgBFVdTGfgXaoW8nvSbjJvPTf9Duf0B Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable On 29.08.2016 11:33 AM, Sivachidambaram Somu wrote: > My bad. I have given below the output of the mount command on my machin= e. >=20 > %mount >=20 > /dev/xvda1 on / type auto (rw,noatime) >=20 > proc on /proc type proc (rw) >=20 > sysfs on /sys type sysfs (rw) >=20 > devpts on /dev/pts type devpts (rw,gid=3D5,mode=3D620) >=20 > tmpfs on /dev/shm type tmpfs (rw) >=20 > /dev/mapper/ephemeralVG-ephemeral on /local type ext4 (rw) >=20 > none on /proc/sys/fs/binfmt_misc type binfmt_misc (rw) >=20 > fusectl on /sys/fs/fuse/connections type fusectl (rw) Okay, no "nosuid" option in there, so that's also ruled out. As a test, set the setgid bit on the id binary like this: sudo chmod g+s $(which id) then, as a non-root user(!) run: id -g Make sure to disable the setgit bit again with: sudo chmod g-s $(which id) If the previous id -g call returned an effective group ID of 0, that mean= s that setgid functionality should be working on your system. If it's not 0, the= reason for your problems are likely that setgid on files is not working correctl= y on your system. Mihai --c8XgBFVdTGfgXaoW8nvSbjJvPTf9Duf0B-- --2Dkd74P5DsdIxIuBJ2VHBhB0xRtsg0jj2 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQIcBAEBCgAGBQJXxP52AAoJEB/WLtluJTqH+3cP/RTU0XuJrUAcWOsnnEpAQbqU oH88NZM7GnlmaMFERqtR1W4guqotMINx3NPu6efOy7HZGNXkjJQWFS1C425zHVT3 KQlvlMLGYSOHSHkI3L0PL2lmlcrhW2TKbCtkeDdCRYE4nezyLtdJEJJhlUvoA1VH qhJvJartfBlNeyL3xoMkeNAl9J0NRGjVc8x6KI6y57GUj49Ygtws48bJeSCmL/R8 SkwQcLyS7KArE5VD2oKnKG/rYQqKUmvhW/BygZI1SrNs8M7MHbgYgy+1b+7MQlxS Ln4fcX2A8z99Cj0DrIdayhIaQWa1SrqcOAkmk421tdvme7ByJ6MdJM4HeHDt7jkl zZ/QGKg/I6Icnal4oO0/dHJPumf1eA50U2/p9pPw+u2zGSSCkMd7apzXVQhiI2ln jeYjt6VKKPg9sKh5tuYUqXBlNgzgqMVqzKENewjkt27ZdiiHRS1ftY2gWJh+38qS ERaDGqF9UkZT050sqk0LyeitI2uiFLeG4FUXiirQuYcuHToMeZsRNCEL+BXxMftG nFKmPC1wT9CQVRHAa6oGGvNQ4JUC3/WsLNO2p6G7k8JpfWR/1tQS9ybTouSBxX8J FfJVgkgCPdGOze/QXZNKAjitz+qgl0keIsveptwyll3kxIUSMTr9YPz1tiPxg6yE vIULhom33ZknnHbTAT5l =mYs6 -----END PGP SIGNATURE----- --2Dkd74P5DsdIxIuBJ2VHBhB0xRtsg0jj2-- From arun.lisieux@gmail.com Tue Aug 30 18:05:59 2016 Received: (at 1063) by bugs.x2go.org; 30 Aug 2016 16:06:00 +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 BD09E5DEFC for <1063@bugs.x2go.org>; Tue, 30 Aug 2016 18:05:58 +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 d2QpATAeYewq for <1063@bugs.x2go.org>; Tue, 30 Aug 2016 18:05:52 +0200 (CEST) Received: from mail-qk0-f181.google.com (mail-qk0-f181.google.com [209.85.220.181]) by ymir.das-netzwerkteam.de (Postfix) with ESMTPS id BF4185DEFB for <1063@bugs.x2go.org>; Tue, 30 Aug 2016 18:05:51 +0200 (CEST) Received: by mail-qk0-f181.google.com with SMTP id l2so23251243qkf.3 for <1063@bugs.x2go.org>; Tue, 30 Aug 2016 09:05:51 -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=IN29IHfa+CPRS0ykH7J1RAAiAGYMEwHW3JJSVl9vfr8=; b=TAghGUMGM6Ev2PmYcTLkZgACykaBALvn9peiP7spIsEWUdSERA9MgwJ90qJKtQYEcX GKyxqd83GbU4+VPZB+8Uw2+mkGxcJf64ZOXd1kjMzP0YDnGDAC6p5aYN7V9S8L94VGOk 3vVV0AarP4PshyenL9y4f5vUIBTeovulBTWJbX/GI7HJc8EQtacCegPlVLVFJEuOyZC7 2zms7YX/tD7BS+aqNCkMOw+hRaB65KZTApOcyXkP+y12FjKVLRscRaG/jvYIf4Skibdh 62I/XP4k+7du7ph3VX1wTWbs+1+FtCmBHgeo4rlZE6JwC1zaDmOqF2Welb2MG1nAXj75 7XdQ== 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=IN29IHfa+CPRS0ykH7J1RAAiAGYMEwHW3JJSVl9vfr8=; b=L8tCaxmoPkzs5n2o0Bzqhswdn6d45c4KuFXbaqG2zHI6jvhxMtjtLWmc4IT75103km Iz9GysslaCoPs6eMO30Kc50gOhVVA72NMeF3S5fG76UkIkNXN1kft3S6PT28A6woZ9xC LmEeuNlDGgWVgfM0CeEgEH8BR3oK4JdZ0EJZEG12BVNqQBt5r2mZXKX036Ev+vV4U57z fYgQSk2R1uaNtY+T5lezwMNO4AADd9jzXCw8ny2ZZCz1J7mP8PnEuQsAa3WzTiSnLt8s 2bzSAeTTwdAWYqxRGd1hpzpS2YQZOxPmvAP6zQ9QnGdmybzJv0pXynV/BNmftHGg+aOx epUQ== X-Gm-Message-State: AE9vXwNtM50duU2+pebT7aB6tcVJv2GDq8WpvfZIQRN7O98jPWt5ou3wnbLc46RaOwidJB85H+pMbMIYyXbn7Q== X-Received: by 10.55.184.198 with SMTP id i189mr4909990qkf.96.1472573150437; Tue, 30 Aug 2016 09:05:50 -0700 (PDT) MIME-Version: 1.0 Received: by 10.55.175.197 with HTTP; Tue, 30 Aug 2016 09:05:49 -0700 (PDT) In-Reply-To: <6fffe69a-2581-66a2-755f-93b84067e2be@ionic.de> References: <6b41f5b6-82ff-273c-ff64-390c17a44dea@ionic.de> <406759e0-2a96-8582-cc8e-46cd28a2779b@ionic.de> <6fffe69a-2581-66a2-755f-93b84067e2be@ionic.de> From: Sivachidambaram Somu Date: Tue, 30 Aug 2016 21:35:49 +0530 Message-ID: Subject: Re: CreateDB fails with error `DBI connect('dbname=/var/lib/x2go/x2go_sessions', '', ...) failed` To: Mihai Moldovan Cc: 1063@bugs.x2go.org Content-Type: multipart/alternative; boundary=94eb2c07926089b1a2053b4c2704 --94eb2c07926089b1a2053b4c2704 Content-Type: text/plain; charset=UTF-8 I'm afraid the command was working as expected. % sudo chmod g+s $(which id) % id -g 0 % sudo chmod g-s $(which id) % id -g 100 Regards, Siva Chidambaram Somu On Tue, Aug 30, 2016 at 9:03 AM, Mihai Moldovan wrote: > On 29.08.2016 11:33 AM, Sivachidambaram Somu wrote: > > My bad. I have given below the output of the mount command on my machine. > > > > %mount > > > > /dev/xvda1 on / type auto (rw,noatime) > > > > proc on /proc type proc (rw) > > > > sysfs on /sys type sysfs (rw) > > > > devpts on /dev/pts type devpts (rw,gid=5,mode=620) > > > > tmpfs on /dev/shm type tmpfs (rw) > > > > /dev/mapper/ephemeralVG-ephemeral on /local type ext4 (rw) > > > > none on /proc/sys/fs/binfmt_misc type binfmt_misc (rw) > > > > fusectl on /sys/fs/fuse/connections type fusectl (rw) > > Okay, no "nosuid" option in there, so that's also ruled out. > > > As a test, set the setgid bit on the id binary like this: > > sudo chmod g+s $(which id) > > then, as a non-root user(!) run: > > id -g > > Make sure to disable the setgit bit again with: > > sudo chmod g-s $(which id) > > > If the previous id -g call returned an effective group ID of 0, that means > that > setgid functionality should be working on your system. If it's not 0, the > reason > for your problems are likely that setgid on files is not working correctly > on > your system. > > > > Mihai > > --94eb2c07926089b1a2053b4c2704 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
I'm afraid the command was working as expected.

% sudo chmod g+s $(which id) =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=C2=A0

% id -g

0


% sudo chmod g-s $(which id)

% id -g=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0

100


Regards,
Siva Chidambaram Somu

On Tue, Aug 30, 2016 at 9:03 AM, Mihai Moldo= van <ionic@ionic.de> wrote:
<= span class=3D"">On 29.08.2016 11:33 AM, Sivachidambaram Somu wrote:
> My bad. I have given below the output of the mount command on my machi= ne.
>
> %mount
>
> /dev/xvda1 on / type auto (rw,noatime)
>
> proc on /proc type proc (rw)
>
> sysfs on /sys type sysfs (rw)
>
> devpts on /dev/pts type devpts (rw,gid=3D5,mode=3D620)
>
> tmpfs on /dev/shm type tmpfs (rw)
>
> /dev/mapper/ephemeralVG-ephemeral on /local type ext4 (rw)
>
> none on /proc/sys/fs/binfmt_misc type binfmt_misc (rw)
>
> fusectl on /sys/fs/fuse/connections type fusectl (rw)

Okay, no "nosuid" option in there, so that's also rule= d out.


As a test, set the setgid bit on the id binary like this:

sudo chmod g+s $(which id)

then, as a non-root user(!) run:

id -g

Make sure to disable the setgit bit again with:

sudo chmod g-s $(which id)


If the previous id -g call returned an effective group ID of 0, that means = that
setgid functionality should be working on your system. If it's not 0, t= he reason
for your problems are likely that setgid on files is not working correctly = on
your system.



Mihai


--94eb2c07926089b1a2053b4c2704-- From ionic@ionic.de Fri Sep 2 10:55:43 2016 Received: (at 1063) by bugs.x2go.org; 2 Sep 2016 08:55:45 +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.6 required=3.0 tests=BAYES_05,DKIM_SIGNED, DKIM_VALID,DKIM_VALID_AU,SPF_HELO_PASS,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 83A165DEFC for <1063@bugs.x2go.org>; Fri, 2 Sep 2016 10:55:43 +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 QU1HVQEBoLbr for <1063@bugs.x2go.org>; Fri, 2 Sep 2016 10:55:37 +0200 (CEST) Received: from Root24.de (powered.by.root24.eu [5.135.3.88]) by ymir.das-netzwerkteam.de (Postfix) with ESMTP id D20825DA97 for <1063@bugs.x2go.org>; Fri, 2 Sep 2016 10:55:36 +0200 (CEST) Received: from nopileos.local (178.162.222.41.adsl.inet-telecom.org [178.162.222.41]) by mail.ionic.de (Postfix) with ESMTPSA id AFF724F0004F; Fri, 2 Sep 2016 10:55:35 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=ionic.de; s=default; t=1472806536; bh=P14vKjPWD9uAx58uEKEkA60fkvcNfe3qGNz7IIQMBxI=; h=Subject:To:References:Cc:From:Date:In-Reply-To:From; b=iGBPzz7hip9sZe44z776Ec4GztASz8T3Rovn39Ru1SthCon/7yhPTvhh0cMv585f+ RDWfhtKzauqCVvMPRn9cSmPUdVyAabcOdYdqrHNchK6xbVmjCYKxNmYri1ryFu/kbe 1HxJAaETWpNClLy+9pHFL5ZuDZDuDN588hOdEPcE= Subject: Re: CreateDB fails with error `DBI connect('dbname=/var/lib/x2go/x2go_sessions', '', ...) failed` To: Sivachidambaram Somu References: <6b41f5b6-82ff-273c-ff64-390c17a44dea@ionic.de> <406759e0-2a96-8582-cc8e-46cd28a2779b@ionic.de> <6fffe69a-2581-66a2-755f-93b84067e2be@ionic.de> Cc: 1063@bugs.x2go.org From: Mihai Moldovan Message-ID: Date: Fri, 2 Sep 2016 10:55:27 +0200 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:45.0) Gecko/20100101 Thunderbird/45.2.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="hatWLnw1LFTDTT4KGEtmDB48vnxKbOHea" This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --hatWLnw1LFTDTT4KGEtmDB48vnxKbOHea Content-Type: multipart/mixed; boundary="AUwCjSc1mJHh4Im6hOm4UMs61fjhrHGEx" From: Mihai Moldovan To: Sivachidambaram Somu Cc: 1063@bugs.x2go.org Message-ID: Subject: Re: CreateDB fails with error `DBI connect('dbname=/var/lib/x2go/x2go_sessions', '', ...) failed` References: <6b41f5b6-82ff-273c-ff64-390c17a44dea@ionic.de> <406759e0-2a96-8582-cc8e-46cd28a2779b@ionic.de> <6fffe69a-2581-66a2-755f-93b84067e2be@ionic.de> In-Reply-To: --AUwCjSc1mJHh4Im6hOm4UMs61fjhrHGEx Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable On 30.08.2016 06:05 PM, Sivachidambaram Somu wrote: > I'm afraid the command was working as expected. >=20 > %sudo chmod g+s $(which id) =20 >=20 > %id -g >=20 > 0 >=20 >=20 > %sudo chmod g-s $(which id) >=20 > %id -g =20 >=20 > 100 That doesn't make sense... the x2go_sessions file has the correct permiss= ions set and the x2gosqlitewrapper binary is setgid with the correct group ass= igned - x2gouser. It doesn't look like your system is in any way special regardin= g this. If you (re)create the DB via sudo x2godbadmin --createdb and then start a new session via X2Go Client and then try to reconnect to= that, what error message comes up in X2Go Client? Mihai --AUwCjSc1mJHh4Im6hOm4UMs61fjhrHGEx-- --hatWLnw1LFTDTT4KGEtmDB48vnxKbOHea Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQIcBAEBCgAGBQJXyT6FAAoJEB/WLtluJTqHpyQP/2x85U2a9b2xZv0Nf+Kbl1zp xLYCsKAgtkU8He3CFuRFCu3sqZjs8EjmYkocMOOjq2DraXnJkiyNSUNc/pv9NTFx +mrwzizfQo8rrS0Z/hE6MPaipt+2CkkHH9/xJ51Xpn5w+inOq9nG0BQVi6/Tc2Gw VNMd2pCcmyYhaWa1qgYsaInE2tXj9CkwU2DjegBRhyZRF0wh7GtKs/RsnPQe7gpJ mJbjBIx6dzpaFbRBIHRENj8qdk13+XLcIb5i5rTkG6teMbJ4GipKEwBLveML9etk 4390YE8tBRaI8Cx5G2gJReO1P9j4pd6tt2Q5ApdxSL6jmgu6kiUf+cD969F5TKD+ t0Ogpw3mdFsjtnJlMxPkCKOzfsVCVLcjCHiSbFqDTWrZpxp11VdSfKloaDjHHd5/ ESDiROHQH4h0Q7QXnf8YFsnmtBTiooQqLPPPoY0/bWDpWeOzJby5So2y0BTYzdhl jvtix0m9VV70R2L9Fvr3SvrHYUGmjzS7ValJvxY+rOvN5VQE1LNZjGpsDFeA+H9f p+wImDqgZPWr3qUxWAv4VCSAfTuKfrf+I6dWEFyfYymOfRpE1QxDlPqM4wpMH64S ekQv8tdNLZlYH6CWpCY/D9EoDNdQlCH0B2ocw4NbGubroJlBYUUUpZoJUpxfdmlY xB4dKBvZA9+5J4diTiTj =DfDo -----END PGP SIGNATURE----- --hatWLnw1LFTDTT4KGEtmDB48vnxKbOHea-- From ionic@ionic.de Tue Oct 4 13:36:41 2016 Received: (at 1063) by bugs.x2go.org; 4 Oct 2016 11:36:43 +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.1 required=3.0 tests=BAYES_40,DKIM_SIGNED, DKIM_VALID,DKIM_VALID_AU,SPF_HELO_PASS,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 C07FC5DA9F for <1063@bugs.x2go.org>; Tue, 4 Oct 2016 13:36:40 +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 XoIRw2Er2Ieo for <1063@bugs.x2go.org>; Tue, 4 Oct 2016 13:36:33 +0200 (CEST) Received: from Root24.de (powered.by.root24.eu [5.135.3.88]) by ymir.das-netzwerkteam.de (Postfix) with ESMTP id E233E5DA98 for <1063@bugs.x2go.org>; Tue, 4 Oct 2016 13:36:32 +0200 (CEST) Received: from nopileos.local (178.162.222.41.adsl.inet-telecom.org [178.162.222.41]) by mail.ionic.de (Postfix) with ESMTPSA id 17AAB4F00651; Tue, 4 Oct 2016 13:36:31 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=ionic.de; s=default; t=1475580992; bh=1ueVMYofDQNbI70SPgCnf7SCEQ4rxFQ640X5KphDZME=; h=Subject:To:References:Cc:From:Date:In-Reply-To:From; b=gpVxRi501rtqh0N1yoPEYyGYojLy00dXyh/6vLpP/JRSaKjsrOqEAAdeYEaojACCE ZaNglWOvntsxFe6upQDxAWvCq94hVcb/XTAOZQGA99iXqECpW7aShYX1RHewH69HyF nRRBogyAS6dKiQeaQ4iQZ0xxCNYMyycL6wBpuG+8= Subject: Re: CreateDB fails with error `DBI connect('dbname=/var/lib/x2go/x2go_sessions', '', ...) failed` To: Sivachidambaram Somu References: <6b41f5b6-82ff-273c-ff64-390c17a44dea@ionic.de> <406759e0-2a96-8582-cc8e-46cd28a2779b@ionic.de> <6fffe69a-2581-66a2-755f-93b84067e2be@ionic.de> Cc: 1063@bugs.x2go.org From: Mihai Moldovan Message-ID: Date: Tue, 4 Oct 2016 13:36:29 +0200 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:45.0) Gecko/20100101 Thunderbird/45.3.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="tRTbGUkbGn3nWH3KrTkkGNwSSqUEved0r" This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --tRTbGUkbGn3nWH3KrTkkGNwSSqUEved0r Content-Type: multipart/mixed; boundary="Qgv4hIPjelWunlikMA81JtPNBBFcOLxv8"; protected-headers="v1" From: Mihai Moldovan To: Sivachidambaram Somu Cc: 1063@bugs.x2go.org Message-ID: Subject: Re: CreateDB fails with error `DBI connect('dbname=/var/lib/x2go/x2go_sessions', '', ...) failed` References: <6b41f5b6-82ff-273c-ff64-390c17a44dea@ionic.de> <406759e0-2a96-8582-cc8e-46cd28a2779b@ionic.de> <6fffe69a-2581-66a2-755f-93b84067e2be@ionic.de> In-Reply-To: --Qgv4hIPjelWunlikMA81JtPNBBFcOLxv8 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable On 11.09.2016 05:09 AM, Sivachidambaram Somu wrote: > Sometimes I get the below error while trying to recreate DB. If I try t= o create > the user myself, I end up back in square one with the error I posted in= my first > email. >=20 > %sudo x2godbadmin --createdb=20 >=20 > Can not find user (x2gouser) I really don't understand how you can get this error. This means that the= perl installation, that uses standard PAM libraries, was not able to get infor= mation for the 'x2gouser' user account on your system. Maybe files in /etc (like= passwd or shadow) or an active- or LDAP directory are not available all the time= on your system. From what I can tell, this looks like a connection issue bet= ween vital systems on your end. The X2Go scripts are not doing something sophisticated but simply calling the standard getpwnam() function in perl= , which SHOULD map more or less directly to the getpwnam() function in the C libr= ary. If that is returning invalid information, you're in for trouble... You could try applying http://tinyurl.com/hy4mb4x but I doubt that'll hel= p you a lot. :/ Mihai --Qgv4hIPjelWunlikMA81JtPNBBFcOLxv8-- --tRTbGUkbGn3nWH3KrTkkGNwSSqUEved0r Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQIcBAEBCgAGBQJX85Q+AAoJEB/WLtluJTqH8YkP/3XqwXtJ/pVXQ6Ox55kWsdTA y/kfQ4/CmxU84y/Zr7ENlwlcQJ8su/O7nopQf2xD50V45ZWgJ24wG/ALJnBwIxVI B1+E0ZlJ90JFwO6yQzQuW/tXUOyeja8hhI0BWBKy50fsE78gIkIHOnLC+szyatHj JsC7GiyloXeKTVcMNChjfuI0lCttGA8jOkDL6stSXqPHKnNpt98VfR7FvGaSbn76 DA7zr4w6bGMG2xlAvQY8qMf/6wlARvjT51fIBM6uBPw2Xxy4hH88njLq1bGGdcRP YV50hJjFpFvkmGINMWFd4NNbPN9gsIhbi5T9yBcJ03PTY3MFNuzOau2a0hy4wSIE 5ZMsmWDNqK/Zog5HbsXqwTRECPawna0QHuoEagDjfuwEYSuWbrGLntjjQb3vW01A GftHS2e/6es7Qp/NgSSUyopwrf9s7wGFLQUlnsy1NH91omLPKe3IVyaU71UpHy7F Kc6eJK4C/XhjxcCq2g3j8BdGpExACZTLDSqHrwsZoh9B6dJxOVUOvZshZP9lrFDD 4mixAVPP0LX8uUmohqvLjqKEp1u1MvQGFwlCGpRGDVipSZhRhbV4C7gztmjor/JZ o0sFff3H0O6olO0Fdc8+gRyJJSHv1DGI7rbqETpmT//Kc+LF/+ZNOhVzWvBdqea5 D1qYq9TEyumHGP4FStHM =2R6E -----END PGP SIGNATURE----- --tRTbGUkbGn3nWH3KrTkkGNwSSqUEved0r--