Re: [rt-users] How to run Queue-Bound scrips instead of the global version?

2006-08-29 Thread Roy El-Hames
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.

2006-08-29 Thread Brendan S (Scratch User)
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 ?)

2006-08-29 Thread Chip Mefford
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

2006-08-29 Thread Drew Barnes

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!

2006-08-29 Thread Ben Weston
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 ?)

2006-08-29 Thread Ole Craig
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 ?)

2006-08-29 Thread Frances Albemuth

 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

2006-08-29 Thread [EMAIL PROTECTED]
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

2006-08-29 Thread BDaniels

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!

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!

2006-08-29 Thread Drew Barnes
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 ?)

2006-08-29 Thread Max H.
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...

2006-08-29 Thread Ben Weston
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...

2006-08-29 Thread Ben Weston

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...

2006-08-29 Thread Ben Weston
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...

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 Michael Liebman

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...

2006-08-29 Thread Ben Weston

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

2006-08-29 Thread Shannon Adams
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...

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

[rt-users] log activities on a per user basis?

2006-08-29 Thread [EMAIL PROTECTED]
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

2006-08-29 Thread Schultz, Eric
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

2006-08-29 Thread Alan Premselaar
-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