Error in checksetup.pl with MYSql driver

I receive the following error running checksetup.  I have verified the Mysql is running.  

Checking for            DBD-mysql (v4.001)    ok: found v4.050
There was an error connecting to MySQL:

    install_driver(mysql) failed: Attempt to reload DBD/mysql.pm aborted.
Compilation failed in require at (eval 581) line 3, <DATA> chunk 755.

 at Bugzilla/DB.pm line 1328.


This might have several reasons:

* MySQL is not running.
* MySQL is running, but there is a problem either in the
  server configuration or the database access rights. Read the Bugzilla
  Guide in the doc directory. The section about database configuration
  should help.
* Your password for the 'bugs' user, specified in $db_pass, is
  incorrect, in './localconfig'.
* There is a subtle problem with Perl, DBI, or MySQL. Make
  sure all settings in './localconfig' are correct. If all else fails, set
  '$db_check' to 0.

Another question:  Does the MySql bin folder need to be in the machine path?
0
eko
12/28/2020 5:16:25 PM
mozilla.support.bugzilla 10182 articles. 0 followers. Post Follow

3 Replies
246 Views

Similar Articles

[PageSpeed] 44
Get it on Google Play
Get it on Apple App Store

Guten Tag eko...--- via support-bugzilla,
am Montag, 28. Dezember 2020 um 18:16 schrieben Sie:

>     install_driver(mysql) failed: Attempt to reload DBD/mysql.pm aborted.
> Compilation failed in require at (eval 581) line 3, <DATA> chunk 755.
>  at Bugzilla/DB.pm line 1328.

Depending on your distribution of Perl, there might simply be binaries
missing to actually load MySQL-drivers. As you are on Windows, I
suggest using ProcMon to see if DLLs are searched for and not found.

https://docs.microsoft.com/en-us/sysinternals/downloads/procmon

> Another question:  Does the MySql bin folder need to be in the machine pa=
th?

Depends on if it contains necessary DLLs. Additionally keep in mind
that if adding that dir to PATH works on the shell, you might need to
additionally do it for the web server as well.=20

Mit freundlichen Gr=FC=DFen,

Thorsten Sch=F6ning

--=20
Thorsten Sch=F6ning
AM-SoFT IT-Service - Bitstore Hameln GmbH

E-Mail:  Thorsten.Schoening@AM-SoFT.de
Web:     http://www.AM-SoFT.de/

Telefon: 05151-  9468-55
Fax:     05151-  9468-88
Mobil:    0178-8 9468-04

Firmensitz: Bitstore IT-Consulting, Frankfurter Allee 285, 10317 Berlin
Steuernummer 037/230/30566, HR 27198, Amtsgericht Potsdam Gesch=E4ftsf=FChr=
er Janine Galonska

0
windows
12/28/2020 6:17:06 PM
I ran procmon and I see nothing glaring.   I ran sanitycheck just for giggles and got the following:

C:\bugzilla>sanitycheck.pl
install_driver(mysql) failed: Can't load 'C:/Perl64/site/5.26.2/lib/auto/DBD/mysql/mysql.dll' for module DBD::mysql: lo
d_file:The specified module could not be found at C:/Perl64/lib/DynaLoader.pm line 194.
  at (eval 259) line 3.
Compilation failed in require at (eval 259) line 3.
Perhaps a required shared library or dll isn't installed where expected
 at Bugzilla/DB.pm line 1328.

the line at 1328 is 

  my $self = DBI->connect($dsn, $user, $pass, $attributes)

Is there any good way to try to see what modules are missing?  I am slowly giving up on this as it is the latest Mysql and the latest Activestate and the latest bugzilla, none of which seem to have been tested together in any way.  

Any more suggestions?  And keep in mind that weve been using this since 2005.

0
eko
12/29/2020 12:31:01 AM
Guten Tag eko...--- via support-bugzilla,
am Dienstag, 29. Dezember 2020 um 01:31 schrieben Sie:

> C:\bugzilla>sanitycheck.pl
> install_driver(mysql) failed: Can't load
> 'C:/Perl64/site/5.26.2/lib/auto/DBD/mysql/mysql.dll' for module DBD::mysq=
l: lo
> d_file:The specified module could not be found at
> C:/Perl64/lib/DynaLoader.pm line 194.
>   at (eval 259) line 3.
> Compilation failed in require at (eval 259) line 3.
> Perhaps a required shared library or dll isn't installed where expected
>  at Bugzilla/DB.pm line 1328.

This might mean that additional dependencies of mysql.dll are not
satisfied or things are incompatible with your installed MySQL or
alike. Should be of help to look at the dependencies of the DLL:

https://www.dependencywalker.com

> Any more suggestions?[...]

Linux, many of the dependencies for Perl, MySQL etc. can be satisfied
automatically by a apackage manager like APT. I'm running Bugzilla
with UB 18.04 and most dependencies simply installed by APT instead of
manually like on Windows. Recently I have switched from MySQL to
PostgreSQL for unrelated reasons, though.

https://www.bugzilla.org/docs/4.4/en/html/api/contrib/bzdbcopy.html

Mit freundlichen Gr=FC=DFen,

Thorsten Sch=F6ning

--=20
Thorsten Sch=F6ning
AM-SoFT IT-Service - Bitstore Hameln GmbH

E-Mail:  Thorsten.Schoening@AM-SoFT.de
Web:     http://www.AM-SoFT.de/

Telefon: 05151-  9468-55
Fax:     05151-  9468-88
Mobil:    0178-8 9468-04

Firmensitz: Bitstore IT-Consulting, Frankfurter Allee 285, 10317 Berlin
Steuernummer 037/230/30566, HR 27198, Amtsgericht Potsdam Gesch=E4ftsf=FChr=
er Janine Galonska

0
windows
12/29/2020 10:34:44 AM
Reply: