well, i got phpwiki up and running, and i also made entries and everything using my admin-account.
but now, as i am trying to set it up for different users, i get trouble all the time. i want to use the sql login, so i edited the config.ini for that, and as far as i can tell, everything is as it should be.
since i found no other available method, i manually created a user and pw in the user table (using plain passwords).
but whenever i try to log-in, i get a memory allocation error in wikiusernew.php, either around line 954 or around line 1012.
perhaps somebody knows what stupid error i made, or if anybody out there with a working mysql auth could post his config.ini, that might help a lot.
oh, and btw, if anybody could tell me, where to create new users, that would be nice, too.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Well, seems like i got everything running back normally again (don't ask me how, i just made the whole config again from scratch).
So now i am able to use the normal login, but without any password configuration.
my goal would be to use the tables phpwiki_user, phpwiki_member and phpwiki_pref as the user / group / preference tables.
i'd like to use the following authentification settings:
ALLOW_ANON_USER = false
ALLOW_ANON_EDIT = false
ALLOW_BOGO_LOGIN = false,
ALLOW_USER_PASSWORDS = true.
but at the moment, i can't get any entries into the corresponding tables.
my configuration for authentification looks like this:
USER_AUTH_ORDER = "Db"
PASSWORD_LENGTH_MINIMUM = 2
USER_AUTH_POLICY = first-only
GROUP_METHOD = WIKIPAGE
DBAUTH_AUTH_CHECK = "SELECT IF(passwd='$password',1,0) FROM phpwiki_user WHERE userid='$userid'"
DBAUTH_AUTH_CRYPT_METHOD = plain
DBAUTH_AUTH_UPDATE = "UPDATE phpwiki_user SET passwd='$password' WHERE userid='$userid'"
DBAUTH_AUTH_CREATE = "INSERT INTO phpwiki_user SET passwd='$password',userid='$userid'"
DBAUTH_PREF_SELECT = "SELECT prefs FROM phpwiki_pref WHERE userid='$userid'"
DBAUTH_PREF_UPDATE = "REPLACE INTO phpwiki_pref SET prefs='$pref_blob',userid='$userid'"
; USERS/GROUPS queries
;
; You can define 1:n or n:m user<=>group relations, as you wish.
;
; Sample configurations:
; only one group per user (1:n):
; DBAUTH_IS_MEMBER = SELECT user FROM user WHERE user='$userid' AND group='$groupname'
; DBAUTH_GROUP_MEMBERS = SELECT user FROM user WHERE group='$groupname'
; DBAUTH_USER_GROUPS = SELECT group FROM user WHERE user='$userid'
; multiple groups per user (n:m):
; DBAUTH_IS_MEMBER = SELECT userid FROM member WHERE userid='$userid' AND groupname='$groupname'
; DBAUTH_GROUP_MEMBERS = SELECT DISTINCT userid FROM member WHERE groupname='$groupname'
; DBAUTH_USER_GROUPS = SELECT groupname FROM member WHERE userid='$userid'
now, my question is: what did i screw up?
Or, if the settings seem to be all right, how the hell do i create users in the sql database with which i can login?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi!
well, i got phpwiki up and running, and i also made entries and everything using my admin-account.
but now, as i am trying to set it up for different users, i get trouble all the time. i want to use the sql login, so i edited the config.ini for that, and as far as i can tell, everything is as it should be.
since i found no other available method, i manually created a user and pw in the user table (using plain passwords).
but whenever i try to log-in, i get a memory allocation error in wikiusernew.php, either around line 954 or around line 1012.
perhaps somebody knows what stupid error i made, or if anybody out there with a working mysql auth could post his config.ini, that might help a lot.
oh, and btw, if anybody could tell me, where to create new users, that would be nice, too.
Well, seems like i got everything running back normally again (don't ask me how, i just made the whole config again from scratch).
So now i am able to use the normal login, but without any password configuration.
my goal would be to use the tables phpwiki_user, phpwiki_member and phpwiki_pref as the user / group / preference tables.
i'd like to use the following authentification settings:
ALLOW_ANON_USER = false
ALLOW_ANON_EDIT = false
ALLOW_BOGO_LOGIN = false,
ALLOW_USER_PASSWORDS = true.
but at the moment, i can't get any entries into the corresponding tables.
my configuration for authentification looks like this:
USER_AUTH_ORDER = "Db"
PASSWORD_LENGTH_MINIMUM = 2
USER_AUTH_POLICY = first-only
GROUP_METHOD = WIKIPAGE
DBAUTH_AUTH_CHECK = "SELECT IF(passwd='$password',1,0) FROM phpwiki_user WHERE userid='$userid'"
DBAUTH_AUTH_CRYPT_METHOD = plain
DBAUTH_AUTH_UPDATE = "UPDATE phpwiki_user SET passwd='$password' WHERE userid='$userid'"
DBAUTH_AUTH_CREATE = "INSERT INTO phpwiki_user SET passwd='$password',userid='$userid'"
DBAUTH_PREF_SELECT = "SELECT prefs FROM phpwiki_pref WHERE userid='$userid'"
DBAUTH_PREF_UPDATE = "REPLACE INTO phpwiki_pref SET prefs='$pref_blob',userid='$userid'"
; USERS/GROUPS queries
;
; You can define 1:n or n:m user<=>group relations, as you wish.
;
; Sample configurations:
; only one group per user (1:n):
; DBAUTH_IS_MEMBER = SELECT user FROM user WHERE user='$userid' AND group='$groupname'
; DBAUTH_GROUP_MEMBERS = SELECT user FROM user WHERE group='$groupname'
; DBAUTH_USER_GROUPS = SELECT group FROM user WHERE user='$userid'
; multiple groups per user (n:m):
; DBAUTH_IS_MEMBER = SELECT userid FROM member WHERE userid='$userid' AND groupname='$groupname'
; DBAUTH_GROUP_MEMBERS = SELECT DISTINCT userid FROM member WHERE groupname='$groupname'
; DBAUTH_USER_GROUPS = SELECT groupname FROM member WHERE userid='$userid'
now, my question is: what did i screw up?
Or, if the settings seem to be all right, how the hell do i create users in the sql database with which i can login?