[rt-users] Using the CLI (404) error
I'm running RT 3.8.7 on Fedora 13 and trying to setup running the CLI however I always get the Server error: Not Found (404) error all the time. I've been searching and reading and tried the export and .rtrc methods and neither seem to work. The URL to RT is http://fedora/rt Can someone please help me get this working? I need to use the CLI with cron to generate some scheduled tickets. Here is the .rtrc file I created in root's home directory: server http://fedora/rt user root passwd rootpw I have also tried the following values for server: http://fedora http://serverip http://serverip/rt Thanks. Brandon Patton, BS Systems Administrator ASPIRE Indiana brandon.pat...@aspireindiana.org 765-641-8283 RT Training in Washington DC, USA on Oct 25 26 2010 Last one this year -- Learn how to get the most out of RT!
[rt-users] ShowStatusInColor
http://wiki.bestpractical.com/view/ShowStatusInColor I've tried all the different methods on this page and nothing seems to be working. I must be missing something somewhere. I want to be able to change the link colors on the main page to make it more readable for the different status types (New, Open, Resolved, etc). The dark gray and black default links are hard to tell apart for some users. What's the simplest method for doing this with v 3.8.7? RT: 3.8.7 OS: Fedora 13 Brandon Patton, BS Systems Administrator ASPIRE Indiana brandon.pat...@aspireindiana.org 765-641-8283 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] ShowStatusInColor
http://wiki.bestpractical.com/view/ShowStatusInColor I've tried all the different methods on this page and nothing seems to be working. I must be missing something somewhere. I want to be able to change the link colors on the main page to make it more readable for the different status types (New, Open, Resolved, etc). The dark gray and black default links are hard to tell apart for some users. What's the simplest method for doing this with v 3.8.7? RT: 3.8.7 OS: Fedora 13 Brandon Patton, BS Systems Administrator ASPIRE Indiana brandon.pat...@aspireindiana.org 765-641-8283 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Queue Watchers
I'm running RT 3.8.7 and I've read about User Rights, Group Rights, Queue Rights, etc and cannot figure out how to allow a group of users (They belong to a group called IT) to be able to administer a queue and change watchers. I have granted the group all the queue rights allowed but cannot figure out how to get to the group to administer them. Seems the root login in the only user that can get to the queues. The other users don't have the menu links on the left. Can anyone help me with this? Thanks. Brandon Patton, BS Systems Administrator ASPIRE Indiana brandon.pat...@aspireindiana.org 765-641-8283 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Queue Watchers
Thank you! I knew there had to be something in there somewhere just so many places with rights to look. From: Raed El-Hames [mailto:raed.el-ha...@vialtus.com] Sent: Tuesday, July 06, 2010 11:34 AM To: Patton, Brandon; rt-users@lists.bestpractical.com Subject: RE: Queue Watchers Start by giving the group IT the ShowConfigTab right, you can do that from Configuration - Global-Group Rights Roy From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Patton, Brandon Sent: 06 July 2010 16:24 To: rt-users@lists.bestpractical.com Subject: [rt-users] Queue Watchers I'm running RT 3.8.7 and I've read about User Rights, Group Rights, Queue Rights, etc and cannot figure out how to allow a group of users (They belong to a group called IT) to be able to administer a queue and change watchers. I have granted the group all the queue rights allowed but cannot figure out how to get to the group to administer them. Seems the root login in the only user that can get to the queues. The other users don't have the menu links on the left. Can anyone help me with this? Thanks. Brandon Patton, BS Systems Administrator ASPIRE Indiana brandon.pat...@aspireindiana.org 765-641-8283 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] webmux.pl error - Apache won't start
Found another error in the apache2 logfile showing this error when trying to start apache2. Can't locate object method Config via package RT at /opt/rt3/bin/webmux.pl line 136. Compilation failed in require at (eval 242) line 1. This is the other error I have: Can't load Perl file: /opt/rt3/bin/webmux.pl Can someone please help me? I really need to get this up and running. More details can be found below from previous emails. Thanks! -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Patton, Brandon Sent: Tuesday, June 29, 2010 2:50 PM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Upgrading from RT 3.6.5 Ok, I'm getting closer and closer to getting this to work but having a problem with the Apache setup. I have created the config for Apache as shown by numerous examples but no matter which example I follow, I get the following error trying to start Apache: Can't load Perl file: /opt/rt3/bin/webmux.pl If I uncomment the PerlRequire line apache will start and I get the website with the Your Almost There! message. Here is the config info I'm using for Apache VirtualHost * ServerName nethealth DocumentRoot /opt/rt3/share/html AddDefaultCharset UTF-8 PerlModule Apache2 Apache::compat PerlModule Apache::DBI PerlRequire /opt/rt3/bin/webmux.pl ErrorLog /opt/rt3/var/log/apache2.error Location / SetHandler perl-script PerlHandler RT::Mason /Location /VirtualHost OS: Ubuntu 8.04.0 MySQL 5.0.51 PostFix Mail 2.54 Apache 2.28 Request Tacker: 3.8.8 -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Patton, Brandon Sent: Tuesday, June 29, 2010 10:43 AM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Upgrading from RT 3.6.5 I'm in the process of trying to upgrade now and I've gotten to the part of updating the database and I get the following error. Can anyone help me? r...@nethealth:/opt/rt3/sbin# ./rt-setup-database --dba root --prompt-for-dba-password --action upgrade In order to create or update your RT database, this script needs to connect to your mysql instance on localhost as root Please specify that user's database password below. If the user has no database password, just press return. Password: Working with: Type: mysql Host: localhost Name: rtdb User: rtuser DBA:root Couldn't finish 'upgrade' step. ERROR: Couldn't read dir './etc/upgrade' with upgrade data The upgrade directory is there, not sure why it can't read it. Of course, I'm not an expert on permissions either. r...@nethealth:/opt/rt3/etc# ls -l total 196 -r 1 root www 90 2010-06-28 15:53 acl.Informix -r 1 root www 859 2010-06-28 15:53 acl.mysql -r 1 root www 27 2010-06-28 15:53 acl.Oracle -r 1 root www1912 2010-06-28 15:53 acl.Pg -r 1 root www 232 2010-06-28 15:53 acl.Sybase -r 1 root www 22776 2010-06-28 15:53 initialdata -r--r- 1 root www 46335 2010-06-28 15:53 RT_Config.pm -rw-r- 1 root www1027 2010-06-28 16:11 RT_SiteConfig.pm -r 1 root www 10518 2010-06-28 15:53 schema.Informix -r 1 root www 13236 2010-06-28 15:53 schema.mysql-4.0 -r 1 root www 14164 2010-06-28 15:53 schema.mysql-4.1 -r 1 root www 11776 2010-06-28 15:53 schema.Oracle -r 1 root www 13904 2010-06-28 15:53 schema.Pg -r 1 root www 10769 2010-06-28 15:53 schema.SQLite -r 1 root www 11550 2010-06-28 15:53 schema.Sybase drwxr-xr-x 25 administrator administrator 4096 2010-06-28 15:52 upgrade -Original Message- From: Jerrad Pierce [mailto:jpie...@cambridgeenergyalliance.org] Sent: Friday, June 25, 2010 2:14 PM To: Patton, Brandon Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Upgrading from RT 3.6.5 Ungh, Ubuntu as a server. Leaving that aside, simply use the package manager (something like Synaptic in the GUI) to check where the files for the rt package are installed. Back those up if you have concerns about possible customizations done to core instead of local code. Backup your database. Then: A) Update your system to something more modern, and install the corresponding rt package B) Download the source tarball from Best Practical, and follow the enclosed directions P.S. /opt/rt3 is the default path, for some reason several distributions like Ubuntu like to shove stuff under /usr/local/packageName and give users longer pathnames to deal with. Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] webmux.pl error - Apache won't start
Yes, it said all dependencies were found. r...@nethealth:~/rt-3.8.8# make testdeps /usr/bin/perl ./sbin/rt-test-dependencies --verbose --with-mysql --with-fastcgi perl: =5.8.3(5.8.8) ...found users: rt group (www) ...found bin owner (root) ...found libs owner (root) ...found libs group (bin) ...found web owner (www) ...found web group (www) ...found CLI dependencies: Term::ReadKey ...found Getopt::Long = 2.24 ...found HTTP::Request::Common ...found Term::ReadLine ...found Text::ParseWords ...found LWP ...found CORE dependencies: Class::ReturnValue = 0.40 ...found Text::Quoted = 2.02 ...found CSS::Squish = 0.06 ...found Encode = 2.21 ...found Module::Versions::Report = 1.05 ...found MIME::Entity = 5.425 ...found DBI = 1.37 ...found Locale::Maketext::Lexicon = 0.32 ...found Devel::StackTrace = 1.19 ...found Digest::base ...found Time::ParseDate ...found File::Temp = 0.18 ...found Locale::Maketext = 1.06 ...found Tree::Simple = 1.04 ...found Text::Template = 1.44 ...found Scalar::Util ...found HTML::Scrubber = 0.08 ...found File::Spec = 0.8 ...found Calendar::Simple ...found DBIx::SearchBuilder = 1.54 ...found Sys::Syslog = 0.16 ...found Mail::Mailer = 1.57 ...found File::ShareDir ...found Regexp::Common ...found Digest::MD5 = 2.27 ...found HTML::Entities ...found Cache::Simple::TimedExpiry ...found File::Glob ...found Locale::Maketext::Fuzzy ...found Time::HiRes ...found Text::Wrapper ...found Log::Dispatch = 2.0 ...found UNIVERSAL::require ...found Email::Address ...found DASHBOARDS dependencies: HTML::RewriteAttributes = 0.02 ...found MIME::Types ...found FASTCGI dependencies: CGI::Fast ...found CGI = 3.38 ...found FCGI ...found GD dependencies: GD::Text ...found GD ...found GD::Graph ...found GPG dependencies: PerlIO::eol ...found GnuPG::Interface ...found ICAL dependencies: Data::ICal ...found MAILGATE dependencies: Pod::Usage ...found HTML::TreeBuilder ...found Getopt::Long ...found HTML::FormatText ...found LWP::UserAgent ...found MASON dependencies: Storable = 2.08 ...found CSS::Squish = 0.06 ...found Apache::Session = 1.53 ...found Errno ...found Devel::StackTrace = 1.19 ...found CGI::Cookie = 1.20 ...found Text::WikiFormat = 0.76 ...found XML::RSS = 1.05 ...found HTML::Mason = 1.36 ...found Digest::MD5 = 2.27 ...found MYSQL dependencies: DBD::mysql = 2.1018 ...found SMTP dependencies: Net::SMTP ...found STANDALONE dependencies: Net::Server ...found HTTP::Server::Simple = 0.34 ...found HTTP::Server::Simple::Mason = 0.09 ...found All dependencies have been found. -Original Message- From: Joop van de Wege [mailto:joopvandew...@mococo.nl] Sent: Wednesday, June 30, 2010 10:27 AM To: Patton, Brandon Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] webmux.pl error - Apache won't start Patton, Brandon wrote: Found another error in the apache2 logfile showing this error when trying to start apache2. Can't locate object method Config via package RT at /opt/rt3/bin/webmux.pl line 136. Compilation failed in require at (eval 242) line 1. This is the other error I have: Can't load Perl file: /opt/rt3/bin/webmux.pl Did you run 'make testdeps' ?? Might be that rt-3.8.8 needs newer versions of installed modules or even need new modules that currently not installed. Regards, Joop Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] webmux.pl error - Apache won't start
Still no go, because your config also has reference to PerlRequire /opt/rt3/bin/webmux.pl If I comment this line out, Apache will start but then when you browse the site you get the webpage that says You're Almost There!. How can I tell if I have the latest Apache::DBI installed? Like I mentioned earlier, I'm a linux novice and inherited this machine after a co-worker left. -Original Message- From: Joop van de Wege [mailto:joopvandew...@mococo.nl] Sent: Wednesday, June 30, 2010 10:49 AM To: Patton, Brandon Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] webmux.pl error - Apache won't start Patton, Brandon wrote: Found another error in the apache2 logfile showing this error when trying to start apache2. Can't locate object method Config via package RT at /opt/rt3/bin/webmux.pl line 136. Compilation failed in require at (eval 242) line 1. This is the other error I have: Can't load Perl file: /opt/rt3/bin/webmux.pl Can someone please help me? I really need to get this up and running. More details can be found below from previous emails. Thanks! -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Patton, Brandon Sent: Tuesday, June 29, 2010 2:50 PM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Upgrading from RT 3.6.5 Ok, I'm getting closer and closer to getting this to work but having a problem with the Apache setup. I have created the config for Apache as shown by numerous examples but no matter which example I follow, I get the following error trying to start Apache: Can't load Perl file: /opt/rt3/bin/webmux.pl If I uncomment the PerlRequire line apache will start and I get the website with the Your Almost There! message. Here is the config info I'm using for Apache VirtualHost * ServerName nethealth DocumentRoot /opt/rt3/share/html AddDefaultCharset UTF-8 PerlModule Apache2 Apache::compat PerlModule Apache::DBI PerlRequire /opt/rt3/bin/webmux.pl ErrorLog /opt/rt3/var/log/apache2.error Location / SetHandler perl-script PerlHandler RT::Mason /Location /VirtualHost This is my RT config vhost VirtualHost * ServerName rt3.server.nl DocumentRoot /opt/rt3/share/html PerlModule Apache::DBI PerlRequire /opt/rt3/bin/webmux.pl Alias /rt3 /opt/rt3/share/html Location /NoAuth/images SetHandler default /Location Location /rt3/ SetHandler perl-script PerlHandler RT::Mason /Location ErrorLog /var/log/httpd/rt_error.log # Possible values include: debug, info, notice, warn, error, crit, # alert, emerg. LogLevel info ServerSignature On /VirtualHost This one is simpler might help since it doesn't include the problem module. Further do you have the latest of Apache::DBI installed? If my memory is correct I had problems that make testdeps didn't detect if I had it installed. Had to do that by hand. Regards, Joop Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Upgrading from RT 3.6.5
I'm in the process of trying to upgrade now and I've gotten to the part of updating the database and I get the following error. Can anyone help me? r...@nethealth:/opt/rt3/sbin# ./rt-setup-database --dba root --prompt-for-dba-password --action upgrade In order to create or update your RT database, this script needs to connect to your mysql instance on localhost as root Please specify that user's database password below. If the user has no database password, just press return. Password: Working with: Type: mysql Host: localhost Name: rtdb User: rtuser DBA:root Couldn't finish 'upgrade' step. ERROR: Couldn't read dir './etc/upgrade' with upgrade data The upgrade directory is there, not sure why it can't read it. Of course, I'm not an expert on permissions either. r...@nethealth:/opt/rt3/etc# ls -l total 196 -r 1 root www 90 2010-06-28 15:53 acl.Informix -r 1 root www 859 2010-06-28 15:53 acl.mysql -r 1 root www 27 2010-06-28 15:53 acl.Oracle -r 1 root www1912 2010-06-28 15:53 acl.Pg -r 1 root www 232 2010-06-28 15:53 acl.Sybase -r 1 root www 22776 2010-06-28 15:53 initialdata -r--r- 1 root www 46335 2010-06-28 15:53 RT_Config.pm -rw-r- 1 root www1027 2010-06-28 16:11 RT_SiteConfig.pm -r 1 root www 10518 2010-06-28 15:53 schema.Informix -r 1 root www 13236 2010-06-28 15:53 schema.mysql-4.0 -r 1 root www 14164 2010-06-28 15:53 schema.mysql-4.1 -r 1 root www 11776 2010-06-28 15:53 schema.Oracle -r 1 root www 13904 2010-06-28 15:53 schema.Pg -r 1 root www 10769 2010-06-28 15:53 schema.SQLite -r 1 root www 11550 2010-06-28 15:53 schema.Sybase drwxr-xr-x 25 administrator administrator 4096 2010-06-28 15:52 upgrade -Original Message- From: Jerrad Pierce [mailto:jpie...@cambridgeenergyalliance.org] Sent: Friday, June 25, 2010 2:14 PM To: Patton, Brandon Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Upgrading from RT 3.6.5 Ungh, Ubuntu as a server. Leaving that aside, simply use the package manager (something like Synaptic in the GUI) to check where the files for the rt package are installed. Back those up if you have concerns about possible customizations done to core instead of local code. Backup your database. Then: A) Update your system to something more modern, and install the corresponding rt package B) Download the source tarball from Best Practical, and follow the enclosed directions P.S. /opt/rt3 is the default path, for some reason several distributions like Ubuntu like to shove stuff under /usr/local/packageName and give users longer pathnames to deal with. Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Upgrading from RT 3.6.5
Ok, I'm getting closer and closer to getting this to work but having a problem with the Apache setup. I have created the config for Apache as shown by numerous examples but no matter which example I follow, I get the following error trying to start Apache: Can't load Perl file: /opt/rt3/bin/webmux.pl If I uncomment the PerlRequire line apache will start and I get the website with the Your Almost There! message. Here is the config info I'm using for Apache VirtualHost * ServerName nethealth DocumentRoot /opt/rt3/share/html AddDefaultCharset UTF-8 PerlModule Apache2 Apache::compat PerlModule Apache::DBI PerlRequire /opt/rt3/bin/webmux.pl ErrorLog /opt/rt3/var/log/apache2.error Location / SetHandler perl-script PerlHandler RT::Mason /Location /VirtualHost OS: Ubuntu 8.04.0 MySQL 5.0.51 PostFix Mail 2.54 Apache 2.28 Request Tacker: 3.8.8 -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Patton, Brandon Sent: Tuesday, June 29, 2010 10:43 AM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Upgrading from RT 3.6.5 I'm in the process of trying to upgrade now and I've gotten to the part of updating the database and I get the following error. Can anyone help me? r...@nethealth:/opt/rt3/sbin# ./rt-setup-database --dba root --prompt-for-dba-password --action upgrade In order to create or update your RT database, this script needs to connect to your mysql instance on localhost as root Please specify that user's database password below. If the user has no database password, just press return. Password: Working with: Type: mysql Host: localhost Name: rtdb User: rtuser DBA:root Couldn't finish 'upgrade' step. ERROR: Couldn't read dir './etc/upgrade' with upgrade data The upgrade directory is there, not sure why it can't read it. Of course, I'm not an expert on permissions either. r...@nethealth:/opt/rt3/etc# ls -l total 196 -r 1 root www 90 2010-06-28 15:53 acl.Informix -r 1 root www 859 2010-06-28 15:53 acl.mysql -r 1 root www 27 2010-06-28 15:53 acl.Oracle -r 1 root www1912 2010-06-28 15:53 acl.Pg -r 1 root www 232 2010-06-28 15:53 acl.Sybase -r 1 root www 22776 2010-06-28 15:53 initialdata -r--r- 1 root www 46335 2010-06-28 15:53 RT_Config.pm -rw-r- 1 root www1027 2010-06-28 16:11 RT_SiteConfig.pm -r 1 root www 10518 2010-06-28 15:53 schema.Informix -r 1 root www 13236 2010-06-28 15:53 schema.mysql-4.0 -r 1 root www 14164 2010-06-28 15:53 schema.mysql-4.1 -r 1 root www 11776 2010-06-28 15:53 schema.Oracle -r 1 root www 13904 2010-06-28 15:53 schema.Pg -r 1 root www 10769 2010-06-28 15:53 schema.SQLite -r 1 root www 11550 2010-06-28 15:53 schema.Sybase drwxr-xr-x 25 administrator administrator 4096 2010-06-28 15:52 upgrade -Original Message- From: Jerrad Pierce [mailto:jpie...@cambridgeenergyalliance.org] Sent: Friday, June 25, 2010 2:14 PM To: Patton, Brandon Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Upgrading from RT 3.6.5 Ungh, Ubuntu as a server. Leaving that aside, simply use the package manager (something like Synaptic in the GUI) to check where the files for the rt package are installed. Back those up if you have concerns about possible customizations done to core instead of local code. Backup your database. Then: A) Update your system to something more modern, and install the corresponding rt package B) Download the source tarball from Best Practical, and follow the enclosed directions P.S. /opt/rt3 is the default path, for some reason several distributions like Ubuntu like to shove stuff under /usr/local/packageName and give users longer pathnames to deal with. Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Upgrading from RT 3.6.5
Hello, I'm a fairly new Request Tracker user and a novice in the Linux world, but I've inherited this system after a co-worker left. We are in the process of getting more departments to use this product and I want to get it upgraded before we move forward. I have read a lot of the documentation on the Wiki but I'm still not 100% confident on what I'm doing. First, I want to have some type of backup of the current system in case I screw something up. Most of the documentation I see refers to /opt/rt3 but this does not exist on my system. Can someone point me in the right direction of backup up the current system and then upgrading to the newest? Below is the information that I have been able to collect about the system: OS: Ubuntu 8.04.0 MySQL 5.0.51 PostFix Mail 2.54 Apache 2.28 Request Racker: 3.6.5 Thanks. Brandon Patton, BS Systems Administrator ASPIRE Indiana brandon.pat...@aspireindiana.org 765-641-8283 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com