ejabberd - Comments for "Can&amp;#039;t access users page in webgui " https://www.ejabberd.im/node/9832 en What is worse is that when https://www.ejabberd.im/node/9832#comment-64960 <p>What is worse is that when this happens all (new) offline messages get lost, too without any information about the problem (other than in error log).</p> <p>Happened to me with ejabberd 13.12 twice already. Used the same solution - deleting offline messages database.</p> Tue, 26 Aug 2014 11:00:46 +0000 arekm comment 64960 at https://www.ejabberd.im For some reason I was unable https://www.ejabberd.im/node/9832#comment-59474 <p>For some reason I was unable to delete the offline_msg from the webadmin.<br /> What I had to do was to empty the offline_msg.DAT and restart ejabberd, but it solved my problems so I'm satisfied.</p> <p>Thanks for your help.</p> Mon, 25 Feb 2013 21:22:59 +0000 tbjornli comment 59474 at https://www.ejabberd.im Maybe there is data in the https://www.ejabberd.im/node/9832#comment-59454 <p>Maybe there is data in the offline_msg table that was not converted correctly to the current format.</p> <p>If you have a reasonably small database, you can try that:<br /> 1. Dump the database to a text file<br /> 2. In the text file, delete everything except offline_msg elements<br /> 3. If you find any strange data, delete it.<br /> 4. Then using webadmin delete the contents of offline_msg table<br /> 5. Load the modified text file</p> <p>If you have a large database and you don't mind removing offline messages, go directly to:<br /> 4. Using webadmin delete the contents of offline_msg table</p> Wed, 20 Feb 2013 16:30:39 +0000 mfoss comment 59454 at https://www.ejabberd.im