May 2015 - otrs - OTRS mailing lists

How can add a button on a template?
by Sotiris 11 May '15

11 May '15

Hello, I am new developer and I am trying to add a button on a template. Is there a developers framework where I can drag and drop a button onto a template and after that I can write my code at the click event? Thank you in advance and kind regards!

1 0

Request for return receipt or delivery status notification
by Jakub Szczepańczyk 11 May '15

11 May '15

Hi, is it already in OTRS Request for return receipt or delivery status notification for sending messages ? -- Jakub Szczepańczyk Inżynier Serwisu Alfavox Sp. z o.o. ul. 1 Maja 17 43-300 Bielsko-Biała Tel.: +48 33 822 43 06 Fax: +48 33 822 43 06 e-mail: j.szczepanczyk(a)alfavox.pl www.alfavox.pl Alfavox Sp. z o.o., 43-300 Bielsko-Biała, ul. 1 Maja 17, wpisana przez Sąd Rejonowy w Bielsku-Białej do rejestru przedsiębiorców VIII Wydziału Gospodarczego Krajowego Rejestru Sądowego pod numerem KRS 0000223533, NIP: 547-201-50-75, o kapitale zakładowym 50000zł opłaconym w całości.

3 3

Ticket urgent
by Simon Allison 11 May '15

11 May '15

Some help please, we are still on OTRS 3.2.2. I tried to add a new template for new phone ticket, - I clicked on the plus sign under new phone ticket. Did an update, and now the whole Ticket navbar has gone! So I removed the option, and did another update, but still missing, Any help urgently ! Simon ________________________________ [http://www.southdowns.ac.uk/assets/efooter.png]<http://www.southdowns.ac.uk/apprenticeships> ********************************************************************** This message may contain privileged and confidential information. It is intended solely for the person to whom it is addressed. If you are not the intended recipient, please notify the sender and delete the message immediately. The text in this e-mail and any attachments should not be altered or tampered with in any way. Any views expressed in this message are those of the individual sender and do not necessarily reflect the views of South Downs College. **********************************************************************

1 0

Storing of large/binary data in Non-MySQL databases
by Christoph Zwerschke 07 May '15

07 May '15

When trying to migrate our OTRS database from MySQL to PostgreSQL, I noticed that the MySQL database uses LONGBLOBs in several places, which are binary objects, while on the other hand, OTRS creates TEXT columns for these columns when using PostgreSQL, which is a character type, not binary. Similarly, for Oracle and SQLServer, OTRS also uses character types for these columns. This makes it difficult to migrate between the databases, because you need to transform from binary to character, using the proper encoding. From looking at the source code, most of the LONGBLOBs are assumed to be UTF-8 encoded strings which can be converted to Postgres TEXT with convert_to(column, 'utf8'), while other LONGBLOBs, e.g. those storing representing attachments are assumed to be binary resp. the original encoding of the attachment. These are handled differently by OTRS - for databases other than MySQL, OTRS stores them in BASE64 encoding. The conversion can be done with Postgres using encode(column, 'base64'). My question is: Why do the other databases use character objects for all the LONGBLOBs including those that really contain binary data, so that for these databases, a BASE64 encoding is necessary, which costs performance when encoding and decoding and 33% more storage? Wouldn't it be much better and easier if OTRS used BLOBs consistently across all databases for the binary columns, and TEXT for the other large columns? All the databases support this. The BLOBs are just called BYTEA in Postgres. And MySQL also has LONGTEXT, no need to use LONGBLOBs if it's actually text. Also, would it be possible to use BYTEA in PostgreSQL instead of TEXT for the binary data columns, changing the database scheme accordingly and setting the DB::DirectBlob flag to 1 so that OTRS stops BASE64 encoding these columns? -- Christoph

2 4

Test
by Stefan Wagner 06 May '15

06 May '15

feedback -- Stefan Wagner Tel +49 911 4007844 Stefan.Wagner(a)logima.de http://www.logima.de Logima Software GmbH - Regensburger Straße 334a - 90480 Nürnberg Geschäftsführer: Daniel Schwartz Registernummer: HRB 28770, Amtsgericht Nürnberg

1 0

OTRS Appliance 4.0.7 - Cannot Login
by Stefan Wagner 06 May '15

06 May '15

Hello everybody, I installed the OTRS Appliance 4.0.7 on a virtual machine and everything looks good. It tells me that the default user is "root@localhost" with the password "root". I can open the web frontend (http://192.168.178.84/otrs/customer.pl) but if I try to login I get the message that the username or password is wrong. I tried to add another user via the command line - it told me it worked, but I cannot login with this credentials either. I also tried to change the password of the root@localhost user, it told me again it worked, but no luck in the web frontend. I also double checked the server name (it is the only otrs server running in the local network and the IP address is the same). Any idea how I can get a working login? Best regards! Stefan

3 2

OTRS + SAP Idendity Service
by Frank Lanitz 05 May '15

05 May '15

Hi folks, Does anybody of you is having experinces of using OTRS together with SAP idendity service? As OTRS is supporting SAML2 it should be working without big issue, but wondering whether theory is also working in practice? Are there any special things to keep care on? Thanks, Frank

1 0

Why does the OTRS-User need "GRANT" privileges?
by Hartmut Goebel 04 May '15

04 May '15

Hi, when investigating which database permissions the OTRS user need, I discovered, that for mysql the user gets "ALL PRIVILEGES" with "WITH GRANT OPTION" (Modules/Installer.pm). Why does the OTRS-User need GRANT" privileges? It does not create any other database-user, dosn't it? -- ▶︎Digitalcourage e.V., Hartmut Goebel, Marktstr. 18, D-33602 Bielefeld Tel: +49-521-1639 1639 | Fax: 0521-61172 | mail(a)digitalcourage.de https://digitalcourage.de | http://bigbrotherawards.de | ------------------------------------------------------------------ Für Bürgerrechte, Datenschutz und eine lebenswerte digitale Welt ----------------------------------------------------------------- Online spenden: https://digitalcourage.de/spende/

2 1

Fwd: FW: [Case#1015987] Ticket Escalation Warning! (Supreme court Wi-Fi Laun [...])
by Darshak Modi 01 May '15

01 May '15

pl remove Abhijit ID -------- Forwarded Message -------- Subject: FW: [Case#1015987] Ticket Escalation Warning! (Supreme court Wi-Fi Laun [...]) Date: Tue, 28 Apr 2015 17:33:21 +0530 From: Abhijit Acharya <abhijit.acharya(a)elitecore.com> To: 'Darshak Modi' <darshak.modi(a)elitecore.com> CC: milin.dholakia(a)elitecore.com Hi Darshak, Could you pls do the needful to remove my name from the alias due to which I am getting these mails from Airtel Bharti. Thanks & Regards Abhijit Acharya | Mob No - +91-97129-14476,Skype - abhijit-acharya, E-Mail - abhijit.acharya(a)elitecore.com Head Office:904, Silicon Tower, Behind Pariseema Building, Off C.G.Road, Nr. Lal Bungalow*,* Ahmedabad-380006. Gujarat, India.** *P****Save Paper - Save Trees** | **S**Save Water |**/7/**Switch**off as you go** | **q****Recycle **always*** *From:*System Notification -Do not Reply [mailto:do-not-reply@elitecore.com] *Sent:* 28 April 2015 15:00 *To:* abhijit.acharya(a)elitecore.com *Subject:* [Case#1015987] Ticket Escalation Warning! (Supreme court Wi-Fi Laun [...]) Hi Abhijit, The ticket [1015987] will escalate! Escalation at: 2015-04-28 19:30:02 Escalation in: 4h 30m Level 1 Bhartiwifi <level.1.bhartiwifi(a)ericsson.com <mailto:level.1.bhartiwifi@ericsson.com>> wrote: <snip> Hi Sir, We need to map SSID AirtelWiFiZone1 with respect to VLAN 1142. Kindly check the possibility for doing the change at BNG. Regards. [Description: Description: Ericsson]<http://www.ericsson.com/> ABHIJEET BARNWAL Engineer - 1st Level Assurance Ericsson Global India Services Ericsson 4th Floor, Tower-A, Knowledge Boulevard Noida, India Phone +919717298411 abhijeet.barnwal(a)ericsson.com<mailto:abhijeet.barnwal@ericsson.com <mailto:abhijeet.barnwal@ericsson.com%3cmailto:abhijeet.barnwal@ericsson.com>> www.ericsson.com <http://www.ericsson.com><http://www.ericsson.com> From: Abhishek Saini [mailto:abhishek.saini@elitecore.com] Sent: Friday, April 24, 2015 4:17 PM To: Level 1 Bhartiwifi Cc: Devesh Singh; AIRTELWIFI-EC-OPS(a)elitecore.com <mailto:AIRTELWIFI-EC-OPS@elitecore.com> Subject: RE: Supreme court Wi-Fi Launch - URGENT ATTENT REQUIRED !!!!! Dear Team, Hotspot package has been updated with FR_25MB_24Hrs. Mentioned calling station IDs already mapped to reseller account. Regarding SSID change to AirtelWiFiZone1, kindly check the possibility for doing the <snip> Please have a look at: http://csmsupport.elitecore.com/otrs/index.pl?Action=AgentTicketZoom;Ticket… Your OTRS Notification Master

1 1