Unable to add users or groups to Project Permissions #5200
Replies: 4 comments
-
Any help would be greatly appreciated. |
Beta Was this translation helpful? Give feedback.
-
I might also add that I have tried Sqlite and MySQL, got the same symptom. Kanboard is setup as a vhost as well. |
Beta Was this translation helpful? Give feedback.
-
It seems to be something in my config.php file - I reverted to the default one and the issue went away. I am using LDAP with AD (and users are able to log in using their AD creds) but I'll post my config.php here to see if anything stands out to anyone.
|
Beta Was this translation helpful? Give feedback.
-
I ended up starting with a default config.php and tested it after each definition change and I've now got LDAP auth with group sync working. Here is an example config.php if anyone has the same issue:
|
Beta Was this translation helpful? Give feedback.
-
Actual behaviour
Users and groups do not 'resolve' in the Project Permissions page, preventing me from adding any.
Expected behaviour
I would expect it to behave like the animated gif posted in this post on the Kanboard forums (creecros's post): https://kanboard.discourse.group/t/cant-add-any-users-to-project/502
Steps to reproduce
I add a test user, called 'testuser' under 'Users management', and a test group called 'testgroup' under 'Groups management'. I then create a non-private Project and configure that project and then go permissions and start typing either that test user in the user field or the group in the group field. Neither appears directly below (like illustrated in the above forum post) for me to click and therefore the Add User or Add Group button doesn't light up for it to be clicked.
Screenshots
Can provide these if necessary.
Logs
This is the immediate output in the debug log after trying to add a user
[2021-04-14 07:37:44] [debug] ###############################################
[2021-04-14 07:38:33] [debug] Kanboard\Core\Controller\Runner::executeMiddleware
[2021-04-14 07:38:33] [debug] Subscriber executed: Kanboard\Subscriber\BootstrapSubscriber::execute
[2021-04-14 07:38:33] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\AuthenticationMiddleware
[2021-04-14 07:38:33] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\PostAuthenticationMiddleware
[2021-04-14 07:38:33] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\ApplicationAuthorizationMiddleware
[2021-04-14 07:38:33] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\ProjectAuthorizationMiddleware
[2021-04-14 07:38:33] [debug] Kanboard\Core\Controller\Runner::executeController => \Kanboard\Controller\UserAjaxController::autocomplete
[2021-04-14 07:38:33] [debug] SQL: SELECT
data
FROMsessions
WHEREid
= ? LIMIT 1[2021-04-14 07:38:33] [debug] SQL: query_duration=0.00045919418334961
[2021-04-14 07:38:33] [debug] SQL: total_execution_time=0.00045919418334961
[2021-04-14 07:38:33] [debug] SQL: SELECT
option
,value
FROMsettings
[2021-04-14 07:38:33] [debug] SQL: query_duration=0.00010418891906738
[2021-04-14 07:38:33] [debug] SQL: total_execution_time=0.00056338310241699
[2021-04-14 07:38:33] [debug] SQL: SELECT projects.id, projects.name FROM
projects
LEFT JOINproject_has_users
ONproject_has_users
.project_id
=projects
.id
WHERE project_has_users.user_id = ? AND projects.is_active IN (?)[2021-04-14 07:38:33] [debug] SQL: query_duration=6.2942504882812E-5
[2021-04-14 07:38:33] [debug] SQL: total_execution_time=0.0006263256072998
[2021-04-14 07:38:33] [debug] SQL: SELECT projects.id, projects.name FROM
projects
LEFT JOINproject_has_groups
ONproject_has_groups
.project_id
=projects
.id
LEFT JOINgroup_has_users
ONgroup_has_users
.group_id
=project_has_groups
.group_id
WHERE group_has_users.user_id = ? AND projects.is_active IN (?)[2021-04-14 07:38:33] [debug] SQL: query_duration=4.8160552978516E-5
[2021-04-14 07:38:33] [debug] SQL: total_execution_time=0.00067448616027832
[2021-04-14 07:38:33] [debug] SQL: SELECT * FROM
actions
WHEREproject_id
IN (?)[2021-04-14 07:38:33] [debug] SQL: query_duration=4.1961669921875E-5
[2021-04-14 07:38:33] [debug] SQL: total_execution_time=0.0007164478302002
[2021-04-14 07:38:33] [debug] SQL: SELECT * FROM
action_has_params
[2021-04-14 07:38:33] [debug] SQL: query_duration=3.9100646972656E-5
[2021-04-14 07:38:33] [debug] SQL: total_execution_time=0.00075554847717285
[2021-04-14 07:38:33] [debug] SQL: SELECT 1 FROM
users
WHEREid
= ? ANDis_active
= ? ANDrole
= ?[2021-04-14 07:38:33] [debug] SQL: query_duration=6.6995620727539E-5
[2021-04-14 07:38:33] [debug] SQL: total_execution_time=0.00082254409790039
[2021-04-14 07:38:33] [debug] SQL: SELECT users.id, users.username, users.name FROM
users
WHERE (username
LIKE ? ORname
LIKE ?) AND users.is_active = ? ORDER BY users.name ASC, users.username ASC[2021-04-14 07:38:33] [debug] SQL: query_duration=6.9141387939453E-5
[2021-04-14 07:38:33] [debug] SQL: total_execution_time=0.00089168548583984
[2021-04-14 07:38:33] [debug] SQL: SELECT 1 FROM
sessions
WHEREid
= ?[2021-04-14 07:38:33] [debug] SQL: query_duration=0.00016999244689941
[2021-04-14 07:38:33] [debug] SQL: total_execution_time=0.0010616779327393
[2021-04-14 07:38:33] [debug] SQL: UPDATE
sessions
SETexpire_at
=?,data
=? WHEREid
= ?[2021-04-14 07:38:33] [debug] SQL: query_duration=0.00026893615722656
[2021-04-14 07:38:33] [debug] SQL: total_execution_time=0.0013306140899658
[2021-04-14 07:38:33] [debug] APP: nb_queries=10
[2021-04-14 07:38:33] [debug] APP: rendering_time=0.016706943511963
[2021-04-14 07:38:33] [debug] APP: memory_usage=1.46M
[2021-04-14 07:38:33] [debug] APP: uri=/?controller=UserAjaxController&action=autocomplete&term=test
Configuration
Application version: 1.2.18
PHP version: 7.4.3
PHP SAPI: apache2handler
HTTP Client: cURL
OS version: Linux 5.4.0-70-generic
Database driver: mysql
Database version: 10.3.25-MariaDB-0ubuntu0.20.04.1
Browser: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.141 Safari/537.36 Edg/87.0.664.75
Beta Was this translation helpful? Give feedback.
All reactions