Re: [rt-users] Debian with RT 3.4 package install - trouble with crontool

2007-05-02 Thread Andrew Nicols

On 5/2/07, Kevin Squire [EMAIL PROTECTED] wrote:


I am running Debian Stable, with the package install of RT 3.4

No longer stable ;)


[EMAIL PROTECTED]:~$ rt-crontool --search RT::Search::ActiveTicketsInQueue
--search-arg testing --action RT::Action::Escalatriority

But got the following error:


Can't locate /etc/request-tracker3.4/RT_SiteConfig.pm in @INC (@INC
contains: /usr/local/share/request-tracker3.4/lib
/usr/share/request-tracker3.4/lib /etc/perl /usr/local/lib/perl/5.8.4
/usr/local/share/perl/5.8.4 /usr/lib/perl5 /usr/share/perl5
/usr/lib/perl/5.8 /usr/share/perl/5.8 /usr/local/lib/site_perl .) at
/usr/share/request-tracker3.4/lib/RT.pm line 123.


As the user you're using, rtuser judging from the above extract, can
you access RT_SiteConfig.pm
IIRC, The permissions on RT_SiteConfig.pm is owned by root:root with
600 permissions so only root can view the file, hence the can't locate
error.
Try running the crontool with some kind of root permissions and see
where you can go from there.

Andrew

--
do be do be doh!
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] Re: Upgrade from 3.0.2 - 3.6.3, easy as 3.14159?

2007-03-05 Thread Andrew Nicols

On 3/5/07, Mathew [EMAIL PROTECTED] wrote:

This is why I don't like using packages put together by any of the
distros.  I prefer installing the source package from Best Practical.
If you were to install the RPMs there would be no path to update the
database schema.


Not necessarily true. Debian, for example, places all of the database
upgrade files in /etc/request-tracker3.6/upgrade/$version and you just
need to call rt-setup-database with the appropriate options as normal
making upgrade relatively painless.

Andrew

--
do be do be doh!
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] How to run multiple instances of RT

2006-09-27 Thread Andrew Nicols
On 9/27/06, bijayant kumar [EMAIL PROTECTED] wrote:
Hi to all, I have installed RT successfully. Now i need to create multiple instances of RT for different projects. I gone through the mailing list archive, and found that it is possible. But could not able to understand it correctly. I know it is my fault. Can any one help me here to provide a suitable how to on to it. I will be very thankful to you all. Thanks in advance..
Hi again Bijayant,Please can you supply some more information:- What version of RT- What web server, version- Are you using mod_perl, mod_perl2 or fastcgi etc
There is an article in the wiki at: http://wiki.bestpractical.com/index.cgi?MultipleInstances which covers exactly what you're after.
Andrew
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] search

2006-09-26 Thread Andrew Nicols
Further to this, the Home Page Saved Searches are your friend: http://wiki.bestpractical.com/index.cgi?HomePageSavedSearchesTo save searches, you need permission to View Saved Searches and to Save them. I forget the exact permissions and I haven't got an RT instance to hand but you'll be looking in the Group Permissions for them,
AndrewOn 9/26/06, Tomasz Wlodek [EMAIL PROTECTED] wrote:
On Tue, 26 Sep 2006, Justin Lim wrote: I noticed that when you do a quick search from the homepage of RT that it only searchs the open tickets. Is there a way to include ALL tickets opened/closed/resolved/etc ?
Go to tickets and use the query. Using the query builder you can searchfor any tickets you want using any criteria you want. Building the queryit a bit tricky and hard to explain by e-mail, you have to experiment with
it before you become an expert, but it is possible to learn it. Once youhave built a query you can save it to use later, so if you have queriesyou use often you can customize your RT.Tom___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-usersCommunity help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]Discover RT's hidden secrets with RT Essentials from O'Reilly Media.Buy a copy at 
http://rtbook.bestpractical.com-- Regards,Andrew Nicols
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

[rt-users] Re: Recurring login problem

2006-09-25 Thread Andrew Nicols
Hi Bijayant,What version of RT are you running, what http server and what database.Are all of your perl modules up to date?If this is version 3.6.0 of RT then it's a known problem and the solution is to upgrade to 
3.6.1 and upgrade Apache::Session from memory. Search the mailing lists and you should find what you're looking for: http://www.gossamer-threads.com/lists/rt/users/
AndrewOn 9/25/06, bijayant kumar [EMAIL PROTECTED] wrote:
Hi to all, I have installed RT 2 days back. The problem is whenever i click on any link i am kicked out to the login page again. RT is running on gentoo-linux. I have searched through the mailing list archive but didnot find any suitable answer that can help me. Some member have suggested in the list to use different browser, thats why i tried on mozilla, mozilla firefox, opera. But none of the web browser solved my problems. In all the browser, cookies are allowed. I can see the cookies in my browser, it is something like 
Name: RT_SID_kavach.blr.80Content: 6015dc61b4c4eecbffafb85b7903b5aaHost: localhostPath: /Send For: Any type of connectionExpires: at end of sessionI have read every files, and each mail on mail list
 archive. But didnt find answer of my problem. Please please help me, i am really screwed upThanks in advance..Bijayant Kumar Send instant messages to your online friends 
http://uk.messenger.yahoo.com 
-- Regards,Andrew Nicols
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Newbie here, not able to login

2006-09-23 Thread Andrew Nicols
On 9/23/06, bijayant kumar [EMAIL PROTECTED] wrote:
Hi, I have installed Rt on my gentoo-linux box witj the help of wiki written for the gentoo plateform. All goes well, and i found no difficulty doing this. But now when i am trying to login in to the main page it gives me an error that your login name or password is incorrect. I have used PERL and MYSQL as a database. And i am giving login name as root and password as password. I have searched archive, but didnt find any answer for my question. I have posted my question already. Please please help me regarding this, i will be very thankful to you all. 
And one more thing in my apache2 error log i find this error[Sat Sep 23 04:30:58 2006] [error]: FAILED LOGIN for root from 
127.0.0.1 (/var/www/localhost/htdocs/rt/autohandler:238)Hi there,Have you correctly initialized the database? Log into your mysql database and check that the tables are there. If they are, run a query to check that your root user is there. This query should list all users:
select name, password from users;If there are no users listed, then you haven't properly initiated the database and it's probably best to just drop and re-initialise the database to see if that fixes it.
I hope that gives you a starting point,-- Regards,Andrew Nicols
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Newbie here, not able to login

2006-09-23 Thread Andrew Nicols
On 9/23/06, bijayant kumar [EMAIL PROTECTED] wrote:
Hi, Thanks for replying me. Yes, you are right, i didnot initialize the database. But when i populate the database manually, and then login it gives me the same error. After checking, i found a file named initialdata. but when i tried to use this it gives me an error, or i donot know how should i use this file to populate the database. If you dont mind can you tell me how to do this. I am using gentoo-linux. I am really screwed up. Thanks in advance.
Hi again Bijayant,If you installed RT using the gentoo package, read the instructions under Database Setup at 
http://wiki.bestpractical.com/index.cgi?GentooInstallGuideOtherwise, assuming you compiled from source, cd to the directory you comiled from and run:% make initialize databaseYou should be able to find some suitably close advice on the wiki at 
http://wiki.bestpractical.com/index.cgi?InstallationGuides-- Regards,Andrew Nicols
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Newbie here, not able to login

2006-09-23 Thread Andrew Nicols
I beg to differ. The following is taken straight from the page I linked for you. It basicallysays to setup mysql, restart the server, then run the rt-setup-database tool with the paramaters provided.Please read it again!
Andrew---
RT provides a script called rt-setup-database which creates the initial database for you. Please note that rt-setup-database does NOT create a database user
 for you.  If you have not already created a database user for RT, please consult the appropriate documentation, such as ConfigureMysqlOnGentoo.


For MySQL:


Note: If you did not previously have mysql installed, you will need to ConfigureMysqlOnGentoo.



Verify that the skip-innodb is commented out in /etc/mysql/my.cnf.  If it is not, then put an octothorpe in front of it:


..[mysqld]#skip-innodbuser   = mysql..

and restart the mysql server:


/etc/init.d/mysql restart

Then set up the database:


/var/www/myrt/rt-3.6.0/sbin/rt-setup-database --action init --dba root --prompt-for-dba-passwordOn 9/23/06, bijayant kumar
 [EMAIL PROTECTED] wrote:Hi,
 Thanks for your support. But, i am really sorry to say that there is nothing given about the database setup in gentoo guide. When i have installed RT than it says that database setup will be done automatically, but it didnt happened. Now i will try to install RT from the source. Meanwhile if you want to give me any other idea regarding this, than i will be very thankful to you for thr same
Andrew Nicols [EMAIL PROTECTED]
 wrote: On 9/23/06, bijayant kumar 
[EMAIL PROTECTED] wrote: Hi, Thanks for replying me. Yes, you
 are right, i didnot initialize the database. But when i populate the database manually, and then login it gives me the same error. After checking, i found a file named initialdata. but when i tried to use this it gives me an error, or i donot know how should i use this file to populate the database. If you dont mind can you tell me how to do this. I am using gentoo-linux. I am really screwed up. Thanks in advance. 
Hi again Bijayant,If you installed RT using the gentoo package, read the instructions under Database Setup at 
 http://wiki.bestpractical.com/index.cgi?GentooInstallGuideOtherwise, assuming you compiled from source, cd to the directory you comiled from and run:% make initialize databaseYou should be able to find some suitably close advice on the wiki at  
http://wiki.bestpractical.com/index.cgi?InstallationGuides-- 
Regards,Andrew Nicols Bijayant Kumar Send instant messages to your online friends 
http://uk.messenger.yahoo.com 
-- Regards,Andrew Nicols
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] How to Downgrade Perl Module (Mason)

2006-09-12 Thread Andrew Nicols
On 9/11/06, Kehinde Orisanaiye [EMAIL PROTECTED] wrote:
Now, i have searched through previouse threads and i have seen the soluotion as downgrading Mason 1.30 that i have now to 1.28.PLEASE CAN SOMEONE HELP ON THIS, I DID NOT KNOW HOW TO DOWNGRADE TO 
1.28.Download the CPAN source and follow the instructions within the tarball. Usually perl Makefile.pl; make; make test; make install
http://backpan.cpan.org/modules/by-module/HTML/HTML-Mason-1.28.tar.gzThat normally does the trick-- Regards,Andrew Nicols
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] RT Installed now can't display in browser

2006-09-12 Thread Andrew Nicols
On 9/12/06, Mark [EMAIL PROTECTED] wrote:
I want to use RT on an internal network only (and still receive emails).I went to Firefox and loaded http://localhost/rt but unfortunately itjust says Page Can Not Be Displayed. If I go to 
http://localhost then Iget Parent Directory and Apache2-default/ listings.What does the relevant section of your apache config say? It sounds like something wrong with that side of things.
Also, any relevant entries in your apache error logs?-- Regards,Andrew Nicols
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] RT 3.6.1 install question

2006-09-07 Thread Andrew Nicols
On 9/7/06, Frank Saxton [EMAIL PROTECTED] wrote:
I was confused when it came to setting up the mysql databasestuff.I got error messages because it didn't like the password butit seems to have gotten over it./var/lib/mysql/rt3 has what lookslike everything in it but I cannot log in as root.No matter what I
give it, I get a username or password incorrect message.Check the Apache logs to see what it's rejecting on. The default username and password are root/password just in case something's misplaced on the wiki. If you can't log on to a fresh RT install, there may be something missing.
This is not a huge problem (I don't think) because I have 3.0.1running on another LInux box and what I'd really like to do is just
copy over all of the accounts, tickets, settings, etc from thatenvironment and put them on the new box.Someone advised me on how to do this a year or so ago and it was verysimple.So simple, that I've forgotten what to do.I tried a tar of
everything on the only /var/lib/mysql/rt3 onto the new machine butthen I get text instead of the GUI when I try to bring up RT.I think if someone can just tell what to copy to the new machine tomake it just like the old RT server, I should be good to go.TIA!
If you have a look at the RT Tarball, there are some upgrade instructions. Your best bet is to have a look at the INSTALL file. From memory it's about point 6 or 7 on there.There are a few changes from 
3.0 to 3.6.1 but they're relatively easy to apply. Just a case of running:% rt-setup-database --datadir /path/to/etc/upgrade/ver --dba dbuser --dba-password dbpass --action insert/act/schemaSadly you've got 6 version updates to do from 
3.0, so they'll be something like:% rt-setup-database --datadir /etc/request-tracker3.6/upgrade/3.1.0 --dba dbuser --dba-password dbpass --action insert% rt-setup-database --datadir /etc/request-tracker3.6/upgrade/3.1.0 --dba dbuser --dba-password dbpass --action acl
% rt-setup-database --datadir /etc/request-tracker3.6/upgrade/3.1.0 --dba dbuser --dba-password dbpass --action schemafor each folder. The instructions in the INSTALL file explain it a bit better than me.
That's it :)Obviously, make sure you backup first, but you'll be doing that anyway if you're migrating to a new server.Good luck,-- Regards,Andrew Nicols
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Reports: Newbie looking for some help.

2006-09-04 Thread Andrew Nicols
On 9/3/06, Brendan S (Scratch User) [EMAIL PROTECTED] wrote:
Brendan S (Scratch User) wrote: I have found the rt shell, but when I try to (eg) list/show tickets it asks for a password and fails. I have tried the password from RTSiteConfig.pm without success.Which password is it looking for?
It's looking for your the username/password you use to log into RT rather than the RT Database Password. 
 I have tried downloading a tsv of the search results, but what I get is ?perl? code.I assume this means I need to add something to the Apache config file somewhere (? presumably adding a perl handler directive for some directory? - ?rt/Search/?)
It sounds like something isn't quite right in your apache config then. Can you use the Search Builder for example at present? If you're getting perl code, it seems like mason isn't handling the file properly. It might be a good idea to check your Apache access and error logs to see if there's anything out of the ordinary being mentioned about the 
Results.tsv file I have managed to search a custom field using the advanced query builder, but can't seem to get it to display the field in the report (the field name is displayed, but the result entry is blank - I have added it from the drop downs at the bottom of the page - the CF naming syntax appears to change).Generic question I know, but anywhere will tell me what is likely to be going wrong?
I'm not entirely sure what you mean here. Can you give a more detailed example, or perhaps paste the text from the bottom box of the Advanced tab?
It's ok, don't worry I will work it out myself.I think I've seen a few replies to the list about some of the things I've mentioned. Perhaps you should check back in case you missed them.
-- Regards,Andrew Nicols
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Does formatting a saved search have to be this *%!%! painful?

2006-09-01 Thread Andrew Nicols
On 9/1/06, Ole Craig [EMAIL PROTECTED] wrote:
Is there any way to get a new field in a search to appear in the secondcolumn of a multicolumn search OTHER THAN this cripplingly repetitiveprocess:Indeed there is... when you build the custom search, once you've added your search criterion, click on Advanced. The bottom text box is the fields which will be displayed. It takes a bit of getting used to, but if you're doing lots of searches, that's a good way of doing it,
-- Regards,Andrew Nicols
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Label owner with something other than username?

2006-09-01 Thread Andrew Nicols
On 9/1/06, Neil Hoggarth [EMAIL PROTECTED] wrote:
Is there any way that I can change the web interface to indicateownership of jobs (and populate the change ownership drop-downs, etc)using nicknames, real names or email addresses instead of (or as wellas) usernames?
Have a look at $RTROOT/html/Elements/SelectOwnerI'm not sure how the authentication affects this, but you should be able to change what's shown in the drop-down box by altering the text to suit your needs around:
 46 select name=%$Name% 47 %if ($DefaultValue) { 48 option % !$Default ? SELECTED : '' % value=%$DefaultLabel%/option
 49 %} 50 %foreach my $User ( @users) { 51 option % ($User-Id == $Default) ? SELECTED : ''% 52 %if ($ValueAttribute eq 'id') { 53 value=%$User-id%
 54 %} elsif ($ValueAttribute eq 'Name') { 55 value=%$User-Name% 56 %} 57 %$User-Name()%/option 58 %} 59 /select
Don't forget to place the file in $RTROOT/local/html/Elements instead of the normal html directory, and when you change the file, you'll need to restart apache for mason to clear it's cache and notice things have changed.
With regards to the other locations the username is displayed, it depends which you want to change, but you'll be looking in:html/Ticket/Elements/ShowUserEntry line 48html/Ticket/Elements/ShowTransaction lines 57
For an idea of what the other fields are called, have a look at the perldoc for RT::User, but as I say, I don't know how your external authentication affects things though.You may also want to change the default fields showing when you search by looking at files in the html/Search/ directory
You might also want to try experimenting with RT 3.6.1. It doesn't offer much in the way of new features, but it will be easier when it comes to upgrading to the 3.6 series for your users as they won't have to adjust to it's vastly different looks.
Hope this helps,-- Regards,Andrew Nicols
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Almost there!

2006-08-29 Thread Andrew Nicols
On 8/29/06, Ben Weston [EMAIL PROTECTED] wrote:
Here is what I have for an httpd.conf at this point Directory /opt/rt34/share/html Order allow,deny Allow from all SetHandler perl-script PerlResponseHandler RT::Mason
 /Directory/VirtualHostPossibly unrelated...I'm fairly new to Apache as well.One thing Idon't understand is:Directory /opt/rt34/share/html/opt/rt34 doesn't exist (it's /opt/rt3).However if I change it to
/opt/rt3, I get a 500 internal server error.This way I get the Almostthere page.Ben,You should be using /opt/rt3 not 34. That tells apache to use the Perl Handler RT::Mason for anything in /opt/rt3. Without it, mason isn't interpretting the HTML in /opt/rt3/ and so you get the stock nearly there message.
Look at the apache error log when you get the 500 error. That may tell you more. It could be that you don't have the database set up properly, or are missing some crucial dependencies. I think they both would give you a 500 error. There are quite a few reasons you could be getting 500 messages but your apache logs should provide some more clue,
Andrew
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Almost there... Some progress... maybe...

2006-08-29 Thread Andrew Nicols
On 8/29/06, Ben Weston [EMAIL PROTECTED] wrote:
I went into Webmin and looked at the SQL DBase (my MySQL skills are verylimited), and that database apparently has no tables in it at all.Did my DBase not initialize properly during install?I wouldn't be
surprised, since I've had to adjust settings today to make everythingsane as far as users/passwords go, and I just didn't notice it at that time.Is there anyway to fix this after the fact, short of a fresh re-install?
If you know where your binaries are and your config directory. You'll probably find the rt-setup-database in:/opt/rt3/sbin/rt-setup-database  Off the top of my noggin:sudo /opt/rt3/sbin/rt-setup-database --action init --datadir /opt/rt3/etc --dba sql_admin_username --dba-password sql_admin_password
It needs to be run as a user with access to read your config files (i.e. root/sudo)Andrew
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Almost there... Some progress... maybe...

2006-08-29 Thread Andrew Nicols
On 8/29/06, Ben Weston [EMAIL PROTECTED] wrote:
Thank you everyone for your helpI now have a login screen, and the abililty to log in (colors are screwyand the pics are broken, but I'm happy to have gotten this far).See 
http://wiki.bestpractical.com/index.cgi?ApacheConfig for advice on this one.The broken pics and missing style sheet are typically because of either:1) because mason is trying to parse /NoAuth/images2) you're missing a trailing slash somewhere in your apache config.
1) will only affect images2) will affect both images and css. Also you'll probably find you're unable to submit some forms I think. I can't quite recall thoughHave a look at your apache error log and look out for lines moaning about not being able to find htmlNoAuth instead of html/NoAuth
I'm not totally sure how it works in Apache2 because I'm using Apache 1.33 and the config is different,Andrew
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Automatically set ticket to stalled

2006-08-07 Thread Andrew Nicols
Alternately, you could write a new Action to change the status. At present there is RT::Action::SetPriority and it should be reasonably easy to create a SetStatus based upon this Action. The TicketObj-SetStatus method already exists.
RT::Action::SetPriority is in $RTROOT$/lib/RT/Action/SetPriority.pmThen you could set a cron job to run, using the rt-crontool with an argument like:bin/rt-crontool \--search RT::Search::ActiveTicketInQueue --search-arg general \
--condition RT::Condition::UntouchedInHours --condition-arg 48 \--action RT::Action::SetStatus --action-arg stalledI may be wrong, I'm fairly new to RT, but I should think that something along those lines would be more modular.
On 8/7/06, Roy El-Hames [EMAIL PROTECTED] wrote:
I'll be implementing something very similar soon and my line of thinkingwas an hourly script with:$RT::Handle-SimpleQuery(update Tickets set status = 'stalled' wherestatus ='open' and LastUpdated  (now() - interval 12 hour));
??RoyMathew Snyder wrote: has anyone written a scrip or script that will automatically set a ticket to stalled after a certain period of inactivity? Mathew Snyder ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: 
http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
 Buy a copy at http://rtbook.bestpractical.com___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-usersCommunity help: http://wiki.bestpractical.comCommercial support: 
[EMAIL PROTECTED]Discover RT's hidden secrets with RT Essentials from O'Reilly Media.Buy a copy at http://rtbook.bestpractical.com
-- Regards,Andrew Nicols
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com