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

version graph

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

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

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

Severity: normal

Tags: moreinfo

Found in version 4.0.1.19-3.el6

Full log

Message #37 received at 1063@bugs.x2go.org (full text, mbox, reply):

Received: (at 1063) by bugs.x2go.org; 27 Aug 2016 10:38:25 +0000
From arun.lisieux@gmail.com  Sat Aug 27 12:38:23 2016
X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on
	ymir.das-netzwerkteam.de
X-Spam-Level: 
X-Spam-Status: No, score=0.7 required=3.0 tests=BAYES_50,DKIM_SIGNED,
	DKIM_VALID,DKIM_VALID_AU,FREEMAIL_FROM,HTML_MESSAGE,URIBL_BLOCKED
	autolearn=ham version=3.3.2
Received: from localhost (localhost [127.0.0.1])
	by ymir.das-netzwerkteam.de (Postfix) with ESMTP id 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: <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>
From: Sivachidambaram Somu <arun.lisieux@gmail.com>
Date: Sat, 27 Aug 2016 16:08:13 +0530
Message-ID: <CAC5R9dn44Hz5nBn11rqEqR2u9eBBM2FRTkbtx1Oh3v=CU99rbw@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=001a114060be707152053b0b3a7c

[Message part 1 (text/plain, inline)]
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" <ionic@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.
>
>
> > 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
>
>

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

Send a report that this bug log contains spam.

X2Go Developers <owner@bugs.x2go.org>. Last modified: Tue Nov 4 21:30:22 2025; Machine Name: ymir.das-netzwerkteam.de

X2Go Bug tracking system

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

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