Hi Thorsten,
I was able to run the $perl
checksetup.pl --check-modules and $perl
install-module.pl --all commands.
However, I was unable to install the following DBD Modules: DBD-mysql
(v4.001) , DBD-Pg (v2.7.0) and DBD-Oracle (v1.19). I am listing the
results below.
---------------------------------------
Bens-MacBook-Pro:~ eljami$ cd bugzilla
Bens-MacBook-Pro:bugzilla eljami$ perl
checksetup.pl --check-module
* This is Bugzilla 5.0.6 on perl 5.18.4
* Running on Darwin 18.7.0 Darwin Kernel Version 18.7.0: Thu Jun 20
18:42:21 PDT 2019; root:xnu-4903.270.47~4/RELEASE_X86_64
Checking perl modules...
Checking for CGI.pm (v3.51) ok: found v4.44
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.51
Checking for DateTime-TimeZone (v1.64) ok: found v2.36
Checking for DBI (v1.614) ok: found v1.642
Checking for Template-Toolkit (v2.24) ok: found v2.29
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.76
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 v4.02
Checking available perl DBD modules...
Checking for DBD-mysql (v4.001) not found
Checking for DBD-Pg (v2.7.0) not found
Checking for DBD-Oracle (v1.19) not found
Checking for DBD-SQLite (v1.29) ok: found v1.62
The following Perl modules are optional:
Checking for GD (v1.20) ok: found v2.71
Checking for Chart (v2.4.1) ok: found v2.4.10
Checking for Template-GD (any) ok: found v1.56
Checking for GDTextUtil (any) ok: found v0.86
Checking for GDGraph (any) ok: found v1.54
Checking for MIME-tools (v5.406) ok: found v5.509
Checking for libwww-perl (any) ok: found v6.39
Checking for XML-Twig (any) ok: found v3.52
Checking for PatchReader (v0.9.6) ok: found v0.9.6
Checking for perl-ldap (any) ok: found v0.66
Checking for Authen-SASL (any) ok: found v2.16
Checking for Net-SMTP-SSL (v1.01) ok: found v1.04
Checking for RadiusPerl (any) ok: found v0.31
Checking for SOAP-Lite (v0.712) ok: found v1.27
Checking for XMLRPC-Lite (v0.712) ok: found v0.717
Checking for JSON-RPC (any) ok: found v1.06
Checking for Test-Taint (v1.06) ok: found v1.08
Checking for HTML-Parser (v3.67) ok: found v3.72
Checking for HTML-Scrubber (any) ok: found v0.17
Checking for Encode (v2.21) ok: found v3.01
Checking for Encode-Detect (any) ok: found v1.01
Checking for Email-Reply (any) ok: found v1.204
Checking for HTML-FormatText-WithLinks (v0.13) ok: found v0.15
Checking for TheSchwartz (v1.07) ok: found v1.12
Checking for Daemon-Generic (any) ok: found v0.85
Checking for mod_perl (v1.999022) ok: found v2.000009
Checking for Apache-SizeLimit (v0.96) not found
Checking for File-MimeInfo (any) ok: found v0.29
Checking for IO-stringy (any) ok: found v2.111
Checking for Cache-Memcached (any) ok: found v1.30
Checking for File-Copy-Recursive (any) ok: found v0.45
Checking for File-Which (any) ok: found v1.23
Checking for mod_env (any) ok
Checking for mod_expires (any) not found
Checking for mod_headers (any) ok
Checking for mod_rewrite (any) not found
Checking for mod_version (any) ok
***********************************************************************
* 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) *
***********************************************************************
* Apache-SizeLimit * mod_perl *
***********************************************************************
* APACHE MODULES *
***********************************************************************
* Some Apache modules allow to extend Bugzilla functionalities. *
* These modules can be enabled in the Apache configuration file *
* (usually called httpd.conf or apache2.conf). *
* - mod_headers, mod_env and mod_expires permit to automatically *
* refresh the browser cache of your users when upgrading Bugzilla. *
* - mod_rewrite permits to write shorter URLs used by the REST API. *
* - mod_version permits to write rules in .htaccess specific to *
* Apache 2.2 or 2.4. *
* The modules you need to enable are: *
* *
* mod_expires, mod_rewrite *
* *
***********************************************************************
COMMANDS TO INSTALL OPTIONAL MODULES:
Apache-SizeLimit: perl
install-module.pl Apache2::SizeLimit
To attempt an automatic install of every required and optional module
with one command, do:
perl
install-module.pl --all
Bens-MacBook-Pro:bugzilla eljami$ perl
install-module.pl --all
Checking for CPAN (v1.81) ok: found v2.00
Checking for YAML (any) ok: found v1.29
Checking for ExtUtils-MakeMaker (v6.31) ok: found v7.36
Reading '/Users/eljami/.cpan/Metadata'
Database was generated on Fri, 26 Jul 2019 11:41:02 GMT
Installing Apache2::SizeLimit version 0.96...
Apache2::SizeLimit is up to date (0.97).
Installing DBD::mysql version 4.050...
Running install for module 'DBD::mysql'
Running make for D/DV/DVEEDEN/DBD-mysql-4.050.tar.gz
Checksum for
/Users/eljami/.cpan/source/authors/id/D/DV/DVEEDEN/DBD-mysql-4.050.tar.gz ok
CPAN.pm: Building D/DV/DVEEDEN/DBD-mysql-4.050.tar.gz
PLEASE NOTE:
For 'make test' to run properly, you must ensure that the
database user 'eljami' can connect to your MySQL server
and has the proper privileges that these tests require such
as 'drop table', 'create table', 'drop procedure', 'create procedure'
as well as others.
mysql> grant all privileges on test.* to 'eljami'@'localhost' identified by
's3kr1t';
You can also optionally set the user to run 'make test' with:
perl Makefile.PL --testuser=username
I will use the following settings for compiling and testing:
cflags (mysql_config) =
-I/usr/local/Cellar/mysql-connector-c/6.1.11/include
embedded (guessed ) =
ldflags (guessed ) =
libs (mysql_config) =
-L/usr/local/Cellar/mysql-connector-c/6.1.11/lib -l
mysql_config (guessed ) = mysql_config
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
nossl (default ) = 0
testdb (default ) = test
testhost (default ) =
testpassword (default ) =
testport (default ) =
testsocket (default ) =
testuser (guessed ) = eljami
To change these settings, see 'perl Makefile.PL --help' and
'perldoc DBD::mysql::INSTALL'.
Checking if libs are available for compiling...
Can't link/include C library '', aborting.
Warning: No success on command[/usr/bin/perl
Makefile.PL LIB="/Users/eljami/bugzilla/lib"
INSTALLMAN1DIR="/Users/eljami/bugzilla/lib/man/man1"
INSTALLMAN3DIR="/Users/eljami/bugzilla/lib/man/man3"
INSTALLBIN="/Users/eljami/bugzilla/lib/bin"
INSTALLSCRIPT="/Users/eljami/bugzilla/lib/bin" INSTALLDIRS=perl]
DVEEDEN/DBD-mysql-4.050.tar.gz
/usr/bin/perl Makefile.PL LIB="/Users/eljami/bugzilla/lib"
INSTALLMAN1DIR="/Users/eljami/bugzilla/lib/man/man1"
INSTALLMAN3DIR="/Users/eljami/bugzilla/lib/man/man3"
INSTALLBIN="/Users/eljami/bugzilla/lib/bin"
INSTALLSCRIPT="/Users/eljami/bugzilla/lib/bin" INSTALLDIRS=perl -- NOT OK
Skipping test because of notest pragma
Running make install
Make had some problems, won't install
---------------------------------------
So I googled DBD-mysql (v4.001) and it pointed me to
https://metacpan.org/pod/DBD::mysql::INSTALL and navigated to the macOS
section, where it suggest to run brew install openssl mysql-connector-c and
then install DBD:mysql using cpan client.
Bens-MacBook-Pro:bugzilla eljami$ brew install openssl mysql-connector-c
Warning: openssl 1.0.2s is already installed and up-to-date
To reinstall 1.0.2s, run `brew reinstall openssl`
Warning: mysql-connector-c 6.1.11 is already installed and up-to-date
To reinstall 6.1.11, run `brew reinstall mysql-connector-c`
As openssl & mysql-connector-c are already installed and up to date then I
proceeded to install DBD:mysql using cpan client as follows:
---------------------------------------
Bens-MacBook-Pro:bugzilla eljami$ cpan DBD::mysql
Reading '/Users/eljami/.cpan/Metadata'
Database was generated on Fri, 26 Jul 2019 11:41:02 GMT
Running install for module 'DBD::mysql'
Running make for D/DV/DVEEDEN/DBD-mysql-4.050.tar.gz
Checksum for
/Users/eljami/.cpan/sources/authors/id/D/DV/DVEEDEN/DBD-mysql-4.050.tar.gz
ok
---- Unsatisfied dependencies detected during ----
---- DVEEDEN/DBD-mysql-4.050.tar.gz ----
Devel::CheckLib [build_requires]
Running make test
Make had some problems, won't test
Delayed until after prerequisites
Running make install
Make had some problems, won't install
Delayed until after prerequisites
Running install for module 'Devel::CheckLib'
Running make for M/MA/MATTN/Devel-CheckLib-1.13.tar.gz
Checksum for
/Users/eljami/.cpan/sources/authors/id/M/MA/MATTN/Devel-CheckLib-1.13.tar.gz
ok
CPAN.pm: Building M/MA/MATTN/Devel-CheckLib-1.13.tar.gz
Checking if your kit is complete...
Looks good
Writing Makefile for Devel::CheckLib
Writing MYMETA.yml and MYMETA.json
---- Unsatisfied dependencies detected during ----
---- MATTN/Devel-CheckLib-1.13.tar.gz ----
IO::CaptureOutput [build_requires]
Mock::Config [build_requires]
Running make test
Delayed until after prerequisites
Running make install
Delayed until after prerequisites
Running install for module 'IO::CaptureOutput'
Running make for D/DA/DAGOLDEN/IO-CaptureOutput-1.1104.tar.gz
Checksum for
/Users/eljami/.cpan/sources/authors/id/D/DA/DAGOLDEN/IO-CaptureOutput-1.1104.tar.gz
ok
CPAN.pm: Building D/DA/DAGOLDEN/IO-CaptureOutput-1.1104.tar.gz
Checking if your kit is complete...
Looks good
Writing Makefile for IO::CaptureOutput
Writing MYMETA.yml and MYMETA.json
cp lib/IO/CaptureOutput.pm blib/lib/IO/CaptureOutput.pm
Manifying blib/man3/IO::CaptureOutput.3pm
DAGOLDEN/IO-CaptureOutput-1.1104.tar.gz
/usr/bin/make -- OK
'YAML' not installed, will not store persistent state
Running make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00-report-prereqs.t .. #
# Versions for all modules listed in MYMETA.json (including optional ones):
#
# === Configure Requires ===
#
# Module Want Have
# ------------------- ---- ----
# ExtUtils::MakeMaker 6.17 6.66
#
# === Build Requires ===
#
# Module Want Have
# ------------------- ---- ----
# ExtUtils::MakeMaker any 6.66
#
# === Test Requires ===
#
# Module Want Have
# ------------------- ---- ----
# ExtUtils::MakeMaker any 6.66
# File::Spec 3.27 3.40
# IO::File any 1.16
# Test::More 0.62 0.98
#
# === Test Recommends ===
#
# Module Want Have
# ---------- -------- --------
# CPAN::Meta 2.120900 2.133380
#
# === Runtime Requires ===
#
# Module Want Have
# -------------- ---- ----
# Carp any 1.29
# Exporter any 5.68
# File::Basename any 2.84
# File::Temp 0.16 0.23
# Symbol any 1.07
# strict any 1.07
# vars any 1.03
# warnings any 1.18
#
t/00-report-prereqs.t .. ok
t/capture.t ............ ok
t/capture_exec.t ....... ok
t/capture_file.t ....... ok
t/errors.t ............. ok
t/noconsole.t .......... ok
t/wperl.t .............. skipped: not MSWin32
All tests successful.
Files=7, Tests=105, 2 wallclock secs ( 0.04 usr 0.01 sys + 1.07 cusr
0.42 csys = 1.54 CPU)
Result: PASS
DAGOLDEN/IO-CaptureOutput-1.1104.tar.gz
/usr/bin/make test -- OK
Running make install
Manifying blib/man3/IO::CaptureOutput.3pm
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
ERROR: Can't create '/Library/Perl/5.18/IO'
mkdir /Library/Perl/5.18/IO: Permission denied at
/System/Library/Perl/5.18/ExtUtils/Install.pm line 469.
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
at -e line 1.
make: *** [pure_site_install] Error 13
DAGOLDEN/IO-CaptureOutput-1.1104.tar.gz
/usr/bin/make install -- NOT OK
Running install for module 'Mock::Config'
Running make for R/RU/RURBAN/Mock-Config-0.03.tar.gz
Checksum for
/Users/eljami/.cpan/sources/authors/id/R/RU/RURBAN/Mock-Config-0.03.tar.gz
ok
CPAN.pm: Building R/RU/RURBAN/Mock-Config-0.03.tar.gz
Checking if your kit is complete...
Looks good
Writing Makefile for Mock::Config
Writing MYMETA.yml and MYMETA.json
cp lib/Mock/Config.pm blib/lib/Mock/Config.pm
Manifying blib/man3/Mock::Config.3pm
RURBAN/Mock-Config-0.03.tar.gz
/usr/bin/make -- OK
Running make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/0-basic.t ....... 1/3 # Testing Mock::Config, Perl 5.018004, Config
5.018004, /usr/bin/perl
t/0-basic.t ....... ok
t/manifest.t ...... skipped: requires a git checkout and a unix for git and
diff
t/pod-coverage.t .. skipped: Author tests not required for installation
t/pod.t ........... skipped: Author tests not required for installation
All tests successful.
Files=4, Tests=3, 0 wallclock secs ( 0.03 usr 0.01 sys + 0.06 cusr 0.02
csys = 0.12 CPU)
Result: PASS
RURBAN/Mock-Config-0.03.tar.gz
/usr/bin/make test -- OK
Running make install
Manifying blib/man3/Mock::Config.3pm
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
ERROR: Can't create '/Library/Perl/5.18/Mock'
mkdir /Library/Perl/5.18/Mock: Permission denied at
/System/Library/Perl/5.18/ExtUtils/Install.pm line 469.
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
at -e line 1.
make: *** [pure_site_install] Error 13
RURBAN/Mock-Config-0.03.tar.gz
/usr/bin/make install -- NOT OK
Running make for M/MA/MATTN/Devel-CheckLib-1.13.tar.gz
Has already been unwrapped into directory
/Users/eljami/.cpan/build/Devel-CheckLib-1.13-16W5gM
CPAN.pm: Building M/MA/MATTN/Devel-CheckLib-1.13.tar.gz
cp lib/Devel/CheckLib.pm blib/lib/Devel/CheckLib.pm
cp bin/use-devel-checklib blib/script/use-devel-checklib
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' --
blib/script/use-devel-checklib
Manifying blib/man1/use-devel-checklib.1
Manifying blib/man3/Devel::CheckLib.3pm
MATTN/Devel-CheckLib-1.13.tar.gz
/usr/bin/make -- OK
Running make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00-load.t ................... ok
t/analyze-binary.t ............ ok
t/bad-single-word-compiler.t .. Name "Config::STORE" used only once:
possible typo at t/bad-single-word-compiler.t line 18.
t/bad-single-word-compiler.t .. ok
t/cmdline-LIBS-INC.t .......... ok
t/custom-function.t ........... ok
t/dash-l-libs.t ............... ok
t/exit_with_message.t ......... ok
t/flags.t ..................... ok
t/found.t ..................... ok
t/headers.t ................... ok
t/multi-word-compiler.t ....... Name "Config::STORE" used only once:
possible typo at t/multi-word-compiler.t line 18.
t/multi-word-compiler.t ....... ok
t/not_found.t ................. ok
All tests successful.
Files=12, Tests=42, 4 wallclock secs ( 0.05 usr 0.02 sys + 2.20 cusr
1.46 csys = 3.73 CPU)
Result: PASS
MATTN/Devel-CheckLib-1.13.tar.gz
/usr/bin/make test -- OK
Running make install
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
ERROR: Can't create '/Library/Perl/5.18/Devel'
mkdir /Library/Perl/5.18/Devel: Permission denied at
/System/Library/Perl/5.18/ExtUtils/Install.pm line 469.
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
at -e line 1.
make: *** [pure_site_install] Error 13
MATTN/Devel-CheckLib-1.13.tar.gz
/usr/bin/make install -- NOT OK
Running make for D/DV/DVEEDEN/DBD-mysql-4.050.tar.gz
CPAN.pm: Building D/DV/DVEEDEN/DBD-mysql-4.050.tar.gz
PLEASE NOTE:
For 'make test' to run properly, you must ensure that the
database user 'eljami' can connect to your MySQL server
and has the proper privileges that these tests require such
as 'drop table', 'create table', 'drop procedure', 'create procedure'
as well as others.
mysql> grant all privileges on test.* to 'eljami'@'localhost' identified by
's3kr1t';
You can also optionally set the user to run 'make test' with:
perl Makefile.PL --testuser=username
I will use the following settings for compiling and testing:
cflags (mysql_config) =
-I/usr/local/Cellar/mysql-connector-c/6.1.11/include
embedded (guessed ) =
ldflags (guessed ) =
libs (mysql_config) =
-L/usr/local/Cellar/mysql-connector-c/6.1.11/lib -l
mysql_config (guessed ) = mysql_config
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
nossl (default ) = 0
testdb (default ) = test
testhost (default ) =
testpassword (default ) =
testport (default ) =
testsocket (default ) =
testuser (guessed ) = eljami
To change these settings, see 'perl Makefile.PL --help' and
'perldoc DBD::mysql::INSTALL'.
Checking if libs are available for compiling...
Can't link/include C library '', aborting.
Warning: No success on command[/usr/bin/perl Makefile.PL]
DVEEDEN/DBD-mysql-4.050.tar.gz
/usr/bin/perl Makefile.PL -- NOT OK
Running make test
Make had some problems, won't test
Running make install
Make had some problems, won't install
I followed the NOTE above, however, I modified the SQL query as I was
getting ERROR 1064 (42000):
I googled "error 1064 mysql 42000 grant all privileges" and I ran into this
blog:
https://stackoverflow.com/questions/50177216/how-to-grant-all-privileges-to-root-user-in-mysql-8-0/50197630
It says that starting with MySQL 8 you no longer can (implicitly) create a
user using the GRANT command. Use CREATE USER instead, followed by the
GRANT statement.
So I run the CREATE USER command first as follows:
Bens-MacBook-Pro:bugzilla eljami$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.17 MySQL Community Server - GPL
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.
mysql> CREATE USER 'eljami'@'localhost' identified by 's3kr1t';
{note: I replaced s3kr1t with my own value}
Then I run the command below:
Bens-MacBook-Pro:bugzilla eljami$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.17 MySQL Community Server - GPL
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.
mysql> GRANT ALL PRIVILEGES ON test.* to 'eljami'@'localhost' WITH GRANT
OPTION;
Query OK, 0 rows affected (0.00 sec)
{note: I first tried grant all privileges on test.* to 'eljami'@'localhost'
identified by 's3kr1t';
however, I got ERROR 1064 (42000), also note that I used my own value
instead of s3kr1t }
While still logged in to mysql, I opened a new terminal and ran the command
below again:
Bens-MacBook-Pro:bugzilla eljami$ perl
install-module.pl --all
However, I got the same error as above so I exited mysql and again ran:
Bens-MacBook-Pro:bugzilla eljami$ perl
install-module.pl --all
But the problem is still there.
It appears that the other option is " to run 'make test' with: perl
Makefile.PL --testuser=username
Please let me know if I am going in the right direction!
Regards,
Ben
On Fri, Jul 26, 2019 at 10:14 PM Thorsten Schöning <
tscho...@am-soft.de>
wrote:
> Guten Tag Ben Sanchez,
> Mit freundlichen Grüßen,
>
> Thorsten Schöning
>
> --
> Thorsten Schöning E-Mail: Thorsten....@AM-SoFT.de
> 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
>