[X2Go-User] Connection failing on Ubuntu 12.04 after upgrade

[Martyn Welch]

Found the issue.

We run with numeric usernames (due to our corporate accounts having pure 
numeric usernames and a wish to use that for authentication). 
Historically this has been an issue with some old Unix/Linux tools (the 
username getting mistaken for a UID) however our usernames are 
sufficiently long that in practice this has never been an issue (and it 
possibly only affects really old versions of some tools...)

The temporary fix for me is to modify line 67 of x2gosqlitewrapper.pl in 
sanitizer(). The line is currently:

if ($string =~ 
/^([a-zA-Z\_][a-zA-Z0-9\_\-\.\@]{0,47}[\$]?)\-([\d]{2,4})\-([\d]{9,12})\_[a-zA-Z0-9\_\-\.]*\_dp[\d]{1,2}$/) 
{

I changed it to:

if ($string =~ 
/^([a-zA-Z0-9\_][a-zA-Z0-9\_\-\.\@]{0,47}[\$]?)\-([\d]{2,4})\-([\d]{9,12})\_[a-zA-Z0-9\_\-\.]*\_dp[\d]{1,2}$/) 
{

Notice the addition of the "0-9" in the first part of the regex...

Martyn

On 28/04/15 13:40, Martyn Welch wrote:
> Bit more debug. If I kill x2gostartagent before killing the client, I
> get the following as an error message (it continues with the session ID
> incrementing):
>
> Connection failed argument "session_id" malformed at
> /usr/lib/x2go/x2gosqlitewrapper.pl line 229. :
> /usr/lib/x2go/x2gosqlitewrapper insertsession 50 RWVM-03C
> 113006950-50-1430224631_stDUNITY_dp24 at /usr/lib/x2go/x2godbwrapper.pm
> line 320. argument "session_id" malformed at
> /usr/lib/x2go/x2gosqlitewrapper.pl line 229. :
> /usr/lib/x2go/x2gosqlitewrapper insertsession 51 RWVM-03C
> 113006950-51-1430224631_stDUNITY_dp24 at /usr/lib/x2go/x2godbwrapper.pm
> line 320. argument "session_id" malformed at
> /usr/lib/x2go/x2gosqlitewrapper.pl line 229. :
> /usr/lib/x2go/x2gosqlitewrapper insertsession 52 RWVM-03C
> 113006950-52-1430224632_stDUNITY_dp24 at /usr/lib/x2go/x2godbwrapper.pm
> line 320. argument "session_id" malformed at
> /usr/lib/x2go/x2gosqlitewrapper.pl line 229. :
> /usr/lib/x2go/x2gosqlitewrapper insertsession 53 RWVM-03C
> 113006950-53-1430224632_stDUNITY_dp24 at /usr/lib/x2go/x2godbwrapper.pm
> line 320. argument "session_id" malformed at
> /usr/lib/x2go/x2gosqlitewrapper.pl
>
> Martyn
>
> On 28/04/15 13:27, Martyn Welch wrote:
>> On 28/04/15 11:21, Stefan Baur wrote:
>>> -----BEGIN PGP SIGNED MESSAGE-----
>>> Hash: SHA256
>>>
>>> Am 28.04.2015 um 11:40 schrieb Martyn Welch:
>>>
>>>> Apr 27 17:42:21 RWVM-05B /usr/bin/x2gostartagent: x2gostartagent
>>>> called with options: 800x600 adsl 16m-jpeg-9 unix-kde-depth_32 us
>>>> auto 1 D UNITY
>>>
>>> Oh, wait, here's the issue: You're trying to use UNITY.
>>>
>>> http://wiki.x2go.org/doku.php/doc:de-compat
>>>
>>> states:
>>>
>>> UNITY
>>>
>>>      Ubuntu 12.04: Compatible, as long as package “unity-2d” is
>>> installed. By default with “Ubuntu Desktop”, it is.
>>>      Ubuntu 12.10 and later (including 14.04): Not compatible
>>>
>>
>> Hi Stefan,
>>
>> I was working before the x2go update, the machine has the
>> unity-2d package installed.
>>
>> Without that I'd expect to get a blank desktop - it's not getting
>> that far, it's not even opening up the window the desktop is
>> usually displayed in.
>>
>> Martyn
>>
>>> So you will have to switch to one of the Desktop Environments listed
>>> as "Supported" on that page.
>>>
>>> - -Stefan
>>>
>>> - --
>>> 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
>>> -----BEGIN PGP SIGNATURE-----
>>> Version: GnuPG v2
>>>
>>> iQEcBAEBCAAGBQJVP18/AAoJEG7d9BjNvlEZ+tkH/2kdc0H8f2aC9oNgvVfYoQL3
>>> M64tesaGk9R4eJstl+7M/irJQkpw9DsSU382yik8iY9C9SULsIdZdXRxhQzQ7nLV
>>> 71SEYj3y3rmWeSC2Dsm0j/aNUqFPZd4GrRvxxuHSSdo7kVg+A3bogvIK5Y7yvb+D
>>> n1YM6sVfltM9BoZLc8BW58n123h/w9f2tCGeI5ClJ3B6Y3kMz1GFTaVCJaC/5pE5
>>> fWxXql749GXAD39YSQriWtWz33jb6NhNdqoZ2cgKVZA6cgOqEJJ5kA7BAZ0CJEq8
>>> FYj0H5hP85pZqjXSJDp5kqclVKZpFG82EB2Xfu8SQYru3wDT865zmrYljPHX7oA=
>>> =a6CC
>>> -----END PGP SIGNATURE-----
>>> _______________________________________________
>>> x2go-user mailing list
>>> x2go-user at lists.x2go.org
>>> http://lists.x2go.org/listinfo/x2go-user
>>>
>>
>

-- 
Martyn Welch (Lead Software Engineer)  | Registered in England and Wales
GE Intelligent Platforms               | (3828642) at 100 Barbirolli Square
T +44(0)1327322748                     | Manchester, M2 3AB
E martyn.welch at ge.com                  | VAT:GB 927559189