Instalação do OTRS em W2K8 (x64) com IIS e MSSQL

Post Reply
ciprianodf
Znuny newbie
Posts: 10
Joined: 29 Jun 2012, 16:58
Znuny Version: 3.1.6
Real Name: Rafael

Instalação do OTRS em W2K8 (x64) com IIS e MSSQL

Post by ciprianodf »

Prezados, boa tarde!

estou tendo alguns problemas para efetuar a instalaçõ do OTRS em um servidor w2k8 com MSSQL e IIS. Alguem já efetuou a isntalaçõa da ultima versão nesta plataforma?
Me recordo de ter instalado uma das versões anteriores e nao tive muitos problemas... Já desta vez nem o banco eu estou conseguindo fazer o otrs conectar.... Vejam a saida do OTRS.CHECKDB:

Code: Select all

[Mon Aug 13 08:24:12 2012][Error][Kernel::System::DB::new][227] [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. (SQL-08001) [state was 08001 now 01000]
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). (SQL-01000)
Mas a conexão está correta com o ODBCAD32... Bem como usuário e senha usados no kernel.pm. Outra coisa que que achei estranho é que nesta versão não tem as linhas de configurações do MSSQL por padrão.

Estou usando os seguintes wikis:
http://blog.afsharm.com/2009/03/install ... ndows.html
http://wiki.otterhub.org/index.php?titl ... _and_IIS_7

E esse após instalado e configurado com integração do LDAP (AD)
viewtopic.php?f=62&t=14988
OTRS 3.1.7 w2k8 x64 R2 IIS MSSQL AD
ciprianodf
Znuny newbie
Posts: 10
Joined: 29 Jun 2012, 16:58
Znuny Version: 3.1.6
Real Name: Rafael

Re: Instalação do OTRS em W2K8 (x64) com IIS e MSSQL

Post by ciprianodf »

Galera,


o DSN que eu estava configurando era x64, porem a aplicação é x86 a fonte que tem que ser configurada em x86.

Thaks
OTRS 3.1.7 w2k8 x64 R2 IIS MSSQL AD
ciprianodf
Znuny newbie
Posts: 10
Joined: 29 Jun 2012, 16:58
Znuny Version: 3.1.6
Real Name: Rafael

Re: Instalação do OTRS em W2K8 (x64) com IIS e MSSQL

Post by ciprianodf »

Alguém saber dizer o motivo desses erros?

Code: Select all

 >> Can't write c:/otrs/var/log/otrs.log: Permission denied <<


 >> Can't write c:/otrs/var/log/otrs.log: Permission denied <<

Notice: Install c:\otrs/Kernel/Config/Files/Support.xml (644)!
Notice: Install c:\otrs/Kernel/Language/de_Support.pm (644)!
Notice: Install c:\otrs/Kernel/Modules/AdminSupport.pm (644)!
Notice: Install c:\otrs/Kernel/Output/HTML/Standard/AdminSupport.dtl (644)!
Notice: Install c:\otrs/Kernel/Output/HTML/Standard/AdminSupportLicenseText.dtl (644)!
Notice: Install c:\otrs/Kernel/System/Support.pm (644)!
Notice: Create Directory c:\otrs/Kernel/System/Support!
Notice: Install c:\otrs/Kernel/System/Support/Database.pm (644)!
Notice: Install c:\otrs/Kernel/System/Support/OS.pm (644)!
Notice: Install c:\otrs/Kernel/System/Support/OTRS.pm (644)!
Notice: Create Directory c:\otrs/Kernel/System/Support/Webserver!
Notice: Install c:\otrs/Kernel/System/Support/Webserver/IIS.pm (644)!
Notice: Install c:\otrs/Kernel/System/Support/Webserver/Apache.pm (644)!
Notice: Create Directory c:\otrs/Kernel/System/Support/Database!
Notice: Install c:\otrs/Kernel/System/Support/Database/oracle.pm (644)!
Notice: Install c:\otrs/Kernel/System/Support/Database/mssql.pm (644)!
Notice: Install c:\otrs/Kernel/System/Support/Database/postgresql.pm (644)!
Notice: Install c:\otrs/Kernel/System/Support/Database/mysql.pm (644)!
Notice: Install c:\otrs/Kernel/System/Support/Webserver.pm (644)!
Notice: Create Directory c:\otrs/Kernel/cpan-lib/Archive!
Notice: Create Directory c:\otrs/Kernel/cpan-lib/Archive/Tar!
Notice: Install c:\otrs/Kernel/cpan-lib/Archive/Tar/Constant.pm (644)!
Notice: Install c:\otrs/Kernel/cpan-lib/Archive/Tar/File.pm (644)!
Notice: Install c:\otrs/Kernel/cpan-lib/Archive/Tar.pm (644)!
Notice: Create Directory c:\otrs/Kernel/cpan-lib/Linux!
Notice: Install c:\otrs/Kernel/cpan-lib/Linux/Distribution.pm (644)!
Notice: Install c:\otrs/var/httpd/htdocs/skins/Agent/default/css/Support.Default.css (644)!

 >> Can't write c:/otrs/var/log/otrs.log: Permission denied <<


 >> Can't write c:/otrs/var/log/otrs.log: Permission denied <<

ERROR: OTRS-CGI-10 Perl: 5.14.2 OS: MSWin32 Time: Tue Aug 14 08:37:48 2012

 Message: Missing braces on \o{} in regex; marked by <-- HERE in m/^c:\o <-- HERE trs/(.*)\.pm$/ at C:/otrs/bin/cgi-bin/../../Kernel/Language.pm line 154.


 Traceback (716): 
   Module: Kernel::System::Package::PackageInstallDefaultFiles (v1.130.2.1) Line: 2028
   Module: Kernel::Modules::AdminInit::Run (v1.17) Line: 60
   Module: Kernel::System::Web::InterfaceAgent::Run (v1.64) Line: 868
   Module: C:\otrs\bin\cgi-bin\index.pl (v1.90) Line: 46


 >> Can't write c:/otrs/var/log/otrs.log: Permission denied <<

Missing braces on \o{} in regex; marked by <-- HERE in m/^c:\o <-- HERE trs/(.*)\.pm$/ at C:/otrs/bin/cgi-bin/../../Kernel/Language.pm line 154.
Missing braces on \o{} in regex; marked by <-- HERE in m/^c:\o <-- HERE trs/(.*)\.pm$/ at C:/otrs/bin/cgi-bin/../../Kernel/Language.pm line 154.
Missing braces on \o{} in regex; marked by <-- HERE in m/^c:\o <-- HERE trs/(.*)\.pm$/ at C:/otrs/bin/cgi-bin/../../Kernel/Language.pm line 154.

 >> Can't write c:/otrs/var/log/otrs.log: Permission denied <<


 >> Can't write c:/otrs/var/log/otrs.log: Permission denied <<

ERROR: OTRS-CGI-10 Perl: 5.14.2 OS: MSWin32 Time: Tue Aug 14 10:06:28 2012

 Message: No UserID found for 'localhost@root'!

 Traceback (3884): 
   Module: Kernel::System::User::UserLookup (v1.121) Line: 797
   Module: Kernel::System::Auth::Auth (v1.56) Line: 244
   Module: Kernel::System::Web::InterfaceAgent::Run (v1.64) Line: 204
   Module: C:\otrs\bin\cgi-bin\index.pl (v1.90) Line: 46


 >> Can't write c:/otrs/var/log/otrs.log: Permission denied <<

Missing braces on \o{} in regex; marked by <-- HERE in m/^c:\o <-- HERE trs/(.*)\.pm$/ at C:/otrs/bin/cgi-bin/../../Kernel/Language.pm line 154.
OTRS 3.1.7 w2k8 x64 R2 IIS MSSQL AD
andrepaulino
Znuny newbie
Posts: 65
Joined: 21 Jan 2013, 20:40
Znuny Version: 3.1.12
Real Name: André da Silva Paulino
Company: IOB

Re: Instalação do OTRS em W2K8 (x64) com IIS e MSSQL

Post by andrepaulino »

O usuário que você está utilizando não possue permissão de escrita no log do otrs, verifique as permissões deste usuário na pasta do OTRS
OTRS 3.3.7 Linux CentOS 6.4 Banco de Dados Mysql
Post Reply