D'OH!!!

I finally, with the help of LD2 and dkubb resolved my issue. It turned out, that I am a giant idiot, and loudmouth, and that kind of prevented me from getting help earlier. Either that, or people thought: "Hey, look it, he's a saint, he don't need our help." and didn't bother to read me node.

Anyway, in the end I had to provide the full path to .my.cnf since mysqld was running as root, and most likely was trying to read /usr/home/root/.my.cnf or some such nonsense. Also, I've type in the .cnf verbose=1 where all I needed was verbose, since it's a standalone switch. I also head some key=value pairs which were not valid switches, like compression, and username(which i knew wasn't an option). Besides that, I also "learned" that you have to prepare before you execute. I am really ashamed that I made this type of mistake (i've done plenty of work with DBI to know how to use it, but *sigh* I regress), but I'm even more *disturbed* that nobody called me on it ( until I really really bugged dkubb). I've considered considering this node for deletion, or just /tell'ing my buddy the NodeReaper to do me a favor, but then I remembered who I was, and figured nobody will hold it against me, and somebody, or at least I, will benefit from this reminder.

Why oh why can't I hide my password using DBI?
just in case anyone asks for it: 
sh-2.05$ perl test.pl
DBI->connect(;mysql_read_default_file=~/.my.cnf;mysql_read_default_gro
+up=perlgroup;) failed: Access denied for user: 'crazyinsomniac_r@loca
+lhost' (Using password: NO) at test.pl line 36

[download]
update: July 28,2001
upon suggestion of LD2, I ran/usr/local/bin/my_print_defaults and it yielded the expected results: 
bash-2.05$ my_print_defaults client
--host=localhost
--user=crazyinsomniac_r
--username=crazyinsomniac_r
--password=elpaseo_r
--mysql_compression=1
--verbose=1

bash-2.05$ my_print_defaults perlgroup
--host=localhost
--user=crazyinsomniac_r
--username=crazyinsomniac_r
--password=elpaseo_r
--mysql_compression=1
--verbose=1

bash-2.05$ my_print_defaults perlgroup client
--host=localhost
--user=crazyinsomniac_r
--username=crazyinsomniac_r
--password=elpaseo_r
--mysql_compression=1
--verbose=1
--host=localhost
--user=crazyinsomniac_r
--username=crazyinsomniac_r
--password=elpaseo_r
--mysql_compression=1
--verbose=1

bash-2.05$ my_print_defaults --config-file=~/.my.cnf client perlgroup
--host=localhost
--user=crazyinsomniac_r
--username=crazyinsomniac_r
--password=elpaseo_r
--mysql_compression=1
--verbose=1
--host=localhost
--user=crazyinsomniac_r
--username=crazyinsomniac_r
--password=elpaseo_r
--mysql_compression=1
--verbose=1

bash-2.05$ my_print_defaults --defaults-file=~/.my.cnf client perlgrou
+p
--host=localhost
--user=crazyinsomniac_r
--username=crazyinsomniac_r
--password=elpaseo_r
--mysql_compression=1
--verbose=1
--host=localhost
--user=crazyinsomniac_r
--username=crazyinsomniac_r
--password=elpaseo_r
--mysql_compression=1
--verbose=1

[download]

 
___crazyinsomniac_______________________________________
Disclaimer: Don't blame. It came from inside the void
perl -e "$q=$_;map({chr unpack qq;H*;,$_}split(q;;,q*H*));print;$q/$q;"

In reply to (crazyinsomniac: D'OH!)Re: DBI:mysql and mysql_read_default_file trouble by crazyinsomniac
in thread DBI:mysql and mysql_read_default_file trouble by crazyinsomniac

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.