Support intro
Sorry to hear you’re facing problems
help.nextcloud.com is for home/non-enterprise users. If you’re running a business, paid support can be accessed via portal.nextcloud.com where we can ensure your business keeps running smoothly.
In order to help you as quickly as possible, before clicking Create Topic please provide as much of the below as you can. Feel free to use a pastebin service for logs, otherwise either indent short log examples with four spaces:
example
Or for longer, use three backticks above and below the code snippet:
longer
example
here
Some or all of the below information will be requested if it isn’t supplied; for fastest response please provide as much as you can
Nextcloud version : 27.1.4
Operating system and version: Ubuntu server 22.04.03
Apache or nginx version: Dont know
PHP version: 8.1.25
The issue you are facing:
Nextcloud instance is preinstalled with ubuntu server installation (on last step there is window where you can chose what to install with ubuntu and nextcloud is installed with snap)
When i remove user from admin panel there are still leftovers in database
I found it when i tried to rename user login accounts in database.
I found that database is located in var/snap/nextcloud/current/mysql/nextcloud and is in multiple files like “oc_accounts.ibd”, “oc_activity.ibd” etc.
When i open for example oc_accounts.ibd in nano or notepad++ i found that there are still entries with old users who were deleted.
How can i “clear” database from old users? I had problem with creating user with same login as previously removed where i got error “user already exist”.
The user folder is removed from /var/snap/nextcloud/common/nextcloud/data/.
The output of your config.php file in /path/to/nextcloud
(make sure you remove any identifiable information!):
<?php
$CONFIG = array (
'apps_paths' =>
array (
0 =>
array (
'path' => '/snap/nextcloud/current/htdocs/apps',
'url' => '/apps',
'writable' => false,
),
1 =>
array (
'path' => '/var/snap/nextcloud/current/nextcloud/extra-apps',
'url' => '/extra-apps',
'writable' => true,
),
),
'supportedDatabases' =>
array (
0 => 'mysql',
),
'memcache.locking' => '\\OC\\Memcache\\Redis',
'memcache.local' => '\\OC\\Memcache\\Redis',
'redis' =>
array (
'host' => '/tmp/sockets/redis.sock',
'port' => 0,
),
'log_type' => 'file',
'logfile' => '/var/snap/nextcloud/current/logs/nextcloud.log',
'logfilemode' => 416,
'passwordsalt' => *****,
'secret' => *****,
'trusted_domains' =>
array (
0 => 'localhost',
1 => *****,
),
'trusted_proxies' =>
array (
0 => *****,
),
'force_language' => 'pl',
'skeletondirectory' => '',
'datadirectory' => '/var/snap/nextcloud/common/nextcloud/data',
'dbtype' => 'mysql',
'version' => '27.1.4.1',
'overwrite.cli.url' => 'http://localhost',
'dbname' => 'nextcloud',
'dbhost' => 'localhost:/tmp/sockets/mysql.sock',
'dbport' => '',
'dbtableprefix' => 'oc_',
'mysql.utf8mb4' => true,
'dbuser' => 'nextcloud',
'dbpassword' => *****,
'installed' => true,
'instanceid' => 'ociowfy3l9yw',
'maintenance' => false,
'loglevel' => 2,
'mail_smtpmode' => 'smtp',
'mail_sendmailmode' => 'smtp',
'mail_from_address' => *****,
'mail_smtpauth' => 1,
'mail_smtpname' => *****,
'mail_smtppassword' => *****,
'mail_domain' => *****,
'mail_smtpport' => '587',
'mail_smtphost' => *****,
);
...