Porting Bugzilla to HP NonStop

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

Porting Bugzilla to HP NonStop

Randall S. Becker

Hi People,

 

I’m looking for advise on the most appropriate way to port Bugzilla to HP NonStop. We’re currently working on a PHP 5.3.2 port. The underlying database appears to support all of the constructs needed (ANSI 2003 compliant), has a shell-level interface, C++ embedded support, ODBC, and JDBC. I’ve checked the porting guide, but need more direction. Any advice would be appreciated.

 

Thanks,

 

Randall S. Becker

Managing Director, Nexbridge Inc.

[hidden email]

Phone: +1 416 984 9826

http://indestructiblecomputing.blogspot.com

 

Reply | Threaded
Open this post in threaded view
|

Re: Porting Bugzilla to HP NonStop

Max Kanat-Alexander
On 03/22/2010 07:57 AM, Randall S. Becker wrote:
> We’re currently working on a PHP 5.3.2 port.

        Why? That's a 10-person-year job. It would probably take less time to
get Perl working on your platform (which I would have to imagine it
already does).

> I’ve checked the porting guide, but need more direction.

        What porting guide?

        -Max
--
http://www.everythingsolved.com/
Competent, Friendly Bugzilla and Perl Services. Everything Else, too.
-
To view or change your list settings, click here:
<http://bugzilla.org/cgi-bin/mj_wwwusr?user=lists@...>
Reply | Threaded
Open this post in threaded view
|

Re: Porting Bugzilla to HP NonStop

Randall S. Becker
>> We’re currently working on a PHP 5.3.2 port.

> Why? That's a 10-person-year job. It would probably take less time to
get Perl working on your platform (which I would have to imagine it
already does).

True, but we have a head-start from an older port. I'd be happy to pass on PHP ;-). We do have Perl.

>> I’ve checked the porting guide, but need more direction.

> What porting guide?

Bugzilla 2.4.1 Doc had a discussion about porting. Old stuff. Not useful other than "Talk to the developers"


-
To view or change your list settings, click here:
<http://bugzilla.org/cgi-bin/mj_wwwusr?user=lists@...>
Reply | Threaded
Open this post in threaded view
|

Re: Porting Bugzilla to HP NonStop

Max Kanat-Alexander
On 03/23/2010 12:29 AM, Randall S. Becker wrote:
> True, but we have a head-start from an older port. I'd be happy to pass on PHP ;-). We do have Perl.

        Okay. Bugzilla is written in Perl, so why not just use Bugzilla as-is?

> Bugzilla 2.4.1 Doc had a discussion about porting. Old stuff. Not useful other than "Talk to the developers"

        There was no Bugzilla 2.4.1. (And if there was, it would have been from
1999.) Did you mean 2.14.1? I don't see anything like that in the 2.16
docs, which are the oldest we have on our website, currently.

        -Max
--
http://www.everythingsolved.com/
Competent, Friendly Bugzilla and Perl Services. Everything Else, too.
-
To view or change your list settings, click here:
<http://bugzilla.org/cgi-bin/mj_wwwusr?user=lists@...>
Reply | Threaded
Open this post in threaded view
|

Re: Porting Bugzilla to HP NonStop

Randall S. Becker
Here's the situation:

Checking for              DBD-Pg (v1.45)    not found
Checking for           DBD-mysql (v4.00)    not found
Checking for          DBD-Oracle (v1.19)    not found

As indicated, this box has none of the above three, nor are we going to put those on the box. I'm looking to port to a new database and am looking for advise on doing so. The RDBMS is NonStop SQL/MX, and I'm expert level at that.

-----Original Message-----
From: [hidden email] [mailto:[hidden email]] On Behalf Of Max Kanat-Alexander
Sent: March-23-10 3:56 AM
To: [hidden email]
Subject: Re: Porting Bugzilla to HP NonStop

On 03/23/2010 12:29 AM, Randall S. Becker wrote:
> True, but we have a head-start from an older port. I'd be happy to pass on PHP ;-). We do have Perl.

        Okay. Bugzilla is written in Perl, so why not just use Bugzilla as-is?

> Bugzilla 2.4.1 Doc had a discussion about porting. Old stuff. Not useful other than "Talk to the developers"

        There was no Bugzilla 2.4.1. (And if there was, it would have been from
1999.) Did you mean 2.14.1? I don't see anything like that in the 2.16
docs, which are the oldest we have on our website, currently.

        -Max
--
http://www.everythingsolved.com/
Competent, Friendly Bugzilla and Perl Services. Everything Else, too.
-
To view or change your list settings, click here:
<http://bugzilla.org/cgi-bin/mj_wwwusr?user=rsbecker@...>

-
To view or change your list settings, click here:
<http://bugzilla.org/cgi-bin/mj_wwwusr?user=lists@...>
Reply | Threaded
Open this post in threaded view
|

Re: Porting Bugzilla to HP NonStop

Gervase Markham
In reply to this post by Max Kanat-Alexander
On 23/03/10 14:57, Randall S. Becker wrote:

> Here's the situation:
>
> Checking for              DBD-Pg (v1.45)    not found
> Checking for           DBD-mysql (v4.00)    not found
> Checking for          DBD-Oracle (v1.19)    not found
>
> As indicated, this box has none of the above three, nor are we going to
> put those on the box. I'm looking to port to a new database and am
> looking for advise on doing so. The RDBMS is NonStop SQL/MX, and I'm
> expert level at that.

Someone here is deeply confused :-)

Perl and PHP are scripting languages. Bugzilla is a large web
application written in Perl. In order to get the output above, your box
must have run the checksetup.pl script which is written in Perl.
Therefore, your box is capable of running Perl, and running Bugzilla's
current code. Converting it "to PHP" would mean rewriting all the code -
basically writing a new application. As Max says, it's a 10 person year
job. Cost - $1M plus. (Cost of buying dedicated hardware, putting Linux
on it and running Bugzilla on that: $1K + 1 man day).

Separately, Bugzilla uses an SQL database. It currently supports MySQL,
PostgreSQL and Oracle (experimentally). Porting it to use a new database
is a comparatively easy task. If you wanted to add "NonStop SQL/MX" to
that list, then that I'm sure is doable. You would need to write a Perl
DBD driver for your database, as I don't think one is available, but
documentation on how to do that _is_ available:
http://search.cpan.org/~timb/DBI-1.609/lib/DBI/DBD.pm

Thirdly, the list you give above does not tell you whether particular
databases are installed, but whether the Perl modules to _drive_
particular databases (DBD modules) are installed or not. You don't have
any of such modules installed, but they are very easy to install. Just
use CPAN.

You do not need to be an expert DBMS to run Bugzilla. Most people just
set up MySQL following the instructions, and let it get on with it. I
strongly suggest that, assuming MySQL is available for your platform,
the easiest way for you to run Bugzilla is to do the same. And if it's
not, the easiest thing to do is buy a 1U rackmount server, install Linux
and use that.

Gerv
_______________________________________________
dev-apps-bugzilla mailing list
[hidden email]
https://lists.mozilla.org/listinfo/dev-apps-bugzilla
-
To view or change your list settings, click here:
<http://bugzilla.org/cgi-bin/mj_wwwusr?user=lists@...>
Reply | Threaded
Open this post in threaded view
|

Re: Porting Bugzilla to HP NonStop

Randall S. Becker
Thanks Gervase.

The point is actually to do the port to SQL/MX rather than using MySQL. At
present, we're upgrading Perl to include the required modules (not so easy
due to quirks, unfortunately, and a lack of mail of any kind on the box).

I wasn't actually confused about the database; rather, just responding to
Max. The SQL/MX engine is native on the box.

The documentation at CPAN appears helpful and I'm going down the DBD path,
although I'm spawning a separate path for using the unixODBC driver
directly.

Thanks,

Randall

-----Original Message-----
From: [hidden email] [mailto:[hidden email]]
On Behalf Of Gervase Markham
Sent: March-23-10 12:06 PM
To: [hidden email]
Subject: Re: Porting Bugzilla to HP NonStop

On 23/03/10 14:57, Randall S. Becker wrote:

> Here's the situation:
>
> Checking for              DBD-Pg (v1.45)    not found
> Checking for           DBD-mysql (v4.00)    not found
> Checking for          DBD-Oracle (v1.19)    not found
>
> As indicated, this box has none of the above three, nor are we going to
> put those on the box. I'm looking to port to a new database and am
> looking for advise on doing so. The RDBMS is NonStop SQL/MX, and I'm
> expert level at that.

Someone here is deeply confused :-)

Perl and PHP are scripting languages. Bugzilla is a large web
application written in Perl. In order to get the output above, your box
must have run the checksetup.pl script which is written in Perl.
Therefore, your box is capable of running Perl, and running Bugzilla's
current code. Converting it "to PHP" would mean rewriting all the code -
basically writing a new application. As Max says, it's a 10 person year
job. Cost - $1M plus. (Cost of buying dedicated hardware, putting Linux
on it and running Bugzilla on that: $1K + 1 man day).

Separately, Bugzilla uses an SQL database. It currently supports MySQL,
PostgreSQL and Oracle (experimentally). Porting it to use a new database
is a comparatively easy task. If you wanted to add "NonStop SQL/MX" to
that list, then that I'm sure is doable. You would need to write a Perl
DBD driver for your database, as I don't think one is available, but
documentation on how to do that _is_ available:
http://search.cpan.org/~timb/DBI-1.609/lib/DBI/DBD.pm

Thirdly, the list you give above does not tell you whether particular
databases are installed, but whether the Perl modules to _drive_
particular databases (DBD modules) are installed or not. You don't have
any of such modules installed, but they are very easy to install. Just
use CPAN.

You do not need to be an expert DBMS to run Bugzilla. Most people just
set up MySQL following the instructions, and let it get on with it. I
strongly suggest that, assuming MySQL is available for your platform,
the easiest way for you to run Bugzilla is to do the same. And if it's
not, the easiest thing to do is buy a 1U rackmount server, install Linux
and use that.

Gerv
_______________________________________________
dev-apps-bugzilla mailing list
[hidden email]
https://lists.mozilla.org/listinfo/dev-apps-bugzilla
-
To view or change your list settings, click here:
<http://bugzilla.org/cgi-bin/mj_wwwusr?user=rsbecker@...>

-
To view or change your list settings, click here:
<http://bugzilla.org/cgi-bin/mj_wwwusr?user=lists@...>
Reply | Threaded
Open this post in threaded view
|

Re: Porting Bugzilla to HP NonStop

Joel Peshkin
Randall,

   If you have ODBC available, the path of least resistance is likely to
start with DBD::ODBC.  Naturally, once you've done that you will need
to update and test all of the Bugzilla code that needs to be at all
database-aware.  That has already been done to accommodate the quirks
of Mysql, Pg, and Oracle so it shouldn't be too terrible a job unless
NonStop is missing any major capabilities.

-Joel Peshkin

>
> The documentation at CPAN appears helpful and I'm going down the DBD path,
> although I'm spawning a separate path for using the unixODBC driver
> directly.
>


-
To view or change your list settings, click here:
<http://bugzilla.org/cgi-bin/mj_wwwusr?user=lists@...>
Reply | Threaded
Open this post in threaded view
|

Re: Porting Bugzilla to HP NonStop

mockodin
In reply to this post by Randall S. Becker
Those being the only support db platforms.

That said to test another db you would need to modify the following:
/bugzilla/Bugzilla/Constants.pm
   Add a section calling the DBD-<your db here>

And you will need to create two files:
Bugzilla\DB\<yourdbtype>.pm
Bugzilla\DB\Schema\<yourdbtype>.pm

Take a look at the patch file I have up on http://www.zplace.com that
is a port for MSSQL. You may want to start be cloning the
Bugzilla\DB\mysql.pm and Bugzilla\DB\Schema\mysql.pm files and edited
where needed.

Keep in mind that your more or less on your own for support, except
where folks are feeling generous, since it is not a supported port.
If you can get it working I imagine if you can submit what you did
back to the community it might get added, that's my goal for mssql.

For my port I found some hard coded instances of functions where
assumptions had been made, such as substring, under mssql all three
parameters are required not just the first two.


Seeing Joel's update, the MSSQL patch is using DBD::ODBC already so
you can probably clone part of my code.

On Tue, Mar 23, 2010 at 7:57 AM, Randall S. Becker
<[hidden email]> wrote:

> Here's the situation:
>
> Checking for              DBD-Pg (v1.45)    not found
> Checking for           DBD-mysql (v4.00)    not found
> Checking for          DBD-Oracle (v1.19)    not found
>
> As indicated, this box has none of the above three, nor are we going to put those on the box. I'm looking to port to a new database and am looking for advise on doing so. The RDBMS is NonStop SQL/MX, and I'm expert level at that.
>
> -----Original Message-----
> From: [hidden email] [mailto:[hidden email]] On Behalf Of Max Kanat-Alexander
> Sent: March-23-10 3:56 AM
> To: [hidden email]
> Subject: Re: Porting Bugzilla to HP NonStop
>
> On 03/23/2010 12:29 AM, Randall S. Becker wrote:
>> True, but we have a head-start from an older port. I'd be happy to pass on PHP ;-). We do have Perl.
>
>        Okay. Bugzilla is written in Perl, so why not just use Bugzilla as-is?
>
>> Bugzilla 2.4.1 Doc had a discussion about porting. Old stuff. Not useful other than "Talk to the developers"
>
>        There was no Bugzilla 2.4.1. (And if there was, it would have been from
> 1999.) Did you mean 2.14.1? I don't see anything like that in the 2.16
> docs, which are the oldest we have on our website, currently.
>
>        -Max
> --
> http://www.everythingsolved.com/
> Competent, Friendly Bugzilla and Perl Services. Everything Else, too.
> -
> To view or change your list settings, click here:
> <http://bugzilla.org/cgi-bin/mj_wwwusr?user=rsbecker@...>
>
> -
> To view or change your list settings, click here:
> <http://bugzilla.org/cgi-bin/mj_wwwusr?user=mockodin@...>
>
-
To view or change your list settings, click here:
<http://bugzilla.org/cgi-bin/mj_wwwusr?user=lists@...>