Re: [rt-users] RT::Extension::Assets - missing Wikitext area and Select date widgets on Bulk Update

2014-04-09 Thread Alex Vandiver
On Thu, 2014-04-10 at 12:32 +1200, Kevin Buckley wrote: Bingo! Will give that a go: thanks. Please keep all replies on-list. Can I also assume that the 4.2.3 plus patch additions would cure what I've seen in the log, since trying to add in in the RT::Extension::Assets::Import::CSV

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

2014-04-03 Thread Alex Vandiver
As previously announced, the 3.8 series of RT has now reached end-of-life, and is no longer supported by Best Practical. This also ends support for RTFM, as well as RTIR 2.4 and 2.6, as those products depended on RT 3.8. Best Practical continues to support the RT 4.0 (maintenance) series, as

Re: [rt-users] RT.Articles table doesn't exist

2014-04-01 Thread Alex Vandiver
On Tue, 2014-04-01 at 14:04 +, GARCIA PEREZ, Alberto (Alberto)** CTR ** wrote: After upgrading my RT from 3.6.6 to 4.0.4 the rt.log displays the next warning: Why upgrade to 4.0.4, which has published security vulnerabilities, rather than 4.0.19? [Tue Apr 1 13:43:24 2014] [warning]:

Re: [rt-users] Upgrade

2014-03-27 Thread Alex Vandiver
On Wed, 2014-03-26 at 13:08 +, Bryon Baker wrote: Where can I find instructions on how to apply this patch? GET https://github.com/bestpractical/rt/commit/7d100f10.patch | patch -p1 -d /opt/rt4 Clear your Mason cache and restart Apache. - Alex -- RT Training - Dallas May 20-21

Re: [rt-users] RT::Authen::ExternalAuth + mod_ssl = core dump

2014-03-27 Thread Alex Vandiver
On Thu, 2014-03-27 at 16:01 -0500, Dewhirst, Rob wrote: I can get RT up and running just fine using LDAP with RT::Authen::ExternalAuth. But as soon as I shut down the server and install mod_ssl, apache won't restart, segfaults. What version of RT and Apache? I presume you're running with a

Re: [rt-users] RT::Authen::ExternalAuth + mod_ssl = core dump

2014-03-27 Thread Alex Vandiver
On Thu, 2014-03-27 at 16:42 -0500, Dewhirst, Rob wrote: RT 4.0.19 (because of RTIR) mod_perl Interesting; we've seen another report of this previously, but I've been unable to replicate it. It's presumably caused by a disagreement of mod_ssl with the SSL libraries that perl uses for LDAPS

Re: [rt-users] Upgrade

2014-03-25 Thread Alex Vandiver
On Wed, 2014-03-26 at 02:20 +, Bryon Baker wrote: I just upgrade from 4.2.0 to 4.2.3 I thought this was going to fix the auto fill for email addresses when forwarding messages. Was this not true? Did I miss something? This is not true. I don't believe we've ever said that 4.2.3 does

Re: [rt-users] Need help with Error Message

2014-03-24 Thread Alex Vandiver
On Mon, 2014-03-24 at 20:48 +, Bryon Baker wrote: When replying from the transaction section of a ticket we get the following exception thrown in the error log. [snip] This was fixed in RT 4.2.2. The error will still occur in your logs, and the outgoing email will not have a text/plain

Re: [rt-users] Multiple attachments for unprivileged users?

2014-03-20 Thread Alex Vandiver
On Thu, 2014-03-20 at 11:31 +0100, Jan Niezbędny wrote: [snip] Keep replies on-list. It works but only when unpriviliged user make new ticket by sending email. It's realy impossible to add button Add more files for unprivileged users in RT v4.0.4 because at this moment i can't upgrade RT

Re: [rt-users] Callback with no TicketObject arg, guidance needed

2014-03-20 Thread Alex Vandiver
On Thu, 2014-03-20 at 17:28 -0400, Jeff Blaine wrote: if (! $showchildren) { # In theory, this should exclude all fields in @childfields $CustomFields-Limit(FIELD = 'Name', OPERATOR = '!=', VALUE = '$_', ENTRYAGGREGATOR = 'AND', CASESENSITIVE = 0) for (@childfields); } Perl only

Re: [rt-users] Callback with no TicketObject arg, guidance needed

2014-03-19 Thread Alex Vandiver
On Tue, 2014-03-18 at 15:55 -0400, Jeff Blaine wrote: This callback in share/html/Elements/EditCustomFields does not pass $TicketObj (and it could, but was ommitted, perhaps on purpose?): %INIT ... $m-callback( %ARGS, CallbackName = 'MassageCustomFields', CustomFields =

Re: [rt-users] Multiple attachments for unprivileged users?

2014-03-19 Thread Alex Vandiver
On Wed, 2014-03-19 at 17:51 +0100, Jan Niezbędny wrote: At this moment unprivilged users making a new ticket by web interface can only add one attachment. Is it possible to change it in such way that they can added a multiple attachments? RT 4.2 includes that functionality. - Alex -- RT

Re: [rt-users] Callback with no TicketObject arg, guidance needed

2014-03-19 Thread Alex Vandiver
On Wed, 2014-03-19 at 11:57 -0400, Jeff Blaine wrote: Follow-up question if I may: How might I exclude fields X, Y, Z from $CustomFields in my callback? # Repeat for each name to exclude: $CustomFields-Limit( FIELD= 'Name', OPERATOR = '!=', VALUE= 'SomeNameToExclude',

Re: [rt-users] Full text search/index - Migrate to Postgres or MySQL + Sphinx?

2014-03-13 Thread Alex Vandiver
On Thu, 2014-03-13 at 14:47 +, Mark Goodge wrote: I know that RT uses InnoDB by default but there should be no reason why the table you want to search can't be converted to MyISAM. There's a very straightforward reason why RT uses InnoDB: database-level transactions. Converting the

Re: [rt-users] rt-serializer and rt-importer

2014-03-12 Thread Alex Vandiver
On Tue, 2014-03-11 at 08:51 -0700, Tim Gustafson wrote: And one last follow-up about this: here are my import statistics. The importer used up to about 800MB of RAM, so better than the serializer, but still pretty high. Both of those (6G for serializing, and 800M for importing) are definitely

Re: [rt-users] Problems, with extension Assets.

2014-03-12 Thread Alex Vandiver
On Tue, 2014-03-11 at 09:44 +0100, Emmanuel Lacour wrote: I am using Debian 7.3, with request tracker 4.2.3 built from source. I am also using the external auth extension, so i can use our Active Directory database for authentication. Does it work if you temporarily disable

Re: [rt-users] New UX for RT: REST 2.0, json, and what?

2014-03-12 Thread Alex Vandiver
On Thu, 2014-03-06 at 17:21 +0100, akos.to...@docca.hu wrote: This is some kind of request for comment. Please, feel free to give us advice, support, ideas. If you have similar effort, if you know any solution that makes this problems causeless, let us know please! Best Practical is always

Re: [rt-users] Assets 1.0 Question - Ticket to asset linking

2014-03-05 Thread Alex Vandiver
On Wed, 2014-03-05 at 11:27 -0600, Schincke, Keith wrote: Is there a way to link and existing ticket with an asset? It does not appear that new tickets created via email or a web form can be linked to an asset. You can add links via the Links page of tickets, using asset:42 to link to Asset

Re: [rt-users] Assets 1.0 - reports

2014-03-05 Thread Alex Vandiver
On Wed, 2014-03-05 at 11:27 -0600, Schincke, Keith wrote: I am looking at the Assets 1.0 module and there does not seem to be a way to save an asset search or export the data to an XLS or CSV format. Development of a CSV export has already been sponsored by Reed, can be found on a branch at

Re: [rt-users] Drop-down menu for Owner field disappeared

2014-03-04 Thread Alex Vandiver
On Tue, 2014-03-04 at 17:05 -0600, Tim Wilson wrote: RT suddenly stopped showing a drop-down menu for the Owner field today. It's just a regular text box now. You can still type in it, and the autocomplete works, but the drop-down is gone. We're running 4.2.0. There's no difference in behavior

[rt-users] [rt-announce] Assets 1.0 released

2014-02-27 Thread Alex Vandiver
Assets 1.0 -- 2014-02-27 We are very happy to announce the first version of RT::Extension::Assets, an asset tracking extension for RT 4.2.1 and above. The extension leverages RT's custom field architecture, making it a very flexible platform for tracking whatever type of

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

2014-02-20 Thread Alex Vandiver
RT 4.2.3 -- 2014-02-20 -- We are chuffed to announce that RT 4.2.3 is now available. http://download.bestpractical.com/pub/rt/release/rt-4.2.3.tar.gz http://download.bestpractical.com/pub/rt/release/rt-4.2.3.tar.gz.asc SHA1 sums e9e48c0a6d6b005e15c2f65c7919f70b086e5569

Re: [rt-users] RT-4.2.2 and RT-Assets

2014-02-19 Thread Alex Vandiver
On Wed, 2014-02-19 at 09:09 +0100, Joop wrote: Joop wrote: Without touching CustomField Grouping I get an error when I click on CustomFields in the display page, 'No grouping specified' , while in rt-4.2.2 clicking on CustomFields will take you to the Basics page with the customfields

Re: [rt-users] Fedora 20 / Perl 5.18

2014-02-19 Thread Alex Vandiver
On Wed, 2014-02-19 at 16:47 -0800, CLOSE Dave wrote: Anyway, Jok's solution did not solve the problem. But it did give me some more error messages to investigate. I discovered that the vendor_perl/RT directory content was quite old. I replaced it entirely with the files from the

Re: [rt-users] No __TimeLeft__ value in search result

2014-02-18 Thread Alex Vandiver
On Tue, 2014-02-18 at 04:10 -0800, andkulb wrote: This is the time values for the ticket: Created: Tue Feb 18 13:28:25 2014 Starts: Tue Feb 18 13:28:25 2014 Started: Tue Feb 18 13:28:25 2014 Last Contact: Tue Feb 18 13:30:25 2014 Due: Wed Feb 19 00:00:00 2014 Still,

Re: [rt-users] RT-Assets-Import-CSV surprises

2014-02-18 Thread Alex Vandiver
On Sat, 2014-02-08 at 14:37 +0100, Joop wrote: Still trying out new things :-) Found another thing which I think is a shortcut in the documentation. [snip] Nowhere in the docs it is mentioned that you need to put CF. in front of CustomFields. Thanks for the catch. I've just released

Re: [rt-users] QueueSummaryByLifecycle warning

2014-02-14 Thread Alex Vandiver
On Fri, 2014-02-14 at 10:54 +0100, Marko Cupać wrote: mysql select Name, Lifecycle from Queues; +---+---+ | Name | Lifecycle | +---+---+ | General | NULL | | ___Approvals | approvals | |

Re: [rt-users] Error while trying rt-assets-import-csv

2014-02-07 Thread Alex Vandiver
On Fri, 2014-02-07 at 14:16 +0100, Joop wrote: I installed a test instance of rt-4.2.2 (from source, on Centos-6.5, perl-5.10.1 x64) and installed the shiny new Assets extension and its import part but get the following error: Insecure dependency in require while running with -T switch at

Re: [rt-users] segmentation fault

2014-02-07 Thread Alex Vandiver
On Wed, 2014-02-05 at 18:50 -0600, José Luis Gordillo Ruiz My RT 4.2 instance is not working properly. Sometimes it gets errors in creating tickets or sending mails. Logs show segmentation faults of httpd. On of the cores I could get shows that the segmentation happens in malloc This RT

Re: [rt-users] RT Upgrade going bad (4.0.8 - 4.2.2)

2014-02-04 Thread Alex Vandiver
On Tue, 2014-02-04 at 14:08 +, Nick Fennell wrote: So it’s mainly this I’m having issues with; {{{ [6096] [Tue Feb 4 10:12:39 2014] [critical]: Can't use an undefined value as a HASH reference at /tmp/rt-4.2.2/sbin/../lib/RT/Crypt.pm line 237. (/tmp/rt-4.2.2/sbin/../lib/RT.pm:393)

Re: [rt-users] RT 4.2.2 - inline images are not shown in tickets

2014-02-04 Thread Alex Vandiver
On Tue, 2014-02-04 at 04:20 -0800, Alexey Bozrikov wrote: I have made a fresh install of RT 4.2.1 yesterday and noticed, that when I create a ticket using RT Web interface (rich text) and paste a screenshot or any other image to the editor, this image not being shown in either e-mail sent to

Re: [rt-users] REST call to retrieve list of groups

2014-02-04 Thread Alex Vandiver
On Tue, 2014-02-04 at 11:21 +, Guadagnino Cristiano wrote: Hi all, I have found out that I can use this REST call: http://my.rt.site/REST/1.0/group/group_name to retrieve informations about a group (id, name, description, members). However, I cannot find a REST way to retrieve the

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

2014-02-03 Thread Alex Vandiver
On Mon, 2014-02-03 at 14:22 -0800, Alexey Bozrikov wrote: I am attaching a diff -ur between upgrded and freshly installed RT 4.2.1, as I had exactly same issue when posting new tickets and replying to existing tickets from RT web interface. Our system has no customizations at all with

Re: [rt-users] ShowCustomFields extremely slow.

2014-01-30 Thread Alex Vandiver
On Thu, 2014-01-30 at 10:57 +0100, Michelle Sullivan wrote: Jan 28 02:11:09 to Jan 28 02:18:31 ... a full 7 minutes of being in ShowCustomFields there are just 100's (like more than 1900 of them) of statements like this: [snip] .. and no other queries... The start being immediately after:

Re: [rt-users] ShowCustomFields extremely slow.

2014-01-29 Thread Alex Vandiver
On Tue, 2014-01-28 at 03:30 +0100, Michelle Sullivan wrote: Ok so temporarily I set min_duration to 0 and logged everything, the log is here: The situation can be made much clearer by limiting to the postgres process IDs which are responding to queries from RT, namely 15537 and 15481. The

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

2014-01-28 Thread Alex Vandiver
On Tue, 2014-01-28 at 16:23 +, Jonah Hirsch wrote: It seems to occur for any ticket. I tried it on our most innocuous queue and it still occurred. Removed all people from the ticket, no special things in the ticket, and it still causes its apache process to lock up the system. Do you have

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

2014-01-28 Thread Alex Vandiver
On Tue, 2014-01-28 at 19:18 +, Jonah Hirsch wrote: I just remembered that when upgrading I had some database upgrade errors. I checked the upgrade history in RT and saw that it failed upgrading the DB schema from 4.1.12 on. When I try to run /opt/rt4/sbin/rt-setup-database --action

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

2014-01-28 Thread Alex Vandiver
On Tue, 2014-01-28 at 21:12 +, Jonah Hirsch wrote: I got the upgrades to run successfully, but I still get the memory issue when merging tickets. I noticed that System_Vendor.pm wasn't a stock RT file either, but I'm not sure where it came from. Here's its contents: That would be the

[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
On Fri, 2014-01-24 at 20:00 +0100, Arkadiusz Miśkiewicz wrote: It will be re-queued and tried again when it fails to submit to RT, so it'll be somewhere in your queues I find it to not always be true. For example when our mysql died then rt- mailgate didn't return any error BUT rt itself

Re: [rt-users] ShowCustomFields extremely slow.

2014-01-27 Thread Alex Vandiver
On Mon, 2014-01-27 at 10:06 +0100, Michelle Sullivan wrote: After upgrade to v4.0.17 from 3.x loading tickets is extremely slow.. can anyone give me any clues please...? What version were you upgrading from? What database backend are you using? Profiler shows this for a load of a single

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

2014-01-27 Thread Alex Vandiver
On Fri, 2014-01-24 at 17:43 +, Jonah Hirsch wrote: I just upgraded to RT 4.2.2 yesterday, and whenever a user merges a ticket, the responsible apache processes maxes out memory usage on the system and the system slows to a crawl until the OS kills the process, since the system is out of

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

2014-01-27 Thread Alex Vandiver
On Mon, 2014-01-27 at 21:13 +, Brent Wiese wrote: I saw under the “General User UI” fixes in 4.2.2: * Fix Clone ticket functionality with Select-multiple custom fields. I don’t see anything in my UI about cloning a ticket. This is actually a feature I’ve been desiring, but the old

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

2014-01-21 Thread Alex Vandiver
On Tue, 2014-01-21 at 04:55 -0800, andriuss wrote: Sorry for my lack of knowledge. Still I think that RT, to be more precise, Email::Address:List module should reject this kind of header and not stuck in infinity regex loop. Absolutely. We intend to address this shortly. What I was able to

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

2014-01-20 Thread Alex Vandiver
On Sun, 2014-01-19 at 23:54 -0800, andriuss wrote: I don't think so. First point, correct me if I'm wrong - An 'encoded-word' MUST NOT appear in any portion of an 'addr-spec' : It says, that you can't have the following syntax: Name Surname name@=?UTF-8?B?abc=?= ...are you attempting to

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

2014-01-16 Thread Alex Vandiver
On Thu, 2014-01-16 at 00:37 -0800, andriuss wrote: The situation become a little bit clearer: The failing mail header: From: =?UTF-8?B?ICJUb21hcyBNYXLEjWl1bGlvbmlzIiA8VG9tYXMuTWFyY2l1bGlvbmlzQGJp?= =?UTF-8?B?dGVzcGFydG5lcmlzLmx0Pg==?= But it should be the following (RT works just fine

[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
On Sun, 2014-01-12 at 20:42 +0100, Matthias Peplow wrote: I found out the following: 1. rt-serializer and rt-import are not installed automatically, had to copy them from my build directory manually to the RTs sbin directory Already fixed in 4.2.2rc1. 2. the import fails, as it is

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

2014-01-10 Thread Alex Vandiver
On Fri, 2014-01-10 at 11:45 +0100, Václav Ovsík wrote: I have a question regarding behaviour of FastCGI processes and database connections. While preparing upgrade of RT 3.8.16 to RT 4.2.1 I noticed a change of FastCGI usage in the RT. Thanks for bringing this to our attention. This is a bug

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

2014-01-08 Thread Alex Vandiver
As previously announced, with the release of RT 4.2, Best Practical will shortly cease support for the 3.8 series of Request Tracker -- specifically, on March 31st, 2014. The RT 3.8 series was first released in July 2008 and has received only critical bug and security fixes since 2011. We will

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
On Tue, 2014-01-07 at 21:36 +, Brent Wiese wrote: Is there a way to use an encrypted value for $DatabasePassword in RT_Siteconfig? What, exactly, do you mean by encrypted? RT clearly needs to have access to the plaintext password to pass to the MySQL authentication process, so there is

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

2014-01-02 Thread Alex Vandiver
On Thu, 2014-01-02 at 16:18 +, Guadagnino Cristiano wrote: This message is related to my previous thread titled HTML templates in RT 4.2.1. This is a known bug in 4.2.1, relating to how RT attempts to generate a plain-text version of HTML templates. A fix will be in 4.2.2 which will ensure

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
On Tue, 2013-12-24 at 17:37 +0100, Albert Shih wrote: In 4.0.x I use inside my search something like and Starts 'Today' to specify the starting date of this ticket is than today. After ugrading to 4.2.1 it's not working anymore. In RT 4.0, this search also found tickets where

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

2013-12-23 Thread Alex Vandiver
On Mon, 2013-12-23 at 15:23 +, ali mobli wrote: I recently upgraded my Centos 6.4 to 6.5 and am currently running RT 4.0.13. After this upgrade My subjects in the emails are corrupt. We use Icelandic Char so I have default UTF-8 both in the ssl.conf and http.conf and RT_SiteConfig.pm.

Re: [rt-users] Request tracker and Lighttpd

2013-12-23 Thread Alex Vandiver
On Mon, 2013-12-23 at 21:47 +0400, Ivan Osipov wrote: When I try start RT via Apache 2 with mod_fastcgi (http://www.bestpractical.com/docs/rt/4.2/web_deployment.html#mod_fastcgi) in Apache error-log: [snip] Sounds like you didn't configure with --with-web-handler=fastcgi, so 'make testdeps'

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

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

2013-12-17 Thread Alex Vandiver
On Tue, 2013-12-17 at 23:11 +0100, m...@fv-berlin.de wrote: didn't get a response there. Is there a way to solve this? Possibly through debugging RT4 to see how its actually trying to connect to searchd instead of how the config looks like it should? This lies firmly in the domain of having to

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
On Mon, 2013-12-16 at 13:58 +, Jacobsson, Henrik G wrote: After upgrading to RT 4.2.1, the postgresql database is producing massive volumes of WAL files around the clock with peaks during office hours. And what version were you upgrading from? Before the upgrade – we had very limited

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

2013-12-03 Thread Alex Vandiver
On Mon, 2013-12-02 at 17:49 +, Cena, Stephen (ext. 300) wrote: I'm getting ready to do an upgrade from 4.0.18 to 4.2.1 here on two servers. When I try the upgrade in a test environment, I get a bunch of errors that fly by (I don't have them, sorry :( ) Get them and look at them. It may

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

2013-12-03 Thread Alex Vandiver
On Tue, 2013-12-03 at 09:52 +1100, Andrew Chung wrote: Just typing in a comment/reply and hitting enter in the message box, it doesn't do anything. You need to use Ctrl-Enter. It's a text box. I don't understand why one would expect pressing enter in such a context to do anything other than

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

2013-12-03 Thread Alex Vandiver
On Tue, 2013-12-03 at 09:21 +0100, Matthias Peplow wrote: Set(%AdminSearchResultFormat,… section in our RT_Site_config and it looks like some paths have changed. So replacing It sounds like you copied all of %AdminSearchResultFormat into your RT_SiteConfig. This is unnecessary, and leads

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
On Mon, 2013-12-02 at 11:35 -0600, Wendi M. wrote: I can then add this Custom Status setting to a particular queue, and it all looks good. My problem.. I can't resolve the ticket or do anything other than leave it in the new status? Am I missing something obvious here? Thanks! You're missing

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

2013-12-03 Thread Alex Vandiver
On Tue, 2013-12-03 at 21:37 -0600, Mike W wrote: Upgrade from 4.0.17 and having some issues with email notices. It seems to be connected to scrips. I did run the make upgrade-database The errors below imply that it if you did run it, it did not complete. Show the RT Upgrade History section of

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

2013-12-03 Thread Alex Vandiver
On Tue, 2013-12-03 at 22:39 +0100, Payam Poursaied wrote: First thank you for your feedback in the list regarding the bug in html parser Do not reply off-list. I believe Tom previously corrected you on that in the email you quote below. First time I point this case in 2011

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

2013-12-03 Thread Alex Vandiver
On Tue, 2013-12-03 at 22:35 -0600, Mike W wrote: Aha! I found: Upgrade from 4.1.0 to 4.1.1 (Incomplete) Fixed that and got things rolling properly. Thanks for telling me about that. Had no idea it logged that there. It's new in 4.2. However, it is no substitute for reading the 'make

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

2013-12-02 Thread Alex Vandiver
On Mon, 2013-12-02 at 15:01 +0100, Matthias Peplow wrote: after the Upgrade from 4.016 to 4.2 the history of tickets was not shown anymore. The label „loading“ was shown forever but the history never appeared. We solved this issue by restoring the RT 4.0 behavior with Set($ShowHistory,

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

2013-12-02 Thread Alex Vandiver
On Mon, 2013-12-02 at 11:38 +0100, m...@fv-berlin.de wrote: Hi, I'm trying to upgrade a 3.6.1-4 (don't ask) RT to 4.0.4-2 and I ran into issues. First of all: I am doing this upgrade (test) on a duplicate of the actual production system, so no worries. As part of the preparation before

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

2013-12-02 Thread Alex Vandiver
On Thu, 2013-11-28 at 11:48 -0800, Chris Black wrote: I just upgraded from 4.0.8 to 4.2.1 this morning and when I log in with my username which was full admin. When I log in now, I am only seeing my list of open tickets. I can't find any dashboard options, admin options, etc. Please show a

Re: [rt-users] changing Organization

2013-12-02 Thread Alex Vandiver
On Fri, 2013-11-29 at 13:11 +, Jenny Martin wrote: I would like to change our Organization name to avoid confusion with another RT instance? Does anyone have a script to fixup the RT database so that I can change the Organization name without breaking the RT ticket links? RT 4.2's

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
On Fri, 2013-11-29 at 13:37 +, Chris Davies wrote: I've finally got around to making some changes to RT::Authen::ExternalAuth that allows me to define the Windows domain. [snip] Are the patches something that would be useful to share here? I've tried emailing the contact in the

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
On Sat, 2013-11-30 at 16:59 +0100, Payam Poursaied wrote: In the past weeks, we received considerable complaints from our staff that their comments and corresponds are not delivered to the requestors (i.e. on correspond notify requestors). [snip] Working more, I found that, when

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
On Thu, 2013-11-28 at 09:30 -0800, Chris Black wrote: CPAN.pm: Going to build M/MI/MIYAGAWA/Plack-1.0030.tar.gz Can't locate File/ShareDir/Install.pm in @INC Apparently your version of CPAN.pm is too old to understand configure_requires. What does `cpan -v` report? You can work around

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

2013-11-28 Thread Alex Vandiver
On Thu, 2013-11-28 at 09:59 -0800, Chris Black wrote: [root@localhost rt-4.2.1]# cpan -v /usr/bin/cpan script version 1.9, CPAN.pm version 1.9402 You may wish to update CPAN: 'cpan install CPAN' Or install and use cpanm: cpan install App::cpanminus RT_FIX_DEPS_CMD=cpanm make fixdeps

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

2013-11-27 Thread Alex Vandiver
On Wed, 2013-11-27 at 13:35 +0100, Budsjö, Martin wrote: Thanks a lot! I did have a extra RT4test schema... I did drop that yesterday, but for once I did not rm the mason cache. I did this after reading your reply and now it works perfectly! Thanks again! You saved our upgrade plan for the

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

2013-11-26 Thread Alex Vandiver
On Tue, 2013-11-26 at 11:30 +0100, Budsjö, Martin wrote: I tried to upgrade from 4.0.17 to 4.2.1 the other day and no matter what I do, I get the same result. After upgrading I can login without any problem and all lists of tickets and graphs etc looks good. (By the way, I really like the

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

2013-11-26 Thread Alex Vandiver
On Tue, 2013-11-26 at 17:25 +0100, Peter van Zetten wrote: I've been looking at migrating from MySQL to PostgreSQL with the rt-serializer/importer scripts. This is a precursor to merging two RT instances, but the initial migration of the main database is being done with the --clone flag to

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 09:28 +0100, Dr. Dirk Pape wrote: In the Log: [13817] [Fri Nov 22 08:17:15 2013] [error]: encountered object '1', but neither allow_blessed, convert_blessed nor allow_tags settings are enabled (or TO_JSON/FREEZE method missing) at

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
On Fri, 2013-11-22 at 13:06 -0800, Kevin wrote: make upgrade-database failed, while trying to upgrade from 4.0.15 to 4.2.1 I ran the configure, make testdeps and make fixdeps with out any issues. now trying to run the DB upgrade script asked for root pw and db version from popped in 4.0.15

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

2013-11-21 Thread Alex Vandiver
On Thu, 2013-11-21 at 21:28 +0100, Bartosz Maciejewski wrote: Hi, Sorry for bother You on private, but I don't get mails from mailing list, only digest came. Then ask to be Cc'd -- please do not simply email directly. Keeping the correspondence on-list means that everyone and the archives will

Re: [rt-users] customfield error: date

2013-11-21 Thread Alex Vandiver
On Thu, 2013-11-21 at 10:05 +, Thomas Lau wrote: [critical]: Unknown CustomField type: Date (/opt/rt4/share/html/Elements/BulkCustomFields:81) Does anyone have idea what's wrong with CustomField after upgrade from 4.0.13 to 4.2.0? Nothing. This warning is produced by the bulk update

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
On Thu, 2013-11-21 at 12:56 +0100, Bartosz Maciejewski wrote: I'm trying to get scrip that on status change set owner to requestor. Remember that Requestors may be a list of users; it may also be empty. Which do you intend to set the Owner to? For instance, to simply set it to the first

Re: [rt-users] RT loses MySQL connection

2013-11-21 Thread Alex Vandiver
On Thu, 2013-11-21 at 18:05 -0800, Jay Christopherson wrote: No, no entries beyond the startup messages. I thought maybe there would be some connection errors (a flush-hosts situation or something), but nothing. That's odd. Can you show your my.cnf, webserver configuration, and

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

2013-11-20 Thread Alex Vandiver
On Wed, 2013-11-20 at 13:56 -0500, Adam Hutchins wrote: [18504] [Wed Nov 20 17:27:58 2013] [critical]: DBD::mysql::st execute failed: Table 'ObjectScrips' already exists at /tmp/rt-4.2.0/sbin/../lib/RT/Handle.pm line 526. (/tmp/rt-4.2.0/sbin/../lib/RT.pm:391) DBD::mysql::st execute failed:

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

2013-11-20 Thread Alex Vandiver
Please keep all replies on-list. On Wed, 2013-11-20 at 14:10 -0500, Adam Hutchins wrote: I have upgraded it in the past from 3.x to 4.0.7. And I was successful with 4.0.7 to 4.0.18 today. It's the jump to 4.2.x that's giving me errors. Did you attempt the 4.0 - 4.2 upgrade at some earlier

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
On Wed, 2013-11-20 at 11:13 -0800, Landon Stewart wrote: Is using 1970-01-01 00:00:00” the only way? Currently, yes. Seems like that definite value might be begging for bugs or something if somehow the unset date equals 1970-01-01 05:00:00” for some reason down the road. I just want to

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

<    1   2   3   4   5   >