I have had problems integrating a DB login with PhpWiki
for several versions now and keep having the same
problems. I waited for a new release hoping it would
fix my problems but it didn't.
I can always sign in using the PhpWiki admin account
specified in the config.ini, however trying to login as
anything else brings up the following error:
wikidb_backend_peardb_mysql: fatal database error
* DB Error: unknown error * ( [nativecode=1065 ** Query was empty]) *
lib/WikiUser/PearDb.php:172: Warning: sprintf(): Too
Currently I am configured as follows:
ALLOW_ANON_EDIT = false
ALLOW_BOGO_LOGIN = false
ALLOW_USER_PASSWORDS = true
USER_AUTH_ORDER = "Db"
USER_AUTH_POLICY = "strict"
// My user database is stored in
DBAUTH_AUTH_USER_EXISTS = "SELECT U_LoginName FROM
w3t_Users WHERE U_LoginName='$userid'"
DBAUTH_AUTH_CHECK = "SELECT
U_Password=PASSWORD('$password'),1,0) AS ok FROM
DBAUTH_AUTH_CRYPT_METHOD = "crypt"
(If I change ALLOW_USER_PASSWORDS to false, the error
goes away, but non-admin logins do not work)
Any help on this matter would be greatly appreciated.
Log in to post a comment.