date:20100714

Re: [otrs] upgrade issues from 2.2.x to 2.4.x

2010-07-14 Thread Isaac Gonzalez

For anyone that cared, I resolved this by changing all of the tables
needing the foreign key mapping to innodb. All new tables are config'd
for innodb storage and the references table below were myisam(left over
from old install). Thus the script created new innodb tables and
couldn't create foreign keys to myisam tablesthey need to be the
same...

 

Up and running with otrs 2.3.5 for a couple of daysthen plan to go
to 2.4.7yay yay!!!

 

From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of
Isaac Gonzalez
Sent: Sunday, July 11, 2010 12:45 AM
To: User questions and discussions about OTRS.
Subject: Re: [otrs] upgrade issues from 2.2.x to 2.4.x

 

After a bit more investigation here are the real errors from sql...


---

Upgrading from 2.2.x to 2.4.x(cent os 5, mysql 4.1.18)

 

I ran into some errors during the db upgrade for mysql for 2.2 to 2.3

The first error was on line 4 for the statement

 

ALTER TABLE sla DROP FOREIGN KEY FK_sla_service_id_id;

There is no foreign key in that table in my 2.2.4 install!

Gave the "error of rename of dbname\sla to #sql2-25000-b"

 

 

And then every alter statement below that tried to add a constraint also
gave back an error cannot create table \dbname\#sql - 2500_b.frm

All of the below really give the error:

100711  0:16:57 Error in foreign key constraint of table
otrsnew/#sql-19a8_39:

 FOREIGN KEY (ticket_id) REFERENCES ticket (id):

Cannot resolve table name close to:

 (id)

And similar for each Reference the foreign key is trying to make via
each statement

ALTER TABLE ticket_watcher ADD CONSTRAINT FK_ticket_watcher_ticket_id_id
FOREIGN KEY (ticket_id) REFERENCES ticket (id);

ALTER TABLE ticket_watcher ADD CONSTRAINT FK_ticket_watcher_user_id_id
FOREIGN KEY (user_id) REFERENCES users (id);

ALTER TABLE ticket_watcher ADD CONSTRAINT FK_ticket_watcher_create_by_id
FOREIGN KEY (create_by) REFERENCES users (id);

ALTER TABLE ticket_watcher ADD CONSTRAINT FK_ticket_watcher_change_by_id
FOREIGN KEY (change_by) REFERENCES users (id);

ALTER TABLE queue_preferences ADD CONSTRAINT
FK_queue_preferences_queue_id_id FOREIGN KEY (queue_id) REFERENCES queue
(id);

ALTER TABLE service_sla ADD CONSTRAINT FK_service_sla_service_id_id
FOREIGN KEY (service_id) REFERENCES service (id);

ALTER TABLE service_sla ADD CONSTRAINT FK_service_sla_sla_id_id FOREIGN
KEY (sla_id) REFERENCES sla (id);

ALTER TABLE link_type ADD CONSTRAINT FK_link_type_create_by_id FOREIGN
KEY (create_by) REFERENCES users (id);

ALTER TABLE link_type ADD CONSTRAINT FK_link_type_change_by_id FOREIGN
KEY (change_by) REFERENCES users (id);

ALTER TABLE link_type ADD CONSTRAINT FK_link_type_valid_id_id FOREIGN
KEY (valid_id) REFERENCES valid (id);

ALTER TABLE link_state ADD CONSTRAINT FK_link_state_create_by_id FOREIGN
KEY (create_by) REFERENCES users (id);

ALTER TABLE link_state ADD CONSTRAINT FK_link_state_change_by_id FOREIGN
KEY (change_by) REFERENCES users (id);

ALTER TABLE link_state ADD CONSTRAINT FK_link_state_valid_id_id FOREIGN
KEY (valid_id) REFERENCES valid (id);

ALTER TABLE link_relation ADD CONSTRAINT
FK_link_relation_source_object_id_id FOREIGN KEY (source_object_id)
REFERENCES link_object (id);

ALTER TABLE link_relation ADD CONSTRAINT
FK_link_relation_target_object_id_id FOREIGN KEY (target_object_id)
REFERENCES link_object (id);

ALTER TABLE link_relation ADD CONSTRAINT FK_link_relation_state_id_id
FOREIGN KEY (state_id) REFERENCES link_state (id);

ALTER TABLE link_relation ADD CONSTRAINT FK_link_relation_type_id_id
FOREIGN KEY (type_id) REFERENCES link_type (id);

ALTER TABLE link_relation ADD CONSTRAINT FK_link_relation_create_by_id
FOREIGN KEY (create_by) REFERENCES users (id);

ALTER TABLE article_search ADD CONSTRAINT
FK_article_search_article_sender_type_id_id FOREIGN KEY
(article_sender_type_id) REFERENCES article_sender_type (id);

ALTER TABLE article_search ADD CONSTRAINT
FK_article_search_article_type_id_id FOREIGN KEY (article_type_id)
REFERENCES article_type (id);

ALTER TABLE article_search ADD CONSTRAINT FK_article_search_ticket_id_id
FOREIGN KEY (ticket_id) REFERENCES ticket (id);

-
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

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/

Re: [otrs] SOAP problem

2010-07-14 Thread Sandor Feher


 Hi Roy,

Thanks a lot! I changed sysread to read accordingly and now it works fine.

regards., Sandor



2010.07.14. 22:01 keltezéssel, Roy Kaldung írta:

On 7/14/10 3:47 PM, Sándor Fehér wrote:

Hi,

I would like to create tickets and articles via OTRS SOAP interface.
This is what I have done so far.

- added SOAP user and pass at OTRS Administrator menu 
(Framework-Core::SOAP)

- installed SOAP::Lite Perl package
- ran otrs.checkModules it looks fine.
- ran rpc-example.pl with the appropriate params (url, user, pass).

The last point always fail with the following: (I added trace=>'all' to
see what's wrong with it)
Apache's error log says nothing  nor otrs log as well. So I really
appreciate any idea where should I continue debugging.
Thank you in advance!



Server: Apache/2.2.3 (Debian) PHP/5.2.0-8+etch11 mod_perl/2.0.2 
Perl/v5.8.8

Content-Length: 603
Content-Type: text/xml; charset=utf-8
Client-Date: Wed, 14 Jul 2010 13:43:50 GMT
Client-Peer: 192.168.1.10:80
Client-Response-Num: 1
SOAPServer: SOAP::Lite/Perl/0.712



Hi,

checj this bug report:
https://rt.cpan.org/Public/Bug/Display.html?id=58538

I solved the issue after I replaced the sysread command in 
SOAP/Transport/HTTP.pm with read.


regards,
Roy





-
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

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/

Re: [otrs] SOAP problem

2010-07-14 Thread Roy Kaldung


On 7/14/10 3:47 PM, Sándor Fehér wrote:

Hi,

I would like to create tickets and articles via OTRS SOAP interface.
This is what I have done so far.

- added SOAP user and pass at OTRS Administrator menu (Framework-Core::SOAP)
- installed SOAP::Lite Perl package
- ran otrs.checkModules it looks fine.
- ran rpc-example.pl with the appropriate params (url, user, pass).

The last point always fail with the following: (I added trace=>'all' to
see what's wrong with it)
Apache's error log says nothing  nor otrs log as well. So I really
appreciate any idea where should I continue debugging.
Thank you in advance!




Server: Apache/2.2.3 (Debian) PHP/5.2.0-8+etch11 mod_perl/2.0.2 Perl/v5.8.8
Content-Length: 603
Content-Type: text/xml; charset=utf-8
Client-Date: Wed, 14 Jul 2010 13:43:50 GMT
Client-Peer: 192.168.1.10:80
Client-Response-Num: 1
SOAPServer: SOAP::Lite/Perl/0.712



Hi,

checj this bug report:
https://rt.cpan.org/Public/Bug/Display.html?id=58538

I solved the issue after I replaced the sysread command in 
SOAP/Transport/HTTP.pm with read.


regards,
Roy



--
Roy Kaldung
e-mail: r...@kaldung.com
web: http://kaldung.com/
gpg key: 2A4D6A9D 
-
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

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/

[otrs] Multiple mails by User

2010-07-14 Thread Martin Waichman

 

I`m trying to configure an OTRS instance, but i need to send the
notification to the user via Mail and SMS, I have an address to send the
email to SMS, but I can`t find how to configure one user with two address.

Someone made this kind of configuration ??

 

 

 

Martin Waichman

Director

Serbiznet

 

Office: +54 2320 657350   Fax: +54 2320 657350 ext 21

Cell: +54 911 6863 2555   email: mwaich...@serbiznet.com

USA: +1 512 212 4446   

Mexico: +52 55 8421 8572  

 

 

SBN70serbiz net

P Please consider the environment before printing this e-mail.

 

<>-
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

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/

Re: [otrs] Working time function

2010-07-14 Thread Alejandra Piedra

Hey there!

Any hints on this issue?

Thanks and regards
Maria Alejandra Piedra

De: Alejandra Piedra
Enviado el: Lunes, 12 de Julio de 2010 10:58 a.m.
Para: 'otrs@otrs.org'
Asunto: Working time function

Hello!

I'm trying to use the $TimeObject->WorkingTime() function, but is not returning 
anything!
Am I doing something wrong? I already checked the parameters, but still is not 
returning anything

Thanks and regards!
María Alejandra Piedra

-
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

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/

[otrs] SOAP problem

2010-07-14 Thread Sándor Fehér

Hi,

I would like to create tickets and articles via OTRS SOAP interface.
This is what I have done so far.

- added SOAP user and pass at OTRS Administrator menu (Framework-Core::SOAP)
- installed SOAP::Lite Perl package
- ran otrs.checkModules it looks fine.
- ran rpc-example.pl with the appropriate params (url, user, pass).

The last point always fail with the following: (I added trace=>'all' to
see what's wrong with it)
Apache's error log says nothing  nor otrs log as well. So I really
appreciate any idea where should I continue debugging.
Thank you in advance!

rbs:/opt/otrs/scripts# ./rpc-example.pl
Subroutine LWP::UserAgent::redirect_ok redefined at
/usr/local/share/perl/5.8.8/SOAP/Transport/HTTP.pm line 44.
Subroutine LWP::Protocol::collect redefined at
/usr/local/share/perl/5.8.8/SOAP/Transport/HTTP.pm line 65.
Subroutine SOAP::Trace::transport redefined at
/usr/local/share/perl/5.8.8/SOAP/Lite.pm line 2905.
Subroutine SOAP::Trace::dispatch redefined at
/usr/local/share/perl/5.8.8/SOAP/Lite.pm line 2905.
Subroutine SOAP::Trace::result redefined at
/usr/local/share/perl/5.8.8/SOAP/Lite.pm line 2905.
Subroutine SOAP::Trace::parameters redefined at
/usr/local/share/perl/5.8.8/SOAP/Lite.pm line 2905.
Subroutine SOAP::Trace::headers redefined at
/usr/local/share/perl/5.8.8/SOAP/Lite.pm line 2905.
Subroutine SOAP::Trace::objects redefined at
/usr/local/share/perl/5.8.8/SOAP/Lite.pm line 2905.
Subroutine SOAP::Trace::method redefined at
/usr/local/share/perl/5.8.8/SOAP/Lite.pm line 2905.
Subroutine SOAP::Trace::fault redefined at
/usr/local/share/perl/5.8.8/SOAP/Lite.pm line 2905.
Subroutine SOAP::Trace::freeform redefined at
/usr/local/share/perl/5.8.8/SOAP/Lite.pm line 2905.
Subroutine SOAP::Trace::trace redefined at
/usr/local/share/perl/5.8.8/SOAP/Lite.pm line 2905.
Subroutine SOAP::Trace::debug redefined at
/usr/local/share/perl/5.8.8/SOAP/Lite.pm line 2905.
SOAP::Lite::call: ()
SOAP::Serializer::envelope: ()
SOAP::Serializer::envelope: new
SOAP::Data::new: ()
SOAP::Data::new: ()
SOAP::Data::new: ()
SOAP::Data::new: ()
SOAP::Transport::HTTP::Client::send_receive: HTTP::Request=HASH(0x84fec2c)
SOAP::Transport::HTTP::Client::send_receive: POST
http://192.168.1.10/otrs/rpc.pl HTTP/1.1
Accept: text/xml
Accept: multipart/*
Accept: application/soap
Content-Length: 403
Content-Type: text/xml; charset=utf-8
SOAPAction: "/Core#new"

http://www.w3.org/2001/XMLSchema-instance";
xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/";
xmlns:xsd="http://www.w3.org/2001/XMLSchema";
soap:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/";
xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/";>
SOAP::Transport::HTTP::Client::send_receive: HTTP::Response=HASH(0x9c0)
SOAP::Transport::HTTP::Client::send_receive: HTTP/1.1 500 Internal
Server Error
Connection: close
Date: Wed, 14 Jul 2010 13:43:50 GMT
Server: Apache/2.2.3 (Debian) PHP/5.2.0-8+etch11 mod_perl/2.0.2 Perl/v5.8.8
Content-Length: 603
Content-Type: text/xml; charset=utf-8
Client-Date: Wed, 14 Jul 2010 13:43:50 GMT
Client-Peer: 192.168.1.10:80
Client-Response-Num: 1
SOAPServer: SOAP::Lite/Perl/0.712




-- 
Üdvözlettel/Kind Regards, Fehér Sándor


...Fehér Sándor...---Sandor Feher 
 fejlesztési vezető   --- development manager
 Blue System Kft. ---  Blue System Ltd. 
..
http://www.bluesystem.hu : http://www.adatmegorzo.hu : http://www.bluehosting.hu
..

Kérem gondoljon a környezetre mielőtt kinyomtatná ezt az e-mailt vagy bármely 
csatolmányát.
Please consider the environment before printing this e-mail and any associated 
attachments.

-
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

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/

Re: [otrs] upgrade issues from 2.2.x to 2.4.x

Re: [otrs] SOAP problem

Re: [otrs] SOAP problem

[otrs] Multiple mails by User

Re: [otrs] Working time function

[otrs] SOAP problem

6 matches

Site Navigation

Mail list logo

Footer information