hi,
right now I am having a bit of a problem getting this built.
I have installed built perl 5.20 using perlbrew and gcc-4.8.1.
# perl -v
This is perl 5, version 20, subversion 0 (v5.20.0) built for
i86pc-solaris-thread-multi-64int
Then cpanm failed because it could not find the path to mysql_config. No
problem, I can set it:
===========================================================================
# perl Makefile.PL --mysql_config=/usr/local/mysql/5.6/bin/mysql_config
--cflags="-m32"
PLEASE NOTE:
For 'make test' to run properly, you must ensure that the
database user '' 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.
mysql> grant all privileges on test.* to ''@'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 (User's choice) = -m32
embedded (mysql_config ) =
ldflags (mysql_config ) = -R/usr/local/mysql/5.6/lib
libs (mysql_config ) = -L/usr/local/mysql/5.6/lib -lmysqlclient
-lsocket -lnsl -lm -lssl -lcrypto
mysql_config (Users choice ) = /usr/local/mysql/5.6/bin/mysql_config
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
ssl (guessed ) = 1
testdb (default ) = test
testhost (default ) =
testpassword (default ) =
testport (default ) =
testsocket (default ) =
testuser (guessed ) =
To change these settings, see 'perl Makefile.PL --help' and
'perldoc DBD::mysql::INSTALL'.
Using DBI 1.631 (for perl 5.020000 on i86pc-solaris-thread-multi-64int)
installed in
/opt/perl5//perls/perl-5.20.0/lib/site_perl/5.20.0/i86pc-solaris-thread-multi-64int/auto/DBI/
Generating a Unix-style Makefile
Writing Makefile for DBD::mysql
Writing MYMETA.yml and MYMETA.json
=========================================================================================
But then it make fails:
=========================================================================================
make
Skip blib/lib/DBD/mysql/INSTALL.pod (unchanged)
Skip blib/lib/DBD/mysql.pm (unchanged)
Skip blib/lib/Bundle/DBD/mysql.pm (unchanged)
Skip blib/lib/DBD/README.pod (unchanged)
Skip blib/lib/DBD/mysql/GetInfo.pm (unchanged)
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
gcc -c
-I/opt/perl5/perls/perl-5.20.0/lib/site_perl/5.20.0/i86pc-solaris-thread-multi-64int/auto/DBI
-m32 -DDBD_MYSQL_WITH_SSL -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -D_REENTRANT
-DPTR_IS_LONG -fno-stack-protector -fwrapv -fno-strict-aliasing -pipe
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DPERL_USE_SAFE_PUTENV -O
-DVERSION=\"4.027\" -DXS_VERSION=\"4.027\" -fPIC
"-I/opt/perl5/perls/perl-5.20.0/lib/5.20.0/i86pc-solaris-thread-multi-64int/CORE"
dbdimp.c
In file included from dbdimp.c:20:0:
dbdimp.h:21:49: fatal error: mysql.h: No such file or directory
#include <mysql.h> /* Comes with MySQL-devel */
^
compilation terminated.
make: *** [dbdimp.o] Error 1
=====================================================================================================
so it cannot find the header. But it is there, this is what mysql_config
tells me:
# ./mysql_config
Usage: ./mysql_config [OPTIONS]
Options:
--cflags [-I/usr/local/mysql/5.6/include -m64 -fPIC -g
-fabi-version=2 -fno-omit-frame-pointer -fno-strict-aliasing]
--cxxflags [-I/usr/local/mysql/5.6/include -m64 -fPIC -g
-fabi-version=2 -fno-omit-frame-pointer -fno-strict-aliasing]
--include [-I/usr/local/mysql/5.6/include]
--libs [-L/usr/local/mysql/5.6/lib
-R/usr/local/mysql/5.6/lib -lmysqlclient -lsocket -lnsl -lm -lssl -lcrypto]
--libs_r [-L/usr/local/mysql/5.6/lib
-R/usr/local/mysql/5.6/lib -lmysqlclient_r -lsocket -lnsl -lm -lssl
-lcrypto]
--plugindir [/usr/local/mysql/5.6/lib/plugin]
--socket [/var/mysql/5.6/run/mysqld.socket]
--port [0]
--version [5.6.17]
--libmysqld-libs [-L/usr/local/mysql/5.6/lib
-R/usr/local/mysql/5.6/lib -lmysqld -lnsl -lm -lssl -lcrypto -lsocket]
--variable=VAR VAR is one of:
pkgincludedir [/usr/local/mysql/5.6/include]
pkglibdir [/usr/local/mysql/5.6/lib]
plugindir [/usr/local/mysql/5.6/lib/plugin]
And if I look in the include dir, sure there it is:
root@zone1:/usr/local/mysql/5.6/bin# ls -l ../include/mysql.h
-rw-r--r-- 1 root bin 29058 Jun 15 16:56 ../include/mysql.h
Not really sure how to build this. Any tips greatly appreciated.
--
Groeten,
natxo
