User:Jelly/Bugzilla

Possible Bugzilla migration

Script available for migration Flyspray DB to Bugzilla, which we could use to port the current bugs.

Setup

pacman -S bugzilla perl-dbd-mysql
pacman -S apache

# optdep
pacman -S perl-cgi

# required dep
pacman -S perl-json-xs perl-file-slurp

Enable mod cgi in /etc/httpd/conf/httpd.conf

LoadModule cgi_module modules/mod_cgi.so

Add /etc/httpd/conf/extra/bugzilla.conf And include it in httpd.conf

<Directory /srv/http/bugzilla>
  AddHandler cgi-script .cgi
  Options +ExecCGI
  DirectoryIndex index.cgi
  AllowOverride All
</Directory>

cd /srv/http/bugzilla/

./checksetup.pl (generates) localconfig

configure:

db_user and db_pass

$webservergroup = 'http'

mysql create database bugs

Re-run checksetup.pl to create the database.

Now enter the username / password

Conversion from flyspray DB

• configure the flypsray attachment path $FS_ATTACH which holds the flyspray attachments these are inserted into the database.
• create a product archlinux (administration => products). Create a default orphan component, the assignee should be the bugwranglers...

• mysql -u root -p bugs

MariaDB [bugs]> select * from components;

+----+--------+------------+--------------+------------------+-----------------+----------+
| id | name   | product_id | initialowner | initialqacontact | description     | isactive |
+----+--------+------------+--------------+------------------+-----------------+----------+
|  3 | orphan |          2 |            1 |             NULL | Orphan packages |        1 |
+----+--------+------------+--------------+------------------+-----------------+----------+

MariaDB [bugs]> select * from products;

+----+-----------+-------------------+---------------------+----------+------------------+-----
---------------+
| id | name      | classification_id | description         | isactive | defaultmilestone | 
allows_unconfirmed |
+----+-----------+-------------------+---------------------+----------+------------------+-----
---------------+
|  2 | archlinux |                 1 | Arch Linux packages |        1 | ---              |                  
1 |
+----+-----------+-------------------+---------------------+----------+------------------+-----
---------------+

Edit copy_bugs

TODO

• Decide on what to migrate
• Migration script
• Migrate users
• Figure out products (and scriptable creation)
• Figure out how to sync/create component <-> maintainer relations
• Figure out how to make flyspray read only (wget -m and sed/script to get the correct attachment from disk)
• Ansible role
• Actual migration
• Get /rest working
• Package optional deps for rest api
• memcached