problem with authn_dbd / auth digest and sqlite3

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



hello.

i am trying to set up AuthDigest against a sqlite3 database
using mod_authn_dbd ( system is Debian squeeze) and it seems
i am missing something.

i created a user database for a user "myself" with password "foobar" in
realm "admin". the password prompt shows up  but any login attempt
fails ( get prompted again) and my error log reports :

     "Digest: user `myself' in realm `admin' not found.

why is that? anybody can point me into a direction?


my sqlite3 database looks like this  

          password              | username |  realm
----------------------------------------------------
4c324a0a70009f01e9804e1326c51ae9|myself|admin


and this looks alright to me, no?


i created the password with   "echo -n 'myself:admin:foobar' | md5sum"
( i double checked with htdigest, but the output was the same)


from my vhost:

###### from my vhost file ####

DBDriver sqlite3
DBDParams "/home/myself/web/authn.db"
DBDMin  1
DBDKeep 2
DBDMax  10
DBDExptime 60

ErrorLog /var/log/apache2/error.log

<Directory /home/myself/web/public/admin>
    AuthType Digest
    AuthName admin
    AuthDigestProvider dbd
    Require valid-user
    AuthDBDUserRealmQuery "SELECT password FROM user WHERE  username =@USERNAME and realm = @REALM; " 
</Directory>

################

startx


---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@xxxxxxxxxxxxxxxx
   "   from the digest: users-digest-unsubscribe@xxxxxxxxxxxxxxxx
For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx



[Index of Archives]     [Open SSH Users]     [Linux ACPI]     [Linux Kernel]     [Linux Laptop]     [Kernel Newbies]     [Security]     [Netfilter]     [Bugtraq]     [Squid]     [Yosemite News]     [MIPS Linux]     [ARM Linux]     [Linux Security]     [Linux RAID]     [Samba]     [Video 4 Linux]     [Device Mapper]

  Powered by Linux