Bug #119081 for DBD-mysql: DBD-mysql CPAN shell install fail

Wed Nov 30 16:23:33 2016 Chris.Gefvert [...] fisglobal.com - Ticket created

Subject:	DBD-mysql CPAN shell install fail
Date:	Wed, 30 Nov 2016 21:22:08 +0000
To:	"bug-DBD-mysql [...] rt.cpan.org" <bug-DBD-mysql [...] rt.cpan.org>
From:	"Gefvert, Chris" <Chris.Gefvert [...] fisglobal.com>

I'll apologize advance for any breaking of decorum, since this is my first submission. Platform AIX 7.2 on IBM power8 # perl -v This is perl 5, version 20, subversion 1 (v5.20.1) built for aix-thread-multi Copyright 1987-2014, Larry Wall Perl may be copied only under the terms of either the Artistic License or the GNU General Public License, which may be found in the Perl 5 source kit. Complete documentation for Perl, including FAQ lists, should be found on this system using "man perl" or "perldoc perl". If you have access to the Internet, point your browser at http://www.perl.org/, the Perl Home Page. # perl -MCPAN -e shell Terminal does not support AddHistory. cpan shell -- CPAN exploration and modules installation (v2.05) Enter 'h' for help. cpan[1]> install DBD::mysql Reading '/home/cgefvert/.cpan/Metadata' Database was generated on Wed, 30 Nov 2016 16:53:54 GMT Running install for module 'DBD::mysql' Checksum for /home/cgefvert/.cpan/sources/authors/id/M/MI/MICHIELB/DBD-mysql-4.041.tar.gz ok Scanning cache /home/cgefvert/.cpan/build for sizes ............................................................................DONE 'YAML' not installed, will not store persistent state Configuring M/MI/MICHIELB/DBD-mysql-4.041.tar.gz with Makefile.PL PLEASE NOTE: For 'make test' to run properly, you must ensure that the database user 'cgefvert' 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. Show quoted text

mysql> grant all privileges on test.* to 'cgefvert'@'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/mysql/include -q64 -ma -qstrict -qoptimize=2 -qmaxmem=8192 embedded (mysql_config) = ldflags (guessed ) = libs (mysql_config) = -L/usr/local/mysql/lib -lmysqlclient -lcrypt -lnsl_r -lm 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 ) = cgefvert To change these settings, see 'perl Makefile.PL --help' and 'perldoc DBD::mysql::INSTALL'. Checking if your kit is complete... Looks good Using DBI 1.636 (for perl 5.020001 on aix-thread-multi) installed in /usr/opt/perl5/lib/site_perl/5.20.1/aix-thread-multi/auto/DBI/ Generating a Unix-style Makefile Writing Makefile for DBD::mysql Wide character in print at /usr/opt/perl5/lib/5.20.1/ExtUtils/MakeMaker.pm line 1167. Wide character in print at /usr/opt/perl5/lib/5.20.1/ExtUtils/MakeMaker.pm line 1167. Writing MYMETA.yml and MYMETA.json MICHIELB/DBD-mysql-4.041.tar.gz /usr/opt/perl5/bin/perl Makefile.PL -- OK Running make for M/MI/MICHIELB/DBD-mysql-4.041.tar.gz cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm /usr/opt/perl5/bin/perl -e 'use ExtUtils::Mksymlists; Mksymlists("NAME" => "DBD::mysql", "DL_FUNCS" => { }, "FUNCLIST" => [], "DL_VARS" => []);' Running Mkbootstrap for DBD::mysql () chmod 644 mysql.bs xlc_r -q32 -c -I/usr/opt/perl5/lib/site_perl/5.20.1/aix-thread-multi/auto/DBI -I/usr/local/mysql/include -q64 -ma -qstrict -qoptimize=2 -qmaxmem=8192 -DDBD_MYSQL_WITH_SSL -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=-1 -qnoansialias -qlanglvl=extc99 -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT -q32 -D_LARGE_FILES -O -DVERSION=\"4.041\" -DXS_VERSION=\"4.041\" "-I/usr/opt/perl5/lib/5.20.1/aix-thread-multi/CORE" dbdimp.c "dbdimp.c", line 351.8: 1506-045 (S) Undeclared identifier MYSQL_TYPE_DOUBLE. "dbdimp.c", line 351.8: 1506-051 (S) Case expression must be a valid integral constant. "dbdimp.c", line 352.8: 1506-045 (S) Undeclared identifier MYSQL_TYPE_FLOAT. "dbdimp.c", line 352.8: 1506-051 (S) Case expression must be a valid integral constant. "dbdimp.c", line 356.8: 1506-045 (S) Undeclared identifier MYSQL_TYPE_SHORT. "dbdimp.c", line 356.8: 1506-051 (S) Case expression must be a valid integral constant. "dbdimp.c", line 357.8: 1506-045 (S) Undeclared identifier MYSQL_TYPE_TINY. "dbdimp.c", line 357.8: 1506-051 (S) Case expression must be a valid integral constant. "dbdimp.c", line 358.8: 1506-045 (S) Undeclared identifier MYSQL_TYPE_LONG. "dbdimp.c", line 358.8: 1506-051 (S) Case expression must be a valid integral constant. "dbdimp.c", line 359.8: 1506-045 (S) Undeclared identifier MYSQL_TYPE_INT24. "dbdimp.c", line 359.8: 1506-051 (S) Case expression must be a valid integral constant. "dbdimp.c", line 360.8: 1506-045 (S) Undeclared identifier MYSQL_TYPE_YEAR. "dbdimp.c", line 360.8: 1506-051 (S) Case expression must be a valid integral constant. "dbdimp.c", line 378.8: 1506-045 (S) Undeclared identifier MYSQL_TYPE_DECIMAL. "dbdimp.c", line 378.8: 1506-051 (S) Case expression must be a valid integral constant. "dbdimp.c", line 383.8: 1506-045 (S) Undeclared identifier MYSQL_TYPE_LONGLONG. "dbdimp.c", line 383.8: 1506-051 (S) Case expression must be a valid integral constant. "dbdimp.c", line 385.8: 1506-045 (S) Undeclared identifier MYSQL_TYPE_DATE. "dbdimp.c", line 385.8: 1506-051 (S) Case expression must be a valid integral constant. "dbdimp.c", line 386.8: 1506-045 (S) Undeclared identifier MYSQL_TYPE_TIME. "dbdimp.c", line 386.8: 1506-051 (S) Case expression must be a valid integral constant. "dbdimp.c", line 387.8: 1506-045 (S) Undeclared identifier MYSQL_TYPE_DATETIME. "dbdimp.c", line 387.8: 1506-051 (S) Case expression must be a valid integral constant. "dbdimp.c", line 388.8: 1506-045 (S) Undeclared identifier MYSQL_TYPE_NEWDATE. "dbdimp.c", line 388.8: 1506-051 (S) Case expression must be a valid integral constant. "dbdimp.c", line 389.8: 1506-045 (S) Undeclared identifier MYSQL_TYPE_TIMESTAMP. "dbdimp.c", line 389.8: 1506-051 (S) Case expression must be a valid integral constant. "dbdimp.c", line 390.8: 1506-045 (S) Undeclared identifier MYSQL_TYPE_VAR_STRING. "dbdimp.c", line 390.8: 1506-051 (S) Case expression must be a valid integral constant. "dbdimp.c", line 394.8: 1506-045 (S) Undeclared identifier MYSQL_TYPE_STRING. "dbdimp.c", line 394.8: 1506-051 (S) Case expression must be a valid integral constant. "dbdimp.c", line 401.8: 1506-045 (S) Undeclared identifier MYSQL_TYPE_BLOB. "dbdimp.c", line 401.8: 1506-051 (S) Case expression must be a valid integral constant. "dbdimp.c", line 402.8: 1506-045 (S) Undeclared identifier MYSQL_TYPE_TINY_BLOB. "dbdimp.c", line 402.8: 1506-051 (S) Case expression must be a valid integral constant. "dbdimp.c", line 1732.31: 1506-045 (S) Undeclared identifier MYSQL_OPT_WRITE_TIMEOUT. "dbdimp.c", line 1743.31: 1506-045 (S) Undeclared identifier MYSQL_OPT_READ_TIMEOUT. "dbdimp.c", line 1754.31: 1506-045 (S) Undeclared identifier MYSQL_SECURE_AUTH. "dbdimp.c", line 3729.12: 1506-045 (S) Undeclared identifier use_server_side_prepare. "dbdimp.c", line 4251.14: 1506-045 (S) Undeclared identifier MYSQL_TYPE_DOUBLE. "dbdimp.c", line 4251.14: 1506-051 (S) Case expression must be a valid integral constant. "dbdimp.c", line 4257.14: 1506-045 (S) Undeclared identifier MYSQL_TYPE_LONG. "dbdimp.c", line 4257.14: 1506-051 (S) Case expression must be a valid integral constant. "dbdimp.c", line 4258.14: 1506-045 (S) Undeclared identifier MYSQL_TYPE_LONGLONG. "dbdimp.c", line 4258.14: 1506-051 (S) Case expression must be a valid integral constant. make: 1254-004 The error code from the last command is 1. Stop. MICHIELB/DBD-mysql-4.041.tar.gz /usr/bin/make -- NOT OK Failed during this command: MICHIELB/DBD-mysql-4.041.tar.gz : make NO Chris Gefvert System Administrator / Developer Wealth Management and Retirement T: 610.251.6688 C: 484.639.4028 E: chris.gefvert@fisglobal.com<mailto:chris.gefvert@fisglobal.com> FIS | Empowering the Financial World [cid:image005.png@01D11265.2C7F1D60] <https://www.facebook.com/FIStoday> [cid:image006.png@01D11265.2C7F1D60] <https://twitter.com/FISGlobal> [cid:image007.png@01D11265.2C7F1D60] <https://www.linkedin.com/company/fis> Show quoted text

_____________ The information contained in this message is proprietary and/or confidential. If you are not the intended recipient, please: (i) delete the message and all copies; (ii) do not disclose, distribute or use the message in any manner; and (iii) notify the sender immediately. In addition, please be aware that any message addressed to our domain is subject to archiving and review by persons other than the intended recipient. Thank you.

Message body is not shown because it is too large.

Download image001.png
image/png 572b

Download image002.png
image/png 656b

Download image003.png
image/png 576b

Wed Nov 30 16:30:36 2016 MICHIELB [...] cpan.org - Correspondence added

Hi Chris, You seem to be missing the header files for libmysqlclient for AIX 7.2. AIX seems not to be a platform that is distributed from http://dev.mysql.com/downloads/connector/c/ - you can either try to compile libmysqlclient from source or try to get a compiled client + header files from your UNIX vendor. Please let me know if this helps! -- Michiel

Wed Nov 30 16:30:37 2016 The RT System itself - Status changed from 'new' to 'open'

Wed Nov 30 16:30:42 2016 MICHIELB [...] cpan.org - Taken

Wed Nov 30 16:36:05 2016 Chris.Gefvert [...] fisglobal.com - Correspondence added

Subject:	RE: [rt.cpan.org #119081] DBD-mysql CPAN shell install fail
Date:	Wed, 30 Nov 2016 21:35:05 +0000
To:	"bug-DBD-mysql [...] rt.cpan.org" <bug-DBD-mysql [...] rt.cpan.org>
From:	"Gefvert, Chris" <Chris.Gefvert [...] fisglobal.com>

Thanks for pointing me in the right direction. Chris Gefvert System Administrator / Developer Wealth Management and Retirement T: 610.251.6688 C: 484.639.4028 E: chris.gefvert@fisglobal.com FIS | Empowering the Financial World Show quoted text

-----Original Message----- From: Michiel Beijen via RT [mailto:bug-DBD-mysql@rt.cpan.org] Sent: Wednesday, November 30, 2016 4:31 PM To: Gefvert, Chris <Chris.Gefvert@fisglobal.com> Subject: [rt.cpan.org #119081] DBD-mysql CPAN shell install fail <URL: https://rt.cpan.org/Ticket/Display.html?id=119081 > Hi Chris, You seem to be missing the header files for libmysqlclient for AIX 7.2. AIX seems not to be a platform that is distributed from https://urldefense.proofpoint.com/v2/url?u=http-3A__dev.mysql.com_downloads_connector_c_&d=BQIDaQ&c=3BfiSO86x5iKjpl2b39jud9R1NrKYqPq2js90dwBswk&r=3PcFjtE9BuGYAt8XrPGomgNnyuIrx0v2yk6pGFLZn4c&m=uYQhB369HqTZ2Bu3zaPYd9AYzPn8phsX2LHoFok79Sg&s=enFqXiv62eSADVBXo1Tukg-yX8WNbyH8fpSUNUXR7ug&e= - you can either try to compile libmysqlclient from source or try to get a compiled client + header files from your UNIX vendor. Please let me know if this helps! -- Michiel

_____________ The information contained in this message is proprietary and/or confidential. If you are not the intended recipient, please: (i) delete the message and all copies; (ii) do not disclose, distribute or use the message in any manner; and (iii) notify the sender immediately. In addition, please be aware that any message addressed to our domain is subject to archiving and review by persons other than the intended recipient. Thank you.

Thu Dec 01 07:48:34 2016 pali [...] cpan.org - Cc PALI added

Thu Dec 01 07:49:04 2016 pali [...] cpan.org - Correspondence added

Hi! Which version of mysql are you using?

Thu Dec 01 08:35:47 2016 Chris.Gefvert [...] fisglobal.com - Correspondence added

CC:	"pali [...] cpan.org" <pali [...] cpan.org>
Subject:	RE: [rt.cpan.org #119081] DBD-mysql CPAN shell install fail
Date:	Thu, 1 Dec 2016 13:34:51 +0000
To:	"bug-DBD-mysql [...] rt.cpan.org" <bug-DBD-mysql [...] rt.cpan.org>
From:	"Gefvert, Chris" <Chris.Gefvert [...] fisglobal.com>

Trying to install DBD-mysql-4.041. My mysql server is mysql Ver 14.14 Distrib 5.6.28, for debian-linux-gnu (ppc64le) using EditLine wrapper I did get this reply from Michiel Beijen via RT <bug-DBD-mysql@rt.cpan.org<mailto:bug-DBD-mysql@rt.cpan.org>> yesterday, so I’m chasing gown the libmysqlclient angle. Hi Chris, You seem to be missing the header files for libmysqlclient for AIX 7.2. AIX seems not to be a platform that is distributed from https://urldefense.proofpoint.com/v2/url?u=http-A__dev.mysql.com_downloads_connector_c_&d=BQIDaQ&c=3BfiSO86x5iKjpl2b39jud9R1NrKYqPq2js90dwBswk&r=3PcFjtE9BuGYAt8XrPGomgNnyuIrx0v2yk6pGFLZn4c&m=uYQhB369HqTZ2Bu3zaPYd9AYzPn8phsX2LHoFok79Sg&s=enFqXiv62eSADVBXo1Tukg-X8WNbyH8fpSUNUXR7ug&e= - you can either try to compile libmysqlclient from source or try to get a compiled client + header files from your UNIX vendor. Chris Gefvert System Administrator / Developer Wealth Management and Retirement T: 610.251.6688 C: 484.639.4028 E: chris.gefvert@fisglobal.com FIS | Empowering the Financial World Show quoted text

-----Original Message----- From: Pali via RT [mailto:bug-DBD-mysql@rt.cpan.org] Sent: Thursday, December 01, 2016 7:49 AM To: Gefvert, Chris <Chris.Gefvert@fisglobal.com> Cc: pali@cpan.org Subject: [rt.cpan.org #119081] DBD-mysql CPAN shell install fail <URL: https://rt.cpan.org/Ticket/Display.html?id=119081 > Hi! Which version of mysql are you using?

_____________ The information contained in this message is proprietary and/or confidential. If you are not the intended recipient, please: (i) delete the message and all copies; (ii) do not disclose, distribute or use the message in any manner; and (iii) notify the sender immediately. In addition, please be aware that any message addressed to our domain is subject to archiving and review by persons other than the intended recipient. Thank you.

Mon Dec 12 15:56:37 2016 MICHIELB [...] cpan.org - Correspondence added

Rejecting - not a bug in DBD::mysql but setup issue (no header files).

Mon Dec 12 15:56:38 2016 MICHIELB [...] cpan.org - Status changed from 'open' to 'rejected'