Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Re: Trouble writing to SQLite from CGI on Windows

by RedJeep (Sexton)
on May 22, 2019 at 05:32 UTC ( #11100356=note: print w/replies, xml ) Need Help??


in reply to Trouble writing to SQLite from CGI on Windows

Ok my Perl friends. I super appreciate your help. The problem is partially solved but more bizarre. I found that the system is duplicating the database file in a directory called... C:\BOXRoot\HarddiskVolume2\inetpub\wwwroot\data

Now, I have no idea what "BOXRoot" is. I did some searching on the Internet. No luck. I do not have dropbox.

The behavior is super crazy but 100% consistent.

If I create the database in the proper directory c:\inetpub\wwwroot\data and run the CGI script it will recreate the database in the c:\BOXRoot\..... directory and INSERT the record correctly. If I do not create the database at all and just plug in some whatever random database name then an empty (0 byte) database will be created in "BOXRoot". That ("0" byte) database does not allow writes.

I have done virus scans and found nothing. This is my dev machine. I know where the directory is now. Although I have no idea where it came from I am going to use as is. My thinking is that I must have mucked up some config setting somewhere.

I thought it only fair to share what I found in the event that someone else comes across the same problem. And, if in teh CGI script I open a filehandle to create a txt file and write to it... well you can guess where it ends up also... BOXRoot. So this is not a SQLite issue.

Thanks again everyone!!!
  • Comment on Re: Trouble writing to SQLite from CGI on Windows

Replies are listed 'Best First'.
Re^2: Trouble writing to SQLite from CGI on Windows
by marto (Cardinal) on May 22, 2019 at 06:11 UTC

    Do you run Comodo anti virus or security software? It looks like the sandboxing feature.

      Yes, I run Comodo. You, my friend, are very smart. That must be what is going on.

      Thanks!

      ---RedJeep

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (4)
As of 2022-12-09 03:17 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?