Re: Need help with CGI/ DBI error (permissions?)

From: patrickg (pat_at_patmail.com)
Date: 02/22/05 

Date: Tue, 22 Feb 2005 16:39:03 GMT

"A. Sinan Unur" <1usa@llenroc.ude.invalid> wrote in message
news:Xns960570AA8443Casu1cornelledu@132.236.56.8...
> "patrickg" <pat@patmail.com> wrote in
> news:ybISd.105725$JF2.95728@tornado.tampabay.rr.com:
>
> >
> > "A. Sinan Unur" <1usa@llenroc.ude.invalid> wrote in message
> > news:Xns9605641F057B9asu1cornelledu@127.0.0.1...
>
> ...
>
> >> Well, I don't know about IIS but it sure makes a difference when
> >> running Apache. This should tell you that you no longer have a Perl
> >> issue but a web server configuration issue. I'd advise you to find an
> >> appropriate forum.
>
> ...
>
> > When you say it makes a difference when running Apache, are you
> > referring to Apache on Windows or Apache on *nix??
>
> Windows.
>
> > Reason I'm asking is because even when I run the script from a command
> > line (therefor not using any webserver at all), it still doesn't make
> > a difference as to my results. So maybe the difference is regarding
> > the OS, not the webserver. (?)
>
> No.
>
> There are three ways to invoke a Perl script on the command line in
> Windows:
>
> 1. perl myscript
>
> In this case, the first perl executable in the PATH is used. The
> interpreter you specify in the shebang line is irrelevant. However, the
> options you specified in the shebang line will be respected by the
> interpreter.
>
> 2. start myscript.pl
>
> Assuming the .pl extension is associated with a perl interpreter, that
> interpreter will be invoked to run the script. Again, the interpreter
> specified on the shebang line will be irrelevant.
>
> 3. Put .pl or whatever extension you use for Perl scripts in the PATHEXT
> (Win2k and higher) environment variable. In this case, you can run
> myscript.pl simply by entering
>
> myscript
>
> on the command line. Once again, assuming the file extension is
> associated with a perl interpreter, the interpreter specified on the
> shebang line becomes irrelevant.
>
> Apache, however, uses the shebang line to determine the interpreter to be
> used to run the script in the absence of any directives telling it
> otherwise.
>
> I am trying very, very hard to stay away from a discussion of how *your*
> web server should be configured. You should find an appropriate forum.
>
> Sinan.

Yes, I have read the docs on how to run perl scripts - I prefer the first
method (with the -w flag).

My other Perl CGI scripts that don't use DBI run OK, so I'm guessing that my
IIS server can't be too far off.
And I'm sure that there are plenty of people using CGI and DBI via IIS, so
if they had to do something *special* to get things to work, or know of any
*gotchas*, perhaps they can help. My point is that my webserver isn't
configured in any way special, so whatever works for others (using IIS)
should work on my server. Using Perl's CGI module doesn't require the use of
Apache, does it?

 If it's a webserver configuration issue, then I guess I *am* seeking a
discussion on how to configure IIS to work with Perl's CGI and DBI modules.
If perl.misc isn't the correct forum (assuming misc is for miscellaneous),
then I'm not sure which forum would be more appropriate. You can probably
imagine the response if I went to some IIS forum and mentioned that my Perl
scripts aren't working correctly!

Thanks for your help!
patrick

Relevant Pages

  • Re: A little help please?
    ... > the interpreter under Windows, preferably without the XP command prompt? ... Command Prompt and feed your script to perl, ...
    (perl.beginners)
  • Re: Error calling Win32::Printer from a perl script hosted in IIS on Win2k3
    ... My test perl script that uses Win32::Printer to print ... Are the IIS and this remote machine members of an Active Directory domain? ... IIRC you can configure IIS that it should run the CGI scripts as another user (especially a sufficiently restricted domain user able to access the printer). ...
    (comp.lang.perl.modules)
  • Perl OLE Module Security
    ... I've written a PERL CGI script that resets the password ... I understand this isn't a PERL group, ... these obscure security problems with IIS 6.0? ...
    (microsoft.public.inetserver.iis.security)
  • Re: How long is too long for cgi script?
    ... > What is the ballpark limit for the size of a script before the perl ... > interpreter takes more than a few seconds to load it? ... > script that is not CPU or memory intensive but is around a few thousand ...
    (comp.lang.perl.misc)
  • FAQ 1.13 Is it a Perl program or a Perl script?
    ... Is it a Perl program or a Perl script? ... He says that "a script is what ... source is destined for a pure interpreter, a parse-tree interpreter, a ... The perlfaq-workers, a group of volunteers, maintain the perlfaq. ...
    (comp.lang.perl.misc)