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

[Joop]

On 4-9-2015 0:15, Simone Morandini wrote:
> 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.
Why don't you use the export/import tools of the database of you choice?
Or are you switching from ABC to mysql/mariadb?

Regards,

Joop

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

[Simone Morandini]

Hello Joop,

On 4-9-2015 0:15, Simone Morandini wrote:

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.

Why don't you use the export/import tools of the database of you choice?
Or are you switching from ABC to mysql/mariadb?



actually I'm running mysql on the old server as well, I just thought 
that the rt-* commands were more suited.
And indeed, data is there: if I login as root I can see all the 
tickets/queues, etc. I just cannot see them if I login as a regular user.
It seems some kind of "permission" issue, if it makes sense in the RT 
world. I actually do not know what to try in order to troubleshoot...


Thanks,
Simone.

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

[Guadagnino Cristiano]

Hi Aaron.

-Messaggio originale-
Da: Aaron C. de Bruyn 
Inviato: Thu Sep 03 2015 19:30:40 GMT+0200 (CEST)
A: Guadagnino Cristiano 
Cc: "rt-users@lists.bestpractical.com" 
Oggetto: Re: [rt-users] RT and Disaster Recovery - problem

>>   > 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?

RT is accessible only in our intranet.
Apache is configured with a few virtual doamins, one of which is 
dedicated to RT.
I don't know why it reports localhost; however this was captured on the 
working production instance, so no problem here.


> 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
>

All requests, unfortuantely.


Cris

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

[Simone Morandini]

Il 04/09/15 14:36, Joop ha scritto:

On 4-9-2015 0:15, Simone Morandini wrote:

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.

Why don't you use the export/import tools of the database of you choice?
Or are you switching from ABC to mysql/mariadb?




just for the records: exporting with mysqldump and then importing with 
mysql solved the issue.


Thanks,
Simone.

[rt-users] Include Ticket information in full text index

[Cena, Stephen (ext. 300)]

I have successfully gotten full text indexing working on our RT 4.2.12 system, 
MySQL 5.5 back-end. At the present time, only the ticket history is being 
searched. This is my Sphinx query:

sql_query   = \
SELECT a.id, a.content FROM Attachments a \
JOIN Transactions txn ON a.TransactionId = txn.id AND txn.ObjectType = 
'RT::Ticket' \
JOIN Tickets t ON txn.ObjectId = t.id \
WHERE a.ContentType = ('text/plain' or 'text/html') AND t.Status != 
'deleted'

Is there a way to modify this query to include some Ticket information 
(subject, requestor, etc.) in the search, or will users just have to use the 
Search Builder for more detailed searches?

Thanks in advance!!


Stephen J. Cena
Systems Administrator/Supervisor - MIS/IT Dept
Quality Vision International
850 Hudson Ave
Rochester,NY 14620
Phone: 585-544-0450 x300
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Please report email problems to: postmas...@qvii.com
QVII MIS/IT Dept - We do what we must because we can.
"Thank you for helping us help you help us all."
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

[rt-users] Customize QuickSearch for RT 4.0.19 - Removing all

[ewanchic]

Hello,
  Everytime I do a quicksearch, it inculdes this addition criteria:

AND (
  Status = 'new'
  OR Status = 'open'
  OR Status = 'stalled')

I don't remember it doing this in 3.6.6 / 3.6.8

I've looked up various other forums and posts. They've mentioned:
   modifying Quicksearch, Quicksearch.html, QueueSummary* (which is now two
different files),
   Adding 'Set(@ActiveStatus, qw());' to RT_SiteConfig.pm,
   or modifying the Lifecycles.

I'm not Looking to change the Lifecycles because that look fine to me, but I
would like to just remove all the extra criteria and just focus on the
criteria requested in the Quick Search. Is this possible? Thanks

Eric



--
View this message in context: 
http://requesttracker.8502.n7.nabble.com/Customize-QuickSearch-for-RT-4-0-19-Removing-all-tp60600.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.

Re: [rt-users] Customize QuickSearch for RT 4.0.19 - Removing all

[Alex Vandiver]

On Fri, Sep 04, 2015 at 09:45:56AM -0700, ewanchic wrote:
> I'm not Looking to change the Lifecycles because that look fine to me, but I
> would like to just remove all the extra criteria and just focus on the
> criteria requested in the Quick Search. Is this possible? Thanks

   
https://docs.bestpractical.com/RT_Config#OnlySearchActiveTicketsInSimpleSearch

Set this to 0 in your RT_SiteConfig.pm:

   Set( $OnlySearchActiveTicketsInSimpleSearch, 0);

 - Alex