I have been trying (unsuccessfully) all day to install the DBD::mysql package (DBI was installed yesterday). I work in the computer support department at the university I attend, and the basic way things work here is if something isn't important or urgent enough for my boss to have to deal with, he assigns it to whoever is available, so everything is a hodge-podge of Unix shell scripts, PHP, Javascript, Perl, whatever the person who was assigned the project happened to be (somewhat) proficient in. I am trying to re-write a shell script in Perl to make the database queries more efficient--and because I thought it would be easier to re-write the script than learn how to format the output exactly how it needs to be done in Shell.

The problem I have come up against now is that the MySQL server is running on a socket in a location other than the default MySQL socket, so the DBD::mysql package doesn't pass the make test stage. The test script uses the outdated (and no longer supported) Perl Mysql object of the form Mysql->connect($host, $db, $user, $pw); and does not support user-specified sockets, so I get an error message saying the server is not running or I do not have access rights to the database. I tried changing the test script to use DBI->connect($dns, $user, $pass); which allows you to specify the socket and configuration file to use, but DBI doesn't support the Mysql object method getserverinfo used in the test script. Any suggestions on what to try now? Should I assume since I know what's causing the errors that DBD::mysql is safe to install and skip the make test stage? (I hate to assume...)

In reply to Installing DBD::mysql by bnanaboy

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.