- otrs - OTRS mailing lists

RE: [otrs] Webserver (Apache) httpd.conf
by Dan Rau 26 Jun '02

26 Jun '02

Thank you for the reply. I added a <VirtualHost> as follows: <VirtualHost xxx.xxx.xxx.xxx:80> User otrs Group users DocumentRoot /opt/OpenTRS ServerName help.mydomain.com </VirtualHost> When I ran apachectl configtest, I received the following error: "User cannot occur within <VirtualHost> section" I'm running Apache 2.0.36 (can't get the .39 version to compile) Can you paste in your <VirtualHost> section? Thank you, Dan Rau 303-394-3006 (office) 303-619-1904 (mobile) 630-566-3378 (fax) -----Original Message----- From: Pablo Ruiz Garcia [mailto:pruiz@ip6seguridad.com] Sent: Tuesday, June 25, 2002 12:59 AM To: otrs(a)otrs.org Subject: Re: [otrs] Webserver (Apache) httpd.conf Use a VirtualHost directive with a new user/group, I do that ;) -- Pablo Ruiz Garcia (Pci) Consultor de Seguridad - Tiger Team IP6 Seguridad (pruiz(a)ip6seguridad.com) http://www.ip6seguridad.com/pgp/pruiz.asc ----- Original Message ----- From: "Dan Rau" <drau(a)thomacressey.com> To: <otrs(a)otrs.org> Sent: Tuesday, June 25, 2002 1:37 AM Subject: [otrs] Webserver (Apache) httpd.conf > The README.webserver instructions says: > "Change the webserver user (normaly wwwrun) to the OpenTRS user > (otrs)." > > I run my webserver as user "nobody" and it is not possible to change > it to something else since I have many sites hosted here that are > currently using "nobody". > > When replying to a support email, I get the following error: > > mkdir /opt/OpenTRS/var/article/2002/06/24/30: Permission denied at > ../../Kernel/System/Article.pm line 124 > > The ownership for those folders is otrs:users If I change ownership to > nobody:nobody, it will work for this session but the next sessions > tries to do the mkdir as otrs again. > > Is it possible to make OTRS use nobody:nobody as my user name and > group name? > > Dan Rau > 303-394-3006 (office) > 303-619-1904 (mobile) > 630-566-3378 (fax) > _______________________________________________ > OpenTRS mailing list: otrs - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/otrs > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs > _______________________________________________ OpenTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

1 0

RE: [otrs] Qmail and OTRS
by Dan Rau 25 Jun '02

25 Jun '02

Changing "otrs(a)mydomain.com" to simply "otrs" did the trick. My qmail is adding the "@mydomain.com" . I've added a .qmail-support entry in otrs(a)mydomain.com with "| /var/qmail/bin/preline procmail" in it and I'm now getting my mail processed into the otrs system. Thank you very much, Dan Rau 303-394-3006 (office) 303-619-1904 (mobile) 630-566-3378 (fax) -----Original Message----- From: Martin Edenhofer [mailto:martin@edenhofer.de] Sent: Saturday, June 22, 2002 3:14 PM To: otrs(a)otrs.org Subject: Re: [otrs] Qmail and OTRS Hi Dan, On Sat, Jun 22, 2002 at 02:46:01PM -0500, Dan Rau wrote: > I'm still getting a bounced message (no such mailbox)to the sender of > mail addressed to support(a)mydomain.com. See the transcript from my > mail log below. > > The email address that I am trying to get to otrs@localhost is > support(a)mydomain.com > > I put the following line in ~optrs/.qmail "| /var/qmail/bin/preline > procmail" > > In the folder /home/vpopmail/domains/mydomain.com is a file > .qmail-support that simply has "&otrs@localhost" in it. > > I do not have a file called .qmail-support in my /var/qmail/alias > folder. > > I will settle for using an alias since there will be very few queues > on this system so I don't mind manually adding aliases if necessary. Ok. It looks like qmail is looking for user otrs@localhost. Try just otrs instead of otrs@localhost (be sure that the user otrs exists). Still a bounced message? ;-/ > Thanks, > > Dan Rau Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- Old programmers never die. They just branch to a new address. _______________________________________________ OpenTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

2 1

Webserver (Apache) httpd.conf
by Dan Rau 25 Jun '02

25 Jun '02

The README.webserver instructions says: "Change the webserver user (normaly wwwrun) to the OpenTRS user (otrs)." I run my webserver as user "nobody" and it is not possible to change it to something else since I have many sites hosted here that are currently using "nobody". When replying to a support email, I get the following error: mkdir /opt/OpenTRS/var/article/2002/06/24/30: Permission denied at ../../Kernel/System/Article.pm line 124 The ownership for those folders is otrs:users If I change ownership to nobody:nobody, it will work for this session but the next sessions tries to do the mkdir as otrs again. Is it possible to make OTRS use nobody:nobody as my user name and group name? Dan Rau 303-394-3006 (office) 303-619-1904 (mobile) 630-566-3378 (fax)

2 1

No autoresponse and notify mails
by Tom Schröder 24 Jun '02

24 Jun '02

Hi, is there any cronjob that will handle the autoresponse or notify mails? I activated them in the configuration but get no mail. "Normal" answer mails from an agent are working just fine. Maybe you have a point where I can look to track this issue. have fun, bye!tom -- Tom Schroeder Systemadministrator _____________________________________________________________________ TILL.DE Internet Solutions fon 0531 . 39023921 Arlette S. Riediger fax 0531 . 39023929 Hamburger Str. 273a mailto: ts(a)till.de 38114 Braunschweig http://www.till.de

2 6

help with inital postgres tables !??
by Scott Brewerton 24 Jun '02

24 Jun '02

hi I've just CSV'd down OpenTRS, but I'm having some trouble trying to use it with Postgres (I know it's only really been tested with MySQL, but I am being forced to use Postgres from higher up) when I try to run the table creation script, it doesn't seem to like the (0) after the timestamp entries !! will it harm the system if I remove them so the entries simply read create_time timestamp NOT NULL, create_by integer NOT NULL, change_time timestamp NOT NULL, change_by integer NOT NULL, ?? it is also complaining about 'serial8' on the 'article' table :o( any hints on how to force the tables and seeding process through ?? thanks _scott

3 5

Definition of a Ticket Number
by Stefan Schmidt 24 Jun '02

24 Jun '02

Hi, where can I define, how the ticket number is composed? In Config.pm I found the System ID. The rest of the number is an increasing count. Can I define something like it was in STTS, eg. Date, System IT, daily count? TIA, Stefan -- Stefan Schmidt Email: jsj(a)jsj.dyndns.org jsj(a)exsuse.de Bremen jsj-hb(a)t-online.de s.schmidt(a)iu-bremen.de

2 3

OpenTRS logo wanted!
by Martin Edenhofer 23 Jun '02

23 Jun '02

Hi, we need a OpenTRS logo for our website and banners for friendly websites. Any suggestions? PS: Your help is very appreciated! Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- Old programmers never die. They just branch to a new address.

1 0

RE: [otrs] Qmail and OTRS
by Dan Rau 22 Jun '02

22 Jun '02

I'm still getting a bounced message (no such mailbox)to the sender of mail addressed to support(a)mydomain.com. See the transcript from my mail log below. The email address that I am trying to get to otrs@localhost is support(a)mydomain.com I put the following line in ~optrs/.qmail "| /var/qmail/bin/preline procmail" In the folder /home/vpopmail/domains/mydomain.com is a file .qmail-support that simply has "&otrs@localhost" in it. I do not have a file called .qmail-support in my /var/qmail/alias folder. I will settle for using an alias since there will be very few queues on this system so I don't mind manually adding aliases if necessary. Thanks, Dan Rau 303-394-3006 (office) 303-619-1904 (mobile) 630-566-3378 (fax) <<<<snip>>>>> 2002-06-22 12:36:34.610791500 info msg 736913: bytes 685 from <drau(a)xxx.com> qp 5988 uid 505 2002-06-22 12:36:34.613134500 starting delivery 1: msg 736913 to local mydomain.com-support(a)mydomain.com 2002-06-22 12:36:34.613143500 status: local 1/10 remote 0/20 2002-06-22 12:36:34.622230500 new msg 737477 2002-06-22 12:36:34.622235500 info msg 737477: bytes 796 from <drau(a)xxx.com> qp 5990 uid 89 2002-06-22 12:36:34.624989500 starting delivery 2: msg 737477 to local otrs@localhost 2002-06-22 12:36:34.624997500 status: local 2/10 remote 0/20 2002-06-22 12:36:34.625002500 delivery 1: success: did_0+1+0/qp_5990/ 2002-06-22 12:36:34.625007500 status: local 1/10 remote 0/20 2002-06-22 12:36:34.625012500 end msg 736913 2002-06-22 12:36:34.631792500 delivery 2: failure: Sorry,_no_mailbox_here_by_that_name._(#5.1.1)/ 2002-06-22 12:36:34.631801500 status: local 0/10 remote 0/20 2002-06-22 12:36:34.637398500 bounce msg 737477 qp 5993 2002-06-22 12:36:34.637404500 end msg 737477 2002-06-22 12:36:34.637407500 new msg 737478 2002-06-22 12:36:34.637411500 info msg 737478: bytes 1332 from <> qp 5993 uid 510 2002-06-22 12:36:34.639789500 starting delivery 3: msg 737478 to remote drau(a)xxx.com 2002-06-22 12:36:34.639798500 status: local 0/10 remote 1/20 2002-06-22 12:36:35.159816500 delivery 3: success: 216.87.86.2_accepted_message./Remote_host_said:_250_OK/ <<<<snip>>>>> -----Original Message----- From: Martin Edenhofer [mailto:martin@edenhofer.de] Sent: Saturday, June 22, 2002 6:13 AM To: otrs(a)otrs.org Subject: Re: [otrs] Qmail and OTRS Hi Dan, On Thu, Jun 20, 2002 at 11:15:26PM -0500, Dan Rau wrote: > I've installed OpenTRS on a Suse 7.3 system that has QMAIL as my MDA > (both POP and SMTP). > > Does anyone have a sample on how to configure qmail to receive an > email to one of my locally hosted domains (help(a)domain.com > <mailto:help@domain.com> for example) and forward it to > otrs@localhost? Or is there a way to get OpenTRS to check a specific > mailbox that is hosted on this machine? > > I tried creating a .qmail-help file that forwards to otrs@localhost > but it just bounces back to the sender. I know it! ;-) Use Procmail: Put '| preline procmail' into ~otrs/.qmail. They will need to use a full path for procmail unless procmail is in the system's startup PATH. (Source http://es.qmail.org/documentacion/autor/FAQ/html/qmail-FAQ-8.html#ss8.7) Deliver a mail to the user otrs@localhost and bin/PostMaster.pl will handle this email. PS0: a maildir or aliases would also work. But if you use procmail, you can use advanced dispatching of incoming emails (see http://otrs.org/pages/index.pl?Action=Ext&Site=Docu/xheader_otrs_queue.html) PS1: A feedback would be nice, so I can put it to the OpenTRS docu! Thanks. > Thanks, > > Dan Rau Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- Old programmers never die. They just branch to a new address. _______________________________________________ OpenTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

2 1

RE: [otrs] Qmail and OTRS
by Dan Rau 22 Jun '02

22 Jun '02

Wow, that was an ugly snip. Sorry about that. Here it is formatted properly: <<<<snip>>>>> 2002-06-22 12:36:34.610791500 info msg 736913: bytes 685 from <drau(a)xxx.com> qp 5988 uid 505 2002-06-22 12:36:34.613134500 starting delivery 1: msg 736913 to local mydomain.com-support(a)mydomain.com 2002-06-22 12:36:34.613143500 status: local 1/10 remote 0/20 2002-06-22 12:36:34.622230500 new msg 737477 2002-06-22 12:36:34.622235500 info msg 737477: bytes 796 from <drau(a)xxx.com> qp 5990 uid 89 2002-06-22 12:36:34.624989500 starting delivery 2: msg 737477 to local otrs@localhost 2002-06-22 12:36:34.624997500 status: local 2/10 remote 0/20 2002-06-22 12:36:34.625002500 delivery 1: success: did_0+1+0/qp_5990/ 2002-06-22 12:36:34.625007500 status: local 1/10 remote 0/20 2002-06-22 12:36:34.625012500 end msg 736913 2002-06-22 12:36:34.631792500 delivery 2: failure: Sorry,_no_mailbox_here_by_that_name._(#5.1.1)/ 2002-06-22 12:36:34.631801500 status: local 0/10 remote 0/20 2002-06-22 12:36:34.637398500 bounce msg 737477 qp 5993 2002-06-22 12:36:34.637404500 end msg 737477 2002-06-22 12:36:34.637407500 new msg 737478 2002-06-22 12:36:34.637411500 info msg 737478: bytes 1332 from <> qp 5993 uid 510 2002-06-22 12:36:34.639789500 starting delivery 3: msg 737478 to remote drau(a)xxx.com 2002-06-22 12:36:34.639798500 status: local 0/10 remote 1/20 2002-06-22 12:36:35.159816500 delivery 3: success: 216.87.86.2_accepted_message./Remote_host_said:_250_OK/ <<<<snip>>>>> Dan Rau 303-394-3006 (office) 303-619-1904 (mobile) 630-566-3378 (fax) -----Original Message----- From: Dan Rau Sent: Saturday, June 22, 2002 1:46 PM To: 'otrs(a)otrs.org' Subject: RE: [otrs] Qmail and OTRS I'm still getting a bounced message (no such mailbox)to the sender of mail addressed to support(a)mydomain.com. See the transcript from my mail log below. The email address that I am trying to get to otrs@localhost is support(a)mydomain.com I put the following line in ~optrs/.qmail "| /var/qmail/bin/preline procmail" In the folder /home/vpopmail/domains/mydomain.com is a file .qmail-support that simply has "&otrs@localhost" in it. I do not have a file called .qmail-support in my /var/qmail/alias folder. I will settle for using an alias since there will be very few queues on this system so I don't mind manually adding aliases if necessary. Thanks, Dan Rau 303-394-3006 (office) 303-619-1904 (mobile) 630-566-3378 (fax) <<<<snip>>>>> 2002-06-22 12:36:34.610791500 info msg 736913: bytes 685 from <drau(a)xxx.com> qp 5988 uid 505 2002-06-22 12:36:34.613134500 starting delivery 1: msg 736913 to local mydomain.com-support(a)mydomain.com 2002-06-22 12:36:34.613143500 status: local 1/10 remote 0/20 2002-06-22 12:36:34.622230500 new msg 737477 2002-06-22 12:36:34.622235500 info msg 737477: bytes 796 from <drau(a)xxx.com> qp 5990 uid 89 2002-06-22 12:36:34.624989500 starting delivery 2: msg 737477 to local otrs@localhost 2002-06-22 12:36:34.624997500 status: local 2/10 remote 0/20 2002-06-22 12:36:34.625002500 delivery 1: success: did_0+1+0/qp_5990/ 2002-06-22 12:36:34.625007500 status: local 1/10 remote 0/20 2002-06-22 12:36:34.625012500 end msg 736913 2002-06-22 12:36:34.631792500 delivery 2: failure: Sorry,_no_mailbox_here_by_that_name._(#5.1.1)/ 2002-06-22 12:36:34.631801500 status: local 0/10 remote 0/20 2002-06-22 12:36:34.637398500 bounce msg 737477 qp 5993 2002-06-22 12:36:34.637404500 end msg 737477 2002-06-22 12:36:34.637407500 new msg 737478 2002-06-22 12:36:34.637411500 info msg 737478: bytes 1332 from <> qp 5993 uid 510 2002-06-22 12:36:34.639789500 starting delivery 3: msg 737478 to remote drau(a)xxx.com 2002-06-22 12:36:34.639798500 status: local 0/10 remote 1/20 2002-06-22 12:36:35.159816500 delivery 3: success: 216.87.86.2_accepted_message./Remote_host_said:_250_OK/ <<<<snip>>>>> -----Original Message----- From: Martin Edenhofer [mailto:martin@edenhofer.de] Sent: Saturday, June 22, 2002 6:13 AM To: otrs(a)otrs.org Subject: Re: [otrs] Qmail and OTRS Hi Dan, On Thu, Jun 20, 2002 at 11:15:26PM -0500, Dan Rau wrote: > I've installed OpenTRS on a Suse 7.3 system that has QMAIL as my MDA > (both POP and SMTP). > > Does anyone have a sample on how to configure qmail to receive an > email to one of my locally hosted domains (help(a)domain.com > <mailto:help@domain.com> for example) and forward it to > otrs@localhost? Or is there a way to get OpenTRS to check a specific > mailbox that is hosted on this machine? > > I tried creating a .qmail-help file that forwards to otrs@localhost > but it just bounces back to the sender. I know it! ;-) Use Procmail: Put '| preline procmail' into ~otrs/.qmail. They will need to use a full path for procmail unless procmail is in the system's startup PATH. (Source http://es.qmail.org/documentacion/autor/FAQ/html/qmail-FAQ-8.html#ss8.7) Deliver a mail to the user otrs@localhost and bin/PostMaster.pl will handle this email. PS0: a maildir or aliases would also work. But if you use procmail, you can use advanced dispatching of incoming emails (see http://otrs.org/pages/index.pl?Action=Ext&Site=Docu/xheader_otrs_queue.html) PS1: A feedback would be nice, so I can put it to the OpenTRS docu! Thanks. > Thanks, > > Dan Rau Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- Old programmers never die. They just branch to a new address. _______________________________________________ OpenTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs _______________________________________________ OpenTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

1 0

Qmail and OTRS
by Dan Rau 22 Jun '02

22 Jun '02

I've installed OpenTRS on a Suse 7.3 system that has QMAIL as my MDA (both POP and SMTP). Does anyone have a sample on how to configure qmail to receive an email to one of my locally hosted domains (help(a)domain.com <mailto:help@domain.com> for example) and forward it to otrs@localhost? Or is there a way to get OpenTRS to check a specific mailbox that is hosted on this machine? I tried creating a .qmail-help file that forwards to otrs@localhost but it just bounces back to the sender. Any help would be appreciated. Thanks, Dan Rau 303-394-3006 (office) 303-619-1904 (mobile) 630-566-3378 (fax)

2 1