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

Reply or subscribe to this bug.

Toggle useless messages

View this report as an mbox folder, status mbox, maintainer mbox


Report forwarded to x2go-dev@lists.x2go.org, X2Go Developers <x2go-dev@lists.x2go.org>:
Bug#1135; Package x2goserver. (Fri, 13 Jan 2017 17:00:02 GMT) Full text and rfc822 format available.

Acknowledgement sent to Walid MOGHRABI <w.moghrabi@servicemagic.eu>:
New Bug report received and forwarded. Copy sent to X2Go Developers <x2go-dev@lists.x2go.org>. (Fri, 13 Jan 2017 17:00:02 GMT) Full text and rfc822 format available.

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

From: Walid MOGHRABI <w.moghrabi@servicemagic.eu>
To: submit@bugs.x2go.org
Subject: MySQL Database backend support
Date: Fri, 13 Jan 2017 17:55:19 +0100 (CET)
[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)]

Information forwarded to x2go-dev@lists.x2go.org, X2Go Developers <x2go-dev@lists.x2go.org>:
Bug#1135; Package x2goserver. (Fri, 13 Jan 2017 17:10:02 GMT) Full text and rfc822 format available.

Acknowledgement sent to Stefan Baur <X2Go-ML-1@baur-itcs.de>:
Extra info received and forwarded to list. Copy sent to X2Go Developers <x2go-dev@lists.x2go.org>. (Fri, 13 Jan 2017 17:10:02 GMT) Full text and rfc822 format available.

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

From: Stefan Baur <X2Go-ML-1@baur-itcs.de>
To: Oleksandr Shneyder <o.shneyder@phoca-gmbh.de>, 1135@bugs.x2go.org
Subject: Re: [X2Go-Dev] Bug#1135: MySQL Database backend support
Date: Fri, 13 Jan 2017 18:03:50 +0100
[Message part 1 (text/plain, inline)]
Alex,

please check if this patch fulfills all the requirements you mentioned
off-list; if not, please comment and advise Walid what he needs to
add/change.

Kind Regards,
Stefan Baur

Am 13.01.2017 um 17:55 schrieb Walid MOGHRABI:
> 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
> 
> 
> 
> _______________________________________________
> x2go-dev mailing list
> x2go-dev@lists.x2go.org
> http://lists.x2go.org/listinfo/x2go-dev
> 


-- 
BAUR-ITCS UG (haftungsbeschränkt)
Geschäftsführer: Stefan Baur
Eichenäckerweg 10, 89081 Ulm | Registergericht Ulm, HRB 724364
Fon/Fax 0731 40 34 66-36/-35 | USt-IdNr.: DE268653243

[signature.asc (application/pgp-signature, attachment)]

Information forwarded to x2go-dev@lists.x2go.org, X2Go Developers <x2go-dev@lists.x2go.org>:
Bug#1135; Package x2goserver. (Fri, 13 Jan 2017 17:25:02 GMT) Full text and rfc822 format available.

Acknowledgement sent to Walid MOGHRABI <w.moghrabi@servicemagic.eu>:
Extra info received and forwarded to list. Copy sent to X2Go Developers <x2go-dev@lists.x2go.org>. (Fri, 13 Jan 2017 17:25:02 GMT) Full text and rfc822 format available.

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

From: Walid MOGHRABI <w.moghrabi@servicemagic.eu>
To: Stefan Baur <X2Go-ML-1@baur-itcs.de>, 1135@bugs.x2go.org
Cc: Oleksandr Shneyder <o.shneyder@phoca-gmbh.de>
Subject: Re: [X2Go-Dev] Bug#1135: Bug#1135: MySQL Database backend support
Date: Fri, 13 Jan 2017 18:13:53 +0100 (CET)
Ho, I just saw that I forgot to mention that MySQL support for Perl::DBI must be installed.
It is not with the x2goserver package and I didn't find how to add it as a dependency in the sources (I probably didn't search too far to be honest ...)


Regards,
Walid Moghrabi

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



----- Mail original ----- 

De: "Stefan Baur" <X2Go-ML-1@baur-itcs.de> 
À: "Oleksandr Shneyder" <o.shneyder@phoca-gmbh.de>, 1135@bugs.x2go.org 
Envoyé: Vendredi 13 Janvier 2017 18:03:50 
Objet: [X2Go-Dev] Bug#1135: Bug#1135: MySQL Database backend support 

Alex, 

please check if this patch fulfills all the requirements you mentioned 
off-list; if not, please comment and advise Walid what he needs to 
add/change. 

Kind Regards, 
Stefan Baur 

Am 13.01.2017 um 17:55 schrieb Walid MOGHRABI: 
> 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 
> 
> 
> 
> _______________________________________________ 
> x2go-dev mailing list 
> x2go-dev@lists.x2go.org 
> http://lists.x2go.org/listinfo/x2go-dev 
> 


-- 
BAUR-ITCS UG (haftungsbeschränkt) 
Geschäftsführer: Stefan Baur 
Eichenäckerweg 10, 89081 Ulm | Registergericht Ulm, HRB 724364 
Fon/Fax 0731 40 34 66-36/-35 | USt-IdNr.: DE268653243 


_______________________________________________ 
x2go-dev mailing list 
x2go-dev@lists.x2go.org 
http://lists.x2go.org/listinfo/x2go-dev
---
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


Information forwarded to x2go-dev@lists.x2go.org, X2Go Developers <x2go-dev@lists.x2go.org>:
Bug#1135; Package x2goserver. (Fri, 20 Oct 2017 17:20:02 GMT) Full text and rfc822 format available.

Acknowledgement sent to Walid MOGHRABI <w.moghrabi@servicemagic.eu>:
Extra info received and forwarded to list. Copy sent to X2Go Developers <x2go-dev@lists.x2go.org>. (Fri, 20 Oct 2017 17:20:02 GMT) Full text and rfc822 format available.

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

From: Walid MOGHRABI <w.moghrabi@servicemagic.eu>
To: 1135@bugs.x2go.org
Subject: MySQL session backend (fixed version)
Date: Fri, 20 Oct 2017 19:16:15 +0200 (CEST)
[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)]

Information forwarded to x2go-dev@lists.x2go.org, X2Go Developers <x2go-dev@lists.x2go.org>:
Bug#1135; Package x2goserver. (Fri, 20 Oct 2017 17:25:02 GMT) Full text and rfc822 format available.

Acknowledgement sent to Walid MOGHRABI <w.moghrabi@servicemagic.eu>:
Extra info received and forwarded to list. Copy sent to X2Go Developers <x2go-dev@lists.x2go.org>. (Fri, 20 Oct 2017 17:25:02 GMT) Full text and rfc822 format available.

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

From: Walid MOGHRABI <w.moghrabi@servicemagic.eu>
To: 1135@bugs.x2go.org
Subject: MySQL session backend
Date: Fri, 20 Oct 2017 19:22:53 +0200 (CEST)
[Message part 1 (text/plain, inline)]
I forgot the modified /etc/x2go/x2gosql/sql file ...



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
[sql-conf.patch (text/x-patch, attachment)]

Send a report that this bug log contains spam.


X2Go Developers <owner@bugs.x2go.org>. Last modified: Tue Dec 18 10:49:22 2018; Machine Name: ymir.das-netzwerkteam.de

X2Go Bug tracking system
Copyright (C) 1999 Darren O. Benham, 1997,2003 nCipher Corporation Ltd, 1994-97 Ian Jackson.