January 2004 - otrs - OTRS mailing lists

RE: [otrs] Cannot login as root@localhost
by Lars Monsees 07 Jan '04

07 Jan '04

Hello Norbert, the algorithm used in otrs is different from password(). Maybe you know the password of an agent. Set the password for root the same as for the agent (via sql query) and then you should be able to login. Lars > -----Original Message----- > From: otrs-bounces(a)otrs.org > [mailto:otrs-bounces@otrs.org]On Behalf Of > norbert(a)munkel.net > Sent: Wednesday, January 07, 2004 2:47 PM > To: otrs(a)otrs.org > Subject: [otrs] Cannot login as root@localhost > > > Hi, > > I was a bit lazy when I set up a otrs for some colleages. > Worked fine for a > while but now I need some new user accounts. > > Unfortunally, I forgot the password of root(a)localhost.;-) > > What I did, is changing the password in the database: > > update system_user set pw=password('foobar') where id=1; > > The database has been flushed, reloaded, restarted several > times since the > change but I still can't login as root@localhost. > > I tried rcotrs restart-force as well. No effect. > > Any hint? Thanks! > > cu, > > Norbert > _______________________________________________ > 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/ >

2 1

Cannot login as root@localhost
by norbert＠munkel.net 07 Jan '04

07 Jan '04

Hi, I was a bit lazy when I set up a otrs for some colleages. Worked fine for a while but now I need some new user accounts. Unfortunally, I forgot the password of root(a)localhost.;-) What I did, is changing the password in the database: update system_user set pw=password('foobar') where id=1; The database has been flushed, reloaded, restarted several times since the change but I still can't login as root@localhost. I tried rcotrs restart-force as well. No effect. Any hint? Thanks! cu, Norbert

2 1

Fetching mail with embedded objects/screendumps
by Thomas Nilsen 07 Jan '04

07 Jan '04

Does anyone know if there is a fetchmail alternative that will retrieve emails from an Exchange server that has embedded objects like screendumps, pictures etc? Grabbing this with fetchmail using POP3 will leave the embedded objects out of the email as they don't conform to the SMTP standard I guess. I think an imap client would be better here, as it would allow fetching of attachments - but fetchmail will ignore these emails all together when using IMAP... We kind of need this before we can implement OTRS in our organisation, as a lot of the emails we get contains screen dumps of error messages etc, and it's too much of a hassle to have the user past the data into a document to insert. Regards, Thomas Nilsen Svg Support Tel: +47 51 81 01 30 - Mob: +47 916 98 229 DISCLAIMER: This message contains information that may be privileged or confidential and is the property of the Roxar Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorised to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message.

2 1

Overloaded otrs queue
by Neil Lehouillier 07 Jan '04

07 Jan '04

I have a small question..... How do you manual go into mysql and delete messages in the raw queue? It seems that over the holidays the otrs system created 88000 messages and put them in the raw queue. Now I can't even get otrs working properly anymore. I want to manual go into the mysql database and delete all the messages in the raw queue. Does anyone know how to do this? Thanks.... Neil

3 2

Re: To: fields in OTRS and other things
by Raza Rizvi 07 Jan '04

07 Jan '04

>> Can you have escalation work by altering the priority on a creeping >> basis? ie. After x minutes, it goes from priority a to priority b and >> then to priority c (is this a job for GenericAgent!)? I have thought >> about just moving tickets between queues to do this sort of thing. > > This will not work with the GenericAgent yet. But it shoud work with OTRS > 1.2 brcause you can search for tickets older then x minutes with state xy > and priority lala. and when is 1.2 slated for release :-) Raza

2 1

RE: [otrs] Overloaded otrs queue
by Neil Lehouillier 06 Jan '04

06 Jan '04

Yes I can. -----Original Message----- From: otrs-bounces(a)otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Sam Nadeau Sent: Tuesday, January 06, 2004 1:46 PM To: User questions and discussions about OTRS. Subject: Re: [otrs] Overloaded otrs queue This will allow you to easily make query against your database. Can you see your OTRS database from phpmyadmin ? Sam ----- Original Message ----- From: Neil Lehouillier <mailto:NLehouillier@comptonpetroleum.com> To: User questions and discussions about OTRS. <mailto:otrs@otrs.org> Sent: Tuesday, January 06, 2004 3:40 PM Subject: RE: [otrs] Overloaded otrs queue Ok I've got in installed. Now what? I'm not very good with php so please be specific. Thanks in advance...... Neil -----Original Message----- From: otrs-bounces(a)otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Sam Nadeau Sent: Tuesday, January 06, 2004 11:08 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Overloaded otrs queue http://www.phpmyadmin.net/home_page/ google is your friend :-) Sam ----- Original Message ----- From: Neil Lehouillier <mailto:NLehouillier@comptonpetroleum.com> To: User questions and discussions about OTRS. <mailto:otrs@otrs.org> Sent: Tuesday, January 06, 2004 12:24 PM Subject: RE: [otrs] Overloaded otrs queue It seems that I don't. Where can I locate this program? Neil -----Original Message----- From: otrs-bounces(a)otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Sam Nadeau Sent: Tuesday, January 06, 2004 9:59 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Overloaded otrs queue Do you have phpmyadmin installed ?? I could help you solve this issue easily. Sam ----- Original Message ----- From: Neil Lehouillier <mailto:NLehouillier@comptonpetroleum.com> To: otrs(a)otrs.org Sent: Tuesday, January 06, 2004 11:50 AM Subject: [otrs] Overloaded otrs queue I have a small question..... How do you manual go into mysql and delete messages in the raw queue? It seems that over the holidays the otrs system created 88000 messages and put them in the raw queue. Now I can't even get otrs working properly anymore. I want to manual go into the mysql database and delete all the messages in the raw queue. Does anyone know how to do this? Thanks.... Neil _____ _______________________________________________ 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/ _____ _______________________________________________ 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/ _____ _______________________________________________ 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/

2 1

RE: [otrs] Overloaded otrs queue
by Neil Lehouillier 06 Jan '04

06 Jan '04

Ok I've got in installed. Now what? I'm not very good with php so please be specific. Thanks in advance...... Neil -----Original Message----- From: otrs-bounces(a)otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Sam Nadeau Sent: Tuesday, January 06, 2004 11:08 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Overloaded otrs queue http://www.phpmyadmin.net/home_page/ google is your friend :-) Sam ----- Original Message ----- From: Neil Lehouillier <mailto:NLehouillier@comptonpetroleum.com> To: User questions and discussions about OTRS. <mailto:otrs@otrs.org> Sent: Tuesday, January 06, 2004 12:24 PM Subject: RE: [otrs] Overloaded otrs queue It seems that I don't. Where can I locate this program? Neil -----Original Message----- From: otrs-bounces(a)otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Sam Nadeau Sent: Tuesday, January 06, 2004 9:59 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Overloaded otrs queue Do you have phpmyadmin installed ?? I could help you solve this issue easily. Sam ----- Original Message ----- From: Neil Lehouillier <mailto:NLehouillier@comptonpetroleum.com> To: otrs(a)otrs.org Sent: Tuesday, January 06, 2004 11:50 AM Subject: [otrs] Overloaded otrs queue I have a small question..... How do you manual go into mysql and delete messages in the raw queue? It seems that over the holidays the otrs system created 88000 messages and put them in the raw queue. Now I can't even get otrs working properly anymore. I want to manual go into the mysql database and delete all the messages in the raw queue. Does anyone know how to do this? Thanks.... Neil _____ _______________________________________________ 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/ _____ _______________________________________________ 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/

2 1

RE: [otrs] Overloaded otrs queue
by Neil Lehouillier 06 Jan '04

06 Jan '04

It seems that I don't. Where can I locate this program? Neil -----Original Message----- From: otrs-bounces(a)otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Sam Nadeau Sent: Tuesday, January 06, 2004 9:59 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Overloaded otrs queue Do you have phpmyadmin installed ?? I could help you solve this issue easily. Sam ----- Original Message ----- From: Neil Lehouillier <mailto:NLehouillier@comptonpetroleum.com> To: otrs(a)otrs.org Sent: Tuesday, January 06, 2004 11:50 AM Subject: [otrs] Overloaded otrs queue I have a small question..... How do you manual go into mysql and delete messages in the raw queue? It seems that over the holidays the otrs system created 88000 messages and put them in the raw queue. Now I can't even get otrs working properly anymore. I want to manual go into the mysql database and delete all the messages in the raw queue. Does anyone know how to do this? Thanks.... Neil _____ _______________________________________________ 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/

2 1

RE: [otrs] Where config the Auto-Answer and Ticket number
by Grimes, David 06 Jan '04

06 Jan '04

Did you configure the queue properties for notification? There is also user properties for notification as well... you probably checked those but I'm pretty sure that they are off by default. HTH DG -----Original Message----- From: Martin Edenhofer [mailto:me@otrs.de] Sent: Tuesday, January 06, 2004 8:01 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Where config the Auto-Answer and Ticket number Hi, On Mon, Jan 05, 2004 at 08:49:22PM +0100, Administration du Reseau wrote: > Hi > > two small question for a new user of OTRS > > I) > in OTRS 1.13, where we configure the auto-answer ? (sorry for my english) > > When i sent a email to my server, the ticket are created (good) but : > 1- The user that open the ticket don't receive the number etc ... > 2- The Technicien don't receive a information of a new tickets are created .. > > by cron, i start only PostMasterPOP3.pl for check the email, it's a other script that sent the auto-answer ? Auto-answer to customer after creating a new ticket: http://host/otrs/index.pl?Action=AdminQueueAutoResponse http://doc.otrs.org/1.1/html/auto-response.html#AUTO-RESPONSE-REPLY > II) > It is possible that put un ticket number ?: > 20040105.0019 or 20040105-0019 > (yearmounthday.ANumber at 4 digit) > If yes, where ? It's possible. You just need to create/modify a existing ticket number module. See also: http://doc.otrs.org/cvs/en/html/dev-custom-modules-ticketnumber.html > Thanks for your help Martin Edenhofer -- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Manage your communication! _______________________________________________ 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/

2 1

a small question ...
by Administration du Reseau 06 Jan '04

06 Jan '04

Hi i don't see where i can delete a "File" or a user ... i see only button "Modify" but never "Delete" ... Thanks for your help

2 1