
Hi , We run OTRS 1.1.2 under Red Hat 8.0 on a 2-way compaq server, about 40 agents and ca. 400 tickets a day (mostly phone view for now) handeling 200 k customers. First of all: OTRS is absolutely great, thanks for sharing it !! Been live with OTRS for about three weeks (and incrfeasingly happy about it) I have a few questions: 1) We get a lot of spam and virus detected mails which I procmail to the "Virus" queue. I wrote an GenericAgent.pm to "close-successfull" those tickets. Does the Generic Agent produce any log file or debug information ? If so where can I find it ? 2) We also have a lot of faxes (as pdf attachements) entering into the system. Any experience with OCR (*.pdf to *.txt converters) and OTRS? Would you address this via Generic Agent and CMD ? 3) I would like to see more lines under ADMINSTRATOR SYSTEM LOG. 4) mysql I changed the customer_user table adding phone number and adress information then I loaded about 750 K records into customer_user. As a result the phone view "SEARCH CUSTOMER" took around 8 seconds to find the customer. I read some doc and then I added a few indexes in the db and changed the queries. I think this could be useful to other people too, I would like to share this, where should I post it ? Can we migrate the db to mysql 4.0 ? Experience ? Is it scheduled ? What release ? Thanks for the help and your soft. It is bitching good ! Paul Rhein EPT Luxembourg ---------------------------------------------------------------------------------------------------------------------- Electronic information is not secure, therefore the Entreprise des Postes et Telecommunications accepts no responsibility whatsoever for the contents of this message, which is intended for the addressee only. Its contents and any attached files are strictly confidential. If you have received this message in error, please telephone the following number 4765-1.

Hi Paul!
We get a lot of spam and virus detected mails which I procmail to the We use qconfirm with otrs and qmail. And it works perfect. But when I remember right procmail is for postfix, yes? Perhaps there is something as qconfirm for postfix? We also have a lot of faxes (as pdf attachements) entering into the system. Any experience with OCR (*.pdf to *.txt converters) and OTRS? Look at the pdf converter from phpMySearch.web4.hm. It was in php, but it works.
Perhaps I could help you. Gruss, Peter. -- _________________________________________________________________ Peter Padberg Pyrmonter Str. 42 Webagentur web4.hm 31789 Hameln Geschaeftsfuehrung Germany Telefon: +49-5151 60 99 70-0 Peter.Padberg@web4.hm Telefax: +49-5151 60 99 70-1 http://web4.hm _________________________________________________________________

Hi Peter, On Tue, Jul 22, 2003 at 02:36:18PM +0200, web4.hm - Peter Padberg wrote:
We get a lot of spam and virus detected mails which I procmail to the We use qconfirm with otrs and qmail. And it works perfect. But when I remember right procmail is for postfix, yes? Perhaps there is something as qconfirm for postfix?
Yes, procmail is an email filter to modify email. I thinks it's similar to qconfirm!? Procmail (http://www.procmail.org/) can also be used with other MTAs like sendmail, exim, ... See also the OTRS online doc to learn how it work with OTRS. :)
We also have a lot of faxes (as pdf attachements) entering into the system. Any experience with OCR (*.pdf to *.txt converters) and OTRS? Look at the pdf converter from phpMySearch.web4.hm. It was in php, but it works.
Cool! :)
Gruss, Peter.
-Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ --

Can someone tell me what I'm doing wrong???
W2K, MySQL 4.0.12, PHP 4.3.1
I get the following error when I try to log on:
[Tue Jul 22 12:53:56 2003][Notice][Kernel::System::Auth::DB::Auth] User:
admin with wrong Pw!!! (REMOTE_ADDR: x.x.x.x)
I checked the pw in the database and it is correct.
Please Help!
Thanks,
Mel
----- Original Message -----
From: "Martin Edenhofer"
Hi Peter,
On Tue, Jul 22, 2003 at 02:36:18PM +0200, web4.hm - Peter Padberg wrote:
We get a lot of spam and virus detected mails which I procmail to the We use qconfirm with otrs and qmail. And it works perfect. But when I remember right procmail is for postfix, yes? Perhaps there is something as qconfirm for postfix?
Yes, procmail is an email filter to modify email. I thinks it's similar to qconfirm!?
Procmail (http://www.procmail.org/) can also be used with other MTAs like sendmail, exim, ...
See also the OTRS online doc to learn how it work with OTRS. :)
We also have a lot of faxes (as pdf attachements) entering into the system. Any experience with OCR (*.pdf to *.txt converters) and OTRS? Look at the pdf converter from phpMySearch.web4.hm. It was in php, but it works.
Cool! :)
Gruss, Peter.
-Martin
-- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.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

Now I'm getting this error!!!!!!!!1
Error: Access denied for user: 'otrs@12.31.84.8' (Using password: YES)
----- Original Message -----
From: "Melvin C. Etheridge"
Can someone tell me what I'm doing wrong???
W2K, MySQL 4.0.12, PHP 4.3.1
I get the following error when I try to log on:
[Tue Jul 22 12:53:56 2003][Notice][Kernel::System::Auth::DB::Auth] User: admin with wrong Pw!!! (REMOTE_ADDR: x.x.x.x)
I checked the pw in the database and it is correct.
Please Help!
Thanks,
Mel
----- Original Message ----- From: "Martin Edenhofer"
To: Sent: Wednesday, July 23, 2003 8:09 AM Subject: Re: [otrs] Utilites - Open Tickets Hi Peter,
On Tue, Jul 22, 2003 at 02:36:18PM +0200, web4.hm - Peter Padberg wrote:
We get a lot of spam and virus detected mails which I procmail to the We use qconfirm with otrs and qmail. And it works perfect. But when I remember right procmail is for postfix, yes? Perhaps there is something as qconfirm for postfix?
Yes, procmail is an email filter to modify email. I thinks it's similar to qconfirm!?
Procmail (http://www.procmail.org/) can also be used with other MTAs like sendmail, exim, ...
See also the OTRS online doc to learn how it work with OTRS. :)
We also have a lot of faxes (as pdf attachements) entering into the system. Any experience with OCR (*.pdf to *.txt converters) and OTRS? Look at the pdf converter from phpMySearch.web4.hm. It was in php, but it works.
Cool! :)
Gruss, Peter.
-Martin
-- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.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

Hello, how did you set up your db-installation for otrs? using the installer.pl file or manually? Best! Dan Melvin C. Etheridge wrote:
Now I'm getting this error!!!!!!!!1
Error: Access denied for user: 'otrs@12.31.84.8' (Using password: YES)
----- Original Message ----- From: "Melvin C. Etheridge"
To: Sent: Wednesday, July 23, 2003 9:00 AM Subject: [otrs] Help! I still cannot log on!!! Can someone tell me what I'm doing wrong???
W2K, MySQL 4.0.12, PHP 4.3.1
I get the following error when I try to log on:
[Tue Jul 22 12:53:56 2003][Notice][Kernel::System::Auth::DB::Auth] User: admin with wrong Pw!!! (REMOTE_ADDR: x.x.x.x)
I checked the pw in the database and it is correct.
Please Help!
Thanks,
Mel
----- Original Message ----- From: "Martin Edenhofer"
To: Sent: Wednesday, July 23, 2003 8:09 AM Subject: Re: [otrs] Utilites - Open Tickets Hi Peter,
On Tue, Jul 22, 2003 at 02:36:18PM +0200, web4.hm - Peter Padberg wrote:
We get a lot of spam and virus detected mails which I procmail to
the
We use qconfirm with otrs and qmail. And it works perfect. But when I remember right procmail is for postfix, yes? Perhaps there is something as qconfirm for postfix?
Yes, procmail is an email filter to modify email. I thinks it's similar to qconfirm!?
Procmail (http://www.procmail.org/) can also be used with other MTAs like sendmail, exim, ...
See also the OTRS online doc to learn how it work with OTRS. :)
We also have a lot of faxes (as pdf attachements) entering into the
system.
Any experience with OCR (*.pdf to *.txt converters) and OTRS?
Look at the pdf converter from phpMySearch.web4.hm. It was in php, but it works.
Cool! :)
Gruss, Peter.
-Martin
-- Martin Edenhofer - <martin at edenhofer.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
_______________________________________________ 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

I've done both.... I have since done a manual install using phpMyAdmin as
the int.
This is what I get in the otrs.log file now:
[Wed Jul 23 19:54:09 2003][Notice][Kernel::System::Auth::DB::Auth] User:
root@localhost logged in (REMOTE_ADDR: 65.x.x.x).
However, on by browser the web page times out with "page cannot be
displayed".
Thanks,
Mel
----- Original Message -----
From: "Daniel Schönland"
Hello,
how did you set up your db-installation for otrs?
using the installer.pl file or manually?
Best!
Dan
Melvin C. Etheridge wrote:
Now I'm getting this error!!!!!!!!1
Error: Access denied for user: 'otrs@12.31.84.8' (Using password: YES)
----- Original Message ----- From: "Melvin C. Etheridge"
To: Sent: Wednesday, July 23, 2003 9:00 AM Subject: [otrs] Help! I still cannot log on!!! Can someone tell me what I'm doing wrong???
W2K, MySQL 4.0.12, PHP 4.3.1
I get the following error when I try to log on:
[Tue Jul 22 12:53:56 2003][Notice][Kernel::System::Auth::DB::Auth] User: admin with wrong Pw!!! (REMOTE_ADDR: x.x.x.x)
I checked the pw in the database and it is correct.
Please Help!
Thanks,
Mel
----- Original Message ----- From: "Martin Edenhofer"
To: Sent: Wednesday, July 23, 2003 8:09 AM Subject: Re: [otrs] Utilites - Open Tickets Hi Peter,
On Tue, Jul 22, 2003 at 02:36:18PM +0200, web4.hm - Peter Padberg wrote:
We get a lot of spam and virus detected mails which I procmail to
the
We use qconfirm with otrs and qmail. And it works perfect. But when I remember right procmail is for postfix, yes? Perhaps there is something as qconfirm for postfix?
Yes, procmail is an email filter to modify email. I thinks it's similar to qconfirm!?
Procmail (http://www.procmail.org/) can also be used with other MTAs like sendmail, exim, ...
See also the OTRS online doc to learn how it work with OTRS. :)
We also have a lot of faxes (as pdf attachements) entering into the
system.
Any experience with OCR (*.pdf to *.txt converters) and OTRS?
Look at the pdf converter from phpMySearch.web4.hm. It was in php, but it works.
Cool! :)
Gruss, Peter.
-Martin
-- Martin Edenhofer - <martin at edenhofer.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
_______________________________________________ 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

I Give Up!!!!
Mel
----- Original Message -----
From: "Melvin C. Etheridge"
Can someone tell me what I'm doing wrong???
W2K, MySQL 4.0.12, PHP 4.3.1
I get the following error when I try to log on:
[Tue Jul 22 12:53:56 2003][Notice][Kernel::System::Auth::DB::Auth] User: admin with wrong Pw!!! (REMOTE_ADDR: x.x.x.x)
I checked the pw in the database and it is correct.
Please Help!
Thanks,
Mel
----- Original Message ----- From: "Martin Edenhofer"
To: Sent: Wednesday, July 23, 2003 8:09 AM Subject: Re: [otrs] Utilites - Open Tickets Hi Peter,
On Tue, Jul 22, 2003 at 02:36:18PM +0200, web4.hm - Peter Padberg wrote:
We get a lot of spam and virus detected mails which I procmail to the We use qconfirm with otrs and qmail. And it works perfect. But when I remember right procmail is for postfix, yes? Perhaps there is something as qconfirm for postfix?
Yes, procmail is an email filter to modify email. I thinks it's similar to qconfirm!?
Procmail (http://www.procmail.org/) can also be used with other MTAs like sendmail, exim, ...
See also the OTRS online doc to learn how it work with OTRS. :)
We also have a lot of faxes (as pdf attachements) entering into the system. Any experience with OCR (*.pdf to *.txt converters) and OTRS? Look at the pdf converter from phpMySearch.web4.hm. It was in php, but it works.
Cool! :)
Gruss, Peter.
-Martin
-- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.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

Hi Mel, On Wed, Jul 23, 2003 at 01:29:32PM -0400, Melvin C. Etheridge wrote:
I Give Up!!!!
However... but I think you should know that the mysql database account (login) is different from the OTRS user accounts (logins).
Mel
-Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ --

Look at the pdf converter from phpMySearch.web4.hm. It was in php, but it works.
Cool! :) @Martin: Do you have any interests to include pdf2html sxw2html doc2html xls2html converter in otrs?
Shell I support this for otrs? -- _________________________________________________________________ Peter Padberg Pyrmonter Str. 42 Webagentur web4.hm 31789 Hameln Geschaeftsfuehrung Germany Telefon: +49-5151 60 99 70-0 Peter.Padberg@web4.hm Telefax: +49-5151 60 99 70-1 http://web4.hm _________________________________________________________________

Hi Paul, On Tue, Jul 22, Paul Rhein wrote:
2) We also have a lot of faxes (as pdf attachements) entering into the system. Any experience with OCR (*.pdf to *.txt converters) and OTRS? Would you address this via Generic Agent and CMD ?
I'd suggest some sort of procmailrule which pipes the fax to an OCR software and than pipes the results into the OTRS. The experience with OCR are very mixed. It depends very much on your clients. You pretty much have to try it. Gruss Stefan Wintermeyer -- Stefan Wintermeyer Attention, this is principal Skinner, your Principal, with a message from the principal's office. (Principal Seymour Skinner) "The Simpsons"

Hi Paul, On Tue, Jul 22, 2003 at 02:20:19PM +0200, Paul Rhein wrote:
We run OTRS 1.1.2 under Red Hat 8.0 on a 2-way compaq server, about 40 agents and ca. 400 tickets a day (mostly phone view for now) handeling 200 k customers.
First of all: OTRS is absolutely great, thanks for sharing it !!
Fine! :)
Been live with OTRS for about three weeks (and incrfeasingly happy about it) I have a few questions:
1) We get a lot of spam and virus detected mails which I procmail to the "Virus" queue. I wrote an GenericAgent.pm to "close-successfull" those tickets. Does the Generic Agent produce any log file or debug information ? If so where can I find it ?
There is no Generic Agent log file. You just can see it in the ticket history.
2) We also have a lot of faxes (as pdf attachements) entering into the system. Any experience with OCR (*.pdf to *.txt converters) and OTRS? Would you address this via Generic Agent and CMD ?
Like Stefan wrote, the best way would be to do this with procmail to generate the txt messages and then pipe it into your OTRS system.
3) I would like to see more lines under ADMINSTRATOR SYSTEM LOG.
In OTRS 1.2 you will be able to set the cache-log-size. Default is 4k. In future you can use a config option to change it: $Self->{LogSystemCacheSize} = 8*1024; And your ADMINSTRATOR SYSTEM LOG will be longer.
4) mysql I changed the customer_user table adding phone number and adress information then I loaded about 750 K records into customer_user. As a result the phone view "SEARCH CUSTOMER" took around 8 seconds to find the customer. I read some doc and then I added a few indexes in the db and changed the queries. I think this could be useful to other people too, I would like to share this, where should I post it ?
Post it on this list ... and I will take it to the doc... .-)
Can we migrate the db to mysql 4.0 ? Experience ? Is it scheduled ? What release ?
You can migrate the mysql 4.0. There should be no problem. Do you use innodb?
Thanks for the help and your soft. It is bitching good !
Thanks for your feedback! .->
Paul Rhein EPT Luxembourg
-Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ --
participants (6)
-
Daniel Schönland
-
Martin Edenhofer
-
Melvin C. Etheridge
-
Paul Rhein
-
Stefan Wintermeyer
-
web4.hm - Peter Padberg