500 Error on Nginx

AakLak

Hi all, had my flarum working fine, but getting a 500 error all of a sudden.
Here's my Nginx log, hope this helps.

1045] Access denied for user 'root'@'localhost' (using password: YES) in /var/www/html/vendor/illuminate/database/Connectors/Connector.php:55
Stack trace:
#0 /var/www/html/vendor/illuminate/database/Connectors/Connector.php(55): PDO->__construct('mysql:host=loca...', 'root', '[2aW5Y%?EDf6d(N...', Array)
#1 /var/www/html/vendor/illuminate/database/Connectors/MySqlConnector.php(22): Illuminate\Database\Connectors\Connector->createConnection('mysql:host=loca...', Array, Array)
#2 /var/www/html/vendor/illuminate/database/Connectors/ConnectionFactory.php(60): Illuminate\Database\Connectors\MySqlConnector->connect(Array)
#3 /var/www/html/vendor/illuminate/database/Connectors/ConnectionFactory.php(49): Illuminate\Database\Connectors\ConnectionFactory->createSingleConnection(Array)
#4 /var/www/html/vendor/flarum/core/src/Database/DatabaseServiceProvider.php(30): Illuminate\Database\Connectors\ConnectionFactory->make(Array)
#5 /var/www/html/ven" while reading response header from upstream, client: 98.252.91.19, server: 104.238.181.129, request: "GET / HTTP/1.1", upstream: "fastcgi://unix:/var/run/php-fpm/php-fpm.sock:", host: "104.238.181.29"

I gave ownership of /var/www/html to nginx user to solve another issue, which may have caused this.

chown -R nginx:nginx /var/www/html/

Here's my permissions for /var/ww/html

[root@rsbotspot ~]# ls -l /var/www/html/
total 232
-rwxrwxrwx  1 root nginx    319 May 24 03:10 admin.php
-rwxrwxrwx  1 root nginx    317 May 24 03:10 api.php
drwxrwxrwx  4 root nginx   4096 Sep 12 08:58 assets
-rwxrwxrwx  1 root nginx   1708 May 24 03:10 composer.json
-rwxrwxrwx  1 root nginx 161816 Sep 11 11:46 composer.lock
-rwxrwxrwx  1 root nginx    471 Sep 12 06:09 config.php
-rwxrwxrwx  1 root nginx   4958 May 24 03:10 CONTRIBUTING.md
-rwxrwxrwx  1 root nginx    381 May 24 03:10 flarum
-rwxrwxrwx  1 root nginx    319 May 24 03:10 index.php
-rwxrwxrwx  1 root nginx   1083 May 24 03:10 LICENSE
-rwxrwxrwx  1 root nginx    104 May 24 03:10 Procfile
-rwxrwxrwx  1 root nginx   1480 May 24 03:10 readme.md
drwxrwxrwx  2 root nginx   4096 May 24 03:10 scripts
drwxrwxrwx  8 root nginx   4096 May 24 03:10 storage
-rwxrwxrwx  1 root nginx  11320 May 24 03:10 Vagrantfile
drwxrwxrwx 31 root nginx   4096 Sep 11 11:46 vendor

Thanks

Ralkage

Are your database credentials correct? Consider using or creating another user other than root. Check your flarum config file to see if the database connection parameters are correct.

luceos

Instead of localhost for your db host try 127.0.0.1 instead.

AakLak

@Ralkage @luceos Thanks for reply.
To add more detail: I had flarum installed and working and, to my knowledge, have not changed any database credentials since then. Wierd.

Where can I find the flarum config file? (looking this up now)

luceos

AakLak the config is in the installation path of flarum, called config.php. The server might have been updated, a recent update to mysql/mariadb made localhost invalid.

AakLak

@luceos Interesting, thanks.
I changed config to 127.0.0.1
'database' => array ( 'driver' => 'mysql', 'host' => '127.0.0.1',
Restarted nginx
sudo systemctl restart nginx

Still seeing localhost in the error though hmm...
2017/09/13 08:02:18 [error] 23189#0: *1 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES) in /var/www/html/vendor/illuminate/database/Connectors/Connector.php:55

luceos

AakLak seems like your root user has no access to the database with the password provided. See if you can log in using sudo mysql -uroot and setting a pass or perhaps you can use an empty password "" in your configuration.

AakLak

luceos
Able to get in just fine, I've got a PW set.

Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 749
Server version: 5.5.52-MariaDB MariaDB Server

In my config.php should the 'password' be my server PW or database PW?
It's currently set as my server PW, and was working fine this way before hmm.

'database' =>
  array (
    'driver' => 'mysql',
    'host' => '127.0.0.1',
    'database' => 'flarum',
    'username' => 'root',
    'password' => 'REMOVED',
    'charset' => 'utf8mb4',
    'collation' => 'utf8mb4_unicode_ci',
    'prefix' => 'testtest',
    'port' => '1111',
    'strict' => false,
  ),

Edit:
I changed the password in config.php from my root server PW to my database PW (duh...)
Not sure why it was set this way, or how it was working previously, as I don't remember changing it.

Thanks for your help everyone!