[Csync2] csync2 git problem

[InterNetX - Carsten Schoene]

Am 11.07.2011 20:56, schrieb InterNetX - Juergen Gotteswinter:
> ---------- Ursprüngliche Nachricht ----------
> Von: Lars Ellenberg <lars.ellenberg at linbit.com>
> An: csync2 at lists.linbit.com
> Datum: 11. Juli 2011 um 18:54
> Betreff: Re: [Csync2] csync2 git problem
> 
> On Mon, Jul 11, 2011 at 06:43:15PM +0200, Lars Ellenberg wrote:
>> On Mon, Jul 11, 2011 at 11:21:02AM +0200, Juergen Gotteswinter wrote:
>> > Hi,
>> >
>> > we got problems with compiling csync 1.2.x on rhel6, so we did a git
>> > checkout. the git version of csync2 compiles and installs fine, but
>> > i get this error message when trying to sync 2 nodes:
>> >
>> > :/etc$ csync2 -xv
>> > Opening shared library libsqlite3.so
>> >
>> > Reading symbols from shared library libsqlite3.so
>> >
>> > Database Error: Checking for removed files [1]: no such column: TRUE
>> > on executing SELECT filename from file where filename = '/' OR TRUE
>> > ORDER BY filename
>> >
>> > Any ideas how to fix this?
>>
>> You could do a git checkout ;-)
>>
>> http://git.linbit.com/?p=csync2.git;a=commit;h=2d459f6cab22b9c4f682b02b6b21e12cf27c23df
> 
> Oh wait. That was your problem, right?
> Sorry, I misread you post.
> 
> Well, replace TRUE with something that happens to be true, always?
> (1 = 1), would that help?
> 
> Just "OR 1" is invalid sql in postgres, unfortunately, so whatever you
> use as replacement, it needs to work in all supported SQL "flavors".
> 
> Or change the logic in that function,
> and take different branches for
>  recursive, '/'
>  recursive, non '/',
>  non-recursive,
> with dedicated SQL strings each.
> Which makes things even more ugly...
> 
> --
> : Lars Ellenberg
> : LINBIT | Your Way to High Availability
> : DRBD/HA support and consulting http://www.linbit.com
> 
> DRBD® and LINBIT® are registered trademarks of LINBIT, Austria.
> _______________________________________________
> Csync2 mailing list
> Csync2 at lists.linbit.com
> http://lists.linbit.com/mailman/listinfo/csync2

I changed TRUE to 1=1 and this seems to work (sqlite3 tested), patch attached.

I also had to fix configure.ac regarding GNUTLS, because of
 USE_GNUTLS should be HAVE_LIBGNUTLS and
 undefined reference to `gnutls_strerror_name'
which is only available in version 2.6.0 and newer, patch attached

Cheers
-- 
Carsten Schöne
Leiter Rechenzentrum

InterNetX GmbH
Maximilianstr. 6
93047 Regensburg

Tel.   +49 941 59559-480
Fax   +49 941 59579-051

www.internetx.com
www.facebook.com/InterNetX
www.twitter.com/InterNetX

Geschäftsführer/CEO: Thomas Mörz
Amtsgericht Regensburg, HRB 7142
-------------- next part --------------
A non-text attachment was scrubbed...
Name: csync2-SQL-TRUE.patch
Type: text/x-patch
Size: 373 bytes
Desc: not available
URL: <http://lists.linbit.com/pipermail/csync2/attachments/20110713/877a273d/attachment.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: csync2-GNUTLS.patch
Type: text/x-patch
Size: 878 bytes
Desc: not available
URL: <http://lists.linbit.com/pipermail/csync2/attachments/20110713/877a273d/attachment-0001.bin>