R: R: [otrs] OTRS statistics

Thank you Edgar, SELECT COUNT(DISTINCT(ticket_id))... result is 31 please consider that I can also debug your script using Komodo. I run it with also by command line with options: StartDay=1 StartMonth=1 StartYear=2006 EndDay=1 EndMonth=2 EndYear=2006 Action=Workload Unit=week Output=Graph

[otrs] otrs on oracle

Title: Message Hi We setup otrs on linux redhat8.0 we have installed an oracle 10.2 database with a tablespace otrs a user otrs . we created the otrs tables on oracle (3 scripts :create:insert:post-creation) and now we try to configure otrs to use this oracle database We modified the

Re: [otrs] MySQL 4.0 with OTRS v2 on Windows 2003

Hi! Solaris User wrote: What type of hash does OTRS v2 use when storing a password in MySQL? It looks like crypt, but I am unable to tell what the salt is. Try it this way: $password = crypt($cleartextpassword, $username); The username is the salt. Greetings Marco

[otrs] Problems with Postmaster reading certain emails

Hi Lately my OTRS has had problems reading certain emails. When i parse the email through Postmaster.pl, I get this error msg: perl: prescan_stmt.c:442: rewrite_execute_stmt: Assertion `ph = imp_sth-phc' failed. Does anyone know why this is happening? I'm running CentOS 4, with perl 5.8.5.

[otrs] nothing in my queues....

Hi all. I'm can't figure how queues work ;) Who can explain ? ;) All names/logins are testcase. Admin - create users: agent1, customer and queue internal-it. Agent (tech. specialist, login agent1) enter OTRS and choose my queue = internal-it in his preferences. Exit. Customer (customer

Re: [otrs] MySQL 4.0 with OTRS v2 on Windows 2003

Again this should have been asked in a mySQL List, however: Why not do the Job with mySQL directly ? SELECT count(*) FROM system_user WHERE pass=password(yourplaintextpass); Started your Server with --old-passwords ? No problem, just use pass=old_password() instead. hth FranzF Solaris User

RE: [otrs] Opening closed tickets

Yes I could have searched the mail archive, I apologize. However contacting sales for these questions is not feasible. The documentation does not cover all the questions that I had unless I missed it. I didn't see anything that goes over how the ticketing system works and how it integrates

[otrs] NumberGenerator change problem

Hi, I've changet Ticket::Hook to Request# and Ticket::NumberGenerator to AutoInc While Hook is applied to all ticket, I noticed that new ticket Number format is only applied to ticket that are created by mails sent to helpdesk address. Ticket created through OTRS web interface (Phone and Email

[otrs] MySQL 4.0 with OTRS v2 on Windows 2003 - Part Deux

FranzF, You have misunderstood the question. This has nothing to do with the MySQL user, but the user that is stored in MySQL *THROUGH* OTRS. Hence why this forum is the best shot I have of getting the correct information. Running the server with --old-password is not relevant. My question

Re: [otrs] MySQL 4.0 with OTRS v2 on Windows 2003

The routine that does this encryption is in /opt/otrs/bin/CryptPassword.pl Solaris User said: What type of hash does OTRS v2 use when storing a password in MySQL? It looks like crypt, but I am unable to tell what the salt is. Essentially, my problem is that I want to interface with

[Fwd: Re: [otrs] MySQL 4.0 with OTRS v2 on Windows 2003]

Oops and in /opt/otrs/Kernel/System/Auth/DB.pm this uses a crypt function from mod_perl Original Message Subject: Re: [otrs] MySQL 4.0 with OTRS v2 on Windows 2003 From:[EMAIL PROTECTED] Date:Thu, February 9, 2006 7:03 pm To:

[otrs] Re: MySQL 4.0 with OTRS v2 on Windows 2003 - Part Deux

Thanks everyone. With your assistance, I was able to figure it out. Here is the PHP code incase anyone wants to use it in the future. This works on Windows 2003. Note: pass_input and user_inputare the username and password fields in the form ?php [..snip..] exec(perl -e \print

Re: [otrs] NumberGenerator change problem

Hi Nikola, I've changet Ticket::Hook to Request# and Ticket::NumberGenerator to AutoInc While Hook is applied to all ticket, I noticed that new ticket Number format is only applied to ticket that are created by mails sent to helpdesk address. Ticket created through OTRS web interface (Phone

[otrs-de] Verschieben von Tickets (nochmal)

Hallo! Angelika Beck fragte das bereits im vergangenen Dezember an, bei uns tritt es auch auf: verschiebt ein Mitarbeiter in unserem OTRS-System (1.3.3) ein Ticket von Queue A nach Queue B, wird die Queue A automatisch geschlossen und der Mitarbeiter landet in der Ansicht Meine Queues. Wo kann

Re: [otrs-de] Verschieben von Tickets (nochmal)

Hallo, habe es selbst gefunden: in otrs 1.3.3 muss in der Datei Kernel/Modules/AgentMove.pm # redirect return $Self-{LayoutObject}-Redirect(OP = $Self-{LastScreen}); stehen und nicht # redirect return $Self-{LayoutObject}-Redirect(OP = $Self-{LastScreenView}); Gruß, Rudolf Harney Am

[otrs-de] Nochmal Kunden# setzen

Hallo Liste und Alexander, also ich hatte vor ein paar Tage schonmal geschrieben. Und zwar nutzen wir OTRS nur intern und es ist auch mit allen geklärt das jeder das Ticket von jedem über CompanyTickets sehen darf im Kundeninterface. Mein Problem ist nur wie erreiche ich das? Die Idee war ja

[otrs-de] Installationsproblem (Gentoo)

Hallo Liste!Ich habe auf Gentoo OTRS 2.0.4 installiert - leider bekomme ich immer folgenden Fehler nach dem Einloggen:Invalid argument at /var/www/ticket.xxx.de/otrs-2.0.4/bin/cgi-bin/../../Kernel/System/Log.pm line 153.Hat jemand eine Idee wo der Fehler zu suchen ist?DankeGerd

Re: [otrs-de] Nochmal Kunden# setzen

Sven Wagner schrieb: Hallo Liste und Alexander, also ich hatte vor ein paar Tage schonmal geschrieben. Und zwar nutzen wir OTRS nur intern und es ist auch mit allen geklärt das jeder das Ticket von jedem über CompanyTickets sehen darf im Kundeninterface. Mein Problem ist nur wie erreiche ich