[strongSwan] attr-sql - case insensitive?

Sven Anders anders at anduras.de
Wed Jul 11 16:21:27 CEST 2018

Am 05.07.2018 um 18:10 schrieb Tobias Brunner:
> Hi Sven,
>> In other words:
>>  I have to change to code to make it work this way.
>>  At least the attr-sql plugin code.
>> Is this correct?
> You can try and see what happens if you don't (i.e. just change the DB).
>  But I guess you have change some code.
> Regards,
> Tobias


I'm using sqlite3 here, because I only need this for static IP assignments.

And I tried your idea, but the database code stores the data in a binary format
(for example: X'294130303030... ).

So no chance here, even if I set the data field to "TEXT NOT NULL COLLATE NOCASE".

But thanks for the tips!

 Sven Anders

 Sven Anders <anders at anduras.de>                 () UTF-8 Ribbon Campaign
                                                 /\ Support plain text e-mail
 ANDURAS intranet security AG
 Messestrasse 3 - 94036 Passau - Germany
 Web: www.anduras.de - Tel: +49 (0)851-4 90 50-0 - Fax: +49 (0)851-4 90 50-55

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
  - Benjamin Franklin

More information about the Users mailing list