Re: [otrs] Re: Upgraded system and now OTRS causes a segfault in apache

2005-06-17 Thread Graham T. Smith
Did you follow the procedure provided in the UPGRADING document found in
the otrs directory, when you initially upgraded from 1.2 to 1.3?

On Fri, 2005-06-17 at 01:33 +0100, Des Quinn wrote:
 Well I have made some progress albeit is a parralell direction :) I have 
 installed the windows version of otrs installer onto a vmware XP session. I 
 have then pointed this at the OTRS database on the linux machine. And it 
 works with me being able to view all the tickets.
 
 Now I have not done too much testing yet but I am wondering if a otrs 1.24 
 install pointing at a otrs 1.31 database is going to end in some trouble. 
 However thats not a major issue as I will be using this as a read only 
 system to look at past info until I get it working properley on the Linux 
 box
 
 so does this give any more clues into my problem .?
 
 
 Des Quinn  wrote in message news:[EMAIL PROTECTED]
  Hi,
 
  I was using a RH9  based distribution with Apache 2 (httpd-2.0.40-24) and 
  mysql 3 (mysql-3.23.58-1.9)  but decided to upgrade to the latest version 
  of the distribution which is based on Fedora Core 2 (kernel 2.6.9.10). 
  This uses apache 2 (httpd-2.0.51-3.0.cc) and mysql 4 
  (mysql-server-4.1.8-1.cc). Old perl version was 5.8 and new perl version 
  is 5.8.3 and is located in /usr/bin/perl. Otrs version is 1.31 at the 
  moment but I do not want to upgrade to 1.32 unless that is going to make 
  sense in my current situation.
 
  This is th eonly web based application on the box that has failed to work 
  after the upgrade. I have other php based web applications that can access 
  the database without issue, and the websites located on the box are not 
  showing any issues. It is only OTRS that seems to have an issue that 
  results in an apache child process seg faulting.
 
  This occurs when I try to access the logon page, either customer or agent 
  and sometimes I dont even get the logon page displaying. When I start the 
  otrs service its checks complete ok although I did have to set 
  OTRS_DB_RUNNING=0 in /etc/sysconfig/otrs. The log shows the connection 
  being authorised when I enter my details into the logon fields but then it 
  just goes to a 404 page. Setting apaches log level to debug does not seem 
  to produce any more information.
 
  Having looked through this thread Segmentation fault (Apache 1.3  2) 
  when trying to login to OTRS on the mailing list which appears to be very 
  similar, but I dont get any further by following its suggestions. I do not 
  get any error message when starting via apachectl. Perl:DBI is 
  perl-DBI-1.40-4.
 
  Can anyone give me a direction to follow as I am at a loss.
 
  regards
 
  Des Quinn
 
 
 
 
 
  ___
  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 oder Consulting fr Ihr OTRS System?
  = http://www.otrs.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
 Support oder Consulting fr Ihr OTRS System?
 = http://www.otrs.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
Support oder Consulting fr Ihr OTRS System?
= http://www.otrs.de/


[otrs] RE: OTRS - automatic queue creation?

2005-06-17 Thread Cogley, Rick
Hello List, from Japan - 

OTRS includes some scripts already in the bin directory that help with
creating things from the command line. The otrs.addQueue script that comes
with OTRS is smart - thanks guys! If you tell it the queuename is
PARENT::CHILD, it goes and creates the queue called CHILD and puts it under
PARENT. Very cool. 

Here's a (too) simple shell script that makes a group, then queues starting
with the same name. Thanks go to Martin for his good backup.sh script, which
I used as the base to start this one. Actually, for my OTRS 2.0b2, I get
errors when I execute this, but the queues are created correctly. 

==Start
#!/bin/sh
# --
# queuemaker.sh - a queue and group making script for OTRS. 

echo queuemaker.sh - \$Revision: 0.1 $

# parse user input
while getopts b:c: Option
do
  case $Option in
b)
  # otrs bin loc
  OTRS_BIN=$OPTARG
;;
c)
  # company name
  COMP_NAME=$OPTARG
;;
  esac
done

shift $(($OPTIND - 1))

if [ x${OTRS_BIN} == x ] || [ x${COMP_NAME} == x ]; then
echo 
echo Usage: queuemaker.sh -b path/bin -c Short_Name_For_Company 
echo 
echo   Try: queuemaker.sh -b /opt/otrs/bin -c YOURCO
echo 
exit 1
fi

#  make group and queues
`${OTRS_BIN}/otrs.addGroup -n ${COMP_NAME}`
`${OTRS_BIN}/otrs.addQueue -g ${COMP_NAME} ${COMP_NAME}`
`${OTRS_BIN}/otrs.addQueue -g ${COMP_NAME} ${COMP_NAME}::Support`
`${OTRS_BIN}/otrs.addQueue -g ${COMP_NAME} ${COMP_NAME}::Projects`

exit 0
==End

If you know a better or more skillful way, please respond, since I know my
code has got to be pretty weak. 

Cheers,
Rick Cogley
Tokyo

-Original Message-
From: Cogley, Rick 
Sent: Thursday, June 16, 2005 2:07 PM
To: OTRS User List (otrs@otrs.org)
Subject: OTRS - automatic queue creation? 

Greetings from Japan - 

Just wondering how I can auto-create queues and system email addresses? 

Can I run the various OTRS perl programs from the command line, and if so,
which one would be used to create queues or system addresses? 

And, is there a --help switch that says what the perl script expects to be
fed as arguments? 

Kind Regards,
Rick
___
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 oder Consulting fr Ihr OTRS System?
= http://www.otrs.de/


RE: [otrs] RE: OTRS - automatic queue creation?

2005-06-17 Thread Cogley, Rick
 
Also - does anyone know of a way to create system addresses from the shell? 
Perhaps it could be added to this script...
Cheers,
Rick


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Cogley, Rick
Sent: Friday, June 17, 2005 5:30 PM
To: 'OTRS User List (otrs@otrs.org)'
Subject: [otrs] RE: OTRS - automatic queue creation? 

Hello List, from Japan - 

OTRS includes some scripts already in the bin directory that help with
creating things from the command line. The otrs.addQueue script that comes
with OTRS is smart - thanks guys! If you tell it the queuename is
PARENT::CHILD, it goes and creates the queue called CHILD and puts it under
PARENT. Very cool. 

Here's a (too) simple shell script that makes a group, then queues starting
with the same name. Thanks go to Martin for his good backup.sh script, which
I used as the base to start this one. Actually, for my OTRS 2.0b2, I get
errors when I execute this, but the queues are created correctly. 

==Start
#!/bin/sh
# --
# queuemaker.sh - a queue and group making script for OTRS. 

echo queuemaker.sh - \$Revision: 0.1 $

# parse user input
while getopts b:c: Option
do
  case $Option in
b)
  # otrs bin loc
  OTRS_BIN=$OPTARG
;;
c)
  # company name
  COMP_NAME=$OPTARG
;;
  esac
done

shift $(($OPTIND - 1))

if [ x${OTRS_BIN} == x ] || [ x${COMP_NAME} == x ]; then
echo 
echo Usage: queuemaker.sh -b path/bin -c Short_Name_For_Company 
echo 
echo   Try: queuemaker.sh -b /opt/otrs/bin -c YOURCO
echo 
exit 1
fi

#  make group and queues
`${OTRS_BIN}/otrs.addGroup -n ${COMP_NAME}` `${OTRS_BIN}/otrs.addQueue -g
${COMP_NAME} ${COMP_NAME}` `${OTRS_BIN}/otrs.addQueue -g ${COMP_NAME}
${COMP_NAME}::Support` `${OTRS_BIN}/otrs.addQueue -g ${COMP_NAME}
${COMP_NAME}::Projects`

exit 0
==End

If you know a better or more skillful way, please respond, since I know my
code has got to be pretty weak. 

Cheers,
Rick Cogley
Tokyo

-Original Message-
From: Cogley, Rick
Sent: Thursday, June 16, 2005 2:07 PM
To: OTRS User List (otrs@otrs.org)
Subject: OTRS - automatic queue creation? 

Greetings from Japan - 

Just wondering how I can auto-create queues and system email addresses? 

Can I run the various OTRS perl programs from the command line, and if so,
which one would be used to create queues or system addresses? 

And, is there a --help switch that says what the perl script expects to be
fed as arguments? 

Kind Regards,
Rick
___
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 oder Consulting f Ihr OTRS System?
= http://www.otrs.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
Support oder Consulting für Ihr OTRS System?
= http://www.otrs.de/


RE: [otrs] OTRS - FAQ Append vs Overwrite

2005-06-17 Thread Cogley, Rick
I tested this - works perfect! Thanks! 
Cheers,
Rick

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jan
Marien
Sent: Thursday, June 16, 2005 6:29 PM
To: User questions and discussions about OTRS.org
Subject: Re: [otrs] OTRS - FAQ Append vs Overwrite

On 6/16/05, Cogley, Rick [EMAIL PROTECTED] wrote:
 Greetings list -
 
 Just wondering: is there a setting for use in Config.pm that allows 
 you to change the default behavior of the FAQ selection process in 
 ticket zoom, where you get the popup and choose a FAQ article from the 
 list to enter into your ticket response. The default seems to be to 
 overwrite the whole ticket response body, which without notice is a 
 bit disconcerting if you have written something in the response, and 
 think oh, and I'll add that FAQ article in here too.
 


There is probably no way of doing this the config.pm file, but you can
change the code in one of the template files.  I looked at the CVS code, and
there it is in otrs/Kernel/Output/HTML/Standard/FAQ.dtl


search for: (line 160)
parent.opener.document.compose.Body.value = document.spelling.Body.value
parent.opener.document.compose.Subject.value =
document.spelling.Title.value

replace with:
parent.opener.document.compose.Body.value =
parent.opener.document.compose.Body.value + document.spelling.Body.value

It will add the FAQ item at the end of the original message, and leave the
the subject as it was (to not confuse the customer).  It is not tested, but
as it is only a small javascript change.  no big doubts about it ;-)

Greetings,
Jan Marien
___
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 oder Consulting fr Ihr OTRS System?
= http://www.otrs.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
Support oder Consulting fr Ihr OTRS System?
= http://www.otrs.de/


[otrs] Re: Re: Upgraded system and now OTRS causes a segfault inapache

2005-06-17 Thread Des Quinn
Hi and thanks for the reply.

I did not upgrade from 1.2 to 1.3.1, as the upgrade I  performed was on the 
linux box. The otrs version stayed at 1.3.1 while apache, perl, and mysqls 
version changed. The current windows vmware session has otrs 1.2.4 on it at 
present but is pointing at a 1.3.1 database on the broken linux machine.

regards

Graham T. Smith [EMAIL PROTECTED] wrote in message 
news:[EMAIL PROTECTED]
 Did you follow the procedure provided in the UPGRADING document found in
 the otrs directory, when you initially upgraded from 1.2 to 1.3?

 On Fri, 2005-06-17 at 01:33 +0100, Des Quinn wrote:
 Well I have made some progress albeit is a parralell direction :) I have
 installed the windows version of otrs installer onto a vmware XP session. 
 I
 have then pointed this at the OTRS database on the linux machine. And it
 works with me being able to view all the tickets.

 Now I have not done too much testing yet but I am wondering if a otrs 
 1.24
 install pointing at a otrs 1.31 database is going to end in some trouble.
 However thats not a major issue as I will be using this as a read only
 system to look at past info until I get it working properley on the Linux
 box

 so does this give any more clues into my problem .?


 Des Quinn  wrote in message news:[EMAIL PROTECTED]
  Hi,
 
  I was using a RH9  based distribution with Apache 2 (httpd-2.0.40-24) 
  and
  mysql 3 (mysql-3.23.58-1.9)  but decided to upgrade to the latest 
  version
  of the distribution which is based on Fedora Core 2 (kernel 2.6.9.10).
  This uses apache 2 (httpd-2.0.51-3.0.cc) and mysql 4
  (mysql-server-4.1.8-1.cc). Old perl version was 5.8 and new perl 
  version
  is 5.8.3 and is located in /usr/bin/perl. Otrs version is 1.31 at the
  moment but I do not want to upgrade to 1.32 unless that is going to 
  make
  sense in my current situation.
 
  This is th eonly web based application on the box that has failed to 
  work
  after the upgrade. I have other php based web applications that can 
  access
  the database without issue, and the websites located on the box are not
  showing any issues. It is only OTRS that seems to have an issue that
  results in an apache child process seg faulting.
 
  This occurs when I try to access the logon page, either customer or 
  agent
  and sometimes I dont even get the logon page displaying. When I start 
  the
  otrs service its checks complete ok although I did have to set
  OTRS_DB_RUNNING=0 in /etc/sysconfig/otrs. The log shows the connection
  being authorised when I enter my details into the logon fields but then 
  it
  just goes to a 404 page. Setting apaches log level to debug does not 
  seem
  to produce any more information.
 
  Having looked through this thread Segmentation fault (Apache 1.3  2)
  when trying to login to OTRS on the mailing list which appears to be 
  very
  similar, but I dont get any further by following its suggestions. I do 
  not
  get any error message when starting via apachectl. Perl:DBI is
  perl-DBI-1.40-4.
 
  Can anyone give me a direction to follow as I am at a loss.
 
  regards
 
  Des Quinn
 
 
 
 
 
  ___
  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 oder Consulting fr Ihr OTRS System?
  = http://www.otrs.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
 Support oder Consulting fr Ihr OTRS System?
 = http://www.otrs.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
 Support oder Consulting fr Ihr OTRS System?
 = http://www.otrs.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
Support oder Consulting fr Ihr OTRS System?
= http://www.otrs.de/


[otrs] RE: otrs Digest, Vol 23, Issue 20

2005-06-17 Thread Philippe Roth
Dear Christian,

I did it with your scripts, which I find good, and got the same result :
Erreur: Need SystemAddressID!
when trying to modify any option of any queue (name, subqueue, group,
options and so on...).

This should meen that the backups are OK, but the database is
corrupted...
What this message meens?
How could I repair this problem?

Many thanks in advance for any light,
Philippe Roth

Date: Thu, 16 Jun 2005 18:03:55 +0200
From: Christian Schoepplein [EMAIL PROTECTED]
Subject: Re: [otrs] Please need HELP...
To: User questions and discussions about OTRS.org otrs@otrs.org
Message-ID: [EMAIL PROTECTED]
Content-Type: text/plain; charset=us-ascii

Hi Phillippe,

On Thu, Jun 16, 2005 at 05:17:16PM +0200, Philippe Roth wrote:
I think our database is corrupted {:o(

Maybe the problem is the way I make the dumps... I use mysqldump
--add-drop-table -u root -p otrs  otrs.bkp

Take a look into the scripts directory in your otrs installation. There

you'll find a backupscript called backup.sh. And there is also a 
restore.sh script.

Best regards,
Christian

___
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 oder Consulting fr Ihr OTRS System?
= http://www.otrs.de/


[otrs] OTRS 2.0b2 - Queue Management Sign Key

2005-06-17 Thread Cogley, Rick
Hello and greetings from Japan - 

In OTRS 2.0b2, queue management screen, there is a sign key selection. 
Is this related to the new SMIME or PGP admin options? 

Also, if I set up SMIME and/or PGP, does the recipient have to be set up
some how as well? 
Are these a way to prove that the mail came from my OTRS? 

Appreciate any help on this - TIA!!

Kind Regards,
Rick

--
Rick Cogley ([EMAIL PROTECTED])

Tel: 03-5940-6880 | Fax: 03-5940-6881 | Cell: 090-4423-5475
(Outside Japan, remove leading zero-+81-3-5940-6880)
English: www.esolia.com http://www.esolia.com/  | Japanese:
www.esolia.co.jp http://www.esolia.co.jp/ 

Bilingual IT solutions and management firm-eSolia.
--

___
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 oder Consulting fr Ihr OTRS System?
= http://www.otrs.de/


Re: [otrs] Re: Re: Upgraded system and now OTRS causes a segfault inapache

2005-06-17 Thread Christian Schoepplein
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi Des,

maybe there is a problem with mod_perl after the upgrade. Would you try 
OTRS without mod_perl please?

Best regards,
Christian

On Fri, Jun 17, 2005 at 10:09:47AM +0100, Des Quinn wrote:
Hi and thanks for the reply.

I did not upgrade from 1.2 to 1.3.1, as the upgrade I  performed was on the 
linux box. The otrs version stayed at 1.3.1 while apache, perl, and mysqls 
version changed. The current windows vmware session has otrs 1.2.4 on it at 
present but is pointing at a 1.3.1 database on the broken linux machine.

regards

Graham T. Smith [EMAIL PROTECTED] wrote in message 
news:[EMAIL PROTECTED]
 Did you follow the procedure provided in the UPGRADING document found in
 the otrs directory, when you initially upgraded from 1.2 to 1.3?

 On Fri, 2005-06-17 at 01:33 +0100, Des Quinn wrote:
 Well I have made some progress albeit is a parralell direction :) I have
 installed the windows version of otrs installer onto a vmware XP session. 
 I
 have then pointed this at the OTRS database on the linux machine. And it
 works with me being able to view all the tickets.

 Now I have not done too much testing yet but I am wondering if a otrs 
 1.24
 install pointing at a otrs 1.31 database is going to end in some trouble.
 However thats not a major issue as I will be using this as a read only
 system to look at past info until I get it working properley on the Linux
 box

 so does this give any more clues into my problem .?


 Des Quinn  wrote in message news:[EMAIL PROTECTED]
  Hi,
 
  I was using a RH9  based distribution with Apache 2 (httpd-2.0.40-24) 
  and
  mysql 3 (mysql-3.23.58-1.9)  but decided to upgrade to the latest 
  version
  of the distribution which is based on Fedora Core 2 (kernel 2.6.9.10).
  This uses apache 2 (httpd-2.0.51-3.0.cc) and mysql 4
  (mysql-server-4.1.8-1.cc). Old perl version was 5.8 and new perl 
  version
  is 5.8.3 and is located in /usr/bin/perl. Otrs version is 1.31 at the
  moment but I do not want to upgrade to 1.32 unless that is going to 
  make
  sense in my current situation.
 
  This is th eonly web based application on the box that has failed to 
  work
  after the upgrade. I have other php based web applications that can 
  access
  the database without issue, and the websites located on the box are not
  showing any issues. It is only OTRS that seems to have an issue that
  results in an apache child process seg faulting.
 
  This occurs when I try to access the logon page, either customer or 
  agent
  and sometimes I dont even get the logon page displaying. When I start 
  the
  otrs service its checks complete ok although I did have to set
  OTRS_DB_RUNNING=0 in /etc/sysconfig/otrs. The log shows the connection
  being authorised when I enter my details into the logon fields but then 
  it
  just goes to a 404 page. Setting apaches log level to debug does not 
  seem
  to produce any more information.
 
  Having looked through this thread Segmentation fault (Apache 1.3  2)
  when trying to login to OTRS on the mailing list which appears to be 
  very
  similar, but I dont get any further by following its suggestions. I do 
  not
  get any error message when starting via apachectl. Perl:DBI is
  perl-DBI-1.40-4.
 
  Can anyone give me a direction to follow as I am at a loss.
 
  regards
 
  Des Quinn
 
 
 
 
 
  ___
  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 oder Consulting fr Ihr OTRS System?
  = http://www.otrs.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
 Support oder Consulting fr Ihr OTRS System?
 = http://www.otrs.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
 Support oder Consulting fr Ihr OTRS System?
 = http://www.otrs.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
Support oder Consulting fr Ihr OTRS System?
= http://www.otrs.de/

- -- 
((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg
http://www.otrs.de/ :: Manage your communication!

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFCsqZOTFWOq90iSiERAuQGAKCPzXkfG9QMaD5GMrXdr4fmmV3fngCg1yvL
hyfIC9tNFIAd1Q27HOjLLzY=
=CvgF
-END PGP SIGNATURE-
___
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: 

Re: [otrs] RE: otrs Digest, Vol 23, Issue 20

2005-06-17 Thread Christian Schoepplein
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi Philippe,

On Fri, Jun 17, 2005 at 10:33:49AM +0200, Philippe Roth wrote:
I did it with your scripts, which I find good, and got the same result :
Erreur: Need SystemAddressID!
when trying to modify any option of any queue (name, subqueue, group,
options and so on...).

This should meen that the backups are OK, but the database is
corrupted...

I'm not sure about that yet.

Please could you send me the apache errror logs, after the error has 
occured again? In the logs there is more about the error and the 
involved modules and routines of OTRS.

Best regrads,
Christian

- -- 
((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg
http://www.otrs.de/ :: Manage your communication!

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFCsqhqTFWOq90iSiERAh74AJ4ua5WhVEfGteAvaEK2RMttJXFeqQCgxGKn
kuI81bJeAK+KDxZu/OirbL8=
=SDmw
-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 oder Consulting fr Ihr OTRS System?
= http://www.otrs.de/


Re: [otrs] Otrs mobile phone access

2005-06-17 Thread Graham T. Smith
You will get access with a Sony Ericsson using the Opera Browser on
p9xx. How usable this is a moot point due to screen size and aspect
ratio issues.

Nokia 9500 is fine. Probably be OK with 9300 as this is effectively a
9500 without Wi-Fi or camera.

Nokia 9210 will load it at about 9.6kbs a second (so very slow).

Unfortunately factors effecting performance (hence usability) are not
just down to the phone, but also to how the service supplier provides
data services. Using the lite theme will probably help performance, but
as far as I know there is no mechanism to associate a particular theme
with either the location or type of device making the connection. So
unless one wants to use the lite theme for all locations one would have
to manually reset the theme each one accessed otrs from a mobile
device. 

On Sun, 2005-06-12 at 07:03 -0700, Wes Plate wrote:
 On 5/25/05 12:54 AM, Graham Smith wrote:
 
  Might be worth someone putting together a list of mobile phones/networks
  otrs works well with.
 
 Agreed.
 
 So far one person replied that the Blueberry 7250 works well.
 
 

___
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 oder Consulting fr Ihr OTRS System?
= http://www.otrs.de/


Re: [otrs] Re: Re: Upgraded system and now OTRS causes a segfault inapache

2005-06-17 Thread Graham T. Smith
Some points of clarification.

You seem to be suggesting that you have a 1.3.1 otrs database backending
for a 1.2.4 otrs system. As the database schema is different between
1.2.x and 1.3.x would suspect that this could cause a few problems. If
on the otherhand you have a unupgraded 1.2.x database being accessed by
a 1.3.x otrs setup the 1.3.x setup will tend fall apart. Both 1.2.4 and
1.3.1 accessing the same dataset sounds like one of those interesting
experiences :-)

The problems you are reporting seems to be consistent with a 1.2.x
database being used with 1.3.x (at least in my experience), it is
possible that the database itself was not upgraded when you upgraded to
the new distro if you were originally running 1.2.x. You do not report
what version of otrs was installed before you upgraded the distro.


On Fri, 2005-06-17 at 10:09 +0100, Des Quinn wrote:
 Hi and thanks for the reply.
 
 I did not upgrade from 1.2 to 1.3.1, as the upgrade I  performed was on the 
 linux box. The otrs version stayed at 1.3.1 while apache, perl, and mysqls 
 version changed. The current windows vmware session has otrs 1.2.4 on it at 
 present but is pointing at a 1.3.1 database on the broken linux machine.
 
 regards
 
 Graham T. Smith [EMAIL PROTECTED] wrote in message 
 news:[EMAIL PROTECTED]
  Did you follow the procedure provided in the UPGRADING document found in
  the otrs directory, when you initially upgraded from 1.2 to 1.3?
 
  On Fri, 2005-06-17 at 01:33 +0100, Des Quinn wrote:
  Well I have made some progress albeit is a parralell direction :) I have
  installed the windows version of otrs installer onto a vmware XP session. 
  I
  have then pointed this at the OTRS database on the linux machine. And it
  works with me being able to view all the tickets.
 
  Now I have not done too much testing yet but I am wondering if a otrs 
  1.24
  install pointing at a otrs 1.31 database is going to end in some trouble.
  However thats not a major issue as I will be using this as a read only
  system to look at past info until I get it working properley on the Linux
  box
 
  so does this give any more clues into my problem .?
 
 
  Des Quinn  wrote in message news:[EMAIL PROTECTED]
   Hi,
  
[Stuff deleted]
   after the upgrade. I have other php based web applications that can 
   access
   the database without issue, and the websites located on the box are not
   showing any issues. It is only OTRS that seems to have an issue that
   results in an apache child process seg faulting.
  
   This occurs when I try to access the logon page, either customer or 
   agent
   and sometimes I dont even get the logon page displaying. When I start 
   the
   otrs service its checks complete ok although I did have to set
   OTRS_DB_RUNNING=0 in /etc/sysconfig/otrs. The log shows the connection
   being authorised when I enter my details into the logon fields but then 
   it
   just goes to a 404 page. Setting apaches log level to debug does not 
   seem
   to produce any more information.
  
   Having looked through this thread Segmentation fault (Apache 1.3  2)
   when trying to login to OTRS on the mailing list which appears to be 
   very
   similar, but I dont get any further by following its suggestions. I do 
   not
   get any error message when starting via apachectl. Perl:DBI is
   perl-DBI-1.40-4.
  
   Can anyone give me a direction to follow as I am at a loss.
  
   regards
  
   Des Quinn
  
  
  
  
  
   ___
   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 oder Consulting fr Ihr OTRS System?
   = http://www.otrs.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
  Support oder Consulting fr Ihr OTRS System?
  = http://www.otrs.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
  Support oder Consulting fr Ihr OTRS System?
  = http://www.otrs.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
 Support oder Consulting fr Ihr OTRS System?
 = http://www.otrs.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
Support oder Consulting fr Ihr OTRS System?
= http://www.otrs.de/


[otrs] RE: OTRS - automatic queue creation?

2005-06-17 Thread Cogley, Rick
Hello List - 

It now seems like this was a bad idea. I can't access the queues I made this
way correctly, so, something went wrong. 
My apologies for counting my chickens before they hatch.

Best Regards,
Rick

--
Rick Cogley (mailto:[EMAIL PROTECTED])

Tel: 03-5940-6880 || Fax: 03-5940-6881 || Cell: 090-4423-5475
(Outside Japan, remove leading zero -- +81-3-5940-6880)
English: http://www.esolia.com || Japanese: http://www.esolia.co.jp

Bilingual IT solutions and management firm -- eSolia.
--



-Original Message-
From: Cogley, Rick 
Sent: Friday, June 17, 2005 5:30 PM
To: 'OTRS User List (otrs@otrs.org)'
Subject: RE: OTRS - automatic queue creation? 

Hello List, from Japan - 

OTRS includes some scripts already in the bin directory that help with
creating things from the command line. The otrs.addQueue script that comes
with OTRS is smart - thanks guys! If you tell it the queuename is
PARENT::CHILD, it goes and creates the queue called CHILD and puts it under
PARENT. Very cool. 

Here's a (too) simple shell script that makes a group, then queues starting
with the same name. Thanks go to Martin for his good backup.sh script, which
I used as the base to start this one. Actually, for my OTRS 2.0b2, I get
errors when I execute this, but the queues are created correctly. 

==Start
#!/bin/sh
# --
# queuemaker.sh - a queue and group making script for OTRS. 

echo queuemaker.sh - \$Revision: 0.1 $

# parse user input
while getopts b:c: Option
do
  case $Option in
b)
  # otrs bin loc
  OTRS_BIN=$OPTARG
;;
c)
  # company name
  COMP_NAME=$OPTARG
;;
  esac
done

shift $(($OPTIND - 1))

if [ x${OTRS_BIN} == x ] || [ x${COMP_NAME} == x ]; then
echo 
echo Usage: queuemaker.sh -b path/bin -c Short_Name_For_Company 
echo 
echo   Try: queuemaker.sh -b /opt/otrs/bin -c YOURCO
echo 
exit 1
fi

#  make group and queues
`${OTRS_BIN}/otrs.addGroup -n ${COMP_NAME}` `${OTRS_BIN}/otrs.addQueue -g
${COMP_NAME} ${COMP_NAME}` `${OTRS_BIN}/otrs.addQueue -g ${COMP_NAME}
${COMP_NAME}::Support` `${OTRS_BIN}/otrs.addQueue -g ${COMP_NAME}
${COMP_NAME}::Projects`

exit 0
==End

If you know a better or more skillful way, please respond, since I know my
code has got to be pretty weak. 

Cheers,
Rick Cogley
Tokyo

-Original Message-
From: Cogley, Rick
Sent: Thursday, June 16, 2005 2:07 PM
To: OTRS User List (otrs@otrs.org)
Subject: OTRS - automatic queue creation? 

Greetings from Japan - 

Just wondering how I can auto-create queues and system email addresses? 

Can I run the various OTRS perl programs from the command line, and if so,
which one would be used to create queues or system addresses? 

And, is there a --help switch that says what the perl script expects to be
fed as arguments? 

Kind Regards,
Rick
___
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 oder Consulting fr Ihr OTRS System?
= http://www.otrs.de/


[otrs] Re: Re: Re: Upgraded system and now OTRS causes a segfaultinapache

2005-06-17 Thread Des Quinn
Hi,

some points inline

Graham T. Smith [EMAIL PROTECTED] wrote in message 
news:[EMAIL PROTECTED]
 Some points of clarification.

 You seem to be suggesting that you have a 1.3.1 otrs database backending
 for a 1.2.4 otrs system. As the database schema is different between
 1.2.x and 1.3.x would suspect that this could cause a few problems. If
 on the otherhand you have a unupgraded 1.2.x database being accessed by
 a 1.3.x otrs setup the 1.3.x setup will tend fall apart. Both 1.2.4 and
 1.3.1 accessing the same dataset sounds like one of those interesting
 experiences :-)

I have 1 Linux server and an XP vmware session. The Linux box has 1.31 
(always has) and the XP box has 1.24. In order to get access to the tickets 
for billing purposes :) and troubleshooting I have pointed the XP install at 
the Linux database.

 The problems you are reporting seems to be consistent with a 1.2.x
 database being used with 1.3.x (at least in my experience), it is
 possible that the database itself was not upgraded when you upgraded to
 the new distro if you were originally running 1.2.x. You do not report
 what version of otrs was installed before you upgraded the distro.

I have no functionality at the moment with otrs running on the linux box but 
will check the mod_perl suggestion above. OTRS was the same version before 
the upgrade to the linux box, and otrs has not been upgraded. So there is 
the possibility of corrupting the database if I work on it thru the XP otrs 
install but thats not an issue as I dont want to add any info to it at the 
moment,

thanks for the help so far.



 On Fri, 2005-06-17 at 10:09 +0100, Des Quinn wrote:
 Hi and thanks for the reply.

 I did not upgrade from 1.2 to 1.3.1, as the upgrade I  performed was on 
 the
 linux box. The otrs version stayed at 1.3.1 while apache, perl, and 
 mysqls
 version changed. The current windows vmware session has otrs 1.2.4 on it 
 at
 present but is pointing at a 1.3.1 database on the broken linux 
 machine.

snip 



___
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 oder Consulting fr Ihr OTRS System?
= http://www.otrs.de/


[otrs] Re: Re: Re: Upgraded system and now OTRS causes a segfaultinapache

2005-06-17 Thread Des Quinn
Hi Christian,

Thanks for helping me out, disabling mod_perl sorted it. The question is 
what can I do to troubleshoot this further and get mod_perl working again. I 
have mod_perl-1.99_12-2.1 installed but to be honest I have no idea what to 
do next. Any pointers to other information sources would be appreceiated

regards


Christian Schoepplein [EMAIL PROTECTED] wrote in message 
news:[EMAIL PROTECTED]
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi Des,

maybe there is a problem with mod_perl after the upgrade. Would you try
OTRS without mod_perl please?

Best regards,
Christian

On Fri, Jun 17, 2005 at 10:09:47AM +0100, Des Quinn wrote:
Hi and thanks for the reply.

I did not upgrade from 1.2 to 1.3.1, as the upgrade I  performed was on the
linux box. The otrs version stayed at 1.3.1 while apache, perl, and mysqls
version changed. The current windows vmware session has otrs 1.2.4 on it at
present but is pointing at a 1.3.1 database on the broken linux machine.

regards

Graham T. Smith [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
 Did you follow the procedure provided in the UPGRADING document found in
 the otrs directory, when you initially upgraded from 1.2 to 1.3?

 On Fri, 2005-06-17 at 01:33 +0100, Des Quinn wrote:
 Well I have made some progress albeit is a parralell direction :) I have
 installed the windows version of otrs installer onto a vmware XP 
 session.
 I
 have then pointed this at the OTRS database on the linux machine. And it
 works with me being able to view all the tickets.

 Now I have not done too much testing yet but I am wondering if a otrs
 1.24
 install pointing at a otrs 1.31 database is going to end in some 
 trouble.
 However thats not a major issue as I will be using this as a read only
 system to look at past info until I get it working properley on the 
 Linux
 box

 so does this give any more clues into my problem .?


 Des Quinn  wrote in message news:[EMAIL PROTECTED]
  Hi,
 
  I was using a RH9  based distribution with Apache 2 (httpd-2.0.40-24)
  and
  mysql 3 (mysql-3.23.58-1.9)  but decided to upgrade to the latest
  version
  of the distribution which is based on Fedora Core 2 (kernel 2.6.9.10).
  This uses apache 2 (httpd-2.0.51-3.0.cc) and mysql 4
  (mysql-server-4.1.8-1.cc). Old perl version was 5.8 and new perl
  version
  is 5.8.3 and is located in /usr/bin/perl. Otrs version is 1.31 at the
  moment but I do not want to upgrade to 1.32 unless that is going to
  make
  sense in my current situation.
 
  This is th eonly web based application on the box that has failed to
  work
  after the upgrade. I have other php based web applications that can
  access
  the database without issue, and the websites located on the box are 
  not
  showing any issues. It is only OTRS that seems to have an issue that
  results in an apache child process seg faulting.
 
  This occurs when I try to access the logon page, either customer or
  agent
  and sometimes I dont even get the logon page displaying. When I start
  the
  otrs service its checks complete ok although I did have to set
  OTRS_DB_RUNNING=0 in /etc/sysconfig/otrs. The log shows the connection
  being authorised when I enter my details into the logon fields but 
  then
  it
  just goes to a 404 page. Setting apaches log level to debug does not
  seem
  to produce any more information.
 
  Having looked through this thread Segmentation fault (Apache 1.3  2)
  when trying to login to OTRS on the mailing list which appears to be
  very
  similar, but I dont get any further by following its suggestions. I do
  not
  get any error message when starting via apachectl. Perl:DBI is
  perl-DBI-1.40-4.
 
  Can anyone give me a direction to follow as I am at a loss.
 
  regards
 
  Des Quinn
 
 
 
 
 
  ___
  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 oder Consulting fr Ihr OTRS System?
  = http://www.otrs.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
 Support oder Consulting fr Ihr OTRS System?
 = http://www.otrs.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
 Support oder Consulting fr Ihr OTRS System?
 = http://www.otrs.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
Support oder Consulting fr Ihr OTRS System?
= http://www.otrs.de/

- -- 
((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg
http://www.otrs.de/ 

[otrs] Filemanager for OTRS 2.0.0 beta2 Installation Issue - Windows Implmentation

2005-06-17 Thread Jürgen Brings








Anyone have any idea if the filemanager module works
on a windows implmentation and how to go about it?



Would appreciate any help.



Thanks



Jrgen






___
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 oder Consulting fr Ihr OTRS System?
= http://www.otrs.de/

Re: [otrs] Otrs mobile phone access

2005-06-17 Thread Wes Plate
On 5/25/05 12:54 AM, Graham Smith wrote:
 
 Might be worth someone putting together a list of mobile phones/networks
 otrs works well with.

I just got a Treo 650 and it seems to handle OTRS well.  I am going to make
a simpler theme, though.  It will make loading faster and navigation easier.


-- 
Wes Plate
 Automatic Duck, Inc.
  http://www.automaticduck.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 oder Consulting fr Ihr OTRS System?
= http://www.otrs.de/


[otrs] WG: Filemanager for OTRS 2.0.0 beta2 Installation Issue - Windows Implmentation

2005-06-17 Thread Jürgen Brings

Anyone have any idea if the filemanager module works on a windows
implmentation and how to go about it?

I have this version 

?xml version=1.0 encoding=utf-8 ?
otrs_package version=1.0
  NameFileManager/Name
  Version1.1.3/Version
  VendorOTRS GmbH/Vendor
  URLhttp://otrs.org//URL
  LicenseGNU GENERAL PUBLIC LICENSE Version 2, June 1991/License
  ChangeLog2005-06-12 added check if root exists/ChangeLog
  ChangeLog2005-06-12 added xml config file/ChangeLog
  ChangeLog2005-02-22 fixed css/ChangeLog
  ChangeLog2004-12-02 added change log/ChangeLog
  ChangeLog2004-12-02 v1.1 New package/ChangeLog
  Description Lang=enA web file system manager with download/upload
option./Description
  Description Lang=deEin Web Datei Manager mit download/upload
moeglichkeit./Description
  Framework2.0.0/Framework
  BuildDate2005-06-12 22:18:11/BuildDate

Etc,etc

Tried installing using the package manager in the web interface. Gave me the
following error message:

ERROR: OTRS-CGI-10 Perl: 5.8.7 OS: MSWin32 Time: Fri Jun 17 22:15:53 2005

Message: Sorry, can't install package, because package is not for your
Framework!!

Traceback (3120):
   Module: Kernel::System::Package::PackageInstall (v1.30) Line: 465
   Module: Kernel::Modules::AdminPackageManager::Run (v1.16) Line: 318
   Module: Kernel::System::Web::InterfaceAgent::Run (v1.6) Line: 687
   Module:
ModPerl::ROOT::ModPerl::Registry::C_3a_otrs_otrs_bin_cgi_2dbin_index_2epl::h
andler (v) Line: 48
   Module: (eval) (v1.80) Line: 184
   Module: ModPerl::RegistryCooker::run (v1.80) Line: 184
   Module: ModPerl::RegistryCooker::default_handler (v1.80) Line: 154
   Module: ModPerl::Registry::handler (v1.99) Line: 16


Please help.

Thanks 

Jrgen




___
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 oder Consulting fr Ihr OTRS System?
= http://www.otrs.de/


[otrs] Permissions help me

2005-06-17 Thread Jürgen Brings
Hi Ren

Refer below:

Multi Group
This is an example setup for one company with a helpdesk, sales and billing
department. Each department should not see tickets of the other department.
This means nobody from helpdesk should have access to the billing tickets.
Nobody the one department can access to a queue of the others.
Add the following to Kernel/Config.pm 

# ChangeOwnerToEveryone - useful for ASP
# (Possible to change owner of ticket ot everyone) [0|1]
$Self-{ChangeOwnerToEveryone} = 0;

# ShowCustomerSelection
# (show customer selection in phone and change customer view
# - disable this for ASP!) [0|1]
$Self-{ShowCustomerSelection} = 0;


System email addresses (1/2): You need to add new system email addresses for
each department (e. g. [EMAIL PROTECTED], [EMAIL PROTECTED] and
[EMAIL PROTECTED]). Note: You can't set the right queue because you need
to create the queue at first - this will be done later.
Groups: Add a new group for each department. In our case add a group
helpdesk, sales and billing.
Queue: Add queue for each department (take care of the naming - e. g.
group-topic). In our case add queue helpdesk-raw, helpdesk-products,
sales-raw, sales-products, billing-raw and billing-claim and set the group
of each queue to the right.
System email addresses (2/2): Update your new system email addresses (e. g.
[EMAIL PROTECTED], [EMAIL PROTECTED] and [EMAIL PROTECTED]) with the
right queue. Note: Of course you need to make sure that the added system
email addresses are routed into your system (e. g. via admin inerface -=
POP3 accounts - see chapter Receiving emails)
User: Add the users and put each user into the wanted group. Means sales
users to the sales group, helpdesk users to the helpdesk group and billing
users to the billing group. 
Note: If you add one user of the departments to the admin group, then the
user can change all settings of the system. Means the user can also
add/modify user/response/... of the other groups. -= Normally this admin
changes should be done by an admin.
Your multi group setup is ready.

Hope this helps.

Jrgen


___
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 oder Consulting fr Ihr OTRS System?
= http://www.otrs.de/


[otrs] Making tickets ownerless

2005-06-17 Thread Lara Abel

Hello,
How do you switch a ticket from an owner to having no owner?
___
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 oder Consulting fr Ihr OTRS System?
= http://www.otrs.de/


[otrs] RE: OTRS - automatic queue creation?

2005-06-17 Thread Cogley, Rick
As a followup, I tried deleting all of the recent entries in the various
tables, but never did get it working again. 
I ended up deleting and recreating my db. Luckily there was nothing in it. 

All I can say is be careful of automation. Seems like the safest thing is to
simply use the GUI unless you really, really know what you are doing. It
seems it is not a trivial matter to simply go into the db via phpmyadmin, or
something, and delete a queue or ticket. 

Best Regards,
Rick

--
Rick Cogley (mailto:[EMAIL PROTECTED])

Tel: 03-5940-6880 || Fax: 03-5940-6881 || Cell: 090-4423-5475
(Outside Japan, remove leading zero -- +81-3-5940-6880)
English: http://www.esolia.com || Japanese: http://www.esolia.co.jp

Bilingual IT solutions and management firm -- eSolia.
--



-Original Message-
From: Cogley, Rick 
Sent: Friday, June 17, 2005 10:50 PM
To: 'OTRS User List (otrs@otrs.org)'
Subject: RE: OTRS - automatic queue creation? 

Hello List - 

It now seems like this was a bad idea. I can't access the queues I made this
way correctly, so, something went wrong. 
My apologies for counting my chickens before they hatch.

Best Regards,
Rick

--
Rick Cogley (mailto:[EMAIL PROTECTED])

Tel: 03-5940-6880 || Fax: 03-5940-6881 || Cell: 090-4423-5475 (Outside
Japan, remove leading zero -- +81-3-5940-6880)
English: http://www.esolia.com || Japanese: http://www.esolia.co.jp

Bilingual IT solutions and management firm -- eSolia.
--



-Original Message-
From: Cogley, Rick
Sent: Friday, June 17, 2005 5:30 PM
To: 'OTRS User List (otrs@otrs.org)'
Subject: RE: OTRS - automatic queue creation? 

Hello List, from Japan - 

OTRS includes some scripts already in the bin directory that help with
creating things from the command line. The otrs.addQueue script that comes
with OTRS is smart - thanks guys! If you tell it the queuename is
PARENT::CHILD, it goes and creates the queue called CHILD and puts it under
PARENT. Very cool. 

Here's a (too) simple shell script that makes a group, then queues starting
with the same name. Thanks go to Martin for his good backup.sh script, which
I used as the base to start this one. Actually, for my OTRS 2.0b2, I get
errors when I execute this, but the queues are created correctly. 

==Start
#!/bin/sh
# --
# queuemaker.sh - a queue and group making script for OTRS. 

echo queuemaker.sh - \$Revision: 0.1 $

# parse user input
while getopts b:c: Option
do
  case $Option in
b)
  # otrs bin loc
  OTRS_BIN=$OPTARG
;;
c)
  # company name
  COMP_NAME=$OPTARG
;;
  esac
done

shift $(($OPTIND - 1))

if [ x${OTRS_BIN} == x ] || [ x${COMP_NAME} == x ]; then
echo 
echo Usage: queuemaker.sh -b path/bin -c Short_Name_For_Company 
echo 
echo   Try: queuemaker.sh -b /opt/otrs/bin -c YOURCO
echo 
exit 1
fi

#  make group and queues
`${OTRS_BIN}/otrs.addGroup -n ${COMP_NAME}` `${OTRS_BIN}/otrs.addQueue -g
${COMP_NAME} ${COMP_NAME}` `${OTRS_BIN}/otrs.addQueue -g ${COMP_NAME}
${COMP_NAME}::Support` `${OTRS_BIN}/otrs.addQueue -g ${COMP_NAME}
${COMP_NAME}::Projects`

exit 0
==End

If you know a better or more skillful way, please respond, since I know my
code has got to be pretty weak. 

Cheers,
Rick Cogley
Tokyo

-Original Message-
From: Cogley, Rick
Sent: Thursday, June 16, 2005 2:07 PM
To: OTRS User List (otrs@otrs.org)
Subject: OTRS - automatic queue creation? 

Greetings from Japan - 

Just wondering how I can auto-create queues and system email addresses? 

Can I run the various OTRS perl programs from the command line, and if so,
which one would be used to create queues or system addresses? 

And, is there a --help switch that says what the perl script expects to be
fed as arguments? 

Kind Regards,
Rick
___
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 oder Consulting fr Ihr OTRS System?
= http://www.otrs.de/


AW: [otrs-de] AutoAntwortDesign-- problem beim verändern!

2005-06-17 Thread Michele Bonadio (Bike o' bello)
 
Hallo Christian,

Hier mein Datei:

# --
# Kernel/Config.pm - Config file for OTRS kernel
# Copyright (C) 2001-2004 Martin Edenhofer [EMAIL PROTECTED]
# --
# $Id: Config.pm.dist,v 1.13 2004/08/10 06:56:39 martin Exp $
# --
# This software comes with ABSOLUTELY NO WARRANTY. For details, see
# the enclosed file COPYING for license information (GPL). If you
# did not receive this file, see http://www.gnu.org/licenses/gpl.txt.
# --
#  Note:
#
#  -- OTRS does have a lot of config settings. For more settings
#   (Notifications, TicketViewAccelerator, TicketNumberGenerator,
#   LDAP, PostMaster, Session, Preferences, ...) see
#   Kernel/Config/Defaults.pm and copy your wanted lines into this
#   config file. This file will not be changed on update!
#
# --
package Kernel::Config;
# --
sub Load {
my $Self = shift;
#  #
#  #
#  #
# Start of your own config options!!!  #
#  #
#  #
#  #


  

#  #
# fs root directory
#  #
$Self-{Home} = '/opt/otrs';

#  #
# insert your own config settings here   #
# config settings taken from Kernel/Config/Defaults.pm #
#  #
# $Self-{SessionUseCookie} = 0;
# $Self-{CheckMXRecord} = 1;

#  #

#  #
# data inserted by installer   #
#  #
# $DIBI$
$Self-{TicketNumberGenerator} =
'Kernel::System::Ticket::Number::DateChecksum';
$Self-{LogModule::LogFile} = '/tmp/otrs.log';
$Self-{LogModule} = 'Kernel::System::Log::SysLog';
$Self-{DefaultLanguage} = 'de';
$Self-{DefaultCharset} = 'iso-8859-1'


#- #
# ms_style
#- #
#
#$Self-{ResponseFormat} = '$Data{Salutation}
#$Data{StdResponse}
#$Data{Signature}
#$Data{OrigFrom} $Text{wrote}:
#$Data{Body}
#';
#  #
#  #
#   End of your own config options!!!  #
#  #
#  #
#  #
}

#  #
# needed system stuff (don't edit this)#
#  #
use strict;
use vars qw(@ISA $VERSION);
use Kernel::Config::Defaults;
push (@ISA, 'Kernel::Config::Defaults');
$VERSION = '$Revision: 1.13 $';
$VERSION =~ s/^\$.*:\W(.*)\W.+?$/$1/;
# -#

1;





So sobald ich nun die Raute Kstechen enferne und es aktieveire, spinnt das
Design meines Shopsystem!!
Warum?

Danke fr deine Untersttzung!



-Ursprngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag
von Christian Schoepplein
Gesendet: Donnerstag, 16. Juni 2005 16:36
An: User questions and discussions about OTRS.org in German
Betreff: Re: [otrs-de] AutoAntwortDesign-- problem beim verndern!

Hi Michele,

On Wed, Jun 15, 2005 at 10:34:13AM +0200, Michele Bonadio (Bike o' bello)
wrote:
Ich hab in der Docu gelesen das man im Kernel/Config.pm Das Design der 
Antwortmail verndern kann!
Quasi so:


# ms_style
$Self-{ResponseFormat} = '$Data{Salutation}
$Data{StdResponse}
$Data{Signature}
$Data{OrigFrom} $Text{wrote}:
$Data{Body}
';

Der Eintrag sieht IMHO gut aus.

So wenn ich das tue spinnt mein Design von Meinem Shop System!!
Warum passiert sowas? Was mach ich falsch!?

Hast du den Eintrag, so wie er oben steht, 1:1 bernommen? Kannst du bitte
deine Config.pm posten (ohne das Kennwort fr die Datenbank), denn nur
so kann man sehen, was da falsch luft.

Viele Gre,
Christian

--
((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg
http://www.otrs.de/ :: Manage your communication!



___
OTRS 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?
= 

[otrs-de] Kunden-Daten (Tel. Adresse) aber nicht für Anmeldung

2005-06-17 Thread Egeler Torsten








Gibt es die Mglichkeit, dass Kunden angelegt werden knnen,

mit zustzlichen Angaben, aber ohne die zwangsmigen
Zugangsdaten.



Wir wollen nur Tel.-Nummer und Adresse der Kunden haben, die
brauchen

aber berhaupt keinen Zugang zu OTRS.



Torsten.E






___
OTRS 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.de/

[otrs-de] Subject in Antwort E-Mails Ticket Status: OTRS_TICKET_STATE erweitern?

2005-06-17 Thread Bartsch, Martin msg asp gmbh
Hi,

im Body einer Antwort Mail wird die Zeile 
Ticket Status: OTRS_TICKET_STATE
nach dem Click auf Senden richtig mit dem ausgewhlten Status ersetzt.

Gibt es eine Mglichkeit diese Information in die Subject Zeile einer Antwort 
Mail mitaufzunehmen?

Mit freundlichen Gren / Kind regards
Martin Bartsch

___
OTRS 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.de/


AW: [otrs-de] AutoAntwortDesign-- problem beim verändern!

2005-06-17 Thread Michele Bonadio (Bike o' bello)
 Unsere CSS. Dati von unsere Shop System ist dann nicht mehr funtionabel!!
Alle im eimer!
Es ist zeimlich schwer zu erklren! Ich werde mal ein scree shot davon
machen uns es dir schicken!!
Warst du shcon mal auf unserer Seite? 

-Ursprngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag
von Christian Schoepplein
Gesendet: Freitag, 17. Juni 2005 12:27
An: User questions and discussions about OTRS.org in German
Betreff: Re: [otrs-de] AutoAntwortDesign-- problem beim verndern!

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hallo Michele,

On Fri, Jun 17, 2005 at 09:20:52AM +0200, Michele Bonadio (Bike o' bello)
wrote:
Hier mein Datei:

[...]

Sieht IMHO gut aus.

So sobald ich nun die Raute Kstechen enferne und es aktieveire, spinnt 
das Design meines Shopsystem!!
Warum?

Was genau meinst du damit, dass das Design spinnt? Kannst du mir das bitte
genauer beschreiben?

Viele Gre,
Christian

- --
((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg
http://www.otrs.de/ :: Manage your communication!

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFCsqVpTFWOq90iSiERAiSmAJ9SpPFDokLnl3BCImcWZl5L7iPnJACfeE/d
z4Oaqd25lPoN7SwIFlV4XzY=
=bnQI
-END PGP SIGNATURE-

___
OTRS 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.de/


AW: [otrs-de] AutoAntwortDesign-- problem beim verändern!

2005-06-17 Thread Michele Bonadio (Bike o' bello)
Ich wei ich hab mir die Preise angeschaut, und leide rist es fr uns zu
teuer!

Danke Trotzdem, werde mal schauen ob ich ein paar Freelancer finde! 

-Ursprngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag
von Christian Schoepplein
Gesendet: Freitag, 17. Juni 2005 13:10
An: User questions and discussions about OTRS.org in German
Betreff: Re: [otrs-de] AutoAntwortDesign-- problem beim verndern!

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi Michele,

On Fri, Jun 17, 2005 at 12:46:20PM +0200, Michele Bonadio (Bike o' bello)
wrote:
 Unsere CSS. Dati von unsere Shop System ist dann nicht mehr funtionabel!!
Alle im eimer!
Es ist zeimlich schwer zu erklren! 

Selbst angepasste Systeme sind ohne tieferen Einblick sehr schwer zu
durchschauen :(. Wenn ihr eigene Anpassungen machen mchtet, kann ich dir
nur noch mal einen Supportvertrag oder einen Workshop bei uns empfehlen. Im
Rahmen eines solchen Workshops wre es mglich, euch tieferen Einblick in
das System zu vermitteln. Natrlich ginge es auch, dass wir die Anpassungen
fr euch durchfhren.

Wende dich bitte bei Interesse an [EMAIL PROTECTED]

Viele Gre,
Christian

- --
((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg
http://www.otrs.de/ :: Manage your communication!
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFCsq94TFWOq90iSiERAnGZAKDVhIw6vSk/q95/oBcTRVPwZkPfJgCeIweR
33tSPrsCTw2/qI7f0pVqB9o=
=cEJK
-END PGP SIGNATURE-

___
OTRS 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.de/


AW: [otrs-de] Kundendaten aus externer MySQL-Datenbank benutzen ?

2005-06-17 Thread Egeler Torsten
Das habe ich soweit gefunden,

jetzt mssen aber die Feldnamen noch irgendwie
zueinander passen. Da wollte ich aber in der Defaults.pm
nicht einfach sinnlos herumkritzeln, gibt es hierfr
eine Beschreibung.

Torsten


Hi Torsten,

On Sa, Jun 11, 2005 at 09:03:17 +0200, Egeler Torsten wrote:
   Ich wrde gerne die Kundendaten aus einer anderen MySQL-Datenbank
   verwenden (ber 1 Mio. Datenstze). Gibt es die Mglichkeit eines direkten
   Zugriffes auf diese Datenbank, oder mu ich alles kopieren, oder
   replizieren, etc.

Schau dir mal in der Datei Defaults.pm die Einstellungen zu CustomerUser 
an. Du kannst damit eine externe DB einbinden.

Ciao,
Christian

-- 
((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg
http://www.otrs.de/ :: Manage your communication!

___
OTRS 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.de/
___
OTRS 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.de/


[otrs-de] Umstellung auf UTF8

2005-06-17 Thread Egeler Torsten








Gibt es eine Doku wo drin steht, was alles gemacht werden

mu, damit otrs statt mit latin1_swedisch
mit utf8 luft?



Grund, wir mssen eine externe Datenbank mit anbinden sowie 

Kunden aus Tschechien und Ungarn. Und die haben halt mal

so komische Buchstaben ;-)



Torsten.E








___
OTRS 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.de/