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.
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.
In Section
Seekers of Perl Wisdom