Hi, I created a CGI perl script that will be placed on a school server. I have secured from the school a MySQL account for a DB backend for my script and a unix account on a Sun box (Solaris 9, I believe). I made this program on my own Linux box and now I would like to migrate it to the Sun CGI server. After doing a "perl -MCPAN -e shell" plus "install DBI" on the Sun box, perl initialized and downloaded the appropriate packages. However, this Sun box does not have the "make" command on it. Therefore, when perl tries to compile the DBI package, it fails (I didn't even know that DBI needed to be compiled). Within my project directory, I also have a modules directory (which I "included" in each of my program files). This allows me to include all sorts of extra perl modules without installing them through CPAN; I can just copy them over from one server to another. Originally, I had copied the DBI module into that included directory. However, if that module is, indeed, a compiled module (as it seems like it might be), it won't run on the Sun box either. Mainly, I am looking for the easiest solution that would allow me to access a MySQL style database. One person once told me about DBI::MySQLlite (or something like that). This might be an option, but I am not sure if it needs to be compiled as well. Does anyone have any information on this module? Also, I don't want to give up on the actual MySQL database and the DBI module. Does anyone know how I might compile the DBI module (without the "make" command) so it will work on the Sun or does anyone have any other ideas? I would prefer not to have to change all of my database function calls. This type of situation has always been one of my greatest fears when designing this project and now it is comming true ;-) Thank you for looking at my problem. Have a nice week, Joe

In reply to DBI Install Problem by JoeJaz

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.