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: <CAC5R9dkj8BfkaHTAhLy0U4nzMRJRtkLw5Ss1be_YM4Y64ZG8Lw@mail.gmail.com>
 <bf97b5ef-9b19-2b68-c5dd-352dcb43dbac@ionic.de> <CAC5R9dnZzc+1enWSTBb6-fuXYSSK6ZAwRLS+miipKUduj01krw@mail.gmail.com>
 <edc5bbf9-38b5-7e67-054c-0f0b526062dc@ionic.de> <CAC5R9dndn6xiS2fCQpovBLZn6yUkUw2F33XEkpZhqXrFbME9Sw@mail.gmail.com>
 <6b41f5b6-82ff-273c-ff64-390c17a44dea@ionic.de> <CAC5R9dn44Hz5nBn11rqEqR2u9eBBM2FRTkbtx1Oh3v=CU99rbw@mail.gmail.com>
 <406759e0-2a96-8582-cc8e-46cd28a2779b@ionic.de> <CAC5R9dm5vJcBwp6-OMzk7Q_O1twu9B7nTP8Ca06irXVed0_mvA@mail.gmail.com>
 <6fffe69a-2581-66a2-755f-93b84067e2be@ionic.de>
From: Sivachidambaram Somu <arun.lisieux@gmail.com>
Date: Tue, 30 Aug 2016 21:35:49 +0530
Message-ID: <CAC5R9dkaF0kHvvR0M69PNnJwoTrsRU63p3hvvDHoM3XiZOAZ0g@mail.gmail.com>
Subject: Re: CreateDB fails with error `DBI connect('dbname=/var/lib/x2go/x2go_sessions',
 '', ...) failed`
To: Mihai Moldovan <ionic@ionic.de>
Cc: 1063@bugs.x2go.org
Content-Type: multipart/alternative; boundary=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 <ionic@ionic.de> 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

<div dir=3D"ltr">I&#39;m afraid the command was working as expected.<div><b=
r></div><div>







<p class=3D"gmail-p1"><span class=3D"gmail-s1">%</span><span class=3D"gmail=
-s2"> sudo chmod g+s $(which id) =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=C2=A0</=
span></p>
<p class=3D"gmail-p4"><span class=3D"gmail-s2">%</span><span class=3D"gmail=
-s3"> id -g</span></p>
<p class=3D"gmail-p1"><span class=3D"gmail-s2">0</span></p><p class=3D"gmai=
l-p1"><span class=3D"gmail-s2"><br></span></p>
<p class=3D"gmail-p4"><span class=3D"gmail-s2">%</span><span class=3D"gmail=
-s3"> sudo chmod g-s $(which id)</span></p>
<p class=3D"gmail-p4"><span class=3D"gmail-s2">%</span><span class=3D"gmail=
-s3"> id -g=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0</span></p>
<p class=3D"gmail-p1"><span class=3D"gmail-s2">100</span></p></div></div><d=
iv class=3D"gmail_extra"><br clear=3D"all"><div><div class=3D"gmail_signatu=
re" data-smartmail=3D"gmail_signature">Regards,<br>Siva Chidambaram Somu</d=
iv></div>
<br><div class=3D"gmail_quote">On Tue, Aug 30, 2016 at 9:03 AM, Mihai Moldo=
van <span dir=3D"ltr">&lt;<a href=3D"mailto:ionic@ionic.de" target=3D"_blan=
k">ionic@ionic.de</a>&gt;</span> wrote:<br><blockquote class=3D"gmail_quote=
" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><=
span class=3D"">On 29.08.2016 11:33 AM, Sivachidambaram Somu wrote:<br>
&gt; My bad. I have given below the output of the mount command on my machi=
ne.<br>
&gt;<br>
&gt; %mount<br>
&gt;<br>
&gt; /dev/xvda1 on / type auto (rw,noatime)<br>
&gt;<br>
&gt; proc on /proc type proc (rw)<br>
&gt;<br>
&gt; sysfs on /sys type sysfs (rw)<br>
&gt;<br>
&gt; devpts on /dev/pts type devpts (rw,gid=3D5,mode=3D620)<br>
&gt;<br>
&gt; tmpfs on /dev/shm type tmpfs (rw)<br>
&gt;<br>
&gt; /dev/mapper/ephemeralVG-<wbr>ephemeral on /local type ext4 (rw)<br>
&gt;<br>
&gt; none on /proc/sys/fs/binfmt_misc type binfmt_misc (rw)<br>
&gt;<br>
&gt; fusectl on /sys/fs/fuse/connections type fusectl (rw)<br>
<br>
</span>Okay, no &quot;nosuid&quot; option in there, so that&#39;s also rule=
d out.<br>
<br>
<br>
As a test, set the setgid bit on the id binary like this:<br>
<br>
sudo chmod g+s $(which id)<br>
<br>
then, as a non-root user(!) run:<br>
<br>
id -g<br>
<br>
Make sure to disable the setgit bit again with:<br>
<br>
sudo chmod g-s $(which id)<br>
<br>
<br>
If the previous id -g call returned an effective group ID of 0, that means =
that<br>
setgid functionality should be working on your system. If it&#39;s not 0, t=
he reason<br>
for your problems are likely that setgid on files is not working correctly =
on<br>
your system.<br>
<span class=3D"HOEnZb"><font color=3D"#888888"><br>
<br>
<br>
Mihai<br>
<br>
</font></span></blockquote></div><br></div>

--94eb2c07926089b1a2053b4c2704--

