Re: How to detect if a table exists, with DBD::DBM

2011-04-04 Thread David McMath
On 04/03/2011 06:18 AM, Jens Rehsack wrote: On 04/01/11 17:15, David McMath wrote: Dear List, Hi David, I quick reply now without taking a look into the details of the implementation to prevent that I forget you (I'm currently busy with other tasks ...). ... I've tried &

How to detect if a table exists, with DBD::DBM

2011-04-01 Thread David McMath
Dear List, The short version of my question is: Using DBD::DBM, is there a simple way to tell whether a table exists? (Other than just trying to query it and handling failure.) I've tried "$dbh->{'dbm_tables'}" which seemed promising, except that it's always empty until I actually execute

Re: Are MySql passwords sent in the clear?

2010-07-06 Thread David McMath
I think the quoted section is more about how passwords are stored in the database itself than about how they're communicated during login. I read http://dev.mysql.com/doc/refman/5.5/en/secure-connections.html to suggest that there isn't much encryption going on at all, particularly The standar

Re: How to suss out module dependencies...

2010-05-27 Thread David McMath
We dealt with a similar problem, moving from comfortable old server to a shiny new one. Perlmonks had some interesting advice: http://perlmonks.org/?node_id=203148 which I think is pretty cool (even though I only barely understand what it's going). One of our folks ended up, though,

Does DBD::Oracle handle failover for RAC?

2010-05-21 Thread David McMath
Dear List, I posted this questions to perl.dbi.users but I understand that the mailing list is a better place to get information. I am experiencing a problem in which, when one node of my 11g RAC fails, all the connections to that node get hung for a while. Some applications support transpa