Running that query returns no results.
I will look into the indexing. I know we run the rt full text indexing command
every 15 minutes. As for the database indexes I will have to look into it.
- Shawn Plummer
Systems Manager
On Aug 30, 2012, at 9:55 PM, Chris O'Kelly wrote:
> hmmm... that is
More specifically removal of main.EmailAddress != '' makes it return the user
record.
- Shawn Plummer
Systems Manager
On Aug 30, 2012, at 9:37 PM, Shawn Plummer wrote:
> Adding this line makes it return no values.
>
> AND (
> main.EmailAddress != ''
> AND main.EmailAddress IS NO
I further broke the query down.
SELECT DISTINCT main.id, main.EmailAddress, main.name
FROM Users main
JOIN Principals Principals_1 ON ( Principals_1.id = main.id )
WHERE (Principals_1.Disabled = '0')
AND (
lower(main.RealName) LIKE '%taf2%'
OR lower(main.EmailAddress) LIKE 'taf2%'
Thanks for breaking those up! I am digging into the SQL tonight too. The
distinct query appears to return no results in my testing so far.
As for the username change, that user was easier to isolate since it had less
activity than I did when our DBA ran the query. The user definitely exists, has
On Thu, Aug 30, 2012 at 03:09:40PM -0400, Paul Tomblin wrote:
> On Thu, Aug 30, 2012 at 2:52 PM, Kevin Falcone
> wrote:
> > This should be easy to fix. Don't specify <%ARGS> and just
> > do a return if ref $ARGS{URL} to skip the first variant of the
> > callback.
>
> Yes, that worked.
>
> Is th
Hi Guys,
Have you tried separating out the subqueries there?
If it were me that's what I would look at next. Here they are split up into
individual queries (where aliases weren't used already I have given them
generic names):
distinctQuery:
SELECT DISTINCT main.id
FROM Users main
JOIN Principal
Looks like it returns no rows. So that could be a problem!
SQL*Plus: Release 11.2.0.3.0 Production on Thu Aug 30 19:24:24 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning
> Date: Thu, 30 Aug 2012 14:54:11 -0400
> From: falc...@bestpractical.com
> To: rt-users@lists.bestpractical.com
> Subject: Re: [rt-users] rt upgrade
>
> On Thu, Aug 30, 2012 at 07:42:42AM +, Wanli Cheng wrote:
> >I tried to convert my rt database from mysql version 3 to mysql version
Please keep replies on the list for the benefit of folks searching for
answers later.
On 08/30/2012 01:16 PM, Shawn Plummer wrote:
> My DBA tells me that this is the query she sees in the database when
> the autocomplete fires:
>
>> "SELECT * FROM ( SELECT limitquery.*,rownum limitrownum FROM (
>
Ah that's the droid i was looking for. We have two admins working on this
instance, I'm maintaining the front end, and out Dev/ DBA is managing the
back end config. I'll let him know that we can configure a blacklist in
the MTA. I have SSH access to the backend, but I'm not sure were to begin
lo
On 08/30/2012 01:37 PM, Anton Roth wrote:
> Below is my httpd.conf from Apache2
>
>
>AddDefaultCharset UTF-8
>
>DocumentRoot "/opt/rt4/share/html/"
>
>
This is a Location, not a Directory section so you use URL paths not
file system paths.
> Order allow,deny
> Allow fr
Hi,
I have set up RT 4.0.7 a few days ago on a Ubuntu12.04 system, but I cannot
get it to run.
It says a "You're almost there!
You haven't yet configured your webserver to run RT. You appear to have
installed RT's web interface correctly, but haven't yet configured your web
server to "run"
On 30 Aug 2012, at 20:04, Stephen Desch wrote:
> I see, I'll have to look into adding that to our server.
Depending on how mail is being delivered to your RT system, you can often do it
with the MTA on the system as well, by configuring a blacklist of addresses you
don't want delivering to y
On Thu, Aug 30, 2012 at 2:52 PM, Kevin Falcone
wrote:
> This should be easy to fix. Don't specify <%ARGS> and just
> do a return if ref $ARGS{URL} to skip the first variant of the
> callback.
Yes, that worked.
Is there a 4.2 git repo up in the usual places?
--
http://www.linkedin.com/in/paul
I see, I'll have to look into adding that to our server.
On Thu, Aug 30, 2012 at 2:28 PM, Rich Bishop wrote:
> We run procmail ( http://www.procmail.org/ ) on our RT machine to do this
> among other things.
>
> Rich
>
>
> On 08/30/2012 02:07 PM, Stephen Desch wrote:
>
>> Hi,
>>We have set u
On Thu, Aug 30, 2012 at 07:42:42AM +, Wanli Cheng wrote:
>I tried to convert my rt database from mysql version 3 to mysql version 5.
>The database mysql version 3 doesn't have such an option:
> --default-character-set=binary
It's usually ok to exclude this on really old MySQL versi
On Tue, Aug 28, 2012 at 09:05:55PM -0400, Paul Tomblin wrote:
> I'm trying to make it so when a user logs out of RT, they get taken
> back to my page when they log back in. But I'm having problems with
> the callback in /NoAuth/Logout.html, because it seems like the
> "Default" callback is called
On Tue, Aug 28, 2012 at 10:27:40PM +0200, Joerg Droege wrote:
> Hello there. thanks in advance for helping me.
> After a couple of failures of dependency problems while compiling or
> installing newer versions , I have finalling managed to get to install an RPM
> of RT 3.6 on my Mandriva 2011 X86
On Tue, Aug 28, 2012 at 04:02:42PM +, Shane Duignan wrote:
> MTA is :
>
> Subject: [queue #278] document (Aug 2012)
> From: "admin via RT"
> Reply-To: j...@tre.ie
> In-Reply-To: References:
> Message-ID:
> Precedence: bulk X-RT-Loop-Prevention: queue
> RT-Ticket: queue #278 Managed-b
We run procmail ( http://www.procmail.org/ ) on our RT machine to do
this among other things.
Rich
On 08/30/2012 02:07 PM, Stephen Desch wrote:
Hi,
We have set up our RT instance successfully and are starting to track
tickets and support requests. The problem is we have some notification
em
Hi,
We have set up our RT instance successfully and are starting to track
tickets and support requests. The problem is we have some notification
emails that are creating tickets in our system, which we dont need/want.
Example:
email from:nore...@domain.com
to: cust...@domain.com
subject: notifi
On 08/30/2012 10:57 AM, Shawn Plummer wrote:
> I appreciate the help. Seems an odd issue.
Odd indeed. Can you capture the SQL query RT is sending Oracle for the
autocompleter?
Does it return any results?
On Aug 30, 2012, at 1:38 PM, Thomas Sibley wrote:
> FWIW, I can't replicate this, so there are bound to be a few questions to
> rule out possibilities.
>
I appreciate the help. Seems an odd issue.
> Can you search your DB directly?
>
> select id, Name, EmailAddress from Users where Name LIKE
On 08/30/2012 10:12 AM, Shawn Plummer wrote:
> That user is me. I do have an email address.
>
> Those logs are the searches done as I type. I was typing in the
> requestor field.
FWIW, I can't replicate this, so there are bound to be a few questions to rule
out possibilities.
Can you search yo
Caolis Ustariz te ha dejado un mensaje...
Sólo tú podrás ver tanto el mensaje como su remitente y lo puedes borrar en
cualquier momento. Puedes responder a través del chat de Badoo. Para leer tu
mensaje, haz clic en el siguiente enlace:
http://us1.badoo.com/01221563152/in/rBoOijS3EPY/?lang_id=7&
That user is me. I do have an email address.
Those logs are the searches done as I type. I was typing in the requestor field.
If I type my name in the owners field it returns a value, requestors it does
not. We are using the defaults from RT_Config for search values.
On Aug 30, 2012, at 1:03
On 08/30/2012 06:57 AM, Shawn Plummer wrote:
> I just installed RT 4.0.7 this morning (along with the latest
> versions of External Auth, LdapImport, and Commands by email), and
> now the autocomplete in user fields is not working.
One of the access log lines you showed was autocompleting for a us
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 8/28/12 11:35 AM, Duncan Hutty wrote:
> And I need to publish another puppet module that I have written
> that is a dependency: pgsiserver. But it's coming and hopefully
> sooner rather than later.
Ok, done that. [dhutty-psgiserver] [1] is able
to d
Hi Ruslan,
i see exactly what to do. I'll try to do this on a 3 levels CF depency.
Do you know if the feature a want use should be in a future release?
Thank you for your time.
JMC
2012/8/27 Ruslan Zakirov
> Hi,
>
> At this moment it's impossible to do like you want it to do. External
> custo
Hello everyone,
I just installed RT 4.0.7 this morning (along with the latest versions of
External Auth, LdapImport, and Commands by email), and now the autocomplete in
user fields is not working.
It does still work in the owner field (since we have enabled
Set($AutocompleteOwners, 1);)
I ca
Anyone know if it is possible to set mandatory fields on a per-queue
basis for RT 4.0.5?
I looked at the MandatoryFields extension
(http://search.cpan.org/dist/RT-Extension-MandatoryFields/), but it
seems to be an all-or-nothing solution for the whole of RT, and not
per-queue.
Hello,
I tried to convert my rt database from mysql version 3 to mysql version 5.
The database mysql version 3 doesn't have such an option:
--default-character-set=binary
anybody have any suggestions? Thanks.
Wanli
32 matches
Mail list logo