Re: Re: Error trying to use 'mod_auth_form' and 'mod_dbd' with sqlite3

[Luca Toscano <toscano.luca@xxxxxxxxx>]

Hi Tom,

2017-04-26 3:23 GMT+02:00 Tom Browder <tom.browder@xxxxxxxxx>:

On Tue, Apr 25, 2017 at 14:47 Tom Browder <tom.browder@xxxxxxxxx> wrote:
>
> On Tue, Apr 25, 2017 at 12:03 PM, Tom Browder <tom.browder@xxxxxxxxx> wrote:
> > Host: httpd version 2.4.25, Debian 8, 64-bit
> >
> > I am so close but getting the following error:
> ...
>
> I think I just discovered I what the problem is: I'm using harp.js to
> build my site and the <form...> is compiling incorrectly.


Well, that wasn't the problem.

The error is still:

[dbd:error] [pid 18921:tid 140512673658624] (20014)Internal error:
  AH00632: failed to prepare SQL statements: near "authn_query": syntax error

 

 > DBDPrepareSQL "SELECT password FROM authn WHERE user = '%s';" authn_query

Not a big expert with dbd but looking in https://httpd.apache.org/docs/current/mod/mod_session_dbd.html#dbdconfig it seems that you have a wrong prepare sql statement. Can you try something like:

DBDPrepareSQL "SELECT password FROM authn WHERE user = %s" authn_query

?

Luca