DBAUTH_AUTH_CHECK = "SELECT IF(passwd=PASSWORD('$password'),1,0) FROM phpwiki_user WHERE userid='$userid'"
DBAUTH_AUTH_CRYPT_METHOD = plain
DBAUTH_AUTH_UPDATE = "UPDATE phpwiki_user SET passwd=PASSWORD('$password') WHERE userid='$userid'"
DBAUTH_PREF_SELECT = SELECT prefs FROM phpwiki_user WHERE userid='$userid'
DBAUTH_PREF_UPDATE = UPDATE phpwiki_user SET prefs='$pref_blob' WHERE userid='$userid'
DBAUTH_IS_MEMBER = SELECT userid FROM phpwiki_member WHERE userid='$userid' AND groupname='$groupname'
DBAUTH_GROUP_MEMBERS = SELECT DISTINCT userid FROM phpwiki_member WHERE groupname='$groupname'
DBAUTH_USER_GROUPS = SELECT groupname FROM phpwiki_member WHERE userid='$userid'
Now i just cannot login under the ADMIN_USER i set and it's password. What am i doing wrong?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I get a warning "lib/WikiGroup.php:562: Warning[512]: No or not enough GROUP_DB SQL statements defined"
DEBUG: ALLOW_ANON_EDIT = false, ALLOW_BOGO_LOGIN = false, ALLOW_USER_PASSWORDS = true USER_AUTH_ORDER: PersonalPage => Db => Forbidden, USER_AUTH_POLICY: old, PASSWORD_LENGTH_MINIMUM: 4
Extra Info: phpWiki 1.3.10 with a MySQL database and php 4.3. Tried it with SQL and ADODB.
I entered the ADMIN_USER, went to passencrypt.php and encrypted a password, and set ADMIN_PASSWD to that encrypted string.
ENCRYPTED_PASSWD = true
CACHE_CONTROL = NONE
DATABASE_TYPE = SQL or ADODB (give the same)
ALLOW_ANON_USER = false, ALLOW_ANON_EDIT = false
ALLOW_BOGO_LOGIN = false
ALLOW_USER_PASSWORDS = true
USER_AUTH_ORDER = "PersonalPage : Db"
USER_AUTH_POLICY = old, GROUP_METHOD = DB
DBAUTH_AUTH_CHECK = "SELECT IF(passwd=PASSWORD('$password'),1,0) FROM phpwiki_user WHERE userid='$userid'"
DBAUTH_AUTH_CRYPT_METHOD = plain
DBAUTH_AUTH_UPDATE = "UPDATE phpwiki_user SET passwd=PASSWORD('$password') WHERE userid='$userid'"
DBAUTH_PREF_SELECT = SELECT prefs FROM phpwiki_user WHERE userid='$userid'
DBAUTH_PREF_UPDATE = UPDATE phpwiki_user SET prefs='$pref_blob' WHERE userid='$userid'
DBAUTH_IS_MEMBER = SELECT userid FROM phpwiki_member WHERE userid='$userid' AND groupname='$groupname'
DBAUTH_GROUP_MEMBERS = SELECT DISTINCT userid FROM phpwiki_member WHERE groupname='$groupname'
DBAUTH_USER_GROUPS = SELECT groupname FROM phpwiki_member WHERE userid='$userid'
Now i just cannot login under the ADMIN_USER i set and it's password. What am i doing wrong?