Re: [rt-users] Problem with HTML tags appearing in correspondence

2014-02-03 Thread Alex Vandiver
installation: [...] Finally, clear the Mason cache dir: rm -fr /opt/rt4/var/mason_data/obj You may then start your web server again. - Alex [1] http://bestpractical.com/docs/rt/latest/README

Re: [rt-users] ShowCustomFields extremely slow.

2014-01-30 Thread Alex Vandiver
noted, there are several queries run multiple times), I expect you will find this to be a frustrating game of whack-a-mole. If at all possible, altering your network topology to remove the latency is most probably a more straightforward way to have a performant RT instance. - Alex

Re: [rt-users] ShowCustomFields extremely slow.

2014-01-29 Thread Alex Vandiver
modes that I'm familiar with in RT. You may wish to try simplifying your database configuration (temporarily install Pg on one of the front-ends) to see if that resolves any of the problems. - Alex

Re: [rt-users] Memory leak when merging tickets, RT 4.2.2

2014-01-28 Thread Alex Vandiver
any extensions or customizations installed? Are there any errors in your error logs? - Alex

Re: [rt-users] Memory leak when merging tickets, RT 4.2.2

2014-01-28 Thread Alex Vandiver
suspicious. - Alex

Re: [rt-users] Memory leak when merging tickets, RT 4.2.2

2014-01-28 Thread Alex Vandiver
/opt/rt4/lib/ - Alex

[rt-users] [rt-announce] Security vulnerability in RT

2014-01-27 Thread Alex Vandiver
Versions of RT between 4.2.0 and 4.2.2 (inclusive) are vulnerable to a denial-of-service attack via the email gateway; any installation which accepts mail from untrusted sources is vulnerable, regardless of the permissions configuration inside RT. This vulnerability is assigned CVE-2014-1474.

Re: [rt-users] REST mail-gateway using 100% cpu

2014-01-27 Thread Alex Vandiver
On Wed, 2014-01-22 at 08:33 -0800, andriuss wrote: Glad to hear that. Waiting for the fix. Please see the just-announced CVE-2014-1474, and http://download.bestpractical.com/mirror/Email-Address-List-0.03.tar.gz which resolves the issue. - Alex

Re: [rt-users] REST mail-gateway using 100% cpu

2014-01-27 Thread Alex Vandiver
) but well... It is absolutely an important bug -- RT should not lose incoming email. If you can replicate it, please submit the replication strategy as a bug to rt-b...@bestpractical.com - Alex

Re: [rt-users] ShowCustomFields extremely slow.

2014-01-27 Thread Alex Vandiver
, in general, are being problematic. - Alex

Re: [rt-users] Memory leak when merging tickets, RT 4.2.2

2014-01-27 Thread Alex Vandiver
of memory. Is this a known issue? Anyone have any thoughts on what I can do to try to solve this problem? This is the first I've heard of it. Does it occur for any ticket merge? Can you replicate it in a clean RT 4.2.2? - Alex

Re: [rt-users] clone ticket in RT 4.2

2014-01-27 Thread Alex Vandiver
. It also picks up many properties of the original ticket, including custom fields[1]. Select-multiple CFs failed to get transferred correctly; that is what the release note refers to. - Alex [1] It also copies over Time Worked, which is often considered a bug. For backwards-compatibility

Re: [rt-users] REST mail-gateway using 100% cpu

2014-01-21 Thread Alex Vandiver
to get from mail sender, he was using Microsoft Outlook Web App. Interesting. - Alex

Re: [rt-users] REST mail-gateway using 100% cpu

2014-01-20 Thread Alex Vandiver
client, for instance, rightly refuses to parse it at all, and leaves it as =?UTF-8?B??= when displaying, and indeed when attempting to reply to such a message. I am still morbidly curious to hear what software created that header. - Alex [1] http://tools.ietf.org/html/rfc822#section-3.1.2 [2

Re: [rt-users] REST mail-gateway using 100% cpu

2014-01-16 Thread Alex Vandiver
header is definitely against the RFC. See the first point on http://tools.ietf.org/html/rfc2047#page-8 . What mail client? - Alex

[rt-users] [rt-announce] RT 4.0.19 released

2014-01-13 Thread Alex Vandiver
RT 4.0.19 -- 2014-01-13 --- We are pleased to announce RT 4.0.19 is now available. http://download.bestpractical.com/pub/rt/release/rt-4.0.19.tar.gz http://download.bestpractical.com/pub/rt/release/rt-4.0.19.tar.gz.sig SHA1 sums ce7bae429ed56603fef9e7a46d976d1ea9ed1e14

[rt-users] [rt-announce] RT 4.2.2 released

2014-01-13 Thread Alex Vandiver
RT 4.2.2 -- 2014-01-13 -- We are pleased to announce that RT 4.2.2 is now available. http://download.bestpractical.com/pub/rt/release/rt-4.2.2.tar.gz http://download.bestpractical.com/pub/rt/release/rt-4.2.2.tar.gz.asc SHA1 sums 72faa454a02240cf21a94633b880e2158325efa1

Re: [rt-users] db migration from mysql to postgres

2014-01-12 Thread Alex Vandiver
fails right at the beginning with DBD::Pg::st execute failed: ERROR: relation users does not exist LINE 1: SELECT * FROM Users WHERE LOWER(Name) = LOWER($1) http://docs.bestpractical.com/rt-importer#CLONED_DATA - Alex

Re: [rt-users] Apache FastCGI and # of db connections

2014-01-10 Thread Alex Vandiver
. - Alex

[rt-users] [rt-announce] End of Life of RT 3.8

2014-01-08 Thread Alex Vandiver
discounted pricing on our upgrade packages and support plans; for more details, contact sa...@bestpractical.com - Alex ___ rt-announce mailing list rt-annou...@lists.bestpractical.com http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-announce

Re: [rt-users] Problems in templates in Rt 4.2.1

2014-01-08 Thread Alex Vandiver
On Mon, 2014-01-06 at 11:42 -0500, Kevin Falcone wrote: Alternatively, wait for RT 4.2.2rc1 (announced on rt-devel) and test once available. RT 4.2.2rc1 is now available for testing, and resolves this issue: http://bestpractical.com/release-notes/rt/4.2.2rc1 - Alex

Re: [rt-users] Encrypting the DB password in RT_Siteconfig

2014-01-07 Thread Alex Vandiver
being gleaned from accidental reading by someone who can read the file, you can simply rot13 it: my $rot13 = sub { my $s = shift; $s =~ tr/A-Za-z/N-ZA-Mn-za-m/; $s }; Set( $DatabasePassword, $rot13-(cnffjbeq) ); - Alex

Re: [rt-users] Problems in templates in Rt 4.2.1

2014-01-02 Thread Alex Vandiver
that mail is always sent out, even if it lacks a text/plain part due to failure of the HTML-text conversion. - Alex

Re: [rt-users] RT 4.2.1

2014-01-02 Thread Alex Vandiver
On Sun, 2013-12-29 at 21:48 +0100, Nick Price wrote: ScriptAlias /rt /opt/rt4/sbin/rt-server.fcgi You are missing: 1. A trailing slash on rt-server.fcgi/ 2. The FastCgiServer directive. Please give http://docs.bestpractical.com/web_deployment a complete read. - Alex

Re: [rt-users] RT CLI Ticket Display Issue

2014-01-02 Thread Alex Vandiver
On Thu, 2014-01-02 at 13:56 -0700, Jesse Griffin wrote: I think this error is related to the HTML - plain text bug in 4.2.1, but I'm hoping to find a pointer to a patch (or git commit) so that I can fix my setup. https://github.com/bestpractical/rt/commit/8807f0d0.patch - Alex

Re: [rt-users] Start

2013-12-24 Thread Alex Vandiver
Starts was not set; this is no longer true in RT 4.2. Unfortunately, as this was an almost-unintended change, there is currently no way to search for tickets which have no Starts date set. I've pushed a branch for 4.2.2 which will resolve this; the ticketsql syntax will be 'Starts IS NULL' - Alex

Re: [rt-users] Centos 6,5 upgrade

2013-12-23 Thread Alex Vandiver
. After the upgrade of the OS this is happening. Likely due to too recent a version of the Encode module. RT 4.0.18 inclues a fix. - Alex

Re: [rt-users] Request tracker and Lighttpd

2013-12-23 Thread Alex Vandiver
' didn't check the dependencies that that deployment adds. - Alex

Re: [rt-users] RES: RE: RES: Sphinx fulltext index v4.0.4

2013-12-20 Thread Alex Vandiver
On Tue, 2013-12-17 at 17:28 -0500, Alex Vandiver wrote: This lies firmly in the domain of having to debug MySQL and the SphinxSE plugin, and not in debugging RT itself. From recent testing locally, using 127.0.0.1 instead of localhost works acceptably. I have confirmed that this is a bug

[rt-users] RTIR for RT 4.2.x

2013-12-18 Thread Alex Young
I'm assuming that the current 3.0 version of RTIR isn't compatible with RT 4.2.x at the moment. When can we expect to see a release of RTIR compatible with the currently version of RT? Thanks.

[rt-users] RTIR for RT 4.2.x

2013-12-18 Thread Alex Young
I'm assuming that the current 3.0 version of RTIR isn't compatible with RT 4.2.x at the moment. When can we expect to see a release of RTIR compatible with the currently version of RT? Thanks.

[rt-users] RTIR for RT 4.2.x

2013-12-17 Thread Alex Young
I'm assuming that the current 3.0 version of RTIR isn't compatible with RT 4.2.x at the moment. When can we expect to see a release of RTIR compatible with the currently version of RT? Thanks.

Re: [rt-users] RES: RE: RES: Sphinx fulltext index v4.0.4

2013-12-17 Thread Alex Vandiver
sphinx://127.0.0.1:3312/rt as the URL of the Sphinx server. - Alex

Re: [rt-users] Installing RT with Oracle 11g: ERROR: as user 'rt': ORA-01017

2013-12-16 Thread Alex Vandiver
On Sat, 2013-12-14 at 18:43 -0500, supp...@pureview.com wrote: Could I still install with rt Oracle user in place already. If that is true what would be the new configuration file? What options should I omit...! sbin/rt-setup-database --action init --skip-create - Alex

Re: [rt-users] Excessive communication between RT and postgresql

2013-12-16 Thread Alex Vandiver
of the activity when you believe the system is not in use. It may be enlightening to examine the generated WAL logs using http://www.postgresql.org/docs/current/static/pgxlogdump.html - Alex

Re: [rt-users] Upgrade from 4.0.x to 4.2.x - Fresh install with DB upgrade ok?

2013-12-03 Thread Alex Vandiver
the recommended set of steps to upgrade, yes. Though it was written for 3.8 - 4.0, you may find http://blog.bestpractical.com/2011/07/upgrading-to-rt-4.html helpful. - Alex

Re: [rt-users] RT 4.2.1 Enter/return key does not work in Safari on OS X

2013-12-03 Thread Alex Vandiver
add a newline. - Alex

Re: [rt-users] Scrips not accessible in 4.2 anymore

2013-12-03 Thread Alex Vandiver
. We'll add an UPGRADING note. - Alex

Re: [rt-users] RT 4.2 Set($ShowHistory, 'delay') does not

2013-12-03 Thread Alex Vandiver
On Tue, 2013-12-03 at 10:38 +0100, Matthias Peplow wrote: same result with Safari 7.0 and Chrome 31.0.1650.57 I can't reproduce with either. You'll need to examine the javascript logs (probably easier in chrome) to see what's happening. - Alex

Re: [rt-users] AD domains with RT::Authen::ExternalAuth

2013-12-03 Thread Alex Vandiver
On Tue, 2013-12-03 at 12:35 +, Chris Davies wrote: On 02/12/13 17:11, Alex Vandiver wrote: Feel free to file a pull request on github[1], and we'll take a look. - Alex [1] https://github.com/bestpractical/rt-authen-externalauth/ You've lost me already. If you can send a unified

Re: [rt-users] Custom Status Setup Problems

2013-12-03 Thread Alex Vandiver
the transitions: http://docs.bestpractical.com/RT_Config#Transitions-between-statuses-and-UI-actions - Alex

Re: [rt-users] upgrade issues 4.0.17 - 4.2.1

2013-12-03 Thread Alex Vandiver
of Admin → Tools → System Configuration. - Alex

Re: [rt-users] FW: Serious problem with mime/html format email containing attachments

2013-12-03 Thread Alex Vandiver
if it resolves your problem. - Alex

Re: [rt-users] upgrade issues 4.0.17 - 4.2.1

2013-12-03 Thread Alex Vandiver
upgrade-database' output itself. - Alex

Re: [rt-users] RT 4.2 Set($ShowHistory, 'delay') does not work

2013-12-02 Thread Alex Vandiver
, 'always‘); How can we get the delayed ticket history working as intended? What browser? Was there anything of note in your logfiles from that time? - Alex

Re: [rt-users] Having trouble upgrading: Unknown column 'm.LastUpdatedBy' in 'on clause' at /usr/sbin/rt-validator

2013-12-02 Thread Alex Vandiver
. If you run 'DROP INDEX CachedGroupMembers3' the upgrade steps should run correctly. - Alex

Re: [rt-users] Upgrading from 4.0.8 to 4.2.1 missing dashboards

2013-12-02 Thread Alex Vandiver
a screenshot -- as .jpg and not overly large, soas to be polite to folks' inboxes. Do you have any local customizations or extensions installed? Is there anything of note in RT's logs? - Alex

Re: [rt-users] changing Organization

2013-12-02 Thread Alex Vandiver
/rt-validator has a --links-only which, in conjunction with --resolve, will fix links after an Organization change. - Alex

Re: [rt-users] Scrips not accessible in 4.2 anymore

2013-12-02 Thread Alex Vandiver
On Mon, 2013-12-02 at 14:54 +0100, Matthias Peplow wrote: after upgrading from 4.016 to 4.2 I cannot select Scrips anymore via Admin-Scrips-Select. Please try the following patch, which should be in 4.2.2: https://github.com/bestpractical/rt/commit/d9c1d3a.patch - Alex

Re: [rt-users] AD domains with RT::Authen::ExternalAuth

2013-12-02 Thread Alex Vandiver
::Authen::ExternalAuth but heard nothing back. Feel free to file a pull request on github[1], and we'll take a look. - Alex [1] https://github.com/bestpractical/rt-authen-externalauth/

Re: [rt-users] RT 4.2.1 RSS feed of articles

2013-12-02 Thread Alex Vandiver
On Sun, 2013-12-01 at 23:38 -0800, andkulb wrote: Is it possible to make a RSS feed from articles like with the tickets? Not currently; patches accepted. - Alex

Re: [rt-users] bug in HTML::FormatText::WithLinks::AndTables stops scrips working

2013-12-02 Thread Alex Vandiver
://github.com/bestpractical/rt/commit/8807f0d.patch How are your staff generating the problematic HTML, out of curiosity? Is the CKeditor generating that, or are you pasting in from Word or some other source? - Alex

Re: [rt-users] RT 4.2.1 Enter/return key does not work in Safari on OS X

2013-12-02 Thread Alex Vandiver
On Tue, 2013-12-03 at 09:34 +1100, Andrew Chung wrote: I've got a couple of users who are having problems with using the enter/return key when using RT 4.2.1 with Safari. Using the return key in what context? - Alex

Re: [rt-users] Error while running make fixdeps on plack

2013-11-28 Thread Alex Vandiver
On Thu, 2013-11-28 at 08:45 -0800, Chris Black wrote: It seems like it's failing on PLACK: arning: Prerequisite 'Plack = 0.992' for 'KAZUHO/Starlet-0.21.tar.gz' failed You've shown the error for Starlet, which depends on Plack. Please show the output of 'cpan install Plack' - Alex

Re: [rt-users] Error while running make fixdeps on plack

2013-11-28 Thread Alex Vandiver
this by running 'cpan install File::ShareDir::Install' before running 'make fixdeps' - Alex

Re: [rt-users] Error while running make fixdeps on plack

2013-11-28 Thread Alex Vandiver
is the dependency that failed to install. Show the logs from attempting to install that. - Alex

Re: [rt-users] CustomFields table problems after upgrade to 4.2.1. (column repeated referenced after upgrade)

2013-11-27 Thread Alex Vandiver
for the weekend. Please keep replies on-list, so others can benefit from what you discover. Glad to hear that fixed things. - Alex

Re: [rt-users] CustomFields table problems after upgrade to 4.2.1. (column repeated referenced after upgrade)

2013-11-26 Thread Alex Vandiver
attempts to inspect the database's list of existent columns to determine which columns are available to GROUP BY. - Alex

Re: [rt-users] PostgreSQL sequence counters do not increment correctly with rt-importer

2013-11-26 Thread Alex Vandiver
its AUTO_INCREMENT if you insert with an explicit id, but neither Oracle nor Pg adjust their sequences. - Alex

Re: [rt-users] Update to RT 4.2.1 - JSON error after login

2013-11-22 Thread Alex Vandiver
/JSON.pm line 154. Show the output of: perl -MJSON -MModule::Versions::Report -e1 - Alex

Re: [rt-users] Update to RT 4.2.1 - JSON error after login

2013-11-22 Thread Alex Vandiver
On Fri, 2013-11-22 at 17:22 +0100, Dr. Dirk Pape wrote: Hi Alex, $ perl -MJSON -MModule::Versions::Report -e1 [snip] I can't replicate your failure with the same versions. Does the following error for you? perl -MJSON -wle 'print JSON::to_json({foo=JSON::true})' - Alex

Re: [rt-users] make upgrade-database failed upgrading to 4.2.1

2013-11-22 Thread Alex Vandiver
your existing Asset Tracker assets. - Alex

Re: [rt-users] Question about Requestors in RT

2013-11-21 Thread Alex Vandiver
, braino on my part: $self-TicketObj-Requestors-UserMembersObj-First; - Alex

Re: [rt-users] customfield error: date

2013-11-21 Thread Alex Vandiver
page, which doesn't support bulk update of Date custom fields. Neither 4.0 nor 4.2 do. The severity of the error should likely be decreased, however. - Alex

Re: [rt-users] RT loses MySQL connection

2013-11-21 Thread Alex Vandiver
On Thu, 2013-11-21 at 15:20 -0800, Jay Christopherson wrote: I just installed a new instance of RT (4.2.1). I've been using RT for quite a long time now, through a lot of different versions, but this is a new issue for me. Is there anything of note in the mysql logs? - Alex

Re: [rt-users] How to use Requestor user in scrip?

2013-11-21 Thread Alex Vandiver
requestor: # This will set $Actor to a user object my $Actor = $self-TicketObj-Requestors-First; # Stop if no requestors return unless $Actor; You can then call -Name or -id on $Actor as you please. - Alex

Re: [rt-users] RT loses MySQL connection

2013-11-21 Thread Alex Vandiver
, and RT_SiteConfig.pm ? Is this under SELinux, or anything else that might muck about with sockets? - Alex

Re: [rt-users] FW: Issue upgrading to 4.2.x

2013-11-20 Thread Alex Vandiver
: Table 'ObjectScrips' already exists at /tmp/rt-4.2.0/sbin/../lib/RT/Handle.pm line 526. Have you tried to upgrade this RT instance previously? What extensions are installed, or have been at some point? - Alex

Re: [rt-users] FW: Issue upgrading to 4.2.x

2013-11-20 Thread Alex Vandiver
' - Alex

Re: [rt-users] What’s the correct SQL syntax for a date/time custom field that’s not set?

2013-11-20 Thread Alex Vandiver
to make sure I’m not setting myself up for buggy behaviour in the future. That magic date is the UNIX epoch, and will not change. - Alex

Re: [rt-users] FW: Issue upgrading to 4.2.x

2013-11-20 Thread Alex Vandiver
On Wed, 2013-11-20 at 14:34 -0500, Adam Hutchins wrote: Did you attempt the 4.0 - 4.2 upgrade at some earlier point? Not that I'm aware of. That's extremely odd. Can you show the output of: mysqldump -u root rt4 -p --no-data - Alex

Re: [rt-users] FW: Issue upgrading to 4.2.x

2013-11-20 Thread Alex Vandiver
ObjectScrips' ...should suffice to remove the extraneous table, and allow 'make upgrade-database' to complete. - Alex

[rt-users] query amount of timeworked BETWEEN 1st and Last day of the month

2013-11-19 Thread Alex Rhys-Hurn
and creation date/time.Ultimately i hope to build a monthly dashboard that can easily report this.Many thanks for your help.Alex-- Alex Rhys-Hurn | ITworX LimitedP.O. Box 1649, 00502, Karen, KenyaTel: +254 (0) 20 2444824 | Cell: +254 (0) 724 972541Web: www.itworx.co.ke

Re: [rt-users] IE8 issues - Custom Fields and edit screens - updated

2013-11-19 Thread Alex Vandiver
in this area, 4.2.1 with IE 8 does not evidence any in the Dashboard pages that I can find. - Alex

Re: [rt-users] IE8 issues - Custom Fields and edit screens - updated

2013-11-19 Thread Alex Vandiver
and propose a patch. - Alex

[rt-users] RT4.2 TimeTaken TimeWorked what changed?

2013-11-19 Thread Alex Rhys-Hurn
Hello,Please can somebody help me to understand in laymans terms what changed in 4.2 vis TimeTaken TimeWorked fields.Is it now enough for me to only query TImeWorked to get an accurate view of time?Many thanks,Alex-- Alex Rhys-Hurn | ITworX LimitedP.O. Box 1649, 00502, Karen, KenyaTel: +254 (0

Re: [rt-users] Date/Datetime CFs not populating on ticket modify

2013-11-18 Thread Alex Vandiver
/28a7109e4cdfbe439f9562b7d58430f626e17a87.patch a test to see if it resolves your issue. - Alex

Re: [rt-users] RT 4.2.0 jquery.min.map 404

2013-11-18 Thread Alex Vandiver
/2013/01/the-magic-of-jquery-source-map.html - Alex

[rt-users] [rt-announce] RT 4.2.1 released

2013-11-18 Thread Alex Vandiver
RT 4.2.1 -- 2013-11-13 -- We're pleased to announce that RT 4.2.1 is now available. http://download.bestpractical.com/pub/rt/release/rt-4.2.1.tar.gz http://download.bestpractical.com/pub/rt/release/rt-4.2.1.tar.gz.asc SHA1 sums 08bd8e4d28c065030aac7b33c0a15a789a6e11f9

Re: [rt-users] Date/Datetime CFs not populating on ticket modify

2013-11-18 Thread Alex Vandiver
in the other two commits on that branch, which deal with Mandatory validation. https://github.com/bestpractical/rt/compare/4.2/date-cf-validation - Alex

Re: [rt-users] Question about 4.2 and setting the owner

2013-11-05 Thread Alex Vandiver
to render a very large drop-down. This is irrespective of the value of $AutocompleteOwners. How many potential owners exist in this queue? - Alex

Re: [rt-users] RT 4.2 and ownership of tickets after comments

2013-11-05 Thread Alex Vandiver
the scrip before we will be able to hazard any guesses. - Alex

Re: [rt-users] RT 4.2 and ownership of tickets after comments

2013-11-05 Thread Alex Vandiver
that happens is the new owner gives the ownership back to the original owner. I can't seem to figure out why. Look at your logs; I suspect you have a second scrip which is firing to give it back. - Alex

Re: [rt-users] TicketHistory slow on 4.2.0

2013-10-31 Thread Alex Vandiver
::Transaction') ; (/opt/rt4/sbin/../lib/RT/Interface/Web.pm:1292) To be useful, we'd unfortunately need to know the full stack trace. The full stack trace is shown in the UI in the Admin → Tools → SQL Queries page if StatementLog is enabled. - Alex

Re: [rt-users] Question about SMTP in an upgrade from 4.0 to 4.2

2013-10-31 Thread Alex Vandiver
is to install a local MTA, which can be configured to relay the mail to the original SMTP host. This provides a durable mail spool in case the remote SMTP server is inaccessible. The local MTA does not need to be configured to accept mail locally if that is not how you wish RT to operate. - Alex

Re: [rt-users] TicketHistory slow on 4.2.0

2013-10-31 Thread Alex Vandiver
On Thu, 2013-10-31 at 16:47 -0400, Tod Detre wrote: Sorry, here is the trace: [snip] Thanks -- this enabled me to track down the regression. A fix which does not require the additional index is under review as https://github.com/bestpractical/rt/commit/61a2dea - Alex

Re: [rt-users] Upgrading 4.0.8 - 4.2.0 breaking outgoing email

2013-10-30 Thread Alex Vandiver
On Wed, 2013-10-30 at 12:20 -0700, Kevin Falcone wrote: These warnings are almost certainly a culprit. Can you show your CustomFields definitions? SHOW CREATE TABLE CustomFields; SHOW INDEXES FROM CustomFields; - Alex

Re: [rt-users] Upgrading 4.0.8 - 4.2.0 breaking outgoing email

2013-10-30 Thread Alex Vandiver
On Wed, 2013-10-30 at 19:30 +, Wright, Cory (CDC/OID/NCEZID) (CTR) wrote: sql_mode = [...],ONLY_FULL_GROUP_BY That would be your problem. RT doesn't support running with that option enabled. - Alex

Re: [rt-users] Upgrading 4.0.8 - 4.2.0 breaking outgoing email

2013-10-28 Thread Alex Vandiver
On Mon, 2013-10-28 at 12:58 +, Wright, Cory (CDC/OID/NCIRD) (CTR) wrote: Thanks Alex -- what's attached is me logging in and performing one correspond in which I expect an email. Hostnames/IPs/db names have been anonymized. Your logs are chock full of SQL statement execution errors, which

Re: [rt-users] Upgrading 4.0.8 - 4.2.0 breaking outgoing email

2013-10-25 Thread Alex Vandiver
for the sole purpose of emailing out, but doesn’t work. Increase RT's logging level to 'debug', and show the logs from an update you would expect to send mail. - Alex

Re: [rt-users] TicketHistory slow on 4.2.0

2013-10-25 Thread Alex Vandiver
= '...') AND (main.ObjectId = '...') AND (main.ObjectType = '...'); ...replacing the '...'s with real values? Also, the output of: SHOW INDEXES FROM ObjectCustomFieldValues; - Alex

Re: [rt-users] Upgrading 4.0.8 - 4.2.0 breaking outgoing email

2013-10-25 Thread Alex Vandiver
On Fri, 2013-10-25 at 20:38 +, Wright, Cory (CDC/OID/NCIRD) (CTR) wrote: Thanks for the tip Alex -- this is what I tried at first and there were no suspicious messages which made me think that somehow I have a flag turned off or something else. Please keep your replies on-list

Re: [rt-users] TicketHistory slow on 4.2.0

2013-10-25 Thread Alex Vandiver
, and if thus it is likely to be a call path which others will encounter this problem with. This will effect if and how we fix this for others in 4.2.1 - Alex

Re: [rt-users] configure --enable-ssl-mailgate option is gone in RT 4.2 ?

2013-10-24 Thread Alex Vandiver
On Thu, 2013-10-24 at 15:59 -0400, John Apodaca wrote: Are the Perl modules required for SSL now included by default? Yes. - Alex

Re: [rt-users] TicketHistory slow on 4.2.0

2013-10-23 Thread Alex Vandiver
in a short period of time, the history will load quickly (probably cached somewhere). [snip] The ticket table is ~30,000 records, the transactions table is ~3,800,000, and the users table is ~280,000. What database backend, and what version thereof? - Alex

Re: [rt-users] TicketHistory slow on 4.2.0

2013-10-23 Thread Alex Vandiver
://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_slow_query_log Providing `SHOW INDEXES FROM Transactions` and `SHOW INDEXES FROM Attachments` may also be useful. - Alex

Re: [rt-users] TicketHistory slow on 4.2.0

2013-10-23 Thread Alex Vandiver
layers in that area. I'd double-check your slow query log threshold and relevant settings. Another interesting point, the mobile site does not seem to have the same problem. Do you have any local customizations? - Alex

Re: [rt-users] 4.2 Queue question

2013-10-23 Thread Alex Vandiver
? That is exceedingly odd. Was this an upgrade? If so, from what version? Are you using custom lifecycles at all? - Alex

Re: [rt-users] Can't call method Name without a package or object reference

2013-10-22 Thread Alex Vandiver
be calling -Name on $queue, not on $qLoad. $qLoad is just a success/failure return value -- $queue is the object that has now been loaded. - Alex

[rt-users] [rt-announce] RT 4.0.18 released

2013-10-15 Thread Alex Vandiver
We're pleased to announce that RT 4.0.18 is now available. http://download.bestpractical.com/pub/rt/release/rt-4.0.18.tar.gz http://download.bestpractical.com/pub/rt/release/rt-4.0.18.tar.gz.sig SHA1 sums c023227267b6fdfc4514b233d53e1b1bc31b51a1 rt-4.0.18.tar.gz

<    3   4   5   6   7   8   9   10   11   >