Nextcloud version: 22.2.0
Operating system and version: Ubuntu 20.04
Apache 2.4.41 Ubuntu
PHP version: PHP 7.4.3
Database:PostgreSQL 12.9
Issue-
Opening Users->Everyone errors out and is unable to load user list.
Is this the first time you’ve seen this error? (Y/N): Y
Steps to replicate it:
- Active Directory Domain Controller was updated from Windows Server 2003 to Windows Server 2019
- Via OCC command via cli I disabled the active LDAP configuration file “s01”
- Logged in via local nextcloud administrator account, reconfigured LDAP configuration to point to new IPv4 of new Domain Controller.
- Via cli I enabled the LDAP configuration again.
- Tested, was able to successfully login using Active Directory username and password, LDAP gives me creen check box, able to talk to new AD server.
- When logged in as any administrator, local or LDAP when I go to Users → Everyone the page errors out and is unable to load the users. If I go to Disabled users same problem. However the “Admins” section opens and all my groups I created allow me to open and view my users and does not error out on me.
The output of your Nextcloud log in Admin > Logging:
[no app in context] Error: An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 7 ERROR: value too long for type character varying(64)
GET /ocs/v2.php/cloud/users/details?offset=0&limit=25&search=
from 82.49.208.175 by ACX at 2022-02-07T12:04:47+00:00
[user_ldap] Warning: provided name template for username does not contain any allowed characters
GET /ocs/v2.php/cloud/users/details?offset=0&limit=25&search=
from 82.49.208.175 by ACX at 2022-02-07T12:04:47+00:00
[PHP] Error: Trying to access array offset on value of type bool at /var/www/nextcloud/apps/user_ldap/lib/Access.php#563
GET /ocs/v2.php/cloud/users/details?offset=0&limit=25&search=
from 82.49.208.175 by ACX at 2022-02-07T12:04:47+00:00
The output of your config.php file in /path/to/nextcloud
(make sure you remove any identifiable information!):
<?php
$CONFIG = array (
'passwordsalt' => 'XXXXXXXXX',
'secret' => 'XXXXXXXXX',
'trusted_domains' =>
array (
0 => 'localhost',
1 => 'XXXXXXXXX',
2 => 'XXXXXXXXX',
),
'defaultapp' => 'apporder',
'default_phone_region' => 'us',
'datadirectory' => '/mnt/ncdata',
'dbtype' => 'pgsql',
'version' => '22.2.0.2',
'overwrite.cli.url' => 'http://localhost/',
'dbname' => XXXXXX_db',
'dbhost' => 'localhost',
'dbport' => '',
'dbtableprefix' => 'oc_',
'dbuser' => 'ncadmin',
'dbpassword' => 'XXXXXXXXXXXXX',
'installed' => true,
'instanceid' => 'oc2ks27wdjhp',
'upgrade.disable-web' => true,
'log_type' => 'file',
'logfile' => '/var/log/nextcloud/nextcloud.log',
'loglevel' => '2',
'log.condition' =>
array (
'apps' =>
array (
0 => 'admin_audit',
),
),
'mail_smtpmode' => 'smtp',
'remember_login_cookie_lifetime' => '1800',
'log_rotate_size' => '10485760',
'trashbin_retention_obligation' => 'auto, 60',
'versions_retention_obligation' => 'auto, 180',
'activity_expire_days' => '120',
'simpleSignUpLink.shown' => false,
'memcache.local' => '\\OC\\Memcache\\Redis',
'filelocking.enabled' => true,
'memcache.distributed' => '\\OC\\Memcache\\Redis',
'memcache.locking' => '\\OC\\Memcache\\Redis',
'redis' =>
array (
'host' => '/var/run/redis/redis-server.sock',
'port' => 0,
'timeout' => 0.5,
'dbindex' => 0,
'password' => 'XXXXXXXXXXXXX',
),
'ldapProviderFactory' => 'OCA\\User_LDAP\\LDAPProviderFactory',
'mail_smtpsecure' => 'tls',
'mail_sendmailmode' => 'smtp',
'mail_from_address' => 'it',
'mail_domain' => 'XXXXXXXX',
'mail_smtpauth' => 1,
'mail_smtpauthtype' => 'LOGIN',
'mail_smtphost' => 'XXXXXXXXXXX',
'mail_smtpport' => '465',
'mail_smtpname' => 'XXXXXXXXXX',
'mail_smtppassword' => 'XXXXXXXXX',
'logtimezone' => 'Etc/UTC',
'htaccess.RewriteBase' => '/',
'maintenance' => false,
'templatedirectory' => NULL,
'twofactor_enforced' => 'false',
'twofactor_enforced_groups' =>
array (
),
'twofactor_enforced_excluded_groups' =>
array (
),
);
The output of your Apache/nginx/system log in /var/log/____
:
Nothing in my daily error log