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

🔗 View this message in rfc822 format

X-Loop: owner@bugs.x2go.org
Subject: Bug#1135: MySQL Database backend support
Reply-To: Walid MOGHRABI <w.moghrabi@servicemagic.eu>, 1135@bugs.x2go.org
Resent-From: Walid MOGHRABI <w.moghrabi@servicemagic.eu>
Resent-To: x2go-dev@lists.x2go.org
Resent-CC: X2Go Developers <x2go-dev@lists.x2go.org>
X-Loop: owner@bugs.x2go.org
Resent-Date: Fri, 13 Jan 2017 17:00:02 +0000
Resent-Message-ID: <handler.1135.B.148432653811008@bugs.x2go.org>
Resent-Sender: owner@bugs.x2go.org
X-X2Go-PR-Message: report 1135
X-X2Go-PR-Package: x2goserver
X-X2Go-PR-Keywords: patch
Received: via spool by submit@bugs.x2go.org id=B.148432653811008
          (code B); Fri, 13 Jan 2017 17:00:02 +0000
Received: (at submit) by bugs.x2go.org; 13 Jan 2017 16:55:38 +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.8 required=3.0 tests=BAYES_50,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 8B0003CDDD
	for <submit@bugs.x2go.org>; Fri, 13 Jan 2017 17:55:32 +0100 (CET)
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 Ja2EC9ajA4wY for <submit@bugs.x2go.org>;
	Fri, 13 Jan 2017 17:55:26 +0100 (CET)
Received: from zm-01.servicemagic.eu (zm-01.servicemagic.eu [176.31.236.17])
	by ymir.das-netzwerkteam.de (Postfix) with ESMTPS id BC66D5DAA7
	for <submit@bugs.x2go.org>; Fri, 13 Jan 2017 17:55:25 +0100 (CET)
Received: from localhost (localhost.localdomain [127.0.0.1])
	by zm-01.servicemagic.eu (Postfix) with ESMTP id 058CC80A9221F
	for <submit@bugs.x2go.org>; Fri, 13 Jan 2017 17:55:23 +0100 (CET)
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 NCAwZplSIJ4z for <submit@bugs.x2go.org>;
	Fri, 13 Jan 2017 17:55:19 +0100 (CET)
Received: from zm-01.servicemagic.eu (localhost.localdomain [127.0.0.1])
	by zm-01.servicemagic.eu (Postfix) with ESMTP id 62BE4807CC6AA
	for <submit@bugs.x2go.org>; Fri, 13 Jan 2017 17:55:19 +0100 (CET)
Date: Fri, 13 Jan 2017 17:55:19 +0100 (CET)
From: Walid MOGHRABI <w.moghrabi@servicemagic.eu>
To: submit@bugs.x2go.org
Message-ID: <1719550560.33223559.1484326519373.JavaMail.root@servicemagic.eu>
In-Reply-To: <1040981999.33222686.1484325938728.JavaMail.root@servicemagic.eu>
MIME-Version: 1.0
Content-Type: multipart/mixed; 
	boundary="----=_Part_33223557_1572844661.1484326519364"
X-Originating-IP: [10.33.100.60]
X-Mailer: Zimbra 7.2.0_GA_2669 (ZimbraWebClient - GC55 (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, til now, all my tests seems to work correctly, 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-Database-backend-support.patch (text/x-patch, attachment)]

Send a report that this bug log contains spam.

X2Go Developers <owner@bugs.x2go.org>. Last modified: Sun Dec 7 15:15:13 2025; 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.