Re: [rt-users] Two questions

[Kevin Falcone]

On Thu, Feb 02, 2012 at 01:25:13PM -0500, Josh Narins wrote:
> > On Tue, Jan 31, 2012 at 12:54:04PM -0500, Josh Narins wrote:
> > > > On Tue, Jan 31, 2012 at 09:28:00AM -0500, Josh Narins wrote:
> > > > >I got partway along writing a Mail Plugin for RT3.8, but,
> > > > somewhere along the way, I lost it.
> > > > >
> > > > >Can anyone point me to any documentation on them? My goal is
> > to
> > > > remove the endlessly
> > > > >duplicating newlines of the quoted text on each reply to our
> > > > tickets and to remove the
> > > > >signatures.
> > > >
> > > > There is actually code in 3.8.10 or later to work around Outlook's
> > > > bugs with newlines.
> > >
> > > I'm running 4.0.2 and still have the problem.
> >
> > Please followup with some sample data to rt-bugs?  Thanks
> 
> Sure. What data do you actually want? I'm happy to run any sort of
> query. I found a ticket with no business-sensitive information that
> has the problem.

I suspect the most useful thing is reconstructing from the Attachments
table email that can be shoved through rt-mailgate so they can be
added to the existing tests for the newline removal.

-kevin


pgphtZQDoRlAM.pgp
Description: PGP signature

RT Training Sessions (http://bestpractical.com/services/training.html)
* Boston — March 5 & 6, 2012

Re: [rt-users] Two questions

[Josh Narins]

> On Tue, Jan 31, 2012 at 12:54:04PM -0500, Josh Narins wrote:
> > > On Tue, Jan 31, 2012 at 09:28:00AM -0500, Josh Narins wrote:
> > > >I got partway along writing a Mail Plugin for RT3.8, but,
> > > somewhere along the way, I lost it.
> > > >
> > > >Can anyone point me to any documentation on them? My goal is
> to
> > > remove the endlessly
> > > >duplicating newlines of the quoted text on each reply to our
> > > tickets and to remove the
> > > >signatures.
> > >
> > > There is actually code in 3.8.10 or later to work around Outlook's
> > > bugs with newlines.
> >
> > I'm running 4.0.2 and still have the problem.
>
> Please followup with some sample data to rt-bugs?  Thanks

Sure. What data do you actually want? I'm happy to run any sort of
query. I found a ticket with no business-sensitive information that
has the problem.


Josh Narins
Director of Application Development
SeniorBridge

845 Third Ave
7th Floor
New York, NY 10022
Tel: (212) 994-6194
Mobile: (917) 488-6248
Fax: (212) 994-4260
jnar...@seniorbridge.com

SeniorBridge
Managing Complex Chronic Care
http://www.seniorbridge.com



SeniorBridge Statement of Confidentiality: The contents of this email message 
are intended for the exclusive use of the addressee(s) and may contain 
confidential or privileged information. Any dissemination, distribution or 
copying of this email by an unintended or mistaken recipient is strictly 
prohibited. In said event, kindly reply to the sender and destroy all entries 
of this message and any attachments from your system. Thank you.

RT Training Sessions (http://bestpractical.com/services/training.html)
* Boston  March 5 & 6, 2012

Re: [rt-users] Two questions

[Kevin Falcone]

On Tue, Jan 31, 2012 at 12:54:04PM -0500, Josh Narins wrote:
> > On Tue, Jan 31, 2012 at 09:28:00AM -0500, Josh Narins wrote:
> > >I got partway along writing a Mail Plugin for RT3.8, but,
> > somewhere along the way, I lost it.
> > >
> > >Can anyone point me to any documentation on them? My goal is to
> > remove the endlessly
> > >duplicating newlines of the quoted text on each reply to our
> > tickets and to remove the
> > >signatures.
> >
> > There is actually code in 3.8.10 or later to work around Outlook's
> > bugs with newlines.
> 
> I'm running 4.0.2 and still have the problem.

Please followup with some sample data to rt-bugs?  Thanks

-kevin


pgpIgkj7BaZCe.pgp
Description: PGP signature

RT Training Sessions (http://bestpractical.com/services/training.html)
* Boston — March 5 & 6, 2012

Re: [rt-users] Two questions

[Josh Narins]

> On Tue, Jan 31, 2012 at 09:28:00AM -0500, Josh Narins wrote:
> >I got partway along writing a Mail Plugin for RT3.8, but,
> somewhere along the way, I lost it.
> >
> >Can anyone point me to any documentation on them? My goal is to
> remove the endlessly
> >duplicating newlines of the quoted text on each reply to our
> tickets and to remove the
> >signatures.
>
> There is actually code in 3.8.10 or later to work around Outlook's
> bugs with newlines.

I'm running 4.0.2 and still have the problem.

> You probably want to look at CommandByMail or the GnuPG encryption
> plugin for an example of how to work with the mail.

Will do.

> >Certain people aren't quite clear on who should be assigning
> tickets to whom, so, I'd like to
> >be able to block that. Is this a transactionbatch step? Can anyone
> point me to what I'd need
> >to add the code I need to block that?
>
> You'd probably be better off just hiding the Owners dropdown from some
> people (or ensuring they don't have ModifyTicket).
>
> If you want to do it from a Scrip, you only need a normal
> TransactionCreate Scrip when an OwnerChange condition and a custom
> action.

Thanks, again.



Josh Narins
Director of Application Development
SeniorBridge

845 Third Ave
7th Floor
New York, NY 10022
Tel: (212) 994-6194
Mobile: (917) 488-6248
Fax: (212) 994-4260
jnar...@seniorbridge.com

SeniorBridge
Managing Complex Chronic Care
http://www.seniorbridge.com



SeniorBridge Statement of Confidentiality: The contents of this email message 
are intended for the exclusive use of the addressee(s) and may contain 
confidential or privileged information. Any dissemination, distribution or 
copying of this email by an unintended or mistaken recipient is strictly 
prohibited. In said event, kindly reply to the sender and destroy all entries 
of this message and any attachments from your system. Thank you.

RT Training Sessions (http://bestpractical.com/services/training.html)
* Boston  March 5 & 6, 2012

Re: [rt-users] Two questions

[Kevin Falcone]

On Tue, Jan 31, 2012 at 09:28:00AM -0500, Josh Narins wrote:
>I got partway along writing a Mail Plugin for RT3.8, but, somewhere along 
> the way, I lost it.
> 
>Can anyone point me to any documentation on them? My goal is to remove the 
> endlessly
>duplicating newlines of the quoted text on each reply to our tickets and 
> to remove the
>signatures.

There is actually code in 3.8.10 or later to work around Outlook's
bugs with newlines.

You probably want to look at CommandByMail or the GnuPG encryption
plugin for an example of how to work with the mail.

>Certain people aren't quite clear on who should be assigning tickets to 
> whom, so, I'd like to
>be able to block that. Is this a transactionbatch step? Can anyone point 
> me to what I'd need
>to add the code I need to block that?

You'd probably be better off just hiding the Owners dropdown from some
people (or ensuring they don't have ModifyTicket).

If you want to do it from a Scrip, you only need a normal
TransactionCreate Scrip when an OwnerChange condition and a custom
action.

-kevin


pgpXdDfQktgUD.pgp
Description: PGP signature

RT Training Sessions (http://bestpractical.com/services/training.html)
* Boston — March 5 & 6, 2012

[rt-users] Two questions

[Josh Narins]

1.

I got partway along writing a Mail Plugin for RT3.8, but, somewhere along the 
way, I lost it.

Can anyone point me to any documentation on them? My goal is to remove the 
endlessly duplicating newlines of the quoted text on each reply to our tickets 
and to remove the signatures.

2.

Certain people aren't quite clear on who should be assigning tickets to whom, 
so, I'd like to be able to block that. Is this a transactionbatch step? Can 
anyone point me to what I'd need to add the code I need to block that?

Thanks.



Josh Narins
Director of Application Development
SeniorBridge

845 Third Ave
7th Floor
New York, NY 10022
Tel: (212) 994-6194
Fax: (212) 994-4260
Mobile: (917) 488-6248
jnar...@seniorbridge.com
seniorbridge.com

[http://www.seniorbridge.com/images/seniorbridgedisclaimerTAG.gif]



SeniorBridge Statement of Confidentiality: The contents of this email message 
are intended for the exclusive use of the addressee(s) and may contain 
confidential or privileged information. Any dissemination, distribution or 
copying of this email by an unintended or mistaken recipient is strictly 
prohibited. In said event, kindly reply to the sender and destroy all entries 
of this message and any attachments from your system. Thank you.

RT Training Sessions (http://bestpractical.com/services/training.html)
* Boston — March 5 & 6, 2012

Re: [rt-users] Two questions regarding an upgrade installation

[Erik Anderson]

On 10/23/07, Erik Anderson <[EMAIL PROTECTED]> wrote:
> Thanks Craig - that worked perfectly.  I should have looked around a
> bit more before posting.
>
> Anyway - does anyone have any clue as to my login session problem?

This has been resolved - there was a little snippet at the bottom of
one of the wiki pages:

---
A table structure issue: take a look at the "sessions" table in the RT
database. There should be a column named "a_session". This column must
have the type "longblob" not "longtext". Also note that if there are
any records in the table, the entire table should be emptied (either
before or after making the change), otherwise the problem will
persist.
---

I changed the a_session column type to LONGBLOB and the problem went away.

Thanks!
-erik
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch 
today. 
Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.


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] Two questions regarding an upgrade installation

[Erik Anderson]

Thanks Craig - that worked perfectly.  I should have looked around a
bit more before posting.

Anyway - does anyone have any clue as to my login session problem?

-erik

On 10/23/07, Patterson, Craig <[EMAIL PROTECTED]> wrote:
> Check out the README that is included with the rt tar.
>
> Basically you need to...
> 1.  cd into the directory that you unpacked the rtX.X.X.tar into(not the
> folder you installed rt into).
>
> 2. ls the etc/upgrade folder.
>
> 3.  For each folder higher than your current version
>   {rt-home}/sbin/rt-setup-database --action schema --datadir
> etc/upgrade/[version] --dba rt --dba-password *
>
>   {rt-home}/sbin/rt-setup-database --action acl  --datadir
> etc/upgrade/[version] --dba rt --dba-password *
>
>   {rt-home}/sbin/rt-setup-database --action insert --datadir
> etc/upgrade/[version] --dba rt --dba-password **
>
> Depending on what variables to set in your RT_SiteConfig, you'll have to
> set different options in the above commands.
>
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Erik
> Anderson
> Sent: Tuesday, October 23, 2007 12:42 PM
> To: rt-users@lists.bestpractical.com
> Subject: [rt-users] Two questions regarding an upgrade installation
>
> All - we've been running on an install of rt-3.2.0 for several years
> now and I've decided it's time to upgrade.  I have two questions so
> far:
>
> 1. I've installed rt-3.6.5 on a different server and have initialized
> the db.  I can get to the login page of RT and can login with the
> default root user and password.  However, when I click on any of the
> links in RT, I'm sent back to the login screen.
>
> After logging in, I can see that RT sets a cookie as well as inserting
> a matching row into the sessions table. My DB is mysql-5.0.42, and I'm
> running on apache-2.0.58/mod_perl2
>
> 2. After resolving the above issue, what's the best way to bring my
> old rt database over. Ideally, I'd like to run a mysqldump of the old
> database and import it into the new server.  At that point, I'd
> imagine I'd need to run some sort of db schema update script, correct?
>  I didn't see anything obvious in the wiki about this.
>
> Thank you
> -Erik
>
> --
> Erik Anderson
> http://andersonfam.org
> ___
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:
>
> If you sign up for a new RT support contract before December 31, we'll
> take
> up to 20 percent off the price. This sale won't last long, so get in
> touch today.
> Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.
>
>
> 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
>


-- 
Erik Anderson
http://andersonfam.org
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch 
today. 
Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.


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] Two questions regarding an upgrade installation

[Patterson, Craig]

Check out the README that is included with the rt tar.  

Basically you need to...
1.  cd into the directory that you unpacked the rtX.X.X.tar into(not the
folder you installed rt into).  

2. ls the etc/upgrade folder.  

3.  For each folder higher than your current version
  {rt-home}/sbin/rt-setup-database --action schema --datadir
etc/upgrade/[version] --dba rt --dba-password *

  {rt-home}/sbin/rt-setup-database --action acl  --datadir
etc/upgrade/[version] --dba rt --dba-password *

  {rt-home}/sbin/rt-setup-database --action insert --datadir
etc/upgrade/[version] --dba rt --dba-password **

Depending on what variables to set in your RT_SiteConfig, you'll have to
set different options in the above commands.


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Erik
Anderson
Sent: Tuesday, October 23, 2007 12:42 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Two questions regarding an upgrade installation

All - we've been running on an install of rt-3.2.0 for several years
now and I've decided it's time to upgrade.  I have two questions so
far:

1. I've installed rt-3.6.5 on a different server and have initialized
the db.  I can get to the login page of RT and can login with the
default root user and password.  However, when I click on any of the
links in RT, I'm sent back to the login screen.

After logging in, I can see that RT sets a cookie as well as inserting
a matching row into the sessions table. My DB is mysql-5.0.42, and I'm
running on apache-2.0.58/mod_perl2

2. After resolving the above issue, what's the best way to bring my
old rt database over. Ideally, I'd like to run a mysqldump of the old
database and import it into the new server.  At that point, I'd
imagine I'd need to run some sort of db schema update script, correct?
 I didn't see anything obvious in the wiki about this.

Thank you
-Erik

-- 
Erik Anderson
http://andersonfam.org
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll
take
up to 20 percent off the price. This sale won't last long, so get in
touch today. 
Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.


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

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch 
today.
Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.


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] Two questions regarding an upgrade installation

[Erik Anderson]

All - we've been running on an install of rt-3.2.0 for several years
now and I've decided it's time to upgrade.  I have two questions so
far:

1. I've installed rt-3.6.5 on a different server and have initialized
the db.  I can get to the login page of RT and can login with the
default root user and password.  However, when I click on any of the
links in RT, I'm sent back to the login screen.

After logging in, I can see that RT sets a cookie as well as inserting
a matching row into the sessions table. My DB is mysql-5.0.42, and I'm
running on apache-2.0.58/mod_perl2

2. After resolving the above issue, what's the best way to bring my
old rt database over. Ideally, I'd like to run a mysqldump of the old
database and import it into the new server.  At that point, I'd
imagine I'd need to run some sort of db schema update script, correct?
 I didn't see anything obvious in the wiki about this.

Thank you
-Erik

-- 
Erik Anderson
http://andersonfam.org
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch 
today. 
Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.


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