I dont see any users as administrator

[GladiusCZ]

Thanks for reporting issues back to Teampass!
This is ONLY for ISSUE / DEFECT / BUG.

IN CASE OF DEFECT, THIS TEMPLATE HAS TO BE FOLLOWED.
IF NOT, I WILL DELETE THE TICKET WITHOUT ANSWERING IT!

For QUESTIONS or REMARKS, please use https://github.com/nilsteampassnet/TeamPass/discussions

To make it possible for us to help you please fill out below information ### carefully.

Thanks for reporting issues back to Teampass!
This is ONLY for ISSUE / DEFECT / BUG.

IN CASE OF DEFECT, THIS TEMPLATE HAS TO BE FOLLOWED.

Steps to reproduce

1. Login in as administrator
2. Open Users

Expected behaviour

See users

Actual behaviour

I get an endlessly rotating circle and an error message:

DataTables warning: table id=table-users - Ajax error. For more information about this error, please see http://datatables.net/tn/7

Server configuration

Operating system:
Ubuntu 22.04.4
Web server:
nginx/1.18.0 (Ubuntu)
Database:
mariadb-10.1
PHP version:
PHP 8.2.17
Teampass version:
3.1.1
Teampass configuration file:

global $SETTINGS;
$SETTINGS = array (
'max_latest_items' => '10',
'enable_favourites' => '1',
'show_last_items' => '1',
'enable_pf_feature' => '1',
'log_connections' => '0',
'log_accessed' => '1',
'time_format' => 'H:i:s',
'date_format' => 'd/m/Y',
'duplicate_folder' => '1',
'item_duplicate_in_same_folder' => '0',
'duplicate_item' => '1',
'number_of_used_pw' => '3',
'manager_edit' => '0',
'cpassman_dir' => '/var/www/teampass.arbes.com',
'cpassman_url' => 'https://pass.arbes.com',
'favicon' => 'https://pass.arbes.com/favicon.ico',
'path_to_upload_folder' => '/var/www/teampass.arbes.com/upload',
'url_to_upload_folder' => 'https://pass.arbes.com/upload',
'path_to_files_folder' => '/var/www/teampass.arbes.com/files',
'url_to_files_folder' => 'https://pass.arbes.com/files',
'activate_expiration' => '0',
'pw_life_duration' => '0',
'maintenance_mode' => '0',
'enable_sts' => '0',
'encryptClientServer' => '1',
'cpassman_version' => '2.1.27',
'ldap_mode' => '1',
'ldap_type' => 'ActiveDirectory',
'ldap_suffix' => '@dc=merlin,dc=cz',
'ldap_domain_dn' => '0',
'ldap_domain_controler' => 'domain',
'ldap_user_attribute' => 'sAMAccountName',
'ldap_ssl' => '0',
'ldap_tls' => '0',
'ldap_search_base' => 'OU=Uzivatele,OU=Merlin,DC=merlin,DC=cz',
'ldap_port' => '389',
'richtext' => '0',
'allow_print' => '0',
'roles_allowed_to_print' => '0',
'show_description' => '1',
'anyone_can_modify' => '0',
'anyone_can_modify_bydefault' => '0',
'nb_bad_authentication' => '0',
'utf8_enabled' => '1',
'restricted_to' => '0',
'restricted_to_roles' => '0',
'enable_send_email_on_user_login' => '0',
'enable_user_can_create_folders' => '0',
'insert_manual_entry_item_history' => '0',
'enable_kb' => '0',
'enable_email_notification_on_item_shown' => '0',
'enable_email_notification_on_user_pw_change' => '0',
'custom_logo' => '',
'custom_login_text' => '',
'default_language' => 'czech',
'send_stats' => '0',
'send_statistics_items' => 'stat_country;stat_users;stat_items;stat_items_shared;stat_folders;stat_folders_shared;stat_admins;stat_managers;stat_ro;stat_mysqlversion;stat_phpversion;stat_teampassversion;stat_languages;stat_kb;stat_suggestion;stat_customfields;stat_api;stat_2fa;stat_agses;stat_duo;stat_ldap;stat_syslog;stat_stricthttps;stat_fav;stat_pf;',
'send_stats_time' => '1518452365',
'get_tp_info' => '1',
'send_mail_on_user_login' => '0',
'nb_items_by_query' => 'auto',
'enable_delete_after_consultation' => '0',
'enable_personal_saltkey_cookie' => '1',
'personal_saltkey_cookie_duration' => '120',
'email_smtp_server' => 'mail',
'email_smtp_auth' => '0',
'email_auth_username' => '',
'email_auth_pwd' => '',
'email_port' => '25',
'email_security' => '',
'email_server_url' => '',
'email_from' => 'mail',
'email_from_name' => 'teampass',
'pwd_maximum_length' => '40',
'google_authentication' => '0',
'delay_item_edition' => '5',
'allow_import' => '1',
'proxy_ip' => '',
'proxy_port' => '',
'upload_maxfilesize' => '10mb',
'upload_docext' => 'doc,docx,dotx,xls,xlsx,xltx,rtf,csv,txt,pdf,ppt,pptx,pot,dotx,xltx',
'upload_imagesext' => 'jpg,jpeg,gif,png',
'upload_pkgext' => '7z,rar,tar,zip',
'upload_otherext' => 'sql,xml,rdp',
'upload_imageresize_options' => '1',
'upload_imageresize_width' => '800',
'upload_imageresize_height' => '600',
'upload_imageresize_quality' => '90',
'use_md5_password_as_salt' => '0',
'ga_website_name' => 'TeamPass for ChangeMe',
'api' => '0',
'subfolder_rights_as_parent' => '1',
'show_only_accessible_folders' => '1',
'enable_suggestion' => '0',
'otv_expiration_period' => '7',
'default_session_expiration_time' => '60',
'duo' => '0',
'enable_server_password_change' => '0',
'ldap_object_class' => 'Person',
'bck_script_path' => '/var/www/teampass.arbes.com/backups',
'bck_script_filename' => 'bck_teampass',
'syslog_enable' => '0',
'syslog_host' => 'localhost',
'syslog_port' => '514',
'manager_move_item' => '0',
'create_item_without_password' => '1',
'otv_is_enabled' => '0',
'agses_authentication_enabled' => '0',
'item_extra_fields' => '0',
'saltkey_ante_2127' => 'none',
'migration_to_2127' => 'done',
'files_with_defuse' => 'done',
'timezone' => 'Europe/Prague',
'enable_attachment_encryption' => '1',
'personal_saltkey_security_level' => '50',
'ldap_new_user_is_administrated_by' => '0',
'disable_show_forgot_pwd_link' => '1',
'offline_key_level' => '0',
'enable_http_request_login' => '0',
'ldap_and_local_authentication' => '1',
'ldap_bind_dn' => 'CN=ldapsynchro,OU=Uzivatele,OU=Merlin,DC=merlin,DC=cz',
'ldap_bind_passwd' => 'PW',
'bck_script_key' => 'm7y3VVaczGI',
'bck_script_passkey' => 'def50200fa22e52da60d0cec6b9f6c61bff478a9b89f8e4f043cabd6c43c5a424edfc907ef13646c0a3f5297ab007d5ca5874c3d002e2ac741bf693b4c763f1ca575470143847bf8d3ef943321b1fcb620e19e13fb51acf3054afb3a35c6f82bad2046e171a7ae5b2dc4c59ec99a32310fda666775b464bfb956ae2f',
'teampass_version' => '3.1.1',
'secure_display_image' => '1',
'upload_zero_byte_file' => '0',
'upload_all_extensions_file' => '0',
'copy_to_clipboard_small_icons' => '1',
'ldap_new_user_role' => '48',
'admin_2fa_required' => '1',
'password_overview_delay' => '4',
'roles_allowed_to_print_select' => '',
'clipboard_life_duration' => '30',
'mfa_for_roles' => '',
'tree_counters' => '0',
'settings_offline_mode' => '0',
'settings_tree_counters' => '0',
'enable_massive_move_delete' => '0',
'email_debug_level' => '0',
'ga_reset_by_user' => '',
'onthefly-backup-key' => '',
'onthefly-restore-key' => '',
'ldap_user_dn_attribute' => 'distinguishedname',
'ldap_dn_additional_user_dn' => '',
'ldap_user_object_filter' => '',
'ldap_bdn' => 'OU=Uzivatele,OU=Merlin,DC=merlin,DC=cz',
'ldap_hosts' => 'HOST',
'ldap_password' => 'OURPW',
'ldap_username' => 'CN=ldapsynchro,OU=Uzivatele,OU=Merlin,DC=merlin,DC=cz',
'api_token_duration' => '60',
'enable_tasks_manager' => '1',
'task_maximum_run_time' => '300',
'maximum_number_of_items_to_treat' => '300',
'tasks_manager_refreshing_period' => '100',
'ldap_tls_certifacte_check' => 'LDAP_OPT_X_TLS_NEVER',
'enable_tasks_log' => '1',
'enable_ad_users_with_ad_groups' => '0',
'enable_ad_user_auto_creation' => '0',
'ldap_group_object_filter' => '',
'ldap_guid_attibute' => 'objectguid',
'sending_emails_job_frequency' => '2',
'user_keys_job_frequency' => '1',
'items_statistics_job_frequency' => '5',
'reload_cache_table_task' => '',
'rebuild_config_file' => '',
'purge_temporary_files_task' => '',
'clean_orphan_objects_task' => '',
'users_personal_folder_task' => '',
'maximum_session_expiration_time' => '60',
'items_ops_job_frequency' => '1',
'upgrade_timestamp' => '1712226231',
'enable_refresh_task_last_execution' => '1',
'ldap_group_objectclasses_attibute' => 'top,groupofuniquenames',

Updated from an older Teampass or fresh install:
Updated from 2.1.27.36

Client configuration

Browser:
firefox
Operating system:
win10

Logs

Web server error log

[error] 120007#120007: *24 FastCGI sent in stderr: "PHP message: PHP Warning: Undefined variable $query in /var/www/teampass.arbes.com/sources/users.datatable.php on line 187; PHP message: PHP Fatal error: Uncaught Error: Call to a member function filter() on null in /var/www/teampass.arbes.com/sources/users.datatable.php:187
Stack trace:
#0 {main}
thrown in /var/www/teampass.arbes.com/sources/users.datatable.php on line 187" while reading response header from upstream, client: 192.168.113.42, server: pass.arbes.com, request: "GET /sources/users.datatable.php?draw=1&columns%5B0%5D%5Bdata%5D=0&columns%5B0%5D%5Bname%5D=&columns%5B0%5D%5Bsearchable%5D=true&columns%5B0%5D%5Borderable%5D=true&columns%5B0%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B0%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B1%5D%5Bdata%5D=1&columns%5B1%5D%5Bname%5D=&columns%5B1%5D%5Bsearchable%5D=true&columns%5B1%5D%5Borderable%5D=true&columns%5B1%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B1%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B2%5D%5Bdata%5D=2&columns%5B2%5D%5Bname%5D=&columns%5B2%5D%5Bsearchable%5D=true&columns%5B2%5D%5Borderable%5D=true&columns%5B2%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B2%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B3%5D%5Bdata%5D=3&columns%5B3%5D%5Bname%5D=&columns%5B3%5D%5Bsearchable%5D=true&columns%5B3%5D%5Borderable%5D=true&columns%5B3%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B3%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B4%5D%5Bdata%5D=4&columns%5B4%5D%5Bname%5D=&columns%5B4%5D%5Bsearchable%5D=true&columns%5B4%5D%5Borderable%5D=true&columns%5B4%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B4%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B5%5D%5Bdata%5D=5&columns%5B5%5D%5Bname%5D=&columns%5B5%5D%5Bsearchable%5D=true&columns%5B5%5D%5Borderable%5D=true&columns%5B5%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B5%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B6%5D%5Bdata%5D=6&columns%5B6%5D%5Bname%5D=&columns%5B6%5D%5Bsearchable%5D=true&columns%5B6%5D%5Borderable%5D=true&columns%5B6%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B6%5D%5Bsearch%5D%5Bregex%5D=false&c

Insert your webserver log here

#### Log from the web-browser developer console (CTRL + SHIFT + i)
GET
[https://pass.arbes.com/sources/users.datatable.php?draw=1&columns[0][data]=0&columns[0][name]=&columns[0][searchable]=true&columns[0][orderable]=true&columns[0][search][value]=&columns[0][search][regex]=false&columns[1][data]=1&columns[1][name]=&columns[1][searchable]=true&columns[1][orderable]=true&columns[1][search][value]=&columns[1][search][regex]=false&columns[2][data]=2&columns[2][name]=&columns[2][searchable]=true&columns[2][orderable]=true&columns[2][search][value]=&columns[2][search][regex]=false&columns[3][data]=3&columns[3][name]=&columns[3][searchable]=true&columns[3][orderable]=true&columns[3][search][value]=&columns[3][search][regex]=false&columns[4][data]=4&columns[4][name]=&columns[4][searchable]=true&columns[4][orderable]=true&columns[4][search][value]=&columns[4][search][regex]=false&columns[5][data]=5&columns[5][name]=&columns[5][searchable]=true&columns[5][orderable]=true&columns[5][search][value]=&columns[5][search][regex]=false&columns[6][data]=6&columns[6][name]=&columns[6][searchable]=true&columns[6][orderable]=true&columns[6][search][value]=&columns[6][search][regex]=false&columns[7][data]=7&columns[7][name]=&columns[7][searchable]=true&columns[7][orderable]=true&columns[7][search][value]=&columns[7][search][regex]=false&columns[8][data]=8&columns[8][name]=&columns[8][searchable]=true&columns[8][orderable]=true&columns[8][search][value]=&columns[8][search][regex]=false&order[0][column]=1&order[0][dir]=asc&start=0&length=10&search[value]=&search[regex]=false&_=1712579159501](https://pass.arbes.com/sources/users.datatable.php?draw=1&columns%5B0%5D%5Bdata%5D=0&columns%5B0%5D%5Bname%5D=&columns%5B0%5D%5Bsearchable%5D=true&columns%5B0%5D%5Borderable%5D=true&columns%5B0%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B0%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B1%5D%5Bdata%5D=1&columns%5B1%5D%5Bname%5D=&columns%5B1%5D%5Bsearchable%5D=true&columns%5B1%5D%5Borderable%5D=true&columns%5B1%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B1%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B2%5D%5Bdata%5D=2&columns%5B2%5D%5Bname%5D=&columns%5B2%5D%5Bsearchable%5D=true&columns%5B2%5D%5Borderable%5D=true&columns%5B2%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B2%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B3%5D%5Bdata%5D=3&columns%5B3%5D%5Bname%5D=&columns%5B3%5D%5Bsearchable%5D=true&columns%5B3%5D%5Borderable%5D=true&columns%5B3%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B3%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B4%5D%5Bdata%5D=4&columns%5B4%5D%5Bname%5D=&columns%5B4%5D%5Bsearchable%5D=true&columns%5B4%5D%5Borderable%5D=true&columns%5B4%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B4%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B5%5D%5Bdata%5D=5&columns%5B5%5D%5Bname%5D=&columns%5B5%5D%5Bsearchable%5D=true&columns%5B5%5D%5Borderable%5D=true&columns%5B5%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B5%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B6%5D%5Bdata%5D=6&columns%5B6%5D%5Bname%5D=&columns%5B6%5D%5Bsearchable%5D=true&columns%5B6%5D%5Borderable%5D=true&columns%5B6%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B6%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B7%5D%5Bdata%5D=7&columns%5B7%5D%5Bname%5D=&columns%5B7%5D%5Bsearchable%5D=true&columns%5B7%5D%5Borderable%5D=true&columns%5B7%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B7%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B8%5D%5Bdata%5D=8&columns%5B8%5D%5Bname%5D=&columns%5B8%5D%5Bsearchable%5D=true&columns%5B8%5D%5Borderable%5D=true&columns%5B8%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B8%5D%5Bsearch%5D%5Bregex%5D=false&order%5B0%5D%5Bcolumn%5D=1&order%5B0%5D%5Bdir%5D=asc&start=0&length=10&search%5Bvalue%5D=&search%5Bregex%5D=false&_=1712579159501)
[HTTP/1.1 500 Internal Server Error 23ms]
Insert the log here and especially the answer of the query that failed.

[crayt214]

Same issue here.
3.1.1


and in my php logs :
[10-Apr-2024 18:30:39 Europe/Paris] PHP Warning: Undefined variable $query in /app/data/teampass/sources/users.datatable.php on line 187 [10-Apr-2024 18:30:39 Europe/Paris] PHP Fatal error: Uncaught Error: Call to a member function filter() on null in /app/data/teampass/sources/users.datatable.php:187 Stack trace: #0 {main} thrown in /app/data/teampass/sources/users.datatable.php on line 187

[mateuszdomagalayosi]

Same problem here.
While updating from 3.1.0 to 3.1.1.
Tried deleting users created from LDAP synchronization, didnt change a thing.

[crayt214]

Same problem here. While updating from 3.1.0 to 3.1.1. Tried deleting users created from LDAP synchronization, didnt change a thing.

It's working in 3.1.0 ?

[mateuszdomagalayosi]

Same problem here. While updating from 3.1.0 to 3.1.1. Tried deleting users created from LDAP synchronization, didnt change a thing.

It's working in 3.1.0 ?

Yes, but my instance was installed with that version (3.1.0). So i dont know if you can update from earlier versions to 3.1.0 (earlier versions also have some different problems when updating so i made new instance from scratch on 3.1.0).

[GladiusCZ]

Somebody know how to fix this?

[wease1]

Same problem #4194

[killmenowkid]

I am having the same issue after upgrading from 3.0.10.50 to 3.1.1. Upgrade runs as expected with no visible issue during the process. After completion and login with the admin account the error mentioned by other is seen. The entries from the Apache error log are below. Additionally I checked the database tables manually and everything in SQL seem good. There were no entries of concern in the mysql logs.

[Wed May 29 17:52:43.086876 2024] [php:warn] [pid 936] [client ] PHP Warning: Undefined variable $query in /var/www/html/teampass/sources/users.datatable.php on line 187, referer: https:///teampass/index.php?page=users
[Wed May 29 17:52:43.086899 2024] [php:error] [pid 936] [client ] PHP Fatal error: Uncaught Error: Call to a member function filter() on null in /var/www/html/teampass/sources/users.datatable.php:187\nStack trace:\n#0 {main}\n thrown in /var/www/html/teampass/sources/users.datatable.php on line 187, referer: https:///teampass/index.php?page=users

[killmenowkid]

This issue has been fixed in 3.1.2, but 3.1.2 is not currently functional due to other errors. The screenshot of the following commit fixed the error for me.

To fix the error I edited the file teampass/sources/users.datatables.php to add the changes on the above commit.

On line 187 (mentioned in the error logs) insert request-> between $ and query and remove ('draw') from the end of the line.

This allowed The user table to function but revealed another error with AD user that was resolved by following: Issue 4080

[crb-anhtuan-m]

I use the version 3.1.2.45 and this problem is fixed.

[wease1]

I use the version 3.1.2.45 and this problem is fixed.

User roles are not changed in this version.