Re: [rt-users] How to run Queue-Bound scrips instead of the global version?
You can either modify the condition of the auto-reply global scrip to check the queue value if its equal to the queue you don't want to run on then return undef, or the better solution is to implement Dirk Pape extension which hide/suppress global scrips: http://page.mi.fu-berlin.de/~pape/rt3screenshots/ Roy Luis Motta Campos wrote: Dear rt-users: I'm using RT's default scrips, with a few modifications, as my base. I have currently 18 active queues. I need to change auto-reply scrips for a queue, and don't want to re-define all scrips for all queues (so they aren't globlas anymore) just for this. My question: is there anything I can do to setup and run custom queue-bound scrips in a way that they run instead of the global scrip for the same action? Thanks a lot for any tips. Kind regards. ___ 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] Reports: Newbie looking for some help.
Hi I have just installed (yesterday) rt (3.6.1) on opensuse 10.1 - and added a couple of pages on the experience to the wiki: http://wiki.bestpractical.com/index.cgi?OpenSuSE101InstallGuide This is the first time I have ever installed/used: Apache, Mysql, perl, cpan (and of course rt) - so my apologies if this is all a bit mundane. I have searched the last 6 months or so of the mailing lists but have not found anything on point. I would like to produce reports which show (among other things) the detail of the issue which initiated ticket, and the most recent comment added to the ticket. Can someone point to somewhere which explains how to do this? Happy, subject to the next question, to do this through the CLI or through query builder. 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? 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/?) 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? Thanks in advance Brendan ___ 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] Centos 4.3, rt no joy. (DBD::Oracle ?)
Attempted to install 3.6.0 on Centos 4.3 (up to date as of this am) I've been trying for a few weeks, on and off to get this working. Finally gave up trying to resolve seemingly endless dependencies and hunted around for a rpm based (yum preferrably) based install. Finding http://wiki.bestpractical.com/index.cgi?RPMInstall I was pleased, and followed the instructions (to the letter, after failing many times to do it 'my way') I die at; Error: Missing Dependency: perl(DBD::Oracle) is needed by package perl-DBIx-SearchBuilder sigh, Apparently, satisfying this dependency is pretty endless and more or less requires an Oracle installation. I don't want Oracle, don't even particularly like Oracle. I emailed Paulo Matos a couple of weeks ago, and no response to date. No joy. Suggestions? Thanks kindly in advance, --chipper ___ 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] logging to file
I've always had to touch the log file and give appropriate permissions. [EMAIL PROTECTED] wrote: RT version3.4.2 This is what I added to my RT_SiteConfig.pm # Mail loops will generate a critical log message. Set($LogToSyslog, ''); Set($LogToScreen, 'error'); Set($LogToFile , 'debug'); Set($LogDir, '/usr/local/rt3/var/log'); Set($LogToFileNamed , rt.log);#log to rt.log However when I log in the log file location there is no log... it's been 3 days... How much info is logged in debug mode? Is there something I am missing in order to get the logs sent to a file? 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 -- 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!
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] Centos 4.3, rt no joy. (DBD::Oracle ?)
On Tue, 2006-08-29 at 09:33 -0400, Chip Mefford wrote: Attempted to install 3.6.0 on Centos 4.3 (up to date as of this am) I've been trying for a few weeks, on and off to get this working. [...] Chip - I've been running 3.6.0 on CentOS 4.3 without too many troubles, after perusing the RHEL4 and fedora 4 install guides at http://wiki.bestpractical.com/index.cgi?RHEL4InstallGuide and http://wiki.bestpractical.com/index.cgi?FedoraCore4InstallGuide (I stuck mostly to the former; I'm using FastCGI and the setup process for 3.6 is basically the same.) I can't help you much with the RPM install, but if you decide to go back to the from-scratch approach feel free to give me a holler. I notice that I don't seem to have DBD::Oracle installed, and DBIx::SearchBuilder doesn't appear to mind. -- /Ole Craig Security Engineer Team lead, customer support 303-381-3802 (main support hotline) 303-381-3824 (my direct line) 303-381-3801 (fax) www.stillsecure.com . . . ___ 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] Centos 4.3, rt no joy. (DBD::Oracle ?)
I've never tried the RPM-based install, but there are a couple of ways to satisfy the dependencies. I generally try to keep my perl modules out of the RPM system, so you'd be using CPAN instead of a package manager/repository like yum. If you still have the source sitting around and it's the same version as the to-be-installed RPM version, from the source: $ make testdeps $ make fixdeps (Rinse, wash, repeat until `make testdeps` is happy.) If there are still missing chunks, figure out what's going on by trying to install them from CPAN: perl -MCPAN -e'install Module::Name' In your case, you might see what happens when you run: perl -MCPAN -e'install DBD::Oracle' HTH, -FC On 8/29/06, Chip Mefford [EMAIL PROTECTED] wrote: Attempted to install 3.6.0 on Centos 4.3 (up to date as of this am) I've been trying for a few weeks, on and off to get this working. Finally gave up trying to resolve seemingly endless dependencies and hunted around for a rpm based (yum preferrably) based install. Finding http://wiki.bestpractical.com/index.cgi?RPMInstall I was pleased, and followed the instructions (to the letter, after failing many times to do it 'my way') I die at; Error: Missing Dependency: perl(DBD::Oracle) is needed by package perl-DBIx-SearchBuilder sigh, Apparently, satisfying this dependency is pretty endless and more or less requires an Oracle installation. I don't want Oracle, don't even particularly like Oracle. I emailed Paulo Matos a couple of weeks ago, and no response to date. No joy. Suggestions? Thanks kindly in advance, --chipper ___ 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-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] logging to file
ok I will try that...any idea of what will be logged in debug mode? On 8/29/06, Drew Barnes [EMAIL PROTECTED] wrote:I've always had to touch the log file and give appropriate permissions. [EMAIL PROTECTED] wrote: RT version3.4.2 This is what I added to my RT_SiteConfig.pm #Mail loops will generate a critical log message. Set($LogToSyslog, ''); Set($LogToScreen, 'error'); Set($LogToFile, 'debug'); Set($LogDir, '/usr/local/rt3/var/log'); Set($LogToFileNamed , rt.log);#log to rt.log However when I log in the log file location there is no log... it's been 3 days... How much info is logged in debug mode? Is there something I am missing in order to get the logs sent to a file? 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 --Drew BarnesApplications AnalystRaymond Walters CollegeUniversity 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] RT will not install dependencies on Centos 4.3 + newest security updates
Attempting to do a new install of RT 3.6.1 on a fresh install of Centos 4.3 with all current updates, I get the following errors during the build process when attempting to run perl sbin/rt-test-dependencies --with-mysql --with-fastcgi --install as root. Removing previously used /root/.cpan/build/Class-ReturnValue-0.53 Can't remove file /root/.cpan/build/Class-ReturnValue-0.53 (No such file or directory) at /usr/lib/perl5/5.8.5/CPAN.pm line 4425 == Couldn't move 'Class-ReturnValue-0.53' to '/root/.cpan/build/Class-ReturnValue-0.53': Is a directory == Cannot continue: Please find the reason why I cannot move == == /root/.cpan/build/tmp/Class-ReturnValue-0.53 == == to== == /root/.cpan/build/Class-ReturnValue-0.53 == == and fix the problem, then retry == Failed to load module CPAN. These occur for every module. If I manually install the modules through CPAN, they work fine. This appears to be the same issue described at: http://wiki.bestpractical.com/index.cgi/RPMInstall/$RT::WebPath/RTIR/Tools/plugin/attachments/RPMInstall/index.cgi?OpenSuSE101InstallGuide -- Brian Daniels Network Administrator -- FarPoint Technologies 808 Aviation Pkwy, Suite 1300 Morrisville, NC 27560 Phones: Tech Support - 919-460-1887 Sales - 800-645-5913Main - 919-460-4551 FTP - ftp.fpoint.com /fpoint.com WEB - www.fpoint.com Sales email: [EMAIL PROTECTED] Technical support: [EMAIL PROTECTED] --- ___ 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
Re: [rt-users] Centos 4.3, rt no joy. (DBD::Oracle ?)
Chip Mefford wrote: Attempted to install 3.6.0 on Centos 4.3 (up to date as of this am) I've been trying for a few weeks, on and off to get this working. Finally gave up trying to resolve seemingly endless dependencies and hunted around for a rpm based (yum preferrably) based install. Finding http://wiki.bestpractical.com/index.cgi?RPMInstall I was pleased, and followed the instructions (to the letter, after failing many times to do it 'my way') I die at; Error: Missing Dependency: perl(DBD::Oracle) is needed by package perl-DBIx-SearchBuilder sigh, Apparently, satisfying this dependency is pretty endless and more or less requires an Oracle installation. I don't want Oracle, don't even particularly like Oracle. I emailed Paulo Matos a couple of weeks ago, and no response to date. I'm running RT just fine off CentOS, and have been for over a year. I checked my Perl installation and I too have that module installed. It's just a Perl module though, and so installing that doesn't mean you need to install an Oracle database. I'm running this off a Postgresql database, also I installed everything manually and have never had to do anything strange other than maybe force a few Perl modules to load here and there. Sometimes Perl installs through CPAN can be a pain and you have to force something. Just my experience with CentOS and RT here, so I'm not sure what you could be doing differently, but I would just load the Perl module if it needs it. It's not going to hurt anything. [EMAIL PROTECTED] ~]# slocate DBD/Oracle /usr/lib/perl5/site_perl/5.8.5/DBIx/DBSchema/DBD/Oracle.pm Worst case is that it's doing what mine is doing, and just sitting there doing nothing. Just my two cents... Max ___ 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
[rt-users] Display ticket contents without requiring login
The following link logs me in automatically in our RT environment: http://rt.ourcorp.com/?user=guestpass=guest However, I want to to provide a link that will log in as guest and view a specific ticket number in one link. The following link will show the ticket contents, but the user has to login: http://rt.ourcorp.com/Ticket/Display.html?id=477 Is there a way to combine the two links so that by clicking on it, the user is automatically logged in as guest and the ticket contents appear? Thanks, Shannon Adams __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ 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
[rt-users] log activities on a per user basis?
I am currently logging in debug mode to a file. I currently do not see any information on activities on a per user basis... I mean users that have access and can log into RT... Info on what user modified what ticket or which user ran a specic query... that sort of thing... Is this possible with the different log levels?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
RE: [rt-users] Display ticket contents without requiring login
You're kidding, right? http://rt.ourcorp.com/Ticket/Display.html?id=477user=guestpass=guest -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Shannon Adams Sent: Tuesday, August 29, 2006 1:03 PM To: rt-users@lists.bestpractical.com Subject: [rt-users] Display ticket contents without requiring login The following link logs me in automatically in our RT environment: http://rt.ourcorp.com/?user=guestpass=guest However, I want to to provide a link that will log in as guest and view a specific ticket number in one link. The following link will show the ticket contents, but the user has to login: http://rt.ourcorp.com/Ticket/Display.html?id=477 Is there a way to combine the two links so that by clicking on it, the user is automatically logged in as guest and the ticket contents appear? Thanks, Shannon Adams __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ 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-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] New Ticket In Queue Alerts
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Chris Allermann wrote: First of all I am rather new to RT, so please forgive me if this is a stupid question. I've been searching the wiki and experimenting with my install for a couple hours now and have not come up with a working solution yet. My Goal: I want to set up a queue that will create new tickets via e-mail and reply to the requestor with an auto-responder (I have this part already working). I have created a TechSupport group and added several members to it, these users have full access to the queue. What I would like to do next is when a new ticket is created is to send out a generic There is a new ticket e-mail alert to all members of the TechSupport group. It seems like it should be a rather straight-forward thing but I can't seem to get it to work. I'd appreciate if anybody can point me in the right direction. Thanks. --Chris Chris, I basically do this with RT-3.6.1. I have my group assigned to the queue as an AdminCC and then I have a global scrip that's condition is On Create and the action is Notify AdminCcs definte your template as necessary and it should work no problem. (this is defined in Configuration Global Scrips) you can also define per-queue scrips in Configuration Queues [queue_name] Scrips hope this helps, Alan -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFE9Qw8E2gsBSKjZHQRAtBIAJ4nibRS+5Keq2LDKrAUk4P3BXreaQCgjFtx mhsAeJO/vFM4krjVMprT1bg= =HVnD -END PGP SIGNATURE- ___ 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