You are viewing a plain text version of this content. The canonical link for it is here.
Posted to modperl@perl.apache.org by "Jonathan M. Hollin" <ne...@digital-word.com> on 2001/05/22 05:17:01 UTC

That annoying DB guy again... ;-)

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...

Kindest regards,
Jonathan M. Hollin
Digital-Word.com


LATEST NEWS:  Digital-Word.com releases e-gateway v3.0.  See:
http://e-gateway.1-1IT.Net/ for further details...


IMPORTANT:  This e-mail and the information that it contains may be
confidential, legally privileged and protected by law.  Access by the
intended recipient only is authorised.  Any liability (in negligence or
otherwise) arising from any third party acting, or refraining from acting,
on any information contained in this e-mail is hereby excluded.  If you are
not the intended recipient, please notify the sender immediately and do not
disclose the contents to any other person, use it for any purpose, or store
or copy the information in any medium.  Copyright in this e-mail and
attachments created by us belongs to The Digital Word Company Limited: the
author also asserts the right to be identified as such and object to any
misuse.

The Digital Word Company Limited.  Registered in the United Kingdom, number:
3416629.  Registered Office:  Batley Business & Technology Centre,
Technology Drive, Batley, WF17 6ER, England.

Internet:  http://v3.digital-word.com/


Re: That annoying DB guy again... ;-)

Posted by Mike Cameron <mc...@mirusweb.com>.

"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...

That should not be a problem. Apache::DBI just allows for persistent DB
connections but DBI alone should work just fine

>
>
> Kindest regards,
> Jonathan M. Hollin
> Digital-Word.com
>
> LATEST NEWS:  Digital-Word.com releases e-gateway v3.0.  See:
> http://e-gateway.1-1IT.Net/ for further details...
>
> IMPORTANT:  This e-mail and the information that it contains may be
> confidential, legally privileged and protected by law.  Access by the
> intended recipient only is authorised.  Any liability (in negligence or
> otherwise) arising from any third party acting, or refraining from acting,
> on any information contained in this e-mail is hereby excluded.  If you are
> not the intended recipient, please notify the sender immediately and do not
> disclose the contents to any other person, use it for any purpose, or store
> or copy the information in any medium.  Copyright in this e-mail and
> attachments created by us belongs to The Digital Word Company Limited: the
> author also asserts the right to be identified as such and object to any
> misuse.
>
> The Digital Word Company Limited.  Registered in the United Kingdom, number:
> 3416629.  Registered Office:  Batley Business & Technology Centre,
> Technology Drive, Batley, WF17 6ER, England.
>
> Internet:  http://v3.digital-word.com/


Re: That annoying DB guy again... ;-)

Posted by Cees Hek <ce...@sitesuite.net>.
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