Bug#506157: libdbd-sqlite3-perl: unsufficient error message while opening database for writing

[Eugene V. Lyubimkin]

Package: libdbd-sqlite3-perl
Version: 1.14-3
Severity: minor

Hello maintainers!

I've spent several days in investigating strange problem and it would be
good to deal somehow with it.

SQLite database consists of one file. But, is is unsufficient to have
write rights to this database file to perform 'INSERT' statements. At
least, this perl package have requirement user should have write rights
to directory containing this file too. Otherwise, my 'INSERT' statement
($sth->execute(...)) will fail with error:

-8<-
DBD::SQLite::st execute failed: unable to open database file(14) at
dbdimp.c line 403 at /var/www/search-site/cgi-bin/register.cgi line 31,
<STDIN> line 1.
->8-

I was very confused to see this while having all necessary right on
database file. Please document this or rather extend the error message.

Happy hacking.

-- System Information:
Debian Release: lenny/sid
  APT prefers unstable
  APT policy: (500, 'unstable'), (1, 'experimental')
Architecture: amd64 (x86_64)

Kernel: Linux 2.6.26-1-amd64 (SMP w/2 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash

Versions of packages libdbd-sqlite3-perl depends on:
ii  libc6                         2.7-15     GNU C Library: Shared libraries
ii  libdbi-perl                   1.607-1    Perl5 database interface by Tim Bu
ii  libsqlite3-0                  3.5.9-6    SQLite 3 shared library
ii  perl                          5.10.0-16  Larry Wall's Practical Extraction 
ii  perl-base [perlapi-5.10.0]    5.10.0-16  minimal Perl system

libdbd-sqlite3-perl recommends no packages.

libdbd-sqlite3-perl suggests no packages.

-- no debconf information