Php – Mantis – Integrate Wiki

A colleague ended up figuring this one out, and the process ended up being generally-applicable to other web content we wanted to pull into Confluence as well. In broad strokes, the process involved:

1. Using wget to suck all of the content out of FogBugz (configured so that images and attachments were downloaded properly, and links to them and to other pages were properly relativized).
2. Using a simple XSLT transform to strip away the "template" content (e.g. logos, control/navigation links, etc) that surrounded the body of each page.
3. (optionally) Using a perl module to convert the resulting HTML fragments into Confluence's markup format
4. Using the Confluence command line interface to push up all of the page, image, and attachment data.

Note that I said "optionally" in #3 above. That is because the Confluence CLI has two relevant options: it can be used to create new pages directly, in which case it's expecting Confluence markup already, or it can be used to create new pages using HTML, which it converts to Confluence markup itself. In some cases, the Confluence CLI converted the HTML just fine; for other data sources, we needed to use the perl module.

1. Create the user normally via http://path/to/mantis/manage_user_create_page.php (using an existing admin account)

2. Open a command prompt and log into MySQL (mysql -u root -p)

3. use bugtracker; (where bugtracker is the name of the mantis bd; default = bugtracker)

4. update mantis_user_table set password=md5('password') where username='username';

The whole cmd exchange looks like this:

C:\Program Files\MySQL\MySQL Server 4.1\bin>mysql -u root -p
Enter password: *********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7 to server version: 4.1.21-community-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use bugtracker;
Database changed

mysql> update mantis_user_table set password=md5('password') where username='username';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0