Re: [otrs] migrating otrs 2.0.4 to linux from windows

2007-10-12 Thread Henning Oschwald
Hi Isaac,

On Fr, Okt 12 2007, Isaac Gonzalez wrote:

 I was contemplating migrating our current version and settings of OTRS
 to a linux box from windows(mysql db is not on the OTRS webserver).
 Depending on how hard this will be I think we would like to go that
 route, and then eventually upgrade to the latest and greatest version of
 OTRS.

I recommend the following procedure:

1.) install the latest OTRS on your Linux box 
2.) copy the configuration files (Kernel/Config.pm and maybe
Kernel/Config/Files/ZZZA*.pm) from your old system to the new one
3.) update the database scheme with the appropriate
scripts/DBUpdate-to-xxx.yyy.sql script(s).
4.) If you use ArticleStorageFS, you might also want to take over the
contents of the directory var\article\.

Which OTRS version are you currently using?

cheers

  Henning

-- 
Henning Oschwald
((otrs)) :: OTRS GmbH :: Europaring 4 :: D - 94315 Straubing
  Fon: +49 (0) 9421 56818-0  :: Fax: +49 (0) 9421 56818-18
http://www.otrs.com/ :: Communication with success!


pgpyAcPIIWRVl.pgp
Description: 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/

Re: [otrs] Ticket time input fields

2007-10-12 Thread Henning Oschwald
Hi Radek,

On Do, Okt 11 2007, Radek Hladik wrote:

 i.e. when changing ticket to pending. How is determined day and month
 inputs order? And how can I change it? Is it taken from locale or
 somewhere else?

No, it doesn't use any locale configuration, it's a fixed order.

 And is there any simple way how to change default value? We postpone
 almost all tickets to night hours (due to smaller servers load) so it
 would be great to change this algorithm to provide default value like
 22:00 today.

The default pending time can't be set to a fixed value in current OTRS
versions, but you can configure how much seconds should be added to the
current time to get the default pending time. Please see the config
setting Ticket::Frontend::PendingDiffTime in the Sysconfig.

  Henning

-- 
Henning Oschwald
((otrs)) :: OTRS GmbH :: Europaring 4 :: D - 94315 Straubing
  Fon: +49 (0) 9421 56818-0  :: Fax: +49 (0) 9421 56818-18
http://www.otrs.com/ :: Communication with success!


pgpGi3b58zanP.pgp
Description: 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/

RE: [otrs] migrating otrs 2.0.4 to linux from windows

2007-10-12 Thread Isaac Gonzalez
we're using otrs v. 2.0.4...i don't know if we're using the ArticleStorageFS or 
not, how would i be able to tell?



From: [EMAIL PROTECTED] on behalf of Henning Oschwald
Sent: Thu 10/11/2007 11:37 PM
To: User questions and discussions about OTRS.org
Subject: Re: [otrs] migrating otrs 2.0.4 to linux from windows



Hi Isaac,

On Fr, Okt 12 2007, Isaac Gonzalez wrote:

 I was contemplating migrating our current version and settings of OTRS
 to a linux box from windows(mysql db is not on the OTRS webserver).
 Depending on how hard this will be I think we would like to go that
 route, and then eventually upgrade to the latest and greatest version of
 OTRS.

I recommend the following procedure:

1.) install the latest OTRS on your Linux box
2.) copy the configuration files (Kernel/Config.pm and maybe
Kernel/Config/Files/ZZZA*.pm) from your old system to the new one
3.) update the database scheme with the appropriate
scripts/DBUpdate-to-xxx.yyy.sql script(s).
4.) If you use ArticleStorageFS, you might also want to take over the
contents of the directory var\article\.

Which OTRS version are you currently using?

cheers

  Henning

--
Henning Oschwald
((otrs)) :: OTRS GmbH :: Europaring 4 :: D - 94315 Straubing
  Fon: +49 (0) 9421 56818-0  :: Fax: +49 (0) 9421 56818-18
http://www.otrs.com/ :: Communication with success!


___
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] Ticket time input fields

2007-10-12 Thread Radek Hladik

Henning Oschwald napsal(a):
Hi Henning,

Hi Radek,

On Do, Okt 11 2007, Radek Hladik wrote:


i.e. when changing ticket to pending. How is determined day and month
inputs order? And how can I change it? Is it taken from locale or
somewhere else?


No, it doesn't use any locale configuration, it's a fixed order.


So I will have to change it in the source code. This order is very 
confusing for us and there are no labels so it is really easy to set it 
to wrong date.





And is there any simple way how to change default value? We postpone
almost all tickets to night hours (due to smaller servers load) so it
would be great to change this algorithm to provide default value like
22:00 today.


The default pending time can't be set to a fixed value in current OTRS
versions, but you can configure how much seconds should be added to the
current time to get the default pending time. Please see the config
setting Ticket::Frontend::PendingDiffTime in the Sysconfig.


Thanks for info, I will try to set it to some mean value so users will 
need to correct it only a little... However it would be nice feature in 
next versions...


Radek



  Henning





___
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] Apache Failing

2007-10-12 Thread Emily Flynn
Hi,

 

The Apache service on our OTRS machine keeps on stopping.. and I don't know
why.  I have it set up in Services that it should attempt to restart each
time but doesn't seem to work.  I don't know much about apache, but maybe
somebody might take a look at this and see what they think?  

Thanks! - Emily

 

[Thu Oct 04 11:13:07 2007] [notice] Child 404: Process exiting because it
reached MaxRequestsPerChild. Signaling the parent to restart a new child
process.

[Thu Oct 04 11:13:07 2007] [notice] Parent: Received restart signal --
Restarting the server.

[Thu Oct 04 11:13:08 2007] [notice] Child 404: Released the start mutex

[Thu Oct 04 11:13:09 2007] [notice] Child 404: Waiting for 250 worker
threads to exit.

[Thu Oct 04 11:13:10 2007] [notice] Child 404: All worker threads have
exited.

[Thu Oct 04 11:13:10 2007] [notice] Child 404: Child process is exiting

[Thu Oct 04 11:13:13 2007] [notice] Apache/2.2.4 (Win32) mod_perl/2.0.3-dev
Perl/v5.8.8 configured -- resuming normal operations

[Thu Oct 04 11:13:13 2007] [notice] Server built: Jan  9 2007 23:17:20

[Thu Oct 04 11:13:13 2007] [crit] (22)Invalid argument: Parent: Failed to
create the child process.

[Thu Oct 04 11:13:13 2007] [crit] (OS 6)The handle is invalid.  :
master_main: create child process failed. Exiting.

[Thu Oct 04 11:13:43 2007] [notice] Parent: Forcing termination of child
process 36 

[Thu Oct 04 11:14:29 2007] [notice] Apache/2.2.4 (Win32) mod_perl/2.0.3-dev
Perl/v5.8.8 configured -- resuming normal operations

[Thu Oct 04 11:14:29 2007] [notice] Server built: Jan  9 2007 23:17:20

[Thu Oct 04 11:14:29 2007] [notice] Parent: Created child process 3008

[Thu Oct 04 11:14:37 2007] [notice] Child 3008: Child process is running

[Thu Oct 04 11:14:37 2007] [notice] Child 3008: Acquired the start mutex.

[Thu Oct 04 11:14:37 2007] [notice] Child 3008: Starting 250 worker threads.

[Thu Oct 04 11:14:37 2007] [notice] Child 3008: Starting thread to listen on
port 80.

[Thu Oct 04 16:45:38 2007] [error] [client 10.1.10.54] File does not exist:
C:/OTRS/Apache2/htdocs/favicon.ico

[Thu Oct 04 16:45:38 2007] [error] [client 10.1.10.54] File does not exist:
C:/OTRS/Apache2/htdocs/favicon.ico

[Tue Oct 09 11:42:47 2007] [notice] Child 3008: Process exiting because it
reached MaxRequestsPerChild. Signaling the parent to restart a new child
process.

[Tue Oct 09 11:42:47 2007] [notice] Parent: Received restart signal --
Restarting the server.

[Tue Oct 09 11:42:48 2007] [warn] (OS 10038)An operation was attempted on
something that is not a socket.  : setsockopt(SO_UPDATE_ACCEPT_CONTEXT)
failed.

[Tue Oct 09 11:42:48 2007] [notice] Child 3008: Released the start mutex

[Tue Oct 09 11:42:49 2007] [notice] Child 3008: Waiting for 250 worker
threads to exit.

[Tue Oct 09 11:42:49 2007] [notice] Child 3008: All worker threads have
exited.

[Tue Oct 09 11:42:49 2007] [notice] Child 3008: Child process is exiting

[Tue Oct 09 11:42:55 2007] [notice] Apache/2.2.4 (Win32) mod_perl/2.0.3-dev
Perl/v5.8.8 configured -- resuming normal operations

[Tue Oct 09 11:42:55 2007] [notice] Server built: Jan  9 2007 23:17:20

[Tue Oct 09 11:42:55 2007] [crit] (22)Invalid argument: Parent: Failed to
create the child process.

[Tue Oct 09 11:42:55 2007] [crit] (OS 6)The handle is invalid.  :
master_main: create child process failed. Exiting.

[Tue Oct 09 11:43:25 2007] [notice] Parent: Forcing termination of child
process 36 

[Tue Oct 09 11:46:24 2007] [notice] Apache/2.2.4 (Win32) mod_perl/2.0.3-dev
Perl/v5.8.8 configured -- resuming normal operations

[Tue Oct 09 11:46:24 2007] [notice] Server built: Jan  9 2007 23:17:20

[Tue Oct 09 11:46:24 2007] [notice] Parent: Created child process 3676

[Tue Oct 09 11:46:31 2007] [notice] Child 3676: Child process is running

[Tue Oct 09 11:46:31 2007] [notice] Child 3676: Acquired the start mutex.

[Tue Oct 09 11:46:31 2007] [notice] Child 3676: Starting 250 worker threads.

[Tue Oct 09 11:46:31 2007] [notice] Child 3676: Starting thread to listen on
port 80.

[Tue Oct 09 14:21:08 2007] [notice] Child 3676: Process exiting because it
reached MaxRequestsPerChild. Signaling the parent to restart a new child
process.

[Tue Oct 09 14:21:08 2007] [notice] Parent: Received restart signal --
Restarting the server.

[Tue Oct 09 14:21:09 2007] [notice] Child 3676: Released the start mutex

[Tue Oct 09 14:21:10 2007] [notice] Child 3676: Waiting for 250 worker
threads to exit.

[Tue Oct 09 14:21:11 2007] [notice] Child 3676: All worker threads have
exited.

[Tue Oct 09 14:21:11 2007] [notice] Child 3676: Child process is exiting

[Tue Oct 09 14:21:16 2007] [notice] Apache/2.2.4 (Win32) mod_perl/2.0.3-dev
Perl/v5.8.8 configured -- resuming normal operations

[Tue Oct 09 14:21:16 2007] [notice] Server built: Jan  9 2007 23:17:20

[Tue Oct 09 14:21:16 2007] [crit] (22)Invalid argument: Parent: Failed to
create the child process.

[Tue Oct 09 14:21:16 2007] [crit] (OS 6)The handle is invalid.  :
master_main: create child process 

Re: [otrs] Ticket time input fields

2007-10-12 Thread Nils Breunese (Lemonbit)

Radek Hladik wrote:


Henning Oschwald napsal(a):
Hi Henning,

Hi Radek,
On Do, Okt 11 2007, Radek Hladik wrote:
i.e. when changing ticket to pending. How is determined day and  
month

inputs order? And how can I change it? Is it taken from locale or
somewhere else?

No, it doesn't use any locale configuration, it's a fixed order.


So I will have to change it in the source code. This order is very  
confusing for us and there are no labels so it is really easy to  
set it to wrong date.


You could file a bug report about the missing labels or the fact that  
dates are not specified in the same order for every locale. http:// 
bugs.otrs.org/


Nils Breunese.


PGP.sig
Description: Dit deel van het bericht is digitaal ondertekend
___
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] More then 10000 customers

2007-10-12 Thread Dan King
Hey list,

 

I have an issue; my customer_user table has grown considerably in the last 
little while to slightly above 1 customers. Now when I click on the 
customer link and try and search for a customer I receive the following error:

 

 


Software error:

Can't call method fetchrow_array on an undefined value at 
C:/OTRS/otrs//Kernel/System/DB.pm line 543.

For help, please send mail to the webmaster ([EMAIL PROTECTED] mailto:[EMAIL 
PROTECTED] ), giving this error message and the time and date of the error. 

Does anyone know that the issue is or has anyone had success with a customer 
database so large?

 

Thanks for the help!

 

Dan King
Software Developer
Canadian Resident Matching Service
613.237.0075  ext. 241
(Toll free) 877.CARMS.42
171 Nepean Street, Suite 300
Ottawa, ON, CANK2P 0B4
www.carms.ca http://www.carms.ca 



This e-mail message, including any attachments, is for the sole use of the 
intended recipients and may contain confidential and or privileged information. 
 If you are not the intended recipient or this information has been forwarded 
in error, please contact the sender by reply e-mail and destroy copies of the 
original message.  Ce message (incluant toute pièce jointe) s'adresse 
uniquement au(x) destinataire(s) prévu(s) ou à une personne autorisée à le 
recevoir en son (leur) nom. Il pourrait contenir des renseignements 
confidentiels ou protégés.  Si vous l'avez reçu par erreur, nous vous prions 
d'en informer l'auteur dans les meilleurs délais, de ne pas divulguer son 
contenu et de le supprimer de votre système. Merci.

 

___
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-de] Kein CreateTicketNr nach update auf 2.2.3

2007-10-12 Thread Dr. Stefan Schwarz

Henning Oschwald schrieb:

Hallo Stefan,

On Mo, Okt 08 2007, Dr. Stefan Schwarz wrote:


nach dem ansonsten erfolgreichen Update kann ich per Mail keine
Tickets mehr einstellen.


Von welcher Version wurde geupdated? Ich vermute mal 2.1?


Logauszug: Can't locate object method CreateTicketNr via package
Kernel::System::Ticket at /opt/otrs/Kernel/System/Ticket.pm line
218, DATA line 225.



Tatsächlich scheint es keine Methode CreateTicketNr mehr zu geben.


,[ Auszug aus dem Changelog ]
|  - (2006/12/14) Removed old compat. CreateTicketNr()/CheckTicketNr() in
| Kernel/System/Ticket.pm and Kernel/System/Ticket/Number/*.pm - so
| old ticket number generator not longer compat. to OTRS 2.1.
`

Vermutlich hast du noch alte Dateien im System.

Viele Grüße

  Henning


Ja, so war es. Aus irgend welchen Gründen wurde Ticket.pm nicht 
aktualisiert. Die manuelle Nachinstallation des Moduls hat den Fehler 
beseitigt.


Grüße,
Stefan
___
OTRS-de Mailingliste: otrs-de - Webpage: http://otrs.org/
Archiv: http://lists.otrs.org/pipermail/otrs-de/
Listenabo verwalten: http://lists.otrs.org/cgi-bin/listinfo/otrs-de/
Support oder Consulting fuer Ihr OTRS System?
= http://www.otrs.com/

[otrs-de] postmaster filter

2007-10-12 Thread Uwe . Waechter
Hallo zusammen,
wie kann man mit dem Postmaster Filter mehr als 4 Werte auf einmal setzen 
? 
gerade durch die Erweiterung mit dem ITSM sind mir die 4 Werte eindeutig 
zu wenig.

Mit freundlichen Gruessen - Best regards

Uwe Waechter
Senior Consultant
Customer Support Group

Phone: +49 (0)2273/597-7857, Mobil: +49 (0)173/3883618
Email: [EMAIL PROTECTED]


Europaring 34-40, 50170 Kerpen, Germany
Computacenter AG  Co. oHG, mit Sitz in Kerpen (Amtsgericht Köln HRA 
18096)
Vertretungsberechtigte Gesellschafter:
Computacenter Aktiengesellschaft, mit Sitz in Köln (Amtsgericht Köln HRB 
28384)
Vorstand: Colin Brown (Vorsitzender), Hans-Georg Freitag
Aufsichtsrat: Michael Norris (Vorsitzender)
Computacenter Management GmbH, mit Sitz in Köln (Amtsgericht Köln HRB 
28284)
Geschäftsführer: Dr. Karsten Freihube, Hans-Georg Freitag, Ulrich Irnich, 
Frank Kottmann, Dr. Friedel Mager, Jürgen Stauber, Oliver Tuszik

Visit us on the Internet: http://www.computacenter.de
Visit our Online-Shop: https://shop.computacenter.de

This email is confidential. If you are not the intended recipient, you 
must not disclose or use the information contained in it. If you have 
received this mail in error, please tell us immediately by return email 
and delete the document.___
OTRS-de Mailingliste: otrs-de - Webpage: http://otrs.org/
Archiv: http://lists.otrs.org/pipermail/otrs-de/
Listenabo verwalten: http://lists.otrs.org/cgi-bin/listinfo/otrs-de/
Support oder Consulting fuer Ihr OTRS System?
= http://www.otrs.com/

[otrs-de] Eskalationen werden teilweise nicht mehr angezeigt

2007-10-12 Thread Pirthauer, Christian
Hallo, 

ich bräuchte bitte dringend eure Hilfe.
Wir haben folgendes Problem:

Agents die vor längerer Zeit angelegt worden sind bekommen teilweise, bzw. gar 
keine Eskalationen der Tickets mehr angezeigt und Agents, die ich vor kurzer 
Zeit angelegt habe erschlägt es mit Eskalationen.

Ich vermute mal, das sich durch unsere Approval Implementierung diverse Flags 
auf der DB geändert haben (vorab: habe das Approval nicht geschrieben). 
Von daher bräuchte ich bitte die Codezeilen/Modul genannt für die Abfrage der 
Eskalationen auf der Datenbank.


Wir setzen OTRS in der Version otrs-2.0.4-10.x86_64 auf einer OpenSuSE 10.1 
(64Bit) ein.

Vielen Dank im Voraus.

Gruß, Christian



Mit freundlichen Grüßen / with best regards 

Christian Pirthauer
IT-Infrastructure

Tel.: +49 (0)89 4424 0431
FAX.: +49 (0)89 4424 0531
email: [EMAIL PROTECTED]
Wirecard Technologies AG
Bretonischer Ring 4
85630 Grasbrunn

Amtsgericht München
HRB: 142 427

Vorstände: Dr. Markus Braun; Burkhard Ley, Rüdiger Trautmann
Aufsichtsratsvorsitzender: Klaus Rehnig


VERTRAULICHE INFORMATIONEN ! 
Diese email enthält vertrauliche Informationen und ist nur für den berechtigten 
Empfänger bestimmt. Wenn diese email nicht für Sie bestimmt ist, bitten wir 
Sie, diese email an uns zurückzusenden und anschließend auf Ihrem Computer und 
Mail-Server zu löschen. Solche emails und Anlagen dürfen Sie weder nutzen, noch 
verarbeiten oder Dritten zugänglich machen, gleich in welcher Form.
Wir danken für Ihre Kooperation! 

CONFIDENTIAL ! 
This email contains confidential information and is intended for the authorised 
recipient only. If you are not an authorised recipient please return the email 
to us and then delete it from your computer and mail-server. You may neither 
use nor edit any such emails including attachments, nor make them accessible to 
third parties in any manner whatsoever.
Thank you for your cooperation. 

___
OTRS-de Mailingliste: otrs-de - Webpage: http://otrs.org/
Archiv: http://lists.otrs.org/pipermail/otrs-de/
Listenabo verwalten: http://lists.otrs.org/cgi-bin/listinfo/otrs-de/
Support oder Consulting fuer Ihr OTRS System?
= http://www.otrs.com/