2 <html lang="en-us" itemscope itemtype="http://schema.org/Article">
5 <meta name="description" content=" Worked on solutions for MySQL client library problem...">
6 <meta name="generator" content="Movable Type 5.2.3">
7 <title>MySQL Client Libraries - 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/mysql-client-li.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/03/remote-sitesmkv.html" title="Remote sites/mkview">
20 <link rel="next" href="http://defaria.com/blogs/Status/2007/03/gpdb-web-update.html" title="GPDB Web Update/Oracle testing">
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="MySQL Client Libraries">
25 <meta property="og:url" content="http://defaria.com/blogs/Status/2007/03/mysql-client-li.html">
26 <meta property="og:description" content=" Worked on solutions for MySQL client library problem...">
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=" Worked on solutions for MySQL client library problem...">
31 <link itemprop="url" href="http://defaria.com/blogs/Status/2007/03/mysql-client-li.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">MySQL Client Libraries</li>
67 <div id="individual-main" class="main" role="main">
68 <article id="entry-1873" class="entry entry-asset asset hentry">
69 <div class="asset-header">
70 <h2 itemprop="name" class="asset-name entry-title">MySQL Client Libraries</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-16T17:32:56-08:00" itemprop="datePublished">March 16, 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>Worked on solutions for MySQL client library problem</li>
88 <blockquote type="cite"> Chris Davey
90 <blockquote type="cite">
93 <p>have update the /apps/cmpackages as per the web page ane try the new version of mkview_linked but faile to run:</p>
98 warmflash,a0741187> ./mkview_linked
99 install_driver(mysql) failed: Can't load
100 '/apps/cmpackages/perl/lib/site_perl/5.8.0/sun4-solaris-thread-multi/auto/DBD/mysql/mysql.so'
101 for module DBD::mysql: ld.so.1: mkview_linked: fatal:
102 libmysqlclient.so.12: open failed: No such file or directory at
103 /apps/cmpackages/perl/lib/5.8.0/sun4-solaris-thread-multi/DynaLoader.pm
106 Compilation failed in require at (eval 1) line 3.
107 Perhaps a required shared library or dll isn't installed where expected
108 at ./mkview_linked line 54
110 warmflash,a0741187> ls -l
111 /apps/cmpackages/perl/lib/site_perl/5.8.0/sun4-solaris-thread-multi/auto/DBD/mysql
113 -r--r--r-- 1 amemgr ameadm 0 Mar 16 09:05 mysql.bs
114 -r-xr-xr-x 1 amemgr ameadm 360080 Mar 16 09:05 mysql.so*
119 <div class=code><pre>
120 ace.tiuk.ti.com,a0741187> ./mkview_linked
121 install_driver(mysql) failed: Can't load
122 '/apps/cmpackages/perl/lib/site_perl/5.8.0/i686-linux-thread-multi/auto/DBD/mysql/mysql.so'
123 for module DBD::mysql: libmysqlclient.so.12: cannot open shared object
124 file: No such file or directory at
125 /apps/cmpackages/perl/lib/5.8.0/i686-linux-thread-multi/DynaLoader.pm
128 Compilation failed in require at (eval 1) line 3.
129 Perhaps a required shared library or dll isn't installed where expected
130 at ./mkview_linked line 54
131 ace.tiuk.ti.com,a0741187> ls -l
132 /apps/cmpackages/perl/lib/site_perl/5.8.0/sun4-solaris-thread-multi/auto/DBD/mysql
134 /apps/cmpackages/perl/lib/site_perl/5.8.0/sun4-solaris-thread-multi/auto/DBD/mysql:
135 No such file or directory
139 <p>The problem seems to be that you lack /apps/mysql/<version> which is what we used to build the DBD::mysql package. We are working on alternate solutions. Meantime could you try the following:</p>
142 <li>mkdir /apps/mysql</li>
143 <li>On Solaris (warmflash): rsync -rlz
144 stashu.dal.design.ti.com:/apps/mysql/4.0.16 /apps/mysql</li>
145 <li>On Linux (ace): rsync -rlz
146 drteeth.dal.design.ti.com:/apps/mysql/4.0.17 /app/mysql</li>
149 <p>Try mkview_linked. Let us know.</p>
153 <h1>Meantime back at the lab...</h1>
155 <h2>Short version:</h2>
157 <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>
159 <h2>Long version (AKA the gory details...)</h2>
161 <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
162 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>
164 <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>
166 <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>
168 <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>
170 <p>Oh and did I mention that mysql is not officially supported by TI...</p>
172 <p>We had hoped that /apps/mysql/<version>, 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/<version> over to the remote sites or 2) include the /apps/mysql/<version> 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>
174 <nav class="page-navigation entry-navigation pagination content-nav">
175 <ul class="page-navigation-list">
177 <li class="page-navigation-list-item page-navigation-prev"><a rel="prev" href="http://defaria.com/blogs/Status/2007/03/remote-sitesmkv.html" title="Remote sites/mkview">Previous entry</a></li>
180 <li class="page-navigation-list-item page-navigation-next"><a rel="next" href="http://defaria.com/blogs/Status/2007/03/gpdb-web-update.html" title="GPDB Web Update/Oracle testing">Next entry</a></li>
185 <aside id="zenback" class="zenback feedback">
186 Please paste Zenback script code here.
193 <aside class="widgets related" role="complementary">
194 <nav class="widget-search widget">
195 <div class="widget-content">
196 <form method="get" id="search" action="http://defaria.com/mt/mt-search.cgi">
198 <input type="text" name="search" value="" placeholder="Search...">
200 <input type="hidden" name="IncludeBlogs" value="8">
202 <input type="hidden" name="limit" value="20">
203 <button type="submit" name="button">
204 <img alt="Search" src="/mt/mt-static/support/theme_static/rainier/img/search-icon.png">
210 <nav class="widget-archive-category widget">
211 <h3 class="widget-header">Categories</h3>
212 <div class="widget-content">
215 <ul class="widget-list">
218 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/ameriquest/">Ameriquest (99)</a>
226 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/audience/">Audience (3)</a>
234 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/broadcom/">Broadcom (76)</a>
242 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/gpdb/">GPDB (35)</a>
250 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-dynamics/">General Dynamics (61)</a>
258 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-electric/">General Electric (13)</a>
266 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/hewlett-packard/">Hewlett Packard (13)</a>
274 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/lynuxworks/">LynuxWorks (162)</a>
282 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/pqa/">PQA (35)</a>
290 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/salira/">Salira (79)</a>
298 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/tellabs/">Tellabs (2)</a>
306 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/texas-instruments/">Texas Instruments (31)</a>
318 <nav class="widget-archive-dropdown widget">
319 <h3 class="widget-header">Archives</h3>
320 <div class="widget-content">
322 <option>Select a Month...</option>
324 <option value="http://defaria.com/blogs/Status/2016/02/">February 2016</option>
328 <option value="http://defaria.com/blogs/Status/2014/09/">September 2014</option>
332 <option value="http://defaria.com/blogs/Status/2014/04/">April 2014</option>
336 <option value="http://defaria.com/blogs/Status/2014/03/">March 2014</option>
340 <option value="http://defaria.com/blogs/Status/2013/02/">February 2013</option>
344 <option value="http://defaria.com/blogs/Status/2012/09/">September 2012</option>
348 <option value="http://defaria.com/blogs/Status/2012/08/">August 2012</option>
352 <option value="http://defaria.com/blogs/Status/2012/05/">May 2012</option>
356 <option value="http://defaria.com/blogs/Status/2012/04/">April 2012</option>
360 <option value="http://defaria.com/blogs/Status/2012/02/">February 2012</option>
364 <option value="http://defaria.com/blogs/Status/2012/01/">January 2012</option>
368 <option value="http://defaria.com/blogs/Status/2011/10/">October 2011</option>
372 <option value="http://defaria.com/blogs/Status/2011/07/">July 2011</option>
376 <option value="http://defaria.com/blogs/Status/2010/09/">September 2010</option>
380 <option value="http://defaria.com/blogs/Status/2010/08/">August 2010</option>
384 <option value="http://defaria.com/blogs/Status/2010/04/">April 2010</option>
388 <option value="http://defaria.com/blogs/Status/2010/03/">March 2010</option>
392 <option value="http://defaria.com/blogs/Status/2010/02/">February 2010</option>
396 <option value="http://defaria.com/blogs/Status/2009/05/">May 2009</option>
400 <option value="http://defaria.com/blogs/Status/2009/04/">April 2009</option>
404 <option value="http://defaria.com/blogs/Status/2008/07/">July 2008</option>
408 <option value="http://defaria.com/blogs/Status/2008/05/">May 2008</option>
412 <option value="http://defaria.com/blogs/Status/2008/04/">April 2008</option>
416 <option value="http://defaria.com/blogs/Status/2008/03/">March 2008</option>
420 <option value="http://defaria.com/blogs/Status/2008/02/">February 2008</option>
424 <option value="http://defaria.com/blogs/Status/2008/01/">January 2008</option>
428 <option value="http://defaria.com/blogs/Status/2007/12/">December 2007</option>
432 <option value="http://defaria.com/blogs/Status/2007/11/">November 2007</option>
436 <option value="http://defaria.com/blogs/Status/2007/10/">October 2007</option>
440 <option value="http://defaria.com/blogs/Status/2007/09/">September 2007</option>
444 <option value="http://defaria.com/blogs/Status/2007/08/">August 2007</option>
448 <option value="http://defaria.com/blogs/Status/2007/07/">July 2007</option>
452 <option value="http://defaria.com/blogs/Status/2007/06/">June 2007</option>
456 <option value="http://defaria.com/blogs/Status/2007/05/">May 2007</option>
460 <option value="http://defaria.com/blogs/Status/2007/04/">April 2007</option>
464 <option value="http://defaria.com/blogs/Status/2007/03/">March 2007</option>
468 <option value="http://defaria.com/blogs/Status/2007/01/">January 2007</option>
472 <option value="http://defaria.com/blogs/Status/2006/12/">December 2006</option>
476 <option value="http://defaria.com/blogs/Status/2006/11/">November 2006</option>
480 <option value="http://defaria.com/blogs/Status/2006/10/">October 2006</option>
484 <option value="http://defaria.com/blogs/Status/2006/09/">September 2006</option>
488 <option value="http://defaria.com/blogs/Status/2006/07/">July 2006</option>
492 <option value="http://defaria.com/blogs/Status/2006/06/">June 2006</option>
496 <option value="http://defaria.com/blogs/Status/2006/05/">May 2006</option>
500 <option value="http://defaria.com/blogs/Status/2006/04/">April 2006</option>
504 <option value="http://defaria.com/blogs/Status/2006/03/">March 2006</option>
508 <option value="http://defaria.com/blogs/Status/2006/02/">February 2006</option>
512 <option value="http://defaria.com/blogs/Status/2006/01/">January 2006</option>
516 <option value="http://defaria.com/blogs/Status/2005/12/">December 2005</option>
520 <option value="http://defaria.com/blogs/Status/2005/11/">November 2005</option>
524 <option value="http://defaria.com/blogs/Status/2005/10/">October 2005</option>
528 <option value="http://defaria.com/blogs/Status/2005/09/">September 2005</option>
532 <option value="http://defaria.com/blogs/Status/2005/08/">August 2005</option>
536 <option value="http://defaria.com/blogs/Status/2005/07/">July 2005</option>
540 <option value="http://defaria.com/blogs/Status/2005/06/">June 2005</option>
544 <option value="http://defaria.com/blogs/Status/2005/05/">May 2005</option>
548 <option value="http://defaria.com/blogs/Status/2005/04/">April 2005</option>
552 <option value="http://defaria.com/blogs/Status/2005/03/">March 2005</option>
556 <option value="http://defaria.com/blogs/Status/2005/02/">February 2005</option>
560 <option value="http://defaria.com/blogs/Status/2005/01/">January 2005</option>
564 <option value="http://defaria.com/blogs/Status/2004/12/">December 2004</option>
568 <option value="http://defaria.com/blogs/Status/2004/09/">September 2004</option>
572 <option value="http://defaria.com/blogs/Status/2004/08/">August 2004</option>
576 <option value="http://defaria.com/blogs/Status/2004/07/">July 2004</option>
580 <option value="http://defaria.com/blogs/Status/2004/06/">June 2004</option>
584 <option value="http://defaria.com/blogs/Status/2004/05/">May 2004</option>
588 <option value="http://defaria.com/blogs/Status/2004/04/">April 2004</option>
592 <option value="http://defaria.com/blogs/Status/2004/03/">March 2004</option>
596 <option value="http://defaria.com/blogs/Status/2004/02/">February 2004</option>
600 <option value="http://defaria.com/blogs/Status/2004/01/">January 2004</option>
604 <option value="http://defaria.com/blogs/Status/2003/12/">December 2003</option>
608 <option value="http://defaria.com/blogs/Status/2003/11/">November 2003</option>
616 <div class="widget-syndication widget section">
617 <div class="widget-content">
618 <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>
626 <footer id="footer" role="contentinfo">
627 <div id="footer-inner">
628 <div id="footer-content">
629 <nav role="navigation">
631 <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
637 <p class="license">© Copyright 2016.</p>
638 <p class="poweredby">Powered by <a href="http://www.movabletype.org/">Movable Type</a></p>
644 <script src="http://defaria.com/mt/mt-static/jquery/jquery.min.js"></script>
645 <script src="http://defaria.com/blogs/Status/mt-theme-scale2.js"></script>