I Installed nextcloud in a shared webhosting
I cannot upload files bigger than 10MB when using mysql database. It throws “unkown error” without finishing uploading the file. When installing sqllite i have none problems. I have other apps in the hosting that use mysqldb without problem.
I installed several versions of nextcloud, 20, 19, 18 ,17 all of them with the same errors.
I dont know what to do to fix de error
Please provide DETAILED information about your installation, used software versions, Nextcloud configuration and any related Nextcloud error message which are logged when trying to use a MySQL database.
Thank You for your quick answer
This is the system server and there are so many errors in the log
Server configuration detail
Operating system: Linux 3.10.0-962.3.2.lve1.5.25.6.el7.x86_64 #1 SMP Thu Apr 18 06:40:26 EDT 2019 x86_64
Webserver: LiteSpeed (litespeed)
Database: mysql 10.4.14
PHP version: 7.3.20
Modules loaded: Core, date, libxml, openssl, pcre, sqlite3, zlib, bz2, calendar, ctype, curl, hash, filter, ftp, gettext, gmp, SPL, iconv, pcntl, readline, Reflection, session, standard, shmop, SimpleXML, mbstring, tokenizer, xml, litespeed, bcmath, dom, fileinfo, gd, json, propro, raphf, http, imagick, imap, intl, exif, memcached, mysqlnd, mysqli, PDO, pdo_mysql, pdo_sqlite, Phar, posix, soap, sockets, tidy, timezonedb, wddx, xmlreader, xmlrpc, xmlwriter, xsl, zip, ionCube Loader, Zend OPcache
Nextcloud version: 20.0.0 - 20.0.0.9
Updated from an older Nextcloud/ownCloud or fresh install:
Where did you install Nextcloud from: unknown
Signing status
Array ( )
List of activated apps
Enabled:
- accessibility: 1.6.0
- activity: 2.13.1
- bruteforcesettings: 2.0.1
- cloud_federation_api: 1.3.0
- comments: 1.10.0
- contactsinteraction: 1.1.0
- dashboard: 7.0.0
- dav: 1.16.0
- federatedfilesharing: 1.10.1
- federation: 1.10.1
- files: 1.15.0
- files_pdfviewer: 2.0.1
- files_rightclick: 0.17.0
- files_sharing: 1.12.0
- files_trashbin: 1.10.1
- files_versions: 1.13.0
- files_videoplayer: 1.9.0
- firstrunwizard: 2.9.0
- logreader: 2.5.0
- lookup_server_connector: 1.8.0
- nextcloud_announcements: 1.9.0
- notifications: 2.8.0
- oauth2: 1.8.0
- password_policy: 1.10.1
- photos: 1.2.0
- privacy: 1.4.0
- provisioning_api: 1.10.0
- recommendations: 0.8.0
- serverinfo: 1.10.0
- settings: 1.2.0
- sharebymail: 1.10.0
- support: 1.3.0
- survey_client: 1.8.0
- systemtags: 1.10.0
- text: 3.1.0
- theming: 1.11.0
- twofactor_backupcodes: 1.9.0
- updatenotification: 1.10.0
- user_status: 1.0.0
- viewer: 1.4.0
- weather_status: 1.0.0
- workflowengine: 2.2.0
Disabled:
- admin_audit
- encryption
- files_external
- user_ldap
Configuration (config/config.php)
{
"instanceid": "***REMOVED SENSITIVE VALUE***",
"passwordsalt": "***REMOVED SENSITIVE VALUE***",
"secret": "***REMOVED SENSITIVE VALUE***",
"trusted_domains": [
"higseg.com.ar"
],
"datadirectory": "***REMOVED SENSITIVE VALUE***",
"dbtype": "mysql",
"version": "20.0.0.9",
"overwrite.cli.url": "https:\/\/higseg.com.ar\/cloud",
"dbname": "***REMOVED SENSITIVE VALUE***",
"dbhost": "***REMOVED SENSITIVE VALUE***",
"dbport": "",
"dbtableprefix": "oc_",
"mysql.utf8mb4": true,
"dbuser": "***REMOVED SENSITIVE VALUE***",
"dbpassword": "***REMOVED SENSITIVE VALUE***",
"installed": true
}
External storages: files_external is disabled
Encryption: no
User-backends:
- OC\User\Database
Browser: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.121 Safari/537.36
Here there are a few errors (not all)
[PHP] Error: Error: shell_exec() has been disabled for security reasons at /home/u339030895/domains/higseg.com.ar/public_html/cloud/apps/serverinfo/lib/OperatingSystems/DefaultOs.php#134 at <>
- <>
OC\Log\ErrorHandler::onError(2, “shell_exec() ha … s”, “/home/u33903089 … p”, 134, {servers: null}) - /home/u339030895/domains/higseg.com.ar/public_html/cloud/apps/serverinfo/lib/OperatingSystems/DefaultOs.php line 134
shell_exec("cat /etc/system … “”) - /home/u339030895/domains/higseg.com.ar/public_html/cloud/apps/serverinfo/lib/Os.php line 90
OCA\ServerInfo\OperatingSystems\DefaultOs->getTimeServers() - /home/u339030895/domains/higseg.com.ar/public_html/cloud/apps/serverinfo/lib/Controller/ApiController.php line 118
OCA\ServerInfo\Os->getTimeServers() - /home/u339030895/domains/higseg.com.ar/public_html/cloud/lib/private/AppFramework/Http/Dispatcher.php line 169
OCA\ServerInfo\Controller\ApiController->BasicData() - /home/u339030895/domains/higseg.com.ar/public_html/cloud/lib/private/AppFramework/Http/Dispatcher.php line 100
OC\AppFramework\Http\Dispatcher->executeController(OCA\ServerInfo\C … {}, “BasicData”) - /home/u339030895/domains/higseg.com.ar/public_html/cloud/lib/private/AppFramework/App.php line 152
OC\AppFramework\Http\Dispatcher->dispatch(OCA\ServerInfo\C … {}, “BasicData”) - /home/u339030895/domains/higseg.com.ar/public_html/cloud/lib/private/Route/Router.php line 308
OC\AppFramework\App::main(“OCA\ServerInfo … r”, “BasicData”, OC\AppFramework\ … {}, {action: null,_r … "}) - /home/u339030895/domains/higseg.com.ar/public_html/cloud/ocs/v1.php line 88
OC\Route\Router->match("/ocsapp/apps/se … a") - /home/u339030895/domains/higseg.com.ar/public_html/cloud/ocs/v2.php line 24
require_once("/home/u33903089 … p")
GET /cloud/ocs/v2.php/apps/serverinfo/api/v1//basicdata?format=json
from 190.7.50.124 by admin at 2020-10-06T20:56:08+00:00
[PHP] Error: Error: Cannot modify header information - headers already sent by (output started at /home/u339030895/domains/higseg.com.ar/public_html/cloud/3rdparty/sabre/http/lib/Sapi.php:132) at /home/u339030895/domains/higseg.com.ar/public_html/cloud/apps/dav/lib/Connector/Sabre/File.php#691 at <>
- <>
OC\Log\ErrorHandler::onError(2, “Cannot modify h … )”, “/home/u33903089 … p”, 691, {string: "X-Hash-MD5: "}) - /home/u339030895/domains/higseg.com.ar/public_html/cloud/apps/dav/lib/Connector/Sabre/File.php line 691
header("X-Hash-MD5: ") - /home/u339030895/domains/higseg.com.ar/public_html/cloud/apps/dav/lib/Connector/Sabre/File.php line 189
OCA\DAV\Connector\Sabre\File->header("X-Hash-MD5: ") - <>
OCA\DAV\Connector\Sabre\File->OCA\DAV\Connector\Sabre{closure}("*** sensitive parameters replaced ***") - /home/u339030895/domains/higseg.com.ar/public_html/cloud/lib/private/Files/Stream/HashWrapper.php line 71
call_user_func(Closure {}, “*** sensitive parameter replaced ***”) - <>
OC\Files\Stream\HashWrapper->stream_close() - /home/u339030895/domains/higseg.com.ar/public_html/cloud/3rdparty/icewind/streams/src/Wrapper.php line 132
fclose(null) - /home/u339030895/domains/higseg.com.ar/public_html/cloud/lib/private/Files/Stream/HashWrapper.php line 75
Icewind\Streams\Wrapper->stream_close() - <>
OC\Files\Stream\HashWrapper->stream_close() - /home/u339030895/domains/higseg.com.ar/public_html/cloud/3rdparty/icewind/streams/src/Wrapper.php line 132
fclose(null) - /home/u339030895/domains/higseg.com.ar/public_html/cloud/lib/private/Files/Stream/HashWrapper.php line 75
Icewind\Streams\Wrapper->stream_close() - <>
OC\Files\Stream\HashWrapper->stream_close()
PUT /cloud/remote.php/dav/uploads/admin/web-file-upload-4bdfe25f43aa0865b5c60f141341a357-1601778222944/0
from 190.7.50.124 by admin at 2020-10-04T02:24:03+00:00
[PHP] Error: Error: hash_final(): supplied resource is not a valid Hash Context resource at /home/u339030895/domains/higseg.com.ar/public_html/cloud/lib/private/Files/Stream/HashWrapper.php#71 at <>
- <>
OC\Log\ErrorHandler::onError(2, “hash_final(): s … e”, “/home/u33903089 … p”, 71, []) - /home/u339030895/domains/higseg.com.ar/public_html/cloud/lib/private/Files/Stream/HashWrapper.php line 71
hash_final(HashContext {}) - <>
OC\Files\Stream\HashWrapper->stream_close() - /home/u339030895/domains/higseg.com.ar/public_html/cloud/3rdparty/icewind/streams/src/Wrapper.php line 132
fclose(null) - /home/u339030895/domains/higseg.com.ar/public_html/cloud/lib/private/Files/Stream/HashWrapper.php line 75
Icewind\Streams\Wrapper->stream_close() - <>
OC\Files\Stream\HashWrapper->stream_close() - /home/u339030895/domains/higseg.com.ar/public_html/cloud/3rdparty/icewind/streams/src/Wrapper.php line 132
fclose(null) - /home/u339030895/domains/higseg.com.ar/public_html/cloud/lib/private/Files/Stream/HashWrapper.php line 75
Icewind\Streams\Wrapper->stream_close() - <>
OC\Files\Stream\HashWrapper->stream_close()
PUT /cloud/remote.php/dav/uploads/admin/web-file-upload-4bdfe25f43aa0865b5c60f141341a357-1601778222944/0
from 190.7.50.124 by admin at 2020-10-04T02:24:03+00:00
[webdav] Fatal: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘SELECT fileid
FROM oc_filecache
WHERE (storage
= ?) AND (path_hash
= ?)’ with params [2, “162830e95b59626ee503c193b0f2f390”]:
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away at <>
- /home/u339030895/domains/higseg.com.ar/public_html/cloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 169
Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException(“An exception oc … y”, Doctrine\DBAL\Dr … ]}) - /home/u339030895/domains/higseg.com.ar/public_html/cloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 149
Doctrine\DBAL\DBALException::wrapException(Doctrine\DBAL\Driver\PDOMySql\Driver {}, Doctrine\DBAL\Dr … ]}, “An exception oc … y”) - /home/u339030895/domains/higseg.com.ar/public_html/cloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php line 914
Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Doctrine\DBAL\Driver\PDOMySql\Driver {}, Doctrine\DBAL\Dr … ]}, “SELECTfileid
… )”, {1: 2,2: "162830 … "}) - /home/u339030895/domains/higseg.com.ar/public_html/cloud/lib/private/DB/Connection.php line 194
Doctrine\DBAL\Connection->executeQuery(“SELECTfileid
… )”, [2,“162830e95b59626ee503c193b0f2f390”], [1,2], null) - /home/u339030895/domains/higseg.com.ar/public_html/cloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php line 206
OC\DB\Connection->executeQuery(“SELECTfileid
… )”, {dcValue1: 2,dcV … "}, {dcValue1: 1,dcValue2: 2}) - /home/u339030895/domains/higseg.com.ar/public_html/cloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 217
Doctrine\DBAL\Query\QueryBuilder->execute() - /home/u339030895/domains/higseg.com.ar/public_html/cloud/lib/private/Files/Cache/Cache.php line 470
OC\DB\QueryBuilder\QueryBuilder->execute() - /home/u339030895/domains/higseg.com.ar/public_html/cloud/lib/private/Files/Cache/Cache.php line 485
OC\Files\Cache\Cache->getId(“uploads/web-fil … 4”) - /home/u339030895/domains/higseg.com.ar/public_html/cloud/lib/private/Files/Cache/Scanner.php line 177
OC\Files\Cache\Cache->getParentId("*** sensitive parameter replaced ***") - /home/u339030895/domains/higseg.com.ar/public_html/cloud/lib/private/Files/Cache/Scanner.php line 338
OC\Files\Cache\Scanner->scanFile("*** sensitive parameter replaced ***", 3, -1, null, false) - /home/u339030895/domains/higseg.com.ar/public_html/cloud/lib/private/Files/Cache/Updater.php line 126
OC\Files\Cache\Scanner->scan("*** sensitive parameter replaced ***", false, 3, false) - /home/u339030895/domains/higseg.com.ar/public_html/cloud/apps/dav/lib/Connector/Sabre/File.php line 310
OC\Files\Cache\Updater->update("*** sensitive parameters replaced ***") - /home/u339030895/domains/higseg.com.ar/public_html/cloud/apps/dav/lib/Connector/Sabre/Directory.php line 155
OCA\DAV\Connector\Sabre\File->put(null) - /home/u339030895/domains/higseg.com.ar/public_html/cloud/apps/dav/lib/Upload/UploadFolder.php line 46
OCA\DAV\Connector\Sabre\Directory->createFile(“0”, null) - /home/u339030895/domains/higseg.com.ar/public_html/cloud/3rdparty/sabre/dav/lib/DAV/Server.php line 1104
OCA\DAV\Upload\UploadFolder->createFile(“0”, null) - /home/u339030895/domains/higseg.com.ar/public_html/cloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php line 527
Sabre\DAV\Server->createFile(“uploads/admin/w … 0”, null, null) - /home/u339030895/domains/higseg.com.ar/public_html/cloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php line 89
Sabre\DAV\CorePlugin->httpPut(Sabre\HTTP\Request {}, Sabre\HTTP\Response {}) - /home/u339030895/domains/higseg.com.ar/public_html/cloud/3rdparty/sabre/dav/lib/DAV/Server.php line 474
Sabre\DAV\Server->emit(“method:PUT”, [Sabre\HTTP\Requ … }]) - /home/u339030895/domains/higseg.com.ar/public_html/cloud/3rdparty/sabre/dav/lib/DAV/Server.php line 251
Sabre\DAV\Server->invokeMethod(Sabre\HTTP\Request {}, Sabre\HTTP\Response {}) - /home/u339030895/domains/higseg.com.ar/public_html/cloud/3rdparty/sabre/dav/lib/DAV/Server.php line 319
Sabre\DAV\Server->start() - /home/u339030895/domains/higseg.com.ar/public_html/cloud/apps/dav/lib/Server.php line 325
Sabre\DAV\Server->exec() - /home/u339030895/domains/higseg.com.ar/public_html/cloud/apps/dav/appinfo/v2/remote.php line 35
OCA\DAV\Server->exec() - /home/u339030895/domains/higseg.com.ar/public_html/cloud/remote.php line 167
require_once("/home/u33903089 … p")
PUT /cloud/remote.php/dav/uploads/admin/web-file-upload-4bdfe25f43aa0865b5c60f141341a357-1601778222944/0
from 190.7.50.124 by admin at 2020-10-04T02:24:03+00:00