Re: [otrs] OTRS on windows and high cpu loads
Speaking from recent experience, I do not think you'll be happier under IIS and PerlEx (the latter being the real issue, from my perspective). Are you using MySQL or MSSQL? We started with that configuration (IIS and PerlEx) and have steadily moved toward Apache. I have some ASP.NET apps also hosted under my helpdesk site so I have remained on IIS as the front end but now just use it as a reverse proxy to Apache and mod_perl for the /otrs directory. This seems to be workable. Overall, I still feel that we have some performance issues, but the OTRS tools indicate it is slowness in the data access tier. On Thursday, July 14, 2011, Arnold Ligtvoet arn...@ligtvoet.org wrote: Hi, recently had to install a system in Windows. The OTRS version is 3.0.9 and I installed in a pretty basic way. Migrated data from 2.2.7 into the new version. Now I notice that the system performs worse than I expected. The system is running Windows2008 server in 32 bit, is a 3.0 Xeon dual core at 3 Ghz and has 6 Gb of ram. Each time a user logs on to OTRS or performs a more complex action the CPU load spikes to 100% and this is largely due to the httpd.exe process. I would have expected that this config would be able to run OTRS oke. I already moved files from database to filesystem, archived 35k tickets (still around 70k tickets in system), did some database optimization (larger key_buffer_size (1024m), added thread_cache_size=40, added table_open_cache = 1024) and activated the WinNT MPM with 150 threads in the httpd.conf. This seems to have no effect on performance. There are around 20 to 30 active agents on the system. - Would I be better of running IIS? - Would I be better of installing Apache under windows myself? Any help / tips are appreciated. Regards, Arnold - 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 - 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
Re: [otrs] OTRS on windows and high cpu loads
Hi Hugh, thanks for that. I am using MySQL, so basically the complete windows installer from the OTRS site. I have a sneaky suspicion that running OTRS on windows is less than optimized. I will test next week with the same database on a Linux based system running a dualcore E2160 (1.8 Ghz) processor with 4Gb ram. I would have expected to be able to run OTRS with this number of agents. Are there other people running similar systems (around 50k tickets, 25 agents) on windows? Regards, Arnold. Op 16-7-2011 14:43, Hugh Kelley wrote: Speaking from recent experience, I do not think you'll be happier under IIS and PerlEx (the latter being the real issue, from my perspective). Are you using MySQL or MSSQL? We started with that configuration (IIS and PerlEx) and have steadily moved toward Apache. I have some ASP.NET apps also hosted under my helpdesk site so I have remained on IIS as the front end but now just use it as a reverse proxy to Apache and mod_perl for the /otrs directory. This seems to be workable. Overall, I still feel that we have some performance issues, but the OTRS tools indicate it is slowness in the data access tier. On Thursday, July 14, 2011, Arnold Ligtvoetarn...@ligtvoet.org wrote: Hi, recently had to install a system in Windows. The OTRS version is 3.0.9 and I installed in a pretty basic way. Migrated data from 2.2.7 into the new version. Now I notice that the system performs worse than I expected. The system is running Windows2008 server in 32 bit, is a 3.0 Xeon dual core at 3 Ghz and has 6 Gb of ram. Each time a user logs on to OTRS or performs a more complex action the CPU load spikes to 100% and this is largely due to the httpd.exe process. I would have expected that this config would be able to run OTRS oke. I already moved files from database to filesystem, archived 35k tickets (still around 70k tickets in system), did some database optimization (larger key_buffer_size (1024m), added thread_cache_size=40, added table_open_cache = 1024) and activated the WinNT MPM with 150 threads in the httpd.conf. This seems to have no effect on performance. There are around 20 to 30 active agents on the system. - Would I be better of running IIS? - Would I be better of installing Apache under windows myself? Any help / tips are appreciated. Regards, Arnold - 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 - 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 - 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
[otrs] OTRS on windows and high cpu loads
Hi, recently had to install a system in Windows. The OTRS version is 3.0.9 and I installed in a pretty basic way. Migrated data from 2.2.7 into the new version. Now I notice that the system performs worse than I expected. The system is running Windows2008 server in 32 bit, is a 3.0 Xeon dual core at 3 Ghz and has 6 Gb of ram. Each time a user logs on to OTRS or performs a more complex action the CPU load spikes to 100% and this is largely due to the httpd.exe process. I would have expected that this config would be able to run OTRS oke. I already moved files from database to filesystem, archived 35k tickets (still around 70k tickets in system), did some database optimization (larger key_buffer_size (1024m), added thread_cache_size=40, added table_open_cache = 1024) and activated the WinNT MPM with 150 threads in the httpd.conf. This seems to have no effect on performance. There are around 20 to 30 active agents on the system. - Would I be better of running IIS? - Would I be better of installing Apache under windows myself? Any help / tips are appreciated. Regards, Arnold - 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
Re: [otrs] OTRS slow windows server 2003.
* Panzarella, David david_panzare...@urmc.rochester.edu: Hi, Our Windows machine running server 2003 with OTRS webserver v 1.19.2.1 and Apache 2.2 What is OTRS webserver v 1.19.2.1 ? -- Ralf Hildebrandt Geschäftsbereich IT | Abteilung Netzwerk Charité - Universitätsmedizin Berlin Campus Benjamin Franklin Hindenburgdamm 30 | D-12203 Berlin Tel. +49 30 450 570 155 | Fax: +49 30 450 570 962 ralf.hildebra...@charite.de | http://www.charite.de - 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
Re: [otrs] OTRS slow windows server 2003.
Sorry that should be the last version of OTRS 2. I'm doing some research on behalf of someone else, and it looks like they had copied an older readme. Also I see a lot of errors in the Apache error log saying: [Thu Nov 18 15:54:44 2010] [notice] Child 8956: Child process is running [Thu Nov 18 15:54:44 2010] [notice] Child 8956: Acquired the start mutex. [Thu Nov 18 15:54:44 2010] [notice] Child 8956: Starting 250 worker threads. [Thu Nov 18 15:54:44 2010] [notice] Child 8956: Starting thread to listen on port 80. [Thu Nov 18 17:57:49 2010] [error] [client 172.16.148.40] File does not exist: C:/OTRS/Apache2/htdocs/favicon.ico [Fri Nov 19 06:41:52 2010] [error] [client 172.18.196.21] File does not exist: C:/OTRS/Apache2/htdocs/robots.txt [Fri Nov 19 08:24:17 2010] [error] [client 172.18.237.213] Attempt to serve directory: C:/OTRS/otrs/bin/cgi-bin/ [Fri Nov 19 08:57:15 2010] [error] [client 10.152.92.167] File does not exist: C:/OTRS/Apache2/htdocs/favicon.ico [Fri Nov 19 09:10:01 2010] [error] [client 10.152.92.14] File does not exist: C:/OTRS/Apache2/htdocs/favicon.ico [Fri Nov 19 09:10:01 2010] [error] [client 10.152.92.14] File does not exist: C:/OTRS/Apache2/htdocs/favicon.ico [Fri Nov 19 09:10:04 2010] [error] [client 10.152.92.14] File does not exist: C:/OTRS/Apache2/htdocs/favicon.ico [Fri Nov 19 09:23:21 2010] [notice] Parent: child process exited with status 0 -- Restarting. [Fri Nov 19 09:23:31 2010] [notice] Apache/2.2.4 (Win32) mod_perl/2.0.3-dev Perl/v5.8.8 configured -- resuming normal operations Hopefully this helps. -Original Message- From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of Ralf Hildebrandt Sent: Thursday, January 06, 2011 10:24 AM To: otrs@otrs.org Subject: Re: [otrs] OTRS slow windows server 2003. * Panzarella, David david_panzare...@urmc.rochester.edu: Hi, Our Windows machine running server 2003 with OTRS webserver v 1.19.2.1 and Apache 2.2 What is OTRS webserver v 1.19.2.1 ? -- Ralf Hildebrandt Geschäftsbereich IT | Abteilung Netzwerk Charité - Universitätsmedizin Berlin Campus Benjamin Franklin Hindenburgdamm 30 | D-12203 Berlin Tel. +49 30 450 570 155 | Fax: +49 30 450 570 962 ralf.hildebra...@charite.de | http://www.charite.de - 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 - 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
Re: [otrs] OTRS slow windows server 2003.
* Panzarella, David david_panzare...@urmc.rochester.edu: Sorry that should be the last version of OTRS 2. I'm doing some research on behalf of someone else, and it looks like they had copied an older readme. Also I see a lot of errors in the Apache error log saying: [Thu Nov 18 15:54:44 2010] [notice] Child 8956: Child process is running [Thu Nov 18 15:54:44 2010] [notice] Child 8956: Acquired the start mutex. [Thu Nov 18 15:54:44 2010] [notice] Child 8956: Starting 250 worker threads. [Thu Nov 18 15:54:44 2010] [notice] Child 8956: Starting thread to listen on port 80. [Thu Nov 18 17:57:49 2010] [error] [client 172.16.148.40] File does not exist: C:/OTRS/Apache2/htdocs/favicon.ico [Fri Nov 19 06:41:52 2010] [error] [client 172.18.196.21] File does not exist: C:/OTRS/Apache2/htdocs/robots.txt [Fri Nov 19 08:24:17 2010] [error] [client 172.18.237.213] Attempt to serve directory: C:/OTRS/otrs/bin/cgi-bin/ [Fri Nov 19 08:57:15 2010] [error] [client 10.152.92.167] File does not exist: C:/OTRS/Apache2/htdocs/favicon.ico [Fri Nov 19 09:10:01 2010] [error] [client 10.152.92.14] File does not exist: C:/OTRS/Apache2/htdocs/favicon.ico [Fri Nov 19 09:10:01 2010] [error] [client 10.152.92.14] File does not exist: C:/OTRS/Apache2/htdocs/favicon.ico [Fri Nov 19 09:10:04 2010] [error] [client 10.152.92.14] File does not exist: C:/OTRS/Apache2/htdocs/favicon.ico [Fri Nov 19 09:23:21 2010] [notice] Parent: child process exited with status 0 -- Restarting. [Fri Nov 19 09:23:31 2010] [notice] Apache/2.2.4 (Win32) mod_perl/2.0.3-dev Perl/v5.8.8 configured -- resuming normal operations This looks like Apache with mod_perl... For a proper analysis one would have to check WHAT exactly is going on. Is CPU load high? Is IO high? Is network latency high? Are DNS queries timing out? Is the SQL Database doing well? Find out what's going on! Look at recent logs. Look at the task manager. -- Ralf Hildebrandt Geschäftsbereich IT | Abteilung Netzwerk Charité - Universitätsmedizin Berlin Campus Benjamin Franklin Hindenburgdamm 30 | D-12203 Berlin Tel. +49 30 450 570 155 | Fax: +49 30 450 570 962 ralf.hildebra...@charite.de | http://www.charite.de - 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
Re: [otrs] OTRS slow windows server 2003.
On Thu, Jan 6, 2011 at 4:43 PM, Panzarella, David david_panzare...@urmc.rochester.edu wrote: Sorry that should be the last version of OTRS 2. I'm doing some research on behalf of someone else, and it looks like they had copied an older readme. Also I see a lot of errors in the Apache error log saying: [Thu Nov 18 15:54:44 2010] [notice] Child 8956: Child process is running [Thu Nov 18 15:54:44 2010] [notice] Child 8956: Acquired the start mutex. [Thu Nov 18 15:54:44 2010] [notice] Child 8956: Starting 250 worker threads. 250 worker threads! That's HUGE. It might be that your virtual machine is really slow because of this. Please set this to a lower value. [Fri Nov 19 09:23:31 2010] [notice] Apache/2.2.4 (Win32) mod_perl/2.0.3-dev Perl/v5.8.8 configured -- resuming normal operations So supposedly you're running mod_perl, although a dev version ; you might want to look into your apache configuration here. -- Mike - 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
Re: [otrs] OTRS slow windows server 2003.
The CPU load will spike high occasionally, same with the output. There is about 1.4 GB of RAM constantly occupied. The largest process is a Java archiver which I don't believe is related to OTRS. The next are two Apache processes totaling about 220,000K. I wonder if this is due to mod_perl. I understand that mod_perl uses a lot of memory. I did get one DNS timeout when running nslookup. It looks like the server has two IP addresses, so I'm waiting to hear back from its admin about that. I also want to lower the number of worker threads. How do I go about this? And, what is a feasible number? I am new to OTRS. -Original Message- From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of Ralf Hildebrandt Sent: Thursday, January 06, 2011 10:51 AM To: otrs@otrs.org Subject: Re: [otrs] OTRS slow windows server 2003. * Panzarella, David david_panzare...@urmc.rochester.edu: Sorry that should be the last version of OTRS 2. I'm doing some research on behalf of someone else, and it looks like they had copied an older readme. Also I see a lot of errors in the Apache error log saying: [Thu Nov 18 15:54:44 2010] [notice] Child 8956: Child process is running [Thu Nov 18 15:54:44 2010] [notice] Child 8956: Acquired the start mutex. [Thu Nov 18 15:54:44 2010] [notice] Child 8956: Starting 250 worker threads. [Thu Nov 18 15:54:44 2010] [notice] Child 8956: Starting thread to listen on port 80. [Thu Nov 18 17:57:49 2010] [error] [client 172.16.148.40] File does not exist: C:/OTRS/Apache2/htdocs/favicon.ico [Fri Nov 19 06:41:52 2010] [error] [client 172.18.196.21] File does not exist: C:/OTRS/Apache2/htdocs/robots.txt [Fri Nov 19 08:24:17 2010] [error] [client 172.18.237.213] Attempt to serve directory: C:/OTRS/otrs/bin/cgi-bin/ [Fri Nov 19 08:57:15 2010] [error] [client 10.152.92.167] File does not exist: C:/OTRS/Apache2/htdocs/favicon.ico [Fri Nov 19 09:10:01 2010] [error] [client 10.152.92.14] File does not exist: C:/OTRS/Apache2/htdocs/favicon.ico [Fri Nov 19 09:10:01 2010] [error] [client 10.152.92.14] File does not exist: C:/OTRS/Apache2/htdocs/favicon.ico [Fri Nov 19 09:10:04 2010] [error] [client 10.152.92.14] File does not exist: C:/OTRS/Apache2/htdocs/favicon.ico [Fri Nov 19 09:23:21 2010] [notice] Parent: child process exited with status 0 -- Restarting. [Fri Nov 19 09:23:31 2010] [notice] Apache/2.2.4 (Win32) mod_perl/2.0.3-dev Perl/v5.8.8 configured -- resuming normal operations This looks like Apache with mod_perl... For a proper analysis one would have to check WHAT exactly is going on. Is CPU load high? Is IO high? Is network latency high? Are DNS queries timing out? Is the SQL Database doing well? Find out what's going on! Look at recent logs. Look at the task manager. -- Ralf Hildebrandt Geschäftsbereich IT | Abteilung Netzwerk Charité - Universitätsmedizin Berlin Campus Benjamin Franklin Hindenburgdamm 30 | D-12203 Berlin Tel. +49 30 450 570 155 | Fax: +49 30 450 570 962 ralf.hildebra...@charite.de | http://www.charite.de - 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 - 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
Re: [otrs] OTRS slow windows server 2003.
* Panzarella, David david_panzare...@urmc.rochester.edu: The CPU load will spike high occasionally, same with the output. There is about 1.4 GB of RAM constantly occupied. The largest process is a Java archiver which I don't believe is related to OTRS. Indeed it is not :) The next are two Apache processes totaling about 220,000K. I wonder if this is due to mod_perl. on linux, my apaches are at about 69,000k (virtual size), also using mod_perl. Maybe they're leaking memory? Try restarting apache. But since you want to change the number of worker threads, read on. I understand that mod_perl uses a lot of memory. I did get one DNS timeout when running nslookup. That's bad. The first DNS server should answer quickly, otherwise some requests might take a lot of time because of the DNS queries timing out. It looks like the server has two IP addresses, so I'm waiting to hear back from its admin about that. I also want to lower the number of worker threads. How do I go about this? And, what is a feasible number? I am new to OTRS. That's more of an apache2 question. Look in it's config. Why are you running unix style services on Windows BTW? -- Ralf Hildebrandt Geschäftsbereich IT | Abteilung Netzwerk Charité - Universitätsmedizin Berlin Campus Benjamin Franklin Hindenburgdamm 30 | D-12203 Berlin Tel. +49 30 450 570 155 | Fax: +49 30 450 570 962 ralf.hildebra...@charite.de | http://www.charite.de - 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
Re: [otrs] OTRS slow windows server 2003.
Thanks for your help/info Ralf. Here's quite a different error. Not as many worker threads, but I can find no documentation about a scalars leaked:1 error in the apache error logs. [Thu Jan 06 15:14:29 2011] [notice] Parent: Created child process 6676 Scalars leaked: 1 Scalars leaked: 1 Scalars leaked: 1 [Thu Jan 06 15:14:35 2011] [notice] Child 6676: Child process is running [Thu Jan 06 15:14:35 2011] [notice] Child 6676: Acquired the start mutex. [Thu Jan 06 15:14:35 2011] [notice] Child 6676: Starting 64 worker threads. [Thu Jan 06 15:14:35 2011] [notice] Child 6676: Starting thread to listen on port 80. Scalars leaked: 1 Scalars leaked: 1 Scalars leaked: 1 Scalars leaked: 1 I restarted Apache but it's still consuming huge amounts of memory -Original Message- From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of Ralf Hildebrandt Sent: Thursday, January 06, 2011 2:08 PM To: otrs@otrs.org Subject: Re: [otrs] OTRS slow windows server 2003. * Panzarella, David david_panzare...@urmc.rochester.edu: The CPU load will spike high occasionally, same with the output. There is about 1.4 GB of RAM constantly occupied. The largest process is a Java archiver which I don't believe is related to OTRS. Indeed it is not :) The next are two Apache processes totaling about 220,000K. I wonder if this is due to mod_perl. on linux, my apaches are at about 69,000k (virtual size), also using mod_perl. Maybe they're leaking memory? Try restarting apache. But since you want to change the number of worker threads, read on. I understand that mod_perl uses a lot of memory. I did get one DNS timeout when running nslookup. That's bad. The first DNS server should answer quickly, otherwise some requests might take a lot of time because of the DNS queries timing out. It looks like the server has two IP addresses, so I'm waiting to hear back from its admin about that. I also want to lower the number of worker threads. How do I go about this? And, what is a feasible number? I am new to OTRS. That's more of an apache2 question. Look in it's config. Why are you running unix style services on Windows BTW? -- Ralf Hildebrandt Geschäftsbereich IT | Abteilung Netzwerk Charité - Universitätsmedizin Berlin Campus Benjamin Franklin Hindenburgdamm 30 | D-12203 Berlin Tel. +49 30 450 570 155 | Fax: +49 30 450 570 962 ralf.hildebra...@charite.de | http://www.charite.de - 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 - 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
Re: [otrs] OTRS slow windows server 2003.
* Panzarella, David david_panzare...@urmc.rochester.edu: [Thu Jan 06 15:14:29 2011] [notice] Parent: Created child process 6676 Scalars leaked: 1 Scalars leaked: 1 Scalars leaked: 1 [Thu Jan 06 15:14:35 2011] [notice] Child 6676: Child process is running [Thu Jan 06 15:14:35 2011] [notice] Child 6676: Acquired the start mutex. [Thu Jan 06 15:14:35 2011] [notice] Child 6676: Starting 64 worker threads. [Thu Jan 06 15:14:35 2011] [notice] Child 6676: Starting thread to listen on port 80. Scalars leaked: 1 Scalars leaked: 1 Scalars leaked: 1 Scalars leaked: 1 If I google for the Scalars leaked message, it indicates not much of a problem. I restarted Apache but it's still consuming huge amounts of memory Damn. Maybe it's loading a lot of (unneeded) module (maybe PHP and such) -- Ralf Hildebrandt Geschäftsbereich IT | Abteilung Netzwerk Charité - Universitätsmedizin Berlin Campus Benjamin Franklin Hindenburgdamm 30 | D-12203 Berlin Tel. +49 30 450 570 155 | Fax: +49 30 450 570 962 ralf.hildebra...@charite.de | http://www.charite.de - 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
[otrs] OTRS 2.4.7 Windows: errors in Apache Log
I have a classic OTRS Windows installation. In the Apache Log file there are the following errors: [Wed May 19 10:56:45 2010] [error] [client 10.229.44.36] Use of uninitialized value $_ in -d at C:/PROGRA~1/OTRS/StrawberryPerl/perl/lib/CGI.pm line 4083. [Wed May 19 10:56:45 2010] [error] [client 10.229.44.36] Use of uninitialized value $_ in -d at C:/PROGRA~1/OTRS/StrawberryPerl/perl/lib/CGI.pm line 4083. [Wed May 19 10:56:45 2010] [error] [client 10.229.44.36] [Wed May 19 10:56:43 2010] index.pl: DBD::mysql::db do failed: Unknown system variable 'DATEFORMAT' at C:/Program Files/OTRS/OTRS/bin/cgi-bin/../../Kernel/System/DB.pm line 427. [Wed May 19 10:56:45 2010] [error] [client 10.229.44.36] ERROR: OTRS-CGI-10 Perl: 5.10.0 OS: MSWin32 Time: Wed May 19 10:56:43 2010 [Wed May 19 10:56:45 2010] [error] [client 10.229.44.36] [Wed May 19 10:56:45 2010] [error] [client 10.229.44.36] Message: Unknown system variable 'DATEFORMAT', SQL: 'SET DATEFORMAT ymd' [Wed May 19 10:56:45 2010] [error] [client 10.229.44.36] [Wed May 19 10:56:45 2010] [error] [client 10.229.44.36] Traceback (2440): [Wed May 19 10:56:45 2010] [error] [client 10.229.44.36]Module: Kernel::System::DB::Connect (v1.105.2.1) Line: 228 [Wed May 19 10:56:45 2010] [error] [client 10.229.44.36]Module: Kernel::System::DB::new (v1.105.2.1) Line: 188 [Wed May 19 10:56:45 2010] [error] [client 10.229.44.36]Module: Kernel::System::Web::InterfaceAgent::Run (v1.43.2.1) Line: 143 [Wed May 19 10:56:45 2010] [error] [client 10.229.44.36]Module: C:/Program Files/OTRS/OTRS/bin/cgi-bin/index.pl (v1.88) Line: 48 [Wed May 19 10:56:45 2010] [error] [client 10.229.44.36] And also in otrs.log there are this message: Wed May 19 11:09:59 2010][Error][Kernel::System::DB::Connect][228] Unknown system variable 'DATEFORMAT', SQL: 'SET DATEFORMAT ymd' What does it mean? Thanks Roberto - 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
Re: [otrs] OTRS on Windows 2000 Server
Hi, Logfiles are reporting nothing special. Permissions are correctly set (IUSR can at least read, write in some dirs). Kind Regards Alex -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Isaac Gonzalez Sent: Thursday, May 29, 2008 2:41 AM To: User questions and discussions about OTRS.org Subject: Re: [otrs] OTRS on Windows 2000 Server I had it working previously before we migrated it to linux on win 2000, but that was with apache and mysqlwhat shows up in the iis logs for the vdir or website?...also have you configged the permissions correctly in the file system and in iis? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Zimmerling, Alexander Sent: Wednesday, May 28, 2008 6:36 AM To: otrs@otrs.org Subject: [otrs] OTRS on Windows 2000 Server Hi everybody, we are planning to use OTRS as our new TroubleTicketSystem. We've installed otrs4win32 during the product-test, without any problems. The live-system is a windows 2000 server with iis5 and ms-sql 2000, which we have to use. Apache and mysql are not an option. I've installed everything following the FAQ and guides from the Forums. I've made it to the login-screen, but instead of the otrs-agent window I just get: Content-type: text/html 'C:\Programme\otrs\bin\cgi-bin\index.pl' script produced no output I need to restart the iis and the login-screen returns until the next try ;). Anyone here having same problems? Kind regards Alex ___ 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/ ___ 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/ ___ 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/
Re: [otrs] OTRS on Windows 2000 Server
My guess is that this is a IIS Perl issue. You may wish to verify that the extentions for .pl are setup correctly for your version of IIS The following instructions are for 5.0 1. Click Start, click Programs, click Administrative Tools, and then click Internet Information Services. 2. Right-click a Web site that you want to enable PERL for, and then click Properties. 3. Click the Home Directory tab. 4. Click Configuration. 5. Click Add. 6. Type the following for Executable: full path to perlis.dll\perlis.dll You can also type the following: full path to perl.exe\perl.exe %s %s Note The %s %s is case sensitive (for example, %S %S does not work). 7. For Extension, type .pl. Note Make sure that the All Verbs option is selected for full functionality. Also, make sure that the Script Engine check box is selected. 8. Click OK to return to the ISM. If this does not work you can create a test.pl file and place it in the same dir as index.pl and see if you can get a hello world type example working. Here is a link to a MS KB that will give more details, http://support.microsoft.com/kb/245225 Hope it helps. Still feel you would be better off running under Linux, but I understand. Have fun Greg Horne GEH -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Zimmerling, Alexander Sent: Thursday, May 29, 2008 3:02 AM To: User questions and discussions about OTRS.org Subject: Re: [otrs] OTRS on Windows 2000 Server Hi, Logfiles are reporting nothing special. Permissions are correctly set (IUSR can at least read, write in some dirs). Kind Regards Alex -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Isaac Gonzalez Sent: Thursday, May 29, 2008 2:41 AM To: User questions and discussions about OTRS.org Subject: Re: [otrs] OTRS on Windows 2000 Server I had it working previously before we migrated it to linux on win 2000, but that was with apache and mysqlwhat shows up in the iis logs for the vdir or website?...also have you configged the permissions correctly in the file system and in iis? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Zimmerling, Alexander Sent: Wednesday, May 28, 2008 6:36 AM To: otrs@otrs.org Subject: [otrs] OTRS on Windows 2000 Server Hi everybody, we are planning to use OTRS as our new TroubleTicketSystem. We've installed otrs4win32 during the product-test, without any problems. The live-system is a windows 2000 server with iis5 and ms-sql 2000, which we have to use. Apache and mysql are not an option. I've installed everything following the FAQ and guides from the Forums. I've made it to the login-screen, but instead of the otrs-agent window I just get: Content-type: text/html 'C:\Programme\otrs\bin\cgi-bin\index.pl' script produced no output I need to restart the iis and the login-screen returns until the next try ;). Anyone here having same problems? Kind regards Alex ___ 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/ ___ 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/ ___ 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/ attachment: winmail.dat___ 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/
Re: [otrs] OTRS on Windows 2000 Server
Hi Mr. Horne, I've posted this problem to the german mailinglist too. A user send me perl script, which will display the content of the RELEASE - file in the OTRS dir. It's working. I've followed your tip and used the perlis.dll istead of perl.exe. The Login-Page is displayed now. If I try to login a process called DLLHOST.EXE on the server running IIS5 is using a lot of systemressources and cpu time. (Up to 99% CPU and ~105M of memory) After some seconds (round about 30) the process returns to 0% CPU load and ~30M memory. The browser returns script produced no output. Kind Regards Alex -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Greg Horne Sent: Thursday, May 29, 2008 11:29 AM To: 'User questions and discussions about OTRS.org' Subject: Re: [otrs] OTRS on Windows 2000 Server My guess is that this is a IIS Perl issue. You may wish to verify that the extentions for .pl are setup correctly for your version of IIS The following instructions are for 5.0 1. Click Start, click Programs, click Administrative Tools, and then click Internet Information Services. 2. Right-click a Web site that you want to enable PERL for, and then click Properties. 3. Click the Home Directory tab. 4. Click Configuration. 5. Click Add. 6. Type the following for Executable: full path to perlis.dll\perlis.dll You can also type the following: full path to perl.exe\perl.exe %s %s Note The %s %s is case sensitive (for example, %S %S does not work). 7. For Extension, type .pl. Note Make sure that the All Verbs option is selected for full functionality. Also, make sure that the Script Engine check box is selected. 8. Click OK to return to the ISM. If this does not work you can create a test.pl file and place it in the same dir as index.pl and see if you can get a hello world type example working. Here is a link to a MS KB that will give more details, http://support.microsoft.com/kb/245225 Hope it helps. Still feel you would be better off running under Linux, but I understand. Have fun Greg Horne GEH -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Zimmerling, Alexander Sent: Thursday, May 29, 2008 3:02 AM To: User questions and discussions about OTRS.org Subject: Re: [otrs] OTRS on Windows 2000 Server Hi, Logfiles are reporting nothing special. Permissions are correctly set (IUSR can at least read, write in some dirs). Kind Regards Alex -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Isaac Gonzalez Sent: Thursday, May 29, 2008 2:41 AM To: User questions and discussions about OTRS.org Subject: Re: [otrs] OTRS on Windows 2000 Server I had it working previously before we migrated it to linux on win 2000, but that was with apache and mysqlwhat shows up in the iis logs for the vdir or website?...also have you configged the permissions correctly in the file system and in iis? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Zimmerling, Alexander Sent: Wednesday, May 28, 2008 6:36 AM To: otrs@otrs.org Subject: [otrs] OTRS on Windows 2000 Server Hi everybody, we are planning to use OTRS as our new TroubleTicketSystem. We've installed otrs4win32 during the product-test, without any problems. The live-system is a windows 2000 server with iis5 and ms-sql 2000, which we have to use. Apache and mysql are not an option. I've installed everything following the FAQ and guides from the Forums. I've made it to the login-screen, but instead of the otrs-agent window I just get: Content-type: text/html 'C:\Programme\otrs\bin\cgi-bin\index.pl' script produced no output I need to restart the iis and the login-screen returns until the next try ;). Anyone here having same problems? Kind regards Alex ___ 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/ ___ 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/ ___ 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/ ___ 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/
Re: [otrs] OTRS on Windows 2000 Server
Just to make sure, I know the steps you have taken, currently you can use the index.pl page, if you enter the default login username and password, click on the submit button the resulting screen is the one returning the script produced no output. You already have gone throught the installation steps, setting up OTRS using http://localhost/otrs/installer.pl script. The error you are getting can also result, if the headers are not correct. However because you get the login page the first time, it sound like index.pl is OK. If you can, please detail the version of Perl, and OTRS that you are using, and the steps that you have taken to setupp OTRS this far. Thanks Greg Horne GEH -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Zimmerling, Alexander Sent: Thursday, May 29, 2008 5:58 AM To: User questions and discussions about OTRS.org Subject: Re: [otrs] OTRS on Windows 2000 Server Hi Mr. Horne, I've posted this problem to the german mailinglist too. A user send me perl script, which will display the content of the RELEASE - file in the OTRS dir. It's working. I've followed your tip and used the perlis.dll istead of perl.exe. The Login-Page is displayed now. If I try to login a process called DLLHOST.EXE on the server running IIS5 is using a lot of systemressources and cpu time. (Up to 99% CPU and ~105M of memory) After some seconds (round about 30) the process returns to 0% CPU load and ~30M memory. The browser returns script produced no output. Kind Regards Alex -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Greg Horne Sent: Thursday, May 29, 2008 11:29 AM To: 'User questions and discussions about OTRS.org' Subject: Re: [otrs] OTRS on Windows 2000 Server My guess is that this is a IIS Perl issue. You may wish to verify that the extentions for .pl are setup correctly for your version of IIS The following instructions are for 5.0 1. Click Start, click Programs, click Administrative Tools, and then click Internet Information Services. 2. Right-click a Web site that you want to enable PERL for, and then click Properties. 3. Click the Home Directory tab. 4. Click Configuration. 5. Click Add. 6. Type the following for Executable: full path to perlis.dll\perlis.dll You can also type the following: full path to perl.exe\perl.exe %s %s Note The %s %s is case sensitive (for example, %S %S does not work). 7. For Extension, type .pl. Note Make sure that the All Verbs option is selected for full functionality. Also, make sure that the Script Engine check box is selected. 8. Click OK to return to the ISM. If this does not work you can create a test.pl file and place it in the same dir as index.pl and see if you can get a hello world type example working. Here is a link to a MS KB that will give more details, http://support.microsoft.com/kb/245225 Hope it helps. Still feel you would be better off running under Linux, but I understand. Have fun Greg Horne GEH -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Zimmerling, Alexander Sent: Thursday, May 29, 2008 3:02 AM To: User questions and discussions about OTRS.org Subject: Re: [otrs] OTRS on Windows 2000 Server Hi, Logfiles are reporting nothing special. Permissions are correctly set (IUSR can at least read, write in some dirs). Kind Regards Alex -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Isaac Gonzalez Sent: Thursday, May 29, 2008 2:41 AM To: User questions and discussions about OTRS.org Subject: Re: [otrs] OTRS on Windows 2000 Server I had it working previously before we migrated it to linux on win 2000, but that was with apache and mysqlwhat shows up in the iis logs for the vdir or website?...also have you configged the permissions correctly in the file system and in iis? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Zimmerling, Alexander Sent: Wednesday, May 28, 2008 6:36 AM To: otrs@otrs.org Subject: [otrs] OTRS on Windows 2000 Server Hi everybody, we are planning to use OTRS as our new TroubleTicketSystem. We've installed otrs4win32 during the product-test, without any problems. The live-system is a windows 2000 server with iis5 and ms-sql 2000, which we have to use. Apache and mysql are not an option. I've installed everything following the FAQ and guides from the Forums. I've made it to the login-screen, but instead of the otrs-agent window I just get: Content-type: text/html 'C:\Programme\otrs\bin\cgi-bin\index.pl' script produced no output I need to restart the iis and the login-screen returns until the next try ;). Anyone here having same problems? Kind regards Alex ___ 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
Re: [otrs] OTRS on Windows 2000 Server
Okay, first of all, I use MSSQL not MySQL the manual said, that the installer is only available for MySQL. OTRS Version is 2.2.5 IIS Version: 5 PerlVersion: 5.5.8 MSSQL-Version: 2000 SP4 OS: Windows 2000 Server SP4 I've started with perl. Downloaded ActivePerl and installed it. I've added the otrs4win32 repository using ppm. I've created the virtual directories using the iis management console and associated .pl and .cgi with perl (also in iis) After that, I've checked the permissions for the IUSR. I've changed the attributes to read, write and scriptaccess (translation, don't know the real english word for this attribute) for the created virtual directory. Created a new database and followed the FAQ-article how I have to set up the database. All steps where done. Did a iisreset and tried to log on. Kind regards Alex -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Greg Horne Sent: Thursday, May 29, 2008 1:02 PM To: 'User questions and discussions about OTRS.org' Subject: Re: [otrs] OTRS on Windows 2000 Server Just to make sure, I know the steps you have taken, currently you can use the index.pl page, if you enter the default login username and password, click on the submit button the resulting screen is the one returning the script produced no output. You already have gone throught the installation steps, setting up OTRS using http://localhost/otrs/installer.pl script. The error you are getting can also result, if the headers are not correct. However because you get the login page the first time, it sound like index.pl is OK. If you can, please detail the version of Perl, and OTRS that you are using, and the steps that you have taken to setupp OTRS this far. Thanks Greg Horne GEH -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Zimmerling, Alexander Sent: Thursday, May 29, 2008 5:58 AM To: User questions and discussions about OTRS.org Subject: Re: [otrs] OTRS on Windows 2000 Server Hi Mr. Horne, I've posted this problem to the german mailinglist too. A user send me perl script, which will display the content of the RELEASE - file in the OTRS dir. It's working. I've followed your tip and used the perlis.dll istead of perl.exe. The Login-Page is displayed now. If I try to login a process called DLLHOST.EXE on the server running IIS5 is using a lot of systemressources and cpu time. (Up to 99% CPU and ~105M of memory) After some seconds (round about 30) the process returns to 0% CPU load and ~30M memory. The browser returns script produced no output. Kind Regards Alex -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Greg Horne Sent: Thursday, May 29, 2008 11:29 AM To: 'User questions and discussions about OTRS.org' Subject: Re: [otrs] OTRS on Windows 2000 Server My guess is that this is a IIS Perl issue. You may wish to verify that the extentions for .pl are setup correctly for your version of IIS The following instructions are for 5.0 1. Click Start, click Programs, click Administrative Tools, and then click Internet Information Services. 2. Right-click a Web site that you want to enable PERL for, and then click Properties. 3. Click the Home Directory tab. 4. Click Configuration. 5. Click Add. 6. Type the following for Executable: full path to perlis.dll\perlis.dll You can also type the following: full path to perl.exe\perl.exe %s %s Note The %s %s is case sensitive (for example, %S %S does not work). 7. For Extension, type .pl. Note Make sure that the All Verbs option is selected for full functionality. Also, make sure that the Script Engine check box is selected. 8. Click OK to return to the ISM. If this does not work you can create a test.pl file and place it in the same dir as index.pl and see if you can get a hello world type example working. Here is a link to a MS KB that will give more details, http://support.microsoft.com/kb/245225 Hope it helps. Still feel you would be better off running under Linux, but I understand. Have fun Greg Horne GEH -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Zimmerling, Alexander Sent: Thursday, May 29, 2008 3:02 AM To: User questions and discussions about OTRS.org Subject: Re: [otrs] OTRS on Windows 2000 Server Hi, Logfiles are reporting nothing special. Permissions are correctly set (IUSR can at least read, write in some dirs). Kind Regards Alex -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Isaac Gonzalez Sent: Thursday, May 29, 2008 2:41 AM To: User questions and discussions about OTRS.org Subject: Re: [otrs] OTRS on Windows 2000 Server I had it working previously before we migrated it to linux on win 2000, but that was with apache and mysqlwhat shows up in the iis logs for the vdir or website?...also have you configged the permissions correctly in the file system and in iis
[otrs] OTRS on Windows 2000 Server
Hi everybody, we are planning to use OTRS as our new TroubleTicketSystem. We've installed otrs4win32 during the product-test, without any problems. The live-system is a windows 2000 server with iis5 and ms-sql 2000, which we have to use. Apache and mysql are not an option. I've installed everything following the FAQ and guides from the Forums. I've made it to the login-screen, but instead of the otrs-agent window I just get: Content-type: text/html 'C:\Programme\otrs\bin\cgi-bin\index.pl' script produced no output I need to restart the iis and the login-screen returns until the next try ;). Anyone here having same problems? Kind regards Alex ___ 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/
Re: [otrs] OTRS on Windows 2000 Server
I had it working previously before we migrated it to linux on win 2000, but that was with apache and mysqlwhat shows up in the iis logs for the vdir or website?...also have you configged the permissions correctly in the file system and in iis? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Zimmerling, Alexander Sent: Wednesday, May 28, 2008 6:36 AM To: otrs@otrs.org Subject: [otrs] OTRS on Windows 2000 Server Hi everybody, we are planning to use OTRS as our new TroubleTicketSystem. We've installed otrs4win32 during the product-test, without any problems. The live-system is a windows 2000 server with iis5 and ms-sql 2000, which we have to use. Apache and mysql are not an option. I've installed everything following the FAQ and guides from the Forums. I've made it to the login-screen, but instead of the otrs-agent window I just get: Content-type: text/html 'C:\Programme\otrs\bin\cgi-bin\index.pl' script produced no output I need to restart the iis and the login-screen returns until the next try ;). Anyone here having same problems? Kind regards Alex ___ 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/ ___ 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/
Re: [otrs] OTRS with Windows and PostMasterMailAccount
Hi Ian, Hi, Another OTRS newbie looking for some advice. I'm evaluating OTRS on Windows for our tech support desk. Our support mail account is POP3S/IMAP on a remotely hosted exchange server and I understand that PostMasterMailAccount.pl will enable the use of this feature. The question is once installed, the otrs.CheckModules script lists several packages that I cannot find using PPM (PERL newbie as well). Has anyone got this working using the Windows OTRS version, or can anyone guide me through how to send/receive email using POP3/IMAP. If you use our installer, then you will have all the needed modules to run OTRS. OTRS cannot authenitcate with POP3S/IMAP. There is an extended package from c.a.p.e IT, but it only runs under linux. http://www.cape-it.de/cgi-bin/download.pl/Postmaster%20Mail%20Account-0.1.3.opm This will replace the otrs.CheckModules to inclued the new requirements for IMAP/POP3S. Try http://www.hmailserver.com/ as an MTA for windows installations. -- 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 signature.asc Description: OpenPGP digital signature ___ 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/
Re: [otrs] OTRS with Windows and PostMasterMailAccount
Hello Aleem Thanks for your response and your offer of help. When I used PPM several of the required modules were not listed. I had the default ActiveState repository enabled. Can you tell me which repository(s) you were using for PPM? - Ian Hi Ian, I have OTRS with PosterMasterMailAccount running on a Windows 2k3 box without issues. I don't recall the exact modules you need but if memory serves me you just need to run PPM and find the Mail::IMAP and Mail:POP3 and a couple of other modules. If you run checkModules again you'll still get errors but provided you have the Mail::IMAP (which was my main concern) things should run smoothly. If you have any issues, reply back and we can work through this step by step. -Aleem ___ 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/
Re: [otrs] OTRS with Windows and PostMasterMailAccount
Hi Ian, I have OTRS with PosterMasterMailAccount running on a Windows 2k3 box without issues. I don't recall the exact modules you need but if memory serves me you just need to run PPM and find the Mail::IMAP and Mail:POP3 and a couple of other modules. If you run checkModules again you'll still get errors but provided you have the Mail::IMAP (which was my main concern) things should run smoothly. If you have any issues, reply back and we can work through this step by step. -Aleem On Fri, Mar 14, 2008 at 7:35 AM, Ian Wells [EMAIL PROTECTED] wrote: Hi, Another OTRS newbie looking for some advice. I'm evaluating OTRS on Windows for our tech support desk. Our support mail account is POP3S/IMAP on a remotely hosted exchange server and I understand that PostMasterMailAccount.pl will enable the use of this feature. The question is once installed, the otrs.CheckModules script lists several packages that I cannot find using PPM (PERL newbie as well). Has anyone got this working using the Windows OTRS version, or can anyone guide me through how to send/receive email using POP3/IMAP. Thanks in advance Ian Wells ___ 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/ ___ 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/
[otrs] OTRS with Windows and PostMasterMailAccount
Hi, Another OTRS newbie looking for some advice. I'm evaluating OTRS on Windows for our tech support desk. Our support mail account is POP3S/IMAP on a remotely hosted exchange server and I understand that PostMasterMailAccount.pl will enable the use of this feature. The question is once installed, the otrs.CheckModules script lists several packages that I cannot find using PPM (PERL newbie as well). Has anyone got this working using the Windows OTRS version, or can anyone guide me through how to send/receive email using POP3/IMAP. Thanks in advance Ian Wells ___ 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/
Re: [otrs] OTRS with Windows and PostMasterMailAccount
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Ian, Our support mail account is POP3S/IMAP on a remotely hosted exchange server and I understand that PostMasterMailAccount.pl will enable the use of this feature. The question is once installed, the otrs.CheckModules script lists several packages that I cannot find using PPM (PERL newbie as well). Has anyone got this working using the Windows OTRS version, or can anyone guide me through how to send/receive email using POP3/IMAP. ...sorry - we haven't tried using this package in a Windows environment yet. But is it possible to install these additional perl modules by perl -MCPAN -e install instead of ppm - e.g. perl -MCPAN -e install Mail::IMAPClient (etc.)? regards, Torsten Thau - -- Torsten Thau, Dipl. Inform. c.a.p.e. IT Labs GbR - Annaberger Str. 240 - D-09125 Chemnitz phone: +49 371 5347 623 cell: +49 176 66 680 680 personal pgp-key: 0x93E0A174 fax: +49 371 5347 625 http://www.cape-it.de -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFH2oTtvXo8m5PgoXQRAv8BAJsFfn8Yjd2iqp8obJXkFeeHP9TnsACfTSmG NOArUZVwFt3LZtX0YCRtVjE= =qzbt -END PGP SIGNATURE- ___ 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/
[otrs] OTRS on Windows
Hi there I had the OTRS system installed using Linix and I did not back it up. Last week I reinstalled the system on Windows. I need to activate customer form the active Directory, get the mails to send and receive, can some one please advise. Thanks Mamakwa ___ 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 orr consulting for your OTRS system? = http://www.otrs.com/
[otrs] OTRS on Windows SBS System
Hi All, I have a Windows SBS2003 server running Exchange 2003, but not in POP3 mode. All emails come into that machine as the primary Mail Exchanger. I have OTRS running on a second Windows Server 2003r2 Standard system, and want to get the incoming support emails from the SBS box. All I can see is POP3 settings, but they are not working, presumably because I am not running POP on the main email server. Can someone assist me in making the correct setting changes to enable email reception? Sending is working fine. Thanks Mike Hayward ___ 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 orr consulting for your OTRS system? = http://www.otrs.com/
RE: [otrs] OTRS on Windows SBS System
Mike, Could you turn on pop3 interface in exchange and restrict the connections on the pop3 protocol to only the IP of the otrs svr From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Hayward Sent: Wednesday, December 27, 2006 4:22 AM To: otrs@otrs.org Subject: [otrs] OTRS on Windows SBS System Hi All, I have a Windows SBS2003 server running Exchange 2003, but not in POP3 mode. All emails come into that machine as the primary Mail Exchanger. I have OTRS running on a second Windows Server 2003r2 Standard system, and want to get the incoming support emails from the SBS box. All I can see is POP3 settings, but they are not working, presumably because I am not running POP on the main email server. Can someone assist me in making the correct setting changes to enable email reception? Sending is working fine. Thanks Mike Hayward ___ 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 orr consulting for your OTRS system? = http://www.otrs.com/
Re: [otrs] OTRS on Windows SBS System
I suggest that you take out an exchange manual or check exchange specific mailing lists. Here are some links to get you started. I do agree that if OTRS is the only thing needing POP3 access that you ³secure² it similar to the way Dave explained in the first reply. http://www.microsoft.com/technet/prodtechnol/exchange/Guides/Ex2k3DepGuide/0 142e228-d939-4a3c-b718-fc1cca389fdd.mspx?mfr=true http://www.google.com/Top/Computers/Software/Groupware/Microsoft_Exchange/Ch ats_and_Forums/ Good luck, Andy Lubel On 12/27/06 11:19 AM, Dave Wojciechowski [EMAIL PROTECTED] wrote: Mike, Could you turn on pop3 interface in exchange and restrict the connections on the pop3 protocol to only the IP of the otrs svr From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Hayward Sent: Wednesday, December 27, 2006 4:22 AM To: otrs@otrs.org Subject: [otrs] OTRS on Windows SBS System Hi All, I have a Windows SBS2003 server running Exchange 2003, but not in POP3 mode. All emails come into that machine as the primary Mail Exchanger. I have OTRS running on a second Windows Server 2003r2 Standard system, and want to get the incoming support emails from the SBS box. All I can see is POP3 settings, but they are not working, presumably because I am not running POP on the main email server. Can someone assist me in making the correct setting changes to enable email reception? Sending is working fine. Thanks Mike Hayward ___ 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 orr consulting for your OTRS system? = http://www.otrs.com/ -- ___ 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 orr consulting for your OTRS system? = http://www.otrs.com/
Re: [otrs] OTRS on windows mobile
I use it on my blackberry and it works pretty good for both customer and agent (well as good as any 320x320 screen could look). Im betting it will work just fine on your mobile device - go ahead, give it a try :) On 6/22/06 10:10 AM, Marcus Hopwood [EMAIL PROTECTED] wrote: Hi, Does anyone have experience of using OTRS on a windows mobile device? Are there any themes available that would make this easier? Thanks, Marcus ___ 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 orr consulting for your OTRS system? = http://www.otrs.com/ -- ___ 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 orr consulting for your OTRS system? = http://www.otrs.com/
Re: [otrs] OTRS on windows mobile
Just the default blackberry, nothing too blingish :) On 6/22/06 10:27 AM, Marcus Hopwood [EMAIL PROTECTED] wrote: Thanks Andy - just considering arming support people with windows mobile devices. What theme are you using on the blackberry? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andy Lubel Sent: 22 June 2006 15:21 To: User questions and discussions about OTRS.org Subject: Re: [otrs] OTRS on windows mobile I use it on my blackberry and it works pretty good for both customer and agent (well as good as any 320x320 screen could look). Im betting it will work just fine on your mobile device - go ahead, give it a try :) On 6/22/06 10:10 AM, Marcus Hopwood [EMAIL PROTECTED] wrote: Hi, Does anyone have experience of using OTRS on a windows mobile device? Are there any themes available that would make this easier? Thanks, Marcus ___ 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 orr consulting for your OTRS system? = http://www.otrs.com/ -- ___ 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 orr consulting for your OTRS system? = http://www.otrs.com/ ___ 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 orr consulting for your OTRS system? = http://www.otrs.com/ -- ___ 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 orr consulting for your OTRS system? = http://www.otrs.com/
[otrs] OTRS 2.0 Windows manual install
Greetings! I did a full install of OTRS 2.0 on my dev machine and I love it. It is exactly what my organization (a City government) needs. However... I really want to install this on a server that is running a few other web applications (our intranet, for example.) The 2.0 installer seems to insist that you cannot have apache / mysql already installed. Has anyone ripped a 2.0 install and manually installed / configured the pieces on an existing webserver? Thanks, Paul Kaiser ___ 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 orr consulting for your OTRS system? = http://www.otrs.com/