Removing double backup messages

We in the current (bacula) system have often times many tickets being made when backups fail. There is a script to remove these with a specific message.

When asked to this follow these steps :

1. ssh as care to cron01:

   ssh care@cron01.care.true.nl

2. Use vi to edit the file:

   vi current/src/Tickets/Ports/Console/BulkHandleFailedBackupTickets.php

In this file you edit the date and time for the tickets to be removed. By changing the time in the GreaterThanFilter.

private function backupTicketsToResolve()
{
    $filters = [
        new EqualFilter('Ticket.department', 'bbd5abfe-f2a2-49f7-8e96-3a2041169756'),
        new EqualFilter('Ticket.status.name', 'Open'),
        new EqualFilter('Ticket.reporter', 'nltru0055'),
        new EqualFilter('Ticket.type', 'RFIR'),
        new GreaterThanFilter('Ticket.createdAt', '2022-05-02 00:10:00'),
        new FreetextFilter('Failed Managed Backup for', ['Ticket.subject']),
    ];
    $selection = CollectionSelection::withFilters(Criteria::create(), $filters);

    return $this->ticketRepository->selection($selection);

if and when needed you can also change the message that needs to be put as an answer to closing the tickets. By changing the value in $content in the handleTicket function.

$content = 'This is an automated message from True.
There was a temporary issue on a backup-server which
prevented the backups from being made.
This is resolved, we expect the next backups
will run as normal.';

This comment on the answer will be supplied by the person asking you to close the tickets.

After making these changes all you have to do is execute the process:

php current/bin/tickets.php tickets:bulkFailedBackups

Changing Domain from inactive to active

Quite often a Domain will be marked as inactive when it should be active, or this request might come from administration for whatever reason. To solve the problem we have two actions that are required.

These databases are found in the Percona-Cluster

1. In the Ascio database remove deleted status:

   select * from domains where domain = '<domain name>';

2. In the Domains database search the domain and change Deleted to Active:

   select * from domains where domain = '<domain name>';

Same query, different databases !

Make Let's Encrypt available for customer ..

LE is still in beta right now so it needs to be turned on manualy

1. SSH to ssl@publicweb01.care.true.nl
2. Go to the env file ssl.env
3. Search for the env variable LETSENCRYPT_BETA= and add the customer id

with the 0.