Unable to open SysConfig

Moderator: crythias

Locked
GraphicsWrench
Znuny newbie
Posts: 4
Joined: 07 Jul 2014, 20:20
Znuny Version: 3.2.1

Unable to open SysConfig

Post by GraphicsWrench »

We run OTRS 3.2.1 and I'm trying to open SysConfig in the Admin section but receive the following error:

Code: Select all

Error Message: Can't open file /opt/otrs/Kernel/Config/Files/ZZZAAuto.pm.17190!

Error Details
Backend ERROR: OTRS-CGI-10 Perl: 5.10.1 OS: linux Time: Tue Jul 8 15:45:12 2014 Message: Can't open file /opt/otrs/Kernel/Config/Files/ZZZAAuto.pm.17190! RemoteAddress: 172.20.194.154 RequestURI: /otrs/index.pl?Action=AdminSysConfig Traceback (17190): Module: Kernel::System::SysConfig::_FileWriteAtomic (v1.44) Line: 1879 Module: Kernel::System::SysConfig::WriteDefault (v1.44) Line: 193 Module: Kernel::Modules::AdminSysConfig::Run (v1.125) Line: 50 Module: Kernel::System::Web::InterfaceAgent::Run (v1.73) Line: 866 Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 46 Module: (eval) (v1.94) Line: 204 Module: ModPerl::RegistryCooker::run (v1.94) Line: 204 Module: ModPerl::RegistryCooker::default_handler (v1.94) Line: 170 Module: ModPerl::Registry::handler (v1.99) Line: 31
When I first ran into this issue, I checked the file permissions for ZZZAAuto.pm and for some reason it was set to 664 root/root. So I changed permissions to match all my other OTRS files (otrs/www-data) and restarted OTRS yet I still get the error. Any ideas?
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Unable to open SysConfig

Post by crythias »

/opt/otrs/Kernel/Config/Files/ZZZAAuto.pm.17190
.17190

may I suggest you move/remove that file?
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Unable to open SysConfig

Post by jojo »

the webserver does not have write permission on the file.

you should:
- update your outdated version to latest 3.2.x or upgrade to 3.3.8
- run the otrs.SetPermissions.pl script with all needed parameters to set all file values
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
GraphicsWrench
Znuny newbie
Posts: 4
Joined: 07 Jul 2014, 20:20
Znuny Version: 3.2.1

Re: Unable to open SysConfig

Post by GraphicsWrench »

It doesn't actually exist on the server. The number appended to the end of the file name will randomly change. An ls -al of my /opt/otrs/Kernel/Config/Files folder yields this:

Code: Select all

drwxr-xr-x 2 otrs www-data 4.0K 2014-06-27 15:27 .
drwxr-xr-x 3 otrs www-data 4.0K 2014-06-27 15:19 ..
-rw-r--r-- 1 otrs www-data 283K 2013-01-03 03:12 Framework.xml
-rw-r--r-- 1 otrs www-data  22K 2012-10-11 02:10 GenericInterface.xml
-rw-r--r-- 1 otrs www-data  15K 2013-01-17 03:06 ProcessManagement.xml
-rw-r--r-- 1 otrs www-data 4.4K 2013-01-17 03:06 Scheduler.xml
-rw-r--r-- 1 otrs www-data 439K 2013-01-24 04:21 Ticket.xml
-rw-rw-r-- 1 otrs www-data 150K 2013-02-15 23:11 ZZZAAuto.pm
-rw-rw-r-- 1 otrs www-data 8.7K 2013-02-15 23:04 ZZZAuto.pm
GraphicsWrench
Znuny newbie
Posts: 4
Joined: 07 Jul 2014, 20:20
Znuny Version: 3.2.1

Re: Unable to open SysConfig

Post by GraphicsWrench »

jojo wrote:the webserver does not have write permission on the file.

you should:
- update your outdated version to latest 3.2.x or upgrade to 3.3.8
- run the otrs.SetPermissions.pl script with all needed parameters to set all file values
Oh trust me, I've been pushing for us to upgrade to the most recent version for awhile now -_- I'll give the SetPermissions script a try after hours this evening.
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Unable to open SysConfig

Post by crythias »

The number appended to the end of the file name will randomly change

drwxr-xr-x 2 otrs www-data 4.0K 2014-06-27 15:27 .
drwxr-xr-x 3 otrs www-data 4.0K 2014-06-27 15:19 ..

www-data does not have write access
www-data is the apache runas user.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
GraphicsWrench
Znuny newbie
Posts: 4
Joined: 07 Jul 2014, 20:20
Znuny Version: 3.2.1

Re: Unable to open SysConfig

Post by GraphicsWrench »

jojo wrote:the webserver does not have write permission on the file.

you should:
- update your outdated version to latest 3.2.x or upgrade to 3.3.8
- run the otrs.SetPermissions.pl script with all needed parameters to set all file values
As recommended, I ran the otrs.SetPermissions.pl script last night but it set the permissions exactly the same as they were before:

Code: Select all

./otrs.SetPermissions.pl --otrs-user=otrs --web-user=www-data --otrs-group=www-data --web-group=www-data /opt/otrs
bin/otrs.SetPermissions.pl <1.10> - set OTRS file permissions
Copyright (C) 2001-2013 xxx, http://otrs.org/
Setting permissions on /opt/otrs
Setting permissions on /opt/otrs/var
Setting permissions on /opt/otrs/bin/*
Setting permissions on /opt/otrs/scripts/*.pl
Setting permissions on /opt/otrs/scripts/tools/*.pl
Setting permissions on Kernel/Config.pm
Setting owner rw and group ro permissions on /opt/otrs/
Setting owner rw and group ro permissions on /opt/otrs/.procmailrc

drwxr-xr-x 2 otrs www-data 4.0K 2014-06-27 15:27 .
drwxr-xr-x 3 otrs www-data 4.0K 2014-06-27 15:19 ..
-rw-r--r-- 1 otrs www-data 283K 2013-01-03 03:12 Framework.xml
-rw-r--r-- 1 otrs www-data  22K 2012-10-11 02:10 GenericInterface.xml
-rw-r--r-- 1 otrs www-data  15K 2013-01-17 03:06 ProcessManagement.xml
-rw-r--r-- 1 otrs www-data 4.4K 2013-01-17 03:06 Scheduler.xml
-rw-r--r-- 1 otrs www-data 439K 2013-01-24 04:21 Ticket.xml
-rw-rw-r-- 1 otrs www-data 150K 2013-02-15 23:11 ZZZAAuto.pm
-rw-rw-r-- 1 otrs www-data 8.7K 2013-02-15 23:04 ZZZAuto.pm
Since the script didn't provide www-data with write permissions, I'm assuming I'll need to manually go through and chmod any directories as needed?
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Unable to open SysConfig

Post by crythias »

Jojo's correct, though. You're on 3.2.1, which is the buggiest release of 3.2
Update to 3.2.latest for security and bugfixes, including a year's worth of updates to otrs.SetPermissions.pl
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Locked