X2Go Bug report logs - #1135
MySQL Database backend support

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

Reported by: Walid MOGHRABI <w.moghrabi@servicemagic.eu>

Date: Fri, 13 Jan 2017 17:00:02 UTC

Severity: wishlist

Tags: patch

Full log

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

Received: (at 1135) by bugs.x2go.org; 20 Oct 2017 17:16:37 +0000
From w.moghrabi@servicemagic.eu  Fri Oct 20 19:16:26 2017
X-Spam-Checker-Version: SpamAssassin 3.4.1 (2015-04-28) on
	ymir.das-netzwerkteam.de
X-Spam-Level: 
X-Spam-Status: No, score=-2.0 required=3.0 tests=BAYES_00,DKIM_SIGNED,
	DKIM_VALID,DKIM_VALID_AU,URIBL_BLOCKED autolearn=ham autolearn_force=no
	version=3.4.1
Received: from localhost (localhost [127.0.0.1])
	by ymir.das-netzwerkteam.de (Postfix) with ESMTP id 553105DACB
	for <1135@bugs.x2go.org>; Fri, 20 Oct 2017 19:16: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 vAa7ElDC30yN for <1135@bugs.x2go.org>;
	Fri, 20 Oct 2017 19:16:20 +0200 (CEST)
Received: from zm-01.servicemagic.eu (zm-01.servicemagic.eu [176.31.236.17])
	by ymir.das-netzwerkteam.de (Postfix) with ESMTPS id 73F945DAC9
	for <1135@bugs.x2go.org>; Fri, 20 Oct 2017 19:16:19 +0200 (CEST)
Received: from localhost (localhost.localdomain [127.0.0.1])
	by zm-01.servicemagic.eu (Postfix) with ESMTP id 1E309814E14B0
	for <1135@bugs.x2go.org>; Fri, 20 Oct 2017 19:16:19 +0200 (CEST)
DKIM-Filter: OpenDKIM Filter v2.11.0 zm-01.servicemagic.eu 1E309814E14B0
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=servicemagic.eu;
	s=frmailing; t=1508519779;
	bh=TQ2nFd+k7fctG7kOID48SAvxb1b/KILaf75MbomFNRo=;
	h=Date:From:To:In-Reply-To:Subject:From;
	b=QOTLfG7/VJKZaMSeDzkN+DqDwI1kBJZQwcugHruTIJxRPXx4OeujKO82OeVcb+Wm2
	 AMy7e/+MZZ3UiicAC/faMNhGgN9hAAyiWsQ1apLDbosidrbSuMQUtHhSM3qO70DVtM
	 Jx/riijHv/E0ZIBnN/hFKNk4xXF70uvq/GeQlCNc=
X-Amavis-Modified: Mail body modified (using disclaimer) -
	zm-01.servicemagic.eu
X-Virus-Scanned: amavisd-new at servicemagic.eu
Received: from zm-01.servicemagic.eu ([127.0.0.1])
	by localhost (zm-01.servicemagic.eu [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id Z1vHRFy+r1UO for <1135@bugs.x2go.org>;
	Fri, 20 Oct 2017 19:16:15 +0200 (CEST)
Received: from zm-01.servicemagic.eu (localhost.localdomain [127.0.0.1])
	by zm-01.servicemagic.eu (Postfix) with ESMTP id 3F78F80AC259C
	for <1135@bugs.x2go.org>; Fri, 20 Oct 2017 19:16:15 +0200 (CEST)
Date: Fri, 20 Oct 2017 19:16:15 +0200 (CEST)
From: Walid MOGHRABI <w.moghrabi@servicemagic.eu>
To: 1135@bugs.x2go.org
Message-ID: <1992364384.23212336.1508519775122.JavaMail.root@servicemagic.eu>
In-Reply-To: <879128570.23211901.1508519534421.JavaMail.root@servicemagic.eu>
Subject: MySQL session backend (fixed version)
MIME-Version: 1.0
Content-Type: multipart/mixed; 
	boundary="----=_Part_23212334_788228192.1508519775114"
X-Originating-IP: [10.33.100.58]
X-Mailer: Zimbra 7.2.0_GA_2669 (ZimbraWebClient - GC62 (Linux)/7.2.0_GA_2669)

[Message part 1 (text/plain, inline)]
package: x2goserver
priority: wishlist
tags: patch

This is a proposal patch for a MySQL session storage database backend for X2Go Server.

I did this simply because :

  1) I'm not used to PostgreSQL and much more skilled with MySQL
  2) I do believe MySQL is pretty common on Linux and is widely spread so I guess this can be useful for many other people willing to build a strong TCE setup and not willing to dig into PostgreSQL
  3) I find it a lot easier to build a multi-master replication scenario with MySQL than with PostgreSQL (but as I said, I'm much more skilled wih MySQL)

This backend is tightly inspired by the PostgreSQL backend and work exactly the same so this is a drop in replacement for it, it's running in my POC for months now and it has been proven very stable.
Feel free to test by yourself and report errors.


Regards,
Walid Moghrabi

TRAVAUX.COM
BAT I - PARC CEZANNE 2 290 AVENUE GALILEE - CS 80403
13591 AIX EN PROVENCE CEDEX 3

---
DISCLAIMER: This e-mail is private and confidential and may contain proprietary or legally privileged information. It is for the intended recipient only. If you have received this email in error, please notify the author by replying to it and then destroy it. If you are not the intended recipient you must not use, disclose, distribute, copy, print or rely on this e-mail or any attachment. Thank you
[MySQL-session-backend.patch (text/x-patch, attachment)]

Send a report that this bug log contains spam.

X2Go Developers <owner@bugs.x2go.org>. Last modified: Thu Nov 21 14:59:24 2024; 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.