Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

Re^3: What is the proper data structure for CAP::DBH?

by hippo (Bishop)
on Jan 18, 2023 at 13:53 UTC ( [id://11149670]=note: print w/replies, xml ) Need Help??


in reply to Re^2: What is the proper data structure for CAP::DBH?
in thread What is the proper data structure for CAP::DBH?

'DBI:mysql:highgatevps_kcmach;vdb2b.pair.com'

The keywords database and host are still missing.


🦛

Replies are listed 'Best First'.
Re^4: What is the proper data structure for CAP::DBH?
by bradcathey (Prior) on Jan 18, 2023 at 20:04 UTC

    I tried it every way, but just hangs.

    $VAR1 = 'DBI:mysql:database=highgatevps_kcmach;host=vdb2b.pair.com';

    On another note, why use sprintf? Elegance? I've always used it for formatting numbers, but not in the way hv did. Nice.

    —Brad
    "The important work of moving the world forward does not wait to be done by perfect men." George Eliot

      It would be better if you showed more complete code. Don't show passwords, but do flesh out what you have for:

      $self->dbh_config($data_source, $username, $auth, \%attr);

      That's from CGI::Application::Plugin::DBH's SYNOPSIS. You should show us your equivalent code.

      Unfortunately, "just hangs" does not help us at all. I'd be surprised if there's no feedback at all about this. The absence of "200 OK" in the log output could be telling; please show us what's there (error.log, access.log, others).

      Just a wild guess, but do check that you're not interpolating strings with special characters; e.g. pass$word.

      The sprintf() function is useful in many cases, not just number formatting. See its documentation for a huge number of examples.

      — Ken

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://11149670]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others admiring the Monastery: (4)
As of 2024-04-13 18:33 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found