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

Full log

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

Received: (at submit) by bugs.x2go.org; 26 Jul 2016 06:03:29 +0000
From arun.lisieux@gmail.com  Tue Jul 26 08:03:26 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 20C8A5DDF5
	for <submit@bugs.x2go.org>; 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 <submit@bugs.x2go.org>;
	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 <submit@bugs.x2go.org>; Tue, 26 Jul 2016 08:03:16 +0200 (CEST)
Received: by mail-qt0-f182.google.com with SMTP id 52so111656269qtq.3
        for <submit@bugs.x2go.org>; 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 <arun.lisieux@gmail.com>
Date: Tue, 26 Jul 2016 11:33:14 +0530
Message-ID: <CAC5R9dkj8BfkaHTAhLy0U4nzMRJRtkLw5Ss1be_YM4Y64ZG8Lw@mail.gmail.com>
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

[Message part 1 (text/plain, inline)]

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.

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

Send a report that this bug log contains spam.