2009/11/12 宇捷 <hfahe@163.com>
先装mysql-devel。
-----邮件原件-----
发件人:
grbounce-_mwj1quaaadplfc8fq-7oyyqfcvs3wxt=hfahe=163.com@googlegroups.com
[mailto:grbounce-_mwj1quaaadplfc8fq-7oyyqfcvs3wxt=hfahe=163.com@googlegroups
.com] 代表 Felix New
发送时间: 2009年11月11日 23:23
收件人: perlchina@googlegroups.com
主题: [PerlChina] 安装DBI, DBD::mysql, make的时候报错
在linux上安装cpan模块很顺利的, 这2天想在mac(snow leopard)弄个环境, DBI和
DBD::mysal死活都搞不定.
首先是编译DBI的时候, 到DBI.xs的时候是一堆警告, 但没有退出;
而编译DBD::mysql的时候, 在dbdimp.c和DBD.xs的时候, 又是一堆警告.
虽然2个模块最后都可以make install, 但DBD::mysql最后安装的是不可用的.
问了下狗狗, 也没找到很好的答案, 大家遇到这样的出错么? 如果我缺少了什么东西,
还希望大家指点, 少走弯路. (Xcode是装了的, 系统光盘带的版本)
bash-3.2$ perl Makefile.PL
*** You are using a perl configured with threading enabled.
*** You should be aware that using multiple threads is
*** not recommended for production environments.
Your perl was compiled with gcc (version 4.2.1 (Apple Inc. build 5646)),
okay.
Creating test wrappers for DBI::PurePerl:
t/zvp_01basics.t
t/zvp_02dbidrv.t
t/zvp_03handle.t
t/zvp_04mods.t
t/zvp_05concathash.t
t/zvp_06attrs.t
********
********
t/zvxgp_80proxy.t
t/zvxgp_85gofer.t
t/zvxgp_86gofer_fail.t
t/zvxgp_87gofer_cache.t
Checking if your kit is complete...
Looks good
I see you're using perl 5.010000 on darwin-thread-multi-2level, okay.
Remember to actually *read* the README file!
Use 'make' to build the software (dmake or nmake on Windows).
Then 'make test' to execute self tests.
Then 'make install' to install the DBI and then delete this working
directory before unpacking and building any DBD::* drivers.
Writing Makefile for DBI
bash-3.2$ make
/usr/bin/perl "-MExtUtils::Command" -e mkpath blib/lib/DBI
rm -f blib/lib/DBI/Changes.pm
cp Changes blib/lib/DBI/Changes.pm
/usr/bin/perl "-MExtUtils::Command" -e mkpath blib/lib/DBI
rm -f blib/lib/DBI/Roadmap.pm
cp Roadmap.pod blib/lib/DBI/Roadmap.pm
cp Driver_xst.h blib/arch/auto/DBI/Driver_xst.h
cp lib/DBD/Proxy.pm blib/lib/DBD/Proxy.pm
cp lib/DBI/Gofer/Response.pm blib/lib/DBI/Gofer/Response.pm
cp lib/DBI/Gofer/Transport/Base.pm blib/lib/DBI/Gofer/Transport/Base.pm
cp lib/DBI/Util/_accessor.pm blib/lib/DBI/Util/_accessor.pm
cp lib/DBD/DBM.pm blib/lib/DBD/DBM.pm
cp DBIXS.h blib/arch/auto/DBI/DBIXS.h
cp Roadmap.pod blib/lib/Roadmap.pod
************
************
cp lib/DBI/ProfileData.pm blib/lib/DBI/ProfileData.pm
/usr/bin/perl -p -e "s/~DRIVER~/Perl/g" ./Driver.xst > Perl.xsi
/usr/bin/perl /System/Library/Perl/5.10.0/ExtUtils/xsubpp -typemap
/System/Library/Perl/5.10.0/ExtUtils/typemap -typemap typemap Perl.xs >
Perl.xsc && mv Perl.xsc Perl.c
gcc-4.2 -c -arch x86_64 -arch i386 -arch ppc -g -pipe -fno-common
-DPERL_DARWIN -fno-strict-aliasing -I/usr/local/include -Os -DVERSION=\"1.
609\" -DXS_VERSION=\"1.609\"
"-I/System/Library/Perl/5.10.0/darwin-thread-multi-2level/CORE" -W -Wall
-Wpointer-arith -Wbad-function-cast -Wno-comment -Wno-sign-compare
-Wno-cast-qual -Wmissing-noreturn -Wno-unused-parameter Perl.c
/usr/bin/perl /System/Library/Perl/5.10.0/ExtUtils/xsubpp -typemap
/System/Library/Perl/5.10.0/ExtUtils/typemap -typemap typemap DBI.xs > DBI.
xsc && mv DBI.xsc DBI.c
gcc-4.2 -c -arch x86_64 -arch i386 -arch ppc -g -pipe -fno-common
-DPERL_DARWIN -fno-strict-aliasing -I/usr/local/include -Os -DVERSION=\"1.
609\" -DXS_VERSION=\"1.609\"
"-I/System/Library/Perl/5.10.0/darwin-thread-multi-2level/CORE" -W -Wall
-Wpointer-arith -Wbad-function-cast -Wno-comment -Wno-sign-compare
-Wno-cast-qual -Wmissing-noreturn -Wno-unused-parameter DBI.c
DBI.xs: In function '_sort_hash_keys':
DBI.xs:260: warning: format not a string literal and no format arguments
DBI.xs:261: warning: format not a string literal and no format arguments
DBI.xs: In function 'set_err_sv':
DBI.xs:623: warning: value computed is not used
DBI.xs: In function 'dbih_setup_handle':
DBI.xs:1289: warning: value computed is not used
DBI.xs:1290: warning: value computed is not used
DBI.xs:1295: warning: value computed is not used
DBI.xs:1298: warning: value computed is not used
DBI.xs: In function 'dbih_set_attr_k':
DBI.xs:1926: warning: value computed is not used
DBI.xs: In function 'dbih_get_attr_k':
DBI.xs:2017: warning: value computed is not used
DBI.xs:2241: warning: value computed is not used
DBI.xs: In function '_profile_next_node':
DBI.xs:2447: warning: value computed is not used
DBI.xs: In function 'XS_DBI_dispatch':
DBI.xs:3000: warning: value computed is not used
DBI.xs:3075: warning: value computed is not used
DBI.xs: In function 'XS_DBI__new_handle':
DBI.xs:4092: warning: value computed is not used
DBI.xs: In function 'XS_DBD_____st_fetchrow_hashref':
DBI.xs:4801: warning: value computed is not used
DBI.xs: In function '_sort_hash_keys':
DBI.xs:260: warning: format not a string literal and no format arguments
DBI.xs:261: warning: format not a string literal and no format arguments
DBI.xs: In function 'set_err_sv':
DBI.xs:623: warning: value computed is not used
DBI.xs: In function 'dbih_setup_handle':
DBI.xs:1289: warning: value computed is not used
***********
BI.xs: In function 'XS_DBD_____st_fetchrow_hashref':
DBI.xs:4801: warning: value computed is not used
Running Mkbootstrap for DBI ()
chmod 644 DBI.bs
rm -f blib/arch/auto/DBI/DBI.bundle
gcc-4.2 -mmacosx-version-min=10.6 -arch x86_64 -arch i386 -arch ppc -bundle
-undefined dynamic_lookup -L/usr/local/lib DBI.o -o blib/arch/auto/DBI/DBI.
bundle \
\
chmod 755 blib/arch/auto/DBI/DBI.bundle
cp DBI.bs blib/arch/auto/DBI/DBI.bs
chmod 644 blib/arch/auto/DBI/DBI.bs
/usr/bin/perl "-Iblib/arch" "-Iblib/lib" dbiprof.PL dbiprof
Extracted dbiprof from dbiprof.PL with variable substitutions.
dbiprof syntax OK
cp dbiprof blib/script/dbiprof
bash-3.2$ perl Makefile.PL
PLEASE NOTE:
For 'make test' to run properly, you must ensure that the
database user 'moxnet' 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 'moxnet'@'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 -g -Os -arch
i386 -fno-common -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE
-DSIGNALS_DONT_BREAK_READ -DIGNORE_SIGHUP_SIGQUIT
-DDONT_DECLARE_CXA_PURE_VIRTUAL
embedded (mysql_config) =
libs (mysql_config) = -L/usr/local/mysql/lib -lmysqlclient -lz
-lm -lmygcc
mysql_config (guessed ) = mysql_config
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
ssl (guessed ) = 0
testdb (default ) = test
testhost (default ) =
testpassword (default ) =
testsocket (default ) =
testuser (guessed ) = moxnet
To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.
Checking if your kit is complete...
Looks good
Using DBI 1.609 (for perl 5.010000 on darwin-thread-multi-2level) installed
in /Library/Perl/5.10.0/darwin-thread-multi-2level/auto/DBI/
Writing Makefile for DBD::mysql
bash-3.2$ make
cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
gcc-4.2 -c -I/Library/Perl/5.10.0/darwin-thread-multi-2level/auto/DBI
-I/usr/local/mysql/include -g -Os -arch i386 -fno-common
-D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ
-DIGNORE_SIGHUP_SIGQUIT -DDONT_DECLARE_CXA_PURE_VIRTUAL
-DDBD_MYSQL_INSERT_ID_IS_GOOD -g -arch x86_64 -arch i386 -arch ppc -g -pipe
-fno-common -DPERL_DARWIN -fno-strict-aliasing -I/usr/local/include -Os
-DVERSION=\"4.013\" -DXS_VERSION=\"4.013\"
"-I/System/Library/Perl/5.10.0/darwin-thread-multi-2level/CORE" dbdimp.c
dbdimp.c: In function 'alloc_param':
dbdimp.c:113: warning: format not a string literal and no format arguments
dbdimp.c: In function 'alloc_bind':
dbdimp.c:131: warning: format not a string literal and no format arguments
dbdimp.c: In function 'alloc_fbind':
dbdimp.c:147: warning: format not a string literal and no format arguments
dbdimp.c: In function 'alloc_fbuffer':
dbdimp.c:162: warning: format not a string literal and no format arguments
dbdimp.c: In function 'parse_params':
dbdimp.c:477: warning: format not a string literal and no format arguments
dbdimp.c: In function 'my_login':
dbdimp.c:1796: warning: format not a string literal and no format arguments
dbdimp.c: In function 'mysql_st_internal_execute41':
dbdimp.c:3085: warning: format '%d' expects type 'int', but argument 3 has
type 'my_ulonglong'
dbdimp.c: In function 'mysql_describe':
dbdimp.c:3305: warning: format '%d' expects type 'int', but argument 5 has
type 'long unsigned int'
dbdimp.c:3309: warning: format '%d' expects type 'int', but argument 3 has
type 'long unsigned int'
dbdimp.c:3319: warning: assignment from incompatible pointer type
dbdimp.c:3320: warning: format not a string literal and no format arguments
dbdimp.c: In function 'mysql_st_fetch':
dbdimp.c:3504: warning: format not a string literal and no format arguments
dbdimp.c:3526: warning: format '%d' expects type 'int', but argument 3 has
type 'long int'
dbdimp.c:3568: warning: format '%08lx' expects type 'long unsigned int', but
argument 3 has type 'struct MYSQL_RES *'
dbdimp.c:3570: warning: format '%llu' expects type 'long long unsigned int',
but argument 3 has type 'unsigned int'
dbdimp.c: In function 'mysql_st_FETCH_attrib':
dbdimp.c:4153: warning: format '%d' expects type 'int', but argument 3 has
type 'my_ulonglong'
dbdimp.c: In function 'mysql_bind_ph':
dbdimp.c:4335: warning: format '%d' expects type 'int', but argument 3 has
type 'IV'
dbdimp.c:4353: warning: format '%d' expects type 'int', but argument 3 has
type 'IV'
dbdimp.c:4380: warning: format '%d' expects type 'int', but argument 3 has
type 'IV'
dbdimp.c: In function 'alloc_param':
dbdimp.c:113: warning: format not a string literal and no format arguments
dbdimp.c: In function 'alloc_bind':
dbdimp.c:131: warning: format not a string literal and no format arguments
dbdimp.c: In function 'alloc_fbind':
dbdimp.c:147: warning: format not a string literal and no format arguments
dbdimp.c: In function 'alloc_fbuffer':
dbdimp.c:162: warning: format not a string literal and no format arguments
dbdimp.c: In function 'parse_params':
dbdimp.c:477: warning: format not a string literal and no format arguments
dbdimp.c: In function 'my_login':
dbdimp.c:1796: warning: format not a string literal and no format arguments
dbdimp.c: In function 'mysql_st_internal_execute41':
dbdimp.c:3085: warning: format '%d' expects type 'int', but argument 3 has
type 'my_ulonglong'
dbdimp.c: In function 'mysql_describe':
dbdimp.c:3305: warning: format '%d' expects type 'int', but argument 5 has
type 'long unsigned int'
dbdimp.c:3309: warning: format '%d' expects type 'int', but argument 3 has
type 'long unsigned int'
dbdimp.c:3319: warning: assignment from incompatible pointer type
dbdimp.c:3320: warning: format not a string literal and no format arguments
dbdimp.c: In function 'mysql_st_fetch':
dbdimp.c:3504: warning: format not a string literal and no format arguments
dbdimp.c:3526: warning: format '%d' expects type 'int', but argument 3 has
type 'long int'
dbdimp.c:3568: warning: format '%08lx' expects type 'long unsigned int', but
argument 3 has type 'struct MYSQL_RES *'
dbdimp.c:3570: warning: format '%llu' expects type 'long long unsigned int',
but argument 3 has type 'unsigned int'
dbdimp.c: In function 'mysql_st_FETCH_attrib':
dbdimp.c:4153: warning: format '%d' expects type 'int', but argument 3 has
type 'my_ulonglong'
dbdimp.c: In function 'mysql_bind_ph':
dbdimp.c:4335: warning: format '%d' expects type 'int', but argument 3 has
type 'IV'
dbdimp.c:4353: warning: format '%d' expects type 'int', but argument 3 has
type 'IV'
dbdimp.c:4380: warning: format '%d' expects type 'int', but argument 3 has
type 'IV'
dbdimp.c: In function 'alloc_param':
dbdimp.c:113: warning: format not a string literal and no format arguments
dbdimp.c: In function 'alloc_bind':
dbdimp.c:131: warning: format not a string literal and no format arguments
dbdimp.c: In function 'alloc_fbind':
dbdimp.c:147: warning: format not a string literal and no format arguments
dbdimp.c: In function 'alloc_fbuffer':
dbdimp.c:162: warning: format not a string literal and no format arguments
dbdimp.c: In function 'parse_params':
dbdimp.c:477: warning: format not a string literal and no format arguments
dbdimp.c: In function 'my_login':
dbdimp.c:1796: warning: format not a string literal and no format arguments
dbdimp.c: In function 'mysql_st_internal_execute41':
dbdimp.c:3085: warning: format '%d' expects type 'int', but argument 3 has
type 'my_ulonglong'
dbdimp.c: In function 'mysql_describe':
dbdimp.c:3305: warning: format '%d' expects type 'int', but argument 5 has
type 'long unsigned int'
dbdimp.c:3309: warning: format '%d' expects type 'int', but argument 3 has
type 'long unsigned int'
dbdimp.c:3319: warning: assignment from incompatible pointer type
dbdimp.c:3320: warning: format not a string literal and no format arguments
dbdimp.c: In function 'mysql_st_fetch':
dbdimp.c:3504: warning: format not a string literal and no format arguments
dbdimp.c:3526: warning: format '%d' expects type 'int', but argument 3 has
type 'long int'
dbdimp.c:3568: warning: format '%08lx' expects type 'long unsigned int', but
argument 3 has type 'struct MYSQL_RES *'
dbdimp.c:3570: warning: format '%llu' expects type 'long long unsigned int',
but argument 3 has type 'unsigned int'
dbdimp.c: In function 'mysql_st_FETCH_attrib':
dbdimp.c:4153: warning: format '%d' expects type 'int', but argument 3 has
type 'my_ulonglong'
dbdimp.c: In function 'mysql_bind_ph':
dbdimp.c:4335: warning: format '%d' expects type 'int', but argument 3 has
type 'IV'
dbdimp.c:4353: warning: format '%d' expects type 'int', but argument 3 has
type 'IV'
dbdimp.c:4380: warning: format '%d' expects type 'int', but argument 3 has
type 'IV'
/usr/bin/perl -p -e "s/~DRIVER~/mysql/g"
/Library/Perl/5.10.0/darwin-thread-multi-2level/auto/DBI/Driver.xst > mysql.
xsi
/usr/bin/perl /System/Library/Perl/5.10.0/ExtUtils/xsubpp -typemap
/System/Library/Perl/5.10.0/ExtUtils/typemap mysql.xs > mysql.xsc && mv
mysql.xsc mysql.c
Warning: duplicate function definition 'do' detected in mysql.xs, line 225
Warning: duplicate function definition 'rows' detected in mysql.xs, line 650
gcc-4.2 -c -I/Library/Perl/5.10.0/darwin-thread-multi-2level/auto/DBI
-I/usr/local/mysql/include -g -Os -arch i386 -fno-common
-D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ
-DIGNORE_SIGHUP_SIGQUIT -DDONT_DECLARE_CXA_PURE_VIRTUAL
-DDBD_MYSQL_INSERT_ID_IS_GOOD -g -arch x86_64 -arch i386 -arch ppc -g -pipe
-fno-common -DPERL_DARWIN -fno-strict-aliasing -I/usr/local/include -Os
-DVERSION=\"4.013\" -DXS_VERSION=\"4.013\"
"-I/System/Library/Perl/5.10.0/darwin-thread-multi-2level/CORE" mysql.c
mysql.xs: In function 'XS_DBD__mysql__db_do':
mysql.xs:329: warning: format not a string literal and no format arguments
mysql.xs:330: warning: format not a string literal and no format arguments
mysql.xs:331: warning: format not a string literal and no format arguments
mysql.xs:490: warning: format not a string literal and no format arguments
mysql.xs: In function 'XS_DBD__mysql__GetInfo_dbd_mysql_get_info':
mysql.xs:741: warning: format '%i' expects type 'int', but argument 2 has
type 'struct SV *'
mysql.xs: In function 'XS_DBD__mysql__db_do':
mysql.xs:329: warning: format not a string literal and no format arguments
mysql.xs:330: warning: format not a string literal and no format arguments
mysql.xs:331: warning: format not a string literal and no format arguments
mysql.xs:490: warning: format not a string literal and no format arguments
mysql.xs: In function 'XS_DBD__mysql__GetInfo_dbd_mysql_get_info':
mysql.xs:741: warning: format '%i' expects type 'int', but argument 2 has
type 'struct SV *'
mysql.xs: In function 'XS_DBD__mysql__db_do':
mysql.xs:329: warning: format not a string literal and no format arguments
mysql.xs:330: warning: format not a string literal and no format arguments
mysql.xs:331: warning: format not a string literal and no format arguments
mysql.xs:490: warning: format not a string literal and no format arguments
mysql.xs: In function 'XS_DBD__mysql__GetInfo_dbd_mysql_get_info':
mysql.xs:741: warning: format '%i' expects type 'int', but argument 2 has
type 'struct SV *'
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
rm -f blib/arch/auto/DBD/mysql/mysql.bundle
LD_RUN_PATH="/usr/local/mysql/lib" /usr/bin/perl myld gcc-4.2
-mmacosx-version-min=10.6 -arch x86_64 -arch i386 -arch ppc -bundle
-undefined dynamic_lookup -L/usr/local/lib dbdimp.o mysql.o -o
blib/arch/auto/DBD/mysql/mysql.bundle \
-L/usr/local/mysql/lib -lmysqlclient -lz -lm -lmygcc \
chmod 755 blib/arch/auto/DBD/mysql/mysql.bundle
cp mysql.bs blib/arch/auto/DBD/mysql/mysql.bs
chmod 644 blib/arch/auto/DBD/mysql/mysql.bs
Manifying blib/man3/DBD::mysql.3pm
Manifying blib/man3/DBD::mysql::INSTALL.3pm
Manifying blib/man3/Bundle::DBD::mysql.3pm
bash-3.2$ sudo make install
bash-3.2$ cat ~/t
#!/usr/bin/perl
use strict;
use warnings;
use DBI;
my $h = DBI->connect("dbi:mysql:test:localhost", 'root', '')
or die $DBI::errstr;
$h->disconnect;
bash-3.2$ perl ~/t
dyld: lazy symbol binding failed: Symbol not found: _mysql_init
Referenced from:
/Library/Perl/5.10.0/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle
Expected in: flat namespace
dyld: Symbol not found: _mysql_init
Referenced from:
/Library/Perl/5.10.0/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle
Expected in: flat namespace
Trace/BPT trap
bash-3.2$
--
如果觉得无聊，您不妨访问Google Reader消遣 http://www.google.com/reader/view
要尝试黑版本Google，请访问 http://www.google.com/custom?q=&sa=Search&client=pub-4021907304270164&forid=1&channel=7519554017&ie=UTF-8&oe=UTF-8&cof=GALT%3A%23FF9900%3BGL%3A1%3BDIV%3A%230033FF%3BVLC%3ACC9900%3BAH%3Acenter%3BBGC%3A000000%3BLBGC%3A000000%3BALC%3AFFFFFF%3BLC%3AFFFFFF%3BT%3ACCCCCC%3BGFNT%3A33CC00%3BGIMP%3A33CC00%3BFORID%3A1%3B&hl=en
--~--~---------~--~----~------------~-------~--~----~
您收到此信息是由于您订阅了 Google 论坛"PerlChina Mongers 讨论组"论坛。
要在此论坛发帖，请发电子邮件到 perlchina@googlegroups.com
要退订此论坛，请发邮件至 perlchina+unsubscribe@googlegroups.com
更多选项，请通过 http://groups.google.com/group/perlchina?hl=zh-CN 访问该论坛
-~----------~----~----~----~------~----~------~--~---
博文
没有评论:
发表评论