Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Re: Perl Script connecting to Mysql works from command prompt, not from Apache

by AgentM (Curate)
on Apr 15, 2001 at 04:30 UTC ( #72627=note: print w/ replies, xml ) Need Help??


in reply to Perl Script connecting to Mysql works from command prompt, not from Apache

We really don't have enough info to go on. For future reference, it's best to include some relevant lines of code. A couple of tips:

  • use CGI::Carp qw/fatalsToBrowser/; More likely than not, you'll be able to read off the error if there is one.
  • MySQL is interested in the login and password passed to it and little else. Thus, using user 'apache' to login shouldn't be a problem unless that user is restricted access to some libs (unlikely).
  • Consider that you might be banging your head against the wall but dealing with the wrong issues. Could the error have something else to do with the script.
  • Check the MySQL as well as the Apache error_logs for messages that might help.
Perhaps next time you could be a little more descriptive than "evaluates to true" but, if you try out some of my tips above, it's unlikely that you won't find out what's going on.
AgentM Systems nor Nasca Enterprises nor Bone::Easy nor Macperl is responsible for the comments made by AgentM. Remember, you can build any logical system with NOR.


Comment on Re: Perl Script connecting to Mysql works from command prompt, not from Apache
Download Code

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (9)
As of 2014-09-22 21:41 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (203 votes), past polls