<html><body>
<p>Or, how do I just wipe out the mnesia database and start over?<br>
<br>
Andrew Berkowitz<br>
aberkow@us.ibm.com<br>
NYCBoE: 718-935-5471<br>
cell: 917-613-3941<br>
<br>
<br>
<br>
<br>
<br>
<img width="16" height="16" src="cid:1__=08BBFED0DFE723AB8f9e8a93df938@us.ibm.com" border="0" alt="Inactive hide details for Andrew Berkowitz/New York/Contr/IBM@IBMUS">Andrew Berkowitz/New York/Contr/IBM@IBMUS<br>
<br>
<br>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr valign="top"><td style="background-image:url(cid:2__=08BBFED0DFE723AB8f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " width="40%">
<ul>
<ul>
<ul>
<ul><b><font size="2">Andrew Berkowitz/New York/Contr/IBM@IBMUS</font></b><font size="2"> </font><br>
<font size="2">Sent by: server-devel-bounces@lists.laptop.org</font>
<p><font size="2">05/08/2008 12:48 PM</font></ul>
</ul>
</ul>
</ul>
</td><td width="60%">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr valign="top"><td width="1%"><img width="58" height="1" src="cid:3__=08BBFED0DFE723AB8f9e8a93df938@us.ibm.com" border="0" alt=""><br>
<div align="right"><font size="2">To</font></div></td><td width="100%"><img width="1" height="1" src="cid:3__=08BBFED0DFE723AB8f9e8a93df938@us.ibm.com" border="0" alt=""><br>
<font size="2">wad@laptop.org, martin@laptop.org</font></td></tr>
<tr valign="top"><td width="1%"><img width="58" height="1" src="cid:3__=08BBFED0DFE723AB8f9e8a93df938@us.ibm.com" border="0" alt=""><br>
<div align="right"><font size="2">cc</font></div></td><td width="100%"><img width="1" height="1" src="cid:3__=08BBFED0DFE723AB8f9e8a93df938@us.ibm.com" border="0" alt=""><br>
<font size="2">server-devel@lists.laptop.org</font></td></tr>
<tr valign="top"><td width="1%"><img width="58" height="1" src="cid:3__=08BBFED0DFE723AB8f9e8a93df938@us.ibm.com" border="0" alt=""><br>
<div align="right"><font size="2">Subject</font></div></td><td width="100%"><img width="1" height="1" src="cid:3__=08BBFED0DFE723AB8f9e8a93df938@us.ibm.com" border="0" alt=""><br>
<font size="2">Re: [Server-devel] Possible Jabber Problem on Server</font></td></tr>
</table>
<table border="0" cellspacing="0" cellpadding="0">
<tr valign="top"><td width="58"><img width="1" height="1" src="cid:3__=08BBFED0DFE723AB8f9e8a93df938@us.ibm.com" border="0" alt=""></td><td width="336"><img width="1" height="1" src="cid:3__=08BBFED0DFE723AB8f9e8a93df938@us.ibm.com" border="0" alt=""></td></tr>
</table>
</td></tr>
</table>
<br>
<font size="4" face="Courier New">To resolve the problem, I am going to uninstall jabber and then reinstall.</font><font size="4"><br>
</font><font size="4" face="Courier New"><br>
When I tried to uninstall ejabberd, rpm complained that ejabberd is needed by xs-pkgs-0.3.0-1.noarch</font><font size="4"><br>
</font><font size="4" face="Courier New"><br>
I am not familiar with xs-pkgs. Should I assume that this is specific to the XS server?</font><font size="4"><br>
</font><font size="4" face="Courier New"><br>
Should I also uninstall xs-pkgs and then install it again? Or should I specify --nodeps?</font><font size="4"><br>
</font><font size="4" face="Courier New"><br>
If I set up jabber to use MySQL rather than the default flat files, will any XS-specific processes discontinue to work? Do any XS-specific process use the files directly? </font><font size="4"><br>
</font><font size="4" face="Courier New"><br>
Thank you.</font><font size="4"><br>
</font><font size="4" face="Courier New"><br>
Andrew Berkowitz<br>
DOE<br>
2 MetroTech Center, Suite 3900<br>
Brooklyn, NY 11201<br>
aberkowitz@schools.nyc.gov<br>
718-935-5471</font><font size="4"><br>
<br>
<br>
<br>
</font><font size="4" face="Courier New"><br>
-----Original Message-----<br>
From: John Watlington [</font><a href="mailto:wad@laptop.org"><u><font size="4" color="#0000FF" face="Courier New">mailto:wad@laptop.org</font></u></a><font size="4" face="Courier New">] <br>
Sent: Thursday, May 08, 2008 12:52 AM<br>
To: Martin Langhoff; Berkowitz Andrew (Project Connect)<br>
Cc: John Watlington; server-devel; Kim Quirk<br>
Subject: Re: Possible Jabber Problem on Server</font><font size="4"><br>
<br>
</font><font size="4" face="Courier New"><br>
On May 7, 2008, at 10:28 PM, Martin Langhoff wrote:</font><font size="4"><br>
</font><font size="4" face="Courier New"><br>
> On Thu, May 8, 2008 at 2:19 AM, Berkowitz Andrew (Project Connect)<br>
>> Greetings from New York.<br>
><br>
> "G'day mate" from New Zealand!<br>
><br>
>> Although the short hostname, schoolserver, has stayed the same, the <br>
>> domain has changed from 00b000.nycboe.org to 00b001.nycboe.org and <br>
>> back to 00b000.nycboe.org. When I changed the domain & address, I <br>
>> changed the<br>
><br>
> Hmmmm. That's unsupported at the moment. Wad might have more <br>
> experience changing the FQDN...</font><font size="4"><br>
</font><font size="4" face="Courier New"><br>
I've only recovered from that by nuking the ejabberd installation (rpm -e ejabberd; rm -r /var/lib/ejabberd/; yum install ejabberd)</font><font size="4"><br>
</font><font size="4" face="Courier New"><br>
>> Jabber servers are<br>
>> notoriously finicky and frequently return the nodedown message if a <br>
>> server's hostname changes.<br>
><br>
> Exactly, and we haven't yet done the legwork to make sure that this <br>
> works end-to-end.</font><font size="4"><br>
</font><font size="4" face="Courier New"><br>
We've done enough to know that changing the host/domain name is a big problem with the current presence server.</font><font size="4"><br>
</font><font size="4" face="Courier New"><br>
>> The normal resolution is to export the database, convert it and <br>
>> import it. I tried this conversion using the Erlang conversion <br>
>> utility.<br>
>><br>
>> I also reimported the original database. Some people report that just <br>
>> exporting and importing, without conversion, fixes the problem.<br>
>> This process<br>
>> also did not resolve the issue.</font><font size="4"><br>
</font><font size="4" face="Courier New"><br>
I found at least one recipe which claimed to fix this problem a while back, but didn't test it.</font><font size="4"><br>
</font><font size="4" face="Courier New"><br>
> Hm. What happens if you wipe out the mnesia database and start from <br>
> scratch.</font><font size="4"><br>
</font><font size="4" face="Courier New"><br>
Fixes the problem.</font><font size="4"><br>
</font><font size="4" face="Courier New"><br>
>> Also, I have another concern. The jabber database is kept in text <br>
>> files.<br>
>> This configuration is fine for small sites. But with many users, it <br>
>> is better to keep the database in MySQL for better performance and <br>
>> better reliability.<br>
><br>
> If I can get mnesia to use PostgreSQL as a backend, I'll do it.</font><font size="4"><br>
</font><font size="4" face="Courier New"><br>
There are configuration file option for ejabberd to use postgreSQL, etc.<br>
for the database. Perhaps some volunteers can play with these ?</font><font size="4"><br>
</font><font size="4" face="Courier New"><br>
>> Another question: You've reported a bug where If an XO is reimaged <br>
>> and then needs to re-register with the server, it cannot. In this <br>
>> case, is it okay to export the database as text, manually delete the <br>
>> entry, and then import the database.</font><font size="4"><br>
</font><font size="4" face="Courier New"><br>
> For a quick fix, you can delete the entries in the SQLite db in <br>
> /home/idmgr . We'll have a UI for this later.</font><font size="4"><br>
</font><font size="4" face="Courier New"><br>
Wrong database. If that bug is due to a database, it is the ejabberd database.</font><font size="4"><br>
</font><font size="4" face="Courier New"><br>
But if you are referring to #6919, it is harder to replicate than Giannis indicated<br>
at first. I do this all the time, when testing builds/servers, and <br>
hadn't seen it.<br>
It was easier to replicate for a while, when the presence server in the local area was misconfigured.</font><font size="4"><br>
</font><font size="4" face="Courier New"><br>
> All these ad-hoc DBs need to be under some control, and the UI will <br>
> probably be handled as an extension of Moodle's user mgmt facilities.</font><font size="4"><br>
</font><font size="4" face="Courier New"><br>
Darn right...</font><font size="4"><br>
</font><font size="4" face="Courier New"><br>
Cheers,<br>
wad</font><font size="4"><br>
<br>
<br>
<br>
</font><tt>_______________________________________________<br>
Server-devel mailing list<br>
Server-devel@lists.laptop.org<br>
</tt><tt><a href="http://lists.laptop.org/listinfo/server-devel">http://lists.laptop.org/listinfo/server-devel</a></tt><tt><br>
</tt><br>
</body></html>