Database only backups not encrypted

[aronvdl]

Hi, When I run a complete backup through spatie, the zip-file is encrypted, like I configured. But when I make a Database only backup, the zip-file is not encrypted.. Is there an aditional setting needed?
Kind regards, Aron
btw I love your product!

[PaolaRuby]

You have to give all the information, the authors cannot guess or use psychic powers to know which package version you use, php version, etc, it's the only way someone can give you an answer

it is verified that the package does encrypt when it is used --only-db

laravel-backup/tests/Commands/BackupCommandTest.php

Lines 380 to 395 in 4fe55e6

	public function it_will_encrypt_backup_when_notifications_are_disabled()
	{
	config()->set('backup.backup.password', '24dsjF6BPjWgUfTu');
	config()->set('backup.backup.source.databases', ['db1']);
	$this->artisan('backup:run --disable-notifications --only-db --db-name=db1 --only-to-disk=local')->assertExitCode(0);
	Storage::disk('local')->assertExists($this->expectedZipPath);
	$zip = new ZipArchive();
	$zip->open(Storage::disk('local')->path($this->expectedZipPath));
	$this->assertSame(1, $zip->numFiles);
	$this->assertSame(ZipArchive::EM_AES_256, $zip->statIndex(0)['encryption_method']);
	$zip->close();
	Event::assertNotDispatched(BackupZipWasCreated::class);
	}

[PaolaRuby]

spatie/laravel-backup 6.16.5 has the test too, that means it is working correctly

laravel-backup/tests/Commands/BackupCommandTest.php

Lines 376 to 391 in e732447

	public function it_will_encrypt_backup_when_notifications_are_disabled()
	{
	config()->set('backup.backup.password', '24dsjF6BPjWgUfTu');
	config()->set('backup.backup.source.databases', ['db1']);
	$this->artisan('backup:run --disable-notifications --only-db --db-name=db1 --only-to-disk=local')->assertExitCode(0);
	Storage::disk('local')->assertExists($this->expectedZipPath);
	$zip = new ZipArchive();
	$zip->open(Storage::disk('local')->path($this->expectedZipPath));
	$this->assertSame(1, $zip->numFiles);
	$this->assertSame(ZipArchive::EM_AES_256, $zip->statIndex(0)['encryption_method']);
	$zip->close();
	Event::assertNotDispatched(BackupZipWasCreated::class);
	}

[PaolaRuby]

@aronvdl I am using cron job and it works correctly, maybe try Laravel Task Scheduling

[aronvdl]

Yeah!! That worked! Thanks a lot!

[aronvdl]

Hello Paola, You are right! Here some information:
Laravel v8.65
PHP 7.4.20
spatie/db-dumper 2.21.1 Dump databases
spatie/laravel-backup 6.16.5 A Laravel package to backup your application
spatie/temporary-directory 1.3.0 Easily create, use and destroy temporary directories
Ubuntu 18.04

[aronvdl]

Ok, I found out when the problem with none encrypted files occurs. When I backup trough a shell command, the files are created, stored and encrypted as they should. When the command is executed as a cron-job, the zip-files are created, stored, but NOT encrypted.

Any idea what could cause that?

The cron job command is:
cd /var/www/vhosts/xxx.nl/httpdocs && /opt/plesk/php/7.4/bin/php 'artisan' backup:run

(with xxx.nl as my domain)