MonaSearch bugs

Hi Hendrik, thanks for your question.

Unfortunately the Trac Launchpad plugin isn't capable of mirroring all the bugs, comments and patches from a Trac instance to Launchpad just yet.

However, we have an exporter script for Trac that will allow you to dump the entire Trac database into an XML export file which we can then import into Launchpad. The way things usually work is:

1) You provide the XML dump
2) We import the XML dump onto a demo instance of Launchpad so that you can check the import is sane
3) Once you're happy with the results of step 2 (we can repeat it if necessary) we import the bugs into the Launchpad production database.

Is this a suitable solution for you? If so, I'll prepare the script and send it to you within a couple of days so you can get cracking.

Sounds good. Please give me some more instructions, I’ll get to it soon.

Excellent! I'll prepare the script for you (it's still got some code in it specific to another project; I've not yet had chance to make it suitable for general use). Once I've done that I'll forward it to you and we can take it from there. I'll send it to you by Monday at the latest.

Hi there,

Is something going to happen here? I haven’t heard anything for a while now and it seems like the server that is hosting the project is about to be shut down soon, so it is getting urgent!

I am following the instructions I found in another answer: https://answers.edge.launchpad.net/malone/+question/73758, but:

# ./migrate.py /home/server/svn/trac/db/ /home/server/svn/trac/attachments/ monasearch-trac
WARNING:root:Methods redefined (Person) in ['set'] ... At your own risks
Traceback (most recent call last):
  File "./migrate.py", line 495, in <module>
    sys.exit(main(sys.argv[1:]))
  File "./migrate.py", line 466, in main
    db = TracDb(trac_db, attachments_dir)
  File "./migrate.py", line 147, in __init__
    database=filename)
  File "/root/trac-launchpad-migrator/db_backend.py", line 99, in __init__
    self._init_backend(backend_name)
  File "/root/trac-launchpad-migrator/db_backend.py", line 141, in _init_backend
    self.connect()
  File "/root/trac-launchpad-migrator/db_backend.py", line 154, in connect
    self._db = self._db_module.connect(**self._params)
sqlite3.OperationalError: unable to open database file

Or did I use the wrong arguments? With the db file as argument, I get this:

 # ./migrate.py /home/server/svn/trac/db/trac.db /home/server/svn/trac/attachments/ monasearch-trac
WARNING:root:Methods redefined (Person) in ['set'] ... At your own risks
[ticket 3] pb with owner Chris
Traceback (most recent call last):
  File "./migrate.py", line 495, in <module>
    sys.exit(main(sys.argv[1:]))
  File "./migrate.py", line 479, in main
    for attachment in db.get_attachments(ticket):
  File "./migrate.py", line 233, in get_attachments
    data = open(attachment_filename).read()
IOError: [Errno 2] No such file or directory: '/home/server/svn/trac/attachments/9/mylyn-context.zip'

In both cases, no output file.

Seems like the correct command was

./migrate.py /home/server/svn/trac/db/trac.db /home/server/svn/trac/attachments/ticket/ monasearch-trac

So you need the /ticket/ directory after attachments, and the db file explicitly.

Hi Hendrick,

I sent you an email a couple of days ago requesting that you re-send me your Trac export. I've yet to receive a reply, so I'm just checking that my email actually reached you :).

Additionally, it would be a good idea for you to upgrade your copy of the trac-launchpad-migrator to version 0.1.2 (or the tip of trunk). Version 0.1.2 includes certain bug fixes which may make the migration smoother.

Regards,

Graham

I did send it to you *and* I replied to your mail, sending it again. Strange. Can I maybe upload it here?

> I did send it to you *and* I replied to your mail, sending it again. Strange. Can I maybe upload it here?

That's very strange. I've seen neither the original nor your reply, and can find neither in my spam trap. Hmm.

The best thing for you to do, I think, would be to upload the xml file to somewhere on the web (there's nowhere in LP that's appropriate for it really) and then paste a URL; I'll grab it from there.

Right, it’s at http://tcl.sfs.uni-tuebingen.de/~hendrik/monasearch-trac.xml. Note that I do get your mails. I used the tip of the migrator.

On Fri, Jun 26, 2009 at 04:37:08PM -0000, Hendrik Maryns wrote:
> Question #69864 on Launchpad Bugs changed:
> https://answers.edge.launchpad.net/malone/+question/69864
>
> Status: Answered => Open
>
> Hendrik Maryns is still having a problem:
> Right, it’s at http://tcl.sfs.uni-tuebingen.de/~hendrik/monasearch-
> trac.xml. Note that I do get your mails. I used the tip of the
> migrator.

Fantastic! This looks okay so far; I'll do a test import locally on
Monday and we'll take it from there.

--
Graham Binns | PGP Key: EC66FA7D

Hi Hendrik,

I've done the import locally and it ran fine. I'll try to get it up on a
demo server for you today so that you can check it over.

Regards,

Graham

Hi Hendrik,

I sent you an email a couple of days ago detailing how to check out the demo import that I did of the MonaSearch bugs. Have you had a chance to take a look at it yet? If not, or if you haven't received my mail, please let me know.

Cheers,

Graham

Hi Hendrik,

I've disabled the EC2 instance for now since it was just consuming money :). Please ping me on IRC when you have time to review the demo import and I'll get it running again for you.

Cheers,

Graham

Hi Hendrik,

Sorry that this question appears to have got lost in the wash a bit. Do you still want to go ahead with the import?

Marking needs info for organisation purposes.

It seems the 2009-07-01 email didn’t reach me. Sorry for the money it cost you :-s

I am no longer working on this project, but I asked my successor to answer.

Hi Hendrik,

Did you manage to talk to your successor at the project?

Hi Graham

Thanks for your efforts. I mailed him, and I will repeat that now, but that’s all I can do now. I am no longer involved and have other things on my mind now (managing a class of 14-year olds, getting them to do maths :-))

Cheers

I am forcing this question to be expired because no one involved in the mona project want to pursue a bug import.