Discussion:
[otrs] Windows Install - Service Unavailable
Tcl Warrior
2008-01-30 13:30:55 UTC
Permalink
Service Unavailable

Okay, I am trying to install otrs on a windows 2003, IIS6, Sql2005 and
Activestate Perl.

So what I did was.
1) I Downloaded the source install for window from
http://ftp.otrs.org/pub/otrs/otrs-2.2.5.zip
2) I used the mssql scripts inside it to create the otrs database, I changed
all references in the scripts from system_user to systen_users since mssql
complained that system_user is a key word.
3) I prepared the necessary IIS virtual directories as described in the otrs
faq ( http://faq.otrs.org/otrs/public.pl?Action=PublicFAQ&ItemID=123 )
4) I donwloaded and install per Activestate 5.8 and installed all the extra
packages for otrs ( okay to do this i kinda cheated I downloaded and
installed using the windows installer on a different machine copied the
packaged folder from it and used as a repository and installed all the extra
packages from it, this is atfer i failed to get all the extra packages for
perl 5.10
5) Created the Config.pm file and fixed it according the instructions here
http://www.mail-archive.com/***@otrs.org/msg20036.html
6) Downloaded, installed and started cronw (cron for windows) - I didnt do
much else, this is the step i have most doubts about, since i didnt modify
anything in the otrs files to point to cron or anything in cron to point to
otrs

I think this is all, but sadly it failled
http://localhost/otrs/index.pl return a page with the message
Service Unavailable

I am for now out of ideas!
I dont know why the official documentation dont describe the manual install
for windows since I am sure many ppl will want to install otrs under the
same setup that I have, the windows setup easy as it is, is only for mysql
and apache!

I have to use windows and sql 2005, its our company standard, I dont have a
choice.

If someone can supply simple steps, or if the developers can fix the
official docs, it will be strongly appreciated
Sune T. Tougaard
2008-01-30 13:46:53 UTC
Permalink
Dunno if it's this simple, but there's a "known issue" with IIS on 2003 with
a service pack applied at the "wrong" time.
(i think it was something like that)

Re-applying the Service Pack, should fix this specific issue.

You may google IIS 2003 service unavailable, and you'll probably find a few
articles about it.

Of course, there may be other issues causing it.
--
/Sune



_____

From: otrs-***@otrs.org [mailto:otrs-***@otrs.org] On Behalf Of Tcl
Warrior
Sent: 30. januar 2008 14:31
To: ***@otrs.org
Subject: [otrs] Windows Install - Service Unavailable



Service Unavailable

Okay, I am trying to install otrs on a windows 2003, IIS6, Sql2005 and
Activestate Perl.

So what I did was.
1) I Downloaded the source install for window from
http://ftp.otrs.org/pub/otrs/otrs-2.2.5.zip
<http://ftp.otrs.org/pub/otrs/otrs-2.2.5.zip>
2) I used the mssql scripts inside it to create the otrs database, I changed
all references in the scripts from system_user to systen_users since mssql
complained that system_user is a key word.
3) I prepared the necessary IIS virtual directories as described in the otrs
faq ( http://faq.otrs.org/otrs/public.pl?Action=PublicFAQ
<http://faq.otrs.org/otrs/public.pl?Action=PublicFAQ&ItemID=123> &ItemID=123
)
4) I donwloaded and install per Activestate 5.8 and installed all the extra
packages for otrs ( okay to do this i kinda cheated I downloaded and
installed using the windows installer on a different machine copied the
packaged folder from it and used as a repository and installed all the extra
packages from it, this is atfer i failed to get all the extra packages for
perl 5.10
5) Created the Config.pm <http://Config.pm> file and fixed it according the
instructions here http://www.mail-archive.com/***@otrs.org/msg20036.html
<http://www.mail-archive.com/***@otrs.org/msg20036.html>
6) Downloaded, installed and started cronw (cron for windows) - I didnt do
much else, this is the step i have most doubts about, since i didnt modify
anything in the otrs files to point to cron or anything in cron to point to
otrs

I think this is all, but sadly it failled
http://localhost/otrs/index.pl <http://localhost/otrs/index.pl> return a
page with the message
Service Unavailable

I am for now out of ideas!
I dont know why the official documentation dont describe the manual install
for windows since I am sure many ppl will want to install otrs under the
same setup that I have, the windows setup easy as it is, is only for mysql
and apache!

I have to use windows and sql 2005, its our company standard, I dont have a
choice.

If someone can supply simple steps, or if the developers can fix the
official docs, it will be strongly appreciated
Tcl Warrior
2008-01-30 15:06:43 UTC
Permalink
Well, thanks for the tip I did search as you suggest and modified the
application pool in IIS to use one of the default identities

I also modified the Cron4Win32.pl script to point to the correct directory.

No I get a different error
I get "The page cannot be found"

Any ideas?

Have anyone error successfully installed otrs on windows from the source
package?
Post by Sune T. Tougaard
Dunno if it's this simple, but there's a "known issue" with IIS on 2003
with a service pack applied at the "wrong" time.
(i think it was something like that)
Re-applying the Service Pack, should fix this specific issue.
You may google IIS 2003 service unavailable, and you'll probably find a
few articles about it.
Of course, there may be other issues causing it.
--
/Sune
------------------------------
*Tcl Warrior
*Sent:* 30. januar 2008 14:31
*Subject:* [otrs] Windows Install - Service Unavailable
Service Unavailable
Okay, I am trying to install otrs on a windows 2003, IIS6, Sql2005 and
Activestate Perl.
So what I did was.
1) I Downloaded the source install for window from
http://ftp.otrs.org/pub/otrs/otrs-2.2.5.zip
2) I used the mssql scripts inside it to create the otrs database, I
changed all references in the scripts from system_user to systen_users since
mssql complained that system_user is a key word.
3) I prepared the necessary IIS virtual directories as described in the
otrs faq ( http://faq.otrs.org/otrs/public.pl?Action=PublicFAQ&ItemID=123)
4) I donwloaded and install per Activestate 5.8 and installed all the
extra packages for otrs ( okay to do this i kinda cheated I downloaded and
installed using the windows installer on a different machine copied the
packaged folder from it and used as a repository and installed all the extra
packages from it, this is atfer i failed to get all the extra packages for
perl 5.10
5) Created the Config.pm <http://config.pm/> file and fixed it according
the instructions here
6) Downloaded, installed and started cronw (cron for windows) - I didnt do
much else, this is the step i have most doubts about, since i didnt modify
anything in the otrs files to point to cron or anything in cron to point to
otrs
I think this is all, but sadly it failled
http://localhost/otrs/index.pl return a page with the message
Service Unavailable
I am for now out of ideas!
I dont know why the official documentation dont describe the manual
install for windows since I am sure many ppl will want to install otrs under
the same setup that I have, the windows setup easy as it is, is only for
mysql and apache!
I have to use windows and sql 2005, its our company standard, I dont have
a choice.
If someone can supply simple steps, or if the developers can fix the
official docs, it will be strongly appreciated
_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support or consulting for your OTRS system?
=> http://www.otrs.com/
Sune T. Tougaard
2008-01-30 15:30:20 UTC
Permalink
Is the IIS able to show you any normal pages, perl pages?
Perhaps you could create a test perl script to see if the IIS is willing to
serve you that.

I think i had it running under IIS for a short time, but it didn't quite
work out as i'd like it to, so now it's running under windows but with an
Apache server, but still from the source package.

You should also check the event log on the server, as the IIS may log what's
going on.
--
/Sune



_____

From: otrs-***@otrs.org [mailto:otrs-***@otrs.org] On Behalf Of Tcl
Warrior
Sent: 30. januar 2008 16:07
To: User questions and discussions about OTRS.org
Subject: Re: [otrs] Windows Install - Service Unavailable


Well, thanks for the tip I did search as you suggest and modified the
application pool in IIS to use one of the default identities

I also modified the Cron4Win32.pl script to point to the correct directory.

No I get a different error
I get "The page cannot be found"

Any ideas?

Have anyone error successfully installed otrs on windows from the source
package?


On 1/30/08, Sune T. Tougaard <***@lyngsoesystems.com
<mailto:***@lyngsoesystems.com> > wrote:

Dunno if it's this simple, but there's a "known issue" with IIS on 2003 with
a service pack applied at the "wrong" time.
(i think it was something like that)

Re-applying the Service Pack, should fix this specific issue.

You may google IIS 2003 service unavailable, and you'll probably find a few
articles about it.

Of course, there may be other issues causing it.
--
/Sune



_____

From: otrs-***@otrs.org <mailto:otrs-***@otrs.org>
[mailto:otrs-***@otrs.org <mailto:otrs-***@otrs.org> ] On Behalf Of
Tcl Warrior
Sent: 30. januar 2008 14:31
To: ***@otrs.org <mailto:***@otrs.org>
Subject: [otrs] Windows Install - Service Unavailable




Service Unavailable

Okay, I am trying to install otrs on a windows 2003, IIS6, Sql2005 and
Activestate Perl.

So what I did was.
1) I Downloaded the source install for window from
http://ftp.otrs.org/pub/otrs/otrs-2.2.5.zip
<http://ftp.otrs.org/pub/otrs/otrs-2.2.5.zip>
2) I used the mssql scripts inside it to create the otrs database, I changed
all references in the scripts from system_user to systen_users since mssql
complained that system_user is a key word.
3) I prepared the necessary IIS virtual directories as described in the otrs
faq ( http://faq.otrs.org/otrs/public.pl?Action=PublicFAQ
<http://faq.otrs.org/otrs/public.pl?Action=PublicFAQ&ItemID=123> &ItemID=123
)
4) I donwloaded and install per Activestate 5.8 and installed all the extra
packages for otrs ( okay to do this i kinda cheated I downloaded and
installed using the windows installer on a different machine copied the
packaged folder from it and used as a repository and installed all the extra
packages from it, this is atfer i failed to get all the extra packages for
perl 5.10
5) Created the Config.pm <http://config.pm/> file and fixed it according
the instructions here
http://www.mail-archive.com/***@otrs.org/msg20036.html
<http://www.mail-archive.com/***@otrs.org/msg20036.html>
6) Downloaded, installed and started cronw (cron for windows) - I didnt do
much else, this is the step i have most doubts about, since i didnt modify
anything in the otrs files to point to cron or anything in cron to point to
otrs

I think this is all, but sadly it failled
http://localhost/otrs/index.pl <http://localhost/otrs/index.pl> return a
page with the message
Service Unavailable

I am for now out of ideas!
I dont know why the official documentation dont describe the manual install
for windows since I am sure many ppl will want to install otrs under the
same setup that I have, the windows setup easy as it is, is only for mysql
and apache!

I have to use windows and sql 2005, its our company standard, I dont have a
choice.

If someone can supply simple steps, or if the developers can fix the
official docs, it will be strongly appreciated






_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/ <http://otrs.org/>
Archive: http://lists.otrs.org/pipermail/otrs
<http://lists.otrs.org/pipermail/otrs>
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
<http://lists.otrs.org/cgi-bin/listinfo/otrs>
Support or consulting for your OTRS system?
=> http://www.otrs.com/ <http://www.otrs.com/>
Shawn Beasley
2008-01-30 17:42:39 UTC
Permalink
Hi,
Post by Tcl Warrior
Service Unavailable
Okay, I am trying to install otrs on a windows 2003, IIS6, Sql2005 and
Activestate Perl.
So what I did was.
1) I Downloaded the source install for window from
http://ftp.otrs.org/pub/otrs/otrs-2.2.5.zip
2) I used the mssql scripts inside it to create the otrs database, I
changed all references in the scripts from system_user to systen_users
since mssql complained that system_user is a key word.
Are you using an ODBC connection? Or did you use another DB connection
string? You can send me your DB connect string so I can evaluate it.
Post by Tcl Warrior
3) I prepared the necessary IIS virtual directories as described in
the otrs faq (
http://faq.otrs.org/otrs/public.pl?Action=PublicFAQ&ItemID=123
<http://faq.otrs.org/otrs/public.pl?Action=PublicFAQ&ItemID=123> )
4) I donwloaded and install per Activestate 5.8 and installed all the
extra packages for otrs ( okay to do this i kinda cheated I downloaded
and installed using the windows installer on a different machine
copied the packaged folder from it and used as a repository and
installed all the extra packages from it, this is atfer i failed to
get all the extra packages for perl 5.10
The only current working version of ActiveState Perl, in conjunction
with OTRS, is 5.8 build 819. You must completely uninstall The 5.10 and
reinstall the correct version.
Additionally you must allow the Perl CGI script to be run on your
server. As a standard, this is set to be blocked by the IIS. Look for
the ISAPI/CGI restriction list, it is the last folder in the mmc. (not
sure about the actual name of this settings folder)
Post by Tcl Warrior
5) Created the Config.pm <http://Config.pm> file and fixed it
according the instructions here
In this example the user table was set to system_user2. Please make sure
this systen_users in your Config.pm.


The next version of the Admin Manual will include the manual
installation of otrs IIS6 on W2K3 Server with ActiveState.
--
Shawn Beasley
((otrs)) :: OTRS AG :: Norsk-Data-Straße 1 :: 61352 Bad Homburg
Fon: +49 (0) 9421 56818 0 :: Fax: +49 (0) 9421 56818 18
http://www.otrs.com/ :: Communication with success!


Geschäftssitz: Bad Homburg
Amtsgericht Bad Homburg, HRB 10751
Steuernummer: 003/240/97521

Aufsichtsratsvorsitzender: Burchard Steinbild
Vorstandsvorsitzender: André Mindermann
Tcl Warrior
2008-01-31 15:12:27 UTC
Permalink
Post by Shawn Beasley
Post by Tcl Warrior
3) I prepared the necessary IIS virtual directories as described in
the otrs faq (
http://faq.otrs.org/otrs/public.pl?Action=PublicFAQ&ItemID=123
....
Additionally you must allow the Perl CGI script to be run on your
server. As a standard, this is set to be blocked by the IIS. Look for
the ISAPI/CGI restriction list, it is the last folder in the mmc. (not
sure about the actual name of this settings folder)
This was exactly whats missing, not OTRS is working :)))
on window 2003, IIS 6.0, Sql 2005 activestate perl 5.8 build 822
thanks all for the help
My next step should be to figure out how to setup OTRS to aithenticate
against the windows active directory of the firm I work at (i.e. the network
accounts)

The next version of the Admin Manual will include the manual
Post by Shawn Beasley
installation of otrs IIS6 on W2K3 Server with ActiveState.
This is great it will surely save many people a lot of time surfing around
collecting bits and pieces from all over the net :))

Loading...