<html><head></head><body 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></body></html>