[rt-users] Custom SQL

[Winn Johnston]

All,

I am trying to create a top closers list on the default dashboard. I have the 
exact SQL statment i want to use, but i am lost after that.

select u.Name as User, count(1) as TotalClosedTix from Users u join Tickets t 
on u.id = t.owner where t.Status = "resolved" group by u.Name order by 2 desc 
limit 10 \G;

*** 1. row ***
          User: winnj
TotalClosedTix: 6
*** 2. row ***
          User: dennisc
TotalClosedTix: 3
*** 3. row ***
          User: royced
TotalClosedTix: 1
3 rows in set (0.00 sec)


Can someone please help?

Thanks
Winn Johnston

[rt-users] Auto Dissable of Accounts

[Winn Johnston]

Hello everyone,

I am noticing some of my accounts are being dissabled after an extended period 
of time. Anyone know of a setting in the RT_SiteConfig to disable this, or if 
this is actually a feature of RT 3.6.6

Thanks
Winn Johnston



  ___
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] Upgrade issue 3.0.10 to 3.6.6

[Winn Johnston]

check the permissions on the user [EMAIL PROTECTED]

Try

mysql -urt -hlocalhost -pPASSWORD

once logged in try and create a db, and a table, then
insert some data into it. Your account may only have
read access.


-winn


--- Matt Grosland <[EMAIL PROTECTED]> wrote:

> Hi all,
> 
> When upgrading from 3.0.10 to 3.6.6, I followed the
> upgrade file and  
> did the following:
> 
>  @echo "   
> $(RT_SBIN_PATH)/rt-setup-database --dba $(DB_DBA)  
> --prompt-for-dba-passwor
> d --action schema --datadir etc/upgrade/"
>  @echo "   
> $(RT_SBIN_PATH)/rt-setup-database --dba $(DB_DBA)  
> --prompt-for-dba-passwor
> d --action acl --datadir etc/upgrade/"
>  @echo "   
> $(RT_SBIN_PATH)/rt-setup-database --dba $(DB_DBA)  
> --prompt-for-dba-passwor
> d --action insert --datadir etc/upgrade/"
> 
> The first two worked fine on the first directory
> (3.1.0).  When I did  
> the 'insert' command for the 3.1.0 upgrade
> directory, however, I got  
> this:
> 
> 
> DBI connect('dbname=rt3;host=localhost','rt',...)
> failed: Access  
> denied for user 'rt'@'localhost' (using password:
> YES) at /Library/ 
> Perl/5.8.6/DBIx/SearchBuilder/Handle.pm line 106
> Connect Failed Access denied for user
> 'rt'@'localhost' (using  
> password: YES)
>   at /opt/rt3/lib/RT.pm line 220
> 
> I didn't change anything between the other commands,
> so I'm a bit  
> perplexed.  Ideas?
> 
> -Matt
> Matt Grosland
> Manager of IT
> Dept of Recording Industry
> Middle Tennessee State University
> (615) 494-8997
> [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



  

Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
___
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] RT 3.6.6 Install .. stuck on Apache configuration

[Winn Johnston]

check your /etc/sysconfig/apache

APACHE_MODULES="actions rewrite alias auth_basic
authn_file authz_host authz_groupfile authz_default
authz_user authn_dbm autoindex cgi dir env expires
include log_config mime negotiation setenvif ssl
suexec userdir php5 perl"

make sure you have perl in there, then restart apache

-winn


--- Bob Duff <[EMAIL PROTECTED]> wrote:

> Tried a couple more things still no luck.. anyone
> else have any advice?
> 
> Thanks
> Bob
> 
> 
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On
> Behalf Of Bob Duff
> Sent: Tuesday, April 29, 2008 5:00 PM
> To: 'rt-users@lists.bestpractical.com'
> Subject: [rt-users] RT 3.6.6 Install .. stuck on
> Apache configuration
> 
> I'm have installed RT 3.6 successfully from source
> but there is a configuration problem I can't seem to
> find.  I get the following error when I pull up my
> url:
> RT: Request Tracker
> You're almost there!
> 
> You haven't yet configured your webserver to run RT.
> 
> You appear to have installed RT's web interface
> correctly, but haven't yet configured your web
> server to "run" the RT server which powers the web
> interface.
> 
> The next step is to edit your webserver's
> configuration file to instruct it to use RT's
> mod_perl , fastcgi or speedycgi handler.
> 
>
__
> 
> Here are my configuration files:
> 
> httpd.conf virtual host section for rt:
> 
> 
> 
> ServerName rt.covista.com
> 
> DocumentRoot /opt/rt3/share/html
> 
> AddDefaultCharset UTF-8
> 
> PerlModule Apache::DBI
> 
> PerlRequire /opt/rt3/bin/webmux.pl
> 
> 
> 
> SetHandler perl-script
> 
> PerlHandler RT::Mason
> 
> 
> 
> 
> 
> 
> 
> RT_SiteConfig.pm
> 
> # Any configuration directives you include here will
> override # RT's default configuration file,
> RT_Config.pm # # To include a directive here, just
> copy the equivalent statement # from RT_Config.pm
> and change the value. We've included a single #
> sample value below.
> 
> #
> 
> # This file is actually a perl module, so you can
> include valid # perl code, as well.
> 
> #
> 
> # The converse is also true, if this file isn't
> valid perl, you're # going to run into trouble. To
> check your SiteConfig file, use # this comamnd:
> 
> #
> 
> # perl -c /path/to/your/etc/RT_SiteConfig.pm
> 
> Set( $rtname, 'covista');
> 
> Set($Organization, "rt.covista.com");
> 
> Set($Timezone, 'US/Eastern');
> 
> Set($WebBaseURL,
> "http://rt.covista.com");
> 
> Set($Webpath, "/rt3");
> 
> Set($CorrespondAddress,
>
'[EMAIL PROTECTED]');
> 
> Set($CommentAddress,
>
'[EMAIL PROTECTED]');
> 
> Set($logToSyslog, '');
> 
> Set($logToFile, 'debug');
> 
>  Set($LogDir, '/var/log');
> 
> Set($LogToFileNamed , "rt.log");
> 
> Set($OwnerEmail,
> [EMAIL PROTECTED]);
> 
> Set($MyTicketsLength, 20);
> 
> Set($SendmailPath , "/usr/sbin/sendmail");
> 
> Set($SendmailArguments , "-oi -t");
> 
>  1;
> 
>
_
> 
> Anyone see something I should have caught here?  If
> not any tips on how to resolve this problem?
> 
> Thanks
> Bob Duff
> 
> > ___
>
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



  

Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
___
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] Top Resolvesrs / Elements failed to display after upgrading

[Winn Johnston]

We were running 3.3.4 and upgraded to 3.3.6. After the
upgrade i noticed the top resolvers were not showing,
along with some other custom elements.

So i did a clean install to see if they would then
show once i put the files back in the elements
directory. Still nothing. Here is the path i am using
along with the permissions.

rt:/opt/rt3/local/html/Elements # ll
total 24
drwxr-xr-x  2 wwwrun www 4096 Apr 30 17:31 .
drwxr-xr-x  3 wwwrun www 4096 Apr 30 12:18 ..
-rwxr-xr-x  1 wwwrun www 2039 Apr 21  2006
LanguishingTickets
-rwxr-xr-x  1 wwwrun www 2380 Apr 21  2006 MyRequests
-rwxr-xr-x  1 wwwrun www 2625 Apr 21  2006 MyTickets
-rwxr-xr-x  1 wwwrun www 1586 Apr 21  2006
TopResolvers


Below you will find what i believe to be the error,
along with a stack trace.

Any help would greatly be appreciated.

Thanks
-winn 



[Wed Apr 30 22:43:26 2008] [debug]: SQL(0.00s): SELECT
ACL.id, ACL.ObjectType, ACL.ObjectId FROM ACL,
Principals, CachedGroupMembers WHERE (ACL.RightName =
'SuperUser'
 OR ACL.RightName = 'SeeQueue') AND Principals.id =
ACL.PrincipalId AND Principals.PrincipalType = 'Group'
AND Principals.Disabled = 0 AND
CachedGroupMembers.GroupId  
= ACL.PrincipalId AND CachedGroupMembers.GroupId  =
Principals.id AND CachedGroupMembers.MemberId = 14032
AND CachedGroupMembers.Disabled = 0  AND
((ACL.ObjectType = '
RT::System' AND ACL.ObjectId = 1) OR (ACL.ObjectType =
'RT::Queue' AND ACL.ObjectId = 36)) LIMIT 1;
(/opt/rt3/share/html/autohandler:319)

Stack trace:
HTML::Mason::Commands::__ANON__() called at
/usr/lib/perl5/site_perl/5.8.3/HTML/Mason/Component.pm:135
HTML::Mason::Component::run() called at
/usr/lib/perl5/site_perl/5.8.3/HTML/Mason/Request.pm:1246
(eval)() called at
/usr/lib/perl5/site_perl/5.8.3/HTML/Mason/Request.pm:1245
HTML::Mason::Request::comp() called at
/usr/lib/perl5/site_perl/5.8.3/HTML/Mason/Request.pm:459
(eval)() called at
/usr/lib/perl5/site_perl/5.8.3/HTML/Mason/Request.pm:459
(eval)() called at
/usr/lib/perl5/site_perl/5.8.3/HTML/Mason/Request.pm:411
HTML::Mason::Request::exec() called at
/usr/lib/perl5/site_perl/5.8.3/HTML/Mason/ApacheHandler.pm:168
HTML::Mason::Request::ApacheHandler::exec()
called at
/usr/lib/perl5/site_perl/5.8.3/HTML/Mason/ApacheHandler.pm:826
HTML::Mason::ApacheHandler::handle_request()
called at /opt/rt3/bin/webmux.pl:125
(eval)() called at /opt/rt3/bin/webmux.pl:125
RT::Mason::handler() called at -e:0
(eval)() called at -e:0



  

Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
___
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] Mailgate issue

[Winn Johnston]

Apr 17 16:46:08 rt postfix/local[16592]: 2B1CE97EC3:
to=<[EMAIL PROTECTED]>, relay=local, delay=0,
status=deferred (temporary failure. Command output: An
Error Occurred =  403 Forbidden 

Error msg.

Can someone please help me. Not sure why apache would
be issuing a 403 error


Thanks

-winn


  

Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
___
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] I've asked the beginner perl group but no one responded

[Winn Johnston]

Mat,

How about trying 

cpan -if HTML::FormatText
cpan -if XML::RS
cpan -if Apache::DBI


-winn

--- Mathew <[EMAIL PROTECTED]> wrote:

> I'm trying to make the (re-)installation of RT as
> painless as possible 
> for future generations.  I've encountered a problem
> though in that I 
> can't get HTML::FormatText, XML::RSS or Apache-DBI
> to install through 
> `make fixdeps`.  As a result I've written a small
> script which parses 
> the output of `make testdeps` for any lines
> containing "MISSING".
> 
> I'm trying to pass these modules onto cpan and force
> their installation 
> with no luck.  I've tried the following:
> CPAN::Shell::force(install,$mod_name)
> CPAN::Module::force(install,$mod_name)
> system "perl -MCPAN -e 'force install $mod_name'"
> 
> None work.
> 
> How can I take care of this?
> 
> Mathew
> -- 
> JJ: "I've lost faith in you Matt."
> Matt: "What?"
> JJ: "You're listening to Metallica."
> Matt: "Come on now, it isn't like I actually paid
> for it."
> 
> Keep up with me and what I'm up to:
> http://theillien.blogspot.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
> 



  

Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
___
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] Critical Errors

[Winn Johnston]

It seems i can create a ticket after i restart apache
and mysql. But i can only create one before the logs
start freaking out about bogus ticket number

-winn

--- Winn Johnston <[EMAIL PROTECTED]> wrote:

> [crit]: Apache2::RequestIO::rflush: (104) Connection
> reset by peer at
>
/usr/lib/perl5/site_perl/5.8.3/HTML/Mason/ApacheHandler.pm
> line 1029 (/usr/local/rt3/bin/webmux.pl:134)
> 
> 
> 
> --- Winn Johnston <[EMAIL PROTECTED]> wrote:
> 
> > [crit]: RT::Attachment->Create couldn't, as you
> > didn't
> > specify a transaction
> > 
> > [crit]: RT::Ticket=HASH(0xa58dd04) tried to load a
> > bogus ticket: 7715
> > 
> > RT seemed to throw up all over the place this
> > morning
> > when I updated the server. Is there any regression
> > tests i can run to see what package broke the
> > software?
> > 
> > Thanks
> > Winn Johnston
> > 
> > 
> > 
> > 
> >  
> >
>

> > Be a better friend, newshound, and 
> > know-it-all with Yahoo! Mobile.  Try it now. 
> >
>
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
> > ___
> >
>
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
> > 
> 
> 
> 
>  
>

> Be a better friend, newshound, and 
> know-it-all with Yahoo! Mobile.  Try it now. 
>
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
> 



  

Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
___
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] Critical Errors

[Winn Johnston]

[crit]: Apache2::RequestIO::rflush: (104) Connection
reset by peer at
/usr/lib/perl5/site_perl/5.8.3/HTML/Mason/ApacheHandler.pm
line 1029 (/usr/local/rt3/bin/webmux.pl:134)



--- Winn Johnston <[EMAIL PROTECTED]> wrote:

> [crit]: RT::Attachment->Create couldn't, as you
> didn't
> specify a transaction
> 
> [crit]: RT::Ticket=HASH(0xa58dd04) tried to load a
> bogus ticket: 7715
> 
> RT seemed to throw up all over the place this
> morning
> when I updated the server. Is there any regression
> tests i can run to see what package broke the
> software?
> 
> Thanks
> Winn Johnston
> 
> 
> 
> 
>  
>

> Be a better friend, newshound, and 
> know-it-all with Yahoo! Mobile.  Try it now. 
>
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
> ___
>
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
> 



  

Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
___
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] Critical Errors

[Winn Johnston]

[crit]: RT::Attachment->Create couldn't, as you didn't
specify a transaction

[crit]: RT::Ticket=HASH(0xa58dd04) tried to load a
bogus ticket: 7715

RT seemed to throw up all over the place this morning
when I updated the server. Is there any regression
tests i can run to see what package broke the
software?

Thanks
Winn Johnston




  

Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
___
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] Can't view newly created ticket - Solved

[Winn Johnston]

Problem Solved. It seemed that suse, likes to create
sendmail cf files for your convenience. One of their
cf files worked its way into the config and broke RT.
Hmm should RT be giving strange errors when sendmail
breaks? Guess so.

-winn

--- Winn Johnston <[EMAIL PROTECTED]> wrote:

> This just started happening, no changes were made to
> the system. 
> 
> mysql v 4.01
> apache2
> 
> Is there something i can check in the ACL table?
> 
> 
> Wed Dec  6 23:36:03 2006] [info]:
> <[EMAIL PROTECTED]>
> #6421/28782 - Scrip 2 
> (/opt/rt3/lib/RT/Action/SendEmail.pm:237)
> [Wed Dec  6 23:36:03 2006] [warning]: DBD::mysql::st
> execute failed: MySQL server has gone away at
>
/usr/local/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm
> li
> ne 492. (/opt/rt3/lib/RT.pm:287)
> [Wed Dec  6 23:36:03 2006] [warning]:
> RT::Handle=HASH(0x96f8200) couldn't execute the
> query
> 'INSERT INTO Transactions (OldReference, Type,
> Field,
> OldValue, NewReferenc
> e, NewValue, Creator, ObjectId, ReferenceType,
> Created, Data, ObjectType) VALUES (?, ?, ?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?)' at
> /usr/local/lib/perl5/site_perl/5.8.3/DBIx/Sea
> rchBuilder/Handle.pm line 505
>
>
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x96f8200)','INSERT
> INTO Transactions (OldReference, Type, Field,
> OldValue...','undef','EmailRecord',
> 'undef','undef','undef','undef',1,...) called at
>
/usr/local/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm
> line 365
>
>
DBIx::SearchBuilder::Handle::Insert('RT::Handle=HASH(0x96f8200)','Transactions','OldReference','undef','Type','EmailRecord','Field','undef','OldValue',...)
> cal
> led at
>
/usr/local/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle/mysql.pm
> line 39
>
>
DBIx::SearchBuilder::Handle::mysql::Insert('RT::Handle=HASH(0x96f8200)','Transactions','OldReference','undef','Type','EmailRecord','Field','undef','OldValue',.
> ..) called at
>
/usr/local/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Record.pm
> line 1291
>
>
DBIx::SearchBuilder::Record::Create('RT::Transaction=HASH(0xa484984)','OldReference','undef','Field','undef','Type','EmailRecord','OldValue','undef',...)
> calle
> d at /opt/rt3/lib/RT/Record.pm line 300
> 
> 
> 
> Thanks
> Winn Johnston
> 
> 
>  
>

> Do you Yahoo!?
> Everyone is raving about the all-new Yahoo! Mail
> beta.
> http://new.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
> 



 

Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail beta.
http://new.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

[rt-users] Can't view newly created ticket

[Winn Johnston]

This just started happening, no changes were made to
the system. 

mysql v 4.01
apache2

Is there something i can check in the ACL table?


Wed Dec  6 23:36:03 2006] [info]:
<[EMAIL PROTECTED]>
#6421/28782 - Scrip 2 
(/opt/rt3/lib/RT/Action/SendEmail.pm:237)
[Wed Dec  6 23:36:03 2006] [warning]: DBD::mysql::st
execute failed: MySQL server has gone away at
/usr/local/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm
li
ne 492. (/opt/rt3/lib/RT.pm:287)
[Wed Dec  6 23:36:03 2006] [warning]:
RT::Handle=HASH(0x96f8200) couldn't execute the query
'INSERT INTO Transactions (OldReference, Type, Field,
OldValue, NewReferenc
e, NewValue, Creator, ObjectId, ReferenceType,
Created, Data, ObjectType) VALUES (?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?)' at
/usr/local/lib/perl5/site_perl/5.8.3/DBIx/Sea
rchBuilder/Handle.pm line 505
   
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x96f8200)','INSERT
INTO Transactions (OldReference, Type, Field,
OldValue...','undef','EmailRecord',
'undef','undef','undef','undef',1,...) called at
/usr/local/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm
line 365
   
DBIx::SearchBuilder::Handle::Insert('RT::Handle=HASH(0x96f8200)','Transactions','OldReference','undef','Type','EmailRecord','Field','undef','OldValue',...)
cal
led at
/usr/local/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle/mysql.pm
line 39
   
DBIx::SearchBuilder::Handle::mysql::Insert('RT::Handle=HASH(0x96f8200)','Transactions','OldReference','undef','Type','EmailRecord','Field','undef','OldValue',.
..) called at
/usr/local/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Record.pm
line 1291
   
DBIx::SearchBuilder::Record::Create('RT::Transaction=HASH(0xa484984)','OldReference','undef','Field','undef','Type','EmailRecord','OldValue','undef',...)
calle
d at /opt/rt3/lib/RT/Record.pm line 300



Thanks
Winn Johnston


 

Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail beta.
http://new.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

[rt-users] Quick Ticket Creation Box - and code to change passwords back to md5 base 64

[Winn Johnston]

hello all,     I have up graded to RT 3.4.5, everything seems to be working just fine. Except for the Quick Ticket Creation Box on the main page. After using the Quick Create ticket option, the ticket is never created. Using the long form it works. Am i missing an option that needs to be turned on in one of the configuration files? Thanks in advance.     Also here below is some code you might find usefull. The RT 3.4.5 uses a hex encoded password, this is diffrent than the previous versions that use a base64 encoded password. If your shop is like ours then you copy the RT users database around the network and use it to authenticate users for other apps. Below is some perl code that will re-encode the new Hex format back to the base64.     #!/usr/bin/perl   # load module use DBI; use MIME::Base64 qw(); use bytes;  @mysqlcopy
 =(/usr/bin/mysqldump --host=rt.dnc.org -uroot --add-drop-table --compress --add-locks -e rt3 Users Groups CachedGroupMembers | /usr/bin/mysql --host=192.168.10.47 -uroot -plemon -C rt3);system (@args);  #querymy $query = qq(    SELECT *    From Users    WHERE CHAR_LENGTH(Password)< 33 AND (CHAR_LENGTH(Password) != 13));  # connectmy $dbh = DBI->connect("DBI:mysql:database=rt3;host=localhost", "root", "", {'RaiseError' => 1});  my $sth = $dbh->prepare($query);$sth->execute();   # iterate through resultset # print values  while(my $ref = $sth->fetchrow_hashref()) {  $old_encoded_pwd = $ref->{'Password'};my $md5 = MIME::Base64::encode(pack "H*", "$old_encoded_pwd");  print "User: $ref->{'Name'}\n";print
 "Password: $ref->{'Password'}\n";    substr($md5,-3) ='';    print "New Password: '$md5'\n";      # execute INSERT query   my $rows = $dbh->do("update Users SET Password= '$md5' WHERE Name='$ref->{Name}';");   print "$rows row(s) affected\n";   print "--\n"; }   # clean up  $dbh->disconnect();
		Yahoo! Messenger with Voice. PC-to-Phone calls for ridiculously low rates.___
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html

[rt-users] rt mailgate reply to field

[Winn Johnston]

hello all,     i am working on a development box, and the last thing i have to do is test the rt-mailgate. It seems like everything is working except for the replyto field. It still refrences the old box.     example.  [EMAIL PROTECTED]  i need it to say  [EMAIL PROTECTED]     i am sure it is in the site config, but i just can't find it.     thanks in advance  winn johnston
		Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls.  Great rates starting at 1¢/min.___
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html

[rt-users] 255 Unknown Mailer

[Winn Johnston]

what's up everyone,      I am getting a unknown mailer error 255 when ever i try and send something to the rt system.     <snip from aliases>  datamart: "|/usr/local/rt3/bin/rt-mailgate --queue datamart --action correspond --url https://rt.xxx.xxx.org/"  snip>     <snip from running rt-mailgate on the command line>  usr/bin/perl /usr/local/bin/rt-mailgate --queue datamart --action correspond --url https://x.org --debug < /etc/aliases  Connecting to https://rt..xx.xxorg/REST/1.0/NoAuth/mail-gateway at /usr/local/bin/rt-mailgate line 444, <> chunk 1.okTicket: 6146Queue: datamartOwner: NobodyStatus:
 newSubject: Requestor:  at /usr/local/bin/rt-mailgate line 453, <> chunk 1.  snip>     Running the rt-mailgate from the command line works fine, it is just when i format an e-mail with mail [EMAIL PROTECTED] i get that darn 255 mailer unknown error. Any ideas     winn johnston
		New Yahoo! Messenger with Voice. Call regular phones from your PC and save big.___
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html

Re: [rt-users] Ticket Display Customizing

[Winn Johnston]

I have found the custom files on old RT 3.0.1 they are located in /local/html/Elements. I tried just copying the files to the new 3.4.5 local/html/Elements directory, however that directory does not exist. So i created it, but i can't figure out how to activate them. Any ideas would be appreciated.     Thanks  winn johnstonWinn Johnston <[EMAIL PROTECTED]> wrote:I have just completed upgrading from RT 3.0.1 to RT 3.4.5, My supervisor has asked me to show the priority level sorted from lowest to highest. I also noticed some diffrences on the layout of the main screen.     RT 3.0.1 (layout left most part of the screen)10 highest priority tickets I own... 10 highest priority tickets I requested... 10 longest-neglected
 high-priority tickets...      RT 3.4.5 (layout left most part of the screen)10 highest priority tickets I own10 newest unowned tickets      Are the "10 highest priority tickets I requested..." and "10 longest-neglected high-priority tickets..." custom templates, or is there a way to configure this from within the program interface it self? Also changing how the sort takes place, again is this a custom mod or am i just missing some configuration tool?     Thanks In Advance  Winn Johnston
	
		Celebrate Earth Day everyday!  Discover 10 things you can do to help slow climate change. Yahoo! Earth Day___
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html

[rt-users] Ticket Display Customizing

[Winn Johnston]

I have just completed upgrading from RT 3.0.1 to RT 3.4.5, My supervisor has asked me to show the priority level sorted from lowest to highest. I also noticed some diffrences on the layout of the main screen.     RT 3.0.1 (layout left most part of the screen)10 highest priority tickets I own... 10 highest priority tickets I requested... 10 longest-neglected high-priority tickets...      RT 3.4.5 (layout left most part of the screen)10 highest priority tickets I own10 newest unowned tickets      Are the "10 highest priority tickets I requested..." and "10 longest-neglected high-priority tickets..." custom templates, or is there a way to configure this from within the program interface it self? Also changing how the sort takes place, again is this a custom mod or am i just missing some
 configuration tool?     Thanks In Advance  Winn Johnston   
	
		Celebrate Earth Day everyday!  Discover 10 things you can do to help slow climate change. Yahoo! Earth Day___
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html

Re: [Rt-Users] Apache2 Starting at boot time

[Winn Johnston]

Vivek,     bash env     some more nfo:  I have a very strange issue. It seems when i enable apache2 to start at boot, during the boot process i get an error about PerlModule Apache::DBI that is in my vhost.conf for RT 3.4.5. However when i start apache at the command line it doesn't throw-up all over the place and the program runs fine. I started looking on CPAN for Apache2::DBI but found nothing. Has anyone else seen this issue? Is there an Apache2::DBI i could download?     System nfo:   SuSe 9.0 Network Enterpise   RT 3.4.5   Apache2   Mod_Perl2     Vivek Khera <[EMAIL PROTECTED]> wrote:  On Apr 19, 2006, at 1:59 PM, Winn Johnston wrote:> I have a very strange issue. It seems when i enable apache2 to > start at boot, during the boot process i get an error about > PerlModule Apache::DBI that is in my vhost.conf for RT 3.4.5. > However when i start apache at the command line it doesn't throw-up > all over the place and the program runs fine. I started looking on > CPAN for Apache2::DBI but found nothing. Has anyone else seen this > issue? Is there an Apache2::DBI i could download?>>what's in your environment on your login shell?i bet you set some PERL paths.and what does this have to do with RT development? seems like a users issue to me.___List info: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-develBest Practical is hiring! Come hack Perl for us:
 http://bestpractical.com/about/jobs.html
		New Yahoo! Messenger with Voice. Call regular phones from your PC and save big.___
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html

[rt-users] Apache won't start at boot But will from the command line

[Winn Johnston]

I have a very strange issue. It seems when i enable apache2 to start at boot, during the boot process i get an error about PerlModule Apache::DBI that is in my vhost.conf for RT 3.4.5. However when i start apache at the command line it doesn't throw-up all over the place and the program runs fine. I started looking on CPAN for Apache2::DBI but found nothing. Has anyone else seen this issue? Is there an Apache2::DBI i could download?     System nfo:   SuSe 9.0 Network Enterpise   RT 3.4.5   Apache2   Mod_Perl2     RT.vhost.conf     Listen 443  LoadModule apreq_module /usr/lib/apache2/mod_apreq2.soServerName
 rt.newrt.dnc.org:443  DocumentRoot /opt/rt3/share/html  LogLevel debug  ErrorLog /var/log/apache2/rt_error_log  TransferLog /var/log/apache2/rt_access_log  PerlSetVar MasonArgsMethod CGI  RewriteEngine On  RewriteRule ^(.*)/$ $1/index.html  PerlModule Apache::DBISetHandler perl-script  PerlHandler RT::MasonSSLEngine on  SSLCipherSuite ALL:!ADH:!EXPORT56:RC4+RSA:+HIGH:+MEDIUM:+LOW:+SSLv2:+EXP:+eNULL  SSLCertificateFile /etc/apache2/ssl.crt/newcert.crt  SSLCertificateKeyFile /etc/apache2/ssl.key/newkey.pemSSLOptions +StdEnvVars  SSLOptions +StdEnvVars 
 SetEnvIf User-Agent ".*MSIE.*" \  nokeepalive ssl-unclean-shutdown \  downgrade-1.0 force-response-1.0CustomLog /var/log/apache2/rt_ssl_error_log ssl_combined     Error Msg at boot:  [Wed Apr 19 13:56:32 2006] [error] Can't locate Apache/DBI.pm in @INC (@INC contains: /usr/lib/perl5/5.8.3/i586-linux-thread-multi /usr/lib/perl5/5.8.3 /usr/lib/perl5/site_perl/5.8.3/i586-linux-thread-multi /usr/lib/perl5/site_perl/5.8.3 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.3/i586-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.3 /usr/lib/perl5/vendor_perl . /srv/www) at (_eval 2) line 3.\n  [Wed Apr 19 13:56:32 2006] [error] Can't load Perl module Apache::DBI for server rt.newrt.dnc.org:443,
 exiting...__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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html

[rt-users] Converting md5 base64 to md5 hex

[Winn Johnston]

Thanks to Ruslan and his piece of code i was able to right this script. It will be helpfull to anyone upgrading to RT 3.4.5 , and people who use to rt database to authentacate users for other pieces of software. It seems RT 3.4.5 uses an MD5 HEX encoding system, but for backwards compatability it can read MD5 base64 encoded passwords. However as users log into the new system the passwords are re-encoded and stored in the new HEX format. This script will change all the passwords to HEX and leave any blank passwords alone. Hope this helps :)     #!/usr/bin/perl# load module  use DBI;  use MIME::Base64 qw();  use bytes;  #query  my $query = qq(  SELECT *  From Users  WHERE CHAR_LENGTH(Password)< 32 AND (CHAR_LENGTH(Password) != 0) AND (CHAR_LENGTH(Password) != 13)  ); 
   # connect  my $dbh = DBI->connect("DBI:mysql:database=rt3;host=localhost", "root", "", {'RaiseError' => 1});my $sth = $dbh->prepare($query);  $sth->execute();# iterate through resultset  # print values  while(my $ref = $sth->fetchrow_hashref()) {  $old_encoded_pwd = $ref->{'Password'};  my $md5 = MIME::Base64::decode($old_encoded_pwd);  $md5 =~ s/(.)/sprintf "%02x",ord($1)/gmse;  print "User: $ref->{'Name'}\n";  print "Password: $ref->{'Password'}\n";  print "New Password: '$md5'\n";# execute INSERT query  my $rows = $dbh->do("update Users SET Password= '$md5' WHERE Name='$ref->{Name}';");  print "$rows row(s) affected\n";  print "--\n";  }# clean up 
 $dbh->disconnect();
		Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less.___
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html

[rt-users] Password Fix

[Winn Johnston]

I am looking for a script that will parse the newly
upgraded (3.0.1 -> 3.4.5)Users Password fields. The
change takes place once a userlogs in for the first
time on the new system. However it would be nice if
there was a script that would commit the change for
me, becuase we auth against that user database, and i
need one standard encryption method to be ussed.

Thanks in adavance
winn johnston

__
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html

[rt-users] CachedGroupMember

[Winn Johnston]

Would someone tell me how the CachedGroupMember table
is built? I have migrated from 3.0.1 to 3.4.5, and
everything is working in RT as it should. However we
authenticate against the RT user table, and i am
having a problem with part of my authentication. The
passwords and user name are correctly auth'd, but the
group relationship is off. We use the
authmysqlgrouptable and link to the CachedGroupMember
table. Now when i migrated that table did not come
over with the same number of records as on the
previous machine. 

Thanks In Advance
winn

__
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html