- otrs - OTRS mailing lists

Stored search with only one parameter
by Ralf Hildebrandt 20 Nov '18

20 Nov '18

Is iit possible to create a URL in such a way that a special parametrized search is perfromend within OTRS? I'd lie to link from a webpage to something like: https://otrs.charite.de?Ralf.Hildebrandt@charite.de and that should display all tickets in the queue XYZ and customeruser == Ralf.Hildebrandt(a)charite.de -- Ralf Hildebrandt Charite Universitätsmedizin Berlin ralf.hildebrandt(a)charite.de Campus Benjamin Franklin https://www.charite.de Hindenburgdamm 30, 12203 Berlin Geschäftsbereich IT, Abt. Netzwerk fon: +49-30-450.570.155

2 2

Can I use upgraded DB on new code install?
by Mike Morris 09 Nov '18

09 Nov '18

Hi, I have an old (3.x) installation that I want to migrate to current 6.x. Can I run the DB upgrade scripts from all intermediate versions against my database, and then expect that upgraded database to work on a brand new installation? (Assuming I handle migration of the config files to the new install, of course.) I don't see why this wouldn't work, but thought I should at least ask the experts... Thanks in advance, Mike Morris

3 2

AUTOREPLY otrs Digest, Vol 122, Issue 1
by baer＠opm-computer.de 09 Nov '18

09 Nov '18

Sehr geehrte Damen und Herren, in der Zeit vom 02.11.2018 bis einschließlich 18.11.2018 befinde ich mich nicht im Büro. Beachten Sie bitte, dass Ihre E-Mail nicht automatisch weitergeleitet wird. In dringenden Fällen wenden Sie sich bitte an unsere Hotline, 0203-378530, oder an Herrn Hesselmann (hesselmann(a)opm-computer.de) Mit freundlichen Grüßen Ronny Bär OPM IT Service GmbH Send otrs mailing list submissions to otrs(a)lists.otrs.org To subscribe or unsubscribe via the World Wide Web, visit http://lists.otrs.org/mailman/listinfo/otrs or, via email, send a message with subject or body 'help' to otrs-request(a)lists.otrs.org You can reach the person managing the list at otrs-owner(a)lists.otrs.org When replying, please edit your Subject line so it is more specific than "Re: Contents of otrs digest..." Today's Topics: 1. Re: Mysql Timeouts? (=?UTF-8?B?TFEgTWFyc2hhbGw=?=) 2. Fail to update DB to 6 (Alvaro Cordero) 3. Can I use upgraded DB on new code install? (Mike Morris) 4. Re: Can I use upgraded DB on new code install? (Gerald Young) ---------------------------------------------------------------------- Message: 1 Date: Mon, 29 Oct 2018 12:10:31 -0700 From: "=?UTF-8?B?TFEgTWFyc2hhbGw=?=" <qmarshall(a)iNetSpace.net> To: "User questions and discussions about OTRS." <otrs(a)lists.otrs.org> Subject: Re: [otrs] Mysql Timeouts? Message-ID: <mailman.1009.1541737606.22665.otrs(a)lists.otrs.org> Content-Type: text/plain; charset="utf-8" MartinExamine Mysql for connectivity/performance issues - Check mysql logs.L.Q. MarshallOne's strength is only determined when the challenge seems overwhelming.<div> </div><div> </div><div>-------- Original message --------</div><div>From: Hochreiter Martin <martin.hochreiter(a)fhstp.ac.at> </div><div>Date: 10/29/18 07:46 (GMT-07:00) </div><div>To: otrs(a)lists.otrs.org </div><div>Subject: [otrs] Mysql Timeouts? </div><div> </div> Dear members, I have a strange syslog on Ubuntu 18.04: otrs Aborted connection XXX to db: Got timeout reading communication OTRS seems to be working - how can I solve that? Kind regards _____________________ DI (FH) Martin Hochreiter --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs

1 0

Fail to update DB to 6
by Alvaro Cordero 02 Nov '18

02 Nov '18

Hello, I am running a migration process of an OTRS 5.0.30 to OTRS 6.0.12 on CentOS 7 with MariaDB and during DB-Migrate-to-6 execution I get the following error. The first time I ran, it told me there were some orphaned articles and some orphaned tags and asked to delete them. I tried reloading the original Database and those orphaned messages disappeared but It keeps giving the error. Step 29 of 42: Post changes on article related tables ... [Fri Nov 2 21:07:29 2018] DBUpdate-to-6.pl: DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`otrs`.`#sql-955_4c109`, CONSTRAINT `FK_article_data_mime_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`)) at /opt/otrs/Kernel/System/DB.pm line 470. ERROR: OTRS-otrs.Console.pl-Maint::Database::Check-1 Perl: 5.16.3 OS: linux Time: Fri Nov 2 21:07:29 2018 Message: Cannot add or update a child row: a foreign key constraint fails (`otrs`.`#sql-955_4c109`, CONSTRAINT `FK_article_data_mime_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`)), SQL: 'EXECUTE FKStatement' Traceback (123074): Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBString Line: 394 Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBArray Line: 342 Module: scripts::DBUpdateTo6::PostArticleTableStructureChanges::_UpdateArticleDataMimeTable Line: 286 Module: scripts::DBUpdateTo6::PostArticleTableStructureChanges::Run Line: 52 Module: scripts::DBUpdateTo6::_ExecuteComponent Line: 157 Module: scripts::DBUpdateTo6::Run Line: 69 Module: scripts/DBUpdate-to-6.pl Line: 87 ERROR: OTRS-otrs.Console.pl-Maint::Database::Check-1 Perl: 5.16.3 OS: linux Time: Fri Nov 2 21:07:29 2018 Message: Error during execution of 'EXECUTE FKStatement'! Traceback (123074): Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBString Line: 397 Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBArray Line: 342 Module: scripts::DBUpdateTo6::PostArticleTableStructureChanges::_UpdateArticleDataMimeTable Line: 286 Module: scripts::DBUpdateTo6::PostArticleTableStructureChanges::Run Line: 52 Module: scripts::DBUpdateTo6::_ExecuteComponent Line: 157 Module: scripts::DBUpdateTo6::Run Line: 69 Module: scripts/DBUpdate-to-6.pl Line: 87 Not possible to complete migration, check previous messages for more information. -- *Alvaro Cordero RetanaConsultor de Tecnologias* *Tel: 22585757 ext 123* *Email:* alvaro(a)gridshield.net

1 0

Re: [otrs] Mysql Timeouts?
by LQ Marshall 29 Oct '18

29 Oct '18

MartinExamine Mysql for connectivity/performance issues - Check mysql logs.L.Q. MarshallOne's strength is only determined when the challenge seems overwhelming.<div> </div><div> </div><div>-------- Original message --------</div><div>From: Hochreiter Martin <martin.hochreiter(a)fhstp.ac.at> </div><div>Date: 10/29/18 07:46 (GMT-07:00) </div><div>To: otrs(a)lists.otrs.org </div><div>Subject: [otrs] Mysql Timeouts? </div><div> </div> Dear members, I have a strange syslog on Ubuntu 18.04: otrs Aborted connection XXX to db: Got timeout reading communication OTRS seems to be working - how can I solve that? Kind regards _____________________ DI (FH) Martin Hochreiter --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs

1 0

Mysql Timeouts?
by Hochreiter Martin 29 Oct '18

29 Oct '18

Dear members, I have a strange syslog on Ubuntu 18.04: otrs Aborted connection XXX to db: Got timeout reading communication OTRS seems to be working - how can I solve that? Kind regards _____________________ DI (FH) Martin Hochreiter

1 0

Appointment Notification Filter "Calendar"
by Rick Heisterhagen 29 Oct '18

29 Oct '18

Hello, I would like to create a new Appointment Notification which only applies for a specific calendar but the field is greyed out "not available". According to the documentation some features are only available for OTRS Business Solution so I created a trial account but there it is also greyed out. How can I enable this field? Best Reagrds, Rick

1 0

Multiple signatures for one queue
by Matthias.Terlinde＠t-systems.com 26 Oct '18

26 Oct '18

Dear list, is it possible to set more than one fixed signature for one queue? I want to set an English and German signature for the same queue and the agent should be able to choose between them like the mail templates. I found a few old otterhub entries for version 3.0 but I think that there isn't any solution in version 6? Kind regards, Matthias T-SYSTEMS INTERNATIONAL GMBH Telekom Security Matthias Terlinde Cyber Defense Operations Bonner Talweg 100, 53113 Bonn, Germany +49 228 181-73771 (fixed) +49 160 3003113 (mobile) E-mail: matthias.terlinde(a)t-systems.com<mailto:matthias.terlinde@t-systems.com> Internet: www.t-systems.com You can find the compulsory statement on: www.t-systems.com/compulsory-statement BIG CHANGES START SMALL - CONSERVE RESOURCES BY NOT PRINTING EVERY E-MAIL.

3 3

Allow customers to read other customer's tickets - OTRS 6
by Willian Silva 01 Oct '18

01 Oct '18

Hello ! Is it possible allow customers to read other customer's tickets at customer's interface ? Best regards, Willian Silva.

2 1

Monitoring of the queues
by Ralf Hildebrandt 28 Sep '18

28 Sep '18

We#d like to programmatically query the number new or open tickets in our OTRS 5 installation. How would we go about doing that? -- Ralf Hildebrandt Charite Universitätsmedizin Berlin ralf.hildebrandt(a)charite.de Campus Benjamin Franklin https://www.charite.de Hindenburgdamm 30, 12203 Berlin Geschäftsbereich IT, Abt. Netzwerk fon: +49-30-450.570.155

3 3