htaccess preventing sqlite database being downloaded

Question

I have a VPS, running apache2 on Debian 6.

Created a file called .htaccess on the web root, which included:

<Files ~ "\.db$">
    Order allow,deny
    Deny from all
</Files>

<FilesMatch "\.db$">
Deny from all
</FilesMatch>

Can still manually download the database.db file that exists in the same directory as the .htaccess file. Restarted Apache2, same.

What gives?

Any reason why your sqlite file has to be placed inside your web root? — Lèse majesté, Commented Apr 1, 2012 at 21:00
at this point no, but this is making me mad that I can't get htaccess to work how it should — ParoX, Commented Apr 1, 2012 at 23:00
What's the AllowOverride setting for that directory? Also, for future reference, you don't need to restart Apache for .htaccess changes to take effect. — Lèse majesté, Commented Apr 1, 2012 at 23:14
SQLLite database is for Android Applications. It has no relation with httaccess. httaccess file resides in the XAMPP/WAMP/LAMP folder you installed. You could be asking to download the SQL file. It can be done by clicking Export button in you phpMyAdmin page. If I am wrong then please state how you are facing problem. — NewUser, Commented Aug 20, 2012 at 3:08

Talvi Watia · Accepted Answer · 2012-06-21 00:50:45Z

1

Send it a 404!

RewriteEngine On
RewriteCond %{REQUEST_URI} (.*).db [NC]
RewriteRule ^(.*)$ 404.html [R=404,L]

answered Jun 21, 2012 at 0:50

Talvi Watia

8341 gold badge7 silver badges15 bronze badges

Add a comment |

1 Answer 1