Re: [rt-users] Top menu Aileron theme disappear when using custom theme

2016-03-10 Thread Kristian Davies
calstyle/ > > I'll create a ticket to update the docs. > > Jim > > > On 3/9/16 7:09 AM, Kristian Davies wrote: >> >> I have this issue as well, doesn't appear to matter which theme i make >> custom either. >> >> Is there additional require

Re: [rt-users] Top menu Aileron theme disappear when using custom theme

2016-03-09 Thread Kristian Davies
I have this issue as well, doesn't appear to matter which theme i make custom either. Is there additional requirements than what's in the documentation in order to get custom themes to work? -Kristian On Mon, Jun 9, 2014 at 2:46 PM, Aurélien Lafranchise wrote: > Hello, > > I tried by starting a

[rt-users] Users timezone

2013-12-12 Thread Kristian Davies
RT v4.0.6 MySQL 5.1.50 Can a users timezone be set via REST/rt script or is it safe just to set it manually via Users table in the database? Cheers, Kristian

Re: [rt-users] RT session cleanup - session table size

2013-07-15 Thread Kristian Davies
On Mon, Jul 15, 2013 at 12:37 PM, Alex Decalli wrote: > BIG NEWS:: solution discovered: > > I first hit this: > > > sudo rt-clean-sessions --debug --older 1M > > and then: > > Mysql> OPTIMIZE TABLE sessions; > > Now my session table is 1K :] > > That's what I did too but I had to re-run the rt-cle

Re: [rt-users] RT session cleanup - session table size

2013-07-12 Thread Kristian Davies
On Sun, Jul 7, 2013 at 1:21 PM, Alex Decalli wrote: > Hello everybody > I want to cleanup my session table, it is already about 1 Gigabyte! I hit: > Hmm amusingly once I saw this post I thought I would check ours... 2.2M rows = 8GB on disk :-) -Kristian

Re: [rt-users] Custom Field searching

2012-11-09 Thread Kristian Davies
> You don't mention your database. Sorry... MySQL 5.1.50-enterprise-gpl-advanced-log > Also, please describe "doesn't work". By not work I mean it doesn't 'filter out' without the 'IS NOT NULL'. It does however work with matching on custom fields. -Kristian We're hiring! http://bestp

Re: [rt-users] Scrip problem (status change)

2012-10-12 Thread Kristian Davies
> I hope you know what IsBound means. Right? Take a look at documentation > in lib/RT/Transaction.pm Ahhh *facepalm*... must use perldoc more. Thanks. -Kristian Final RT training for 2012 in Atlanta, GA - October 23 & 24 http://bestpractical.com/training We're hiring! http://bestprac

Re: [rt-users] Scrip problem (status change)

2012-10-12 Thread Kristian Davies
> You don't check result of SetStatus. Message it returns probably tells > you that such status change is prohibited by Lifecycles configuration. my $ticketStatus = $self->TicketObj->Status; if ( $ticketStatus eq 'testing' ) { if ($self->TransactionObj->IsInbound()) { my ($val, $m

Re: [rt-users] RT 3.8.0 DB migrate to 4.0.5 - Errors Please help!

2012-06-20 Thread Kristian Davies
On Tue, Jun 12, 2012 at 7:23 PM, FrankOh wrote: > > OK i've searched all over the Internet and I can't seem to fix the problem. > Currently in production we have RHEL (kernel 2.6.18-238.9.1.el5) with > RT3.8.0 installed on mySQL 5.0.77. We want to move RT off of this physical > box and put it on V

[rt-users] List CF values

2012-04-20 Thread Kristian Davies
Is it possible via the REST api to get a list of possible CF values? Someone speculatively asked me the question and I had not idea.. Cheers, Kristian

[rt-users] Dashboards & RT at a glance

2011-07-19 Thread Kristian Davies
Hey All ! Would I be right in saying that dashboards are for notification rather than a default view in 'RT at a glance' ? We have different support departments and we'd like to give each one a default set of 'RT at a glance' Cheers, Kristian 2011 Training: http://bestpractical.com

Re: [rt-users] Pg to mysql : attachements not viewable

2011-06-07 Thread Kristian Davies
On Mon, Jun 6, 2011 at 3:49 PM, Kevin Falcone wrote: >> Just in case it's something to do with database encoding, I used >> rt-3.8.2/etc/schema.mysql to create the database (and >> rt3-on-pg-to-mysql script from the wiki?? to import from pg). > > That's the wrong schema, you wanted schema.mysql-4.

Re: [rt-users] Pg to mysql : attachements not viewable

2011-06-06 Thread Kristian Davies
> That's the wrong schema, you wanted schema.mysql-4.1 > Any new attachments are likely to have corruption. > > I know nothing about the script you're using, but you have to convert > out of the base64 storage used on Pg to binary storage on mysql. > Your content-type headers imply that you didn't

[rt-users] Pg to mysql : attachements not viewable

2011-06-06 Thread Kristian Davies
I've just moved our RT DB from postgres to Mysql (5.1.50). Apart from the DB change, I edited RT_siteconfig.pm and also had to upgrade the perl-DBD-mysql module (apache is a centos 4, 32bit box). When I click on the attachment link I get nothing (in chrome) and in firefox I just get the path as t

Re: [rt-users] Initiate Template via custom scrip action

2010-04-20 Thread Kristian Davies
> What happens if you move your action code to the condition and then make you > rAction : Notify Requestors with the Template you need ; ie your condition > will be something like: Thanks for the reply. I already tried that, but just to sanity check I tried it again. No avail. Requestor doesn'

[rt-users] Initiate Template via custom scrip action

2010-04-20 Thread Kristian Davies
I've created a scrip: Condition: User Defined Action: User Defined Template: Global Template: Blank Stage: TransactionCreate Custom Condition: my $Transaction = $self->TransactionObj; my $CreatorId = $Transaction->CreatorObj->Id; if ( $self->TransactionObj->Type eq "Create" && !$self->TicketObj

[rt-users] Editable Text

2009-04-28 Thread Kristian Davies
There seems to be an odd issue this this. Create two tickets, 1001 and 1002. Add "Depends on: 1001" to 1002. Search for them both. and click "Editable Text" ===Update-Ticket: 1001 Queue: Test Queue Subject: TEST Status: open UpdateType: correspond Children: DependedOnBy: DependsOn: Parents: Refe

Re: [rt-users] Problem Tools, Reports Postgres 3.8.2

2009-03-16 Thread Kristian Davies
> Thank you for the information. I was hoping that it was something > like that. Stick with your areas of expertise to reduce support > costs. We are more the other way here with more PostgreSQL than > MySQL. What is your plan to provide redundancy/business continuity > for your RT instance and wha

Re: [rt-users] Problem Tools, Reports Postgres 3.8.2

2009-03-13 Thread Kristian Davies
> It does sound like something is missing because I am running > PostgreSQL 8.3.5 and did not have to make these changes. I do have > a question, why are you converting your RT instance to MySQL? Is > there a particular problem you are trying to address? No technical reason, we are a essentially a

Re: [rt-users] Problem Tools, Reports Postgres 3.8.2

2009-03-12 Thread Kristian Davies
On Thu, Mar 12, 2009 at 1:51 PM, Kenneth Marshall wrote: > On Thu, Mar 12, 2009 at 08:44:23AM -0500, Kenneth Marshall wrote: >> Kristian, >> >> I think the problem is in SearchBuilder/Handle.pm in the function >> _MakeClauseCaseInsensitive. It looks like it only skips the lower() >> for integer va

Re: [rt-users] Problem Tools, Reports Postgres 3.8.2

2009-03-12 Thread Kristian Davies
Unfortunately I'd already tried those. I did however get excellent results from your full text search wiki page though. Mar 12 12:48:19 ghole postgres[13129]: [2-1] ERROR: function lower(timestamp without time zone) does not exist at character 259 Mar 12 12:48:19 ghole postgres[13129]: [2-2] H

[rt-users] Problem Tools, Reports Postgres 3.8.2

2009-03-12 Thread Kristian Davies
Postgres: 8.3.6 RT 3.8.2 CentOS 4 My graphing isn't working under Tools>Reports. Any ideas? Cheers, Kristian /var/log/message Mar 12 10:50:27 ghole postgres[11326]: [2-1] ERROR: function lower(timestamp without time zone) does not exist at character 315 Mar 12 10:50:27 ghole postgres[11326]:

Re: [rt-users] Time Displays

2009-02-10 Thread Kristian Davies
>Thanks to Kristian Davies I have modifed my time entries to allow only > "Days". The data is stores "as is", which is perfect. If someone enters > "5", it is stored as "5". However, when I display a ticket, it still > shows "min&quo

Re: [rt-users] RT Time fields in days?

2009-02-04 Thread Kristian Davies
Not my code, but in the interest of sharing: local/html/Elements/SelectTimeUnits %# END BPS TAGGED BLOCK }}} % my $selected = 'minutes'; % $selected = 'hours' if $minutes > 60; % $selected = 'days' if $minutes > 480; ><% loc('Minutes') %> ><% loc('Hours') %> ><% loc('Days') %> <%INIT> $Name .=

[rt-users] PG to MySQL Duplicate key

2009-01-20 Thread Kristian Davies
Whilst converting my 2.6GB postgres RT database 3.6.5 to mysql i get the following error. [r...@bogan rt-3.6.5]# mysql -u root -p rt3 --ignore < /tmp/rt.sql6 Enter password: ERROR 1062 (23000) at line 34107989: Duplicate entry '242710-28171' for key 2 (line 34107989) INSERT INTO GroupMembers (id,

Re: [rt-users] Basic setup...

2008-08-01 Thread Kristian Davies
On Fri, Aug 1, 2008 at 3:39 PM, Ruslan Zakirov <[EMAIL PROTECTED]> wrote: > http://wiki.bestpractical.com/view/ManualApacheConfig After kicking it to death it was actually: #Set($WebExternalAuth , 1); #Set($WebFallbackToInternalAuth , 'true'); #Set($WebExternalGecos , undef); #Set($WebExternalAut

[rt-users] Basic setup...

2008-08-01 Thread Kristian Davies
Q: I have a working setup fresh install authenticating against AD. Problem is, i have no super users as it's a fresh install. I hear there is a root/password account but in order to use that i have to disable AD authentication in my apache.conf. As per: ServerName rnd-test.mpc.local Se

[rt-users] Tree View

2008-06-26 Thread Kristian Davies
RT Version: 3.6.5 The "Tree View" function doesn't seem to work. Is this a know problem? Tia, Kristian ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTEC

Re: [rt-users] Scrips (queue change notify)

2008-06-02 Thread Kristian Davies
On Mon, Jun 2, 2008 at 5:11 PM, Gene LeDuc <[EMAIL PROTECTED]> wrote: > Hi Kristian, > > In addition to what Toby mentioned about NotifyActor, you only need to put > the scrip in the receiving queue. If a ticket moves from OldQueue to > NewQueue, the scrip in NewQueue will fire but the one in OldQ

Re: [rt-users] Scrips (queue change notify)

2008-06-02 Thread Kristian Davies
>> Description: Queue Notify >> Condition: On queue change >> Action: Notify requesors, CC and AdminCC >> Template: Global template: Transaction >> Stage: TransactionCreate. >> >> I am the requestor and adminCC. >> >> Still does not send the email. I thought that would be enough. > > Are you also

[rt-users] Scrips (queue change notify)

2008-06-02 Thread Kristian Davies
I'm trying to create a notification email on the receiving queue when a ticket is moved. I have two queues (test1 and test2), and I've added a scrip to both: Description: Queue Notify Condition: On queue change Action: Notify requesors, CC and AdminCC Template: Global template: Transaction Stage:

Re: [rt-users] Question regarding search case

2008-03-12 Thread Kristian Davies
On Wed, Mar 12, 2008 at 12:59 PM, Mathew <[EMAIL PROTECTED]> wrote: > A user recently asked me a question regarding the case of searches. He > was looking for tickets owned by another user which were open by using > the quick search box. He knew enough about the subject to know which > one he

Re: [rt-users] rt scripting

2008-02-25 Thread Kristian Davies
On Mon, Feb 25, 2008 at 9:46 PM, Mathew Snyder <[EMAIL PROTECTED]> wrote: > my $users = new RT::Users(RT::SystemUser); > $users->LimitToPrivileged; Ahh-haa.. My code is like a rubik's cube, if I shake it hard enough all the bits fall in place. This is now working. Thanks very much! -Kristian _

[rt-users] rt scripting

2008-02-25 Thread Kristian Davies
Problem: Retrieve list of privilidged users automagicallu. What is the best way to do this? I'm guessing it's not attacking the db directly. Having poked around the code, i tried to replicate what the configuration>users page with the perl api but due to my lack of perl foo i failed quite badly

[rt-users] Re: Missing/Hiding history post upgrade

2007-08-03 Thread Kristian Davies
On 8/2/07, Kristian Davies <[EMAIL PROTECTED]> wrote: > I have rt running on machine A with 45k tickets in production use. I > thought I would do a couple of test upgrades on machine B. A is > running Apache1.x, mysql4,redhat7.2, rt 3.0.7 . B is Apache2+mod_perl, > mysql5,

[rt-users] Missing/Hiding history post upgrade

2007-08-02 Thread Kristian Davies
I was wondering if someone could shed some light on my little problem. I have rt running on machine A with 45k tickets in production use. I thought I would do a couple of test upgrades on machine B. A is running Apache1.x, mysql4,redhat7.2, rt 3.0.7 . B is Apache2+mod_perl, mysql5,CentOS4.4, RT3