<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><br></div><div>Two (now) known issue:</div><div><br></div><div>Filename column is too short, but this is due to the fact that mysql 5 only supports keys length of max 1000 bytes.</div><div><br></div><div>So the filename+peername must be below 333 UTF characters (since mysql looks at worst-case when generating the tables). </div><div><br></div><div>Weird characters in filename cuts off the filename at the character. I have a danish letter (ĺ encoded in iso-8859-1: \370) still present in my </div>now UTF-8 filesystem names. <div><br></div><div>Two regressions from the current trunk... :-(</div><div><br></div><div>cheers, </div><div>:-Dennis</div><div><div><br></div><div><div><div>On 29/08/2010, at 22.36, Dennis Schafroth wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hey,<br><br>Attached is a patch to a database abstraction. I have it running on two Fedora 13 and a OpenSUSE 11.3. It should be considered beta status, and I would like to get feed back on how it works for others set-ups (non production!). <br></div><span><db_api.patch.gz></span><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><br><br>I have mostly tested using MySQL 5. I have done some minor testing on sqlite 3, and haven't seen any regression, but wont promise.<br><br>The SQL statements has been modified to a level so they work for these databases, but some more advanced SQL mapping is prob. needed to support more.<br><br>DB API with support for:<br>- sqlite 2 (not tested), sqlite 3 (somewhat tested), mysql 5 <br>- New global configuration: database <file with database spec> containing one of: <br><span class="Apple-tab-span" style="white-space: pre; "> </span>- <a href="mysql://user:passwd@host:port/schema">mysql://user:passwd@host:port/schema</a> <br><span class="Apple-tab-span" style="white-space: pre; "> </span>- <a href="sqlite3://path/to/file">sqlite3://path/to/file</a><br><span class="Apple-tab-span" style="white-space: pre; "> </span>- <a href="sqlite2://path/to/file">sqlite2://path/to/file</a><br>- For testing the -a option can be used to give a similar database specification. <br>- No support for creating the database and tables in mysql 5. There is a ./sql/csync.sql for creating the tables where it uses UTF-8 binary character encoding, but this must be changed to match your file system setup and case (in)sensitive !!! <br><br>I have done some changes in the autoconf / automake, in which I am no expert. <br><br>mysql support is currently only enabled if you configure with --enable-mysql. <br><br>For a mysql set-up: <br>1) configure and built with mysql support<br>2) create a database as root/admin and grant access to your csync2 user. <br>3) create the tables/indexes using the sql/csync2.sql (modified to your setup) <br>4) create the database file spec file. <br>5) add the global configuration: database <database spec file> <br><br>Should now be ready to test. <br><br>Also included in the patch is a option for syslog logging (-l) and a change in backup strategy in the daemon. I prefer to create a identical directory tree in the backup, instead of the flat structure. <br><br>cheers, <br>:-Dennis Schafroth<br><br>On 22/08/2010, at 21.51, Lars Ellenberg wrote:<br><br><blockquote type="cite">On Sat, Aug 21, 2010 at 11:05:27PM +0200, Dennis Schafroth wrote:<br></blockquote><blockquote type="cite"><blockquote type="cite">Hey, <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">I am working on a patch to introduce a simple database abstraction<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">layer, so it will be easier to introduce alternative databases. I also<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">have the a basic mysql version (almost) working, it has crashed on a<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">OpenSuse box, but worked on my Fedora boxes.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">If there are any brave volunteers, that wants to try, let me know. It<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">wont be clean at the moment. <br></blockquote></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Great.<br></blockquote><blockquote type="cite">Please post a unified diff against latest svn to this list.<br></blockquote><blockquote type="cite">Or, if you prefer, send it pm my way.<br></blockquote><blockquote type="cite">Or put it online as git/mercurial/whatever.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Thanks,<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">-- <br></blockquote><blockquote type="cite">: Lars Ellenberg<br></blockquote><blockquote type="cite">: LINBIT | Your Way to High Availability<br></blockquote><blockquote type="cite">: DRBD/HA support and consulting <a href="http://www.linbit.com/">http://www.linbit.com</a><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">DRBD® and LINBIT® are registered trademarks of LINBIT, Austria.<br></blockquote><blockquote type="cite">_______________________________________________<br></blockquote><blockquote type="cite">Csync2 mailing list<br></blockquote><blockquote type="cite"><a href="mailto:Csync2@lists.linbit.com">Csync2@lists.linbit.com</a><br></blockquote><blockquote type="cite"><a href="http://lists.linbit.com/mailman/listinfo/csync2">http://lists.linbit.com/mailman/listinfo/csync2</a><br></blockquote><blockquote type="cite"><br></blockquote></div>_______________________________________________<br>Csync2 mailing list<br><a href="mailto:Csync2@lists.linbit.com">Csync2@lists.linbit.com</a><br>http://lists.linbit.com/mailman/listinfo/csync2<br></blockquote></div><br></div></div></body></html>