染出一道彩虹

如果能像烟花般灿烂,也许消亡便不再可怕

日志

我的Perl DBD:Mysql Module安装历险

2006-09-24 11:34:52| 分类：技术 | 标签： |字号大中小订阅

Perl: 5.8.6

about 2005-10-13 晚10：30分:
shell> perl -MCPAN -e shell
cpan> install DBI
................
cpan> install DBD::mysql
提示错误信息，like this:
......
Cannot find the file 'mysql_config'! Your execution PATH doesn't seem
not contain the path to mysql_config. Resorting to guessed values!
Can't exec "mysql_config": No such file or directory at Makefile.PL line 454.
......
猜测估计是根据PATH找不到mysql_config的原因，知道mysql_config在/home/mysql/bin下后，
shell> PATH=/home/mysql/bin:$PATH; export PATH
再度安装
......
I will use the following settings for compiling and testing:

cflags (mysql_config) = -I/home/mysql/include/mysql
embedded (mysql_config) =
libs (mysql_config) = -L/home/mysql/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm
mysql_config (guessed ) = mysql_config
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
ssl (guessed ) = 0
testdb (default ) = test
testhost (default ) =
testpassword (default ) =
testsocket (default ) =
testuser (default ) =
......
Running make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base.............install_driver(mysql) failed: Can't load '/root/.cpan/build/DBD-mysql-3.0002/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.14: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.6/i386-linux-thread-multi/DynaLoader.pm line 230.
......
Failed 19/20 test scripts, 5.00% okay. 863/866 subtests failed, 0.35% okay.
make: *** [test_dynamic] Error 255
/usr/bin/make test -- NOT OK
Running make install
make test had returned bad status, won't install without force
......
又出错，不禁感叹搞乜啊又，好我从CPAN下载DBD-mysql-3.0002，看INSTALL.html文档，修改config,
进行手动安装，出错信息一样，晕！！我 google 再 google
-------------------------------------------------------------------------------------
about 2005-10-13 晚11：30分:
没法了，升级perl看看，下载perl5.8.7, 编译安装...漫长的等待...
顺利升级，好，再安装DBD
......
make: *** [test_dynamic] Error 255
/usr/bin/make test -- NOT OK
Running make install
make test had returned bad status, won't install without force
......
shit, 又是你，倒！！！百度...google...google...百度...

about 2005-10-14 零时40分：
好困阿，ZZZZZZZ...
-------------------------------------------------------------------------------------
about 2005-10-4 晚10:30分：
算啦，我再看看INSTALL.html的config部分吧，再不行我就去论坛。看ing，看ing
......
KNOWN PROBLEMS
......
4. )
Red Hat 8 & 9 set the Default locale to UTF which causes problems with MakeMaker. To build DBD::mysql on these systems, do a 'unset LANG' before runing 'perl Makefile.PL'
......
oh, damn it!!! is u UTF. I finally catch u. 马上验证一下
shell> unset LANG
shell> perl Makefile.PL -mysql_config=/home/mysql/bin/mysql_config -testuser=root -testpassword=dbadmin
shell> make
shell> make test
一切正常，yeah！！！
我终于可以
shell> make install

总结
shell> unset LANG (若os的默认字符编码为UTF8，例如FCX)
shell> PATH=/home/mysql/bin:$PATH; export PATH (mysql的安装路径根据实际情况填写)
shell> perl -MCPAN -e shell
cpan> install DBI (根据自己需要)
cpan> force install DBD::mysql (忽略make test结果，强行安装)

测试验证
你可以写个内容如下的perl文件来测试一些你安装的驱动，各参数的具体值由你的实际环境决定



#!/usr/bin/perl
use Mysql;
$HOST = "localhost";
$DATABASE = "test";
$USER = "root";
$PASSWD = "rootpwd";
my $dbh = Mysql->connect("$HOST","$DATABASE","$USER","$PASSWD") or die "Can not connect to database: $DataSource:$DataBase";

如果运行后没报错那就表示成功了

评论这张

转发至微博

0人 | 分享到：

阅读(3844)| 评论(1)| 引用 (0) |举报

关于如何使用第三方控件cos和jspSmartUpload实现文件的上传与下载

嵌入式数据库Hsqldb和McKoi的使用

历史上的今天

this.p={  m:2,
              b:2,
              id:'fks_084064080087083064080074094071081080087067087',
              blogTitle:'我的Perl DBD:Mysql Module安装历险',
              blogAbstract:'In my mind, it should be simple and easy, but in fact sometimes it can make you mad',
              blogTag:'perl',
              blogUrl:'blog/static/8456603200682411345243',
              isPublished:1,
              istop:false,
              type:0,
              modifyTime:1159069880985,
              publishTime:1159068892043,
              permalink:'blog/static/8456603200682411345243',
              commentCount:1,
              mainCommentCount:1,
              recommendCount:0,
              bsrk:-100,
              publisherId:0,
              recomBlogHome:false,
              attachmentsFileIds:[],
              vote:{},
              groupInfo:{},
              friendstatus:'none',
              followstatus:'unFollow',
              pubSucc:'',
              visitorProvince:'未设置',
              visitorCity:'未设置',
              postAddInfo:{"postAdSetting":{"title":"youdaonote","linkUrl":"http://g.163.com/a?CID=14253&Values=715242298&Redirect=http://e.cn.miaozhen.com/r.gif?k=1001788&p=3xjnR0&ae=1000240&vo=2ceafe9f2&vr=2&o=http%3A%2F%2Fphdi.qq.com","imageUrl":"http://img1.126.net/channel8/011811_5.21.swf","expireDay":"14","modifyTime":"1337569753119","flashUrl":"http://img1.126.net/channel8/011811_5.21.swf"},"isAdShow":true,"postAdContent":{"special":[{"title":"周国平：纪念<讲话>时我纪念什么","url":"http://blog.163.com/zhouguoping_vip/blog/static/1689663172012423200454/"},{"title":"舌尖上的乡愁和地沟里的中国","url":"http://spacebandit.blog.163.com/blog/static/39710562201242402519546/"},{"title":"周濂：永远都无法叫醒一个装睡的人","url":"http://westernphilosophy.blog.163.com/blog/static/187136009201242343652663/"}],"blog":[{"title":"实拍舌尖上的北京夜市","pic":"http://img2.cache.netease.com/cnews/2012/5/24/2012052408440699dca.jpg","url":"http://shihuixiong.blog.163.com/blog/static/2070152272012423111427614/"},{"title":"郎咸平：戳穿中国电力企业的谎言","url":"http://blog.163.com/"},{"title":"台湾作家：台湾并没韩寒写的那么好","url":"http://liaoxinzhong.blog.163.com/blog/static/206945029201242332256424/"},{"title":"《心术》导演：首轮落幕期待再相会","url":"http://yangyangvip2012.blog.163.com/blog/static/207281112201242314729798/"},{"title":"营养师：小笼包中'血脖肉馅'的危害","url":"http://xujinxi2012.blog.163.com/blog/static/20729214020124178370706/"},{"title":"张俊以：敢向赵本山说不的东北演员","url":"http://zhangjunyivip.blog.163.com/blog/static/1811722442012424745374/"}]}},
              mset:'000',
              mcon:'',
              srk:-100,
              remindgoodnightblog:false,
              isBlackVisitor:false,
              isShowYodaoAd:false,
              hostIntro:'你若不想做,会找到一个借口。你若想做,会找到一个方法。',
              hmcon:'1',
              lofter_single:'<a hidefocus="true" target="_blank" href="http://www.lofter.com/specials/2012cmvfestival"><img onload="var nimg = new Image(); nimg.src=\'http://blog.163.com/newpage/images/analyse.png?lofter_single&t=\'+new Date().getTime()" border="0" src="http://b2.bst.126.net/newpage/images/lofter_single5.jpg"/></a>'
            }

{list a as x}
    {if !!x}
    <div class="iblock nbw-fce nbw-f40">
      <a class="fc03 noul" target="_blank" hidefocus="true" href="http://blog.163.com/${x.visitorName}/">
      {if x.visitorName==visitor.userName}
      <img alt="${x.visitorNickname|escape}" onerror="this.src=location.f40" class="cwd bdwa bdc0" src="${fn1(x.visitorName)}&r=${visitor.imageUpdateTime}"/>
      {else}
      <img alt="${x.visitorNickname|escape}" onerror="this.src=location.f40" class="cwd bdwa bdc0" src="${fn1(x.visitorName)}"/>
      {/if}
      </a>
      <div class="cwd vname thide">
        {if x.moveFrom=='wap'}
          <a class="noul pnt" target="_blank" href="http://blog.163.com/services/wapblog.html?frompersonalbloghome"><span title="来自网易手机博客" class="iblock wapIcon"> </span></a>
        {elseif x.moveFrom=='iphone'}
          <a class="noul pnt" target="_blank"><span title="来自iPhone客户端" class="iblock iphoneIcon"> </span></a>
        {elseif x.moveFrom=='android'}
          <a class="noul pnt" target="_blank"><span title="来自Android客户端" class="iblock androidIcon"> </span></a>
        {elseif x.moveFrom=='mobile'}
          <a class="noul pnt" target="_blank" href="http://blog.163.com/services/emsblog.html?frompersonalbloghome"><span title="来自网易短信写博" class="iblock wapIcon"> </span></a>
        {/if}
        <a class="fc03 m2a"  target="_blank" hidefocus="true" href="http://blog.163.com/${x.visitorName}/">
          ${fn(x.visitorNickname,8)|escape}
        </a>
      </div>
    </div>
    {/if}
    {/list}

<#--最新日志，群博日志--> <#--推荐日志-->

<p class="fc06">推荐过这篇日志的人：</p>
    <div>
      {list a as x}
      {if !!x}
      <div class="iblock nbw-fce nbw-f40">
        <a class="fc03 noul" target="_blank" hidefocus="true" href="http://blog.163.com/${x.recommenderName}/">
        <img alt="${x.recommenderNickname|escape}" onerror="this.src=location.f40" class="cwd bdwa bdc0" src="${fn1(x.recommenderName)}"/>
        </a>
        <div class="cwd thide">
          <a class="fc03 m2a" target="_blank" hidefocus="true" href="http://blog.163.com/${x.recommenderName}/">
            ${fn(x.recommenderNickname,6)|escape}
          </a>
        </div>
      </div>
      {/if}
      {/list}
    </div>
    {if !!b&&b.length>0}
    <p  class="fc06">他们还推荐了：</p>
    <ul>
    {list b as y}
      {if !!y}
        <li class="rrb"><span class="iblock">·</span><a class="fc03 m2a" target="_blank" href="http://blog.163.com/${y.recommendBlogPermalink}/?from=blog/static/8456603200682411345243">${y.recommendBlogTitle|escape}</a></li>
      {/if}
    {/list}
    </ul>
    {/if}

<#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--相关文章--> <#--历史上的今天--> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->

页脚

公司简介 - 联系方法 - 招聘信息 - 客户服务 - 隐私政策 - 博客风格 - 手机博客 - VIP博客 - 订阅此博客

染出一道彩虹

导航

日志

我的Perl DBD:Mysql Module安装历险

历史上的今天

相关文章

最近读者

评论

页脚