1 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
2 "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
3 <html xmlns="http://www.w3.org/1999/xhtml" id="sixapart-standard">
5 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
6 <meta name="generator" content="Movable Type 5.2.3" />
8 <link rel="stylesheet" href="http://defaria.com/blogs/Status/styles-site.css" type="text/css" />
9 <link rel="alternate" type="application/atom+xml" title="Atom" href="http://defaria.com/blogs/Status/atom.xml" />
10 <link rel="alternate" type="application/rss+xml" title="RSS 2.0" href="http://defaria.com/blogs/Status/index.xml" />
12 <title>Status for Andrew DeFaria: Building DBD::MySQL</title>
14 <link rel="start" href="http://defaria.com/blogs/Status/" title="Home" />
15 <link rel="prev" href="http://defaria.com/blogs/Status/archives/000612.html" title="VOB UUIDs" />
16 <link rel="next" href="http://defaria.com/blogs/Status/archives/000622.html" title="Clearcase License Graphs" />
19 <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
20 xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/"
21 xmlns:dc="http://purl.org/dc/elements/1.1/">
23 rdf:about="http://defaria.com/blogs/Status/archives/000621.html"
24 trackback:ping="http://defaria.com/mt/mt-tb.cgi/10"
25 dc:title="Building DBD::MySQL"
26 dc:identifier="http://defaria.com/blogs/Status/archives/000621.html"
27 dc:subject="Texas Instruments"
28 dc:description=" Built DBD::MySQL for Solaris Having problems building DBD::MySQL for Linux..."
30 dc:date="2007-03-07T17:44:17-06:00" />
37 <script type="text/javascript" src="http://defaria.com/blogs/Status/mt-site.js"></script>
39 <body class="layout-one-column" onload="individualArchivesOnLoad(commenter_name)">
41 <div id="container-inner" class="pkg">
44 <div id="banner-inner" class="pkg">
45 <h1 id="banner-header"><a href="http://defaria.com/blogs/Status/" accesskey="1">Status for Andrew DeFaria</a></h1>
46 <h2 id="banner-description">Searchable status reports and work log</h2>
51 <div id="pagebody-inner" class="pkg">
53 <div id="alpha-inner" class="pkg">
55 <p class="content-nav">
56 <a href="http://defaria.com/blogs/Status/archives/000612.html">« VOB UUIDs</a> |
57 <a href="http://defaria.com/blogs/Status/">Main</a>
58 | <a href="http://defaria.com/blogs/Status/archives/000622.html">Clearcase License Graphs »</a>
62 <div class="entry" id="entry-621">
63 <h3 class="entry-header">Building DBD::MySQL</h3>
64 <div class="entry-content">
65 <div class="entry-body">
67 <li>Built DBD::MySQL for Solaris</li>
69 <li>Having problems building DBD::MySQL for Linux</li>
73 <div id="more" class="entry-more">
74 <h2>How to build DBD::MySQL</h2>
76 <p>After downloading DBD::mysql from
77 <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>
79 <p>Then one needs to give the proper parameters to generate the Makefile:</p>
82 $ export PATH=$PATH:/apps/mysql/4.0.16/bin
83 $ /apps/cmpackages/perl/bin/perl Makefile.PL \
84 > --libs="-L/apps/mysql/4.0.16/lib/mysql -lmysqlclient -lz" \
85 > --cflags=-I/apps/mysql/4.0.16/include/mysql \
86 > --testhost=mysql01.dal.design.ti.com \ <font
87 color="#ff0000"><i>These will not always be the same</i></font>
88 > --testuser=ccprojects \ <font color="#ff0000"><i>This will change</i></font>
89 > --testpassword=ccpr0jects <font color="#ff0000"><i>This will change (note the 0 not O)</i></font>
92 <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>
94 <p>This will produce a Makefile which you then do:</p>
101 <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>
103 <p>Turns out that perl Makefile.PL <<i>options</i>> specifies which perl to use thus the following appears in the generated Makefile:</p>
105 <div class=code><pre>
106 INSTALLPRIVLIB = /apps/cmpackages/perl/lib/5.8.0
107 INSTALLSITELIB = /apps/cmpackages/perl/lib/site_perl/5.8.0
109 INSTALLARCHLIB = /apps/cmpackages/perl/lib/5.8.0/sun4-solaris-thread-multi
110 INSTALLSITEARCH = /apps/cmpackages/perl/lib/site_perl/5.8.0/sun4-solaris-thread-multi
112 INSTALLBIN = /apps/cmpackages/perl/bin
113 INSTALLSITEBIN = /apps/cmpackages/perl/bin
115 INSTALLSCRIPT = /apps/cmpackages/perl/bin
118 <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>
121 <p class="entry-footer">
122 <span class="post-footers">Posted by on March 7, 2007 5:44 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000621.html">Permalink</a>
127 <div class="trackbacks">
128 <h3 id="trackback" class="trackbacks-header">TrackBack</h3>
129 <div id="trackbacks-info">
130 <p>TrackBack URL for this entry:<br />http://defaria.com/mt/mt-tb.cgi/10</p>
132 <div class="trackbacks-content">