Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

Re: DBD::SQLite - Can't Connect to file...

by bliako (Abbot)
on Dec 29, 2018 at 09:30 UTC ( [id://1227805]=note: print w/replies, xml ) Need Help??


in reply to DBD::SQLite - Can't Connect to file - Solved

File permissions, *Directory* permissions and who owns them (must be the owner of the process running the inserts, e.g. chown www-data /var/www/data) are the usual suspects.

Replies are listed 'Best First'.
Re^2: DBD::SQLite - Can't Connect to file - Solved
by wjw (Priest) on Dec 29, 2018 at 16:29 UTC

    Thanks for those reminders. I have in fact checked to ensure that the permissions are correct. The process running inserts is owned by www-data.

    I have tested an insert both by hand and via phpLiteAdmin to ensure the database can take inserts as well.

    Again, thanks for the reminders.

    Update:I was wrong. Permissions/ownership on the files under /var/www were correct, however permissions on the directories themselves were incorrect. Such a basic mistake to make! Ah well, doing things under the light of midnight oil is my excuse... .

    Thanks again for the help!

    ...the majority is always wrong, and always the last to know about it...

    A solution is nothing more than a clearly stated problem...

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others romping around the Monastery: (2)
As of 2025-12-09 08:16 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    What's your view on AI coding assistants?





    Results (88 votes). Check out past polls.

    Notices?
    hippoepoptai's answer Re: how do I set a cookie and redirect was blessed by hippo!
    erzuuliAnonymous Monks are no longer allowed to use Super Search, due to an excessive use of this resource by robots.