backup: list shows backup unhealthy and missing while we store remotely on DO Spaces

[jasperf]

We have just set up this amazing package on a new Ploi provisioned Hetzner server. We keep Digital Ocean Spaces for now for storage of our backups. We just ran another round of backups last night and they seem to run well.

But we do a check we get the indication there are issues

php artisan backup:list
+---------+-------+-----------+---------+--------------+--------------------+--------------+
| Name    | Disk  | Reachable | Healthy | # of backups | Newest backup      | Used storage |
+---------+-------+-----------+---------+--------------+--------------------+--------------+
| Smart48 | local | ✅        | ❌      |            0 | No backups present |         0 KB |
+---------+-------+-----------+---------+--------------+--------------------+--------------+

Unhealthy backup destinations
-----------------------------
+---------+-------+------------------+--------------------------------------------------+
| Name    | Disk  | Failed check     | Description                                      |
+---------+-------+------------------+--------------------------------------------------+
| Smart48 | local | Maximumageindays | There are no backups of this application at all. |
+---------+-------+------------------+--------------------------------------------------+

I think this is a configuration issue on our side. Perhaps the wrong disk is checked or something. Any pointers on how to make this health check work better?

[jasperf]

Hmm do see cleanup fails

Illuminate\Database\QueryExceptionartisan clean:backup
SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user 'backup'@'localhost' 
for table 'projects' (SQL: select backup.projects.* from `projects` left join `forge`.`projects` 
on `forge`.`projects`.`id` = `backup`.`projects`.`project_id` where `forge`.`projects`.`id` is null limit 100)

and

Illuminate\Database\QueryExceptionartisan clean:backup
SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to 
user 'backup'@'10.0.0.3' for table 'projects' (SQL: select backup.projects.* from `projects` left join `forge`.`projects` 
on `forge`.`projects`.`id` = `backup`.`projects`.`project_id` where `forge`.`projects`.`id` is null limit 100)

Seems the host is not accepted by database server as we use 127.0.0.1 and 10.0.0.3 . Strangely enough our .env has internal ip address only for access so not localhost.

...
DB_CONNECTION=mysql
DB_HOST=10.0.0.2
DB_PORT=3306
DB_DATABASE=forge
DB_USERNAME=forge
...
DB_BACKUP_HOST=10.0.0.2
DB_BACKUP_DATABASE=backup
DB_BACKUP_USERNAME=backup
...

[jasperf]

Used Sequel Ace to add user [email protected] to database schema forge for privileges. So would think it can work now. Did not add backup to host localhost. Assume it only tried localhost because internal ip address failed as backup was not added for that internal ip address to the forge database.

[jasperf]

post addition of [email protected] to database forge I did another cleanup test that passed:

php artisan backup:clean
Starting cleanup...
Cleaning backups of App on disk do_backup...
Used storage after cleanup: 460.33 MB.
Cleanup completed!

and email with

The clean up of the App (production) backups on the disk named do_backup was successful.

Application name: App (production)
Backup name: App
Disk: do_backup
Newest backup size: 157.51 MB
Number of backups: 3
Total storage used: 460.33 MB
Newest backup date: 2023/04/09 02:01:29
Oldest backup date: 2023/04/08 02:01:29
...

But still seeing unreachable and no backups.

php artisan backup:list
+---------+-------+-----------+---------+--------------+--------------------+--------------+
| Name    | Disk  | Reachable | Healthy | # of backups | Newest backup      | Used storage |
+---------+-------+-----------+---------+--------------+--------------------+--------------+
| App | local | ✅        | ❌      |            0 | No backups present |         0 KB |
+---------+-------+-----------+---------+--------------+--------------------+--------------+

Unhealthy backup destinations
-----------------------------
+---------+-------+------------------+--------------------------------------------------+
| Name    | Disk  | Failed check     | Description                                      |
+---------+-------+------------------+--------------------------------------------------+
| App | local | Maximumageindays | There are no backups of this application at all. |
+---------+-------+------------------+--------------------------------------------------+

I think I need to change the disk from local to do_backup somehow..

[jasperf]

Think we need to update this backup.php part:

...
 'monitor_backups' => [
    [
        'name' => env('APP_NAME', 'laravel-backup'),
        'disks' => ['local'],
        'health_checks' => [
            \Spatie\Backup\Tasks\Monitor\HealthChecks\MaximumAgeInDays::class => 1,
            \Spatie\Backup\Tasks\Monitor\HealthChecks\MaximumStorageInMegabytes::class => 5000,
        ],
    ],

    /*
    [
        'name' => 'name of the second app',
        'disks' => ['local', 's3'],
        'health_checks' => [
            \Spatie\Backup\Tasks\Monitor\HealthChecks\MaximumAgeInDays::class => 1,
            \Spatie\Backup\Tasks\Monitor\HealthChecks\MaximumStorageInMegabytes::class => 5000,
        ],
    ],
    */
...