[rt-users] creativity and expertise with Assets and lifecycles

[Peter Zillmann]

Greetings!

I've set up Assets on a test server for our staff to evaluate. They like it 
very much so far, but they've got one need I haven't yet figured out how to 
meet with Assets. I feel like I've read through documentation, wiki, and mail 
archives, and I don't think I've found my answer.

Our staff want to use Assets to track who has a shareable resource. The 
resource might be in inventory, or checked out to a patron. The workflow they 
want needs to be linear, and ideally a single-screen process. They'll want to 
change "held-by" for a resource, and change the item's lifecycle status (from 
on-shelf to checked-out).

I think we're only going to be able to make this workflow work for them if we 
can use a Scrip with a custom action. Existing documentation regarding this 
seems to be written all from a Tickets perspective, leaving me feeling a bit at 
sea.

So, am I wrong to think Assets might be able to meet our need? Or am I thinking 
of this the wrong way? I thought of trying to use a Comment or Respond action 
on an asset, but those features don't seem to exist (I've tried configuring 
them like tickets, but they don't seem to work). Would I be smarter to create a 
linked ticket for each "check-out"/"check-in"?

Would anyone be able to point me in the right direction?

Thanks much,
Peter

--
Peter Zillmann
Systems & Networking Associate
Information Services
Kalamazoo College
1200 Academy Street
Kalamazoo, MI, 49006
269.337.5800
peter.zillm...@kzoo.edu

Re: [rt-users] Pg FTS query works, RT search returns 0 results ( was: '.' as delimiter/boundary breaks domain name searches)

[Jeff Blaine]

>> * An RT 4.2.12 search for the same string returns 0 results[2].
>>   I'm 98% certain the ticket *is* indexed though as other queries
>>   return it[2].

...

> Is the ticket in question a merged ticket?  You had a mail from the
> same timeframe which dealt with merged ticket FTS, which is a known
> bug: https://issues.bestpractical.com/Ticket/Display.html?id=9370
> Sadly, there's not good solution to that bug at this time.

I'm losing what little is left of my mind, apparently. I looked last
week at the problem ticket and could swear it had no merging in its
history. Looking today, I see it *does*.

> perl -MRT=-init -le 
> '$t=RT::Tickets->new(RT->SystemUser);$t->FromSQL("@ARGV");print 
> $t->BuildSelectQuery' \
> "Content LIKE 'f...@domain.com'"

Handy! Used this to generate the SQL. Pasted the SQL into psql for kicks
and got the unfortunately now-expected 0 results. Filed this snippet
away for later.

Thanks Alex.

Jeff

Re: [rt-users] RT and Disaster Recovery - problem

[Aaron C. de Bruyn]

Sorry for the late reply--work exploded. ;)

On Wed, Sep 2, 2015 at 8:40 AM, Guadagnino Cristiano
 wrote:
>  > Are you using Apache, Nginx or something else to serve up RT?
> Apache/2.2.15 (CentOS) Server at localhost Port 80

If it's bound to localhost, how are users accessing it?  Or do you
have something else on the box that has a public-facing IP that
proxies traffic to port 127.0.0.1:80?

Or do you have something like spawn_fcgi running on 127.0.0.1:80 with
apache proxying?


> Yes, DNS is warking properly and very fast. However, on my test VMs I
> have used only IPs to avoid putting the DNS into the equation.

> Apparently it is just RT

Is it the first request, or all requests?
I had an issue with spawn_fcgi if I recall correctly, that when the
process first started it took ~45 seconds to serve the first page.
After that, pages were snappy.

-A

Re: [rt-users] RT and Disaster Recovery - problem

[Ram]

>
> Date: Wed, 2 Sep 2015 13:35:20 -0400
> From: Alex Vandiver 
> To: Guadagnino Cristiano 
> Cc: "rt-users@lists.bestpractical.com"
> 
> Subject: Re: [rt-users] RT and Disaster Recovery - problem
> Message-ID: <20150902173520.ga...@chmrr.net>
> Content-Type: text/plain; charset=us-ascii
>
> On Wed, Sep 02, 2015 at 03:11:52PM +, Guadagnino Cristiano wrote:
> > Our RT servers are virtualized on VMware.
> > [snip]
> > However, the problem is that - after reconfiguring the VMs - RT becomes
> > slow as a snail (tens of seconds for each page change/refresh).
>
>


G, on your DR box time exactly how long the home page takes to load. Three
times in a row, each time. The length of the delay may be very telling.

Re: [rt-users] RT 4.2.12 and CentOS 7

[Emmanuel Lacour]

Le 02/09/2015 19:23, Tom Misilo a écrit :
> Hi,
> 
>  
> 
> I was wondering if anyone has successfully used “make fixdeps” with
> Request Tracker on CentOS 7? As it seems like cpan only installs to the
> local users home directory in a ~/perl5 folder and not systemwide. Which
> when using Request Tracker and mod_fcgid  apache does not find any of
> the modules.
> 
>  


just did it and:

- most perl packages are available through yum with the epel repository
- for last missing cpan modules, you can either try to find them
packaged on another place on the web, build them or install through cpan.

For CPAN, make sure package "perl-homedir"  isn't installed ... Or tweak
your cpan configuration.



-- 
Easter-eggs  Spécialiste GNU/Linux
44-46 rue de l'Ouest  -  75014 Paris  -  France -  Métro Gaité
Phone: +33 (0) 1 43 35 00 37-   Fax: +33 (0) 1 43 35 00 76
mailto:elac...@easter-eggs.com  -   http://www.easter-eggs.com

Re: [rt-users] RT and Disaster Recovery - problem

[Guadagnino Cristiano]

Alex,
thank you for your reply.

No, the VMs do not have any snapshot enabled.

Cris


-Messaggio originale-
Da: Alex Vandiver 
Inviato: Wed Sep 02 2015 19:35:20 GMT+0200 (CEST)
A: Guadagnino Cristiano 
Cc: "rt-users@lists.bestpractical.com" 
Oggetto: Re: [rt-users] RT and Disaster Recovery - problem

> On Wed, Sep 02, 2015 at 03:11:52PM +, Guadagnino Cristiano wrote:
>> Our RT servers are virtualized on VMware.
>> [snip]
>> However, the problem is that - after reconfiguring the VMs - RT becomes
>> slow as a snail (tens of seconds for each page change/refresh).
>
> Do the VMs have any snapshots enabled?  I know that historically, at
> least, the mere presence of a snapshot file caused all I/O to be COW,
> which caused order-of-magnitude I/O bandwidth degradation.
>   - Alex
>

Re: [rt-users] RT 4.2.12 and CentOS 7

[Tom Misilo]

Landon,

 yes I am running as root.

Thanks,

 Tom


 Original message 
From: Landon Stewart 
Date: 09/02/2015 7:28 PM (GMT-05:00)
To: Tom Misilo 
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT 4.2.12 and CentOS 7

On Sep 2, 2015, at 10:23 AM, Tom Misilo 
> wrote:

Hi,

I was wondering if anyone has successfully used “make fixdeps” with Request 
Tracker on CentOS 7? As it seems like cpan only installs to the local users 
home directory in a ~/perl5 folder and not systemwide. Which when using Request 
Tracker and mod_fcgid  apache does not find any of the modules.

Are you running 'make fixdeps' as root privileges?



Landon Stewart : lstew...@iweb.com
Lead Specialist, Abuse and Security Management
Spécialiste principal, gestion des abus et sécurité
http://iweb.com : +1 (888) 909-4932

[rt-users] Issue with rt-serializer and rt-importer

[Simone Morandini]

Hello list,

I'm an RT newbie, and I'm having a problem trying to export/import my RT 
database content.
I have a machine running RT 4.2.9 and I need to move the content onto 
another machine, where I prepared a clean install of the latest RT 4.2.12.
On the old box I ran "rt-validator --check" and then "rt-serializer". I 
moved the content of the output directory onto the new box, where I ran 
"rt-importer /path/to/dir", but I'm having problems.


I can login with my personal username (before importing only the root 
user was defined), but I cannot see any content: no tickets, no queues. 
I can see all the "Saved searches" I had previously configured, but they 
are empty.
If I try to open a new ticket, I get the error message "Queue could not 
be loaded." (none of them is displayed in the drop-down menu).


Instead, if I login as root user, I can see everything correctly, and in 
fact, querying the database using mysql (MariaDB) CLI, the content is 
there: Tickets and Queues tables, for example, are populated with the 
correct content.


What am I missing?

Thanks in advance,
Simone.