[rt-users] Almost there with Approvals
Today I present the TimeOff approval stuff to the HR department. Things when well (thank you again RT developers and to the user list). The did have one request that I can not seem to figure out (I really need to get a perl book or two :-) ) Currently, my OnApproval sprip looks like this (I think it is the same as the default, but I have made so many changes I am not sure now): # OnApproval scrip # return(0) unless ($self-TicketObj-Type eq 'approval'); my $note; my $t = $self-TicketObj-Transactions; while (my $o = $t-Next) { $note .= $o-Content . \n if $o-ContentObj and $o-Content !~ /Default Approval/; } foreach my $obj ($self-TicketObj-AllDependedOnBy( Type = 'ticket' )) { $obj-Comment( Content = $self-loc( Your request has been approved by [_1]. Other approvals may still be pending., # loc $self-TransactionObj-CreatorObj-Name, ) . \n . $self-loc( Approver's notes: , # loc $note ), ); # so we can access it inside templates $T::Approval = $self-TicketObj; # we want the original id in the token line $self-{TicketObj} = $obj; } # Now magically turn myself into a Requestor Notify object... require RT::Action::Notify; bless($self, 'RT::Action::Notify'); $self-{Argument} = 'Requestor'; $self-Prepare; return 1; #---# The resulting comment in the original ticket shows up like: #---# Tue Jun 05 11:58:16 2007 RT_System - Comments added [Reply] [Comment] Your request has been approved by scizmarik. Other approvals may still be pending. Approver's notes: Tue Jun 05 11:53:09 2007: Request 2131 was acted upon. Transaction: Ticket created by RT_System Queue: TimeOff-Approval Subject: Approval of Mike is a Dork Owner: Nobody Requestors: Status: new Ticket URL: http://gentgeen.homelinux.org:5556/rt/Ticket/Display.html?id=2131 Woo Hoo...it's approved by HR URL: http://gentgeen.homelinux.org:5556/rt/Ticket/Display.html?id=2131 Woo Hoo...it's approved by HR #---# The would like to remove everything from Approver's notes: down to (at least) the first Woo Hoo... it's approved by HR. The Link can go, or stay either way. (i.e. really only the last line is needed.) problem is, I can not figure out what part of the scrip is causing that to be put in. Any help would be appreciated (again) Thanks, Kevin -- http://gentgeen.homelinux.org # Associate yourself with men of good quality if you esteem your own reputation; for 'tis better to be alone then in bad company.- George Washington, Rules of Civility ___ 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] Almost there!
I've used RT Extensively, but this is my first attempt at doing an install of it. I'm running Fedora Core 5 and Apache2. I've been stuck at this point for a week or two. Now that I'm back working on the RT project, I figured it's time I ask for some help. I've gone through the wiki docs, as well as the mailing list archive, but it's still not working (it's gotten me this far though)... I get the ubiquitous Almost there page. Here is what I have for an httpd.conf at this point. # Begin RT Host VirtualHost 192.168.51.48:80 ServerName 192.168.51.48 ServerAdmin [EMAIL PROTECTED] DocumentRoot /opt/rt3/share/html PerlRequire /opt/rt3/bin/webmux.pl Directory /opt/rt34/share/html Order allow,deny Allow from all SetHandler perl-script PerlResponseHandler RT::Mason /Directory /VirtualHost Possibly unrelated... I'm fairly new to Apache as well. One thing I don'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 Almost there page. Help, input, advice, direction? Thanks, Ben ___ 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!
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!
I get this when it is trying to log to file but I haven't touched the file yet. Check that? Andrew Nicols wrote: On 8/29/06, *Ben Weston* [EMAIL PROTECTED] mailto:[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 /VirtualHost Possibly unrelated... I'm fairly new to Apache as well. One thing I don'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 Almost there 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 -- Drew Barnes Applications Analyst Raymond Walters College University of Cincinnati ___ 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] Almost there... Some progress... maybe...
Several people have sent me emails directly have have been quite helpful. I appolgize if I haven't replied personally. The advice I've gotten has certainly made some progress Though I'm still looking at the same page as a result. Please bare with me while I paste in cfg's and error messages. --- httpd.conf # Begin RT Host VirtualHost 192.168.51.48:80 ServerName 192.168.51.48 ServerAdmin [EMAIL PROTECTED] DocumentRoot /opt/rt3/share/html PerlRequire /opt/rt3/bin/webmux.pl Directory /opt/rt34/share/html Order allow,deny Allow from all SetHandler perl-script PerlResponseHandler RT::Mason /Directory /VirtualHost RT_Siteconfig: (NOTE: server is currently setup only for internal use, no DNS A or CNAME) Set($rtname , rt.computerhelpme.com); Set($Organization , computerhelpme.com); Set($DatabaseType , 'mysql'); Set($DatabaseHost , ''); Set($DatabaseRTHost , ''); Set($DatabasePort , ''); Set($DatabaseUser , 'rt'); Set($DatabasePassword , 'nottelling'); Set($DatabaseName , 'rt3'); --- Here's what I had/have/have done: From /var/log/httpd/error_log earlier today: DBI connect('dbname=rt3;host=localhost','rt_user',...) failed: Access denied for user 'rt_user'@'localhost' (using password: YES) at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 108 [Tue Aug 29 10:05:59 2006] [error] [client 192.168.51.72] Connect Failed Access denied for user 'rt_user'@'localhost' (using password: YES)\n at /opt/rt3/lib/RT.pm line 176\n Reset my password for the rt user, and made sure all the RT config settings were sane (a couple of them were originally incorrect), I'm no longer getting those errors... From /var/log/httpd/error_log, now: [Tue Aug 29 13:01:54 2006] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec) [Tue Aug 29 13:01:57 2006] [notice] Digest: generating secret for digest authentication ... [Tue Aug 29 13:01:57 2006] [notice] Digest: done [Tue Aug 29 13:01:57 2006] [notice] FastCGI: process manager initialized (pid 13358) [Tue Aug 29 13:01:57 2006] [notice] mod_python: Creating 4 session mutexes based on 256 max processes and 0 max threads. [Tue Aug 29 13:01:57 2006] [notice] Apache/2 configured -- resuming normal operations Everything looks Ok to me here (please correct me if I'm wrong). I went and made sure that the rt user for mysql had full access to the rt3 database. Not sure if there is anything else that would be helpful in troubleshooting this... I'm thinking it's a DBase permission issue, but I'm no longer gettig any errors regarding that... Suggestions? Other logfiles I should be looking at? Thanks again, Ben ___ 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...
Ben - If this is a cut/paste, looks like there's still a tyop [sic] in your httpd.conf -- you're specifying /opt/rt3/ everywhere except the Directory container where the handlers are defined. That directory container is for /opt/rt34/share/html, rather than /opt/rt3/share/html. Or was this a cosmetic error introduced while emailing No, that was a typo in my config I thought I'd fixed this morning, but apparently hadn't Originally, when I went with /opt/rt3 instead of rt34, it would just bomb out with a 500 error... This time I'm getting: *error:*RT couldn't store your session. This may mean that that the directory '/opt/rt3/var/session_data' isn't writable or a database table is missing or corrupt. *context:* *...* *86:* }; *87:* undef $cookies{$cookiename}; *88:* } *89:* else { *90:* die loc(RT couldn't store your session.) . \n *91:* . loc( *92:* This may mean that that the directory '[_1]' isn't writable or a database table is missing or corrupt., *93:* $RT::MasonSessionDir *94:* ) *...* *code stack:* /opt/rt3/share/html/Elements/SetupSessionCookie:90 /opt/rt3/share/html/autohandler:73 Raw Error: RT couldn't store your session. This may mean that that the directory '/opt/rt3/var/session_data' isn't writable or a database table is missing or corrupt. Trace begun at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Exceptions.pm line 129 HTML::Mason::Exceptions::rethrow_exception('RT couldn\'t store your session.^JThis may mean that that the directory \'/opt/rt3/var/session_data\' isn\'t writable or a database table is missing or corrupt.^J^J') called at /opt/rt3/share/html/Elements/SetupSessionCookie line 90 HTML::Mason::Commands::__ANON__ at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xbbb4058)') called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1256 eval {...} at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1250 HTML::Mason::Request::comp(undef, undef) called at /opt/rt3/share/html/autohandler line 73 HTML::Mason::Commands::__ANON__ at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xbba7188)') called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1251 eval {...} at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1250 HTML::Mason::Request::comp(undef, undef, undef) called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 460 eval {...} at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 460 eval {...} at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 412 HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0xbb25344)') called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm line 168 HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0xbb25344)') called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm line 826 HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0xad0c3ac)', 'Apache2::RequestRec=SCALAR(0xafa5d30)') called at /opt/rt3/bin/webmux.pl line 123 eval {...} at /opt/rt3/bin/webmux.pl line 123 RT::Mason::handler('Apache2::RequestRec=SCALAR(0xafa5d30)') called at /usr/lib/perl5/site_perl/5.8.8/Apache/Session/MySQL.pm line 0 eval {...} at /usr/lib/perl5/site_perl/5.8.8/Apache/Session/MySQL.pm line 0 -- /opt/rt3/var/session_data is RWX for owner and group, none for Other Database issue perhaps??? ___ 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...
I went into Webmin and looked at the SQL DBase (my MySQL skills are very limited), 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 everything sane 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? ___ 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...
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...
On 8/29/06, Ben Weston [EMAIL PROTECTED] wrote: I went into Webmin and looked at the SQL DBase (my MySQL skills are very limited), 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 everything sane 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 still have the install directory around, you can just do make initialize-database Michael -- Michael S. Liebman [EMAIL PROTECTED] http://msl521.freeshell.org/ I have vision and the rest of the world wears bifocals. -Paul Newman in Butch Cassidy the Sundance Kid ___ 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...
Thank you everyone for your help I now have a login screen, and the abililty to log in (colors are screwy and the pics are broken, but I'm happy to have gotten this far). You'll probably hear from me again as I try to finalize and tweak things, but you've proven the most helpful mailing-list group I have found in a long time. Thanks a bunch, Ben ___ 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...
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