Bugzilla on Windows 2012 R2

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

Bugzilla on Windows 2012 R2

robert.j.mortensen
I am attempting to install Bugzilla on Windows 2012 R2. I have been following the instructions from this website: http://bugzilla.readthedocs.io/en/latest/installing/windows.html

I have installed MySQL, Apache24, Strawberry Perl, and I'm in the process of trying to get Bugzilla setup. When I run checksetup.pl I get the following output:

* This is Bugzilla 5.0.4 on perl 5.26.2
* Running on Win2012 Build 9600

Checking perl modules...
Checking for               CGI.pm (v3.51)     ok: found v4.38
Checking for           Digest-SHA (any)       ok: found v6.02
Checking for             TimeDate (v2.23)     ok: found v2.24
Checking for             DateTime (v0.75)     ok: found v1.48
Checking for    DateTime-TimeZone (v1.64)     ok: found v2.18
Checking for                  DBI (v1.614)    ok: found v1.641
Checking for     Template-Toolkit (v2.24)     ok: found v2.27
Checking for         Email-Sender (v1.300011) ok: found v1.300031
Checking for           Email-MIME (v1.904)    ok: found v1.946
Checking for                  URI (v1.55)     ok: found v1.74
Checking for       List-MoreUtils (v0.32)     ok: found v0.428
Checking for    Math-Random-ISAAC (v1.0.1)    ok: found v1.004
Checking for              JSON-XS (v2.01)     ok: found v3.04
Checking for                Win32 (v0.35)     ok: found v0.52
Checking for            Win32-API (v0.55)     ok: found v0.84
Checking for DateTime-TimeZone-Local-Win32 (v1.64)     ok: found v2.01

Checking available perl DBD modules...
Checking for           DBD-SQLite (v1.29)     ok: found v1.58
Checking for           DBD-Oracle (v1.19)     ok: found v1.74
Checking for               DBD-Pg (v2.7.0)    ok: found v3.7.4
Checking for            DBD-mysql (v4.001)    ok: found v4.046

The following Perl modules are optional:
Checking for                   GD (v1.20)     ok: found v2.68
Checking for                Chart (v2.4.1)    not found
Checking for          Template-GD (any)       not found
Checking for           GDTextUtil (any)       not found
Checking for              GDGraph (any)       not found
Checking for           MIME-tools (v5.406)    not found
Checking for          libwww-perl (any)       ok: found v6.33
Checking for             XML-Twig (any)       ok: found v3.52
Checking for          PatchReader (v0.9.6)    not found
Checking for            perl-ldap (any)       not found
Checking for          Authen-SASL (any)       ok: found v2.16
Checking for         Net-SMTP-SSL (v1.01)     not found
Checking for           RadiusPerl (any)       not found
Checking for            SOAP-Lite (v0.712)    ok: found v1.26
Checking for          XMLRPC-Lite (v0.712)    not found
Checking for             JSON-RPC (any)       ok: found v1.06
Checking for           Test-Taint (v1.06)     not found
Checking for          HTML-Parser (v3.67)     ok: found v3.72
Checking for        HTML-Scrubber (any)       not found
Checking for               Encode (v2.21)     ok: found v2.97
Checking for        Encode-Detect (any)       not found
Checking for          Email-Reply (any)       not found
Checking for HTML-FormatText-WithLinks (v0.13)     not found
Checking for          TheSchwartz (v1.07)     not found
Checking for       Daemon-Generic (any)       not found
Checking for             mod_perl (v1.999022) not found
Checking for     Apache-SizeLimit (v0.96)     not found
Checking for        File-MimeInfo (any)       not found
Checking for           IO-stringy (any)       ok: found v2.111
Checking for      Cache-Memcached (any)       not found
Checking for  File-Copy-Recursive (any)       ok: found v0.38
Checking for           File-Which (any)       ok: found v1.22
***********************************************************************
* OPTIONAL MODULES                                                    *
***********************************************************************
* Certain Perl modules are not required by Bugzilla, but by           *
* installing the latest version you gain access to additional         *
* features.                                                           *
*                                                                     *
* The optional modules you do not have installed are listed below,    *
* with the name of the feature they enable. Below that table are the  *
* commands to install each module.                                    *
***********************************************************************
*               MODULE NAME * ENABLES FEATURE(S)                      *
***********************************************************************
*                     Chart * New Charts, Old Charts                  *
*               Template-GD * Graphical Reports                       *
*                GDTextUtil * Graphical Reports                       *
*                   GDGraph * Graphical Reports                       *
*                MIME-tools * Move Bugs Between Installations         *
*               PatchReader * Patch Viewer                            *
*                 perl-ldap * LDAP Authentication                     *
*              Net-SMTP-SSL * SSL Support for SMTP                    *
*                RadiusPerl * RADIUS Authentication                   *
*               XMLRPC-Lite * XML-RPC Interface                       *
*                Test-Taint * JSON-RPC Interface, XML-RPC Interface, REST Interface *
*             HTML-Scrubber * More HTML in Product/Group Descriptions *
*             Encode-Detect * Automatic charset detection for text attachments *
*               Email-Reply * Inbound Email                           *
* HTML-FormatText-WithLinks * Inbound Email                           *
*               TheSchwartz * Mail Queueing                           *
*            Daemon-Generic * Mail Queueing                           *
*                  mod_perl * mod_perl                                *
*          Apache-SizeLimit * mod_perl                                *
*             File-MimeInfo * Sniff MIME type of attachments          *
*           Cache-Memcached * Memcached Support                       *
***********************************************************************
COMMANDS TO INSTALL OPTIONAL MODULES:

          Chart: C:\Strawberry\perl\bin\perl.exe install-module.pl Chart::Lines
    Template-GD: C:\Strawberry\perl\bin\perl.exe install-module.pl Template::Plugin::GD::Image
     GDTextUtil: C:\Strawberry\perl\bin\perl.exe install-module.pl GD::Text
        GDGraph: C:\Strawberry\perl\bin\perl.exe install-module.pl GD::Graph
     MIME-tools: C:\Strawberry\perl\bin\perl.exe install-module.pl MIME::Tools
    PatchReader: C:\Strawberry\perl\bin\perl.exe install-module.pl PatchReader
      perl-ldap: C:\Strawberry\perl\bin\perl.exe install-module.pl Net::LDAP
   Net-SMTP-SSL: C:\Strawberry\perl\bin\perl.exe install-module.pl Net::SMTP::SSL
     RadiusPerl: C:\Strawberry\perl\bin\perl.exe install-module.pl Authen::Radius
    XMLRPC-Lite: C:\Strawberry\perl\bin\perl.exe install-module.pl XMLRPC::Lite
     Test-Taint: C:\Strawberry\perl\bin\perl.exe install-module.pl Test::Taint
  HTML-Scrubber: C:\Strawberry\perl\bin\perl.exe install-module.pl HTML::Scrubber
  Encode-Detect: C:\Strawberry\perl\bin\perl.exe install-module.pl Encode::Detect
    Email-Reply: C:\Strawberry\perl\bin\perl.exe install-module.pl Email::Reply
HTML-FormatText-WithLinks: C:\Strawberry\perl\bin\perl.exe install-module.pl HTML::FormatText::WithLinks
    TheSchwartz: C:\Strawberry\perl\bin\perl.exe install-module.pl TheSchwartz
 Daemon-Generic: C:\Strawberry\perl\bin\perl.exe install-module.pl Daemon::Generic
       mod_perl: C:\Strawberry\perl\bin\perl.exe install-module.pl mod_perl2
Apache-SizeLimit: C:\Strawberry\perl\bin\perl.exe install-module.pl Apache2::SizeLimit
  File-MimeInfo: C:\Strawberry\perl\bin\perl.exe install-module.pl File::MimeInfo::Magic
Cache-Memcached: C:\Strawberry\perl\bin\perl.exe install-module.pl Cache::Memcached


To attempt an automatic install of every required and optional module
with one command, do:

  C:\Strawberry\perl\bin\perl.exe install-module.pl --all

Reading ./localconfig...

OPTIONAL NOTE: If you want to be able to use the 'difference between two
patches' feature of Bugzilla (which requires the PatchReader Perl module
as well), you should install patchutils from:

    http://cyberelk.net/tim/software/patchutils/

Checking for            DBD-mysql (v4.001)    ok: found v4.046
Checking for                MySQL (v5.0.15)   ok: found v8.0.11

Adding new table groups...

DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups (
        id      mediumint auto_increment PRIMARY KEY NOT NULL,
        name    varchar(255) N' at line 1 [for Statement "CREATE TABLE groups (
        id      mediumint auto_increment PRIMARY KEY NOT NULL,
        name    varchar(255) NOT NULL,
        description     mediumtext NOT NULL,
        isbuggroup      tinyint NOT NULL,
        userregexp      tinytext DEFAULT '' NOT NULL,
        isactive        tinyint DEFAULT 1 NOT NULL,
        icon_url        tinytext
) ENGINE = InnoDB CHARACTER SET utf8"] at Bugzilla/DB.pm line 837.
        Bugzilla::DB::_bz_add_table_raw(Bugzilla::DB::Mysql=HASH(0x8c615f8), "groups", HASH(0x8f70f20)) called at Bugzilla/DB.pm line 796
        Bugzilla::DB::bz_add_table(Bugzilla::DB::Mysql=HASH(0x8c615f8), "groups", HASH(0x8f70f20)) called at Bugzilla/DB.pm line 509
        Bugzilla::DB::bz_setup_database(Bugzilla::DB::Mysql=HASH(0x8c615f8)) called at Bugzilla/DB/Mysql.pm line 558
        Bugzilla::DB::Mysql::bz_setup_database(Bugzilla::DB::Mysql=HASH(0x8c615f8)) called at C:\bugzilla\checksetup.pl line 121

From what I am seeing, the script is failing when it tries to add "table groups". Any help would be greatly appreciated.


_______________________________________________
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: Bugzilla on Windows 2012 R2

robert.j.mortensen
On Tuesday, June 19, 2018 at 12:23:07 AM UTC-6, Thorsten Schöning wrote:

> Guten Tag [hidden email],
> am Montag, 18. Juni 2018 um 22:36 schrieben Sie:
>
> > DBD::mysql::db do failed: You have an error in your SQL syntax;
> > check the manual that corresponds to your MySQL server version for
> > the right syntax to use near 'groups (
>
> You need to use an older MySQL:
>
> https://bugzilla.mozilla.org/show_bug.cgi?id=1424043
>
> Mit freundlichen Grüßen,
>
> Thorsten Schöning
>
> --
> Thorsten Schöning       E-Mail: [hidden email]
> AM-SoFT IT-Systeme      http://www.AM-SoFT.de/
>
> Telefon...........05151-  9468- 55
> Fax...............05151-  9468- 88
> Mobil..............0178-8 9468- 04
>
> AM-SoFT GmbH IT-Systeme, Brandenburger Str. 7c, 31789 Hameln
> AG Hannover HRB 207 694 - Geschäftsführer: Andreas Muchow

thank you for your help. I installed an earlier version and it now installs.

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