On Tue, 22 May 2001, Jonathan M. Hollin wrote:
> I know you all want me to go away, so I apologise for the noise. Anyway, at
> http://perl.apache.org/guide/databases.html#Why_Relational_SQL_Databases
> there is a reference to an "Apache::DBI" module. I DON'T have this module
> installed - is this the reason why CGI connects work yet mod_perl requests
> don't? I wonder...
No, that module is not required. Apache::DBI will cache DBI connections
for you. It is something you might want to look at after you get your
problem fixed.
As to Ken's suggestion of trying to access MySQL from the command line
using the same user as apache is running as, you could try running the
mysql command line interpreter as a different user:
mysql -u username -p databasename
The -p just means it will prompt you for a password.
I would have a good read of the MySQL docs on access permissions. Or try
running Apache as a different user that you know has access to the
database.
Please don't let this discourage you from using mod_perl. It is probably
one of those simple mistakes that everyone makes. And if you really can't
solve your problem, you could always scrap windows and use Unix instead of
scapping mod_perl and using VB ;)
Cees
