Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW

Re: Perl CGI with SQLite Windows and IIS

by huck (Prior)
on Mar 19, 2018 at 19:55 UTC ( #1211265=note: print w/replies, xml ) Need Help??

in reply to Perl CGI with SQLite Windows and IIS

For starters you may wish to add

use CGI::Carp qw(fatalsToBrowser);
to get past the bad headers part.

but i suspect that your problem is that when you said I did set the database directory to have rights of Full Control. one of two things were still not right.

first while the directory may have write privileges it may not have also changed all the files in that directory to have write privileges.

but it is more likely that you set up the privileges for your user, while IIS does not run under your userid, instead it runs under another userid. and that userid needs to have the write privileges as well as your userid

Replies are listed 'Best First'.
Re^2: Perl CGI with SQLite Windows and IIS
by RedJeep (Sexton) on Mar 19, 2018 at 20:11 UTC
    Thanks for the reply. I checked and the database file, sample.db, currently has full control for user IIS_IUSERS. I appreciate the help! Any other ideas on what to check?

      Write a small test program

      #!/usr/bin/perl use strict; use warnings; use CGI qw(:standard); use CGI::Carp 'fatalsToBrowser'; my $dir = "c:/inetpub/wwwroot/data"; print header('text/plain'); if ( open my $fh,'>',$dir.'/write.txt' ){ print "OK : write.txt created in $dir"; close $fh; } else { print "ERROR : No write permission to $dir" }
        Much better. Solved the rights issue. In Anonymous Authentication switched from "Specific User" to "Application pool identity". Thanks all!!!

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1211265]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (3)
As of 2023-02-03 23:51 GMT
Find Nodes?
    Voting Booth?
    I prefer not to run the latest version of Perl because:

    Results (30 votes). Check out past polls.