- otrs - OTRS mailing lists

Sun Directory Server (LDAP) integration with OTRS 2.4.7
by Deniz Rende 24 Feb '10

24 Feb '10

Hello, I've been trying to figure out how to integrate our company ldap with OTRS 2.4.7 . Here is what I did so far that did not give me any results: 0) Installed Net::LDAP Module 1) From Admin -> SysConfig 2) Search for LDAP 3) Frontend::Customer::Auth 4) Edited the Following: - Customer::AuthModule::LDAP::Host (instead of default I added our ldap server) - Customer::AuthModule::LDAP::BaseDN (entered o=.....,o......) - Customer::AuthModule::LDAP::UID (left the default as UID) - Customer::AuthModule::LDAP::GroupDN (instead of the default I entered our cn, ,our ou=staff, our o's....) - Customer::AuthModule::LDAP::AccessAttr (left is as memberUid) 5) Created a test user in our ldap, and made sure that It was created (ldap searches from servers returned just fine) 6) Restarted the Apache server. 7) Tried to login with my testuser in https://otrshost/otrs/customer.pl and the login failed. Tried to get the password, but otrs informed me no such user... What else needs to be done for ldap integration? Do I need to go back to /opt/otrs/Kernel/Config.pm and add things or do the Web GUI method is enough? Here is what I am using Solaris 10 X86 Perl 5.10 Apache2 with SSL OTRS 2.4.7 check.Modules returns ok -- Deniz Rende E-mail: deniz.rende(a)gmail.com Phone: +1 (224) 789-UNIX (8649) Mobile: +1 (816) 213-2139 Web: http://www.deniz-rende.com/blog

2 1

How to discount the pending/close time from the solution time
by Estevam Viragh 24 Feb '10

24 Feb '10

Hi list, Perhaps I'm not doing it right but I'm trying to find a way to have the solutiontime discounting the time when the ticket stood on pending and also the time when it stood as closed. Below you have 1) Report Result and 2) Ticket_History query for this very ticket. Any clue anyone!?!?! Thx so much in advance. Ticket# Created Close Time Priority CustomerID SLA FirstResponse FirstResponseInMin SolutionTime SolutionInMin 1010 24/02/2010 11:12 24/02/2010 12:17 3 Normal IT P2 - 4hs 24/02/2010 11:45 33 24/02/2010 12:17 65 Ticket_History.id Ticket_History. Create_Time Ticket_History.Name Ticket_Status.Name Ticket_History_Type.Name 174 2010-02-24 11:36:02.467 %%new%%open%% open StateUpdate 181 2010-02-24 11:52:25.780 %%open%%pending auto close+%% pending auto close+ StateUpdate 185 2010-02-24 11:55:46.933 %%pending auto close+%%open%% open StateUpdate 189 2010-02-24 11:56:09.513 %%open%%closed successful%% closed successful StateUpdate 193 2010-02-24 12:08:23.937 %%closed successful%%open%% open StateUpdate 196 2010-02-24 12:09:19.267 %%open%%closed successful%% closed successful StateUpdate 198 2010-02-24 12:11:29.313 %%closed successful%%pending auto close+%% pending auto close+ StateUpdate 202 2010-02-24 12:16:48.423 %%pending auto close+%%open%% open StateUpdate 205 2010-02-24 12:17:00.827 %%open%%closed successful%% closed successful StateUpdate Regards / Saludos / Cordialmente, Estevam Viragh Technology Manager +55 11 4501-9426 T +55 11 4501-9436 F +55 11 7605-4538 M estevam.viragh(a)sitel.com <mailto:estevam.viragh@sitel.com> Sitel Achilles Orlando Curtolo, nº 499 Barra Funda - São Paulo 01144-010 Brasil +55 11 4501 940 www.sitel.com <http://www.sitel.com/> P Please consider the environment before printing this mail. **CONFIDENTIAL NOTICE** This e-mail and any files transmitted with it may contain PRIVILEGED or CONFIDENTIAL information and may be read or used only by the intended recipient. If you are not the intended recipient of the e-mail or any of its attachments, please be advised that you have received this e-mail in error and that any use, dissemination, distribution, forwarding, printing, or copying of this e-mail or any attached files is strictly prohibited. If you have received this e-mail in error, please immediately purge it and all attachments and notify the sender by reply e-mail.

1 0

Delete attachment of incoming mail
by Martignier, Philippe 24 Feb '10

24 Feb '10

Hi there, I come back with one of my request but with a proposition I want to use the Ticket::Frontend::MenuModule###460-Delete Not to delete the ticket but delete all attachments I saw in the API doc that line: ArticleDeleteAttachment() delete all attachments of an article $TicketObject->ArticleDeleteAttachment( ArticleID => 123, UserID => 123, ); How should I modify the code in order to have this function ... I have one department saying they don't want to use OTRS because of that feature missing, so it is really IMPORTANT for me to solve that quickly :) (defending part of my job :) MANY THANKS Bye Phil Philippe Martignier Communications Division Customer Service Section Email : Philippe.Martignier(a)wipo.int<mailto:Philippe.Martignier@wipo.int> Phone : 00 41 022 338 72 36 Building : GB II Office : 0,3 World Intellectual Property Organization Disclaimer: This electronic message may contain privileged, confidential and copyright protected information. If you have received this e-mail by mistake, please immediately notify the sender and delete this e-mail and all its attachments. Please ensure all e-mail attachments are scanned for viruses prior to opening or using.

1 0

Re: [otrs] importing customer users from a csv file
by Alessandro Cortiana 24 Feb '10

24 Feb '10

ciao Marco, > The problem with a trial that I made is with the password of the user > created... (could be solved with the Lost your password? from the > customer.pl ?) In my environment there is no password problem. I can temporarily set a default password and I can instruct the customer to change the password on first login. > insert into customer_user > (login,email,customer_id,first_name,last_name,valid_id,create_time,create_by,change_time,change_by) > values ('prova', 'prova(a)prova.it', 'prova', 'p', 'p', 1, sysdate(), 1, > sysdate(), 1) I did a test to try to understand what database modifications are made when I add a customer user. I found modifications in two tables: customer_users -> one row customer_preferences -> many rows Doing an insert like you propose is enough? Or I also have to insert entries on the customer_preferences table? Thanks, Alessandro Cortiana

2 1

Re: [otrs] otrs Digest, Vol 17, Issue 127
by Richard Cross 24 Feb '10

24 Feb '10

On 22 Feb 2010, at 14:55, otrs-request(a)otrs.org wrote: > Richard Cross wrote : >> Thanks, but that post seems to describe the solution I mentioned >> above, which is not what I'm looking for. >> I found that the easiest way around this problem is to use the FAQ >> facility and create new FAQ entries with the content I need to send >> in the "Symptom" field. Then, when creating a New Email Ticket, I >> can then select the appropriate FAQ and it gets pasted into the email >> body. > > Hello Richard, > > the FAQ way is a clever workaround. The quicktickets work similiar, you can define buttons per screen and on button click they set predefined values for the HTML controls of the screen. In this way you can insert a predefined text in a text form. Just give them a try, IMHO this would be easier to use than the FAQ way. I would give them a try, but I see nothing in the OTRS documentation about this feature, that mail posting mentioned previously is over 2 years old and the target files I'm supposed to edit do not contain the commented out code that is referred to. If this every becomes a properly implemented and supported feature (ideally one that can be configured through the UI rather than hacking perl files), I'd be happy to use it. In the meantime, using the FAQ works just fine and I can guarantee that my live OTRS remains in a supportable (and upgradable) state. Richard Cross.

1 0

importing customer users from a csv file
by Alessandro Cortiana 24 Feb '10

24 Feb '10

I have a CentOS with OTRS installed. I need to import a lot of customer users into the otrs database. These users are stored in a csv file. Is there any way to do this automatically (via script or via the GUI)? If not, what do you suggest? Thanks, Alessandro Cortiana

3 2

Stats
by Guy Baxter 24 Feb '10

24 Feb '10

Hi, I have OTRS 2.4.7 installed on an intel mac mini for testing. I have muddled my way through the setup of emails, users and queues quite well, but have become stuck at stats. I want to create some stats, firstly to display tickets opened in a week: Information about the Stat Stat#: 10012 Title: Tech Support - Tickets per Week Object: TicketAccumulation Description: Stats to show tickets for a week Format: graph-lines-points Graphsize: 800x600 Sum rows: No Sum columns: Yes Cache: No Valid: valid X-axis Create Time: The last 7 day(s) Scale: 1 day(s) Value Series Queue: Technical Support Restrictions No element selected. I however get: Error: To much data, can't use it with graph ERROR: OTRS-CGI-10 Perl: 5.10.0 OS: linux Time: Wed Feb 24 10:19:00 2010 Message: GenerateGraph: Need GD! Traceback (3669): Module: Kernel::System::Stats::GenerateGraph (v1.80.2.1) Line: 1650 Module: Kernel::Modules::AgentStats::Run (v1.74.2.2) Line: 2179 Module: Kernel::System::Web::InterfaceAgent::Run (v1.43.2.1) Line: 819 Module: /opt/otrs/bin/cgi-bin/index.pl (v1.88) Line: 48 Could anyone help please? This email and any attachments are confidential and are intended solely for the use of the individual to whom it is addressed. If you are not the intended recipient of this email and its attachments, you must take no action based upon them, nor must you copy or show them to anyone. Please contact the sender if you believe you have received this email in error. Emails are not secure and cannot be guaranteed to be free of errors or viruses. It is your responsibility to scan emails and attachments for viruses before opening them. Any views or opinions expressed are solely those of the author and do not necessarily represent those of The Blackpool Sixth Form College. ##################################################################################### Scanned by MailMarshal - Marshal's comprehensive email content security solution. Download a free evaluation of MailMarshal at www.marshal.com #####################################################################################

1 0

RV: Stats by Groups - No Notification Message
by Alan Cowes 24 Feb '10

24 Feb '10

Hello Everybody, I have installed OTRS 2.2.7-2lenny3, and I´m trying to make a stats by groups instead of queues. For example, I want the graph to show me how many tickets (doesn´t matter which type of queue they are in) each department has, we are a helpdesk team and we need to show monthly results of tickets that were given to each department. Is that possible? Also, I want to disable the notification for the customers that reads as follows: System <http://10.100.14.30/otrs/customer.pl?Action=CustomerTicketZoom&TicketID=43& ArticleID=188#188> (email-notification-ext) OTRS System <otr[..]: New State "-Pending[..] - 17.02.2010 18:01:18 *************************************************************** *** THIS IS JUST A NOTICE *** The owner of your ticket "2010021710000052" has been changed to "JOE Heldesk. http://mycompany.com/otrs/customer.pl?Action=CustomerZoom <http://mycompany.com/otrs/customer.pl?Action=CustomerZoom&TicketID=43> &TicketID=43 Your OTRS Notification Master *** THIS IS JUST A NOTICE *** ******************************************************************** Because this will confuse the customers inside our company, I want them to only read the new replies we send them. Thanks a lot in advance! Alan LOPD: INFORMACION SOBRE PROTECCION Y TRATAMIENTO DE DATOS PERSONALES: De acuerdo con la Ley de Servicios de la Sociedad de la Informacion y Comercio Electrónico aprobada por el parlamento español y de la vigente Ley Orgánica 15 13/12/1999 de Protección de Datos española, le comunicamos que su dirección de Correo electrónico forma parte de nuestra base de datos, teniendo usted derecho de oposición, acceso, rectificación y cancelación de sus datos. Si desea acceder, rectificar, cancelar u oponerse al tratamiento de sus datos, contacte con nosotros en DATATRONICS, S.A. Avda. Cardenal Herrera Oria,383 - 28034 Madrid, o bien envíenos un e-mail a lopd(a)datatronics.es junto con su nombre y apellidos, indicando en el campo asunto el texto: "Borrar Datos Personales". Si desea seguir recibiendo información, su dirección de correo electrónico seguirá en nuestra base de datos, entendiéndose que acepta los términos y condiciones, expresados en este Aviso Legal. Agradeciendo su colaboración para poder seguir ofreciéndole nuestros servicios y reiterando nuestro firme compromiso de uso responsable de sus datos, aprovechamos la ocasión para saludarle muy cordialmente. AVISO DE CONFIDENCIALIDAD: Este mensaje y los archivos adjuntos son confidenciales. Los mismos contienen informaciÿn reservada y que no puede ser difundida. Si usted ha recibido este correo por error, por favor avÿsenos inmediatamente por e-mail o por telÿfono (+34 91 376 92 90) y tenga la amabilidad de eliminarlo de su sistema. CONFIDENTIALE NOTICE: This message and its attached files are confidential. They contain information that is privileged and legally exempt from disclosure. If you have received this e-mail by mistake, please let us know immediately by e-mail and by phone (+34 91 376 92 90 ) and delete it from your system.

1 0

Help Inserting a Ticket State Type
by David Zauss 24 Feb '10

24 Feb '10

I am attempting to add a Ticket State Type but keep getting the error "ERROR 1364 (HY000): Field 'create_time" doesn't have a default value". I'm following the directions in the admin book: linux:~# mysql -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 23 to server version: 5.0.16-Debian_1-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> use otrs; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> insert into ticket_state_type (name,comments) values ('own','Own state type'); Query OK, 1 row affected (0.00 sec) mysql> quit Bye linux:~# I'm running OTRS v2.4.7 in a Windows environment. I had to install MySQL Server v5.1 before installing OTRS just to get access to the database. I'm using the MySQL Command Line Client to attempt the change. I have no Linux or SQL knowledge so any help would be greatly appreciated. If you need any additional information please let me know. David Zauss Senior Office Assistant Information Technology Main: 417.886.7542 ext 1201 Email: <mailto:david.zauss@russellcellular.com> david.zauss(a)russellcellular.com cid:image001.jpg@01CA6D1D.DA52F770 LOGO.gif Corporate Office: 5624 S State Hwy FF Battlefield, MO 65619 Office: 417.886.7542 Fax: 417.888.5011 <http://www.russellcellular.com> www.russellcellular.com

2 1

Fwd: error
by Leonardo Certuche 23 Feb '10

23 Feb '10

Hello People, Our OTRS system just crashed :( hopefully someone will give us some help Here's the output of the error: # rcotrs restart Shutting down OTRS Disable /opt/otrs/bin/PostMaster.pl ... done. Shutting down cronjobs ... done. done Starting OTRS Checking Apache ... done. Checking MySQL ... done. Checking database connect... (Can't modify subtraction (-) in scalar assignment at /opt/otrs/Kernel/Config.pm line 330, near "'Kernel::System::CustomerAuth::LDAP';" syntax error at /opt/otrs/Kernel/Config.pm line 331, near "$Self" Compilation failed in require at /opt/otrs/bin/CheckDB.pl line 38. BEGIN failed--compilation aborted at /opt/otrs/bin/CheckDB.pl line 38.) Thanks in advance for your help, Leonardo Certuche 301 284 6250 460 0727 ext 5559 leonardo.certuche(a)itcon-ltda.com www.itcon-ltda.com Cra 31 # 54-10 TECNOSOFT Medellín, Colombia ---------- Forwarded message ---------- From: Carlos Andres Gallego <cgallegoa(a)emtelco.com.co> Date: Tue, Feb 23, 2010 at 3:42 PM Subject: error To: leonardo.certuche(a)itcon-ltda.com seus:/opt/otrs/Kernel # rcotrs restart Shutting down OTRS Disable /opt/otrs/bin/PostMaster.pl ... done. Shutting down cronjobs ... done. done Starting OTRS Checking Apache ... done. Checking MySQL ... done. Checking database connect... (Can't modify subtraction (-) in scalar assignment at /opt/otrs/Kernel/Config.pm line 330, near "'Kernel::System::CustomerAuth::LDAP';" syntax error at /opt/otrs/Kernel/Config.pm line 331, near "$Self" Compilation failed in require at /opt/otrs/bin/CheckDB.pl line 38. BEGIN failed--compilation aborted at /opt/otrs/bin/CheckDB.pl line 38. ) ---------------------------------------------------------------------------- Error: Maybe your database isn't configured yet? ---------------------------------------------------------------------------- Try the web installer to configure your database: -->> http://seus/otrs/installer.pl <<-- ---------------------------------------------------------------------------- or configure your database with README.database (DB - Setup Example) ---------------------------------------------------------------------------- failed

1 1