defaria.com/blogs/Status/archives/week_2007_03_04.html

   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">
   4 <head>
   5    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
   6    <meta name="generator" content="Movable Type 5.2.3" />
   7
   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"$>" />
  11
  12    <title>Status for Andrew DeFaria: March  4, 2007 - March 10, 2007 Archives</title>
  13
  14    <link rel="start" href="http://defaria.com/blogs/Status/" title="Home" />
  15    <link rel="prev" href="http://defaria.com/blogs/Status/archives/week_2007_01_14.html" title="January 14, 2007 - January 20, 2007" />
  16    <link rel="next" href="http://defaria.com/blogs/Status/archives/week_2007_03_11.html" title="March 11, 2007 - March 17, 2007" />
  17 </head>
  18 <body class="layout-one-column">
  19    <div id="container">
  20       <div id="container-inner" class="pkg">
  21
  22          <div id="banner">
  23             <div id="banner-inner" class="pkg">
  24                <h1 id="banner-header"><a href="http://defaria.com/blogs/Status/" accesskey="1">Status for Andrew DeFaria</a></h1>
  25                <h2 id="banner-description">Searchable status reports and work log</h2>
  26             </div>
  27          </div>
  28
  29          <div id="pagebody">
  30             <div id="pagebody-inner" class="pkg">
  31                <div id="alpha">
  32                   <div id="alpha-inner" class="pkg">
  33
  34                      <p class="content-nav">
  35                         <a href="http://defaria.com/blogs/Status/archives/week_2007_01_14.html">&laquo; January 14, 2007 - January 20, 2007</a> |
  36                         <a href="http://defaria.com/blogs/Status/">Main</a>
  37                         | <a href="http://defaria.com/blogs/Status/archives/week_2007_03_11.html">March 11, 2007 - March 17, 2007 &raquo;</a>
  38                      </p>
  39
  40
  41                      <!--
  42 <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
  43          xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/"
  44          xmlns:dc="http://purl.org/dc/elements/1.1/">
  45 <rdf:Description
  46     rdf:about="http://defaria.com/blogs/Status/archives/week_2007_03_04.html#entry-000622"
  47     trackback:ping="http://defaria.com/mt/mt-tb.cgi/11"
  48     dc:title="Clearcase License Graphs"
  49     dc:identifier="http://defaria.com/blogs/Status/archives/week_2007_03_04.html#entry-000622"
  50     dc:subject="Texas Instruments"
  51     dc:description=" Worked on Clearcase License Graphs web page..."
  52     dc:creator=""
  53     dc:date="2007-03-08T18:52:25-06:00" />
  54 </rdf:RDF>
  55 -->
  56
  57
  58                      <h2 class="date-header">March  8, 2007</h2>
  59                      <a id="a000622"></a>
  60                      <div class="entry" id="entry-622">
  61                         <h3 class="entry-header">Clearcase License Graphs</h3>
  62                         <div class="entry-content">
  63                            <div class="entry-body">
  64                               <ul>
  65   <li>Worked on Clearcase License Graphs web page</lI>
  66 </ul>
  67
  68                               <p>Seems this set of scripts didn't like the additional of the Make licensing because Make licensing often had 0 usage. The 0 was being carried forward and used as a denominator for some divisions causing divide by zero errors. I fixed up these errors which then caused it to loop indefinitely. Seems a for loop didn't properly anticipate having a usage of 0. Fixed</p>
  69
  70                               <p class="entry-footer">
  71                                  <span class="post-footers">Posted by  at  6:52 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000622.html">Permalink</a>
  72
  73                                  | <a href="http://defaria.com/blogs/Status/archives/000622.html#trackback">TrackBacks (0)</a>
  74                               </p>
  75                            </div>
  76                         </div>
  77                      </div>
  78
  79                      <!--
  80 <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
  81          xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/"
  82          xmlns:dc="http://purl.org/dc/elements/1.1/">
  83 <rdf:Description
  84     rdf:about="http://defaria.com/blogs/Status/archives/week_2007_03_04.html#entry-000621"
  85     trackback:ping="http://defaria.com/mt/mt-tb.cgi/10"
  86     dc:title="Building DBD::MySQL"
  87     dc:identifier="http://defaria.com/blogs/Status/archives/week_2007_03_04.html#entry-000621"
  88     dc:subject="Texas Instruments"
  89     dc:description=" Built DBD::MySQL for Solaris Having problems building DBD::MySQL for Linux..."
  90     dc:creator=""
  91     dc:date="2007-03-07T17:44:17-06:00" />
  92 </rdf:RDF>
  93 -->
  94
  95
  96                      <h2 class="date-header">March  7, 2007</h2>
  97                      <a id="a000621"></a>
  98                      <div class="entry" id="entry-621">
  99                         <h3 class="entry-header">Building DBD::MySQL</h3>
 100                         <div class="entry-content">
 101                            <div class="entry-body">
 102                               <ul>
 103   <li>Built DBD::MySQL for Solaris</li>
 104
 105   <li>Having problems building DBD::MySQL for Linux</li>
 106 </ul>
 107
 108
 109                               <h2>How to build DBD::MySQL</h2>
 110
 111 <p>After downloading DBD::mysql from
 112 <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>
 113
 114 <p>Then one needs to give the proper parameters to generate the Makefile:</p>
 115
 116 <div class=code><pre>
 117 $ export PATH=$PATH:/apps/mysql/4.0.16/bin
 118 $ /apps/cmpackages/perl/bin/perl Makefile.PL \
 119 &gt;    --libs="-L/apps/mysql/4.0.16/lib/mysql -lmysqlclient -lz" \
 120 &gt;    --cflags=-I/apps/mysql/4.0.16/include/mysql \
 121 &gt;    --testhost=mysql01.dal.design.ti.com \&nbsp;&nbsp; <font
 122  color="#ff0000"><i>These will not always be the same</i></font>
 123 &gt;    --testuser=ccprojects \&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font color="#ff0000"><i>This will change</i></font>
 124 &gt;    --testpassword=ccpr0jects &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font color="#ff0000"><i>This will change (note the 0 not O)</i></font>
 125 </pre></div>
 126
 127 <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>
 128
 129 <p>This will produce a Makefile which you then do:</p>
 130
 131 <div class=code><pre>
 132 $ make
 133 $ make test
 134 </pre></div>
 135
 136 <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>
 137
 138 <p>Turns out that perl Makefile.PL &lt;<i>options</i>&gt; specifies which perl to use thus the following appears in the generated Makefile:</p>
 139
 140 <div class=code><pre>
 141 INSTALLPRIVLIB = /apps/cmpackages/perl/lib/5.8.0
 142 INSTALLSITELIB = /apps/cmpackages/perl/lib/site_perl/5.8.0
 143 INSTALLVENDORLIB =
 144 INSTALLARCHLIB = /apps/cmpackages/perl/lib/5.8.0/sun4-solaris-thread-multi
 145 INSTALLSITEARCH = /apps/cmpackages/perl/lib/site_perl/5.8.0/sun4-solaris-thread-multi
 146 INSTALLVENDORARCH =
 147 INSTALLBIN = /apps/cmpackages/perl/bin
 148 INSTALLSITEBIN = /apps/cmpackages/perl/bin
 149 INSTALLVENDORBIN =
 150 INSTALLSCRIPT = /apps/cmpackages/perl/bin
 151 </pre></div>
 152
 153 <p>Thus this means a make install will install the module into whichever Perl installation we specified in the perl Makefile.PL &lt;<i>options</i>&gt;! Alas we cannot write to those areas yet...</p>
 154
 155                               <p class="entry-footer">
 156                                  <span class="post-footers">Posted by  at  5:44 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000621.html">Permalink</a>
 157
 158                                  | <a href="http://defaria.com/blogs/Status/archives/000621.html#trackback">TrackBacks (0)</a>
 159                               </p>
 160                            </div>
 161                         </div>
 162                      </div>
 163
 164                   </div>
 165                </div>
 166             </div>
 167          </div>
 168       </div>
 169    </div>
 170 </body>
 171 </html>