A couple of months ago installed Nextcloud on a Godaddy shared server using their Installatron library. It worked fine for the past 2 months, I uploaded about 55gb of data and created 40 new user accounts. 2 days ago I was unable to login and I see this error message:
The server was unable to complete your request.
If this happens again, please send the technical details below to the server administrator.
More details can be found in the server log.
- Remote Address: 184.108.40.206
- Request ID: YTz2JKPwKPsresHhtXf5gQAAQxE
Nextcloud version (eg, 20.0.5): not sure, latest?
server info (from godaddy cpanel):
|cPanel Version |86.0 (build 30)|
|Apache Version |2.4.46|
|PHP Version |5.6.40|
|MySQL Version |5.6.49-cll-lve|
|Operating System |linux|
|Shared IP Address |220.127.116.11|
|Path to Sendmail |/usr/sbin/sendmail|
|Path to Perl |/usr/bin/perl|
|Perl Version |5.10.1|
|Kernel Version |2.6.32-954.3.5.lve18.104.22.168.el6.x86_64|
The issue you are facing:
I did not make any changes to the site in the past 3 days and none of the new user accounts had admin access. I contacted Godaddy support and they were not able to find anything wrong with the server and were not very helpful at all.
I found this error message in the public_html/nextcloud/apps/dashboard/error_log:
[11-Sep-2021 18:26:35 UTC] PHP Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /home/nykidsclub/public_html/nextcloud/apps/dashboard/mysql.php:20
thrown in /home/nykidsclub/public_html/nextcloud/apps/dashboard/mysql.php on line 20
and this error located in /public_html/nextcloud/ocs/error_log:
[09-Sep-2021 21:22:42 UTC] PHP Fatal error: Uncaught Doctrine\DBAL\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000]  Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) in /home/nykidsclub/public_html/nextcloud/lib/private/DB/Connection.php:87
#0 /home/nykidsclub/public_html/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1486): OC\DB\Connection->connect()
#1 /home/nykidsclub/public_html/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1014): Doctrine\DBAL\Connection->getWrappedConnection()
#2 /home/nykidsclub/public_html/nextcloud/lib/private/DB/Connection.php(231): Doctrine\DBAL\Connection->executeQuery(‘SELECT * FROM
...', Array, Array, NULL) #3 /home/nykidsclub/public_html/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(210): OC\DB\Connection->executeQuery('SELECT * FROM …’, Array, Array)
#4 /home/nykidsclub/public_html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(287): Doctrine\DBAL\Query\QueryBuilder->execute()
#5 / in /home/nykidsclub/public_html/nextcloud/lib/private/DB/Connection.php on line 87
I am not very technical when it comes to the database and server and I do not have root access to the server since it is a shared godaddy server. I am confused how the site can break itself like this without any user changes.
Please help - thank you!