defaria.com/blogs/Status/archives/week_2007_03_11.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 11, 2007 - March 17, 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_03_04.html" title="March  4, 2007 - March 10, 2007" />
  16    <link rel="next" href="http://defaria.com/blogs/Status/archives/week_2007_03_18.html" title="March 18, 2007 - March 24, 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_03_04.html">&laquo; March  4, 2007 - March 10, 2007</a> |
  36                         <a href="http://defaria.com/blogs/Status/">Main</a>
  37                         | <a href="http://defaria.com/blogs/Status/archives/week_2007_03_18.html">March 18, 2007 - March 24, 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_11.html#entry-000624"
  47     trackback:ping="http://defaria.com/mt/mt-tb.cgi/13"
  48     dc:title="MySQL Client Libraries"
  49     dc:identifier="http://defaria.com/blogs/Status/archives/week_2007_03_11.html#entry-000624"
  50     dc:subject="Texas Instruments"
  51     dc:description=" Worked on solutions for MySQL client library problem..."
  52     dc:creator=""
  53     dc:date="2007-03-16T17:32:56-06:00" />
  54 </rdf:RDF>
  55 -->
  56
  57
  58                      <h2 class="date-header">March 16, 2007</h2>
  59                      <a id="a000624"></a>
  60                      <div class="entry" id="entry-624">
  61                         <h3 class="entry-header">MySQL Client Libraries</h3>
  62                         <div class="entry-content">
  63                            <div class="entry-body">
  64                               <ul>
  65   <li>Worked on solutions for MySQL client library problem</li>
  66 </ul>
  67
  68                               Andrew DeFaria wrote:
  69 <blockquote type="cite"> Chris Davey
  70 wrote:
  71   <blockquote type="cite">
  72 <p>Andrew</p>
  73
  74 <p>have update the /apps/cmpackages as per the web page ane try the new version of mkview_linked but faile to run:</p>
  75
  76 <h3>sunos</h3>
  77
  78 <div class=code><pre>
  79 warmflash,a0741187&gt; ./mkview_linked
  80 install_driver(mysql) failed: Can't load
  81 '/apps/cmpackages/perl/lib/site_perl/5.8.0/sun4-solaris-thread-multi/auto/DBD/mysql/mysql.so'
  82 for module DBD::mysql: ld.so.1: mkview_linked: fatal:
  83 libmysqlclient.so.12: open failed: No such file or directory at
  84 /apps/cmpackages/perl/lib/5.8.0/sun4-solaris-thread-multi/DynaLoader.pm
  85 line 229.
  86 at (eval 1) line 3
  87 Compilation failed in require at (eval 1) line 3.
  88 Perhaps a required shared library or dll isn't installed where expected
  89 at ./mkview_linked line 54
  90
  91 warmflash,a0741187&gt; ls -l
  92 /apps/cmpackages/perl/lib/site_perl/5.8.0/sun4-solaris-thread-multi/auto/DBD/mysql
  93 total 712
  94 -r--r--r-- 1 amemgr ameadm 0 Mar 16 09:05 mysql.bs
  95 -r-xr-xr-x 1 amemgr ameadm 360080 Mar 16 09:05 mysql.so*
  96 </pre></div>
  97
  98 <h3>linux</h3>
  99
 100 <div class=code><pre>
 101 ace.tiuk.ti.com,a0741187&gt; ./mkview_linked
 102 install_driver(mysql) failed: Can't load
 103 '/apps/cmpackages/perl/lib/site_perl/5.8.0/i686-linux-thread-multi/auto/DBD/mysql/mysql.so'
 104 for module DBD::mysql: libmysqlclient.so.12: cannot open shared object
 105 file: No such file or directory at
 106 /apps/cmpackages/perl/lib/5.8.0/i686-linux-thread-multi/DynaLoader.pm
 107 line 229.
 108 at (eval 1) line 3
 109 Compilation failed in require at (eval 1) line 3.
 110 Perhaps a required shared library or dll isn't installed where expected
 111 at ./mkview_linked line 54
 112 ace.tiuk.ti.com,a0741187&gt; ls -l
 113 /apps/cmpackages/perl/lib/site_perl/5.8.0/sun4-solaris-thread-multi/auto/DBD/mysql
 114 ls:
 115 /apps/cmpackages/perl/lib/site_perl/5.8.0/sun4-solaris-thread-multi/auto/DBD/mysql:
 116 No such file or directory
 117 </pre></div>
 118   </blockquote>
 119
 120 <p>The problem seems to be that you lack /apps/mysql/&lt;version&gt; which is what we used to build the DBD::mysql package. We are working on alternate solutions. Meantime could you try the following:</p>
 121
 122   <ul>
 123     <li>mkdir /apps/mysql</li>
 124     <li>On Solaris (warmflash): rsync -rlz
 125 stashu.dal.design.ti.com:/apps/mysql/4.0.16 /apps/mysql</li>
 126     <li>On Linux (ace): rsync -rlz
 127 drteeth.dal.design.ti.com:/apps/mysql/4.0.17 /app/mysql</li>
 128   </ul>
 129
 130 <p>Try mkview_linked. Let us know.</p>
 131
 132 </blockquote>
 133
 134 <h1>Meantime back at the lab...</h1>
 135
 136 <h2>Short version:</h2>
 137
 138 <p>Nix the rsyncing of /apps/mysql and redo the rsync of /apps/cmpackages. We're put a copy of mysql under /apps/cmpackages. After refreshing your /apps/cmpackages area you should see an /apps/cmpackages/mysql directory. Then test mkview_linked again.</p>
 139
 140 <h2>Long version (AKA the gory details...)</h2>
 141
 142 <p>In order to get mkview_linked to use DBD::mysql, the Perl package of mysql must be compiled and installed. Perl packages often glue some subsystem's API (in this case MySQL), normally written in C or something like that to a Perl package (i.e. a .pm file). So on the one
 143 end we have architecturally dependent code (usually a .a or .so library) and on the other we have (hopefully) architecturally neutral and interpreted Perl code (the .pm module). Therefore the process usually involves a makefile, execution of gcc to compile the <i>glue code</i> between the Perl and the subsystem's API as well as installing into the proper place, all of these files.</p>
 144
 145 <p>When Perl then calls the module DynaLoader.pm gets involved to load the appropriate architecturally dependent libraries so that calls to the Perl subroutines flow through the glue code and the appropriate API is called.</p>
 146
 147 <p>Since architecturally dependent code is involved we need to build this for the different architectures that we support. Further, MySQL in particular, has it's own library, libmysqlclient.a, which contains the API itself. So the glue code (mysql.so) needs to locate and load the appropriate libmysqlclient.a before it can successfully call an API. Finally there are issues of the version number of the, in this case, client software and the server software. Suffice to say, this is not always easy stuff!</p>
 148
 149 <p>Oh and we need mention that we are also talking about a large corporation here with various sites and the like; in most cases MySQL's client libraries will <b>not</b> be available locally nor of the right version - IOW we cannot trust that the MySQL client libraries will be local.</p>
 150
 151 <p>Oh and did I mention that mysql is not officially supported by TI...</p>
 152
 153 <p>We had hoped that /apps/mysql/&lt;version&gt;, while not officially supported, would be widely available but on our first guinea pi... ah... test subject, TI UK, we found that not to be the case. It looked like we had two ways to go: either 1) copy the /apps/mysql/&lt;version&gt; over to the remote sites or 2) include the /apps/mysql/&lt;version&gt; trees under /apps/cmpackages as our own mini distribution. I've implemented the latter. Now refreshing your /apps/cmpackages tree will carry along the necessary MySQL client libraries necessary to support mkview_linked and friends in most situations.</p>
 154
 155                               <p class="entry-footer">
 156                                  <span class="post-footers">Posted by  at  5:32 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000624.html">Permalink</a>
 157
 158                                  | <a href="http://defaria.com/blogs/Status/archives/000624.html#trackback">TrackBacks (0)</a>
 159                               </p>
 160                            </div>
 161                         </div>
 162                      </div>
 163
 164                      <!--
 165 <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
 166          xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/"
 167          xmlns:dc="http://purl.org/dc/elements/1.1/">
 168 <rdf:Description
 169     rdf:about="http://defaria.com/blogs/Status/archives/week_2007_03_11.html#entry-000623"
 170     trackback:ping="http://defaria.com/mt/mt-tb.cgi/12"
 171     dc:title="Remote sites/mkview"
 172     dc:identifier="http://defaria.com/blogs/Status/archives/week_2007_03_11.html#entry-000623"
 173     dc:subject="Texas Instruments"
 174     dc:description=" Gained access to a few new remote sites. Updated GPDB. Alas there&apos;s no DesignSync info at these sites and none of the vobs have vobstorage paths that indicate a project! Got access to cmmgr but was unable to publish..."
 175     dc:creator=""
 176     dc:date="2007-03-13T17:26:14-06:00" />
 177 </rdf:RDF>
 178 -->
 179
 180
 181                      <h2 class="date-header">March 13, 2007</h2>
 182                      <a id="a000623"></a>
 183                      <div class="entry" id="entry-623">
 184                         <h3 class="entry-header">Remote sites/mkview</h3>
 185                         <div class="entry-content">
 186                            <div class="entry-body">
 187                               <ul>
 188   <li>Gained access to a few new remote sites. Updated GPDB. Alas there's no DesignSync info at these sites and none of the vobs have vobstorage paths that indicate a project!</li>
 189
 190   <li>Got access to cmmgr but was unable to publish new mysql from all architectures</li>
 191
 192   <li>Started incorporating the UK changes into mkview. Need to replicate these to mkview_linked (?)</li>
 193 </ul>
 194
 195                               <p class="entry-footer">
 196                                  <span class="post-footers">Posted by  at  5:26 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000623.html">Permalink</a>
 197
 198                                  | <a href="http://defaria.com/blogs/Status/archives/000623.html#trackback">TrackBacks (0)</a>
 199                               </p>
 200                            </div>
 201                         </div>
 202                      </div>
 203
 204                   </div>
 205                </div>
 206             </div>
 207          </div>
 208       </div>
 209    </div>
 210 </body>
 211 </html>