Re: [rt-users] automaticaly set a reminder of 2, 5h to every new ticket in queue xxx
maybe this helps you guys helping me!
My Cronjob:
/ 5 * * * * /usr/bin/rt-crontool%
--search RT::Search::FromSQL
--search-arg 'Type = reminder and (Status = open or
Status = new)'
--condition RT::Condition::BeforeDue
--condition-arg 71h
--action RT::Action::SendEmail
--action-arg Owner
--transaction first
--template '150minremind'/
My Template (with the name 150 min remind)
/ To: { $Target = $Ticket-RefersTo-First-TargetObj; ($Argument eq
'TicketOwner' ? $Target : $Ticket)-OwnerObj-EmailAddress }
Subject: {$Ticket-Subject} is due {$Ticket-DueAsString}
Just a friendly heads up. This reminder is for ticket #{$Target-Id}.
{RT-Config-Get('WebURL')}Ticket/Display.html?id={$Target-Id}/
--
View this message in context:
http://requesttracker.8502.n7.nabble.com/automaticaly-set-a-reminder-of-2-5h-to-every-new-ticket-in-queue-xxx-tp52830p52883.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.
--
RT training in Amsterdam, March 20-21:
http://bestpractical.com/services/training.html
Help improve RT by taking our user survey:
https://www.surveymonkey.com/s/N23JW9T
Re: [rt-users] automaticaly set a reminder of 2, 5h to every new ticket in queue xxx
hello kevin, first of all thanks for your information. but unfortunately the documentation didn't help me reaching my goal. maybe i should mention that i'm super new to this. i just dont seem to get the syntax! i dont really think my request is that complicated (well fo me it is :D) i just want to set an automatic reminder directly after the ticket is created (with incoming mail to queue ) WITH e-mail notification to ALL users, regardless if they own the ticket or dont own them (there are just 2 users) for every new and open ticket (well to all tickets as long as they are not resolved). and there should be a notification sent to those users every 2,5h until the ticket is resolved. btw, outgoing mail when someone is stealing the ticket or status changes already works. so i guess its not a mail-setting problem... its just a problem that i'm a pretty useless regarding programming. thanks for your support and your patience with my mickey-mouse request. -- View this message in context: http://requesttracker.8502.n7.nabble.com/automaticaly-set-a-reminder-of-2-5h-to-every-new-ticket-in-queue-xxx-tp52830p52855.html Sent from the Request Tracker - User mailing list archive at Nabble.com. -- RT training in Amsterdam, March 20-21: http://bestpractical.com/services/training.html Help improve RT by taking our user survey: https://www.surveymonkey.com/s/N23JW9T
[rt-users] automaticaly set a reminder of 2, 5h to every new ticket in queue xxx
Hi, i've already read through the wiki and already tried my luck with google but i couldnt manage to find a solution to my problem. i'd like to set automatically a reminder to every incoming ticket whichs gives me mail notification every 2,5 hours until the ticket is done. (resolved) im using rt 4.0.7 on debian 6. it'll also be great if the two admins get the mail notification even if the incoming ticket is still unowned. the 2,5 hours should start right when the ticket is created, and if the first reminder is sent then there should start another countdown to 2,5h until the ticket is done. thanks in advance! -- View this message in context: http://requesttracker.8502.n7.nabble.com/automaticaly-set-a-reminder-of-2-5h-to-every-new-ticket-in-queue-xxx-tp52830.html Sent from the Request Tracker - User mailing list archive at Nabble.com. -- RT training in Amsterdam, March 20-21: http://bestpractical.com/services/training.html Help improve RT by taking our user survey: https://www.surveymonkey.com/s/N23JW9T
Re: [rt-users] problems with install
I have gotton the make initialize-databse to work and have the
web-interface setup and is working but I cannot login. It tells me uknown
user or password. I have tries root,and rt_user. looked in mysql database
and see the user root under the users table not sure if I'm doing
something wrong.
Thanks
--
Bo
On Tue, July 8, 2008 11:35 am, J.P. Racine wrote:
Bo, you need to edit the etc/RT_SiteConfig.pm file to include the
database connection info ( as well as other critical config info ).
Set($DatabaseName , 'rt3');
Set($DatabaseType , 'mysql');
Set($DatabaseUser, root);
Set($DatabasePassword , 'yourpassword');
Have another look at the install doc - the RT_SiteConfig configuration
step comes before initializing the db.
Bo Lynch wrote:
Trying to install RT 3.6.7 on CentOS,MYSQL box. When trying to run the
make initialize-database I get
DBI connect(';host=localhost','root',...) failed: Access denied for user
'root'@'localhost' (using password: YES) at
//opt/rt3/sbin/rt-setup-database line 105
Failed to connect to dbi:mysql:;host=localhost as root: Access denied
for
user 'root'@'localhost' (using password: YES) at
//opt/rt3/sbin/rt-setup-database line 105, STDIN line 1.
make: *** [initialize-database] Error 255
I am able to login to mysql as root with the password that I supplied
with
make. Could someone point me in the right direction.
Thanks
___
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] problems with install
Trying to install RT 3.6.7 on CentOS,MYSQL box. When trying to run the
make initialize-database I get
DBI connect(';host=localhost','root',...) failed: Access denied for user
'root'@'localhost' (using password: YES) at
//opt/rt3/sbin/rt-setup-database line 105
Failed to connect to dbi:mysql:;host=localhost as root: Access denied for
user 'root'@'localhost' (using password: YES) at
//opt/rt3/sbin/rt-setup-database line 105, STDIN line 1.
make: *** [initialize-database] Error 255
I am able to login to mysql as root with the password that I supplied with
make. Could someone point me in the right direction.
Thanks
--
Bo
___
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] problems with install
OK i got that to work and installed RT and initialized the databse with no
problems. But when I restart httpd it fails. In the error_log i get
Tue Jul 08 13:03:31 2008] [error] \nRT couldn't load RT config file
/etc/rt3/RT_SiteConfig.pm as:\nuser: root \ngroup: root\n\nThe
file is owned by user root and group root. \n\nThis usually means that
the user/group your webserver is running\nas cannot read the file. Be
careful not to make the permissions\non this file too liberal, because it
contains database passwords.\nYou may need to put the webserver user in
the appropriate group\n(root) or change permissions be able to run
succesfully.\n\nUnrecognized character \\xE2 at /etc/rt3/RT_SiteConfig.pm
line 32.\nCompilation failed in require at
/usr/lib/perl5/vendor_perl/5.8.8/RT.pm line 152.\nBEGIN
failed--compilation aborted at /usr/sbin/webmux.pl line 78.\nCompilation
failed in require at (eval 2) line 1.\n
[Tue Jul 08 13:03:31 2008] [error] Can't load Perl file:
/usr/sbin/webmux.pl for server 127.0.0.1:0, exiting...
In my httpd conf file apache is the user that my webserver is running. The
/usr/sbin/webmux.pl file exists and has permissions of 755 root.root.
On Tue, July 8, 2008 11:35 am, J.P. Racine wrote:
Bo, you need to edit the etc/RT_SiteConfig.pm file to include the
database connection info ( as well as other critical config info ).
Set($DatabaseName , 'rt3');
Set($DatabaseType , 'mysql');
Set($DatabaseUser, root);
Set($DatabasePassword , 'yourpassword');
Have another look at the install doc - the RT_SiteConfig configuration
step comes before initializing the db.
Bo Lynch wrote:
Trying to install RT 3.6.7 on CentOS,MYSQL box. When trying to run the
make initialize-database I get
DBI connect(';host=localhost','root',...) failed: Access denied for user
'root'@'localhost' (using password: YES) at
//opt/rt3/sbin/rt-setup-database line 105
Failed to connect to dbi:mysql:;host=localhost as root: Access denied
for
user 'root'@'localhost' (using password: YES) at
//opt/rt3/sbin/rt-setup-database line 105, STDIN line 1.
make: *** [initialize-database] Error 255
I am able to login to mysql as root with the password that I supplied
with
make. Could someone point me in the right direction.
Thanks
___
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] Migration from another ticket system
We currently use an open source solution called IRM for our ticket system. It uses a mysql database. Does anyone have any knowledge of migrating from IRM to RT. Any info would be greatly appreciated. Thanks -- Bo Lynch ___ 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] Question about migration
On Wed, July 2, 2008 4:06 pm, Chaim Rieger wrote: Bo Lynch wrote: We currently use an open source solution called IRM for our ticket system. It uses a mysql database. Does anyone have any knowledge of migrating from IRM to RT. Any info would be greatly appreciated. Thanks are you using IRM for tickets onnly or alsoe for asset mgmt ? --Chaim Rieger We use IRM for tickets only. Bo ___ 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
