Hi,<br><br>&nbsp; I&#39;m using Centos 5.2 with sqlite3. I&#39;ve successfully patched csync2 to support sqlite3 (<a href="http://tmp.askask.com/2008/01/csync2-sqlite3-wip.patch">http://tmp.askask.com/2008/01/csync2-sqlite3-wip.patch</a>). Now I have 3 nodes (one master and two slaves). The conf is:<br>
group asterisk #group name, we can have multiple groups<br>{<br>&nbsp;&nbsp;&nbsp; host <a href="http://berkut.mediafon.lt">berkut.mediafon.lt</a>; #master server<br>&nbsp;&nbsp;&nbsp; host (<a href="http://voip-gw-1.900.lt">voip-gw-1.900.lt</a>);&nbsp;&nbsp;&nbsp; #slave server<br>
&nbsp;&nbsp;&nbsp; host (<a href="http://voip-gw-2.900.lt">voip-gw-2.900.lt</a>);&nbsp;&nbsp;&nbsp; #slave server<br><br>&nbsp;&nbsp;&nbsp; key /etc/csync2_ssl_cert.key;<br><br>&nbsp;&nbsp;&nbsp; exclude *~ .* ok lock control;<br>&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp; include %etcdir%/odbc.ini;<br>&nbsp;&nbsp;&nbsp; include %etcdir%/odbcinst.ini;<br>
&nbsp;&nbsp;&nbsp; include %etcdir%/asterisk;<br>&nbsp;&nbsp;&nbsp; exclude %etcdir%/asterisk/sip.conf;<br>&nbsp;&nbsp;&nbsp; include %vardir%/lib/asterisk;<br>&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp; action<br>&nbsp;&nbsp;&nbsp; {<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; pattern %etcdir%/asterisk/extensions.ael;<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; exec &quot;/usr/sbin/rasterisk -x &#39;ael reload&#39;&quot;;<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; logfile &quot;/var/log/csync2/action.log&quot;;<br>&nbsp;&nbsp;&nbsp; }<br>&nbsp;&nbsp;&nbsp; action<br>&nbsp;&nbsp;&nbsp; {<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; pattern %etcdir%/asterisk/extensions.conf;<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; exec &quot;/usr/sbin/rasterisk -x &#39;dialplan reload&#39;&quot;;<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; logfile &quot;/var/log/csync2/action.log&quot;;<br>&nbsp;&nbsp;&nbsp; }<br><br>&nbsp;&nbsp;&nbsp; backup-directory /var/backups/csync2;<br>&nbsp;&nbsp;&nbsp; backup-generations 3;<br>&nbsp;&nbsp;&nbsp; auto none; #no automatic sync<br>}<br>prefix etcdir<br>{<br>&nbsp;&nbsp;&nbsp; on <a href="http://berkut.mediafon.lt">berkut.mediafon.lt</a>:&nbsp; /opt/asterisk/etc;<br>
&nbsp;&nbsp;&nbsp; on <a href="http://voip-gw-1.900.lt">voip-gw-1.900.lt</a>:&nbsp;&nbsp;&nbsp; /etc;<br>&nbsp;&nbsp;&nbsp; on <a href="http://voip-gw-2.900.lt">voip-gw-2.900.lt</a>:&nbsp;&nbsp;&nbsp; /etc;<br>}<br>prefix vardir<br>{<br>&nbsp;&nbsp;&nbsp; on <a href="http://berkut.mediafon.lt">berkut.mediafon.lt</a>:&nbsp;&nbsp;&nbsp; /opt/asterisk/var;<br>
&nbsp;&nbsp;&nbsp; on <a href="http://voip-gw-1.900.lt">voip-gw-1.900.lt</a>:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /var;<br>&nbsp;&nbsp;&nbsp; on <a href="http://voip-gw-2.900.lt">voip-gw-2.900.lt</a>:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /var;<br>}<br><br>But then I execute command from <a href="http://berkut.mediafon.lt">berkut.mediafon.lt</a> , I get:<br>
<br>csync2 -x -vvvvvvvvvvvvvvvvvvvvvvv<br>My hostname is <a href="http://berkut.mediafon.lt">berkut.mediafon.lt</a>.<br>Database-File: /var/lib/csync2/berkut.mediafon.lt.db3<br>Config-File:&nbsp;&nbsp; /etc/csync2.cfg<br>Prefix &#39;etcdir&#39; is set to &#39;/opt/asterisk/etc&#39;.<br>
Prefix &#39;vardir&#39; is set to &#39;/opt/asterisk/var&#39;.<br>Running recursive check for / ...<br>SQL: SELECT filename from file where filename = &#39;/&#39; or 1 ORDER BY filename<br>Trying to fetch a row from the database.<br>
Database Error: Checking for removed files [21].<br><br>Please help to solve this issue. Maybe better to use older sqlite version?<br>Thanks<br clear="all"><br>-- <br>Pagarbiai &nbsp;/ Best Regards,<br>Giedrius Augys<br>