<html><head><meta name="color-scheme" content="light dark"></head><body><pre style="word-wrap: break-word; white-space: pre-wrap;">#!/usr/bin/perl
# --
# bin/otrs.ImportACLsFromConfig.pl - import existing ACLs from Config.pm to database
# Copyright (C) 2001-2014 OTRS AG, http://otrs.com/
# --
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU AFFERO General Public License as published by
# the Free Software Foundation; either version 3 of the License, or
# any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU Affero General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301 USA
# or see http://www.gnu.org/licenses/agpl.txt.
# --

use strict;
use warnings;
use utf8;

use File::Basename;
use FindBin qw($RealBin);

use lib dirname($RealBin);
use lib dirname($RealBin) . '/Kernel/cpan-lib';
use lib dirname($RealBin) . '/Custom';

use Kernel::Config;
use Kernel::System::DB;
use Kernel::System::Encode;
use Kernel::System::Log;
use Kernel::System::Main;
use Kernel::System::Time;
use Kernel::System::ACL::DB::ACL;

my %CommonObject;
$CommonObject{ConfigObject} = Kernel::Config-&gt;new();
$CommonObject{EncodeObject} = Kernel::System::Encode-&gt;new(%CommonObject);
$CommonObject{LogObject}    = Kernel::System::Log-&gt;new(
    LogPrefix =&gt; 'OTRS-otrs.ImportACLsFromConfig.pl',
    %CommonObject,
);
$CommonObject{TimeObject} = Kernel::System::Time-&gt;new(%CommonObject);
$CommonObject{MainObject} = Kernel::System::Main-&gt;new(%CommonObject);
$CommonObject{DBObject}   = Kernel::System::DB-&gt;new(%CommonObject);
$CommonObject{ACLObject}  = Kernel::System::ACL::DB::ACL-&gt;new(%CommonObject);

# check if there are already entries in the database
# in this case, the import can't be done.
exit 1 if !$CommonObject{DBObject}-&gt;Prepare(
    SQL =&gt; 'SELECT id FROM acl',
);

=cut
# fetch the result
my $RowCount = $CommonObject{DBObject}-&gt;FetchrowArray();
if ($RowCount) {
    $CommonObject{LogObject}-&gt;Log(
        Priority =&gt; 'error',
        Message =&gt;
            'Existing database entries found! Import stopped. Database has to be clean in order to be able to import ACLs from config.',
    );
    exit 1;
}
=cut

# check if there are any ACLs to import
my $ACLs = $CommonObject{ConfigObject}-&gt;{TicketAcl};
if ( !$ACLs || ref $ACLs ne 'HASH' ) {

    $CommonObject{LogObject}-&gt;Log(
        Priority =&gt; 'error',
        Message  =&gt; 'No ACLs found which could be imported. Import stopped.',
    );
    exit 1;

}

# get current time to add to ACL comments
my $TimeStamp = $CommonObject{TimeObject}-&gt;CurrentTimestamp();

ACL:
for my $ACLName ( sort keys %{$ACLs} ) {

    # try adding the ACL
    my $ACLID = $CommonObject{ACLObject}-&gt;ACLAdd(
        Name           =&gt; $ACLName,
        Comment        =&gt; 'Imported at ' . $TimeStamp,
        StopAfterMatch =&gt; $ACLs-&gt;{$ACLName}-&gt;{StopAfterMatch},
        ConfigMatch    =&gt; {
            Properties         =&gt; $ACLs-&gt;{$ACLName}-&gt;{Properties}         || {},
            PropertiesDatabase =&gt; $ACLs-&gt;{$ACLName}-&gt;{PropertiesDatabase} || {},
        },
        ConfigChange =&gt; {
            Possible    =&gt; $ACLs-&gt;{$ACLName}-&gt;{Possible}    || {},
            PossibleNot =&gt; $ACLs-&gt;{$ACLName}-&gt;{PossibleNot} || {},
        },
        ValidID =&gt; 1,
        UserID  =&gt; 1,
    );

    # show error if can't create
    if ( !$ACLID ) {
        $CommonObject{LogObject}-&gt;Log(
            Priority =&gt; 'error',
            Message  =&gt; "There was an error creating the ACL",
        );
        next ACL;
    }
}

print "###############################################################\n";
print " IMPORT COMPLETED!\n";
print "###############################################################\n";
print " Please check the log for any errors.\n\n\n";
print " Important: Please delete the ACLs from any config files now in\n";
print " order to avoid any collisions with entries from the database.\n";
print "###############################################################\n";

exit 0;
</pre></body></html>