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: 14.0.3
Operating system and version: Ubuntu 16.04 LTS
Apache or nginx version: Apache 2.4.18
PHP version: PHP 7.0.32-0ubuntu0.16.04.1 (cli) ( NTS )
Is this the first time you’ve seen this error?: Yes
The issue you are facing:
Attempted to install Onlyoffice Community Document server earlier today. After the command, my terminal stated broken dependencies and packages.
Shortly after noticed nextcloud unable to connect with HTTP 500 Error not connecting on any platform. I did not notice any .htaccess files modified recently.
All errors from access requests were Error 500 Internal Server Error.
Error from web, desktop app, and davdroid sync.
Different ports were still operational such as Emby.
First error in terminal after trying to install OnlyOffice Community Server
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:
The following packages have unmet dependencies:
onlyoffice-communityserver : Depends: mysql-server
Depends: mysql-client but it is not going to be installed
Depends: nodejs (>= 6.10.3) but it is not going to be installed
E: Unable to correct problems, you have held broken packages.
So I then tried to install mysql-server for onlyoffice which broke nextcloud.
I removed mysql-server and tried to restart mysql when I realized as it displayed this error:
sudo service mysql status
● mysql.service - LSB: Start and stop the mysql database server daemon
Loaded: loaded (/etc/init.d/mysql; bad; vendor preset: enabled)
Active: inactive (dead) since Sat 2018-12-08 18:05:57 EST; 1h 13min ago
Docs: man:systemd-sysv-generator(8)
Dec 08 18:05:55 ubserv mysqld[1663]: 181208 18:05:55 [Note] /usr/sbin/mysqld: No
Dec 08 18:05:55 ubserv mysqld[1663]: 181208 18:05:55 [Note] Event Scheduler: Pur
Dec 08 18:05:55 ubserv mysqld[1663]: 181208 18:05:55 [Note] InnoDB: FTS optimize
Dec 08 18:05:55 ubserv mysqld[1663]: 181208 18:05:55 [Note] InnoDB: Starting shu
Dec 08 18:05:55 ubserv mysqld[1663]: 181208 18:05:55 [Note] InnoDB: Waiting for
Dec 08 18:05:56 ubserv mysqld[1663]: 181208 18:05:56 [Note] InnoDB: Shutdown com
Dec 08 18:05:56 ubserv mysqld[1663]: 181208 18:05:56 [Note] /usr/sbin/mysqld: Sh
Dec 08 18:05:56 ubserv mysqld[1663]:
Dec 08 18:05:57 ubserv mysql[25618]: ...done.
Dec 08 18:05:57 ubserv systemd[1]: Stopped LSB: Start and stop the mysql databas
Steps to replicate it:
- Removed onlyoffice community server
- Removed mysql-server
- Rebooted
- No changes in .htaccess files logged
Output of Apache2 Error Log:
[Sat Dec 08 18:06:00.356388 2018] [:error] [pid 24620] [client 192.168.1.190:48310] PHP Fatal error: Uncaught Doctrine\\DBAL\\DBALException: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [2002] No such file or directory in /var/www/nextcloud/lib/private/DB/Connection.php:64\nStack trace:\n#0 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(429): OC\\DB\\Connection->connect()\n#1 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(389): Doctrine\\DBAL\\Connection->getDatabasePlatformVersion()\n#2 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(328): Doctrine\\DBAL\\Connection->detectDatabasePlatform()\n#3 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(623): Doctrine\\DBAL\\Connection->getDatabasePlatform()\n#4 /var/www/nextcloud/lib/private/DB/Connection.php(151): Doctrine\\DBAL\\Connection->setTransactionIsolation(2)\n#5 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DriverManager.php(172): OC\\DB\\Connection->__construct(Array, Object(Doctrine\\DBAL\\Driver\\PDOMySql\\Driver), Obj in /var/www/nextcloud/lib/private/DB/Connection.php on line 64
So it seems when I tired to install mysql-server for onlyoffice, it redirected or broke apache2 from nextcloud.
The output of your config.php file in /path/to/nextcloud
:
<?php
$CONFIG = array (
'instanceid' => 'oc1vu6rggsil',
'passwordsalt' => '',
'secret' => '',
'trusted_domains' =>
array (
0 => '[rem]',
1 => '[rem].io',
),
'datadirectory' => '/var/www/nextcloud/data',
'overwrite.cli.url' => 'https://[REMOVED]/nextcloud',
'dbtype' => 'mysql',
'version' => '14.0.3.0',
'dbname' => 'nextcloud',
'dbhost' => 'localhost:443',
'dbport' => '',
'dbtableprefix' => 'oc_',
'dbuser' => '',
'dbpassword' => '',
'installed' => true,
'maintenance' => false,
'filelocking.enabled' => false,
'theme' => '',
'updater.secret' => '',
'loglevel' => 2,
'mail_smtpmode' => 'smtp',
'mail_smtpsecure' => 'ssl',
'skeletondirectory' => '/var/opt/ncskeledir',
'memcache.local' => '\\OC\\Memcache\\APCu',
'memcache.distributed' => '\\OC\\Memcache\\Memcached',
'memcached_servers' =>
array (
0 =>
array (
0 => 'localhost',
1 => 11211,
),
),
);
If I try to run a mysql command this is the response:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")