Hi,
for those not satisfied with PostgreSQL full text search (no substring
support)...
http://wiki.bestpractical.com/view/PostgreSQLFullTextTrgm
Limitations
* minimal word length 3 chars,
* maybe false matches at some conditions
Any comments appreciated
Regards
--
Zito
Discover RT's hidden secr
Hi,
On Wed, Nov 03, 2010 at 09:46:36PM +0100, Josef wrote:
>
> Yes, but only priviledged users see this... I don't want end users
> to change my settings. Unpriviledged user sees only its requests, or
> is there a way to add Newest Unowned dashboard to them?
I have modified the SelfService a bi
On Thu, Nov 04, 2010 at 12:22:11AM +0100, Josef wrote:
>
> Thank you very much,
> I have copied these files into my
> /usr/share/request-tracker3.6/html/SelfService/, but I'm having this
I forgot to mention files from the tarball should be extracted into
inst
On Thu, Nov 04, 2010 at 09:37:42AM +0100, Richard Pijnenburg wrote:
> Wouldn't it be easier if you could create a group per customer and let
> all the users in that group see the tickets from each other?
> Of course there are different approaches possible to the same issue :-)
I hope, that it is e
On Mon, Feb 21, 2011 at 09:24:38AM +0100, Adrian Stel wrote:
> Hi,
> I would like to change standard access to RT from username/pw to
> certificates authorization. Is there any simple way to do that ? Or
> any additions to the RT ?
I'm testing a simple alternative to External Auth.
I have a Callba
Hi,
because of horrible performance of spreadsheet export of tickets I found
some badly created or missing indexes. I didn't investigate if other
RDBMS schemas has the same problem.
To discover problems I rewrote Results.tsv into command-line shape and
run it with DBI_TRACE=2 finally.
For every r
On Fri, Apr 15, 2011 at 12:09:58PM +1000, Jesse Vincent wrote:
> ...
> I'd actually consider this a code bug. We shouldn't be LOWER()ing either
> of those parameters. Please open a ticket by mailing
> rt-b...@bestpractical.com
I did it. It have received ticket [rt3 #17121].
About the second pro
On Thu, Jul 26, 2012 at 06:59:49PM +, Betz, Gregory wrote:
> Hello all,
>
> Is there any way to setup full-text indexing (with PostgreSQL) to index
> substrings?
I have setup this for RT 3.8.10:
http://requesttracker.wikia.com/wiki/PostgreSQLFullTextTrgm
This setup addresses exactly the pro
Dear Users and Developers,
I'm facing a migration four instances RT 3.2.2 to RT 3.8.8 with a number
of customizations.
Back-end database is MySQL and I have prepared a script for loading
database dumps from old MySQL 3.23.58 to 5.0.51 (Debian Lenny)
and then upgrading RT schema (rt-setup-database).
Hi Emmanuel,
thanks for your reply.
On Sat, May 15, 2010 at 07:23:01AM +0200, Emmanuel Lacour wrote:
> With Pg, this content is handled specifically, see _EncodeLOB in
> lib/RT/Record.pm.
>
> (see also mysql2Pg page on RTwiki).
I saw Base64 encoding in script on wiki page and also elsewhere, but
On Sat, May 15, 2010 at 01:35:36PM +0200, Václav Ovsík wrote:
> Hi Emmanuel,
> thanks for your reply.
>
> On Sat, May 15, 2010 at 07:23:01AM +0200, Emmanuel Lacour wrote:
> > With Pg, this content is handled specifically, see _EncodeLOB in
> > lib/RT/Record.pm.
> >
On Mon, May 17, 2010 at 02:10:43PM +0200, Emmanuel Lacour wrote:
> On Mon, May 17, 2010 at 01:53:43PM +0200, Václav Ovsík wrote:
> >
> > Oh yes, I was blind that RT uses DBIx::SearchBuilder. There is
> > a subroutine BinarySafeBLOBs defined in
> > DBIx::SearchBuilder
On Mon, May 17, 2010 at 02:10:43PM +0200, Emmanuel Lacour wrote:
> Maybe there is a better way as of recent postgres?
FYI: fwd
--
Zito
--- Begin Message ---
* Václav Ovsík:
> Is it possible that binding of binary data-type (bytea) without
> data-type specification would behave like in
Hi,
I'm preparing migration from RT 3.2.2 + Mysql 3.x to RT 3.8.8
+ Mysql or Pg.
I just discovered a problem with the case insensitive searching in the
column Attachments.Content (longblob) while playing with a new RT
instance.
Ticket SQL query
Content like 'outlook'
on our current (old) RT in
... 3rd try to mail ...
On Sun, Jun 06, 2010 at 02:34:58PM -0500, Kenneth Marshall wrote:
> Hi Zito,
>
> You can look in the mailing list archives for several similar "discoveries" on
> how MySQL works with content searches and the longblob data type. I would
> definitely recommend using PostgreS
Hi Ken,
On Tue, Jun 08, 2010 at 07:48:15AM -0500, Kenneth Marshall wrote:
> ILIKE is fine on PostgreSQL as long as the search is anchored on
> the left and there is an index. Otherwise it will do a sequential
> scan of the attachments table to find matching records. The wiki
> entries for full-tex
Hi,
Thanks very much for Request Tracker!
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.
I am using Debian Wheezy (with some packages from Jessie/Sid to satisfy
d
On Fri, Jan 10, 2014 at 07:13:28PM -0500, Alex Vandiver wrote:
> 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
> >
Hi,
On Wed, Apr 09, 2014 at 05:53:35PM +0400, Arkady Glazov wrote:
> Hi,
>
> I have installed RT 4.2 with PostgreSQL FullTextSearch. In base i can
> search only the whole word. Is in possible search only for parts of word?
I did this in the past for RT 3.8.x and I have configuration ready to
use
Please look at https://github.com/zito/rt-pgsql-fttrgm
I hope it will work, also I didn't try to run the script rt-mysql2pg on
RT4 database (I did simple upgrade of RT3 database with indexes already
setup). Let me know if it works.
Thanks
--
Zito
--
RT Training - Dallas May 20-21
http://bestpract
Hi Arkady,
On Thu, Apr 10, 2014 at 03:33:16PM +0400, Arkady Glazov wrote:
> Hi Václav,
> I will be in wait.
>
> I look databases. All content saved as 'quoted-printable'. I can send
> example If it help you.
...
On Fri, Apr 11, 2014 at 09:38:26AM +0400, Arkady Glazov wrote:
> Hi Václav,
>
> I s
I have tried to feed test message into production RT instance 3.8.16
and it ends in the database:
interni=# select contenttype, contentencoding, content, trigrams from
attachments where transactionid =254774;
-[ RECORD 1
]---+--
I think I found the critical point.
The problem is in the method RT::Record::_EncodeLOB().
I run a little script feeding message into the RT under debugger:
last actions was to setup breakpoint on b RT::Record::_EncodeLOB
and there is several steps:
DB<45> v
788:} elsif (!$RT::H
On Fri, Apr 11, 2014 at 01:47:53PM +0200, Václav Ovsík wrote:
>...
> Maybe the problem is with the libmime-tools-perl (I'm running on the Debian),
> I
> have version 5.503-1.
> ...
correction, I have localy installed version 5.505...
zito@rt2:~/migration/rt$ make tes
FYI: The problem has ticket
http://issues.bestpractical.com/Ticket/Display.html?id=29735
I found a temporary workaround - patch attached...
--
Zito
diff --git a/lib/RT/Record.pm b/lib/RT/Record.pm
index 788aa42..304ac6a 100644
--- a/lib/RT/Record.pm
+++ b/lib/RT/Record.pm
@@ -787,7 +787,7 @@ sub _
Hi,
I found a bug in the DBD::Pg 3.4.1 yesterday
https://rt.cpan.org/Public/Bug/Display.html?id=99144
The problem was fixed very quickly and the new version 3.4.2 was
released.
The upgrade failed for etc/upgrade/3.9.8/content, details are in the
bug-report above.
...
Processing 3.9.8
Now populati
Hi,
I am a bit surprised, that our RT instance sends emails to disabled
users. I thought disabling user is sufficient procedure tu suppress
user access and all communication towards that user by RT.
I did some RT database cleanup procedures (adding/deleting watchers on
old tickets, so I can purge
https://issues.bestpractical.com/Ticket/Display.html?id=29735
--
Zito
Hi,
On Thu, Mar 05, 2015 at 06:37:21PM -0500, Alex Vandiver wrote:
> On Fri, 6 Mar 2015 00:06:32 +0100 Václav Ovsík
> wrote:
> > https://issues.bestpractical.com/Ticket/Display.html?id=29735
>
> Aha -- thanks for digging that out! I thought I vaguely recalled
> s
Hi,
is there any way to set password quality enforcement better then its
minimal length ($MinimumPasswordLength)?
I mean something like
http://sourceforge.net/projects/cracklib
http://www.openwall.com/passwdqc/
or so.
Tried Anyone John The Ripper successfully with RT password hashes?
--
Zito
On Fri, Jul 17, 2015 at 09:05:49AM -0500, Matt Zagrabelny wrote:
> On Fri, Jul 17, 2015 at 6:55 AM, Václav Ovsík wrote:
> > Hi,
> > is there any way to set password quality enforcement better then its
> > minimal length ($MinimumPasswordLength)?
>
> There is a Befor
Hi,
On Thu, Dec 15, 2016 at 12:07:54AM -0800, Alex Vandiver wrote:
>...
> However, upon writing this, it occurs to me that Postgres' default
> isolation level is _also_ "read committed."[4] Thus any possible race
> conditions that might show up under NDB are also possible under
> Postgres. I'd n
On Wed, Dec 21, 2016 at 06:38:08PM +0100, Václav Ovsík wrote:
>...
>
> * default_transaction_isolation = 'serializable'
>- I tried the action many times, but Pg is silent - nothing appears
> in it
Hi,
to reproduce the deadlock problem with RT 4.4.1 on Postgres I tried to install
RT 4.4.1 as clean new instalation:
1. On Debian 8.6 stable + Postgres 9.4
2. On Debian sid (unstable) + Postgres 9.6 (there was a need to
change one sql command, option NOCREATEUSER -> NOCREATEROLE)
T
On Mon, Jan 02, 2017 at 08:10:15PM -0800, Alex Vandiver wrote:
> 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 re
On Wed, Jan 04, 2017 at 04:50:11AM -0800, Alex Vandiver wrote:
>...
> MySQL suffers from the exact same problem -- but, as it happens,
> both more silently and more catastrophically. See
> https://github.com/bestpractical/rt/commit/e36364c5
Eh. I'm glad I did transition from Mysql to Postgres ye
36 matches
Mail list logo