if you could kindly submit ... more-specific, information

Locate your mysql.so file (presumably ./lib/perl/5.8.8/auto/DBD/mysql/mysql.so) and run (from outside of Apache, where things (hopefully) work — but on the same machine):

$ ldd /path/to/mysql.so

[download]

This should list its dependencies, among which there is probably something like libmysqlclient.so.15 (if everything is OK, there should be no "... => not found" entries). Note the path where this lib is found, and then arrange for the LD_LIBRARY_PATH environment variable to contain that directory in the environment of the CGI program. See "man ld.so" for what this is about. One way to set it could be in a BEGIN block in your CGI script, e.g. (I'm appending here, just in case it's non-empty)

BEGIN {
    $ENV{LD_LIBRARY_PATH} .= ":/path/to/lib";
}

[download]

Other ways would be to use a shell wrapper, or via the SetEnv Apache config directive.

BTW, which platform are you on? I'm asking because (a) the respective system tools (like ldd) might be different, (b) there is a special issue with LD_LIBRARY_PATH on Solaris, which might apply here... sorry, overlooked the "linux host" in your OP

In reply to Re^2: Do XS-components require special considerations with CGI? by almut
in thread Do XS-components require special considerations with CGI? [SOLVED] by locked_user sundialsvc4

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.