Dear x2go Users,
I have tried to install x2go (EPEL 6 version) to a CentOS 6.5 machine. The installation worked (I've had to add fuse and fuse-sshfs and a few perl modules, including perl-SQLite-DBD). However when I try to connect a client, or to run x2golistsessions on the server, I get the following error:
Connection failed DBD::SQLite::db prepare failed: no such table: sessions at /usr/lib64/x2go/x2gosqlitewrapper.pl line 467. Can't call method "execute" on an undefined value at /usr/lib64/x2go/x2gosqlitewrapper.pl line 475.
Could you please suggest how this problem is to be fixed? Thank you very much in advance!
-- Grigory Shamov
HPC Analyst, Tech. Site Lead, Westgrid/Compute Canada E2-588 EITC Building, University of Manitoba (204) 474-9625
On Tue, Aug 26, 2014 at 1:21 PM, Grigory Shamov <Grigory.Shamov@umanitoba.ca> wrote:
Dear x2go Users,
I have tried to install x2go (EPEL 6 version) to a CentOS 6.5 machine. The installation worked (I've had to add fuse and fuse-sshfs and a few perl modules, including perl-SQLite-DBD). However when I try to connect a client, or to run x2golistsessions on the server, I get the following error:
Connection failed DBD::SQLite::db prepare failed: no such table: sessions at /usr/lib64/x2go/x2gosqlitewrapper.pl line 467. Can't call method "execute" on an undefined value at /usr/lib64/x2go/x2gosqlitewrapper.pl line 475.
Could you please suggest how this problem is to be fixed? Thank you very much in advance!
Did you use yum to install x2goserver or just grab an isolated rpm from the repository? Yum should have taken care of all the dependencies for you.
-- Les Mikesell lesmikesell@gmail.com
Dear Les,
I've used EPEL 6 version of the X2go repo, by adding the repo as described, (http://wiki.x2go.org/doku.php/wiki:repositories:epel) and installed the dependencies rpms that were missing manually from EPEL 6 x86_64 ( python-gevent-0.13.8-3.el6.x86_64.rpm python-greenlet-0.4.2-1.el6.x86_64.rpm perl-File-Read-0.0801-2.el6.noarch.rpm perl-File-ReadBackwards-1.04-7.el6.noarch.rpm).
Is there more generic EPEL dependencies that I miss?
-- Grigory Shamov
HPC Analyst, Tech. Site Lead, Westgrid/Compute Canada E2-588 EITC Building, University of Manitoba (204) 474-9625
On 14-08-26 2:37 PM, "Les Mikesell" <lesmikesell@gmail.com> wrote:
On Tue, Aug 26, 2014 at 1:21 PM, Grigory Shamov <Grigory.Shamov@umanitoba.ca> wrote:
Dear x2go Users,
I have tried to install x2go (EPEL 6 version) to a CentOS 6.5 machine. The installation worked (I've had to add fuse and fuse-sshfs and a few perl modules, including perl-SQLite-DBD). However when I try to connect a client, or to run x2golistsessions on the server, I get the following error:
Connection failed DBD::SQLite::db prepare failed: no such table: sessions at /usr/lib64/x2go/x2gosqlitewrapper.pl line 467. Can't call method "execute" on an undefined value at /usr/lib64/x2go/x2gosqlitewrapper.pl line 475.
Could you please suggest how this problem is to be fixed? Thank you very much in advance!
Did you use yum to install x2goserver or just grab an isolated rpm from the repository? Yum should have taken care of all the dependencies for you.
-- Les Mikesell lesmikesell@gmail.com
On Tue, Aug 26, 2014 at 2:54 PM, Grigory Shamov <Grigory.Shamov@umanitoba.ca> wrote:
Dear Les,
I've used EPEL 6 version of the X2go repo, by adding the repo as described, (http://wiki.x2go.org/doku.php/wiki:repositories:epel) and installed the dependencies rpms that were missing manually from EPEL 6 x86_64 ( python-gevent-0.13.8-3.el6.x86_64.rpm python-greenlet-0.4.2-1.el6.x86_64.rpm perl-File-Read-0.0801-2.el6.noarch.rpm perl-File-ReadBackwards-1.04-7.el6.noarch.rpm).
Is there more generic EPEL dependencies that I miss?
I don't understand the "manually" part. If the EPEL repository is enabled, yum should have installed all the dependencies together for you. And a working x2goserver is included in EPEL. I don't think you need the x2go repo unless you want a version newer than 4.0.1.15. What version did you install?
-- Les
Dear Les,
Thank you for your always helpful answers.
"Manual" means wget + rpm -i. Only x2go "EPEL" repo was enabled. There are two x2go repos, one "EPEL" and one "SUSE Open Factory" (you may want to visit the link I provided). So I call it "EPEL" to distinguish from the "SUSE Open Factory".
There is also EPEL EPEL, a RedHat/Fedora project which has nothing to do with x2go besides providing the dependencies for "EPEL" build of it. I did not enable the EPEL repo. If dependencies in x2go rpms that are in "EPEL" build are correct, they should tell me, what rpms do I miss. Then I install missing ones manually. As described above.
I have 4.0.1.15 that is in the "EPEL" x2go repo.
-- Grigory Shamov
HPC Analyst, Tech. Site Lead, Westgrid/Compute Canada E2-588 EITC Building, University of Manitoba (204) 474-9625
On 14-08-26 3:05 PM, "Les Mikesell" <lesmikesell@gmail.com> wrote:
On Tue, Aug 26, 2014 at 2:54 PM, Grigory Shamov <Grigory.Shamov@umanitoba.ca> wrote:
Dear Les,
I've used EPEL 6 version of the X2go repo, by adding the repo as described, (http://wiki.x2go.org/doku.php/wiki:repositories:epel) and installed the dependencies rpms that were missing manually from EPEL 6 x86_64 ( python-gevent-0.13.8-3.el6.x86_64.rpm python-greenlet-0.4.2-1.el6.x86_64.rpm perl-File-Read-0.0801-2.el6.noarch.rpm perl-File-ReadBackwards-1.04-7.el6.noarch.rpm).
Is there more generic EPEL dependencies that I miss?
I don't understand the "manually" part. If the EPEL repository is enabled, yum should have installed all the dependencies together for you. And a working x2goserver is included in EPEL. I don't think you need the x2go repo unless you want a version newer than 4.0.1.15. What version did you install?
-- Les
On 08/26/2014 03:05 PM, Grigory Shamov wrote:
Dear Les,
Thank you for your always helpful answers.
"Manual" means wget + rpm -i. Only x2go "EPEL" repo was enabled. There are two x2go repos, one "EPEL" and one "SUSE Open Factory" (you may want to visit the link I provided). So I call it "EPEL" to distinguish from the "SUSE Open Factory".
There is also EPEL EPEL, a RedHat/Fedora project which has nothing to do with x2go besides providing the dependencies for "EPEL" build of it. I did not enable the EPEL repo. If dependencies in x2go rpms that are in "EPEL" build are correct, they should tell me, what rpms do I miss. Then I install missing ones manually. As described above.
I have 4.0.1.15 that is in the "EPEL" x2go repo.
Yeah, this is what I was afraid would happen with the use of EPEL everywhere on the X2Go site.
Basically, follow the "using EPEL" link and just install from there. I've tried to tweak the wiki to make this clearer.
-- Orion Poplawski Technical Manager 303-415-9701 x222 NWRA, Boulder/CoRA Office FAX: 303-415-9702 3380 Mitchell Lane orion@nwra.com Boulder, CO 80301 http://www.nwra.com
Dear Orion,
Aha! Now I see that there is also real EPEL build by you! No wonder I confused people with my explanation. Sorry about that. :-)
Should I drop the "EPEL" build and just use EPEL one, as the version seem to be roughly the same?
-- Grigory Shamov
HPC Analyst, Tech. Site Lead, Westgrid/Compute Canada E2-588 EITC Building, University of Manitoba (204) 474-9625
On 14-08-26 4:47 PM, "Orion Poplawski" <orion@cora.nwra.com> wrote:
On 08/26/2014 03:05 PM, Grigory Shamov wrote:
Dear Les,
Thank you for your always helpful answers.
"Manual" means wget + rpm -i. Only x2go "EPEL" repo was enabled. There are two x2go repos, one "EPEL" and one "SUSE Open Factory" (you may want to visit the link I provided). So I call it "EPEL" to distinguish from the "SUSE Open Factory".
There is also EPEL EPEL, a RedHat/Fedora project which has nothing to do with x2go besides providing the dependencies for "EPEL" build of it. I did not enable the EPEL repo. If dependencies in x2go rpms that are in "EPEL" build are correct, they should tell me, what rpms do I miss. Then I install missing ones manually. As described above.
I have 4.0.1.15 that is in the "EPEL" x2go repo.
Yeah, this is what I was afraid would happen with the use of EPEL everywhere on the X2Go site.
Basically, follow the "using EPEL" link and just install from there. I've tried to tweak the wiki to make this clearer.
-- Orion Poplawski Technical Manager 303-415-9701 x222 NWRA, Boulder/CoRA Office FAX: 303-415-9702 3380 Mitchell Lane orion@nwra.com Boulder, CO 80301 http://www.nwra.com
On 08/26/2014 04:08 PM, Grigory Shamov wrote:
Dear Orion,
Aha! Now I see that there is also real EPEL build by you! No wonder I confused people with my explanation. Sorry about that. :-)
Should I drop the "EPEL" build and just use EPEL one, as the version seem to be roughly the same?
Something seems to have gone awry in the package installation. I'm checking in a fix for what might have happened.
Yeah, at this point I would remove the x2goserver package and the X2Go repo, install the Fedora EPEL repo, and install x2goserver from there.
-- Orion Poplawski Technical Manager 303-415-9701 x222 NWRA, Boulder/CoRA Office FAX: 303-415-9702 3380 Mitchell Lane orion@nwra.com Boulder, CO 80301 http://www.nwra.com
Hi Orion
On Mi 27 Aug 2014 00:12:53 CEST, Orion Poplawski wrote:
On 08/26/2014 04:08 PM, Grigory Shamov wrote:
Dear Orion,
Aha! Now I see that there is also real EPEL build by you! No wonder I confused people with my explanation. Sorry about that. :-)
Should I drop the "EPEL" build and just use EPEL one, as the version seem to be roughly the same?
Something seems to have gone awry in the package installation. I'm
checking in a fix for what might have happened.
on post-install, the package system has to run x2godbadmin --createdb...\
But only if /etc/x2go/x2gosql/sql is configured to use the SQLite
backend. The PostgreSQL setup has to be done by the sysadmin manually
(not by the package system).
So for new installations, there should be an x2godbadmin --createdb
happening, because the default DB backend is SQLite. For package
upgrades (once the admin has switched over to PostegreSQL), the
post-upgrade scripts (if any) should stay away from the DB (note that
x2godbadmin has an option --updatedb, which should be called on every
package upgrade).
Mike
--
DAS-NETZWERKTEAM mike gabriel, herweg 7, 24357 fleckeby fon: +49 (1520) 1976 148
GnuPG Key ID 0x25771B31 mail: mike.gabriel@das-netzwerkteam.de, http://das-netzwerkteam.de
freeBusy: https://mail.das-netzwerkteam.de/freebusy/m.gabriel%40das-netzwerkteam.de.xf...
Dear Orion,
The EPEL 6 binaries worked out of the box. (I forgot to remove the x2go user that I created manually ; but I did delete all the X2Go rpms and the yum repo config). I did, using EPEL repo,
yum install x2goserver x2goserver-xsession python-x2go python-x2go-doc
After that, "x2godbadmin --createdb" and "x2golistsessions" resulted in no more SQL errors. It allowed me to connect and x2golistsessions then gives a correct output (that is, shows one session).
All is great! Thanks!
Now how does one manage users? Is it possible to use LDAP with this version (4.0.1.15)?
Also, EPEL repo has fewer components apparently (no x2gognomebindings, no x2gextensions) -- do I miss them? A desktop does start and looks like GNOME (for it is my default and only installed DE on this machine). Is there a way to give users a default panel, set of bookmarks etc.?
-- Grigory Shamov
HPC Analyst, Tech. Site Lead, Westgrid/Compute Canada E2-588 EITC Building, University of Manitoba (204) 474-9625
On 14-08-26 5:12 PM, "Orion Poplawski" <orion@cora.nwra.com> wrote:
On 08/26/2014 04:08 PM, Grigory Shamov wrote:
Dear Orion,
Aha! Now I see that there is also real EPEL build by you! No wonder I confused people with my explanation. Sorry about that. :-)
Should I drop the "EPEL" build and just use EPEL one, as the version seem to be roughly the same?
Something seems to have gone awry in the package installation. I'm checking in a fix for what might have happened.
Yeah, at this point I would remove the x2goserver package and the X2Go repo, install the Fedora EPEL repo, and install x2goserver from there.
-- Orion Poplawski Technical Manager 303-415-9701 x222 NWRA, Boulder/CoRA Office FAX: 303-415-9702 3380 Mitchell Lane orion@nwra.com Boulder, CO 80301 http://www.nwra.com
On Wed, Aug 27, 2014 at 11:46 AM, Grigory Shamov <Grigory.Shamov@umanitoba.ca> wrote:
Now how does one manage users? Is it possible to use LDAP with this version (4.0.1.15)?
What do you need to manage? I've always had ssh already set to allow users to connect and x2go just worked on top of that.
Also, EPEL repo has fewer components apparently (no x2gognomebindings, no x2gextensions) -- do I miss them? A desktop does start and looks like GNOME (for it is my default and only installed DE on this machine). Is there a way to give users a default panel, set of bookmarks etc.?
The default should be the same as if they logged in with that id at the console (if you have one) with the selected desktop (gnome/kde/mate, etc.).
-- Les Mikesell lesmikesell@gmail.com