I can't get the database to connect and have cache errors at the same time.

[richard378]

I get a 419 page expired when trying to create the first user:

I get the following in ff3-apache2handler
[2025-01-18 00:13:43] production.ERROR: Exception is: {"class":"FireflyIII\\Exceptions\\FireflyException","errorMessage":"Could not poll the database: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo for db failed: Temporary failure in name resolution (Connection: mysql, SQL: select id, name, datafromconfigurationwherename= is_demo_site andconfiguration.deleted_atis null limit 1)","time":"Sat, 18 Jan 2025 00:13:43 -0500","file":"\/srv\/www\/firefly-iii\/app\/Support\/FireflyConfig.php","line":65,"code":0,"version":"6.1.24","url":"https:\/\/firefly-iii.webhoran.com","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:134.0) Gecko\/20100101 Firefox\/134.0","json":true,"method":"GET","post":""} [2025-01-18 00:13:43] production.ERROR: Exception is: {"class":"ErrorException","errorMessage":"file_put_contents(\/srv\/www\/firefly-iii\/storage\/framework\/cache\/error-count.json): Failed to open stream: Permission denied","time":"Sat, 18 Jan 2025 00:13:43 -0500","file":"\/srv\/www\/firefly-iii\/app\/Jobs\/MailError.php","line":161,"code":0,"version":"6.1.24","url":"https:\/\/firefly-iii.webhoran.com","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:134.0) Gecko\/20100101 Firefox\/134.0","json":true,"method":"GET","post":""} [2025-01-18 00:13:43] production.ERROR: Exception is: {"class":"ErrorException","errorMessage":"file_put_contents(\/srv\/www\/firefly-iii\/storage\/framework\/cache\/error-count.json): Failed to open stream: Permission denied","time":"Sat, 18 Jan 2025 00:13:43 -0500","file":"\/srv\/www\/firefly-iii\/app\/Jobs\/MailError.php","line":161,"code":0,"version":"6.1.24","url":"https:\/\/firefly-iii.webhoran.com","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:134.0) Gecko\/20100101 Firefox\/134.0","json":true,"method":"GET","post":""} [2025-01-18 00:13:43] production.ERROR: Exception is: {"class":"ErrorException","errorMessage":"file_put_contents(\/srv\/www\/firefly-iii\/storage\/framework\/cache\/error-count.json): Failed to open stream: Permission denied","time":"Sat, 18 Jan 2025 00:13:43 -0500","file":"\/srv\/www\/firefly-iii\/app\/Jobs\/MailError.php","line":161,"code":0,"version":"6.1.24","url":"https:\/\/firefly-iii.webhoran.com","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:134.0) Gecko\/20100101 Firefox\/134.0","json":true,"method":"GET","post":""} [2025-01-18 00:13:43] production.ERROR: Exception is: {"class":"ErrorException","errorMessage":"file_put_contents(\/srv\/www\/firefly-iii\/storage\/framework\/cache\/error-count.json): Failed to open stream: Permission denied","time":"Sat, 18 Jan 2025 00:13:43 -0500","file":"\/srv\/www\/firefly-iii\/app\/Jobs\/MailError.php","line":161,"code":0,"version":"6.1.24","url":"https:\/\/firefly-iii.webhoran.com","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:134.0) Gecko\/20100101 Firefox\/134.0","json":true,"method":"GET","post":""} [2025-01-18 00:13:43] production.ERROR: Exception is: {"class":"ErrorException","errorMessage":"file_put_contents(\/srv\/www\/firefly-iii\/storage\/framework\/cache\/error-count.json): Failed to open stream: Permission denied","time":"Sat, 18 Jan 2025 00:13:43 -0500","file":"\/srv\/www\/firefly-iii\/app\/Jobs\/MailError.php","line":161,"code":0,"version":"6.1.24","url":"https:\/\/firefly-iii.webhoran.com","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:134.0) Gecko\/20100101 Firefox\/134.0","json":true,"method":"GET","post":""} [2025-01-18 00:13:43] production.ERROR: Exception is: {"class":"ErrorException","errorMessage":"file_put_contents(\/srv\/www\/firefly-iii\/storage\/framework\/cache\/error-count.json): Failed to open stream: Permission denied","time":"Sat, 18 Jan 2025 00:13:43 -0500","file":"\/srv\/www\/firefly-iii\/app\/Jobs\/MailError.php","line":161,"code":0,"version":"6.1.24","url":"https:\/\/firefly-iii.webhoran.com","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:134.0) Gecko\/20100101 Firefox\/134.0","json":true,"method":"GET","post":""} [2025-01-18 00:13:43] production.ERROR: Exception is: {"class":"ErrorException","errorMessage":"file_put_contents(\/srv\/www\/firefly-iii\/storage\/framework\/cache\/error-count.json): Failed to open stream: Permission denied","time":"Sat, 18 Jan 2025 00:13:43 -0500","file":"\/srv\/www\/firefly-iii\/app\/Jobs\/MailError.php","line":161,"code":0,"version":"6.1.24","url":"https:\/\/firefly-iii.webhoran.com","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:134.0) Gecko\/20100101 Firefox\/134.0","json":true,"method":"GET","post":""} [2025-01-18 00:13:43] production.ERROR: Exception is: {"class":"ErrorException","errorMessage":"file_put_contents(\/srv\/www\/firefly-iii\/storage\/framework\/cache\/error-count.json): Failed to open stream: Permission denied","time":"Sat, 18 Jan 2025 00:13:43 -0500","file":"\/srv\/www\/firefly-iii\/app\/Jobs\/MailError.php","line":161,"code":0,"version":"6.1.24","url":"https:\/\/firefly-iii.webhoran.com","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:134.0) Gecko\/20100101 Firefox\/134.0","json":true,"method":"GET","post":""} [2025-01-18 00:13:43] production.ERROR: Exception is: {"class":"ErrorException","errorMessage":"file_put_contents(\/srv\/www\/firefly-iii\/storage\/framework\/cache\/error-count.json): Failed to open stream: Permission denied","time":"Sat, 18 Jan 2025 00:13:43 -0500","file":"\/srv\/www\/firefly-iii\/app\/Jobs\/MailError.php","line":161,"code":0,"version":"6.1.24","url":"https:\/\/firefly-iii.webhoran.com","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:134.0) Gecko\/20100101 Firefox\/134.0","json":true,"method":"GET","post":""} [2025-01-18 00:15:30] production.ERROR: Exception is: {"class":"FireflyIII\\Exceptions\\FireflyException","errorMessage":"Could not poll the database: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo for db failed: Temporary failure in name resolution (Connection: mysql, SQL: selectid, name, datafromconfigurationwherename= is_demo_site andconfiguration.deleted_atis null limit 1)","time":"Sat, 18 Jan 2025 00:15:30 -0500","file":"\/srv\/www\/firefly-iii\/app\/Support\/FireflyConfig.php","line":65,"code":0,"version":"6.1.24","url":"https:\/\/firefly-iii.webhoran.com","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:134.0) Gecko\/20100101 Firefox\/134.0","json":true,"method":"GET","post":""} [2025-01-18 00:15:30] production.ERROR: Could not poll the database: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo for db failed: Temporary failure in name resolution (Connection: mysql, SQL: selectid, name, datafromconfigurationwherename= is_demo_site andconfiguration.deleted_atis null limit 1) {"exception":"[object] (FireflyIII\\Exceptions\\FireflyException(code: 0): Could not poll the database: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo for db failed: Temporary failure in name resolution (Connection: mysql, SQL: selectid, name, datafromconfigurationwherename= is_demo_site andconfiguration.deleted_atis null limit 1) at /srv/www/firefly-iii/app/Support/FireflyConfig.php:65) [stacktrace]

And this is the ff3-cli log
[2025-01-18 00:05:04] production.ERROR: Exception is: {"class":"Illuminate\\Database\\QueryException","errorMessage":"SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo for db failed: Temporary failure in name resolution (Connection: mysql, SQL: select exists (select 1 from information_schema.tables where table_schema = 'firefly' and table_name = 'migrations' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as exists)","time":"Sat, 18 Jan 2025 00:05:04 -0500","file":"\/srv\/www\/firefly-iii\/vendor\/laravel\/framework\/src\/Illuminate\/Database\/Connection.php","line":825,"code":2002,"version":"6.1.24","url":"https:\/\/firefly-iii.webhoran.com","userAgent":"Symfony","json":true,"method":"GET","post":""} [2025-01-18 00:05:04] production.ERROR: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo for db failed: Temporary failure in name resolution (Connection: mysql, SQL: select exists (select 1 from information_schema.tables where table_schema = 'firefly' and table_name = 'migrations' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as exists) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 2002): SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo for db failed: Temporary failure in name resolution (Connection: mysql, SQL: select exists (select 1 from information_schema.tables where table_schema = 'firefly' and table_name = 'migrations' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as exists) at /srv/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Connection.php:825)
I have tried deleting are recreating the database which does not help.

My database config:
DB_CONNECTION=mysql DB_HOST=localhost DB_PORT=3306 DB_DATABASE=firefly DB_USERNAME=firefly

It is a MariaDB

How do I fix this?

[richard378]

I found the problem was this: https://github.com/orgs/firefly-iii/discussions/4699#discussioncomment-703562

I removed the memcached lines. And then it worked.

[JC5]

Nice, thanks for explaining!