Steps to reproduce
Server 10.4.1 combined with Windows desktop app 2.6.3. App password is needed to connect the Windows client, but it is not persistent.
Expected behaviour
As far as we understand, app passwords should be persistent and never be deleted.
Actual behaviour
The app password for any connected Windows client is periodically revoked about every week or so, usually overnight, and needs to be reinstated again. The client loses connection to the server and the app password entry shown under “Security > App-passwords / Tokens” in the user’s own preferences, is gone.
Server configuration
Debian 4.19.0
apache2
MariaDB
PHP 7.3
ownCloud Server 10.4.1
ownCloud Windows client 2.6.3
Fresh install
Signing status (ownCloud 9.0 and above):
“No errors have been found.”
The content of config/config.php:
too long
List of activated apps:
Enabled:
- activity: 2.5.3
- comments: 0.3.0
- configreport: 0.2.0
- dav: 0.5.0
- encryption: 1.4.0
- federatedfilesharing: 0.5.0
- files: 1.5.2
- files_external: 0.7.1
- files_mediaviewer: 1.0.2
- files_sharing: 0.12.0
- files_trashbin: 0.9.1
- files_versions: 1.3.0
- market: 0.5.0
- notifications: 0.5.0
- provisioning_api: 0.5.0
- systemtags: 0.3.0
- theme-removed: 1.0.0
- twofactor_totp: 0.6.1
- updatenotification: 0.2.1
- user_ldap: 0.15.1
Disabled: - external
- federation
- firstrunwizard
- user_external
Enabled: - activity: 2.5.3
- comments: 0.3.0
- configreport: 0.2.0
- dav: 0.5.0
- encryption: 1.4.0
- federatedfilesharing: 0.5.0
- files: 1.5.2
- files_external: 0.7.1
- files_mediaviewer: 1.0.2
- files_sharing: 0.12.0
- files_trashbin: 0.9.1
- files_versions: 1.3.0
- market: 0.5.0
- notifications: 0.5.0
- provisioning_api: 0.5.0
- systemtags: 0.3.0
- theme-removed: 1.0.0
- twofactor_totp: 0.6.1
- updatenotification: 0.2.1
- user_ldap: 0.15.1
Disabled: - external
- federation
- firstrunwizard
- user_external
Are you using encryption: no
Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/…
LDAP configuration (delete this part if not used)
±------------------------------±-----------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Configuration | removed |
±------------------------------±-----------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| hasMemberOfFilterSupport | 1 |
| hasPagedResultSupport | |
| homeFolderNamingRule | |
| lastJpegPhotoLookup | 0 |
| ldapAgentName | CN=removed,OU=ServiceUsers,OU=Corporate,DC=int,DC=removed,DC=removed |
| ldapAgentPassword | *** |
| ldapAttributesForGroupSearch | |
| ldapAttributesForUserSearch | |
| ldapBackupHost | |
| ldapBackupPort | |
| ldapBase | OU=Corporate,DC=int,DC=removed,DC=removed |
| ldapBaseGroups | OU=Corporate,DC=int,DC=removed,DC=removed |
| ldapBaseUsers | OU=Corporate,DC=int,DC=removed,DC=removed |
| ldapCacheTTL | 600 |
| ldapConfigurationActive | 1 |
| ldapDynamicGroupMemberURL | |
| ldapEmailAttribute | mail |
| ldapExperiencedAdmin | 0 |
| ldapExpertUUIDGroupAttr | |
| ldapExpertUUIDUserAttr | objectguid |
| ldapExpertUsernameAttr | |
| ldapGroupDisplayName | cn |
| ldapGroupFilter | (|(cn=removed)) |
| ldapGroupFilterGroups | removed|
| ldapGroupFilterMode | 0 |
| ldapGroupFilterObjectclass | |
| ldapGroupMemberAssocAttr | member |
| ldapHost | ldap:// |
| ldapIgnoreNamingRules | |
| ldapLoginFilter | (&(&(|(objectclass=person)))(|(mailPrimaryAddress=%uid)(mail=%uid))) |
| ldapLoginFilterAttributes | |
| ldapLoginFilterEmail | 1 |
| ldapLoginFilterMode | 0 |
| ldapLoginFilterUsername | 0 |
| ldapNestedGroups | 0 |
| ldapNetworkTimeout | 2 |
| ldapOverrideMainServer | |
| ldapPagingSize | 500 |
| ldapPort | 389 |
| ldapQuotaAttribute | |
| ldapQuotaDefault | |
| ldapTLS | 0 |
| ldapUserDisplayName | displayname |
| ldapUserDisplayName2 | |
| ldapUserFilter | (&(|(objectclass=organizationalPerson))(!(userAccountControl:1.2.840.113556.1.4.803:=2))(|(memberof=CN=removed ,OU=Groups,OU=Corporate,DC=int,DC=removed,DC=removed))) |
| ldapUserFilterGroups | removed |
| ldapUserFilterMode | 0 |
| ldapUserFilterObjectclass | |
| ldapUserName | samaccountname |
| ldapUuidGroupAttribute | auto |
| ldapUuidUserAttribute | auto |
| turnOffCertCheck | 0 |
| useMemberOfToDetectMembership | 1 |
±------------------------------±-----------------------------------------------------------------------------------------------------------------------------------------------------------------------+
±------------------------------±---------------+
| Configuration | s01 |
±------------------------------±---------------+
| hasMemberOfFilterSupport | 0 |
| hasPagedResultSupport | |
| homeFolderNamingRule | |
| lastJpegPhotoLookup | 0 |
| ldapAgentName | |
| ldapAgentPassword | *** |
| ldapAttributesForGroupSearch | |
| ldapAttributesForUserSearch | |
| ldapBackupHost | |
| ldapBackupPort | |
| ldapBase | |
| ldapBaseGroups | |
| ldapBaseUsers | |
| ldapCacheTTL | 600 |
| ldapConfigurationActive | 0 |
| ldapDynamicGroupMemberURL | |
| ldapEmailAttribute | |
| ldapExperiencedAdmin | 0 |
| ldapExpertUUIDGroupAttr | |
| ldapExpertUUIDUserAttr | |
| ldapExpertUsernameAttr | |
| ldapGroupDisplayName | cn |
| ldapGroupFilter | |
| ldapGroupFilterGroups | |
| ldapGroupFilterMode | 0 |
| ldapGroupFilterObjectclass | |
| ldapGroupMemberAssocAttr | uniqueMember |
| ldapHost | |
| ldapIgnoreNamingRules | |
| ldapLoginFilter | |
| ldapLoginFilterAttributes | |
| ldapLoginFilterEmail | 0 |
| ldapLoginFilterMode | 0 |
| ldapLoginFilterUsername | 1 |
| ldapNestedGroups | 0 |
| ldapNetworkTimeout | 2 |
| ldapOverrideMainServer | |
| ldapPagingSize | 500 |
| ldapPort | |
| ldapQuotaAttribute | |
| ldapQuotaDefault | |
| ldapTLS | 0 |
| ldapUserDisplayName | displayName |
| ldapUserDisplayName2 | |
| ldapUserFilter | |
| ldapUserFilterGroups | |
| ldapUserFilterMode | 0 |
| ldapUserFilterObjectclass | |
| ldapUserName | samaccountname |
| ldapUuidGroupAttribute | auto |
| ldapUuidUserAttribute | auto |
| turnOffCertCheck | 0 |
| useMemberOfToDetectMembership | 1 |
±------------------------------±---------------+
Client configuration
n/a
Operating system:
Win10
Logs
Web server error log
Empty
ownCloud log (data/owncloud.log)
Insert your ownCloud log here
{“reqId”:“removed”,“level”:3,“time”:“2020-06-06T17:08:19+00:00”,“remoteAddr”:"",“user”:"–",“app”:“mysql.setup”,“method”:"–",“url”:"–",“message”:"Specific user creation failed: An exception occurred while
executing ‘SELECT user FROM mysql.user WHERE user=?’ with params ["removed “]:\n\nSQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user ‘removed’@‘localhost’ for table ‘user’”}