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... ;-)
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
Re: That annoying DB guy again... ;-)
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/