Today i have some troubles with mysql backend.
If you make two files with name in different registers (i.e. 1.jpg and 1.JPG) in the same directory , csync2 cannot work corretly.
I have execute this query:
SELECT * FROM file WHERE filename like '1.JPG'
and received 1.jpg file only in the result (result no contains 1.JPG file)
Then, I have execute this query:
SELECT * FROM file WHERE upper(filename) LIKE lower('1.JPG')
and received same result - 1.jpg.
So, i want use two files, 1.jpg and 1.JPG in my synchronization.
Then I go to the source of csync2-2.0 and change some files, see this:
After csync2 -cIr
I have correct DB:
This is correctly work only for MySQL only, but may be helpful for anybody with mysql backend
Csync2 mailing list