Cannot install ITSM on windows mssql environment

Moderator: crythias

Locked
otrsgsy
Znuny newbie
Posts: 16
Joined: 17 Aug 2012, 12:50
Znuny Version: 3.1.8
Real Name: Dan

Cannot install ITSM on windows mssql environment

Post by otrsgsy »

I have been working with OTRS for some time and have been using the Windows installer (MySQL) without issue, however my boss would like me to get it to run with MS SQL but I am having a few issues.

OTRS has been successfully installed on a Window 2008 R2 Server (using the guide below) and is connected up to a separate MS SQL server. New tickets can be created without issue.

http://wiki.otterhub.org/index.php?titl ... _and_IIS_7

The system appears to work fine until I attempt to install the ITSMCore package, where I keep getting the following warning when accessing the package manager:

ITSMCore 3.1.5 - Package not correctly deployed! Please reinstall the package.

Various.pm files are reported as being different.

I have checked the log file and have the following:
-----------------------
ERROR: OTRS-CGI-10 Perl: 5.14.2 OS: MSWin32 Time: Fri Aug 17 11:43:29 2012

Message: Can't remove file c:/otrs/var/tmp/CacheFileStorable/DynamicField/20aa1d07d0cc84b17bd7ad64056623ea: Permission denied

Traceback (4040):
Module: Kernel::System::Cache::FileStorable::CleanUp (v1.9) Line: 220
Module: Kernel::System::Cache::CleanUp (v1.21) Line: 234
Module: Kernel::System::Package::PackageInstall (v1.130.2.1) Line: 511
Module: Kernel::Modules::AdminPackageManager::_InstallHandling (v1.108) Line: 1483
Module: Kernel::Modules::AdminPackageManager::Run (v1.108) Line: 1050
Module: Kernel::System::Web::InterfaceAgent::Run (v1.64) Line: 868
Module: c:\otrs\bin\cgi-bin\index.pl (v1.90) Line: 46

-----------------------
ERROR: OTRS-CGI-10 Perl: 5.14.2 OS: MSWin32 Time: Fri Aug 17 11:44:46 2012

Message: ITSMCore-3.1.5: c:/otrs/scripts/test/Service.t is different!

Traceback (1120):
Module: Kernel::System::Package::DeployCheck (v1.130.2.1) Line: 1313
Module: Kernel::Modules::AdminPackageManager::Run (v1.108) Line: 1227
Module: Kernel::System::Web::InterfaceAgent::Run (v1.64) Line: 868
Module: c:\otrs\bin\cgi-bin\index.pl (v1.90) Line: 46
I had no issue when installing the GeneralCatalog 3.1.5 or FAQ 2.1.2 packages.
I have also checked the file permissions on the OTRS directory and tried uninstalling/reinstalling the Core package numerous times.

Any help would be appreciated.

Thanks, Dan
OTRS 3.1.12
Ubuntu
MYSQL DB
sipsmi
Znuny newbie
Posts: 1
Joined: 22 Feb 2013, 19:20
Znuny Version: OTRS 3.1
Real Name: Simon

Re: Cannot install ITSM on windows mssql environment

Post by sipsmi »

Dan,

Did you get anywhere with this?

I have exactly the same issue and may have to fall back to MySQL although don't really want to on this particular machine.

Cheers

Simon
Locked