May 2008 - dev - OTRS mailing lists

Feature request: response template -> next ticket state
by Sascha.Rommelfangen＠ses-astra.com 17 Jan '11

17 Jan '11

Hi, I have a suggestion for OTRS, probably someone wants to implement this: When creating a response template (Admin Area -> Responses; AdminResponse.pm), it would be nice to have the possibility to define the next ticket state. For example: I have a 'CloseWithStateExplanation' template, and often people forget to change the next ticket state. The result is a nice explanation about the state ('closed'), but the state is of course still 'open'. Best regards, Sascha Rommelfangen

3 3

Java WebServiceClient for OTRS
by Christoph Nagel 16 Jun '08

16 Jun '08

Hello, I try to implement a Java WebServiceClient which uses OTRS WebServices. Have anybody experience in implementing a Java WebServiceClient for OTRS or an example? Greetings Christoph

7 24

MySQL 5.1 fixes
by Philip M. Gollucci 03 Jun '08

03 Jun '08

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi all, http://www.freebsd.org/cgi/query-pr.cgi?pr=123905 The attached patch is required to have the ALTER statements parse as vaild SQL. I guess this must be a MySQL 5.1 thing since it looks like MySQL 5.0 is the primary testing location. It is back-compatible. - -- - ------------------------------------------------------------------------ Philip M. Gollucci (philip(a)ridecharge.com) o:703.549.2050x206 Senior System Admin - Riderway, Inc. http://riderway.com / http://ridecharge.com 1024D/DB9B8C1C B90B FBC3 A3A1 C71A 8E70 3F8C 75B8 8FFB DB9B 8C1C Work like you don't need the money, love like you'll never get hurt, and dance like nobody's watching. -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.8 (FreeBSD) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFINaNEdbiP+9ubjBwRAn15AJ9mlp1Ip3MXeNtSWqLnsi3NSUbFjwCcDy3B reH+b5luChgN1KD4H/XwwSY= =RWX5 -----END PGP SIGNATURE----- --- ./scripts/database/otrs-schema-post.mysql.sql.orig 2008-05-21 18:58:03.000000000 +0000 +++ ./scripts/database/otrs-schema-post.mysql.sql 2008-05-22 15:48:31.000000000 +0000 @@ -1,159 +1,159 @@ # ---------------------------------------------------------- # driver: mysql, generated: 2007-06-12 16:52:19 # ---------------------------------------------------------- -ALTER TABLE valid ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE valid ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE ticket_priority ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE ticket_priority ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE ticket_type ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE ticket_type ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE ticket_type ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE ticket_lock_type ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE ticket_lock_type ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE ticket_lock_type ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE system_user ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE system_user ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE system_user ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE user_preferences ADD FOREIGN KEY (user_id) REFERENCES `system_user(id)`; -ALTER TABLE groups ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE groups ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE groups ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE group_user ADD FOREIGN KEY (group_id) REFERENCES `groups(id)`; -ALTER TABLE group_user ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE group_user ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE group_user ADD FOREIGN KEY (user_id) REFERENCES `system_user(id)`; -ALTER TABLE group_role ADD FOREIGN KEY (role_id) REFERENCES `roles(id)`; -ALTER TABLE group_role ADD FOREIGN KEY (group_id) REFERENCES `groups(id)`; -ALTER TABLE group_role ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE group_role ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE group_customer_user ADD FOREIGN KEY (group_id) REFERENCES `groups(id)`; -ALTER TABLE group_customer_user ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE group_customer_user ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE roles ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE roles ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE roles ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE role_user ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE role_user ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE role_user ADD FOREIGN KEY (user_id) REFERENCES `system_user(id)`; -ALTER TABLE personal_queues ADD FOREIGN KEY (queue_id) REFERENCES `queue(id)`; -ALTER TABLE personal_queues ADD FOREIGN KEY (user_id) REFERENCES `system_user(id)`; -ALTER TABLE theme ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE theme ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE theme ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE ticket_state ADD FOREIGN KEY (type_id) REFERENCES `ticket_state_type(id)`; -ALTER TABLE ticket_state ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE ticket_state ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE ticket_state ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE ticket_state_type ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE ticket_state_type ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE salutation ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE salutation ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE salutation ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE signature ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE signature ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE signature ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE system_address ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE system_address ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE system_address ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE follow_up_possible ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE follow_up_possible ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE follow_up_possible ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE queue ADD FOREIGN KEY (salutation_id) REFERENCES `salutation(id)`; -ALTER TABLE queue ADD FOREIGN KEY (signature_id) REFERENCES `signature(id)`; -ALTER TABLE queue ADD FOREIGN KEY (group_id) REFERENCES `groups(id)`; -ALTER TABLE queue ADD FOREIGN KEY (follow_up_id) REFERENCES `follow_up_possible(id)`; -ALTER TABLE queue ADD FOREIGN KEY (system_address_id) REFERENCES `system_address(id)`; -ALTER TABLE queue ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE queue ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE queue ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE ticket ADD FOREIGN KEY (ticket_lock_id) REFERENCES `ticket_lock_type(id)`; -ALTER TABLE ticket ADD FOREIGN KEY (ticket_priority_id) REFERENCES `ticket_priority(id)`; -ALTER TABLE ticket ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE ticket ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE ticket ADD FOREIGN KEY (user_id) REFERENCES `system_user(id)`; -ALTER TABLE ticket ADD FOREIGN KEY (responsible_user_id) REFERENCES `system_user(id)`; -ALTER TABLE ticket ADD FOREIGN KEY (service_id) REFERENCES `service(id)`; -ALTER TABLE ticket ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE ticket ADD FOREIGN KEY (sla_id) REFERENCES `sla(id)`; -ALTER TABLE ticket ADD FOREIGN KEY (ticket_state_id) REFERENCES `ticket_state(id)`; -ALTER TABLE ticket ADD FOREIGN KEY (queue_id) REFERENCES `queue(id)`; -ALTER TABLE ticket ADD FOREIGN KEY (type_id) REFERENCES `ticket_type(id)`; -ALTER TABLE ticket_history ADD FOREIGN KEY (priority_id) REFERENCES `ticket_priority(id)`; -ALTER TABLE ticket_history ADD FOREIGN KEY (owner_id) REFERENCES `system_user(id)`; -ALTER TABLE ticket_history ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE ticket_history ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE ticket_history ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE ticket_history ADD FOREIGN KEY (state_id) REFERENCES `ticket_state(id)`; -ALTER TABLE ticket_history ADD FOREIGN KEY (history_type_id) REFERENCES `ticket_history_type(id)`; -ALTER TABLE ticket_history ADD FOREIGN KEY (article_id) REFERENCES `article(id)`; -ALTER TABLE ticket_history ADD FOREIGN KEY (queue_id) REFERENCES `queue(id)`; -ALTER TABLE ticket_history ADD FOREIGN KEY (type_id) REFERENCES `ticket_type(id)`; -ALTER TABLE ticket_history ADD FOREIGN KEY (ticket_id) REFERENCES `ticket(id)`; -ALTER TABLE ticket_history_type ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE ticket_history_type ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE ticket_history_type ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE article_type ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE article_type ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE article_type ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE article_sender_type ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE article_sender_type ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE article_sender_type ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE article_flag ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE article ADD FOREIGN KEY (article_sender_type_id) REFERENCES `article_sender_type(id)`; -ALTER TABLE article ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE article ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE article ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE article ADD FOREIGN KEY (article_type_id) REFERENCES `article_type(id)`; -ALTER TABLE article ADD FOREIGN KEY (ticket_id) REFERENCES `ticket(id)`; -ALTER TABLE article_plain ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE article_plain ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE article_plain ADD FOREIGN KEY (article_id) REFERENCES `article(id)`; -ALTER TABLE article_attachment ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE article_attachment ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE article_attachment ADD FOREIGN KEY (article_id) REFERENCES `article(id)`; -ALTER TABLE standard_response ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE standard_response ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE standard_response ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE queue_standard_response ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE queue_standard_response ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE queue_standard_response ADD FOREIGN KEY (standard_response_id) REFERENCES `standard_response(id)`; -ALTER TABLE queue_standard_response ADD FOREIGN KEY (queue_id) REFERENCES `queue(id)`; -ALTER TABLE standard_attachment ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE standard_attachment ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE standard_attachment ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE standard_response_attachment ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE standard_response_attachment ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE standard_response_attachment ADD FOREIGN KEY (standard_response_id) REFERENCES `standard_response(id)`; -ALTER TABLE standard_response_attachment ADD FOREIGN KEY (standard_attachment_id) REFERENCES `standard_attachment(id)`; -ALTER TABLE auto_response_type ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE auto_response_type ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE auto_response_type ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE auto_response ADD FOREIGN KEY (type_id) REFERENCES `auto_response_type(id)`; -ALTER TABLE auto_response ADD FOREIGN KEY (system_address_id) REFERENCES `system_address(id)`; -ALTER TABLE auto_response ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE auto_response ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE auto_response ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE queue_auto_response ADD FOREIGN KEY (auto_response_id) REFERENCES `auto_response(id)`; -ALTER TABLE queue_auto_response ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE queue_auto_response ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE queue_auto_response ADD FOREIGN KEY (queue_id) REFERENCES `queue(id)`; -ALTER TABLE time_accounting ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE time_accounting ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE time_accounting ADD FOREIGN KEY (article_id) REFERENCES `article(id)`; -ALTER TABLE time_accounting ADD FOREIGN KEY (ticket_id) REFERENCES `ticket(id)`; -ALTER TABLE service ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE service ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE service_customer_user ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE sla ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE sla ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE sla ADD FOREIGN KEY (service_id) REFERENCES `service(id)`; -ALTER TABLE customer_user ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE customer_user ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE customer_user ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE pop3_account ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE pop3_account ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE pop3_account ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE notifications ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE notifications ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE package_repository ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE package_repository ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; +ALTER TABLE valid ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE valid ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE ticket_priority ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE ticket_priority ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE ticket_type ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE ticket_type ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE ticket_type ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE ticket_lock_type ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE ticket_lock_type ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE ticket_lock_type ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE system_user ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE system_user ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE system_user ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE user_preferences ADD FOREIGN KEY (user_id) REFERENCES `system_user`(`id`); +ALTER TABLE groups ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE groups ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE groups ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE group_user ADD FOREIGN KEY (group_id) REFERENCES `groups`(`id`); +ALTER TABLE group_user ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE group_user ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE group_user ADD FOREIGN KEY (user_id) REFERENCES `system_user`(`id`); +ALTER TABLE group_role ADD FOREIGN KEY (role_id) REFERENCES `roles`(`id`); +ALTER TABLE group_role ADD FOREIGN KEY (group_id) REFERENCES `groups`(`id`); +ALTER TABLE group_role ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE group_role ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE group_customer_user ADD FOREIGN KEY (group_id) REFERENCES `groups`(`id`); +ALTER TABLE group_customer_user ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE group_customer_user ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE roles ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE roles ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE roles ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE role_user ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE role_user ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE role_user ADD FOREIGN KEY (user_id) REFERENCES `system_user`(`id`); +ALTER TABLE personal_queues ADD FOREIGN KEY (queue_id) REFERENCES `queue`(`id`); +ALTER TABLE personal_queues ADD FOREIGN KEY (user_id) REFERENCES `system_user`(`id`); +ALTER TABLE theme ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE theme ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE theme ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE ticket_state ADD FOREIGN KEY (type_id) REFERENCES `ticket_state_type`(`id`); +ALTER TABLE ticket_state ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE ticket_state ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE ticket_state ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE ticket_state_type ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE ticket_state_type ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE salutation ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE salutation ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE salutation ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE signature ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE signature ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE signature ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE system_address ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE system_address ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE system_address ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE follow_up_possible ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE follow_up_possible ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE follow_up_possible ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE queue ADD FOREIGN KEY (salutation_id) REFERENCES `salutation`(`id`); +ALTER TABLE queue ADD FOREIGN KEY (signature_id) REFERENCES `signature`(`id`); +ALTER TABLE queue ADD FOREIGN KEY (group_id) REFERENCES `groups`(`id`); +ALTER TABLE queue ADD FOREIGN KEY (follow_up_id) REFERENCES `follow_up_possible`(`id`); +ALTER TABLE queue ADD FOREIGN KEY (system_address_id) REFERENCES `system_address`(`id`); +ALTER TABLE queue ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE queue ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE queue ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE ticket ADD FOREIGN KEY (ticket_lock_id) REFERENCES `ticket_lock_type`(`id`); +ALTER TABLE ticket ADD FOREIGN KEY (ticket_priority_id) REFERENCES `ticket_priority`(`id`); +ALTER TABLE ticket ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE ticket ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE ticket ADD FOREIGN KEY (user_id) REFERENCES `system_user`(`id`); +ALTER TABLE ticket ADD FOREIGN KEY (responsible_user_id) REFERENCES `system_user`(`id`); +ALTER TABLE ticket ADD FOREIGN KEY (service_id) REFERENCES `service`(`id`); +ALTER TABLE ticket ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE ticket ADD FOREIGN KEY (sla_id) REFERENCES `sla`(`id`); +ALTER TABLE ticket ADD FOREIGN KEY (ticket_state_id) REFERENCES `ticket_state`(`id`); +ALTER TABLE ticket ADD FOREIGN KEY (queue_id) REFERENCES `queue`(`id`); +ALTER TABLE ticket ADD FOREIGN KEY (type_id) REFERENCES `ticket_type`(`id`); +ALTER TABLE ticket_history ADD FOREIGN KEY (priority_id) REFERENCES `ticket_priority`(`id`); +ALTER TABLE ticket_history ADD FOREIGN KEY (owner_id) REFERENCES `system_user`(`id`); +ALTER TABLE ticket_history ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE ticket_history ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE ticket_history ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE ticket_history ADD FOREIGN KEY (state_id) REFERENCES `ticket_state`(`id`); +ALTER TABLE ticket_history ADD FOREIGN KEY (history_type_id) REFERENCES `ticket_history_type`(`id`); +ALTER TABLE ticket_history ADD FOREIGN KEY (article_id) REFERENCES `article`(`id`); +ALTER TABLE ticket_history ADD FOREIGN KEY (queue_id) REFERENCES `queue`(`id`); +ALTER TABLE ticket_history ADD FOREIGN KEY (type_id) REFERENCES `ticket_type`(`id`); +ALTER TABLE ticket_history ADD FOREIGN KEY (ticket_id) REFERENCES `ticket`(`id`); +ALTER TABLE ticket_history_type ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE ticket_history_type ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE ticket_history_type ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE article_type ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE article_type ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE article_type ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE article_sender_type ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE article_sender_type ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE article_sender_type ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE article_flag ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE article ADD FOREIGN KEY (article_sender_type_id) REFERENCES `article_sender_type`(`id`); +ALTER TABLE article ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE article ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE article ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE article ADD FOREIGN KEY (article_type_id) REFERENCES `article_type`(`id`); +ALTER TABLE article ADD FOREIGN KEY (ticket_id) REFERENCES `ticket`(`id`); +ALTER TABLE article_plain ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE article_plain ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE article_plain ADD FOREIGN KEY (article_id) REFERENCES `article`(`id`); +ALTER TABLE article_attachment ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE article_attachment ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE article_attachment ADD FOREIGN KEY (article_id) REFERENCES `article`(`id`); +ALTER TABLE standard_response ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE standard_response ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE standard_response ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE queue_standard_response ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE queue_standard_response ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE queue_standard_response ADD FOREIGN KEY (standard_response_id) REFERENCES `standard_response`(`id`); +ALTER TABLE queue_standard_response ADD FOREIGN KEY (queue_id) REFERENCES `queue`(`id`); +ALTER TABLE standard_attachment ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE standard_attachment ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE standard_attachment ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE standard_response_attachment ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE standard_response_attachment ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE standard_response_attachment ADD FOREIGN KEY (standard_response_id) REFERENCES `standard_response`(`id`); +ALTER TABLE standard_response_attachment ADD FOREIGN KEY (standard_attachment_id) REFERENCES `standard_attachment`(`id`); +ALTER TABLE auto_response_type ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE auto_response_type ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE auto_response_type ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE auto_response ADD FOREIGN KEY (type_id) REFERENCES `auto_response_type`(`id`); +ALTER TABLE auto_response ADD FOREIGN KEY (system_address_id) REFERENCES `system_address`(`id`); +ALTER TABLE auto_response ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE auto_response ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE auto_response ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE queue_auto_response ADD FOREIGN KEY (auto_response_id) REFERENCES `auto_response`(`id`); +ALTER TABLE queue_auto_response ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE queue_auto_response ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE queue_auto_response ADD FOREIGN KEY (queue_id) REFERENCES `queue`(`id`); +ALTER TABLE time_accounting ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE time_accounting ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE time_accounting ADD FOREIGN KEY (article_id) REFERENCES `article`(`id`); +ALTER TABLE time_accounting ADD FOREIGN KEY (ticket_id) REFERENCES `ticket`(`id`); +ALTER TABLE service ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE service ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE service_customer_user ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE sla ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE sla ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE sla ADD FOREIGN KEY (service_id) REFERENCES `service`(`id`); +ALTER TABLE customer_user ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE customer_user ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE customer_user ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE pop3_account ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE pop3_account ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE pop3_account ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE notifications ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE notifications ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE package_repository ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE package_repository ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`);

4 9

Missing 2.3 branch in bugzilla ?
by Yann Richard 02 Jun '08

02 Jun '08

Hi, I have posted bug for otrs 2.3.0 beta 1 but there is no specific version for this new branch in the bugtracker I have posted it as CVS. it's good for you ? the bug: http://bugs.otrs.org/show_bug.cgi?id=2940 Regards, -- M. Yann Richard yann.richard on gmail.com

2 1

Re: [dev] Java WebServiceClient for OTRS
by jonathan sartin 28 May '08

28 May '08

--------- Original Message -------- From: Development community of OTRS.org <dev(a)otrs.org> To: Development community of OTRS.org <dev(a)otrs.org> Subject: Re: [dev] Java WebServiceClient for OTRS Date: 09/05/08 07:41 > > jonathan sartin (jonathan(a)opennms.org) wrote: > > > It's not wsdl for the rpc-example.pl, but I have tested it with AXIS > > 1.4 (my requirement). You can use this module and wsdl for creating > > and retrieving simple tickets/articles. > > Hi, > > rpc/encoded works with Axis? It does with 1.4, anyway. >I'd prefer document/literal (wrapped) as rpc/encoded is not WS-I compliant. yeah, document/literal isn't exactly SOAP::Lite's strong point though. I suspect it's possible but I can't find any examples to work with. > I also have problems importing it into MS > VisualStudio (stubs aren't generated). That I can't help you with, I'm afraid. > BTW: You have to change the port address from > "http://localhost/otrs/opennms.pl" to whatever your local hostname is. > Yeah, you'd set the endpoint with something like: service = new TicketServiceLocator(); service.setTicketServicePortEndpointAddress(new java.lang.String("http://yourhost/otrs/opennms.pl")); rather than change the wsdl though. I guess I could have OTRS tweak the wsdl on the way through to reflect the hostname. Cheers ... J ________________________________________________ Message sent using UebiMiau 2.7.2

2 1

Re: [dev] [otrs] OTRS 2.2.6 : problem with Customer Companies listing
by Laurent Minost 28 May '08

28 May '08

Hi, Anyone having such a behaviour please ? In order for me to "debug" the problem, does anyone having OTRS 2.2.6 installed and working with an external MySQL database for Customer Companies can : - tell me if the link "Company" in Agent frontend is displaying companies properly - send me these files : -> Kernel/Config.pm -> Kernel/ZZZAuto.pm -> Kernel/ZZZAAuto.com -> Kernel/System/CustomerCompany.pm -> Kernel/Modules/AdminCustomerCompany.pm Thanks by advance, BR. Laurent MINOST Laurent Minost a écrit : > Hi, > > upgraded to OTRS 2.2.6 a few days ago and we are faced to a little problem : > > Under the Agent frontend, the Company link is not displaying anymore our > companies from our external DB, when I click on the Company link/Icon, > I'm only having nothing displayed, just the possibility to add a new > company. > > Tried to get the same configuration (Config.pm / Defaults.pm / > ZZZAuto.pm / ZZZAAuto.pm ...) with OTRS 2.2.5 and my companies are > listed properly. > > Did not find any OTRS bugzilla entry that could match this problem for > the moment. > Does anyone is having the same behaviour please or know how to solve it > (workaround or new 2.2.6 configuration maybe ? ) > > Thanks by advance. > > Best regards, > > Laurent > _______________________________________________ > 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 or consulting for your OTRS system? > => http://www.otrs.com/ > _______________________________________________ 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 or consulting for your OTRS system? => http://www.otrs.com/

1 1

FW: Help - Does OTRS provide interface to software integration likesalesforce/Vtrack?
by Nagender Kumar Mallik 21 May '08

21 May '08

Hi Torsten, If possible can you provide information about OTRS modules used for this purpose or steps to integrate the salesforce application? Thanks in advance, -Nagender -----Original Message----- From: dev-bounces(a)otrs.org [mailto:dev-bounces@otrs.org] On Behalf Of Torsten Thau Sent: Tuesday, May 20, 2008 7:01 PM To: Development community of OTRS.org Subject: Re: [dev] Help - Does OTRS provide interface to software integration likesalesforce/Vtrack? -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, > I am exploring the features of OTRS system. I have some queries > regarding integration of software's like salesforce/Vtrack? > > Does OTRS provide such a module interface for doing that? Kindly > provide the necessary details. there have already been a Salesforce-Integration [1]. So it's possible to interface OTRS and Salesforce but it will be a custom development. [1] http://www.otrs.com/fileadmin/mediafiles/Download/Success-Stories/Succes s-Stories-EN/Project-Description-Astaro.com_20071220.pdf regards, Torsten Thau - -- Torsten Thau, Dipl. Inform. c.a.p.e. IT GmbH - Annaberger Str. 240 - D-09125 Chemnitz phone: +49 371 5347 623 cell: +49 176 66 680 680 personal pgp-key: 0x93E0A174 company pgp-key: 0x292F987D fax: +49 371 5347 625 http://www.cape-it.de AG Chemnitz - HRB 23192 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFIMtKCvXo8m5PgoXQRAscFAJwI9R43LlDO39VKPCUleWutnHpKbwCffGWm SEKqp5+PuAuI29q1V0Y9KwE= =fcvP -----END PGP SIGNATURE----- _______________________________________________ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev

1 0

Help - Does OTRS provide interface to software integration likesalesforce/Vtrack?
by Nagender Kumar Mallik 20 May '08

20 May '08

Hi, I am exploring the features of OTRS system. I have some queries regarding integration of software's like salesforce/Vtrack? Does OTRS provide such a module interface for doing that? Kindly provide the necessary details. Looking forward for your response. Thanks and regards, Nagender

2 1

Rich text Formatting
by Go Wow 16 May '08

16 May '08

Hello I know this is not the right place to post this question here but I'm in a dire need to resolve this. We have tested the otrs software for our needs everything is fulfilled expect one which unfortuanetly came in last. We want to send HTML or Rich Text replies to all the tickets how to achieve it in Version 2.2. I have already tested this post http://lists.otrs.org/pipermail/otrs/2006-August/012101.html but the problem im facing right now is that all the text in the Textarea is getting merged to one line (like salutation, signature, body etc). Yes I want to add line breaks but dunno how to do it. If anyone can point few things that will be great.

1 0

Notification mechanism from ticket event handler?
by Axel Großklaus 16 May '08

16 May '08

moin, i'm developing an otrs module that is triggered by TicketEventHandlerPost on Event TicketQueueUpdate and reacts on tickets being moved to a specific queue. now i'd need some way to give back an error message to the webuser if something goes wrong, Something like LayoutObject->Notify(). but unfortunatley, since my module ist called by Kernel::Ticket::TicketEventHandlerPost and Ticket.pm is a core module, i dont have a layout object and so cannot use Notify(). I already do some logging via Kernel::System::Log, but that just goes to the system log and so i cannot use to to notify the web user. is there any other way, a module triggered by a ticket event can give any feedback to the web user? i thought about adding an "error report article" to the ticket, but thats a bit too permanent for just a small error message.. tty, axel -- Dipl.-Inform. Axel Großklaus ag(a)pre-secure.de Senior Researcher Phone (+49) 040 / 8080 77 - 880 Fax (+49) 040 / 8080 77 - 877 PRESECURE Consulting GmbH, Muenster AG Münster, HRB 6581 Geschäftsführer/Managing Director Dr. Klaus-Peter Kossakowski CarmentiS - Early Warning Expertise https://www.carmentis.org

1 0