Re: [rt-users] MySQL issue - Windows vs. Linux - Table name case seems to matter
Stephen, MySQL does not maintain internal dictionary where it could keep the list of tables (but InnoDB does for its own purpose!). Instead, MySQL relies on the information from the underlying file system. Since Windows does not care about case of file names, 'users.frm', 'Users.frm' and 'UsErS.frm' are all the same file, in MySQL 'users', 'Users' and 'USERS' will all be the same table. On the other hand, Linux has case sensitive file names, so 'users.frm' and 'Users.frm' are two different files. In this case 'users' and 'Users' also become two different tables. Your problem is easy to fix, but the solution will depend on how the MySQL server on Windows was configured and how the tables were created both in MySQL and on disk. Typically either performing dump restore or setting lower_case_table_names=1 option (or both) on Linux is enough, however in certain circumstances it may not be. Please refer to this page http://dev.mysql.com/doc/refman/5.5/en/identifier-case-sensitivity.html as it will most likely contain the answers you need. Maciek
[rt-users] Modify CF dropdown list from external DB based off of another CFs value
I have 2 ticket CFs (Version_No and Product) i currently have a perl script to update the Version_No CF drop down list from an external database with a manually set Where value set in the code. (This all works fine for controlling the drop down list values to show only the version numbers for the manually set product) i would now like to modify the code to allow the drop down list to be updated with values which contain the same catagory as the value set in the Product CF, similar to using the Categories are based on Field when you create your own list To do this i have added the following line my $dbwherevalue = $self-TicketObj-FirstCustomFieldValue('Product'); but i also get the following error [error]: Can't locate object method TicketObj via package RT::CustomFieldValues::Version_No at /opt/rt4/sbin/../lib/RT/CustomFieldValues/Version_No.pm line 60 would someone be able to advice me what to do to resolve this error below is my code ---CODE START--- ## ##Prep ## package RT::CustomFieldValues::Version_No; use strict; use warnings; use DBI; use DBD::Mysql; use base qw(RT::CustomFieldValues::External); ## ##List Description ## sub SourceDescription { return 'Version Numbers'; } ## ##VARIABLES ## sub ExternalValues { my $self = shift; # External Database details my $dbhost = [HostName]; my $dbtype = [DatabaseType]; my $dbname = [DatabaseName]; my $dbtable=customfieldvalue; my $dbcolumn=Name; my $dbwherecolumn=Category; #my $dbwherevalue='Testing1234'; my $dbwherevalue = $self-TicketObj-FirstCustomFieldValue('Product'); my $dbuser = [UserName]; my $dbpass = [Password]; my $i = 0; my @res; my $Hostname; ## ##Connect to Database ## #Database on remote server my $dbh = DBI-connect(DBI:$dbtype:$dbname;host=$dbhost, $dbuser, $dbpass, { RaiseError = 1 } ); ## ##Run Search of DB for values you wish in CF List ## my $req = SELECT distinct $dbcolumn FROM $dbtable where $dbwherecolumn=$dbwherevalue; my $hreq = $dbh-prepare($req); $hreq-execute();; $hreq-bind_columns(\$Hostname); while ($hreq-fetch()){ push @res, { name= $Hostname, description = $Hostname, sortorder = $i++, }; } return \@res; } RT::Base-_ImportOverlays(); 1; ---CODE END- thank you in advanced Scott -- View this message in context: http://requesttracker.8502.n7.nabble.com/Modify-CF-dropdown-list-from-external-DB-based-off-of-another-CFs-value-tp55012.html Sent from the Request Tracker - User mailing list archive at Nabble.com.
Re: [rt-users] Modify CF dropdown list from external DB based off of another CFs value
I had a similar need. But instead of connecting to an external database from within RT, I put together 2 scripts to check for content change and dump and load my custom fields in cron. In my case, I was pulling time sheet codes which are: client_project and task_code. Each client_project has specific task_codes so task_codes is dependent on client_project. Mine is probably way more complicated than you need and could be done easier in perl. I'm a bash man at heart so here is my method. They could be run from one script as long as the server has access to get to both databases. Since custom fields are added to transactions as the actual field values (and not relational by id's) this was the best way foe me to get this done. During the day if the finance department adds or removes codes, within an hour the RT system is updated. Also in my case, client_project and task_code are each concatenated from 4 fields in my original search (fields 1 and 2 make up client_project and fields 3 and 4 make up task_code). Hope this helps in some way and apologies for the long message... The first script is run on the external server and creates a load file. This script is run every hour between 8am and 5pm from cron. #!/bin/bash NEWFILE=/tmp/codes.txt OLDFILE=/tmp/codes.last /bin/mv $NEWFILE $OLDFILE /usr/bin/psql -A -t -c select field1,field2 from table where criteria like 'your_criteria' -U postgres_user databasename $NEWFILE if /usr/bin/diff $NEWFILE $OLDFILE /dev/null ; then echo NoChanges /tmp/codes.status else echo Changes /tmp/codes.status fi Then on another server, I look at the codes.status file and check for changes. If there are, I pull over the file and dump and load the customfieldvalues table where the customfield is in my case 1 and 2. This script is run 5 minutes after the other one. #!/bin/bash HOME=/path/to/scripts STATUSFILE=/tmp/codes.status LOADFILE=/tmp/codes.txt LASTFILE=/tmp/codes.txt LOGFILE=$HOME/codes.log PGSERVER=RT_PGSERVERNAME_REDACTED PGUSER=RT_USER_REDACTED PGDB=RT_DBNAME_REDACTED TODAY=`date +%Y-%m-%d-%H:%M:%S` echo Starting script at $TODAY # Start logging exec (tee $LOGFILE) exec 21 #Fetch status file scp root@EXT_SERVERNAME_REDACTED:$STATUSFILE /tmp/ STATUS=`cat $STATUSFILE` echo $STATUS $LOGFILE if [ $STATUS == Changes ] ; then echo Making Changes $LOGFILE # Fetch update file scp root@EXT_SERVERNAME_REDACTED:$LOADFILE /tmp/ # Clean up previous sql load files and remove the old custom fields rm -f $HOME/client_project.* rm -f $HOME/task_code.* rm -f $HOME/sequence.tmp mv $HOME/client_project_backup $HOME/client_project_backup-$TODAY psql -A -t -c select * from customfieldvalues where customfield='1' -h $PGSERVER -U $PGUSER $PGDB $HOME/client_project_backup psql -A -t -c select * from customfieldvalues where customfield='2' -h $PGSERVER -U $PGUSER $PGDB $HOME/task_code_backup psql -A -c delete from customfieldvalues where customfield='1' -h $PGSERVER -U $PGUSER $PGDB psql -A -c delete from customfieldvalues where customfield='2' -h $PGSERVER -U $PGUSER $PGDB # Add a placeholder to notify users that update is taking place psql -A -c insert into customfieldvalues (customfield,name,creator,created) values ('1','Tasks are being updated. Refresh in 2-5 minutes','22',now()) -h $PGSERVER -U $PGUSER $PGDB # Start numbering echo 5 $HOME/sequence.tmp # Parse through load file and capture variables to populate Client/Project field OIFS=$IFS IFS=' ' for m in `cat $LOADFILE` do CLIENT=`echo $m|cut -d| -f1` PROJECT=`echo $m|cut -d| -f2` CLIENTPROJECT=${CLIENT}[${PROJECT}] echo $CLIENTPROJECT $HOME/client_project.tmp done # Get Unique Client Project Codes to load to database cat $HOME/client_project.tmp |sort -u $HOME/client_project.txt OIFS=$IFS IFS=' ' for c in `cat $HOME/client_project.txt` do NAME=`echo $c |cut -d| -f1` # Send load file info to SQL file for troubleshooting, then update the database with the new Client Project Values echo psql -A -c \insert into customfieldvalues (customfield,name,creator,created) values ('1','$c','22',now())\ -h $PGSERVER -U $PGUSER $PGDB $HOME/client_project.sql psql -A -c insert into customfieldvalues (customfield,name,creator,created) values ('1','$c','22',now()) -h $PGSERVER -U $PGUSER $PGDB #Increment sequence file for sorting in the Web GUI sequence=`tail -n1 $HOME/sequence.tmp` SEQUENCE=`expr $sequence + 5` CLEANNAME=`echo $NAME |sed -e 's/\[/\|/g; s/\]//g'` # Using the formatted Client/Project codes, loop through the loadfile and capture Task codes for each Client/Project code OIFS=$IFS IFS=' ' for task in `cat $LOADFILE|grep $CLEANNAME` do TASK=`echo $task|cut -d| -f3` CODE=`echo $task|cut -d| -f4` CLIENT=`echo $task|cut -d| -f1` PROJECT=`echo $task|cut -d| -f2` CLIENTPROJECT=${CLIENT}[${PROJECT}] TASKCODE=${TASK}[${CODE}] echo psql -A -c \insert into customfieldvalues (customfield,name,creator,created,category,sortorder) values ('2','$TASKCODE','22',now(),'$CLIENTPROJECT','$SEQUENCE')\ -h $PGSERVER -U $PGUSER $PGDB
Re: [rt-users] MySQL issue - Windows vs. Linux - Table name
Maciek - I figured it was more a MySQL issue than an RT one. I manually went in changed each table to the correct one (users to Users) and that appeared to work. However, this won't fix my problem if I have to move several databases over (we have a lot of MySQL dependant apps here). Thank you for the link. I'll take a look at it today see if it will help. I'm just glad to know it's a MySQL issue and not an RT one! Steve
Re: [rt-users] RT-at-a-Glance Saved Searches not showing RT System searches
Joe - it helps if you trim the rest of the digest when replying. On Tue, Aug 13, 2013 at 12:43:08PM -0400, Joe Kirby wrote: I would like to know how to make RT System Searches show when the Saved Searches is added to RT-at-a-Glance. This is a great feature for My Closed Tickets type reports that are really not needed on the page as its own. At this time it seems like only SuperUser gets these. Is there a setting that would allow this? Thanks in advance Usually when I do not hear back on a topic it means that it is either not clear what I am asking for or it is a stupid question. I have looked back through the wiki again with no luck on how to have RT System Searches available to the delivered Saved Search. The reports saved as RT System Searches are available to be placed on the RT-at-a-Glance but do not show up in the Saved Search option. I am trying to avoid having to generate many copies of a system wide report so it shows up in folks Saved Search collection. At the risk of being an annoyance I am reporting Thanks in advance RT System Searches don't automatically show up for all users unless their name is in a specific format (compare with the system default searches we ship). I consider this an oversight, and it'll probably be fixed in a future release. At this time, your best solution is finding the widest group you can and assigning the search to that group. -kevin pgpUo4_6ZF9FJ.pgp Description: PGP signature
Re: [rt-users] sendmailpipe returns EX_TEMPFAIL
On Tue, Aug 13, 2013 at 10:55:57AM +0200, Nathan Cutler wrote: Does anyone have any other ideas for debugging this issue? Especially I am interested in how I could confirm or deny that it's related to mod_perl cohabitation -- i.e. two different Perl applications in a single mod_perl host? I noticed that when I don't have PerlOptions +Parent in the apache config, the Perl library search order on the System Configuration page is different than when I do. Here's what it looks like _without_ PerlOptions +Parent (omitting the line numbers which do not copy-paste): Perl library search order /usr/share/request-tracker/local/lib /usr/share/request-tracker/local/plugins/RT-Extension-MergeUsers/lib /usr/lib/perl5/vendor_perl/5.10.0 /usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi /srv/www/perl-lib /srv/www/vhosts/pdb/ /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi /usr/lib/perl5/site_perl/5.10.0 /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.10.0/x86_64-linux-thread-multi /usr/lib/perl5/5.10.0 . /srv/www Notice lines 5 and 6 which obviously come from the other mod_perl application. Now, here's what it says _with_ PerlOptions +Parent: Perl library search order /usr/share/request-tracker/local/lib /usr/share/request-tracker/local/plugins/RT-Extension-MergeUsers/lib /usr/lib/perl5/vendor_perl/5.10.0 /usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi /usr/lib/perl5/site_perl/5.10.0 /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.10.0/x86_64-linux-thread-multi /usr/lib/perl5/5.10.0 . /srv/www So maybe the problem is solved? I did have PerlOptions +Parent in the apache configuration before, but maybe not correctly? I checked the other application's vhosts file and it _does_ have PerlOptions +Parent. While PerlOptions +Parent is important if you need to run two mod_perl apps, you should keep your log in place, and possibly dig up one of the shims from the mailing list archives that has been used to debug this. In the past, it was bugs in mod_perl and the handler type, but it's nearly impossible to debug from the standard RT debug and mail logs. -kevin pgpyQVSUZUDNE.pgp Description: PGP signature
Re: [rt-users] Re-send a previously attached attachment?
On Tue, Aug 13, 2013 at 09:49:54PM +, Beachey, Kendric wrote: -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Boli Sent: Tuesday, August 13, 2013 3:36 PM To: RT users Subject: [rt-users] Re-send a previously attached attachment? Hi All, Apologies if I have missed something obvious. How can I re-send an attachment that has previously been attached to a ticket without downloading it and re-attaching it. For example, if a new requestor or CC is added to a ticket, and I want to get them up to date quickly by referring to previously discussed/attached information. Comments/Suggestions welcomed Regards, Point them to the web view of the ticket? The attachment should be there in the ticket history, so they can download/view it at their leisure. (assuming you don't have a security policy that would prevent this) The alternate (attaching a previously attached attachment to a new reply) is something we've explored in a few branches with clients, but nothing we've written has stuck or been right for mainstream release. -kevin pgpVxdg53TJnN.pgp Description: PGP signature
Re: [rt-users] sendmailpipe returns EX_TEMPFAIL
On 08/14/2013 07:35 AM, Kevin Falcone wrote: So maybe the problem is solved? I did have PerlOptions +Parent in the apache configuration before, but maybe not correctly? I checked the other application's vhosts file and it _does_ have PerlOptions +Parent. While PerlOptions +Parent is important if you need to run two mod_perl apps, you should keep your log in place, and possibly dig up one of the shims from the mailing list archives that has been used to debug this. In the past, it was bugs in mod_perl and the handler type, but it's nearly impossible to debug from the standard RT debug and mail logs. Adding on to what Kevin said... You could also just save yourself some time and switch to a different deployment option for RT. Running it under mod_fastcgi or mod_fcgid is simple and would avoid any mod_perl bugs with +Parent. Why fight with mod_perl?
[rt-users] Groups in LDAP
I have successfully setup RT4.0.17 on a CentOS 6.4 machine with RT::Authen::ExternalAuth to authenticate against our OpenLDAP. My question is, can I have certain groups in LDAP that are automatically privileged in RT? Like setup a helpdesk group and everyone in there are automatically set with the proper abilities. -- Donny B.
[rt-users] RT4 and GIT; RT4 and Eclipse
1) Re: GIT - RT4 integration: ---Does anyone know of a way to tie a commit (in GIT) to a ticket in RT4, by putting an RT ticket # in the commit (and, ideally, back to the code)? 2) Does anyone know of a way to connect Eclipse and RT4 (mylin used to do this with an older version of RT)? Thanks! Lisa :) Lisa Tomalty Information Systems Technology/Arts Computing Office MC 2052/PAS 2023 University of Waterloo Waterloo, Ontario, Canada MC2025/PAS1083 (519) 888-4567 X35873 ltoma...@uwaterloo.camailto:ltoma...@uwaterloo.ca
Re: [rt-users] RT4 and GIT; RT4 and Eclipse
1) Re: GIT - RT4 integration: ---Does anyone know of a way to tie a “commit” (in GIT) to a ticket in RT4, by putting an RT ticket # in the commit (and, ideally, back to the code)? Git has hooks where you can call specific scripts at different stages in the commit process. You should be able to use a post-commit hook to poke at RT and do what you need. 2) Does anyone know of a way to connect Eclipse and RT4 (mylin used to do this with an older version of RT)? Not familiar with either of those, so I can't be of much help here. University of Waterloo Waterloo, Ontario, Canada Go Warriors! Thanks, Jok
Re: [rt-users] Groups in LDAP
There is an extension that will allow you to import groups from LDAP into RT. The extension, by default, just loads users, then groups. My patch (which is in the queue for that extension -- see below), adds a filter to the config to automatically privilege those users that match a second search. You can find the patch here: https://rt.cpan.org/Public/Bug/Display.html?id=76926 It is far from the most elegant way of doing this, but It Works For Me() Thanks, Jok -- | Joachim Thuau | IT Systems Engineer - Linux / SpaceX | On 8/14/13 8:42 AM, Donny Brooks dbro...@mdah.state.ms.us wrote: I have successfully setup RT4.0.17 on a CentOS 6.4 machine with RT::Authen::ExternalAuth to authenticate against our OpenLDAP. My question is, can I have certain groups in LDAP that are automatically privileged in RT? Like setup a helpdesk group and everyone in there are automatically set with the proper abilities. -- Donny B.
Re: [rt-users] rt-users Digest, Vol 113, Issue 20
psql -A -c delete from customfieldvalues where customfield='2' -h $PGSERVER -U $PGUSER $PGDB # Add a placeholder to notify users that update is taking place psql -A -c insert into customfieldvalues (customfield,name,creator,created) values ('1','Tasks are being updated. Refresh in 2-5 minutes','22',now()) -h $PGSERVER -U $PGUSER $PGDB # Start numbering echo 5 $HOME/sequence.tmp # Parse through load file and capture variables to populate Client/Project field OIFS=$IFS IFS=' ' for m in `cat $LOADFILE` do CLIENT=`echo $m|cut -d| -f1` PROJECT=`echo $m|cut -d| -f2` CLIENTPROJECT=${CLIENT}[${PROJECT}] echo $CLIENTPROJECT $HOME/client_project.tmp done # Get Unique Client Project Codes to load to database cat $HOME/client_project.tmp |sort -u $HOME/client_project.txt OIFS=$IFS IFS=' ' for c in `cat $HOME/client_project.txt` do NAME=`echo $c |cut -d| -f1` # Send load file info to SQL file for troubleshooting, then update the database with the new Client Project Values echo psql -A -c \insert into customfieldvalues (customfield,name,creator,created) values ('1','$c','22',now())\ -h $PGSERVER -U $PGUSER $PGDB $HOME/client_project.sql psql -A -c insert into customfieldvalues (customfield,name,creator,created) values ('1','$c','22',now()) -h $PGSERVER -U $PGUSER $PGDB #Increment sequence file for sorting in the Web GUI sequence=`tail -n1 $HOME/sequence.tmp` SEQUENCE=`expr $sequence + 5` CLEANNAME=`echo $NAME |sed -e 's/\[/\|/g; s/\]//g'` # Using the formatted Client/Project codes, loop through the loadfile and capture Task codes for each Client/Project code OIFS=$IFS IFS=' ' for task in `cat $LOADFILE|grep $CLEANNAME` do TASK=`echo $task|cut -d| -f3` CODE=`echo $task|cut -d| -f4` CLIENT=`echo $task|cut -d| -f1` PROJECT=`echo $task|cut -d| -f2` CLIENTPROJECT=${CLIENT}[${PROJECT}] TASKCODE=${TASK}[${CODE}] echo psql -A -c \insert into customfieldvalues (customfield,name,creator,created,category,sortorder) values ('2','$TASKCODE','22',now(),'$CLIENTPROJECT','$SEQUENCE')\ -h $PGSERVER -U $PGUSER $PGDB $HOME/task_code.sql psql -A -c insert into customfieldvalues (customfield,name,creator,created,category,sortorder) values ('2','$TASKCODE','22',now(),'$CLIENTPROJECT','$SEQUENCE') -h $PGSERVER -U $PGUSER $PGDB echo $SEQUENCE $HOME/sequence.tmp done done psql -A -c delete from customfieldvalues where name='Tasks are being updated. Refresh in 2-5 minutes' -h $PGSERVER -U $PGUSER $PGDB echo Complete $LOGFILE else echo No Changes$LOGFILE fi -- next part -- An HTML attachment was scrubbed... URL: http://lists.bestpractical.com/pipermail/rt-users/attachments/20130814/75815045/attachment-0001.html -- Message: 2 Date: Wed, 14 Aug 2013 08:19:38 -0400 From: Cena, Stephen \(ext. 300\) s...@qvii.com To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] MySQL issue - Windows vs. Linux - Table name Message-ID: 4dd6ab329450d847913ea76d7f3c6b8312f7f...@valkyrie.ogp.qvii.com Content-Type: text/plain; charset=us-ascii Maciek - I figured it was more a MySQL issue than an RT one. I manually went in changed each table to the correct one (users to Users) and that appeared to work. However, this won't fix my problem if I have to move several databases over (we have a lot of MySQL dependant apps here). Thank you for the link. I'll take a look at it today see if it will help. I'm just glad to know it's a MySQL issue and not an RT one! Steve -- Message: 3 Date: Wed, 14 Aug 2013 10:33:03 -0400 From: Kevin Falcone falc...@bestpractical.com To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] RT-at-a-Glance Saved Searches not showing RT System searches Message-ID: 20130814143303.gi2...@jibsheet.com Content-Type: text/plain; charset=us-ascii Joe - it helps if you trim the rest of the digest when replying. On Tue, Aug 13, 2013 at 12:43:08PM -0400, Joe Kirby wrote: I would like to know how to make RT System Searches show when the Saved Searches is added to RT-at-a-Glance. This is a great feature for My Closed Tickets type reports that are really not needed on the page as its own. At this time it seems like only SuperUser gets these. Is there a setting that would allow this? Thanks in advance Usually when I do not hear back on a topic it means that it is either not clear what I am asking for or it is a stupid question. I have looked back through the wiki again with no luck on how to have RT System Searches available to the delivered Saved Search. The reports saved as RT System Searches are available to be placed on the RT-at-a-Glance but do not show up in the Saved Search option. I am trying to avoid having to generate many copies of a system wide report so it shows up in folks Saved Search collection. At the risk of being an annoyance I am
Re: [rt-users] RT4 and GIT; RT4 and Eclipse
On 08/14/2013 12:09 PM, Jok Thuau wrote: 1) Re: GIT - RT4 integration: ---Does anyone know of a way to tie a “commit” (in GIT) to a ticket in RT4, by putting an RT ticket # in the commit (and, ideally, back to the code)? Git has hooks where you can call specific scripts at different stages in the commit process. You should be able to use a post-commit hook to poke at RT and do what you need. 2) Does anyone know of a way to connect Eclipse and RT4 (mylin used to do this with an older version of RT)? Not familiar with either of those, so I can't be of much help here. University of Waterloo Waterloo, Ontario, Canada Go Warriors! Thanks, Jok RT::Integration::SVN is a start but has some significant limitations. I took a look at a year or so ago. Jeff
[rt-users] Malformed RT response when trying to create ticket from cli (rt)
Hi RT version 4.0.13 I am having problems creating ticket from REST interface [root@myrt RestClient]# RTDEBUG=3 ./rt create -t ticket set id='ticket/new' Queue='Testing' subject='new ticket' POST http://myrturl/REST/1.0/show Content-Length: 264 Content-Type: multipart/form-data; boundary=xYzZY --xYzZY Content-Disposition: form-data; name=format l --xYzZY Content-Disposition: form-data; name=id ticket/new --xYzZY Content-Disposition: form-data; name=user root --xYzZY Content-Disposition: form-data; name=pass mypass --xYzZY-- HTTP/1.1 200 OK Connection: close Date: Thu, 15 Aug 2013 01:29:04 GMT Server: Apache/2.2.15 (CentOS) Content-Type: text/plain; charset=utf-8 Client-Date: Thu, 15 Aug 2013 01:29:04 GMT Client-Peer: 194.143.161.11:80 Client-Response-Num: 1 Client-Transfer-Encoding: chunked Set-Cookie: RT_SID_myrt.80=0e3b9b4e581aa0237b098fefdb98e37f; path=/; HttpOnly X-Frame-Options: DENY RT/4.0.13 200 Ok # Required: id, Queue id: ticket/new Queue: General Requestor: root Subject: Cc: AdminCc: Owner: Status: new Priority: 100 InitialPriority: 100 FinalPriority: 60 TimeEstimated: 0 Starts: 2013-08-15 01:29:04 Due: 2013-08-15 01:29:04 Text: rt: Malformed RT response from http://myrt. Can anyone give any pointers ,rather urgent , The only plugins I added : (RT::Extension::TicketLocking RT::Extension::MergeUsers RTx::Calendar RT::Extension::SLA) Roy [cid:image301004.PNG@a4a14fa2.4ea5c3f8] This email (and any attachments) contains information, which may be privileged and/or confidential. It's meant only for the individual(s) or entity named above. If you're not the intended recipient, please note that disclosing, copying, distributing or using this information is prohibited. If you've received this email in error, please let me know immediately by emailing me at the email address above and then delete all traces of this email from your system. We monitor our email system, and may record your emails. Computer viruses can be transmitted by email. You should check this email and any attachments for the presence of viruses. We accept no liability for any damage caused by any virus transmitted by this email or any attachments. Daisy Communications Ltd Registered office: Daisy House, Lindred Road Business Park, Nelson, Lancashire, BB9 5SR Registered in England and Wales with company number: 4145329 inline: image301004.PNG