From unknown Thu Apr 09 03:17:40 2026 X-Loop: owner@bugs.x2go.org Subject: Bug#1063: CreateDB fails with error `DBI connect('dbname=/var/lib/x2go/x2go_sessions', '', ...) failed` Reply-To: Mihai Moldovan , 1063@bugs.x2go.org Resent-From: Mihai Moldovan Resent-To: x2go-dev@lists.x2go.org Resent-CC: X2Go Developers X-Loop: owner@bugs.x2go.org Resent-Date: Sun, 14 Aug 2016 02:15:01 +0000 Resent-Message-ID: Resent-Sender: owner@bugs.x2go.org X-X2Go-PR-Message: followup 1063 X-X2Go-PR-Package: x2goserver X-X2Go-PR-Keywords: moreinfo Received: via spool by 1063-submit@bugs.x2go.org id=B1063.147114065011353 (code B ref 1063); Sun, 14 Aug 2016 02:15:01 +0000 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= 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--