From X2Go-ML-1@baur-itcs.de Fri Jan 13 18:09:14 2017 Received: (at 1135) by bugs.x2go.org; 13 Jan 2017 17:09:16 +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=-1.9 required=3.0 tests=BAYES_00,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 226FE3CDDD for <1135@bugs.x2go.org>; Fri, 13 Jan 2017 18:09:14 +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 wtVhvO3ln1C1 for <1135@bugs.x2go.org>; Fri, 13 Jan 2017 18:09:07 +0100 (CET) Received: from mout.kundenserver.de (mout.kundenserver.de [212.227.17.24]) by ymir.das-netzwerkteam.de (Postfix) with ESMTPS id AD47C5DAA7 for <1135@bugs.x2go.org>; Fri, 13 Jan 2017 18:09:06 +0100 (CET) Received: from [192.168.0.23] ([78.43.90.159]) by mrelayeu.kundenserver.de (mreue103 [212.227.15.145]) with ESMTPSA (Nemesis) id 0M83Dl-1cfETV20vJ-00vgis; Fri, 13 Jan 2017 18:04:04 +0100 Subject: Re: [X2Go-Dev] Bug#1135: MySQL Database backend support To: Oleksandr Shneyder , 1135@bugs.x2go.org References: <1719550560.33223559.1484326519373.JavaMail.root@servicemagic.eu> From: Stefan Baur Message-ID: <2daf33a3-f457-a7ba-2f23-1d0879392195@baur-itcs.de> Date: Fri, 13 Jan 2017 18:03:50 +0100 User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:45.0) Gecko/20100101 Thunderbird/45.6.0 MIME-Version: 1.0 In-Reply-To: <1719550560.33223559.1484326519373.JavaMail.root@servicemagic.eu> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="TikD4rA1UIfK99Fj6dr7VOpDWWdO2vjqj" X-Provags-ID: V03:K0:DVASkWnO0eUTdbNckXuVNUNevuY8Tdaau4caAKQ4NS1JbvgGOtg bdKYvK3afda6CRAFZUvhwZBPsWESCYimj2MAvI9eoIlWtHgJ+0oMSkURhACRjlZZTu95rMu ifeMWtd6OhwcdPbJPwIFrnmYNc3VoMcxOIgcFV6uhC9MWQR0ugw/CVI0AB1QH6JV/VbQjtw STpwQhj+C1CeANOkcBDXg== X-UI-Out-Filterresults: notjunk:1;V01:K0:5QJKJQIa8CM=:tR5j4IWG4NsPeLnNFGH7p5 MfjDenV0iG6/ygufaDL/7l8pWDqpQ/mHgdXSrpxbdtAxaO7HNdx1nxjD+mSNS8Tt4Ad1QjhVa NzEzYTwtVyQRLIC/6Ue7BMygNc6EwkDEw5TyhcfGCmgTadRD+FwkAlVok7WN+KY7swqb0vi7f /5FegU1UpalZJmqqqBkwRMuUwyxIF45Rhzol9CLelPYAm+2cYSE2mQGrPipqeKYwY9l5QAF0X uJP5pXroe7DNDiPcDSVmS2advJtNOqKv4O/OKa7BKG+kuUDHNT/ZbV8Us+RktHzJh5GpcezUO eN0vFFVpyfw+ocU21GhS1UOb3sGxGmnyekoql7JmQNGBGxYB0GgRW0+ybDabdoCDumsvQwOQB yyoe/QBBD5728h67MlD0lvOBiFmVF91n5OZ7BcPCeELuo1kg+my3ElHSu9MxElQl6tw/p+1yG Gq9BosHoY1i8fxelPkSdPKACR8xlJ2XdOp15FgNPDENmEXNPc84qLUET4rXLZn16OtKQ6k0BD N8vqPfuR2nLyVn0029Tx4TXf9oUqDy+O9+FvDno5pZBJ6+Wz6KS+I5i8TTYGOB0dU6hHVb6f1 F8+3ShqnRjoci8X5jbPen2pa/nRTtBJ86Gj6YEZ7qv1GTprAexIlra2GqnEzqZGiSQGGS0M4m WxFEGK+fXjbPzyJ7nFRhngqYGR7pSXaty8lxdd4T4Jo2fP5xgAotGdRSCrxqLFv+r0yE= This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --TikD4rA1UIfK99Fj6dr7VOpDWWdO2vjqj Content-Type: multipart/mixed; boundary="VS3m6X3UQ1PVgDv18cF1EP13CfKS9LOqr"; protected-headers="v1" From: Stefan Baur To: Oleksandr Shneyder , 1135@bugs.x2go.org Message-ID: <2daf33a3-f457-a7ba-2f23-1d0879392195@baur-itcs.de> Subject: Re: [X2Go-Dev] Bug#1135: MySQL Database backend support References: <1719550560.33223559.1484326519373.JavaMail.root@servicemagic.eu> In-Reply-To: <1719550560.33223559.1484326519373.JavaMail.root@servicemagic.eu> --VS3m6X3UQ1PVgDv18cF1EP13CfKS9LOqr Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable 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 >=20 > This is a proposal patch for a MySQL session storage database backend f= or X2Go Server. >=20 > I did this simply because : >=20 > 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 st= rong TCE setup and not willing to dig into PostgreSQL > 3) I find it a lot easier to build a multi-master replication scenari= o with MySQL than with PostgreSQL (but as I said, I'm much more skilled w= ih MySQL) >=20 > This backend is tightly inspired by the PostgreSQL backend and work exa= ctly the same so this is a drop in replacement for it, til now, all my te= sts seems to work correctly, feel free to test by yourself and report err= ors. >=20 >=20 > Regards, > Walid Moghrabi >=20 > TRAVAUX.COM > BAT I - PARC CEZANNE 2 290 AVENUE GALILEE - CS 80403 > 13591 AIX EN PROVENCE CEDEX 3 >=20 > --- > DISCLAIMER: This e-mail is private and confidential and may contain pro= prietary or legally privileged information. It is for the intended recipi= ent only. If you have received this email in error, please notify the aut= hor by replying to it and then destroy it. If you are not the intended re= cipient you must not use, disclose, distribute, copy, print or rely on th= is e-mail or any attachment. Thank you >=20 >=20 >=20 > _______________________________________________ > x2go-dev mailing list > x2go-dev@lists.x2go.org > http://lists.x2go.org/listinfo/x2go-dev >=20 --=20 BAUR-ITCS UG (haftungsbeschr=E4nkt) Gesch=E4ftsf=FChrer: Stefan Baur Eichen=E4ckerweg 10, 89081 Ulm | Registergericht Ulm, HRB 724364 Fon/Fax 0731 40 34 66-36/-35 | USt-IdNr.: DE268653243 --VS3m6X3UQ1PVgDv18cF1EP13CfKS9LOqr-- --TikD4rA1UIfK99Fj6dr7VOpDWWdO2vjqj Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iQEcBAEBCAAGBQJYeQh7AAoJEG7d9BjNvlEZZ24IALAhwqok2Wraa+MFyPVzLFER oneTTf+JfEkbJfIU2i0PK27ZxQm+VRZGXIflwJuURVCCUgMMrPxUojjYUG5REoBN la1zyAgEtQOosg15aUjudr2hze6tkQldDU+kjycjIL9tArhM+Si20M6HS55nIVaD zffY0o6v6HemHmaHfnWrbviS34/CRlsDRHUYP4QZV6LxFiPtzi+ZVaD6NHJUtx1P sLX5ipV7WHWAuD/OycQUeO+MVS8A6nYN6rT7E2JL2DFZ2/kqsqxfpAhwf4D2De8h rvHDIqBHDxcpgdH1pXIBHWGuCyN+0TS65mbNkLiY3KNMnMFmVJORsDo6EnMVI+0= =nMHv -----END PGP SIGNATURE----- --TikD4rA1UIfK99Fj6dr7VOpDWWdO2vjqj--