I am writing a program which report user print quota under unix by running >pquota (which do a whoami, and query the remote DB then)

the quota database(MySql) is not located the same machine where users log on. so here is the problem that i am not
sure how do i go about writing a program that query the remote database securely.

one way i am thinking of is to use Net::SSH::Perl log in the remote database server and do a local query, then
return the result. but then i will need a login user for this. in addition, i need to save this user name and password in somewhere that other users can't read.

any suggestions how to write a secure program does that?

if you know there is print quota app available, please do share.

thanks

Qiang

In reply to ideas needed to query remote database securely by Qiang

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.