Edit: /opt/cloudlinux/venv/bin/cpanel-dbmapping (3925B)
#!/bin/bash
# Copyright © Cloud Linux GmbH & Cloud Linux Software, Inc 2010-2018 All Rights Reserved
#
# Licensed under CLOUD LINUX LICENSE AGREEMENT
# http://cloudlinux.com/docs/LICENSE.TXT
eval 'if [ -x /usr/local/cpanel/3rdparty/bin/perl ]; then exec /usr/local/cpanel/3rdparty/bin/perl -x -- $0 ${1+"$@"}; else exec /usr/bin/perl -x $0 ${1+"$@"}; fi;'
if 0;
#!/usr/bin/perl
#BEGIN { unshift @INC, '/scripts'; }
BEGIN { unshift @INC, '/usr/local/cpanel', '/scripts'; }
my $pckg_name = 'Cpanel';
use strict;
use warnings;
eval "use " .$pckg_name . "::Config::Users ();";
if ($@){
$pckg_name = 'cPScript';
eval "use " .$pckg_name . "::Config::Users ();";
}
#eval "use " .$pckg_name . "::Config::Users ();";
eval "use " .$pckg_name . "::DB::Map ();";
eval "use " .$pckg_name . "::DB ();";
use Data::Dumper;
my @old = ();
my @new = ();
my @copy_new = ();
my $noSystemUsers = ($#ARGV >= 0 && $ARGV[0] eq "--nosys");
if ($noSystemUsers) {
shift @ARGV;
}
my $numArgs = $#ARGV + 1;
if($numArgs>0){
foreach my $mb (@ARGV) {
if($mb>0){
my $uname_1 = getpwuid($mb);
@new = get_map_list_user_($uname_1);
foreach my $item (@new){
my $fnd = 0;
foreach my $item2 (@old){
if (($$item[0] eq $$item2[0]) && ($$item[1] eq $$item2[1])){
$fnd = 1;
last;
}
}
if($fnd==0){
push @old, $item;
}
}
}
}
foreach my $item (@old){
print $$item[0], " ", $$item[1], " ", $$item[2], "\n";
}
} else {
@new = get_map_list_();
@copy_new = map { [@$_] } @new;
my @del_list = ();
my @del_list2 = ();
my $i=0;
my $j=0;
foreach my $item (@new){
$j=0;
my $del = 0;
foreach my $item2 (@old){
if (($$item[0] eq $$item2[0]) && ($$item[1] eq $$item2[1])){
push @del_list, $j;
$del = 1;
}
$j++;
}
if($del==1){
push @del_list2, $i;
}
$i++;
}
foreach my $item (@del_list){
delete $old[$item];
}
foreach my $item (@del_list2){
delete $new[$item];
}
@old = grep {$_} @old;
@new = grep {$_} @new;
my $cnt_old = @old;
my $cnt_new = @new;
if($cnt_old>0 || $cnt_new>0){
foreach my $item (@copy_new){
print $$item[0], " ", $$item[1], " ", $$item[2], "\n";
}
}
}
sub get_map_list_ {
my @arr = ();
my @users =Cpanel::Config::Users::getcpusers();
foreach my $user (@users) {
my $user_map1 = Cpanel::DB::get_map ( {'cpuser' => $user} );
my $name="";
my $uid= -1;
my $dummy;
($name, $dummy, $uid, $dummy, $dummy, $dummy, $dummy, $dummy, $dummy) = getpwnam($user);
if ($uid>=0 && !$noSystemUsers){
push @arr, [ $user, $user, "$uid" ];
}
if ($uid>=0 && exists($$user_map1{'stash'}{'MYSQL'}{'dbusers'})){
for my $key (keys %{$$user_map1{'stash'}{'MYSQL'}{'dbusers'}}) {
push @arr, [ $key, $user, "$uid" ];
}
}
}
return @arr;
}
sub get_map_list_user_ {
my @arr = ();
my $user = shift;
my $user_map1 = Cpanel::DB::get_map ( {'cpuser' => $user} );
my $name = "";
my $uid = -1;
my $dummy;
($name, $dummy, $uid, $dummy, $dummy, $dummy, $dummy, $dummy, $dummy) = getpwnam($user);
if ($uid>=0 && !$noSystemUsers){
push @arr, [ $user, $user, "$uid" ];
}
if ($uid>=0 && exists($$user_map1{'stash'}{'MYSQL'}{'dbusers'})){
for my $key (keys %{$$user_map1{'stash'}{'MYSQL'}{'dbusers'}}) {
push @arr, [ $key, $user, "$uid" ];
}
}
return @arr;
}