Import ejabberd1 dump file?

Christian4 · July 15, 2008, 10:39am

Hey all!

I got a rather large ejabberd1 installation going, but for reasons of easy-of-configuration and hassle-free-ness I am going to migrate to openfire. I also have a rather large dumpfile (made with ejabberdctl dump) available. Now I “only” need to convert this file into openfire format. The problem “could” be that I also have russian, chinese and the like users, so there WILL be special characters in there (along the lines of ö,ü,ä…) as well as tons of avatars for the users.

How would I go about converting those?

Thank you all for your kind help.

-Chris.

Daniel_Henninger · July 15, 2008, 1:45pm

Howdy, as you pinged me about in PM, I wrote an ejabber to jive messenger conversion script (yes it’s that old). You are likely to have to do some tweaks to it because things may have changed since then. You definitely will need to change ). I’ve attached the script, written in perl. You’ll also need the import/export plugin for Openfire to be installed. I apparently had updated it for Wildfire at some point, but never Openfire. It should definitely get you started in the right direction if nothing else. It may even work flawlessly. hehehe There’s some instructions at the top of the script. =) Good luck! If you make tweaks to it and get it working, may I suggest reposting your updated script here so others can make use of it?

Christian4 · July 15, 2008, 3:27pm

Hey there!

Thanks for your quick reply. Unfortunately that script threw a lot of errors, and the resulting file was rejected by the server with “The import file does not match the user schema.”. I know too little of perl to even try and adjust it, so without further guide and help that wouldn’t help me too much, I’m afraid.

-Christian.

Thomas_Klein-Hitpass · July 17, 2008, 1:46pm

I have the exactly same problem when migrating from ejabberd to openfire.

Could anyone please update this script?

Its essential for me, because I really would like to migrate to openfire with my ~300 users.

Thanks a lot in advance,

Thomas

Christian4 · September 19, 2008, 2:45pm

Jebus.

Is there really no solution out there to handle imports? I mean you (the developers) can’t just hope on new Jabbernodes to pop up, you also have to supply migration solutions to (old) Jabbernodes like myself. I can’t just drop a few k of active users and make them re-register. And I am unable to code myself an import script as it is not my language.

In other words: Access to this Jabberserver software is denied for me?

-Christian.

Daniel_Henninger · September 19, 2008, 2:51pm

Search the forums I had posted a migration script from ejabberd1 to openfire a loooong time ago.

I don’t really know where it is anymore. It doesn’t require that you know java though. What it boils down to is … use the ejabberdctl dump command to get a copy of it’s db. Then you can use the “user import/export plugin” for openfire to import the data — not directly though. In whatever language you prefer, write something to convert the simple text of the ejabberd dump script to the format expected by the user import export script (described in the readme I believe). That’s what my script that I posted a while ago does. Anyway, the script is somewhere in this forum. Should be called something like ejdtojive.pl (was written in perl) Has instructions at the top. Now— keep in mind it was written for Jive Messenger, not Openfire. I later adjusted it for Wildfire. It might still work with Openfire. It was a simple matter of changing the root xml tag … like to or something like that.

Daniel_Henninger · September 19, 2008, 2:51pm

Oh, there we go, the script is right in this thread.

No, we don’t provide a fully supported or anything conversion from ejabberd to openfire. You will have to work on the script yourself or write something similar in another language that does the trick.

Christian4 · September 19, 2008, 3:02pm

After I dumped a file and ran that script, I get tons (talking MBs worth of text) like this:

String found where operator expected at (eval 13451) line 5584, near ""<<""Am+VZgpCxbiASQa19X0TVtKeWy1qA217Y3Rt57W4hjEkIbeqqjqzYYKrI5DFjzxzgcsxt7HULm8""
     (Missing operator before "Am+VZgpCxbiASQa19X0TVtKeWy1qA217Y3Rt57W4hjEkIbeqqjqzYYKrI5DFjzxzgcsxt7HULm8"?)
String found where operator expected at (eval 13451) line 5585, near ""<<""\n""
     (Missing operator before "\n"?)
String found where operator expected at (eval 13451) line 5586, near ""<<""gjRmdEyDDM7QKI41IjbeZGiIRflXKD""
     (Missing operator before "gjRmdEyDDM7QKI41IjbeZGiIRflXKD"?)
String found where operator expected at (eval 13451) line 5588, near ""<<""DdySO2VWDnTrUYyVSNCCn7OPxK6hOT5rWk7Wcd3+Byzw1""
     (Missing operator before "DdySO2VWDnTrUYyVSNCCn7OPxK6hOT5rWk7Wcd3+Byzw1"?)
String found where operator expected at (eval 13451) line 5589, near ""<<""\n""
     (Missing operator before "\n"?)
String found where operator expected at (eval 13451) line 5591, near ""<<""SFGpCa5vebcKdP3ZNTvTlGWvNzxenSKW66x6zaS22txfblkieC6j27IdrARsGRSVVvNQszfvGD4""
     (Missing operator before "SFGpCa5vebcKdP3ZNTvTlGWvNzxenSKW66x6zaS22txfblkieC6j27IdrARsGRSVVvNQszfvGD4"?)
String found where operator expected at (eval 13451) line 5592, near ""<<""\n""
     (Missing operator before "\n"?)
String found where operator expected at (eval 13451) line 5594, near ""<<""y2fQ/QfizVNL1bwdoUmxlvdNsY9NSVht8xYJJJGeRo3VpJNsyR4kEq/LzkgV41LYz64lxNcXcTz""
     (Missing operator before "y2fQ/QfizVNL1bwdoUmxlvdNsY9NSVht8xYJJJGeRo3VpJNsyR4kEq/LzkgV41LYz64lxNcXcTz"?)
String found where operator expected at (eval 13451) line 5595, near ""<<""\n""
     (Missing operator before "\n"?)
String found where operator expected at (eval 13451) line 5597, near ""<<""+WZEGHGQqoCUPDhiWLBWICrxknlo57fWLbS2s5T86LCFZlPlyBm2ZjQMxbAUcqzZPOWxk89OVOM""
     (Missing operator before "+WZEGHGQqoCUPDhiWLBWICrxknlo57fWLbS2s5T86LCFZlPlyBm2ZjQMxbAUcqzZPOWxk89OVOM"?)
String found where operator expected at (eval 13451) line 5598, near ""<<""\n""
     (Missing operator before "\n"?)
String found where operator expected at (eval 13451) line 5600, near ""<<""q6lCo4VozipuKXJyzjJTjbe1rN+9bX1KxFGpiqWG5KlOnPD1WnTi7JwnBRjN8rcmvd1tbXpds4j""
     (Missing operator before "q6lCo4VozipuKXJyzjJTjbe1rN+9bX1KxFGpiqWG5KlOnPD1WnTi7JwnBRjN8rcmvd1tbXpds4j"?)
String found where operator expected at (eval 13451) line 5601, near ""<<""\n""
     (Missing operator before "\n"?)
String found where operator expected at (eval 13451) line 5603, near ""<<""xDpl3qMclxZGN0QFJIVaGN9kaL5jmRwshkkWSTCA4kVAMHYTXBppkj+e0drcv5G8uvlBguE3YZF""
     (Missing operator before "xDpl3qMclxZGN0QFJIVaGN9kaL5jmRwshkkWSTCA4kVAMHYTXBppkj+e0drcv5G8uvlBguE3YZF"?)
String found where operator expected at (eval 13451) line 5604, near ""<<""\n""
     (Missing operator before "\n"?)
String found where operator expected at (eval 13451) line 5606, near ""<<""JOSGB3qzAY5APy16Tois1+2m3YlVJH3S7nRDCJdzFldyySPuJIj3chtoxlc+5+Hfhc+ozzxb7E2""
     (Missing operator before "JOSGB3qzAY5APy16Tois1+2m3YlVJH3S7nRDCJdzFldyySPuJIj3chtoxlc+5+Hfhc+ozzxb7E2"?)
String found where operator expected at (eval 13451) line 5607, near ""<<""\n""
     (Missing operator before "\n"?)
String found where operator expected at (eval 13451) line 5609, near ""<<""8UVxJaXTuirIBA7qXSTY8TsijaHISQk7c7WFbUKkq/JJL91OXs4yt+8u21ZtSd+Zp27fec3sXD6""
     (Missing operator before "8UVxJaXTuirIBA7qXSTY8TsijaHISQk7c7WFbUKkq/JJL91OXs4yt+8u21ZtSd+Zp27fec3sXD6"?)
String found where operator expected at (eval 13451) line 5610, near ""<<""\n""
     (Missing operator before "\n"?)
String found where operator expected at (eval 13451) line 5612, near ""<<""xGc5wXtIvmlFQpypp/Bd2nJyntH+Xy0PjlEkRktpGkjlVkMDrEjZV2ZXAmVjMGDfKY8cgtyuDu6""
     (Missing operator before "xGc5wXtIvmlFQpypp/Bd2nJyntH+Xy0PjlEkRktpGkjlVkMDrEjZV2ZXAmVjMGDfKY8cgtyuDu6"?)
String found where operator expected at (eval 13451) line 5613, near ""<<""\n""
     (Missing operator before "\n"?)
String found where operator expected at (eval 13451) line 5615, near ""<<""S+8NT6ZbreN/y9W8RSQmSRJIgSG53qI5QMrn/WIduRhQp6PXvChs9Yu4RAzKtwQkiqcAhlLvCyM""
     (Missing operator before "S+8NT6ZbreN/y9W8RSQmSRJIgSG53qI5QMrn/WIduRhQp6PXvChs9Yu4RAzKtwQkiqcAhlLvCyM"?)
String found where operator expected at (eval 13451) line 5616, near ""<<""\n""
     (Missing operator before "\n"?)
String found where operator expected at (eval 13451) line 5618, near ""<<""nJYhdsp5O/j+I9DqemS/2ZbQyM7rtCKrDbsVcuRH94MAo3FQeSccnpMa1KVStQacJqLtC3Kns1J""
     (Missing operator before "nJYhdsp5O/j+I9DqemS/2ZbQyM7rtCKrDbsVcuRH94MAo3FQeSccnpMa1KVStQacJqLtC3Kns1J"?)
String found where operator expected at (eval 13451) line 5619, near ""<<""\n""
     (Missing operator before "\n"?)
String found where operator expected at (eval 13451) line 5621, near ""<<""9W3da39ew6lGvONOp7OnTpuvGGzu4+XJa0bR6817/N+bfbILewSJ2JZHWFwzIzsRHuiL4+dSUUM""
     (Missing operator before "9W3da39ew6lGvONOp7OnTpuvGGzu4+XJa0bR6817/N+bfbILewSJ2JZHWFwzIzsRHuiL4+dSUUM"?)
String found where operator expected at (eval 13451) line 5622, near ""<<""\n""
     (Missing operator before "\n"?)
String found where operator expected at (eval 13451) line 5624, near ""<<""W43D8m5K982WddqgptKxFQCIyZMlVG4uE5JBLsSXPbit+6sZo7sWrCIIJV2xzhTNePmONGXa6sF""
     (Missing operator before "W43D8m5K982WddqgptKxFQCIyZMlVG4uE5JBLsSXPbit+6sZo7sWrCIIJV2xzhTNePmONGXa6sF"?)
String found where operator expected at (eval 13451) line 5625, near ""<<""\n""
     (Missing operator before "\n"?)
String found where operator expected at (eval 13451) line 5627, near ""<<""C8Y8r5QvRRhqp6ppk9jMYZxMkrq/Dl4gjK6gxqFi2CbEqkJuU7F9hupQ51Tk5SjNR5Vzax0aaTf""
     (Missing operator before "C8Y8r5QvRRhqp6ppk9jMYZxMkrq/Dl4gjK6gxqFi2CbEqkJuU7F9hupQ51Tk5SjNR5Vzax0aaTf"?)
String found where operator expected at (eval 13451) line 5628, near ""<<""\n""
     (Missing operator before "\n"?)
String found where operator expected at (eval 13451) line 5630, near ""<<""Sa193S+xm6TppOHN7N1pOMYzvKL3vqndtW0tps1cw98ZkMXlF3KK3mE+QqO7xq28FSzBRuJOcjj""
     (Missing operator before "Sa193S+xm6TppOHN7N1pOMYzvKL3vqndtW0tps1cw98ZkMXlF3KK3mE+QqO7xq28FSzBRuJOcjj"?)
String found where operator expected at (eval 13451) line 5631, near ""<<""\n""
     (Missing operator before "\n"?)
String found where operator expected at (eval 13451) line 5633, near ""<<""0NV1gdkkkAdVVzgqNyZDkcY5O/B55xx6VpTzfvwY1VmhEIdyJA7LAV3DJUqyEEBkYZcH0yarQeR""
     (Missing operator before "0NV1gdkkkAdVVzgqNyZDkcY5O/B55xx6VpTzfvwY1VmhEIdyJA7LAV3DJUqyEEBkYZcH0yarQeR"?)
String found where operator expected at (eval 13451) line 5634, near ""<<""\n""
     (Missing operator before "\n"?)
String found where operator expected at (eval 13451) line 5636, near ""<<""NLKzW7JKrOqlVCvMAd2MnBGQV5w+Mjhq0jzS5LqaS1k+Z8ye9mmnpK2j6X9SqkbexrUm3Vcb8so""
     (Missing operator before "NLKzW7JKrOqlVCvMAd2MnBGQV5w+Mjhq0jzS5LqaS1k+Z8ye9mmnpK2j6X9SqkbexrUm3Vcb8so"?)
String found where operator expected at (eval 13451) line 5637, near ""<<""\n""
     (Missing operator before "\n"?)
String found where operator expected at (eval 13451) line 5639, near ""<<""3k22o88buzad7tJ7PSybeeu4MSpG8MQyqrs6hQv3lYFV8zlQ2Rt5PHGZp184Q7VVUcDeVkVFWRC""
     (Missing operator before "3k22o88buzad7tJ7PSybeeu4MSpG8MQyqrs6hQv3lYFV8zlQ2Rt5PHGZp184Q7VVUcDeVkVFWRC"?)
String found where operator expected at (eval 13451) line 5640, near ""<<""\n""
     (Missing operator before "\n"?)
String found where operator expected at (eval 13451) line 5642, near ""<<""w3MnzKVCjOchsk/i6X5XSWIbWdStwsZ3YlBK5LDGVVQgyV5Oe3As26oxRJgVjMcjK5EcwQkMpJy""
     (Missing operator before "w3MnzKVCjOchsk/i6X5XSWIbWdStwsZ3YlBK5LDGVVQgyV5Oe3As26oxRJgVjMcjK5EcwQkMpJy"?)
String found where operator expected at (eval 13451) line 5643, near ""<<""\n""
     (Missing operator before "\n"?)
String found where operator expected at (eval 13451) line 5644, near ""<<""UCudrMEwXA9chq0k7Ju75tevvLXZJqzXbfqvMz""
     (Missing operator before "UCudrMEwXA9chq0k7Ju75tevvLXZJqzXbfqvMz"?)
String found where operator expected at (eval 13451) line 5645, near ""<<""i3JOnUco+9L3nFRkpWemnxJNXbcrpa9zLZ5Uh""
     (Missing operator before "i3JOnUco+9L3nFRkpWemnxJNXbcrpa9zLZ5Uh"?)
String found where operator expected at (eval 13451) line 5646, near ""<<""\n""
     (Missing operator before "\n"?)
String found where operator expected at (eval 13451) line 5648, near ""<<""dFQNvP7/HJAWTETZG5QG6/Ky4zgg8VGsip5rOoZirRxI7vwxbORjCgjHTHPzetXxFGzERjezbm2""
     (Missing operator before "dFQNvP7/HJAWTETZG5QG6/Ky4zgg8VGsip5rOoZirRxI7vwxbORjCgjHTHPzetXxFGzERjezbm2"?)
String found where operator expected at (eval 13451) line 5649, near ""<<""\n""
     (Missing operator before "\n"?)
String found where operator expected at (eval 13451) line 5651, near ""<<""qOnz7sgnGM4bIxwu3HYVWudjgNIXQxMMDJ53P8qp2+XJJXC5JPJqotNTSU0+dXt12d7a6vor6fi""
     (Missing operator before "qOnz7sgnGM4bIxwu3HYVWudjgNIXQxMMDJ53P8qp2+XJJXC5JPJqotNTSU0+dXt12d7a6vor6fi"?)
String found where operator expected at (eval 13451) line 5652, near ""<<""\n""
     (Missing operator before "\n"?)
String found where operator expected at (eval 13451) line 5654, near ""<<""yLnT5oXcdm0nzSck0rwvdWlHZa/erlXOx43VkZ338HdmPAPAwCpJJ2gfwj8Kb58iptGz775ZVG5""
     (Missing operator before "yLnT5oXcdm0nzSck0rwvdWlHZa/erlXOx43VkZ338HdmPAPAwCpJJ2gfwj8Kb58iptGz775ZVG5"?)
String found where operator expected at (eval 13451) line 5655, near ""<<""\n""
     (Missing operator before "\n"?)
String found where operator expected at (eval 13451) line 5657, near ""<<""lf76lsZKnBwO3bGTSJAyuHB3LuZFGRuVhk5I3dSozgZH1qyvlstx/qkTCL8yncGHDMud2GO0c/K""
     (Missing operator before "lf76lsZKnBwO3bGTSJAyuHB3LuZFGRuVhk5I3dSozgZH1qyvlstx/qkTCL8yncGHDMud2GO0c/K"?)
String found where operator expected at (eval 13451) line 5658, near ""<<""\n""
     (Missing operator before "\n"?)
String found where operator expected at (eval 13451) line 5660, near ""<<""Bz7kXy3snFvW7krrks+qW7XRJa6q4vYu0pfbk2oxcrN/wB5aNuO9kly3RBtC7ZIvMSNUMjAhX2M""
     (Missing operator before "Bz7kXy3snFvW7krrks+qW7XRJa6q4vYu0pfbk2oxcrN/wB5aNuO9kly3RBtC7ZIvMSNUMjAhX2M"?)
String found where operator expected at (eval 13451) line 5661, near ""<<""\n""
     (Missing operator before "\n"?)
String found where operator expected at (eval 13451) line 5663, near ""<<""H24bHRGLcbt2OevUkrKEQKuJIi7t0IDBwC0ZyQQMZ3D73+0KAstu8sCkHblHLLgsCVO1UDHILEf""
     (Missing operator before "H24bHRGLcbt2OevUkrKEQKuJIi7t0IDBwC0ZyQQMZ3D73+0KAstu8sCkHblHLLgsCVO1UDHILEf"?)
String found where operator expected at (eval 13451) line 5664, near ""<<""\n""
     (Missing operator before "\n"?)
String found where operator expected at (eval 13451) line 5666, near ""<<""xZO3oOKRSUbO0MVZH2Sja8q8MWGORGGXO3cMhl9c00r3Tenwp2d27ddHvrrd28hSlBwlFwvJRjF""

Any help on this?

Daniel_Henninger · September 19, 2008, 3:06pm

Not really. Looks like the format may have changed a bit since I wrote that script. Someone will need to upgrade the script to account for whatever changes there might have been, or write a fresh script.

Christian4 · May 3, 2009, 5:01pm

For the archive: There is NO solution for this. Had to dump all data and start over. Cheers all around!

Juan · June 22, 2009, 3:41pm

Hi all,

I have recently migrated a small ejabberd server to OpenFire and I have used the attached script to acomplish this task.

May be it will helps someone else in this dirty task.

ejabberd 1.1.4 to openfire 3.6.4-1

This script must be executed in Linux command line (or Windows with Cygwin). It outputs XML to be imported with the import/export plugin from Openfire web based administration page.

Grettings.