Upgrade / Migrate from Bugzilla 2.22 (on Windows 2000) to 5.0.3 (on CentOS 7.4.1708)

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Upgrade / Migrate from Bugzilla 2.22 (on Windows 2000) to 5.0.3 (on CentOS 7.4.1708)

Anil Talpade
Dear all,

We are using Bugzilla 2.22 on Windows 2000 Server:

Operating System: Windows 2000 Server with SP4
MySQL: MySQL Server 5.0.22
Bugzilla: 2.22

We want to migrate to CentOS 7X with the latest versions of Bugzilla and
MySQL. Our new setup is:

Operating System: 64-bit CentOS 7.4.1708
MySQL: MySQL Community Server 5.7.21
Bugzilla: 5.0.3

As mentioned in the Release Documentation, the on the fly update /
migration fails. We have taken the following approach.

1. Installed the new setup as mentioned above. Able to login to the
bugzilla as Administrator and able to create an user.
2. Backed up the existing database of bugzilla 2.22 (old bugzilla) using
mysqldump.
3. Restored the database on the new bugzilla server. Also copied the
/data directory of the old bugzilla server to the new bugzilla server
(as mentioned in the Release document).
4. Made changes to the localconfig file.
5. Ran ./checksetup.pl. It gave a few errors and now the (NEW) bugzilla
page is not accessible. It shows lots of errors related to MySQL.

I am very much new to databases and need help. Is this a correct
approach for upgrade / migration? Or we have to take the following steps:

a. Install Bugzilla 2.22 and MySQL 5.0.22 on CentOS and configure it.
b. Upgrade this Bugzilla to 5.0.3 using the documentation (from 2.22 to
5.0.3 on CentOS)
c. Export the MySQL database and then import to the CentOS machine
d. Reconfigure Bugzilla on CentOS for the new database (./checksetup.pl
and other stuff)

We would be very much grateful to have some valuable inputs / help from
your side.

Thank you.

Regards,
Anil Talpade
TERA Informatics Pvt. Ltd.
Mumbai
_______________________________________________
support-bugzilla mailing list
[hidden email]
https://lists.mozilla.org/listinfo/support-bugzilla
PLEASE put [hidden email] in the To: field when you reply.
Reply | Threaded
Open this post in threaded view
|

Re: Upgrade / Migrate from Bugzilla 2.22 (on Windows 2000) to 5.0.3 (on CentOS 7.4.1708)

Emmanuel Seyman-3
* Anil Talpade [18/01/2018 09:54] :
>
> 5. Ran ./checksetup.pl. It gave a few errors and now the (NEW) bugzilla page
> is not accessible. It shows lots of errors related to MySQL.

We'll need to know what thoses errors are to be able to help you.
Are these UTF-8 related ?

FWIW, your bugzilla database show now look like this:
http://schema.seyman.fr/bugzilla/schema?action=single&version=5.0.3&view=View+schema

> I am very much new to databases and need help. Is this a correct approach
> for upgrade / migration? Or we have to take the following steps:

Going from 2.22 to 5.0.3 skips A LOT of versions. You might want to try
upgrading from 2.22 to 3.6.13 (the last 3.x release) then upgrade to
4.4.12 (the last 4.x release) and finally upgrade to 5.0.3.

Emmanuel
_______________________________________________
support-bugzilla mailing list
[hidden email]
https://lists.mozilla.org/listinfo/support-bugzilla
PLEASE put [hidden email] in the To: field when you reply.
Reply | Threaded
Open this post in threaded view
|

Re: Upgrade / Migrate from Bugzilla 2.22 (on Windows 2000) to 5.0.3 (on CentOS 7.4.1708)

Gervase Markham
In reply to this post by Anil Talpade
On 18/01/18 09:01, Emmanuel Seyman wrote:
> Going from 2.22 to 5.0.3 skips A LOT of versions. You might want to try
> upgrading from 2.22 to 3.6.13 (the last 3.x release) then upgrade to
> 4.4.12 (the last 4.x release) and finally upgrade to 5.0.3.

Upgrading all the way in one go is supported; don't try this until all
else has failed.

Gerv
_______________________________________________
support-bugzilla mailing list
[hidden email]
https://lists.mozilla.org/listinfo/support-bugzilla
PLEASE put [hidden email] in the To: field when you reply.
Reply | Threaded
Open this post in threaded view
|

Re: Upgrade / Migrate from Bugzilla 2.22 (on Windows 2000) to 5.0.3 (on CentOS 7.4.1708)

Anil Talpade - TERA
In reply to this post by Anil Talpade
On Thursday, January 18, 2018 at 9:55:54 AM UTC+5:30, Anil Talpade wrote:

> Dear all,
>
> We are using Bugzilla 2.22 on Windows 2000 Server:
>
> Operating System: Windows 2000 Server with SP4
> MySQL: MySQL Server 5.0.22
> Bugzilla: 2.22
>
> We want to migrate to CentOS 7X with the latest versions of Bugzilla and
> MySQL. Our new setup is:
>
> Operating System: 64-bit CentOS 7.4.1708
> MySQL: MySQL Community Server 5.7.21
> Bugzilla: 5.0.3
>
> As mentioned in the Release Documentation, the on the fly update /
> migration fails. We have taken the following approach.
>
> 1. Installed the new setup as mentioned above. Able to login to the
> bugzilla as Administrator and able to create an user.
> 2. Backed up the existing database of bugzilla 2.22 (old bugzilla) using
> mysqldump.
> 3. Restored the database on the new bugzilla server. Also copied the
> /data directory of the old bugzilla server to the new bugzilla server
> (as mentioned in the Release document).
> 4. Made changes to the localconfig file.
> 5. Ran ./checksetup.pl. It gave a few errors and now the (NEW) bugzilla
> page is not accessible. It shows lots of errors related to MySQL.
>
> I am very much new to databases and need help. Is this a correct
> approach for upgrade / migration? Or we have to take the following steps:
>
> a. Install Bugzilla 2.22 and MySQL 5.0.22 on CentOS and configure it.
> b. Upgrade this Bugzilla to 5.0.3 using the documentation (from 2.22 to
> 5.0.3 on CentOS)
> c. Export the MySQL database and then import to the CentOS machine
> d. Reconfigure Bugzilla on CentOS for the new database (./checksetup.pl
> and other stuff)
>
> We would be very much grateful to have some valuable inputs / help from
> your side.
>
> Thank you.
>
> Regards,
> Anil Talpade
> TERA Informatics Pvt. Ltd.
> Mumbai


Hello all,

Thank you for your post. I will share our details / errors here sometime from now.

Regards,
Anil Talpade
_______________________________________________
support-bugzilla mailing list
[hidden email]
https://lists.mozilla.org/listinfo/support-bugzilla
PLEASE put [hidden email] in the To: field when you reply.