Re: [rt-users] Full text indexing error with MySQL

2016-08-25 Thread Alex Vandiver
On Thu, 25 Aug 2016 20:49:48 -0700 Omen Wild wrote: > I activated the full text indexing under Ubuntu 16.04 (request-tracker4 > 4.2.12-5) and (mysql-server 5.7.13-0ubuntu0.16.04.2). Both the initial > indexing and subsequent calls to rt-fulltext-indexer have the same error: > >

Re: [rt-users] Help! I enabled Full Text search and now Simple search won't look at Subjects !!

2016-08-26 Thread Alex Vandiver
On Tue, 23 Aug 2016 13:21:20 +0200 Claes Merin wrote: > I beg to differ about the attachments table, in our setup we rely on > customfields and there parameters. We have quite a few tickets that does > not have any attachments. > If you do not write anything in the message

Re: [rt-users] Customizing with Overlays

2016-10-02 Thread Alex Vandiver
On Mon, 3 Oct 2016 08:58:25 +0530 Nilesh wrote: > Can I put my Overlay files in local/lib? Yup; that's what's generally suggested. > Do I have to maintain the same directory structure? Yes. > Let's say I have to customize RT::Action::SendEmail, so my Overlay should > be in

Re: [rt-users] FTS enabled in SiteConfig, but not being enabled

2016-11-16 Thread Alex Vandiver
On Tue, 15 Nov 2016 11:36:53 -0500 Alex Hall wrote: > I found the problem. I've seen "Table" and "TableName" both used in sample > configurations, but apparently only one is correct. As soon as I switched > to "Table" in my config file, FTS enabled itself. If any of the

Re: [rt-users] rt-setup-fulltext-index dropped DB connections with MySQL

2016-10-13 Thread Alex Vandiver
On Thu, 13 Oct 2016 20:32:36 + James Zuelow wrote: > Package versions at the moment are MySQL 5.6.30, Perl 5.2.22, and > request-tracker 4.2.13. There is a Perl 5.4 upgrade available, but > that breaks my rt4 installation. For reference, your perl versions are not

Re: [rt-users] supplying database credentials to rt-fulltext-indexer

2016-12-10 Thread Alex Vandiver
On Fri, 9 Dec 2016 17:30:31 -0500 Alex Hall wrote: > What this file never says is how to tell the indexer tool how to connect to > the database. It clearly isn't pulling from the RT configuration, nor from > /home/www-data/rtrc. The indexer reads and uses the database

Re: [rt-users] mysql DB engine ndbdcluster

2016-12-13 Thread Alex Vandiver
On Tue, 13 Dec 2016 12:25:37 +0100 Pescoller Reinhold wrote: > Thanks for your informations. > > I tried to do so but rt give me an error that innodb is required and > that I should upgrade my tables. > Have I to change this direct in the code? lib/RT/Handle.pm:

Re: [rt-users] mysql DB engine ndbdcluster

2016-12-13 Thread Alex Vandiver
On Tue, 13 Dec 2016 10:28:41 +0100 Reinhold Pescoller wrote: > Is there some possibilty to change the default db engine from innodb to > ndbdcluster in rt4? RT assumes REPEATABLE READ isolation; you may encounter subtle and difficult to diagnose bugs under READ COMMITTED

Re: [rt-users] mysql DB engine ndbdcluster

2016-12-15 Thread Alex Vandiver
On Wed, 14 Dec 2016 09:42:42 -0500 Mike Diehl wrote: > At the risk of picking a fight, I'd like to understand this a bit better. Happy to explain more -- and my instinct may have been wrong on one count; see below. > As long as the database supports minimum functions,

Re: [rt-users] Problem with index

2017-01-11 Thread Alex Vandiver
On Wed, 11 Jan 2017 15:17:53 -0500 François Meehan wrote: > We are using RT 4.2.12. We noticed that the indexation stopped working. > When trying to run the indexer manually, I would get: > > [11238] [Wed Jan 11 19:53:56 2017] [warning]: DBD::mysql::st execute > failed: MySQL

Re: [rt-users] Queue still being CC'ed with $ParseNewMessageForTicketCcs and $RTAddressRegexp

2017-01-10 Thread Alex Vandiver
On Tue, 10 Jan 2017 20:26:05 + "Cena, Stephen (ext. 300)" wrote: > Set($RTAddressRegexp, '(local-part1@domain1\.tld)| > (local-part2@domain2\.tld)| > (local-part3@domain3\.tld)| > : > : > (local-partN@domainN\.tld)/xi'); If you want to use the /x modifier, provide a regular

Re: [rt-users] RT 4.4.1 and transaction isolation level on Postgres

2017-01-04 Thread Alex Vandiver
On Tue, 3 Jan 2017 17:06:47 +0100 Václav Ovsík wrote: > How about the Mysql don't have this problem - is this caused by > the different default transaction isolation level or not? MySQL suffers from the exact same problem -- but, as it happens, both more silently and more

Re: [rt-users] Where to put crontool scripts?

2017-01-04 Thread Alex Vandiver
On Wed, 4 Jan 2017 11:13:38 -0500 Alex Hall wrote: > I'm considering putting them in /opt/rt4/etc, maybe in a "crontool-scripts" > folder, but I don't know what RT upgrades might do to that. RT upgrades won't remove any extra files you have lying around. - Alex

Re: [rt-users] Ticket SQL for dates?

2016-12-31 Thread Alex Vandiver
On Sat, 31 Dec 2016 12:41:21 -0500 Alex Hall wrote: > In a thread a week or two ago, I was asking about the syntax for finding > tickets by relative dates, like "3 days ago". It wasn't working, and at > least one other list member was able to confirm that it wasn't. You're

Re: [rt-users] RT 4.4.1 and transaction isolation level on Postgres

2017-01-02 Thread Alex Vandiver
On Mon, 2 Jan 2017 17:12:29 +0100 Václav Ovsík wrote: > Can anybody confirm on different system? Thanks for the detailed replication instructions. I can replicate, and have tracked down a minimal replication case. I'll drop my findings and suggestion on your ticket. The

<    1   2   3   4   5