X2Go Bug report logs - #1135
MySQL Database backend support

Reply or subscribe to this bug.

Toggle useless messages

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

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)]

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

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)]

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

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

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

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)]

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

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.