Steps to reproduce
1.sudo -u www-data php /var/www/owncloud/occ background:queue:status
2.sudo -u www-data php /var/www/owncloud/occ activity:send-emails
3.
Expected behaviour
Notification send
Actual behaviour
Notification not working anymore. The test message work fine. The occ background:queue:status show strange date , maybe the cause? The origin of the problem is i check because i don’t see any notification since a lot of time. When i tried to launch the cron manually with : sudo -u www-data php /var/www/owncloud/occ activity:send-emails
I received : sudo: unable to resolve host PTCDEB-OWNCLOUD
It’s because i changed the name of the server several weeks… I corrected the /etc/hosts with good name and ip, now i don’t have any errors when i use the command but no email was send…
| 11 | OCA\UpdateNotification\Notification\BackgroundJob | 2019-12-02T12:06:02+00:00 | |
| 12 | OC\Authentication\Token\DefaultTokenCleanupJob | 2019-12-02T21:00:02+00:00 | |
| 90 | OCA\Activity\BackgroundJob\EmailNotification | 2019-12-02T20:47:03+00:00 | |
| 91 | OCA\Activity\BackgroundJob\ExpireActivities | 2019-12-02T17:47:02+00:00 | |
| 97 | OCA\DAV\BackgroundJob\CleanProperties | 1970-01-01T00:00:00+00:00 | |
| 98 | OC\Command\CommandJob | 1970-01-01T00:00:00+00:00 | O:33:“OCA\Files_Trashbin\Command\Expire”:1:{s:39:"\OCA\Files_Trashbin\Command\Expire\user";s:3:“jcs”;} |
| 99 | OC\Command\CommandJob | 1970-01-01T00:00:00+00:00 | O:33:“OCA\Files_Versions\Command\Expire”:2:{s:43:"\OCA\Files_Versions\Command\Expire\fileName";s:63:“Indépendant Complémenaire/Factures de Sorties/2019/F_0139.pdf”;s:39:"\OCA\Files_Versions\Command\Expire\user";s:3:“jcs”;} |
| 100 | OC\Command\CommandJob | 1970-01-01T00:00:00+00:00 | O:33:“OCA\Files_Versions\Command\Expire”:2:{s:43:"\OCA\Files_Versions\Command\Expire\fileName";s:58:“Indépendant Complémenaire/Factures de Sorties/2019/0.pdf”;s:39:"\OCA\Files_Versions\Command\Expire\user";s:3:“jcs”;} |
| 101 | OC\Command\CommandJob | 1970-01-01T00:00:00+00:00 | O:33:“OCA\Files_Versions\Command\Expire”:2:{s:43:"\OCA\Files_Versions\Command\Expire\fileName";s:63:“Indépendant Complémenaire/Factures de Sorties/2019/F_0134.pdf”;s:39:"\OCA\Files_Versions\Command\Expire\user";s:3:“jcs”;} |
| 102 | OC\Command\CommandJob | 1970-01-01T00:00:00+00:00 | O:33:“OCA\Files_Versions\Command\Expire”:2:{s:43:"\OCA\Files_Versions\Command\Expire\fileName";s:64:“Indépendant Complémenaire/Factures de Sorties/2019/F_0133.docx”;s:39:"\OCA\Files_Versions\Command\Expire\user";s:3:“jcs”;} |
| 103 | OC\Command\CommandJob | 1970-01-01T00:00:00+00:00 | O:33:“OCA\Files_Versions\Command\Expire”:2:{s:43:"\OCA\Files_Versions\Command\Expire\fileName";s:63:“Indépendant Complémenaire/Factures de Sorties/2019/F_0133.pdf”;s:39:"\OCA\Files_Versions\Command\Expire\user";s:3:“jcs”;} |
| 104 | OC\Command\CommandJob | 1970-01-01T00:00:00+00:00 | O:33:“OCA\Files_Versions\Command\Expire”:2:{s:43:"\OCA\Files_Versions\Command\Expire\fileName";s:64:“Indépendant Complémenaire/Factures de Sorties/2019/F_0134.docx”;s:39:"\OCA\Files_Versions\Command\Expire\user";s:3:“jcs”;} |
Server configuration
Operating system:
Debian 9
Web server:
Apache 2.4.25
Database:
MySQL
PHP version:
7.0.33
ownCloud version: (see ownCloud admin page)
10.3.1
Updated from an older ownCloud or fresh install:
updated
Where did you install ownCloud from:
package download from owncloud.org
Signing status (ownCloud 9.0 and above):
?
Login as admin user into your ownCloud and access
http://example.com/index.php/settings/integrity/failed
paste the results into https://gist.github.com/ and puth the link here.
No errors have been found.
**The content of config/config.php:**
<?php
$CONFIG = array (
'instanceid' => 'ocsnwt6bevmn',
'passwordsalt' => 'Smbg6vh0AvwYI9OKEPHz1KUU0S+1zF',
'secret' => 'nSQNoxU5B0lov96bRYOyer9yO6ZQ3klg73VlvLYvltn2HZ9H',
'trusted_domains' =>
array (
0 => '192.168.0.122',
1 => XXX',
2 => 'XXX',
),
'datadirectory' => '/var/www/owncloud/data',
'overwrite.cli.url' => 'https://192.168.122/owncloud',
'dbtype' => 'mysql',
'version' => '10.3.1.1',
'versions_retention_obligation' => 'auto',
'dbname' => 'owncloud',
'dbhost' => 'localhost',
'dbtableprefix' => 'oc_',
'mysql.utf8mb4' => true,
'dbuser' => 'owncloud',
'dbpassword' => 'XFY6RvpL6zk2Fc',
'logtimezone' => 'Europe/Brussels',
'installed' => true,
'force ssl' => true,
'memcache.local' => '\\OC\\Memcache\\APCu',
'mail_domain' => 'XXXc.be',
'mail_from_address' => 'noreply',
'mail_smtpmode' => 'smtp',
'filelocking.enabled' => true,
'memcache.locking' => '\\OC\\Memcache\\Redis',
'redis' =>
array (
'host' => 'localhost',
'port' => 6379,
'timeout' => 0.0,
'password' => '',
),
'mail_smtpauthtype' => 'LOGIN',
'mail_smtpport' => '587',
'mail_smtphost' => 'ssl0.ovh.net',
'mail_smtpauth' => 1,
'mail_smtpname' => 'noreply@XXX.be',
'mail_smtppassword' => 'XXX',
'loglevel' => 2,
'maintenance' => false,
'theme' => '',
'updater.secret' => '$2y$10$wUHWqKzuXXXXXXXXXXXDYFuO5XoQ0gQcl8wkoLTX.',
);
Log in to the web-UI with an administrator account and click on
'admin' -> 'Generate Config Report' -> 'Download ownCloud config report'
This report includes the config.php settings, the list of activated apps
and other details in a well sanitized form.
or
If you have access to your command line run e.g.:
sudo -u www-data php occ config:list system
from within your ownCloud installation folder
*ATTENTION:* Do not post your config.php file in public as is. Please use one of the above
methods whenever possible. Both, the generated reports from the web-ui and from occ config:list
consistently remove sensitive data. You still may want to review the report before sending.
If done manually then it is critical for your own privacy to dilligently
remove *all* host names, passwords, usernames, salts and other credentials before posting.
You should assume that attackers find such information and will use them against your systems.
List of activated apps:
Enabled:
- activity: 2.5.2
- comments: 0.3.0
- configreport: 0.2.0
- dav: 0.5.0
- external: 1.4.0
- federatedfilesharing: 0.5.0
- federation: 0.1.0
- files: 1.5.2
- files_external: 0.7.1
- files_external_dropbox: 1.2.0
- files_mediaviewer: 1.0.1
- files_pdfviewer: 0.11.1
- files_sharing: 0.12.0
- files_trashbin: 0.9.1
- files_versions: 1.3.0
- firstrunwizard: 1.2.0
- guests: 0.8.2
- market: 0.5.0
- notifications: 0.5.0
- provisioning_api: 0.5.0
- systemtags: 0.3.0
- updatenotification: 0.2.1
Disabled: - encryption
- files_external_ftp
- user_external
If you have access to your command line run e.g.:
sudo -u www-data php occ app:list
from within your ownCloud installation folder.
Are you using external storage, if yes which one: local/smb/sftp/…
YES SMB
Are you using encryption: yes/no
NO
Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/…
NO
LDAP configuration (delete this part if not used)
With access to your command line run e.g.:
sudo -u www-data php occ ldap:show-config
from within your ownCloud installation folder
Without access to your command line download the data/owncloud.db to your local
computer or access your SQL server remotely and run the select query:
SELECT * FROM `oc_appconfig` WHERE `appid` = 'user_ldap';
Eventually replace sensitive data as the name/IP-address of your LDAP server or groups.
Client configuration
Browser:
Chrome
Operating system:
Windows 10
Logs
Web server error log
Insert your webserver log here
ownCloud log (data/owncloud.log)
Insert your ownCloud log here
Browser log
Insert your browser log here, this could for example include:
a) The javascript console log
b) The network log
c) ...