2 <html lang="en-us" itemscope itemtype="http://schema.org/Article">
5 <meta name="description" content=" Built DBD::MySQL for Solaris Having problems building DBD::MySQL for Linux...">
6 <meta name="generator" content="Movable Type 5.2.3">
7 <title>Building DBD::MySQL - Status</title>
8 <link rel="alternate" type="application/atom+xml" title="Recent Entries" href="http://defaria.com/blogs/Status/atom.xml">
9 <link rel="canonical" href="http://defaria.com/blogs/Status/2007/03/building-dbdmys.html">
10 <meta name="viewport" content="width=device-width,initial-scale=1">
11 <link rel="stylesheet" href="http://defaria.com/blogs/Status/styles.css">
13 <link rel="stylesheet" href="http://defaria.com/blogs/Status/styles_ie.css">
14 <script src="/mt/mt-static/support/theme_static/rainier/js/html5shiv.js"></script>
17 <link rel="start" href="http://defaria.com/blogs/Status/">
19 <link rel="prev" href="http://defaria.com/blogs/Status/2007/01/vob-uuids.html" title="VOB UUIDs">
20 <link rel="next" href="http://defaria.com/blogs/Status/2007/03/clearcase-licen.html" title="Clearcase License Graphs">
21 <!-- Open Graph Protocol -->
22 <meta property="og:type" content="article">
23 <meta property="og:locale" content="en-us">
24 <meta property="og:title" content="Building DBD::MySQL">
25 <meta property="og:url" content="http://defaria.com/blogs/Status/2007/03/building-dbdmys.html">
26 <meta property="og:description" content=" Built DBD::MySQL for Solaris Having problems building DBD::MySQL for Linux...">
27 <meta property="og:site_name" content="Status">
28 <meta property="og:image" content="/mt/mt-static/support/theme_static/rainier/img/siteicon-sample.png">
30 <meta itemprop="description" content=" Built DBD::MySQL for Solaris Having problems building DBD::MySQL for Linux...">
31 <link itemprop="url" href="http://defaria.com/blogs/Status/2007/03/building-dbdmys.html">
32 <link itemprop="image" href="/mt/mt-static/support/theme_static/rainier/img/siteicon-sample.png">
37 <div id="container-inner">
38 <header id="header" role="banner">
39 <div id="header-inner">
40 <div id="header-content">
42 <a href="http://defaria.com/blogs/Status/">
51 <nav role="navigation">
53 <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
62 <div id="content-inner">
63 <ul class="breadcrumb breadcrumb-list">
64 <li class="breadcrumb-list-item"><a href="http://defaria.com/blogs/Status/">Home</a></li>
65 <li class="breadcrumb-list-item">Building DBD::MySQL</li>
67 <div id="individual-main" class="main" role="main">
68 <article id="entry-1870" class="entry entry-asset asset hentry">
69 <div class="asset-header">
70 <h2 itemprop="name" class="asset-name entry-title">Building DBD::MySQL</h2>
71 <footer class="asset-meta">
72 <ul class="asset-meta-list">
73 <li class="asset-meta-list-item">Posted on <time datetime="2007-03-07T17:44:17-08:00" itemprop="datePublished">March 7, 2007</time></li>
74 <li class="asset-meta-list-item">by <span class="author entry-author vcard"></span></li>
77 <li class="asset-meta-list-item">in <a itemprop="articleSection" rel="tag" href="http://defaria.com/blogs/Status/texas-instruments/">Texas Instruments</a></li>
83 <div class="entry-content asset-content" itemprop="articleBody">
85 <li>Built DBD::MySQL for Solaris</li>
87 <li>Having problems building DBD::MySQL for Linux</li>
89 <h2>How to build DBD::MySQL</h2>
91 <p>After downloading DBD::mysql from
92 <a href="http://search.cpan.org/~capttofu/DBD-mysql-4.003/lib/DBD/mysql.pm">http://search.cpan.org/~capttofu/DBD-mysql-4.003/lib/DBD/mysql.pm</a> I encountered some problems. First one needs to use the appropriate perl, one that has a compatible DBI module already. I found this in /app/cmpackages/perl/bin/perl. The more standard perl, /apps/perl/5.8.3/bin/perl seems to have a newer DBI module that is not compatible with the DBD::mysql that I downloaded.</p>
94 <p>Then one needs to give the proper parameters to generate the Makefile:</p>
97 $ export PATH=$PATH:/apps/mysql/4.0.16/bin
98 $ /apps/cmpackages/perl/bin/perl Makefile.PL \
99 > --libs="-L/apps/mysql/4.0.16/lib/mysql -lmysqlclient -lz" \
100 > --cflags=-I/apps/mysql/4.0.16/include/mysql \
101 > --testhost=mysql01.dal.design.ti.com \ <font
102 color="#ff0000"><i>These will not always be the same</i></font>
103 > --testuser=ccprojects \ <font color="#ff0000"><i>This will change</i></font>
104 > --testpassword=ccpr0jects <font color="#ff0000"><i>This will change (note the 0 not O)</i></font>
107 <p>Note that we explicitly use /apps/cmpackages/perl/bin/perl here. I would rather use /apps/perl/5.8.3/bin/perl but it's DBI appears to be too new for this version of DBD::mysql (!).</p>
109 <p>This will produce a Makefile which you then do:</p>
111 <div class=code><pre>
116 <p>Alas, normally one would do a make install but that would attempt to install into /usr/local/perl, not something we wish to do. And there doesn't appear to be a way to pack into Makefile.PL where you want to eventually install this module when make install is run, so we need to actually modify the Makefile itself.</p>
118 <p>Turns out that perl Makefile.PL <<i>options</i>> specifies which perl to use thus the following appears in the generated Makefile:</p>
120 <div class=code><pre>
121 INSTALLPRIVLIB = /apps/cmpackages/perl/lib/5.8.0
122 INSTALLSITELIB = /apps/cmpackages/perl/lib/site_perl/5.8.0
124 INSTALLARCHLIB = /apps/cmpackages/perl/lib/5.8.0/sun4-solaris-thread-multi
125 INSTALLSITEARCH = /apps/cmpackages/perl/lib/site_perl/5.8.0/sun4-solaris-thread-multi
127 INSTALLBIN = /apps/cmpackages/perl/bin
128 INSTALLSITEBIN = /apps/cmpackages/perl/bin
130 INSTALLSCRIPT = /apps/cmpackages/perl/bin
133 <p>Thus this means a make install will install the module into whichever Perl installation we specified in the perl Makefile.PL <<i>options</i>>! Alas we cannot write to those areas yet...</p>
135 <nav class="page-navigation entry-navigation pagination content-nav">
136 <ul class="page-navigation-list">
138 <li class="page-navigation-list-item page-navigation-prev"><a rel="prev" href="http://defaria.com/blogs/Status/2007/01/vob-uuids.html" title="VOB UUIDs">Previous entry</a></li>
141 <li class="page-navigation-list-item page-navigation-next"><a rel="next" href="http://defaria.com/blogs/Status/2007/03/clearcase-licen.html" title="Clearcase License Graphs">Next entry</a></li>
146 <aside id="zenback" class="zenback feedback">
147 Please paste Zenback script code here.
154 <aside class="widgets related" role="complementary">
155 <nav class="widget-search widget">
156 <div class="widget-content">
157 <form method="get" id="search" action="http://defaria.com/mt/mt-search.cgi">
159 <input type="text" name="search" value="" placeholder="Search...">
161 <input type="hidden" name="IncludeBlogs" value="8">
163 <input type="hidden" name="limit" value="20">
164 <button type="submit" name="button">
165 <img alt="Search" src="/mt/mt-static/support/theme_static/rainier/img/search-icon.png">
171 <nav class="widget-archive-category widget">
172 <h3 class="widget-header">Categories</h3>
173 <div class="widget-content">
176 <ul class="widget-list">
179 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/ameriquest/">Ameriquest (99)</a>
187 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/audience/">Audience (3)</a>
195 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/broadcom/">Broadcom (76)</a>
203 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/gpdb/">GPDB (35)</a>
211 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-dynamics/">General Dynamics (61)</a>
219 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-electric/">General Electric (13)</a>
227 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/hewlett-packard/">Hewlett Packard (13)</a>
235 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/lynuxworks/">LynuxWorks (162)</a>
243 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/pqa/">PQA (35)</a>
251 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/salira/">Salira (79)</a>
259 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/tellabs/">Tellabs (2)</a>
267 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/texas-instruments/">Texas Instruments (31)</a>
279 <nav class="widget-archive-dropdown widget">
280 <h3 class="widget-header">Archives</h3>
281 <div class="widget-content">
283 <option>Select a Month...</option>
285 <option value="http://defaria.com/blogs/Status/2016/02/">February 2016</option>
289 <option value="http://defaria.com/blogs/Status/2014/09/">September 2014</option>
293 <option value="http://defaria.com/blogs/Status/2014/04/">April 2014</option>
297 <option value="http://defaria.com/blogs/Status/2014/03/">March 2014</option>
301 <option value="http://defaria.com/blogs/Status/2013/02/">February 2013</option>
305 <option value="http://defaria.com/blogs/Status/2012/09/">September 2012</option>
309 <option value="http://defaria.com/blogs/Status/2012/08/">August 2012</option>
313 <option value="http://defaria.com/blogs/Status/2012/05/">May 2012</option>
317 <option value="http://defaria.com/blogs/Status/2012/04/">April 2012</option>
321 <option value="http://defaria.com/blogs/Status/2012/02/">February 2012</option>
325 <option value="http://defaria.com/blogs/Status/2012/01/">January 2012</option>
329 <option value="http://defaria.com/blogs/Status/2011/10/">October 2011</option>
333 <option value="http://defaria.com/blogs/Status/2011/07/">July 2011</option>
337 <option value="http://defaria.com/blogs/Status/2010/09/">September 2010</option>
341 <option value="http://defaria.com/blogs/Status/2010/08/">August 2010</option>
345 <option value="http://defaria.com/blogs/Status/2010/04/">April 2010</option>
349 <option value="http://defaria.com/blogs/Status/2010/03/">March 2010</option>
353 <option value="http://defaria.com/blogs/Status/2010/02/">February 2010</option>
357 <option value="http://defaria.com/blogs/Status/2009/05/">May 2009</option>
361 <option value="http://defaria.com/blogs/Status/2009/04/">April 2009</option>
365 <option value="http://defaria.com/blogs/Status/2008/07/">July 2008</option>
369 <option value="http://defaria.com/blogs/Status/2008/05/">May 2008</option>
373 <option value="http://defaria.com/blogs/Status/2008/04/">April 2008</option>
377 <option value="http://defaria.com/blogs/Status/2008/03/">March 2008</option>
381 <option value="http://defaria.com/blogs/Status/2008/02/">February 2008</option>
385 <option value="http://defaria.com/blogs/Status/2008/01/">January 2008</option>
389 <option value="http://defaria.com/blogs/Status/2007/12/">December 2007</option>
393 <option value="http://defaria.com/blogs/Status/2007/11/">November 2007</option>
397 <option value="http://defaria.com/blogs/Status/2007/10/">October 2007</option>
401 <option value="http://defaria.com/blogs/Status/2007/09/">September 2007</option>
405 <option value="http://defaria.com/blogs/Status/2007/08/">August 2007</option>
409 <option value="http://defaria.com/blogs/Status/2007/07/">July 2007</option>
413 <option value="http://defaria.com/blogs/Status/2007/06/">June 2007</option>
417 <option value="http://defaria.com/blogs/Status/2007/05/">May 2007</option>
421 <option value="http://defaria.com/blogs/Status/2007/04/">April 2007</option>
425 <option value="http://defaria.com/blogs/Status/2007/03/">March 2007</option>
429 <option value="http://defaria.com/blogs/Status/2007/01/">January 2007</option>
433 <option value="http://defaria.com/blogs/Status/2006/12/">December 2006</option>
437 <option value="http://defaria.com/blogs/Status/2006/11/">November 2006</option>
441 <option value="http://defaria.com/blogs/Status/2006/10/">October 2006</option>
445 <option value="http://defaria.com/blogs/Status/2006/09/">September 2006</option>
449 <option value="http://defaria.com/blogs/Status/2006/07/">July 2006</option>
453 <option value="http://defaria.com/blogs/Status/2006/06/">June 2006</option>
457 <option value="http://defaria.com/blogs/Status/2006/05/">May 2006</option>
461 <option value="http://defaria.com/blogs/Status/2006/04/">April 2006</option>
465 <option value="http://defaria.com/blogs/Status/2006/03/">March 2006</option>
469 <option value="http://defaria.com/blogs/Status/2006/02/">February 2006</option>
473 <option value="http://defaria.com/blogs/Status/2006/01/">January 2006</option>
477 <option value="http://defaria.com/blogs/Status/2005/12/">December 2005</option>
481 <option value="http://defaria.com/blogs/Status/2005/11/">November 2005</option>
485 <option value="http://defaria.com/blogs/Status/2005/10/">October 2005</option>
489 <option value="http://defaria.com/blogs/Status/2005/09/">September 2005</option>
493 <option value="http://defaria.com/blogs/Status/2005/08/">August 2005</option>
497 <option value="http://defaria.com/blogs/Status/2005/07/">July 2005</option>
501 <option value="http://defaria.com/blogs/Status/2005/06/">June 2005</option>
505 <option value="http://defaria.com/blogs/Status/2005/05/">May 2005</option>
509 <option value="http://defaria.com/blogs/Status/2005/04/">April 2005</option>
513 <option value="http://defaria.com/blogs/Status/2005/03/">March 2005</option>
517 <option value="http://defaria.com/blogs/Status/2005/02/">February 2005</option>
521 <option value="http://defaria.com/blogs/Status/2005/01/">January 2005</option>
525 <option value="http://defaria.com/blogs/Status/2004/12/">December 2004</option>
529 <option value="http://defaria.com/blogs/Status/2004/09/">September 2004</option>
533 <option value="http://defaria.com/blogs/Status/2004/08/">August 2004</option>
537 <option value="http://defaria.com/blogs/Status/2004/07/">July 2004</option>
541 <option value="http://defaria.com/blogs/Status/2004/06/">June 2004</option>
545 <option value="http://defaria.com/blogs/Status/2004/05/">May 2004</option>
549 <option value="http://defaria.com/blogs/Status/2004/04/">April 2004</option>
553 <option value="http://defaria.com/blogs/Status/2004/03/">March 2004</option>
557 <option value="http://defaria.com/blogs/Status/2004/02/">February 2004</option>
561 <option value="http://defaria.com/blogs/Status/2004/01/">January 2004</option>
565 <option value="http://defaria.com/blogs/Status/2003/12/">December 2003</option>
569 <option value="http://defaria.com/blogs/Status/2003/11/">November 2003</option>
577 <div class="widget-syndication widget section">
578 <div class="widget-content">
579 <p><img src="http://defaria.com/mt/mt-static/images/status_icons/feed.gif" alt="Subscribe to feed" width="9" height="9" /> <a href="http://defaria.com/blogs/Status/atom.xml">Subscribe to this blog's feed</a></p>
587 <footer id="footer" role="contentinfo">
588 <div id="footer-inner">
589 <div id="footer-content">
590 <nav role="navigation">
592 <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
598 <p class="license">© Copyright 2016.</p>
599 <p class="poweredby">Powered by <a href="http://www.movabletype.org/">Movable Type</a></p>
605 <script src="http://defaria.com/mt/mt-static/jquery/jquery.min.js"></script>
606 <script src="http://defaria.com/blogs/Status/mt-theme-scale2.js"></script>