Warning: prerequisite DBD::mysql 1 not found错误解决方案
来源:互联网 发布:剑灵灵族男捏脸数据 编辑:程序博客网 时间:2024/06/16 16:01
在使用perl编译的 DBD::mysql 的时候,进程提示无法编译成功,这里想需要我们手动进行编译相关的包文件;相关错误如下所示;
dbdimp.c: In function 鈓ysql_db_async_result?dbdimp.c:5049: error: 釳YSQL?undeclared (first use in this function)dbdimp.c:5049: error: 鈙vsock?undeclared (first use in this function)dbdimp.c:5049: error: invalid operands to binary *dbdimp.c:5049: warning: statement with no effectdbdimp.c:5050: error: 釳YSQL_RES?undeclared (first use in this function)dbdimp.c:5050: error: 鈅res?undeclared (first use in this function)dbdimp.c:5050: error: invalid operands to binary *dbdimp.c:5050: warning: statement with no effectdbdimp.c:5051: warning: ISO C90 forbids mixed declarations and codedbdimp.c:5054: error: 鈘esp?undeclared (first use in this function)dbdimp.c:5055: warning: statement with no effectdbdimp.c:5069: error: 鈏mp_dbh_t?has no member named 鈇sync_query_in_flight?dbdimp.c:5073: error: 鈏mp_dbh_t?has no member named 鈇sync_query_in_flight?dbdimp.c:5073: warning: comparison of distinct pointer types lacks a castdbdimp.c:5077: error: 鈏mp_dbh_t?has no member named 鈇sync_query_in_flight?dbdimp.c:5077: warning: statement with no effectdbdimp.c:5079: error: 鈏mp_dbh_t?has no member named 鈖mysql?dbdimp.c:5079: warning: statement with no effectdbdimp.c:5080: warning: implicit declaration of function 鈓ysql_read_query_result?dbdimp.c:5082: warning: implicit declaration of function 鈓ysql_store_result?dbdimp.c:5082: error: assignment of read-only locationdbdimp.c:5082: warning: statement with no effectdbdimp.c:5085: warning: passing argument 3 of 鈓ysql_dr_error?makes pointer from integer without a castdbdimp.c:5086: error: wrong type argument to unary exclamation markdbdimp.c:5090: warning: comparison of distinct pointer types lacks a castdbdimp.c:5098: error: 鈓y_ulonglong?undeclared (first use in this function)dbdimp.c:5098: warning: comparison between pointer and integerdbdimp.c:5099: error: wrong type argument to unary exclamation markdbdimp.c:5100: error: 鈏mp_sth_t?has no member named 鈏nsertid?dbdimp.c:5100: warning: statement with no effectdbdimp.c:5106: error: 鈏mp_sth_t?has no member named 鈘esult?dbdimp.c:5107: error: 鈏mp_sth_t?has no member named 鈊one_desc?dbdimp.c:5107: warning: statement with no effectdbdimp.c:5108: error: 鈏mp_sth_t?has no member named 鈌etch_done?dbdimp.c:5108: warning: statement with no effectdbdimp.c:5111: error: 鈏mp_sth_t?has no member named 鈝arning_count?dbdimp.c:5111: warning: statement with no effectdbdimp.c:5096: warning: unused variable 鈏mp_dbh?dbdimp.c:5115: warning: passing argument 3 of 鈓ysql_dr_error?makes pointer from integer without a castdbdimp.c: In function 鈓ysql_db_async_ready?dbdimp.c:5139: error: 鈏mp_dbh_t?has no member named 鈇sync_query_in_flight?dbdimp.c:5140: error: 鈏mp_dbh_t?has no member named 鈇sync_query_in_flight?dbdimp.c:5140: warning: comparison of distinct pointer types lacks a castdbdimp.c:5144: error: 鈏mp_dbh_t?has no member named 鈖mysql?dbdimp.c:5144: error: 鈙ql_type_info_t?has no member named 鈔et?dbdimp.c:5144: error: request for member 鈌d?in something not a structure or uniondbdimp.c:5144: warning: assignment makes integer from pointer without a castmake: *** [dbdimp.o] Error 1 CAPTTOFU/DBD-mysql-4.022.tar.gz /usr/bin/make -- NOT OKRunning make test Can't test without successful makeRunning make install Make had returned bad status, install seems impossibleFailed during this command: CAPTTOFU/DBD-mysql-4.022.tar.gz : make NO
解决方法如下,手动编译包文件即可;
[root@Slave02 ~]# lsanaconda-ks.cfg innotop-1.8.1.tar.gz sleep.sha.pl input.txt success_test.sha.txt install.log tablesize.sqlbug.sh install.log.syslog temp.ttcmake-2.8.5.tar.gz let.sh time_take.shDBD-mysql-4.018.tar.gz log.txt tuning-primer.shdebug.sh my_program us.shDesktop mysqlspp.sql xtrabackup-1.6.5.tar.gzfile.sh out.txt[root@Slave02 ~]# tar xzvf DBD-mysql-4.018.tar.gz DBD-mysql-4.018/DBD-mysql-4.018/ChangeLogDBD-mysql-4.018/constants.hDBD-mysql-4.018/dbdimp.cDBD-mysql-4.018/dbdimp.hDBD-mysql-4.018/eg/DBD-mysql-4.018/eg/bug14979.plDBD-mysql-4.018/eg/bug21028.plDBD-mysql-4.018/eg/bug30033.plDBD-mysql-4.018/eg/bug30033pg.plDBD-mysql-4.018/eg/decimal_test.plDBD-mysql-4.018/eg/issue21946.plDBD-mysql-4.018/eg/prepare_memory_usage.plDBD-mysql-4.018/eg/proc_example1.plDBD-mysql-4.018/eg/proc_example2.plDBD-mysql-4.018/eg/proc_example2a.plDBD-mysql-4.018/eg/proc_example2b.plDBD-mysql-4.018/eg/proc_example3.plDBD-mysql-4.018/eg/proc_example4.plDBD-mysql-4.018/INSTALL.htmlDBD-mysql-4.018/lib/DBD-mysql-4.018/lib/Bundle/DBD-mysql-4.018/lib/Bundle/DBD/DBD-mysql-4.018/lib/Bundle/DBD/mysql.pmDBD-mysql-4.018/lib/DBD/DBD-mysql-4.018/lib/DBD/mysql/DBD-mysql-4.018/lib/DBD/mysql/GetInfo.pmDBD-mysql-4.018/lib/DBD/mysql/INSTALL.podDBD-mysql-4.018/lib/DBD/mysql.pmDBD-mysql-4.018/Makefile.PLDBD-mysql-4.018/Makefile.PL.embeddedDBD-mysql-4.018/MANIFESTDBD-mysql-4.018/MANIFEST.SKIPDBD-mysql-4.018/META.ymlDBD-mysql-4.018/myldDBD-mysql-4.018/mysql.xsDBD-mysql-4.018/READMEDBD-mysql-4.018/t/DBD-mysql-4.018/t/00base.tDBD-mysql-4.018/t/10connect.tDBD-mysql-4.018/t/20createdrop.tDBD-mysql-4.018/t/25lockunlock.tDBD-mysql-4.018/t/29warnings.tDBD-mysql-4.018/t/30insertfetch.tDBD-mysql-4.018/t/31insertid.tDBD-mysql-4.018/t/32insert_error.tDBD-mysql-4.018/t/35limit.tDBD-mysql-4.018/t/35prepare.tDBD-mysql-4.018/t/40bindparam.tDBD-mysql-4.018/t/40bindparam2.tDBD-mysql-4.018/t/40blobs.tDBD-mysql-4.018/t/40catalog.tDBD-mysql-4.018/t/40keyinfo.tDBD-mysql-4.018/t/40listfields.tDBD-mysql-4.018/t/40nulls.tDBD-mysql-4.018/t/40nulls_prepare.tDBD-mysql-4.018/t/40numrows.tDBD-mysql-4.018/t/40server_prepare.tDBD-mysql-4.018/t/40server_prepare_error.tDBD-mysql-4.018/t/40types.tDBD-mysql-4.018/t/41bindparam.tDBD-mysql-4.018/t/41blobs_prepare.tDBD-mysql-4.018/t/42bindparam.tDBD-mysql-4.018/t/50chopblanks.tDBD-mysql-4.018/t/50commit.tDBD-mysql-4.018/t/51bind_type_guessing.tDBD-mysql-4.018/t/52comment.tDBD-mysql-4.018/t/53comment.tDBD-mysql-4.018/t/55utf8.tDBD-mysql-4.018/t/60leaks.tDBD-mysql-4.018/t/65types.tDBD-mysql-4.018/t/70takeimp.tDBD-mysql-4.018/t/71impdata.tDBD-mysql-4.018/t/75supported_sql.tDBD-mysql-4.018/t/76multi_statement.tDBD-mysql-4.018/t/80procs.tDBD-mysql-4.018/t/85init_command.tDBD-mysql-4.018/t/86_bug_36972.tDBD-mysql-4.018/t/lib.plDBD-mysql-4.018/t/mem_leak.plDBD-mysql-4.018/t/mysql.dbtestDBD-mysql-4.018/t/mysql.mtestDBD-mysql-4.018/TODO[root@Slave02 ~]# cd DBD-mysql-4.018[root@Slave02 DBD-mysql-4.018]# perl Makefile.PL --mysql_config=/usr/local/mysql/bin/mysql_config PLEASE NOTE:For 'make test' to run properly, you must ensure that the database user 'root' 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 'root'@'localhost' identified by 's3kr1t';You can also optionally set the user to run 'make test' with:perl Makefile.PL --testuser=usernameI will use the following settings for compiling and testing: cflags (mysql_config) = -I/usr/local/mysql/include -g embedded (mysql_config) = libs (mysql_config) = -L/usr/local/mysql/lib -lmysqlclient -lpthread -lz -lm -lrt -lssl -lcrypto -ldl mysql_config (Users choice) = /usr/local/mysql/bin/mysql_config nocatchstderr (default ) = 0 nofoundrows (default ) = 0 ssl (guessed ) = 1 testdb (default ) = test testhost (default ) = testpassword (default ) = testsocket (default ) = testuser (guessed ) = rootTo change these settings, see 'perl Makefile.PL --help' and'perldoc INSTALL'.Checking if your kit is complete...Looks goodMultiple copies of Driver.xst found in: /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/DBI/ /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi/auto/DBI/ at Makefile.PL line 907Using DBI 1.623 (for perl 5.008008 on i386-linux-thread-multi) installed in /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/DBI/Writing Makefile for DBD::mysqlWriting MYMETA.yml and MYMETA.json[root@Slave02 DBD-mysql-4.018]# make cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pmcp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pmcp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.podcp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pmgcc -c -I/usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/DBI -I/usr/local/mysql/include -g -DDBD_MYSQL_WITH_SSL -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m32 -march=i386 -mtune=generic -fasynchronous-unwind-tables -DVERSION=\"4.018\" -DXS_VERSION=\"4.018\" -fPIC "-I/usr/lib/perl5/5.8.8/i386-linux-thread-multi/CORE" dbdimp.cdbdimp.c: In function 鈉ount_params?dbdimp.c:94: warning: suggest parentheses around assignment used as truth valuedbdimp.c:137: warning: suggest parentheses around assignment used as truth valuedbdimp.c: In function 鈊bd_discon_all?dbdimp.c:2172: warning: unused variable 鈏mp_xxh?dbdimp.c: In function 鈓ysql_st_prepare?dbdimp.c:2593: warning: unused variable 鈒imit_flag?/usr/bin/perl -p -e "s/~DRIVER~/mysql/g" /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/DBI/Driver.xst > mysql.xsi/usr/bin/perl /usr/lib/perl5/5.8.8/ExtUtils/xsubpp -typemap /usr/lib/perl5/5.8.8/ExtUtils/typemap mysql.xs > mysql.xsc && mv mysql.xsc mysql.cWarning: duplicate function definition 'do' detected in mysql.xs, line 225Warning: duplicate function definition 'rows' detected in mysql.xs, line 650gcc -c -I/usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/DBI -I/usr/local/mysql/include -g -DDBD_MYSQL_WITH_SSL -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m32 -march=i386 -mtune=generic -fasynchronous-unwind-tables -DVERSION=\"4.018\" -DXS_VERSION=\"4.018\" -fPIC "-I/usr/lib/perl5/5.8.8/i386-linux-thread-multi/CORE" mysql.cmysql.xs: In function 釾S_DBD__mysql__db_do?mysql.xs:242: warning: unused variable 鈙tatement_ptr?mysql.xs: In function 釾S_DBD__mysql__st_more_results?mysql.xs:588: warning: implicit declaration of function 鈓ysql_st_next_results?mysql.xs:587: warning: unused variable 鈘etval?mysql.xs: In function 釾S_DBD__mysql__GetInfo_dbd_mysql_get_info?mysql.xs:724: warning: implicit declaration of function 鈏s_prefix?Running Mkbootstrap for DBD::mysql ()chmod 644 mysql.bsrm -f blib/arch/auto/DBD/mysql/mysql.soLD_RUN_PATH="/usr/local/mysql/lib:/lib" /usr/bin/perl myld gcc -shared -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m32 -march=i386 -mtune=generic -fasynchronous-unwind-tables -L/usr/local/lib dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.so \ -L/usr/local/mysql/lib -lmysqlclient -lpthread -lz -lm -lrt -lssl -lcrypto -ldl \ chmod 755 blib/arch/auto/DBD/mysql/mysql.socp mysql.bs blib/arch/auto/DBD/mysql/mysql.bschmod 644 blib/arch/auto/DBD/mysql/mysql.bsManifying blib/man3/DBD::mysql.3pmManifying blib/man3/DBD::mysql::INSTALL.3pmManifying blib/man3/Bundle::DBD::mysql.3pm[root@Slave02 DBD-mysql-4.018]# make installFiles found in blib/arch: installing files in blib/lib into architecture dependent library treeInstalling /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/DBD/mysql/mysql.soInstalling /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/DBD/mysql/mysql.bsInstalling /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/Bundle/DBD/mysql.pmInstalling /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/DBD/mysql.pmInstalling /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/DBD/mysql/INSTALL.podInstalling /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/DBD/mysql/GetInfo.pmInstalling /usr/share/man/man3/Bundle::DBD::mysql.3pmInstalling /usr/share/man/man3/DBD::mysql.3pmInstalling /usr/share/man/man3/DBD::mysql::INSTALL.3pmAppending installation info to /usr/lib/perl5/5.8.8/i386-linux-thread-multi/perllocal.pod[root@Slave02 DBD-mysql-4.018]#
- Warning: prerequisite DBD::mysql 1 not found错误解决方案
- Warning: prerequisite DBD::mysql 3 not found
- MATLAB Warning:...toolbox\local\pathdef.m not found. 解决方案
- prerequisite could not be found for bootstrapping 问题解决
- mysql导入数据file not found解决方案
- warning:directory not found option
- R连接mysql时,已列出所有表,错误Error in odbcTableExists(channel, sqtable) object 'wuliudata' not found解决方案
- Message file sp1.msb not found错误的解决方案
- Spring MVC 404 Not Found 无错误日志解决方案
- ASP网页HTTP 错误 404.3 - Not Found解决方案
- pod install 错误(-bash: pod: command not found)解决方案
- warning LNK4099: PDB 'vc100.pdb' was not found... 解决方案
- sqlite3 not found 解决方案
- [Makefile]warning: needed by not found (try using -rpath or -rpath-link)错误处理
- warning: needed by not found (try using -rpath or -rpath-link)错误处理
- coreseek(sphinx)错误:WARNING: attribute 'id' not found - IGNORING原因及解决方法
- coreseek(sphinx)错误:WARNING: attribute 'id' not found - IGNORING原因及解决方法
- 错误:/bin/sh: 1: protoc: not found
- contiki系统分析三:进程分析
- ADB(Android Debug Bridge)技术实现
- CSS性能优化探讨
- 在outlook中批量导入MSG文件
- Maven 项目修改项目名称之后,如何修改target下面的项目名称
- Warning: prerequisite DBD::mysql 1 not found错误解决方案
- (转)Android图片处理内存溢出学习
- 【WiEngine 游戏引擎】基础(1)添加一个精灵
- HTML----css clear的理解,清除浮动方式
- JSP/Servlet的生命周期
- Linux图形界面中客户端、服务器、窗口管理器之间的关系
- linux lsof 命令参数详解(查看进程打开的文件)
- 松岛枫
- 松岛枫