Re: problem with authn_dbd / auth digest and sqlite3

[Dave Mansfield <dmansfield@xxxxxxxxxxxxx>]

startx wrote:
> On Tue, 12 Oct 2010 08:52:31 -0700
> Dave Mansfield <dmansfield@xxxxxxxxxxxxx> wrote:
>
>   
> > startx wrote
> >     
>
>   
> > > from my vhost:
> > >
> > > ###### from my vhost file ####
> > >
> > > DBDriver sqlite3
> > > DBDParams "/home/myself/web/authn.db"
> > >     
> > >       
>
>   
> > STW for examples of SQLite connection strings.
> >     
>
> hi.
>
>   
> > STW
> >     
>
> i did, for quite a while actually.  you answer confuses me, the
> connection string
>
> DBDParams "/home/myself/web/authn.db"
>
> seems to work fine (at least it works perfectly with AuthBasic) and
> there is no connection error logged.
>
>   
Sorry - your problem is your AuthDBDUserRealmQuery - the params are 
'%s', not @USERNAME, etc:

 AuthDBDUserRealmQuery "Select password FROM user WHERE username=%s and 
realm=%s"


-- D Mansfield


---------------------------------------------------------------------
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