Reinstalled NC 3 times, still getting a blank page

🚧 Installation
1

Let me start by saying I’m using this.
I’ve know the basics of Linux (ownership, modifying files, some bash, ect), but I’m not sure if that’s important.
Anyways, I’m uploading some jpg photos (about 12mb each) to NextCloud, when suddenly I get a thing coming from the top that says ‘Internal Service Error’. So I refresh the page, and I get a blank page. I tried this using both the domain & IP. I can reboot, but it just happens again. Rebooting the server gives me a few seconds of time, until I receive a blank page.

No apps have been installed. I’ve tried reinstalling through Vultr’s control panel several times.

EDIT: Here is some of /var/log/nginx/nextcloud_https_error.log:

2017/12/17 03:42:18 [error] 1843#1843: *35 FastCGI sent in stderr: "PHP message: 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/html/lib/private/DB/Connection.php:61
Stack trace:
#0 /var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(429): OC\DB\Connection->connect()
#1 /var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(389): Doctrine\DBAL\Connection->getDatabasePlatformVersion()
#2 /var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(328): Doctrine\DBAL\Connection->detectDatabasePlatform()
#3 /var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(623): Doctrine\DBAL\Connection->getDatabasePlatform()
#4 /var/www/html/lib/private/DB/Connection.php(148): Doctrine\DBAL\Connection->setTransactionIsolation(2)
#5 /var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DriverManager.php(172): OC\DB\Connection->__construct(Array, Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Obj...
PHP message: 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/html/lib/private/DB/Connection.php:61
Stack trace:
#0 /var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(429): OC\DB\Connection->connect()
#1 /var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(389): Doctrine\DBAL\Connection->getDatabasePlatformVersion()
#2 /var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(328): Doctrine\DBAL\Connection->detectDatabasePlatform()
#3 /var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(623): Doctrine\DBAL\Connection->getDatabasePlatform()
#4 /var/www/html/lib/private/DB/Connection.php(148): Doctrine\DBAL\Connection->setTransactionIsolation(2)
#5 /var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DriverManager.php(172): OC\DB\Connection->__c

2017/12/17 03:42:07 [error] 1843#1843: *41 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Allowed memory size of 134217728 bytes exhausted (tried to allocate 8192 bytes) in /var/www/html/lib/private/legacy/image.php on line 886" while reading response header from upstream, client: myip, server: _, request: "GET /core/preview.png?file={filename}.jpg&c=4ef098fe0c9bb5f38a10297f9752e26d&x=32&y=32&forceIcon=0 HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "server ip"
2017/12/17 03:42:07 [error] 1843#1843: *57 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Allowed memory size of 134217728 bytes exhausted (tried to allocate 8192 bytes) in /var/www/html/lib/private/legacy/image.php on line 886" while reading response header from upstream, client: my ip, server: _, request: "GET /core/preview.png?file={filename}.jpg&c=bc446224dd692d5a60f2053625d00b78&x=32&y=32&forceIcon=0 HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "server ip"
2017/12/17 03:42:07 [error] 1843#1843: *40 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Allowed memory size of 134217728 bytes exhausted (tried to allocate 8192 bytes) in /var/www/html/lib/private/legacy/image.php on line 886" while reading response header from upstream, client: my ip, server: _, request: "GET /core/preview.png?file={filename}.jpg&c=ede5d140359f0305bde0b51b1add9f77&x=32&y=32&forceIcon=0 HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "server ip"
2017/12/17 03:42:07 [error] 1843#1843: *35 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Allowed memory size of 134217728 bytes exhausted (tried to allocate 8192 bytes) in /var/www/html/lib/private/legacy/image.php on line 886" while reading response header from upstream, client:my ip, server: _, request: "GET /core/preview.png?{filename}.jpg&c=dabcaf9bceb948d91f0f4a3b93975caf&x=32&y=32&forceIcon=0 HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "server ip"
2017/12/17 03:42:07 [error] 1843#1843: *56 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Allowed memory size of 134217728 bytes exhausted (tried to allocate 8192 bytes) in /var/www/html/lib/private/legacy/image.php on line 886" while reading response header from upstream, client: my ip, server: _, request: "GET /core/preview.png?file={filename}.jpg&c=b292a532f1863c92789227651000fa61&x=32&y=32&forceIcon=0 HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "server ip"
2017/12/17 03:42:16 [error] 1843#1843: *35 FastCGI sent in stderr: "PHP message: 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/html/lib/private/DB/Connection.php:61

IP’s and filenames have been removed.

2

PHP tells you that it runs out of memory. 128MB is not that much, I don’t know if you can reduce the apps and functions of NC so much that it runs with 128MB. That’s probably also the reason it does not connect to the database.

3

Weird… When you say 128MB, are you referring to the total system memory? According to my control panel, I have 1024MB.

EDIT: So a php memory limit is a thing, my bad. Here’s the output of cat /etc/php.ini | grep "memory_limit": memory_limit = 128M. Is it safe to increase it? Should I need to increase it?

EDIT2: According to this, my 3840x5760 photos will use about 118 MB of ram… :upside_down_face:

4

I’m getting a ton of these in the https error log:

PHP message: 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/html/lib/private/DB/Connection.php:61
Stack trace:
#0 /var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(429): OC\DB\Connection->connect()
#1 /var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(389): Doctrine\DBAL\Connection->getDatabasePlatformVersion()
#2 /var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(328): Doctrine\DBAL\Connection->detectDatabasePlatform()
#3 /var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(623): Doctrine\DBAL\Connection->getDatabasePlatform()
#4 /var/www/html/lib/private/DB/Connection.php(148): Doctrine\DBAL\Connection->setTransactionIsolation(2)
#5 /var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DriverManager.php(172): OC\DB\Connection->__co

EDIT: Doing mysqladmin status gives me:

mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!

When I restart the mysqld server, it works fine, until I attempt to login in another tab and get a blank page

5

It’s the requirement for resizing, Nextcloud also manages the database entries, creates webinterface and some more things. You should probably use at least 256 or 512 MB. But it’s hard to tell, the less memory you have, the more careful you have to adjust the parameter of each service. And it depends how you use it.