/usr/share/otrs/bin/otrs.ImportACLsFromConfig.pl is in otrs2 3.3.5-1.
This file is owned by root:root, with mode 0o755.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 | #!/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->new();
$CommonObject{EncodeObject} = Kernel::System::Encode->new(%CommonObject);
$CommonObject{LogObject} = Kernel::System::Log->new(
LogPrefix => 'OTRS-otrs.ImportACLsFromConfig.pl',
%CommonObject,
);
$CommonObject{TimeObject} = Kernel::System::Time->new(%CommonObject);
$CommonObject{MainObject} = Kernel::System::Main->new(%CommonObject);
$CommonObject{DBObject} = Kernel::System::DB->new(%CommonObject);
$CommonObject{ACLObject} = Kernel::System::ACL::DB::ACL->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}->Prepare(
SQL => 'SELECT id FROM acl',
);
=cut
# fetch the result
my $RowCount = $CommonObject{DBObject}->FetchrowArray();
if ($RowCount) {
$CommonObject{LogObject}->Log(
Priority => 'error',
Message =>
'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}->{TicketAcl};
if ( !$ACLs || ref $ACLs ne 'HASH' ) {
$CommonObject{LogObject}->Log(
Priority => 'error',
Message => 'No ACLs found which could be imported. Import stopped.',
);
exit 1;
}
# get current time to add to ACL comments
my $TimeStamp = $CommonObject{TimeObject}->CurrentTimestamp();
ACL:
for my $ACLName ( sort keys %{$ACLs} ) {
# try adding the ACL
my $ACLID = $CommonObject{ACLObject}->ACLAdd(
Name => $ACLName,
Comment => 'Imported at ' . $TimeStamp,
StopAfterMatch => $ACLs->{$ACLName}->{StopAfterMatch},
ConfigMatch => {
Properties => $ACLs->{$ACLName}->{Properties} || {},
PropertiesDatabase => $ACLs->{$ACLName}->{PropertiesDatabase} || {},
},
ConfigChange => {
Possible => $ACLs->{$ACLName}->{Possible} || {},
PossibleNot => $ACLs->{$ACLName}->{PossibleNot} || {},
},
ValidID => 1,
UserID => 1,
);
# show error if can't create
if ( !$ACLID ) {
$CommonObject{LogObject}->Log(
Priority => 'error',
Message => "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;
|