Bug #73856 for DBD-mysql: Failure in "make test"

perl Makefile.PL succeeded make succeeded make test failed -- Dynaloader could not find "compress". I'm not sure what to do about that. Details are in the downloaded text file. I set up the recommended environment variables, although some changes were needed, it appears. The documentation is vague on that issue.

DBD::mysql Installation Failure wbarrett1076@comcast.net This was on an Ubuntu 11.10 platform Perl vs. 5.12.2 gcc (Ubuntu/Linaro 4.6.1-9ubuntu3) 4.6.1 mysql Ver 14.7 Distrib 4.1.7, for pc-linux (i686) I followed the Linux installation procedure "INSTALLATION" on http://search.cpan.org/~capttofu/DBD-mysql-4.020/lib/DBD/mysql.pm The environment variables didn't match the installation locations, so I changed some of them. See "Environment variables" below. PATH was extended to include the mysql binary directory /usr/local/mysql/bin. These changes enabled building makefile and compilation, but 'make test' failed. The C compiler generated several warnings: gcc: warning: ‘-mcpu=’ is deprecated; use ‘-mtune=’ or ‘-march=’ instead mysql.xs: In function ‘XS_DBD__mysql__db_do’: mysql.xs:307:19: warning: format ‘%d’ expects argument of type ‘int’, but argument 4 has type ‘struct SV *’ [-Wformat] Main failure seems to be in "make test", the last stuff below. Complaint is a missing "compress" function. I verified that mysql.so is in place: wbarrett@holmes:~/Downloads/DBD-mysql-4.020/blib/arch/auto/DBD/mysql$ ls -l total 1360 -rw-r--r-- 1 wbarrett wbarrett 0 2012-01-09 13:01 mysql.bs -rwxr-xr-x 1 wbarrett wbarrett 1392284 2012-01-09 13:01 mysql.so Environment variables: ----------------- DBD_MYSQL_CONFIG=mysql_config SSH_AGENT_PID=1594 GPG_AGENT_INFO=/tmp/keyring-nq806s/gpg:0:1 SHELL=/bin/bash TERM=xterm XDG_SESSION_COOKIE=d4a9c99a340211fdb2c4acf50000000e-1326135956.305016-1717660550 DBD_MYSQL_TESTHOST=localhost CRSCPW=creator WINDOWID=27262981 GNOME_KEYRING_CONTROL=/tmp/keyring-nq806s SERVER_PORT=22 X_WCHAR=1 GTK_MODULES=canberra-gtk-module:canberra-gtk-module USER=wbarrett LS_COLORS=rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01;31:*.lz=01;31:*.xz=01;31:*.bz2=01;31:*.bz=01;31:*.tbz=01;31:*.tbz2=01;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.rar=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.cgm=01;35:*.emf=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=00;36:*.au=00;36:*.flac=00;36:*.mid=00;36:*.midi=00;36:*.mka=00;36:*.mp3=00;36:*.mpc=00;36:*.ogg=00;36:*.ra=00;36:*.wav=00;36:*.axa=00;36:*.oga=00;36:*.spx=00;36:*.xspf=00;36: DBD_MYSQL_LIBS=-L/usr/local/mysql/lib -lmysqlclient XDG_SESSION_PATH=/org/freedesktop/DisplayManager/Session0 XDG_SEAT_PATH=/org/freedesktop/DisplayManager/Seat0 DBD_MYSQL_EMBEDDED= SSH_AUTH_SOCK=/tmp/keyring-nq806s/ssh WHICH_GRADER=grader DBD_MYSQL_CFLAGS=-I/usr/local/mysql/include SESSION_MANAGER=local/holmes:@/tmp/.ICE-unix/1556,unix/holmes:/tmp/.ICE-unix/1556 USERNAME=wbarrett DEFAULTS_PATH=/usr/share/gconf/xsession.default.path DBD_MYSQL_TESTDB=test XDG_CONFIG_DIRS=/etc/xdg/xdg-xsession:/etc/xdg PATH=/usr/local/mysql/bin:/home/wbarrett/qparser/vs25.0/unix/execs:/home/wbarrett/bin:/opt/ActivePerl-5.12/bin:/home/wbarrett/qparser/vs24.2/unix/execs:/home/wbarrett/QtSDK/QtCreator/bin:/usr/local/apache2/bin:/home/wbarrett/bin:/usr/lib/lightdm/lightdm:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:.:. DESKTOP_SESSION=xsession PWD=/home/wbarrett/Downloads/DBD-mysql-4.020 DBD_MYSQL_NOCATCHSTDERR=0 DBD_MYSQL_NOFOUNDROWS=0 LANG=en_US.UTF-8 GNOME_KEYRING_PID=1547 MANDATORY_PATH=/usr/share/gconf/xsession.mandatory.path UBUNTU_MENUPROXY=libappmenu.so QPDIR=/home/wbarrett/qparser/vs25.0/unix QTSDK=/home/wbarrett/QtSDK/QtCreator/bin GDMSESSION=xsession SHLVL=1 SERVER_NAME= HOME=/home/wbarrett DBD_MYSQL_TESTPASSWORD=bumb0zzl ADMIN_EMAIL=wbarrett1076@comcast.net GNOME_DESKTOP_SESSION_ID=this-is-deprecated QTSPIM=/home/wbarrett/QtSpim BASH_ENV=/home/wbarrett/.bashrc LOGNAME=wbarrett DBD_MYSQL_TESTUSER=wbarrett XDG_DATA_DIRS=/usr/share/xsession:/usr/share/gnome:/usr/local/share/:/usr/share/ DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-kgDVT7stmB,guid=3533ef78979380221fb5f95f0000002a LESSOPEN=| /usr/bin/lesspipe %s DBPW=bumb0zzl DBD_MYSQL_SSL= DISPLAY=:0 XDG_CURRENT_DESKTOP=Unity DBD_MYSQL_TESTPORT=3306 LESSCLOSE=/usr/bin/lesspipe %s %s XAUTHORITY=/home/wbarrett/.Xauthority COLORTERM=gnome-terminal _=/usr/bin/env OLDPWD=/home/wbarrett/Downloads --------------------------- INSTALLATION >>perl Makefile.PL I will use the following settings for compiling and testing: cflags (mysql_config) = -I/usr/local/mysql/include -mcpu=pentiumpro embedded (mysql_config) = libs (mysql_config) = -L/usr/local/mysql/lib -lmysqlclient -lcrypt -lnsl -lm -lz -lc -lnss_files -lnss_dns -lresolv -lc -lnss_files -lnss_dns -lresolv mysql_config (guessed ) = mysql_config nocatchstderr (default ) = 0 nofoundrows (default ) = 0 ssl (guessed ) = 0 testdb (environment ) = test testhost (environment ) = localhost testpassword (environment ) = bumb0zzl testsocket (default ) = testuser (environment ) = wbarrett To change these settings, see 'perl Makefile.PL --help' and 'perldoc INSTALL'. Using DBI 1.615 (for perl 5.012002 on i686-linux-thread-multi) installed in /opt/ActivePerl-5.12/lib/auto/DBI/ Writing Makefile for DBD::mysql ------------------------------------- >> make Skip blib/lib/DBD/mysql.pm (unchanged) Skip blib/lib/DBD/mysql/GetInfo.pm (unchanged) Skip blib/lib/DBD/mysql/INSTALL.pod (unchanged) Skip blib/lib/Bundle/DBD/mysql.pm (unchanged) gcc -c -I/opt/ActivePerl-5.12/lib/auto/DBI -I/usr/local/mysql/include -mcpu=pentiumpro -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -D_REENTRANT -D_GNU_SOURCE -DUSE_SITECUSTOMIZE -fno-merge-constants -fno-strict-aliasing -pipe -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\"4.020\" -DXS_VERSION=\"4.020\" -fPIC "-I/opt/ActivePerl-5.12/lib/CORE" dbdimp.c gcc -c -I/opt/ActivePerl-5.12/lib/auto/DBI -I/usr/local/mysql/include -mcpu=pentiumpro -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -D_REENTRANT -D_GNU_SOURCE -DUSE_SITECUSTOMIZE -fno-merge-constants -fno-strict-aliasing -pipe -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\"4.020\" -DXS_VERSION=\"4.020\" -fPIC "-I/opt/ActivePerl-5.12/lib/CORE" mysql.c Running Mkbootstrap for DBD::mysql () chmod 644 mysql.bs rm -f blib/arch/auto/DBD/mysql/mysql.so /opt/ActivePerl-5.12/bin/perl-static myld gcc -shared -O2 dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.so \ -L/usr/local/mysql/lib -lmysqlclient \ chmod 755 blib/arch/auto/DBD/mysql/mysql.so cp mysql.bs blib/arch/auto/DBD/mysql/mysql.bs chmod 644 blib/arch/auto/DBD/mysql/mysql.bs Manifying blib/man3/DBD::mysql.3 Manifying blib/man3/DBD::mysql::INSTALL.3 Manifying blib/man3/Bundle::DBD::mysql.3 ------------------------------ >>make test PERL_DL_NONLAZY=1 /opt/ActivePerl-5.12/bin/perl-static "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t Bailout called. Further testing stopped: Unable to load DBD::mysql # Failed test 'use DBD::mysql;' # at t/00base.t line 21. # Tried to use 'DBD::mysql'. # Error: Can't load '/home/wbarrett/Downloads/DBD-mysql-4.020/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: /home/wbarrett/Downloads/DBD-mysql-4.020/blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: compress at /opt/ActivePerl-5.12/lib/DynaLoader.pm line 201. # at (eval 9) line 2 # Compilation failed in require at (eval 9) line 2. # BEGIN failed--compilation aborted at (eval 9) line 2.