[Csync2] csync2 git problem

[Lars Ellenberg]

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.