Skip Menu |

This queue is for tickets about the DBD-mysql CPAN distribution.

Report information
The Basics
Id: 124286
Status: new
Priority: 0/
Queue: DBD-mysql

Owner: Nobody in particular
Requestors: HMBRAND [...]

Bug Information
Severity: Critical
Broken in: 4.044
Fixed in: (no value)

Subject: Won't build - SSL_MODE_PREFERRED undefined
Download (untitled) / with headers
text/plain 5.7k
I scanned several systems, but SSL_MODE_PREFERRED is not defined anywhere in /usr/include $ rpm -qa | grep -i -e mariadb -e mysql | sort libmariadb3-3.0.2-4.2.x86_64 libmariadb-devel-3.0.2-4.2.x86_64 libmysqlcppconn7-1.1.9-2.2.x86_64 libmysqld19-10.2.12-2.1.x86_64 libQt5Sql5-mysql-5.10.0-2.2.x86_64 libreoffice-base-drivers-mysql- mariadb-10.2.12-2.1.x86_64 mariadb-bench-10.2.12-2.1.x86_64 mariadb-client-10.2.12-2.1.x86_64 mariadb-connector-odbc-3.0.2-4.1.x86_64 mariadb-errormessages-10.2.12-2.1.noarch mariadb-tools-10.2.12-2.1.x86_64 mysql-connector-java-5.1.43-3.1.noarch perl-DBD-mysql-4.043-3.2.x86_64 php7-mysql-7.2.1-1.1.x86_64 $ rpm -q openssl openssl-1.1.0g-1.1.noarch $ mysql --version mysql Ver 15.1 Distrib 10.2.12-MariaDB, for Linux (x86_64) using readline 5.1 $ perl -v | fgrep 5.2 This is perl 5, version 26, subversion 0 (v5.26.0) built for x86_64-linux-thread-multi-ld This machine: Linux 4.14.15-1-default [openSUSE Tumbleweed 20180129] HP ZBook 15G3 Core(TM) i7-6820HQ CPU @ 2.70GHz/1079(8 cores) x86_64 15963 Mb $ perl -MV=DBI DBI /pro/lib/perl5/site_perl/5.26.0/x86_64-linux-thread-multi-ld/ 1.640 $ perl Makefile.PL PLEASE NOTE: For 'make test' to run properly, you must ensure that the database user 'merijn' 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 'merijn'@'localhost' identified by 's3kr1t';
You can also optionally set the user to run 'make test' with: perl Makefile.PL --testuser=username mysql_config: unrecognized option '--embedded' I will use the following settings for compiling and testing: cflags (mysql_config) = -I/usr/include/mysql -I/usr/include/mysql/mariadb embedded (guessed ) = ldflags (guessed ) = libs (mysql_config) = -L/usr/lib64 -lmariadb -lpthread -ldl -lm -lssl -lcrypto 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 ) = merijn 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.64 (for perl 5.026000 on x86_64-linux-thread-multi-ld) installed in /pro/lib/perl5/site_perl/5.26.0/x86_64-linux-thread-multi-ld/auto/DBI/ Generating a Unix-style Makefile Writing Makefile for DBD::mysql Writing MYMETA.yml and MYMETA.json $ make cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod cp lib/DBD/mysql/ blib/lib/DBD/mysql/ cp lib/Bundle/DBD/ blib/lib/Bundle/DBD/ cp lib/DBD/ blib/lib/DBD/ Running Mkbootstrap for mysql () chmod 644 "" "/data/pro/bin/perl5.26.0" -MExtUtils::Command::MM -e 'cp_nonempty' -- blib/arch/auto/DBD/mysql/ 644 cc -c -I/pro/lib/perl5/site_perl/5.26.0/x86_64-linux-thread-multi-ld/auto/DBI -I/usr/include/mysql -I/usr/include/mysql/mariadb -DDBD_MYSQL_WITH_SSL -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -D_REENTRANT -D_GNU_SOURCE -fPIC -fwrapv -fno-strict-aliasing -pipe -fstack-protector-strong -I/pro/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\"4.044\" -DXS_VERSION=\"4.044\" -fPIC "-I/pro/lib/perl5/5.26.0/x86_64-linux-thread-multi-ld/CORE" dbdimp.c dbdimp.c: In function ‘mysql_dr_connect’: dbdimp.c:1987:22: error: ‘SSL_MODE_PREFERRED’ undeclared (first use in this function); did you mean ‘SO_PEERCRED’? ssl_mode = SSL_MODE_PREFERRED; ^~~~~~~~~~~~~~~~~~ SO_PEERCRED dbdimp.c:1987:22: note: each undeclared identifier is reported only once for each function it appears in dbdimp.c:1989:19: error: ‘SSL_MODE_VERIFY_IDENTITY’ undeclared (first use in this function); did you mean ‘SSL_MODE_PREFERRED’? ssl_mode = SSL_MODE_VERIFY_IDENTITY; ^~~~~~~~~~~~~~~~~~~~~~~~ SSL_MODE_PREFERRED dbdimp.c:1991:19: error: ‘SSL_MODE_VERIFY_CA’ undeclared (first use in this function); did you mean ‘SSL_MODE_VERIFY_IDENTITY’? ssl_mode = SSL_MODE_VERIFY_CA; ^~~~~~~~~~~~~~~~~~ SSL_MODE_VERIFY_IDENTITY dbdimp.c:1993:19: error: ‘SSL_MODE_REQUIRED’ undeclared (first use in this function); did you mean ‘SSL_MODE_PREFERRED’? ssl_mode = SSL_MODE_REQUIRED; ^~~~~~~~~~~~~~~~~ SSL_MODE_PREFERRED dbdimp.c:1994:30: error: ‘MYSQL_OPT_SSL_MODE’ undeclared (first use in this function); did you mean ‘MYSQL_OPT_SSL_CRL’? if (mysql_options(sock, MYSQL_OPT_SSL_MODE, &ssl_mode) != 0) { ^~~~~~~~~~~~~~~~~~ MYSQL_OPT_SSL_CRL dbdimp.c:2072:30: error: ‘SSL_MODE_DISABLED’ undeclared (first use in this function); did you mean ‘SSL_MODE_REQUIRED’? unsigned int ssl_mode = SSL_MODE_DISABLED; ^~~~~~~~~~~~~~~~~ SSL_MODE_REQUIRED dbdimp.c:2125:13: error: ‘MYSQL {aka struct st_mysql}’ has no member named ‘reconnect’ result->reconnect=0; ^~ dbdimp.c: In function ‘mysql_describe’: dbdimp.c:3967:22: warning: assignment from incompatible pointer type [-Wincompatible-pointer-types] buffer->is_null= (my_bool*) &(fbh->is_null); ^ dbdimp.c:3968:20: warning: assignment from incompatible pointer type [-Wincompatible-pointer-types] buffer->error= (my_bool*) &(fbh->error); ^ make: *** [Makefile:353: dbdimp.o] Error 1

This service is sponsored and maintained by Best Practical Solutions and runs on infrastructure.

Please report any issues with to