apr-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jorge Bastos" <mysql.jo...@decimal.pt>
Subject Authn_dbd with MySQL problem
Date Thu, 23 Nov 2006 23:36:26 GMT
People,
I did a few more tests, and the user i enter in the browser when it goes to Auth, i can see
in apache logs:

[Fri Nov 24 00:34:45 2006] [error] [client 192.168.1.1] user oi: authentication failure for
"/": Password Mismatch

But looking at MySQL logs:

061124  0:34:45     218 Connect     root@127.0.0.1 on auth
                    218 Prepare     [1] select password from users where username='?'
                    218 Execute     [1] select password from users where username='?'
                    218 Quit

Should the query in MySQL be ?

                    218 Execute     [1] select password from users where username='oi'


In the virtualhost i have:

        AuthType Basic
        AuthName "My Server"
        AuthBasicProvider dbd
        Require valid-user

        AuthDBDUserPWQuery "select password from users where username='%s'"

I recompiled libapr and libaprutil from svn, the last 0.3.0.
I use the apache 2.2.3 version from the debian packages.
What could it be?

Jorge Bastos


Mime
View raw message