[SOLVED] Script failed to send data (using IIS)

[HervE]

Hello forum,

In my Firefox browser, using IIS, http://localhost:8080/otrs/index.pl only leads to the sentence: Script failed to send data.

So I cheked PerlEx logfile "PerlEx-Err-002.log":

*** 'C:\otrs\OTRS\bin\cgi-bin\index.pl' log message at: 2014/09/10 09:55:10
'C:\otrs\OTRS\bin\cgi-bin\index.pl' script produced no output

*** 'C:\otrs\OTRS\bin\cgi-bin\index.pl' log message at: 2014/09/10 09:59:14
Precompiler: Execute Error:
Filename:[C:\otrs\OTRS\bin\cgi-bin\index.pl]
Package:[PerlEx::Precompiler::c_::otrs::otrs::bin::cgi2dbin::index_pl]
Params[]
install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: C:/otrs/OTRS/bin/Custom C:/otrs/OTRS/bin/Kernel/cpan-lib C:/otrs/OTRS/bin C:/otrs/OTRS/bin/cgi-bin/../../Custom C:/otrs/OTRS/bin/cgi-bin/../../Kernel/cpan-lib C:/otrs/OTRS/bin/cgi-bin/../.. C:/Perl/site/lib C:/Perl/lib .) at (eval 69) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: CSV, DBM, ExampleP, File, Gofer, ODBC, Oracle, Pg, Proxy, SQLite, Sponge.
at C:/otrs/OTRS/bin/cgi-bin/../../Kernel/System/DB.pm line 252.

But still don't understand what the problem is.

Could anybody help please?

Best regards,
HervE

[RStraub]

Can't locate DBD/mysql.pm in @INC

This hints that the needed file (driver in this case) is not found in the Perl path.

To test if that would resolve your issue you can export the variable:

export PERL5LIB=path/to/DBD-folder
(note that you shouldn't directly point to mysql.pm)

edit:
Oh, you're on windows. I don't know how to add something to the perl path there

[HervE]

Thanks for your answer.

This hints that the needed file (driver in this case) is not found in the Perl path.
To test if that would resolve your issue you can export the variable:
export PERL5LIB=path/to/DBD-folder

How can this be done?

(note that you shouldn't directly point to mysql.pm)

What do you mean? I didn't modify anything from standard configuration.

Does it mean Perl cannot manage to C:\otrs\OTRS\Kernel\System\DB\mysql.pm?

Regards,
HervE

[RStraub]

I just googled how to, according to this blog:
http://perlmaven.com/how-to-change-inc- ... -locations

you should try:

Code: Select all

set PERL5LIB = C:\otrs\OTRS\Kernel\System\

[HervE]

Thanks.

I did it:

C:\>echo %PERL5LIB%
C:\otrs\OTRS\Kernel\System\

C:\>

But got the same log:

*** 'C:\otrs\OTRS\bin\cgi-bin\index.pl' log message at: 2014/09/10 14:22:42
'C:\otrs\OTRS\bin\cgi-bin\index.pl' script produced no output

*** 'C:\otrs\OTRS\bin\cgi-bin\index.pl' log message at: 2014/09/10 14:22:43
Precompiler: Execute Error:
Filename:[C:\otrs\OTRS\bin\cgi-bin\index.pl]
Package:[PerlEx::Precompiler::c_::otrs::otrs::bin::cgi2dbin::index_pl]
Params[]
install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: C:/otrs/OTRS/bin/Custom C:/otrs/OTRS/bin/Kernel/cpan-lib C:/otrs/OTRS/bin C:/otrs/OTRS/bin/cgi-bin/../../Custom C:/otrs/OTRS/bin/cgi-bin/../../Kernel/cpan-lib C:/otrs/OTRS/bin/cgi-bin/../.. C:/Perl/site/lib C:/Perl/lib .) at (eval 69) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: CSV, DBM, ExampleP, File, Gofer, ODBC, Oracle, Pg, Proxy, SQLite, Sponge.
at C:/otrs/OTRS/bin/cgi-bin/../../Kernel/System/DB.pm line 252.

Wasn't "C:\otrs\OTRS\Kernel\System\" supposed to appear right after "@INC contains: "?

Regards,
HervE

[RStraub]

Phew - really, I have no experience with OTRS on windows. My then next idea whould be the output of the script:
~pathToOtrs/bin/otrs.CheckModules.pl

and see that DBD::mysql and DBI is installed.

[HervE]

Thanks, and good idea!

Actually I ran CheckModules twice:

1) using the Perl version I downloaded from ActivePerl, and here is the result:

CheckModules (ActivePerl).png

Inbetween, I got this strange pop-up:

CheckModules - OCI.dll missing (ActivePerl).png

It's in French, but clear enough: OCI.dll is missing on my computer, and I should reinstall the program (really? reinstall Perl again?)

2) using the Perl natively version embedded in OTRS Windows installer, called StrawberryPerl, and the result is far much better:

CheckModules (StrawberryPerl).png

Actually I didn't tell you my OTRS works fine on Apache, but now I want to have it running on IIS, that's why.

Regards,
HervE

[jojo]

switch to Linux. Windows for OTRS is and will stay crap

[HervE]

Just impossible.

By the way, OTRS in general should be careful enough not to cut itself from the Windows people.

To tell you my story a bit, I installed and used OTRS at a customer's under Windows during 2 years, and I think I did something beautiful and it worked fine.
Now I am about to install it at a new customer's, who is "full Microsoft". So using Windows of course, but also IIS, and SQL Server, is highly recommended.

I feel like I'm close to it, but still need a little help, from time to time.
All the help I can get from this forum is, as usual, very very appreciated!

Best regards,
HervE

[jojo]

as I said. Get rid of windows. Managed or appliances should also be a possible solution for windows users

[HervE]

I switched to Debug mode and got this in otrs.log:

[Wed Sep 10 17:47:29 2014][Debug][Kernel::System::Web::InterfaceAgent::new][84] Global handle started...
[Wed Sep 10 17:47:29 2014][Debug][Kernel::System::Main::Require][161] Module: Kernel/System/DB/mysql.pm loaded!
[Wed Sep 10 17:47:29 2014][Debug][Kernel::System::DB::new][223] DB.pm->Connect: DSN: DBI:mysql:database=otrs;host=localhost, User: otrs, Pw: 0V6Dlbs4Dd56YP, DB Type: mysql;
[Wed Sep 10 17:47:29 2014][Debug][Kernel::System::DB::DESTROY][1588] DB.pm->Disconnect
[Wed Sep 10 17:47:29 2014][Debug][Kernel::System::Web::InterfaceAgent::DESTROY][920] Global handle stopped.

Does it tell more?

Regards,
HervE

[HervE]

Hello,

Although it works fine with Apache, I installed DBD::mysql (because it was stated as "Not installed").

Now I've got something with IIS, although not completely what's expected. This is a raw HTML view:

IIS HTML view.png

When I click on a blue link... nothing appears, as if I hadn't clicked at all.
Sounds strange.

Has anyone an explanation and/or a way out?

Best regards,
HervE

[RStraub]

You said you're using strawberry perl - you might want to search the forum, because I saw alot (!) of threads regarding the shipped perl when running OTRS on windows.

[HervE]

Hello forum,

This is solved!
I was missing an important configuration in IIS: add a virtual directory with the alias otrs-web, pointing to C:\otrs\OTRS\var\httpd\htdocs

Now it works fine even with IIS!

Regards,
HervE