I am setting Bugzilla on my machine and want to install DBD::mysql module. I am trying this with manual installation using nmake install as my network is behind firewall and I can not use ppm install or cpan commands because proxy authentication failure error(inspite of setting HTTP_proxy environment variable).

I also tried installing lower version of DBD::mysql module but got same error. Can you please suggest how do I resolve this error? or Is there any other way to install this module.There are some sucessfull process as well as warnings in between but I have put only errors.

Error:

D:\Bugzilla\PERL_M~1\DBD-MY~1.011>perl Makefile.PL "--libs=-Lc:\mysql\lib -lmysq lclient -lz -lm -lcrypt -lnsl" "--cflags=-Ic:\mysql\include"
Use of uninitialized value in concatenation (.) or string at Makefile.PL line 488.
Use of uninitialized value in printf at Makefile.PL line 175.

Use of uninitialized value in printf at Makefile.PL line 175.

Checking if your kit is complete...
Looks good
Note (probably harmless): No library found for -lmysqlclient
Note (probably harmless): No library found for -lz
Note (probably harmless): No library found for -lm
Note (probably harmless): No library found for -lcrypt
Note (probably harmless): No library found for -lnsl
Multiple copies of Driver.xst found in: C:/Perl/site/lib/auto/DBI/ C:/Perl/lib/a uto/DBI/ at Makefile.PL line 747

Using DBI 1.608 (for perl 5.008008 on MSWin32-x86-multi-thread) installed in C:/ Perl/site/lib/auto/DBI/

Writing Makefile for DBD::mysql
D:\Bugzilla\PERL_M~1\DBD-MY~1.011>nmake
Creating library blib\arch\auto\DBD\mysql\mysql.lib and object blib\arch\auto \DBD\mysql\mysql.exp
dbdimp.obj : error LNK2001: unresolved external symbol _mysql_real_connect@32

dbdimp.obj : error LNK2001: unresolved external symbol _mysql_options@12
dbdimp.obj : error LNK2001: unresolved external symbol _mysql_init@4
dbdimp.obj : error LNK2001: unresolved external symbol _mysql_errno@4
mysql.obj : error LNK2001: unresolved external symbol _mysql_errno@4
dbdimp.obj : error LNK2001: unresolved external symbol _mysql_error@4
mysql.obj : error LNK2001: unresolved external symbol _mysql_error@4
dbdimp.obj : error LNK2001: unresolved external symbol _mysql_sqlstate@4
mysql.obj : error LNK2001: unresolved external symbol _mysql_sqlstate@4
dbdimp.obj : error LNK2001: unresolved external symbol _mysql_commit@4
dbdimp.obj : error LNK2001: unresolved external symbol _mysql_rollback@4
dbdimp.obj : error LNK2001: unresolved external symbol _mysql_close@4
mysql.obj : error LNK2001: unresolved external symbol _mysql_close@4
dbdimp.obj : error LNK2001: unresolved external symbol _mysql_server_end@0
dbdimp.obj : error LNK2001: unresolved external symbol _mysql_autocommit@8
dbdimp.obj : error LNK2001: unresolved external symbol _mysql_insert_id@4
dbdimp.obj : error LNK2001: unresolved external symbol _mysql_info@4
dbdimp.obj : error LNK2001: unresolved external symbol _mysql_get_proto_info@4
dbdimp.obj : error LNK2001: unresolved external symbol _mysql_stat@4
dbdimp.obj : error LNK2001: unresolved external symbol _mysql_get_server_info@4
mysql.obj : error LNK2001: unresolved external symbol _mysql_get_server_info@4
dbdimp.obj : error LNK2001: unresolved external symbol _mysql_thread_id@4
dbdimp.obj : error LNK2001: unresolved external symbol _mysql_get_host_info@4
dbdimp.obj : error LNK2001: unresolved external symbol _mysql_stmt_param_count@4
dbdimp.obj : error LNK2001: unresolved external symbol _mysql_stmt_close@4
mysql.obj : error LNK2001: unresolved external symbol _mysql_stmt_close@4
dbdimp.obj : error LNK2001: unresolved external symbol _mysql_stmt_errno@4
mysql.obj : error LNK2001: unresolved external symbol _mysql_stmt_errno@4
dbdimp.obj : error LNK2001: unresolved external symbol _mysql_stmt_error@4
mysql.obj : error LNK2001: unresolved external symbol _mysql_stmt_error@4
dbdimp.obj : error LNK2001: unresolved external symbol _mysql_stmt_prepare@12
mysql.obj : error LNK2001: unresolved external symbol _mysql_stmt_prepare@12
dbdimp.obj : error LNK2001: unresolved external symbol _mysql_stmt_init@4
mysql.obj : error LNK2001: unresolved external symbol _mysql_stmt_init@4
dbdimp.obj : error LNK2001: unresolved external symbol _mysql_next_result@4
mysql.obj : error LNK2001: unresolved external symbol _mysql_next_result@4
dbdimp.obj : error LNK2001: unresolved external symbol _mysql_free_result@4
mysql.obj : error LNK2001: unresolved external symbol _mysql_free_result@4
dbdimp.obj : error LNK2001: unresolved external symbol _mysql_field_count@4
dbdimp.obj : error LNK2001: unresolved external symbol _mysql_use_result@4
mysql.obj : error LNK2001: unresolved external symbol _mysql_use_result@4
dbdimp.obj : error LNK2001: unresolved external symbol _mysql_num_fields@4
dbdimp.obj : error LNK2001: unresolved external symbol _mysql_affected_rows@4
dbdimp.obj : error LNK2001: unresolved external symbol _mysql_store_result@4
dbdimp.obj : error LNK2001: unresolved external symbol _mysql_warning_count@4
dbdimp.obj : error LNK2001: unresolved external symbol _mysql_more_results@4
dbdimp.obj : error LNK2001: unresolved external symbol _mysql_num_rows@4
mysql.obj : error LNK2001: unresolved external symbol _mysql_num_rows@4
dbdimp.obj : error LNK2001: unresolved external symbol _mysql_real_query@12
mysql.obj : error LNK2001: unresolved external symbol _mysql_real_query@12
dbdimp.obj : error LNK2001: unresolved external symbol _mysql_list_fields@12
dbdimp.obj : error LNK2001: unresolved external symbol _mysql_real_escape_string @16
.
.
.
.
.

blib\arch\auto\DBD\mysql\mysql.dll : fatal error LNK1120: 63 unresolved externals
NMAKE : fatal error U1077: 'C:\WINDOWS\system32\cmd.exe' : return code '0x1' Stop.

Can you please help me solve this problem?

In reply to DBD::mysql module installation error by premal

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.