Import ejabberd database

Openfire Openfire Support
1

Hello,

I have some problems to upgrade my ejabberd setup (version 1.1.1 to 1.1.2). This is not really a problem for now but it will be when a security hole will be found one day… Seem to be no upgrade procedure and messages in the forums didn’'t help.

So, I think to migrate to Wildfire server. My auth is done with the mail server, but I need to import the rest of the database of ejabberd into wildfire (the most important is the contact list).

Can I import my ejabberd database into wildfire ? If yes, how ?

Thanks.

Message was edited by: Ohmer

2

Hi Ohmer,

Take a look at this thread which discusses how to use the User Import/Export plugin along with a script to migrate from ejabberd to Wildfire.

Hope that helps,

Ryan

3

Thanks, I will look at this

4

Hello,

I have two problems.

The first one, is that the plugin doesn’‘t want import anything because I’'m using LDAP auth. I disabled LDAP while I import in hope that Wildfire keep the data in memory. Will it work ? (I cannot test because of problem #2).

The second one is when I try to import the XML file created by the perl script, the plugin say: “The import file does not match the user schema.”. What’'s the problem ?

Thanks !

Message was edited by: Ohmer

5

Hi Ohmer,

The first one, is that the plugin doesn’‘t want import anything because I’'m using LDAP auth. I disabled LDAP while I import in hope that Wildfire keep the data in memory. Will it work ? (I cannot test because of problem #2).

Wildfire won’‘t store the data in memory rather it will save it to whichever database you configured it to use when you started. I’‘m not sure if it will work but it’'s worth trying.

The second one is when I try to import the XML file created by the perl script, the plugin say: “The import file does not match the user schema.”. What’'s the problem ?

That’'s hard to know without seeing the import file. Take a look at the plugin readme, in it there is a small sample of how the import file should look, compare it to your file and see if anything looks out of the ordinary.

Hope that helps,

Ryan

6

What version of the script do you have? One of the versions of the scripts was for Jive Messenger, which is only really different in that one of the wrapper tags is named Wildfire instead of JiveMessenger or something like that.

The latest version of the script is at:

http://www.vorpalcloud.org/~daniel/ejdtojive.txt

7

I think it’'s ejabberdtojive. I will verify next tuesday (long week-end yeah ).

8

Hello,

Yes I used the Wildfire script.

I checked the file and the schema seem to be OK.

Also, I see that my XML file doesn’‘t contain all my users. I only have 2 users in the file, but the ejabberd installation have ~10. Maybe it can help, I only have my 2 initials users who have password in the ejabberd dump file. Others users don’'t have passwords because I used an external authentication.

9

One problem solved. I can now import my file. The name field was set to “<<70”. I removed the “<<” and it works.

10

Ohmer wrote:

One problem solved. I can now import my file. The name field was set to “<<70”. I removed the “<<” and it works.

Good to hear!

11

But still cannot import users without passwords. Any ideas?

Perl is not my friend, so I can’'t debug the script :confused:

Message was edited by: Ohmer

12

Aleluya… it works !

I modified my dump file and I added fakes passwords for all of my users. Then, I enabled again the LDAP support and I verified that my roster was OK and it is. I also upgraded to 3.1.0 without any problems.

So, I will be able to migrate our jabber server to Wildfire soon.

Thanks for your help !