Subject: Re: CreateDB fails with error `DBI connect('dbname=/var/lib/x2go/x2go_sessions', '', ...) failed`

From: Mihai Moldovan <[email-masked]>
Date: Sat, 13 Aug 2016 23:11:14 +0200

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