I installed ownCloud v 10.7 on my Synology NAS (directly, NOT via Docker). It works perfectly - apart from a couple of nightly error logs in my data folder every couple of days or so. I would be really grateful if anyone could suggest what might be wrong.
I am using PHP 7.4 and MariaDB 10. I have clients using CardDAV and CalDAV and my web browsers sync their bookmarks using floccus and an .xbel file which is accessed via a WebDAV link. I have ownCloud clients on my iPhone, my Windows box and on two Macs. I use redis for file locking and get no errors at all in the ownCloud Settings/System. Everything works without any issues - apart from the error messages referred to above. When I do ââŚsettings/integrity/failedâ I get âNo errors have been foundâ.
I have made sure permissions on the ownCloud and ownCloud data folders are correct:
chown -R http:http /volume1/web/owncloud/
chown -R http:http /volume1/web/owncloud/apps/
chown -R http:http /volume1/web/owncloud/config/
chown -R http:http /volume1/owncloudData/
chown http:http /volume1/web/owncloud/.htaccess
find /volume1/web/owncloud/ -type f -print0 | xargs -0 chmod 777
find /volume1/web/owncloud/ -type d -print0 | xargs -0 chmod 777
find /volume1/owncloudData/ -type d -print0 | xargs -0 chmod 777
chmod 777 /volume1/web/owncloud/.htaccess
I access my ownCloud install via my own domain - I have a CNAME record with my domain host and a commercial SSL certificate.
This is my config.php - with sensitive information replaced by xxx:
<?php
$CONFIG = array (
'instanceid' => âxâxxx,
'passwordsalt' => â/xxxxâ,
'secret' => 'xxxxc',
'trusted_domains' =>
array (
0 => 'owncloud.xxxx.net',
1 => '192.168.xx.xxâ,
),
'datadirectory' => '/volume1/owncloudData',
'overwrite.cli.url' => 'https://owncloud.xxxx.net',
'dbtype' => 'mysql',
'version' => '10.7.0.4',
'dbname' => 'OwnCloud',
'dbhost' => '127.0.0.1:3307',
'dbtableprefix' => 'oc_',
'mysql.utf8mb4' => true,
'dbuser' => 'oc_admin2',
'dbpassword' => 'xxxxâ,
'memcache.local' => '\\OC\\Memcache\\Redis',
'memcache.locking' => '\\OC\\Memcache\\Redis',
'redis' =>
array
(
'host' => '127.0.0.1',
'port' => '6379',
'timeout' => '0',
'dbindex' => '0',
),
'mail_from_address' => âxxxxâ,
'mail_smtpmode' => 'smtp',
'mail_domain' => âxxxx.net',
'mail_smtpauthtype' => 'PLAIN',
'mail_smtpauth' => 1,
'mail_smtphost' => 'smtp.xxxx.com',
'mail_smtpport' => '465',
'mail_smtpname' => âxxxx@xxxxâ.xxxx,
'mail_smtppassword' => âxxxxâ,
'mail_smtpsecure' => 'ssl',
'default_phone_region' => 'GB',
'logtimezone' => 'UTC',
'htaccess.RewriteBase' => '/',
'trashbin_retention_obligation' => 'auto, 10',
'apps_paths' =>
array (
0 =>
array (
'path' => '/volume1/web/owncloud/apps',
'url' => '/apps',
'writable' => false,
),
1 =>
array (
'path' => '/volume1/web/owncloud/apps-external',
'url' => '/apps-external',
'writable' => true,
),
),
'installed' => true,
);
The error messages are all pretty much the same. I get two or three each night.
"date": "2021-04-07T01:57:15+00:00", /r
"parentId": null,
"id": "7c1de5089fa20b9b2781cb597c4f4b1f606d117bac7bd5.31852171",
"class": "Doctrine\\DBAL\\DBALException",
"message": "Failed to connect to the database: An exception occurred in driver: SQLSTATE[HY000] [2002] Connection refused",
"stacktrace": [
{
"file": "\/volume1\/web\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php",
"line": 428,
"function": "connect",
"class": "OC\\DB\\Connection"
},
{
"file": "\/volume1\/web\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php",
"line": 388,
"function": "getDatabasePlatformVersion",
"class": "Doctrine\\DBAL\\Connection"
},
{
"file": "\/volume1\/web\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php",
"line": 330,
"function": "detectDatabasePlatform",
"class": "Doctrine\\DBAL\\Connection"
},
{
"file": "\/volume1\/web\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php",
"line": 695,
"function": "getDatabasePlatform",
"class": "Doctrine\\DBAL\\Connection"
},
{
"file": "\/volume1\/web\/owncloud\/lib\/private\/DB\/Connection.php",
"line": 144,
"function": "setTransactionIsolation",
"class": "Doctrine\\DBAL\\Connection"
},
{
"file": "\/volume1\/web\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/DriverManager.php",
"line": 194,
"function": "__construct",
"class": "OC\\DB\\Connection"
},
{
"file": "\/volume1\/web\/owncloud\/lib\/private\/DB\/ConnectionFactory.php",
"line": 138,
"function": "getConnection",
"class": "Doctrine\\DBAL\\DriverManager"
},
{
"file": "\/volume1\/web\/owncloud\/lib\/private\/Server.php",
"line": 536,
"function": "getConnection",
"class": "OC\\DB\\ConnectionFactory"
},
{
"file": "\/volume1\/web\/owncloud\/lib\/composer\/pimple\/pimple\/src\/Pimple\/Container.php",
"line": 118,
"function": "OC\\{closure}",
"class": "OC\\Server"
},
{
"file": "\/volume1\/web\/owncloud\/lib\/private\/AppFramework\/Utility\/SimpleContainer.php",
"line": 108,
"function": "offsetGet",
"class": "Pimple\\Container"
},
{
"file": "\/volume1\/web\/owncloud\/lib\/private\/ServerContainer.php",
"line": 86,
"function": "query",
"class": "OC\\AppFramework\\Utility\\SimpleContainer"
},
{
"file": "\/volume1\/web\/owncloud\/lib\/private\/Server.php",
"line": 1239,
"function": "query",
"class": "OC\\ServerContainer"
},
{
"file": "\/volume1\/web\/owncloud\/lib\/private\/Server.php",
"line": 412,
"function": "getDatabaseConnection",
"class": "OC\\Server"
},
{
"file": "\/volume1\/web\/owncloud\/lib\/composer\/pimple\/pimple\/src\/Pimple\/Container.php",
"line": 118,
"function": "OC\\{closure}",
"class": "OC\\Server"
},
{
"file": "\/volume1\/web\/owncloud\/lib\/private\/AppFramework\/Utility\/SimpleContainer.php",
"line": 108,
"function": "offsetGet",
"class": "Pimple\\Container"
},
{
"file": "\/volume1\/web\/owncloud\/lib\/private\/ServerContainer.php",
"line": 86,
"function": "query",
"class": "OC\\AppFramework\\Utility\\SimpleContainer"
},
{
"file": "\/volume1\/web\/owncloud\/lib\/private\/Server.php",
"line": 1169,
"function": "query",
"class": "OC\\ServerContainer"
},
{
"file": "\/volume1\/web\/owncloud\/lib\/private\/Server.php",
"line": 591,
"function": "getAppConfig",
"class": "OC\\Server"
},
{
"file": "\/volume1\/web\/owncloud\/lib\/composer\/pimple\/pimple\/src\/Pimple\/Container.php",
"line": 118,
"function": "OC\\{closure}",
"class": "OC\\Server"
},
{
"file": "\/volume1\/web\/owncloud\/lib\/private\/AppFramework\/Utility\/SimpleContainer.php",
"line": 108,
"function": "offsetGet",
"class": "Pimple\\Container"
},
{
"file": "\/volume1\/web\/owncloud\/lib\/private\/ServerContainer.php",
"line": 86,
"function": "query",
"class": "OC\\AppFramework\\Utility\\SimpleContainer"
},
{
"file": "\/volume1\/web\/owncloud\/lib\/private\/Server.php",
"line": 1437,
"function": "query",
"class": "OC\\ServerContainer"
},
{
"file": "\/volume1\/web\/owncloud\/lib\/private\/legacy\/app.php",
"line": 344,
"function": "getAppManager",
"class": "OC\\Server"
},
{
"file": "\/volume1\/web\/owncloud\/lib\/private\/legacy\/app.php",
"line": 108,
"function": "getEnabledApps",
"class": "OC_App"
},
{
"file": "\/volume1\/web\/owncloud\/lib\/base.php",
"line": 583,
"function": "loadApps",
"class": "OC_App"
},
{
"file": "\/volume1\/web\/owncloud\/lib\/base.php",
"line": 1058,
"function": "init",
"class": "OC"
},
{
"file": "\/volume1\/web\/owncloud\/remote.php",
"line": 110,
"function": "require_once"
}
]
}