Why can't DBD::SQLite insert into a database through my Perl CGI script?

perl apache sqlite dbi
Todd Hunter picture Todd Hunter · Jul 14, 2009 · Viewed 14.5k times · Source

I am running a SQLite database within a Perl CGI script which is being accessed by DBD::SQLite. This is being run as a straight CGI on Apache.

The DBI connection works fine and selects are able to be run. However, when I attempt to do an insert I get a die with the following error:

DBD::SQLite::st execute failed: unable to open database file(1) at dbdimp.c line 402 at index.cgi line 66

I have tried changing the database file permission to 666 to try to fix this however I am still receiving the error.

Any advice?

Answer

Todd Hunter picture Todd Hunter · Jul 14, 2009

It looks like the directory needs write permission, the reason is:

SQLite needs to be able to create a journal file in the same directory as the DB, before any modifications can take place. The journal is used to support transaction rollback.

From: seem to need write permission on db's parent directory

Related questions

How do I configure Apache 2 to run Perl CGI scripts?

I would like to configure Apache 2 running on Kubuntu to execute Perl CGI scripts. I've tried some steps that I came across by googling, but nothing seems to work. What is the right way of achieving this?

Read More
Nginx variables similar to SetEnv in Apache?

I use SetEnv in Apache to set some variables in virtualhosts that I recover in PHP using $_SERVER[the_variable]. Now I am switching to Perl Catalyst and Nginx, but it seems that the "env" directive in Nginx is not …

Read More
Perl Apache : Perl script displayed as plain text

While configuring with apache and perl cgi scripts, don't know why index.cgi/index.pl are displayed as plain text instead of executing them. When I put http://localhost in browser it displays below code, instead of executing it. List …

Read More