ejabberd - Comments for "mod_ctlextra export to odbc" https://www.ejabberd.im/node/1259 en Thanks https://www.ejabberd.im/node/1259#comment-2775 <div class="quote-msg"> <div class="quote-author"><em>teo</em> wrote:</div> <p>ejabberd from <noindex><a href="http://sgolovan.jabber.ru/debian/" title="http://sgolovan.jabber.ru/debian/" rel="nofollow" >http://sgolovan.jabber.ru/debian/</a></noindex> has odbc modules compiled in. But it doesn't include native mysql and postgresql drivers.</p></div> <p>Thanks, I have already found in deb-src: DEB_CONFIGURE_EXTRA_FLAGS := --enable-odbc</p> Thu, 21 Dec 2006 22:35:55 +0000 CombatPenguin comment 2775 at https://www.ejabberd.im ejabberd from https://www.ejabberd.im/node/1259#comment-2774 <p>ejabberd from <noindex><a href="http://sgolovan.jabber.ru/debian/" title="http://sgolovan.jabber.ru/debian/" rel="nofollow" >http://sgolovan.jabber.ru/debian/</a></noindex> has odbc modules compiled in. But it doesn't include native mysql and postgresql drivers.</p> Thu, 21 Dec 2006 22:02:46 +0000 teo comment 2774 at https://www.ejabberd.im Don't wish to open a new topic... https://www.ejabberd.im/node/1259#comment-2773 <p>How I can see which modules or options ejabberd compiled in?<br /> Interesting odbc support!<br /> P.S. I have binary version from <noindex><a href="http://sgolovan.jabber.ru/debian/" title="http://sgolovan.jabber.ru/debian/" rel="nofollow" >http://sgolovan.jabber.ru/debian/</a></noindex><br /> Sorry for my bad English :(</p> Thu, 21 Dec 2006 21:53:10 +0000 CombatPenguin comment 2773 at https://www.ejabberd.im Many thanks!!! https://www.ejabberd.im/node/1259#comment-2770 <p>You rescued me :)<br /> Thank you!</p> Thu, 21 Dec 2006 09:43:52 +0000 CombatPenguin comment 2770 at https://www.ejabberd.im Table not exportable https://www.ejabberd.im/node/1259#comment-2769 <div class="quote-msg"> <div class="quote-author"><em>CombatPenguin</em> wrote:</div> <pre>=ERROR REPORT==== 20-Dec-2006::20:54:12 === E(&lt;3921.23754.19&gt;:ejabberd_hooks:187): {undef, [{ejd2odbc, export_private_storage, ["jabber.ellada.com.ua", "/tmp/private_storage.txt"]},</pre><p> Tables private_storage and vcard_search not exported! :(</p></div> <p>I'm developing for ejabberd SVN, and you seem to use ejabberd 1.1.2. Some tables will not be exported. I've updated mod_ctlextra so it does not crash. Please try the new version, and remember that privacy_storage table will not be exported.</p> Thu, 21 Dec 2006 08:54:48 +0000 mfoss comment 2769 at https://www.ejabberd.im Hmm... https://www.ejabberd.im/node/1259#comment-2768 <p>ejabberdctl export2odbc jabber.mydomain /tmp/</p> <p>Exporting Mnesia table 'last' on server 'jabber.mydomain' to file '/tmp/last.txt'<br /> Exporting Mnesia table 'offline' on server 'jabber.mydomain' to file '/tmp/offline.txt'<br /> Exporting Mnesia table 'passwd' on server 'jabber.mydomain' to file '/tmp/passwd.txt'<br /> Exporting Mnesia table 'private_storage' on server 'jabber.mydomain' to file '/tmp/private_storage.txt'</p> <p>And next:<br /> =ERROR REPORT==== 20-Dec-2006::20:54:12 ===<br /> E(&lt;3921.23754.19&gt;:ejabberd_hooks:187): {undef,<br /> [{ejd2odbc,<br /> export_private_storage,<br /> ["jabber.ellada.com.ua",<br /> "/tmp/private_storage.txt"]},<br /> {lists,foreach,2},<br /> {mod_ctlextra,ctl_process,2},<br /> {ejabberd_hooks,run_fold1,4},<br /> {ejabberd_ctl,process,1},<br /> {rpc,'-handle_call/3-fun-0-',5}]}<br /> running hook: {ejabberd_ctl_process,[["export2odbc",<br /> "jabber.mydomain",<br /> "/tmp/"]]}<br /> ** at node ejabberd@jabber **</p> <p>Tables private_storage and vcard_search not exported! :(</p> Wed, 20 Dec 2006 17:46:26 +0000 CombatPenguin comment 2768 at https://www.ejabberd.im Big thanks! https://www.ejabberd.im/node/1259#comment-2767 <p>Big thanks!!! It works!!!</p> Wed, 20 Dec 2006 17:42:04 +0000 CombatPenguin comment 2767 at https://www.ejabberd.im CombatPenguin wrote:I https://www.ejabberd.im/node/1259#comment-2766 <div class="quote-msg"> <div class="quote-author"><em>CombatPenguin</em> wrote:</div> <p>I tried ejabberdctl export2odbc myserver.mydomain /tmp/output</p></div> <p>You are right, there was a bug on mod_ctlextra. Get the new fixed version from SVN, and now the syntax is:</p> <pre>ejabberdctl export2odbc myserver.mydomain /tmp/</pre> Wed, 20 Dec 2006 14:06:32 +0000 mfoss comment 2766 at https://www.ejabberd.im