in reply to DBI, DBD::MySQL, Apache & Cygwin

You may wish to look into where $user and $pass come from in your script, since it appears that the values being used do not have the correct permissions to access the database.

Give it a look-see, and determine if your script is running as the correct user (you may have to look at both the script and the httpd.conf file), and/or whether or not your script is pulling the correct values to be used in the connect string. Also, ensure that the user and password values being sent are permitted in the database.

Hope that helped,
-v
"Perl. There is no substitute."

Replies are listed 'Best First'.
Re^2: DBI, DBD::MySQL, Apache & Cygwin
by rvosa (Curate) on Sep 02, 2004 at 08:30 UTC
    Hi Velaki, thanks for that swift reply!

    $user and $pass work fine when I run the script from the command line and there is no way they could be changed during the CGI execution (they are, erm, hard coded...).

    I went through mysql.user and the $user and $pass combination definitely are allowed on this database, from localhost and 127.0.0.1.

    I hope you don't mind me asking if you could give me any pointers what to change in httpd.conf? Do I have to allow more in the ScriptAlias <Directory "/blah/blah"></Directory> directive? Thanks!
[reply]
[d/l]

In Section Seekers of Perl Wisdom