459982 - [Oracle] Windows installation may need additional documentation

Status: RESOLVED WORKSFORME

(Bugzilla :: Documentation, defect)

Description

[Dave King]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3
Build Identifier: 3.2rc1

Hi all,

I think there is a bug here.  If not, sorry.  Here is my experience of installing Oracle 10g XE + Bugzilla 3.2rc1 + Apache 2.2.8 + ActivePerl 5.8.8 on a Windows XP Pro SP2 laptop.

1. install-module.pl spewed too much to read but the occasional "That was a pretty bad one but I'm ignoring it" bothered me, and it finally failed hard, so I reinstalled perl and bugzilla and used the wonderful checksetup.pl --check-modules to manually ppm everything except PerlMagick and SASL-Authen which ppm did not find at ActiveState or your Theory58S repositories.

2. It was a bit tricky for a beginning Oracle + Bugzilla admin but I think everything is somewhere in the docs and finally checksetup.pl --all succeeded in connecting the DB and creating the schema.

3. In the browser now, index.cgi failed at "use DBD::Oracle," reporting that it could not find <perl>/lib/auto/DBD/Oracle/Oracle.dll which was false because I could see Oracle.dll with my own eyes!  Running index.cgi from command line showed that Oracle.dll could not find oci.dll even though oci.dll was in the PATH at <oracle>/app/oracle/product/10.2.0/server/BIN.  I have seen this before:  ppm install DBD-Oracle drops oci.dll in <perl>/bin but <perl>/lib/auto/DBD/Oracle/Oracle.dll can't find it until I drop a copy in <perl>/lib/auto/DBD/Oracle.

4. Moving along, browser reports error from Oracle DB, something about "OCINls language not found, please check your ORACLE_HOME, is your database running?"  This may be a documentation problem because OracleXE online docs say "Windows does not need environment settings because we handle it, only Linux needs ORACLE_HOME and LD_LIBRARY_PATH" etc.  And all the examples from you show only Linux so ... so I added ORACLE_HOME => <oracle>/app/oracle/product/10.2.0/server to Windoze global environment, added PassEnv ORACLE_HOME to Apache config, and finally, Finally got a nice picture of a bug looking for something at dusk.  OracleXE puts ORACLE_HOME in the registry; I guess Oracle.dll doesn't do registry.

5. Next, the Search page crashed with the "RELEVANCE" bug that I saw posted earlier.  I am not able to access your cvs server (that would be #6) but compared the diffs there to my perl scripts and it looked like I had xiaoou.wu's fixes so I dunno if this is still a bug on Windows or if I just need to pick up newer versions.

OK, there you have it.  Hope this all fits on my first bug report and is helpful.

Regards,
Dave.


Reproducible: Always

Steps to Reproduce:
1. Install fresh Apache, ActivePerl, OracleXE, Bugzilla 3.2rc1 per my notes.
2. Navigate browser to new bugzilla page.
3. Search.
Actual Results:  
See my long summary.

Expected Results:  
It is a challenge to have new stuff work right away.  Wish I could get bits from cvs, maybe be more helpful.

Please email me if I can provide any more info.

Comment 1

[Xiaoou]

You may hit this bug 455857.

Comment 2

[Max Kanat-Alexander]

  You can't use install-module.pl on Windows. Why in the world would you be trying?

  As far as the stuff about DBD::Oracle on Windows, you're the first (or one of the first) to try using Bugzilla with Oracle on Windows, which we haven't even tested yet, so it's possible that the installation instructions need some work there.

Comment 3

[Frédéric Buclin]

(In reply to comment #0)
> OK, there you have it.  Hope this all fits on my first bug report and is
> helpful.

Yes, your input is helpful. Thanks for testing Bugzilla + Oracle on Windows. :)

xiaoou, can you investigate and confirm on Windows (besides #5 which we already know about)? If it's confirmed, please set the bug status to NEW.

Comment 4

[Dave King]

(In reply to comment #2)
>   You can't use install-module.pl on Windows. Why in the world would you be
> trying?

In the world of "new user fumbling around," I must have seen install-module.pl presented without realizing it was not platform-independent.  In any world, this is easy to fix.

  if (OS == Windows) {
    `ppm install TimeDate`;
	...
  }

The bug says "Assigned To: Bugzilla Documentation Team (you?)" and, as I'm volunteering on the Obama campaign, I'd be happy to help with Bugzilla docs if someone helps me get started.

~D

Comment 5

[Max Kanat-Alexander]

Oh, okay! :-) Do you want to fix the docs, or do you want to actually make install-module.pl work on Windows? I'd be happy to have either one...

In either case, our development process is described here:

  http://wiki.mozilla.org/Bugzilla:Developers

Comment 6

[Max Kanat-Alexander]

  Oh, and I forgot what bug this is. :-) We wouldn't fix install-module.pl in this bug, only the docs. I think you'll want to fix configuration.xml in the docs, for this one.

Comment 7

[Dave King]

(In reply to comment #5)
> Oh, okay! :-) Do you want to fix the docs, or do you want to actually make
> install-module.pl work on Windows? I'd be happy to have either one...
> 
> In either case, our development process is described here:
> 
>   http://wiki.mozilla.org/Bugzilla:Developers

Thank you, Max!  I will review your development process and get back to you asap.

Comment 8

[Xiaoou]

Yes, we have to put oci.dll into the right path to get Bugzilla work on Windows.
Other things seem all right.

Thanks Dave for the great help:-)

Comment 9

[Dave King]

Hi all,

I need help finding correct JADE_PUB and LDP_HOME and lynx for makedocs.pl.

I found a windows jade binary on James Clark's site but it needs LDP_HOME,

	-----------------------------
	Creating separate HTML documentation ...
	jade -t sgml -i html -d C:\Temp\LDP_HOME/ldp.dsl#html D:\Apps\Mozilla\Jade/xml.dcl ../xml/Bugzilla-Guide.xml

	jade:../xml/Bugzilla-Guide.xml:2:61:W: cannot generate system identifier for public text "-//OASIS//DTD DocBook XML V4.1.2//EN"
	jade:../xml/Bugzilla-Guide.xml:48:0:E: reference to entity "book" for which no system identifier could be generated
	jade:../xml/Bugzilla-Guide.xml:2:0: entity was defined here
	jade:../xml/Bugzilla-Guide.xml:48:0:E: DTD did not contain element declaration for document type name
	jade:../xml/Bugzilla-Guide.xml:73:9:E: there is no attribute "id"
	jade:../xml/Bugzilla-Guide.xml:73:16:E: element "book" undefined
	...
	-----------------------------
	
I tried cygwin lynx but it gives this error,

	-----------------------------
	lynx -dump -justify=off -nolist Bugzilla-Guide.html > ../txt/Bugzilla-Guide.txt

	lynx: Invalid Option: -justify=off
	-----------------------------
	
Please point me to the proper toolset.

Thanks!
-Dave

Comment 10

[Max Kanat-Alexander]

I've never tried to build the docs on Windows, I'm not sure it can be done.

Comment 12

[Frédéric Buclin]

Bugzilla 3.2 is restricted to security bugs only. Mass-retargetting to 3.6.

Comment 13

[Max Kanat-Alexander]

Hey, I think that some or all of this should go on the Wiki somewhere, to help out Oracle users on Windows.

Comment 14

[Frédéric Buclin]

Is it still an issue with Bugzilla 5.0.2? Bugzilla support for Windows has improved a lot since 2008.

Comment 15

[Dave King]

Golly, Frederic, this was a long time ago, I do not recall the details, no longer use this environment.  Go ahead and close if you like, I do not have cycles to reproduce here.  Thanks, -dave

Comment 16

[Frédéric Buclin]

OK, so closing as we cannot do anything without feedback.