[rt-users] RT-3.6.1-4 - DB connection problem
Hi
I'm using debian etch and RT version 3.6.1-4 , now I have problem to
connect DB, when I run from shell:
perl /usr/share/request-tracker3.6/libexec/mason_handler.fcgi
I get some error:
DBI connect('dbname=rt_test;host=192.168.1.11;port=3306','rt_test',...)
failed: received invalid response to SSL negotiation: F
at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 106
Connect Failed received invalid response to SSL negotiation: F
Someone know where is the problem? The databases have off ssl
connection, Can I off ssl connection in RT config?
Regards,
Albert
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
[rt-users] Archiving the Attachments Table
Hi, Our attachments table is currently taking up 2.3gb and is easily the largest table in our RT 3.6.3 DB. I know that that table contains both the text of comments/replies as well as the files that are attached to tickets. Has anyone looked at archiving this table? Ideally I'd like to keep textual comment/replies but remove attached files. I'd also like to do it in a way that would mean I could get them back later if needed. Any ideas? Justin -- Justin Hayes Support Manager [EMAIL PROTECTED] ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Archiving the Attachments Table
Why don't you make a general backup of your mysql database (you can also export this table only) and then use the Shredder to get rid of the attachments? Justin Hayes schrieb: Hi, Our attachments table is currently taking up 2.3gb and is easily the largest table in our RT 3.6.3 DB. I know that that table contains both the text of comments/replies as well as the files that are attached to tickets. Has anyone looked at archiving this table? Ideally I'd like to keep textual comment/replies but remove attached files. I'd also like to do it in a way that would mean I could get them back later if needed. Any ideas? Justin -- Justin Hayes Support Manager [EMAIL PROTECTED] ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Archiving the Attachments Table
Thanks I'll take a look at the Shredder - I was thinking about deleting rows using SQL but if there's an extension to do it I'll use that. However am I easily going to be able to get files back from the backup if I need them? The files are stored as data in a column of that table. If 3 months down the line I need a file from a Ticket, will I be able to find out which row I need in my backup if the Shredder has removed it from the live RT? Also will I be able to out the data back into a file? Or are you suggesting setting up an archive install of RT and having that run off the backup. So I have a live streamlined install and a bloated backup install. Cheers, Justin -- Justin Hayes Support Manager [EMAIL PROTECTED] On 2 Apr 2008, at 14:18, Benjamin Weser wrote: Why don't you make a general backup of your mysql database (you can also export this table only) and then use the Shredder to get rid of the attachments? Justin Hayes schrieb: Hi, Our attachments table is currently taking up 2.3gb and is easily the largest table in our RT 3.6.3 DB. I know that that table contains both the text of comments/replies as well as the files that are attached to tickets. Has anyone looked at archiving this table? Ideally I'd like to keep textual comment/replies but remove attached files. I'd also like to do it in a way that would mean I could get them back later if needed. Any ideas? Justin -- Justin Hayes Support Manager [EMAIL PROTECTED] ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Enhancements and workflows that we have added
Aaron,
Sure. Thanks for asking. The following is a copy of the code just above
what your addition is to just below:
*** beginning copy **
my $EditComponent = EditCustomField$Type;
$m-comp('/Elements/Callback', _CallbackName = 'EditComponentName',
Name = \$
EditComponent, CustomField = $CustomField, Object = $Object );
$EditComponent = EditCustomField$Type unless
$m-comp_exists($EditComponent);
# Custom Field formatting overlays===
If ($Type eq Text) {
$Rows = 6;
$Columns = 20;
} elsif ($Type eq Wikitext) {
$Rows = 8;
$Columns = 15;
} elsif ($Type eq Select) {
$Rows = 1;
$Columns = 10;
}
# end of custom overlay code
return $m-comp(
$EditComponent,
%ARGS,
Rows = $Rows,
Cols = $Cols,
Default = $Default,
Object = $Object,
Values = $Values,
MaxValues = $MaxValues,
Multiple = ($MaxValues != 1),
NamePrefix = $NamePrefix,
CustomField = $CustomField,
);
I included the befor and after code just in case I accidently erased or
modified something I was supposed to. Thanks for your help.
Kenn
LBNL
On 4/1/2008 5:38 PM, Aaron Sallade wrote:
Can you send me a copy of your EditCustomField file?
Aaron Sallade'
Application Manager
PTSO of Washington
Shared Technology for Community Health
(206) 613-8938 Desk
(206) 521-8833 Main
(206) 613-5078 Fax
[EMAIL PROTECTED]
-Original Message-
From: Kenneth Crocker [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 01, 2008 4:46 PM
To: Aaron Sallade
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Enhancements and workflows that we have added
Aaron,
I just put in those changes and I get a syntax error on $Type.
The
error message says the folowing:
Error during compilation of
/apps/rt/rt-3.6.4/local/html/Elements/EditCustomField:
syntax error at /apps/rt/rt-3.6.4/local/html/Elements/EditCustomField
line 79, near ) {
Global symbol $Columns requires explicit package name at
/apps/rt/rt-3.6.4/local/html/Elements/EditCustomField line 81, GEN39
line 361.
syntax error at /apps/rt/rt-3.6.4/local/html/Elements/EditCustomField
line 82, near } elsif
Global symbol $Type requires explicit package name at
/apps/rt/rt-3.6.4/local/html/Elements/EditCustomField line 82, GEN39
line 361.
Global symbol $Rows requires explicit package name at
/apps/rt/rt-3.6.4/local/html/Elements/EditCustomField line 83, GEN39
line 361.
Global symbol $Columns requires explicit package name at
/apps/rt/rt-3.6.4/local/html/Elements/EditCustomField line 84, GEN39
line 361.
syntax error at /apps/rt/rt-3.6.4/local/html/Elements/EditCustomField
line 85, near ;
}
I'm not sure why it doesn't like $Type. Any ideas? I'm not real
experienced at perl. Just learning. Thanks.
Kenn
LBNL
On 4/1/2008 11:47 AM, Aaron Sallade wrote:
For the width of freetext boxes etc, as well as the height -
Copy your/share/html/elements/EditCustomField to
local/html/elements/EditCustomField and add the following changes.
Put this after
$EditComponent = EditCustomField$Type unless
$m-comp_exists($EditComponent);
# My custom field formatting overlays===
If ($Type eq Text) {
$Rows = 6;
$Columns = 20;
} elsif ($Type eq Wikitext) {
$Rows = 8;
$Columns = 15;
} elsif ($Type eq Select) {
$Rows = 1;
$Columns = 10;
}
# CustomField id # 14 is the specific ID of a field that I want to
have
unique display
If (CustomField-Id == 14) {
$Rows = 7;
}
# End of my overlay=
Aaron Sallade'
Application Manager
PTSO of Washington
Shared Technology for Community Health
(206) 613-8938 Desk
(206) 521-8833 Main
(206) 613-5078 Fax
[EMAIL PROTECTED]
-Original Message-
From: Kenneth Crocker [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 01, 2008 9:25 AM
To: Aaron Sallade
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Enhancements and workflows that we have added
Aaron,
We are VERY interested in what you have developed. Whether or
not you
post to the list, please send us what you have. It will be extremely
appreciated. Also, do you have anything that increases the box size of
a
free-test CF?. Thanks in advance.
Kenn
LBNL
On 3/31/2008 4:54 PM, Aaron Sallade wrote:
Just in case these are of interest to anyone else-
Added a scrip and template that adds a reply to a DependedOnBy Parent
ticket when the child is resolved. Resolving a sub task (child) will
add
a comment to the parent noting that the prerequisite is now complete,
it
will also email the owner of the parent task.
Set the Row count of custom fields by type and or customfield ID. In
our
implementation, single select boxes have a row height of 1 (making
them
a drop down box) and text areas have a row height of 6, and a
specific
multi select is set to 7 so that no
[rt-users] RT Update and Bulk Update
Hi all, I have a question regarding RT update verses Bulk Update. If we don’t wish a message to be sent to a Cc or Bcc member of any given ticket we have to check a box in front of their name(s) and then click on “Save changes” button, then click on the “Update Ticket” to accomplish this which is not a big deal, unless we went wrong during the installation. However, the “Save changes” button is not available in Bulk Update. Is this by design? If not, can it be added? Is there any other way script or otherwise to achieve this? We are using RT 3.6.4 Many thanks in advance for your replies, Hossein -- _ _ _ _ _ _ _ Hossein Rafighi |_ _|| _ \ |_ _|| | | || \_/ || __|TRIUMF, 4004 Wesbrook Mall | | | |_| ) | | | | | || || |__ Vancouver BC, Canada, V6T 2A3 | | | _ / | | | \_/ || \_/ || __|Voice: (604) 222-1047 | | | | \ \ _| |_ | || | | || | Fax: (604) 222-1074 |_| |_| \_\|_| \___/ |_| |_||_| Website: http://www.triumf.ca ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] How to reset Preferences - Search options?
Hi everyone, Is there a way to reset the user's Preferences - Search options to the $DefaultSearchResultFormat? A Defaults button on the SearchOptions.html page, for example, could be handy. Thansk, js. -- Jean-Sebastien Morisset, Sr. UNIX Administrator [EMAIL PROTECTED] ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] autoreply template content
Hello, It doesn't look like I have privs to the autoreply global template. Would anybody be able to email me the content of that template so I can see how it is setup? thanks, Gary _ More immediate than e-mail? Get instant access with Windows Live Messenger. http://www.windowslive.com/messenger/overview.html?ocid=TXT_TAGLM_WL_Refresh_instantaccess_042008___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] How to reset Preferences - Search options?
On Wed, Apr 02, 2008 at 05:49:07PM +, Jean-Sebastien Morisset wrote:
Hi everyone,
Is there a way to reset the user's Preferences - Search options to the
$DefaultSearchResultFormat? A Defaults button on the
SearchOptions.html page, for example, could be handy.
I've been able to add the button, but it screws up the display some:
# diff ./share/html/Prefs/SearchOptions.html
./local/html/Prefs/SearchOptions.html
67a68,75
form method=post action=SearchOptions.html
input type=hidden class=hidden name=Format
value=%$RT::DefaultSearchResultFormat% /
input type=hidden class=hidden name=Order value=ASC
/
input type=hidden class=hidden name=OrderBy value=id
/
input type=hidden class=hidden name=RowsPerPage
value=50 /
/Elements/Submit, Name = 'SavePreferences', Label =
loc('Reset to Defaults')
/form
Any idea how I can tuck the Save Changes and Reset to Defaults
button together?
Thanks,
js.
--
Jean-Sebastien Morisset, Sr. UNIX Administrator [EMAIL PROTECTED]
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] How to reset Preferences - Search options?
On Wed, Apr 02, 2008 at 06:35:35PM +, Jean-Sebastien Morisset wrote:
On Wed, Apr 02, 2008 at 05:49:07PM +, Jean-Sebastien Morisset wrote:
Hi everyone,
Is there a way to reset the user's Preferences - Search options to the
$DefaultSearchResultFormat? A Defaults button on the
SearchOptions.html page, for example, could be handy.
I've been able to add the button, but it screws up the display some:
# diff ./share/html/Prefs/SearchOptions.html
./local/html/Prefs/SearchOptions.html
67a68,75
form method=post action=SearchOptions.html
input type=hidden class=hidden name=Format
value=%$RT::DefaultSearchResultFormat% /
input type=hidden class=hidden name=Order value=ASC
/
input type=hidden class=hidden name=OrderBy value=id
/
input type=hidden class=hidden name=RowsPerPage
value=50 /
/Elements/Submit, Name = 'SavePreferences', Label =
loc('Reset to Defaults')
/form
Any idea how I can tuck the Save Changes and Reset to Defaults
button together?
So this isn't pretty, but it works.
# diff ./share/html/Prefs/SearchOptions.html
./local/html/Prefs/SearchOptions.html
65c65,68
/Elements/Submit, Name = 'SavePreferences', Label = loc('Save
Changes')
---
div class=submit
div class=buttons
input type=submit name=SavePreferences value=Save
Changes class=button /
/div
66a70,78
form method=post action=SearchOptions.html
div class=extra-buttons
input type=hidden class=hidden name=Format
value=%$RT::DefaultSearchResultFormat% /
input type=hidden class=hidden name=Order value=ASC
/
input type=hidden class=hidden name=OrderBy value=id
/
input type=hidden class=hidden name=RowsPerPage
value=50 /
input type=submit name=SavePreferences value=Reset to
Defaults class=button /
/div
/form
js.
--
Jean-Sebastien Morisset, Sr. UNIX Administrator [EMAIL PROTECTED]
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT Update and Bulk Update
No. What I want is a way NOT to send email to Admin Cc or Cc people when ticket(s) are resolved through Bulk Update. I tried Remove Admin Cc: but to no avail. I can easily accomplish this when I am resolving tickets individually by checking the boxes next to Admin Cc and Cc names and then clicking on Save changes button, but the Save changes button is not available in Bulk Update and I don't know how else to do a bulk update without sending email to Admin Cc and Cc people. Cheers, Hossein Kenneth Crocker wrote: Hossein, UH, actually, I thought that clicking the Update button for Bulk Update (after one has made the type of changes they want to happen to a bunch of tickets, un-checking any ticket that is NOT to be changed) WAS, in fact, a Save Changes button. It may not say it but IT certainly ACTS like it. Do you just want to change the Title on the button? The action/results are the same so I don't really understand the problem. Kenn LBNL On 4/2/2008 8:29 AM, Hossein Rafighi wrote: Hi all, I have a question regarding RT update verses Bulk Update. If we don’t wish a message to be sent to a Cc or Bcc member of any given ticket we have to check a box in front of their name(s) and then click on “Save changes” button, then click on the “Update Ticket” to accomplish this which is not a big deal, unless we went wrong during the installation. However, the “Save changes” button is not available in Bulk Update. Is this by design? If not, can it be added? Is there any other way script or otherwise to achieve this? We are using RT 3.6.4 Many thanks in advance for your replies, Hossein -- _ _ _ _ _ _ _ Hossein Rafighi |_ _|| _ \ |_ _|| | | || \_/ || __|TRIUMF, 4004 Wesbrook Mall | | | |_| ) | | | | | || || |__ Vancouver BC, Canada, V6T 2A3 | | | _ / | | | \_/ || \_/ || __|Voice: (604) 222-1047 | | | | \ \ _| |_ | || | | || | Fax: (604) 222-1074 |_| |_| \_\|_| \___/ |_| |_||_| Website: http://www.triumf.ca ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT Update and Bulk Update
Hossein, AAHH! Now I understand. I thought you were just talking about the way it updates. You want THAT without the automatic email when the ticket status is changed. HHHMM. I wonder if there is a way to identify when the transaction is coming from bulk update? Then you could use that in your scrips for resolve, etc. I'mnot sure how to do that. sorry. Kenn LBNL On 4/2/2008 12:18 PM, Hossein Rafighi wrote: No. What I want is a way NOT to send email to Admin Cc or Cc people when ticket(s) are resolved through Bulk Update. I tried Remove Admin Cc: but to no avail. I can easily accomplish this when I am resolving tickets individually by checking the boxes next to Admin Cc and Cc names and then clicking on Save changes button, but the Save changes button is not available in Bulk Update and I don't know how else to do a bulk update without sending email to Admin Cc and Cc people. Cheers, Hossein Kenneth Crocker wrote: Hossein, UH, actually, I thought that clicking the Update button for Bulk Update (after one has made the type of changes they want to happen to a bunch of tickets, un-checking any ticket that is NOT to be changed) WAS, in fact, a Save Changes button. It may not say it but IT certainly ACTS like it. Do you just want to change the Title on the button? The action/results are the same so I don't really understand the problem. Kenn LBNL On 4/2/2008 8:29 AM, Hossein Rafighi wrote: Hi all, I have a question regarding RT update verses Bulk Update. If we don’t wish a message to be sent to a Cc or Bcc member of any given ticket we have to check a box in front of their name(s) and then click on “Save changes” button, then click on the “Update Ticket” to accomplish this which is not a big deal, unless we went wrong during the installation. However, the “Save changes” button is not available in Bulk Update. Is this by design? If not, can it be added? Is there any other way script or otherwise to achieve this? We are using RT 3.6.4 Many thanks in advance for your replies, Hossein ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] installing on RHEL4
Is there an up to date install instruction apart from: http://wiki.bestpractical.com/view/RHEL4InstallGuide I see a RPM rt-3.6.6-1.noarch.rpm but it's missing a WACK load of dependencies How do I install this RPM and satisfy all dependencies? Nelson Pereira Senior Network Administrator Protus IP Solutions Inc. [EMAIL PROTECTED] phone: 613.733. ext.528 MyFax: 613.822.5083 www.myfax.com Refer your friends and colleagues to MyFax! Click here for more information. http://www.myfax.com/referral_program.asp http://www.myfax.com image001.gif___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] installing on RHEL4
Nelson Pereira wrote: Is there an up to date install instruction apart from: http://wiki.bestpractical.com/view/RHEL4InstallGuide I see a RPM rt-3.6.6-1.noarch.rpm but it’s missing a WACK load of dependencies…. How do I install this RPM and satisfy all dependencies? Personally I would recommend ditching the RPM and the RHEL-specific installation and doing a manual installation. There a number of reasons why this would be preferable, least of all that your RT directory structure will remain separate from the rest of your OS and make life that much more simple for you. Aside from that, Red Hat packaged software is asking for trouble as they seem to like to change the defaults that developers have worked on carefully to whatever they think they should be. It is for this reason, for example, that you should be careful if you upgrade your Perl installation via RPM because the Red Hat defaults cause RT to break in attempting to use Scalar::Util. -- Kind Regards, __ Mike Peachey, IT Tel: +44 114 281 2655 Fax: +44 114 281 2951 Jennic Ltd, Furnival Street, Sheffield, S1 4QT, UK Comp Reg No: 3191371 - Registered In England http://www.jennic.com __ ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Self Service Permissions
Our unprivileged users can't see the queue names (we have multiple queues) in the Self Service interface, the field is just blank. What permission is needed to see that field? Currently set up with: unprivileged: CreateTicket SeeQueue requester: ReplyToTicket ShowTicket Thanks, Steve ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Due Date in Ticket Creation Page
Has anyone hacked the Create ticket form to show the due date? Can easily create a custom field that shows on the entry form, but seems silly since the ticket object already has a due date. In the archives I noticed a lot posts referencing using PHP etc as a front end and just having the forms send mail to RT to be processed in. Is that typical, ie what most people do to provide a more flexible interface (ajax, etc)? Thanks, Steve ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
