[rt-users] Scrip check body of email for text
I am modifying the scrip found at http://www.gossamer-threads.com/lists/rt/users/70038#70038 posted by gle...@- and could use some help The original, true if e-mail contains 'ok' $Transaction-Content =~ /\bok\s/i; I need to make it true IF a line (any line - 1st, 2nd, etc) starts with RMA and ends with has been received An example line is: RMA-47767-1 has been received (This email is coming in from a third party, that I do NOT have much control over their setup... so there may or may not be a space at the end of the line, and I can't not control if it is the 1st line or not - it always appears as the first line of TEXT .. but I am pretty sure their system is adding a extra blank line or two at the beginning of the body) -- http://www.wikiak.org # Associate yourself with men of good quality if you esteem your own reputation; for 'tis better to be alone then in bad company.- George Washington, Rules of Civility ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] LDAP with ExternalAuth, adding autocreated users to groups
Hi, I'm trying to configure RT3.8 to authenticate via LDAP - which apprently goes well, but the users from LDAP are autocreated in rt3 without some useful properties. I'd like them to: * Automatically be assigned to a specific group * That the new user gets whatever the Let this user be granted rights checkbox does in user management Is there a way to do this? ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] LDAP with ExternalAuth, adding autocreated users to groups
Ivan Voras wrote: Hi, I'm trying to configure RT3.8 to authenticate via LDAP - which apprently goes well, but the users from LDAP are autocreated in rt3 without some useful properties. I'd like them to: * Automatically be assigned to a specific group * That the new user gets whatever the Let this user be granted rights checkbox does in user management Is there a way to do this? Not without writing code I'm afraid. This is something there have been a number of enquiries about, but as far as I am aware there hasn't been a really good solution posted anywhere. This is part of what you want: see the CurrentUser_Local.pm section in http://wiki.bestpractical.com/view/AutoCreateAndCanonicalizeUserInfo Cheers, Matthew -- Dr Matthew Seaman The Bunker, Ash Radar Station PGP: 0x60AE908C on serversMarshborough Rd Tel: +44 1304 814890 Sandwich Fax: +44 1304 814899 Kent, CT13 0PL, UK signature.asc Description: OpenPGP digital signature ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] LDAP with ExternalAuth, adding autocreated users to groups
Ivan Voras wrote:
Hi,
I'm trying to configure RT3.8 to authenticate via LDAP - which
apprently goes well, but the users from LDAP are autocreated in rt3
without some useful properties.
I'd like them to:
* Automatically be assigned to a specific group
Not currently possible unless you write the extra code.
* That the new user gets whatever the Let this user be granted
rights checkbox does in user management
This is done with:
Set($AutoCreate, {Privileged = 1});
--
Kind Regards,
__
Mike Peachey, IT
Tel: +44 114 281 2655
Fax: +44 114 281 2951
Jennic Ltd, Furnival Street, Sheffield, S1 4QT, UK
Comp Reg No: 3191371 - Registered In England
http://www.jennic.com
__
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
[rt-users] Question about changing the look and feel of RT
RT 3.8.5 on FreeBSD-6.2 using Apache 2.2.6 using mason_handler.fcgi I can not figure out how to change the color scheme of RT to be red instead of blue. I've Googled the hell out of the issue and have yet to come to a solution. I've found and replaced: /opt/rt3/share/html/NoAuth/css/web2/images/source/background-gradient.png ...with my own, which results in the top menu bar RT at a glance + New ticket in toolbar is now red. The rest of the page remains blue. I've tried changing multiple color entries in multiple .css files, but have yet to find the one that works. My HTML source refers to: link rel=stylesheet href=/NoAuth/css/web2/main-squished.css type=text/css media=all / ...but I have no main-squished.css anywhere. I've tried changing settings in /opt/rt3/share/html/NoAuth/css/web2/main.css, but have yet to find the right one. The worst part about this is that I know I've found the answer to this years ago in what was probably RT 3.0.x ro 3.1.x...and I know the answer must be out there somewhere, but just can't find it... If anyone can provide me guidance here, I would greatly appreciate it. -Jake ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Scrip check body of email for text
Hi Kevin, Check out the /m modifier. This should match what you are specifying (which is different from your example, by the way): $Transaction-Content =~ /^RMA.*has been received$/m The /m tells perl to treat the string as multiple lines and the ^$ anchors match the beginning and end of any line in the string. Your specification (and my suggestion) does not match your example because the example line ends with rather than d. If you want trailing spaces to be Ok in the line, use received\s*$ instead of received$. A line that ends with received. will not match, though. If all you want is RMA at the beginning and followed by has been received somewhere on the same line, then you could use received.*$ instead. That would allow anything to follow received and still match. Have fun! Regards, Gene Kevin Squire wrote: I am modifying the scrip found at http://www.gossamer-threads.com/lists/rt/users/70038#70038 posted by gle...@- and could use some help The original, true if e-mail contains 'ok' $Transaction-Content =~ /\bok\s/i; I need to make it true IF a line (any line - 1st, 2nd, etc) starts with RMA and ends with has been received An example line is: RMA-47767-1 has been received (This email is coming in from a third party, that I do NOT have much control over their setup... so there may or may not be a space at the end of the line, and I can't not control if it is the 1st line or not - it always appears as the first line of TEXT .. but I am pretty sure their system is adding a extra blank line or two at the beginning of the body) ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] LDAP with ExternalAuth, adding autocreated users to groups
2009/11/16 Mike Peachey mike.peac...@jennic.com:
Ivan Voras wrote:
Hi,
I'm trying to configure RT3.8 to authenticate via LDAP - which
apprently goes well, but the users from LDAP are autocreated in rt3
without some useful properties.
I'd like them to:
* Automatically be assigned to a specific group
Not currently possible unless you write the extra code.
Heh, I thought so. Somehow I don't think I'd be the only one to notice
rt3 is somewhat convoluted and unmodular :)
* That the new user gets whatever the Let this user be granted
rights checkbox does in user management
This is done with:
Set($AutoCreate, {Privileged = 1});
Ok, it's a start. With this I could just add the default properties to
the Privileged user group - are there any unforseen consequences to
this?
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Question about changing the look and feel of RT
elsif wrote:
RT 3.8.5 on FreeBSD-6.2 using Apache 2.2.6 using mason_handler.fcgi
I can not figure out how to change the color scheme of RT to be red
instead of blue.
I've Googled the hell out of the issue and have yet to come to a solution.
I've found and replaced:
/opt/rt3/share/html/NoAuth/css/web2/images/source/background-gradient.png
Not using the FreeBSD ports then...
...with my own, which results in the top menu bar RT at a glance + New
ticket in toolbar is now red.
The rest of the page remains blue.
I've tried changing multiple color entries in multiple .css files, but
have yet to find the one that works.
My HTML source refers to:
link rel=stylesheet href=/NoAuth/css/web2/main-squished.css type=text/css
media=all /
...but I have no main-squished.css anywhere. I've tried changing settings
in /opt/rt3/share/html/NoAuth/css/web2/main.css, but have yet to find the
right one.
The worst part about this is that I know I've found the answer to this
years ago in what was probably RT 3.0.x ro 3.1.x...and I know the answer
must be out there somewhere, but just can't find it...
If anyone can provide me guidance here, I would greatly appreciate it.
You should follow the 'cleanly customize' concepts, which means creating
a parallel directory tree under /opt/rt3/local/html (I think. It might be just
/opt/rt3/local) [It's /usr/local/www/rt38 if you use the ports layout.]
Under there create a directory tree like so:
mkdir -p NoAuth/css/web2/images/source
Your replacement background gradient (an 800x2 pixel PNG image) goes into:
NoAuth/css/web2/images/source/background-gradient.png
Then you need to copy the original layout.css from /opt/rt3/html/NoAuth/css/web2
into your new locally modified tree:
NoAuth/css/web2/layout.css
Edit this file to change the background colour to match the bottom end of your
gradient file -- look for this section close to the top of the file and change
as
indicated:
body {
padding:0;
margin:0;
background: #a2a2a2
url(%RT-Config-Get('WebPath')%/NoAuth/css/web2/images/background-gradient.png)
top left repeat-x ;
font-family: arial, helvetica, sans-serif;
}
Here I've changed the original blue colour (#547CCC) to a fairly light grey
(#a2a2a2)
Finally you need to copy .../NoAuth/css/web2/images/dhandler unchanged into the
equivalent position in your new local tree. Clear the mason cache and restart
apache. You should now have a customized background gradient.
Cheers,
Matthew
--
Dr Matthew Seaman The Bunker, Ash Radar Station
PGP: 0x60AE908C on serversMarshborough Rd
Tel: +44 1304 814890 Sandwich
Fax: +44 1304 814899 Kent, CT13 0PL, UK
signature.asc
Description: OpenPGP digital signature
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Question about changing the look and feel of RT
I've found web2/layout.css...
background: #547CCC
url(%RT-Config-Get('WebPath')%/NoAuth/css/web2/images/background-gradient.png)
top left repeat-x ;
...that line should be what's making the background blue.
Changing it to #FF doesn't change anything.
Commenting out the line doesn't change anything.
What am I missing here?
On Mon, 16 Nov 2009, elsif wrote:
RT 3.8.5 on FreeBSD-6.2 using Apache 2.2.6 using mason_handler.fcgi
I can not figure out how to change the color scheme of RT to be red
instead of blue.
I've Googled the hell out of the issue and have yet to come to a solution.
I've found and replaced:
/opt/rt3/share/html/NoAuth/css/web2/images/source/background-gradient.png
...with my own, which results in the top menu bar RT at a glance + New
ticket in toolbar is now red.
The rest of the page remains blue.
I've tried changing multiple color entries in multiple .css files, but
have yet to find the one that works.
My HTML source refers to:
link rel=stylesheet href=/NoAuth/css/web2/main-squished.css
type=text/css media=all /
...but I have no main-squished.css anywhere. I've tried changing settings
in /opt/rt3/share/html/NoAuth/css/web2/main.css, but have yet to find the
right one.
The worst part about this is that I know I've found the answer to this
years ago in what was probably RT 3.0.x ro 3.1.x...and I know the answer
must be out there somewhere, but just can't find it...
If anyone can provide me guidance here, I would greatly appreciate it.
-Jake
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com
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: sa...@bestpractical.com
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
[rt-users] Not sending auto response from certain from addresses
All - Is it possible for RT to add an email into a ticket, however do not send an auto response, just for certain from addresses? Thanks! ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] REALLY Confused about RT Extension ExternalAuth and LDAP
To list, I'm not an internals/Unix Admin or tech. I've been the Admin for User Support for our RT 3.6.4 installation. We successfully use LDAP Authentication. I've just been given the responsibility to install 3.8.6 in VM (RHEL 5.3). I have some Unix help. However, I have to tell my guy what to download/install. So, as I have been reading past Emails about using the plugin RT::Extension::ExteranlAuth, I have become quite confused. For example, when I look at the BestPractical Wiki site for extensions I saw this comment: Once installed, you should view the file: 3.4/3.6$RTHOME/local/etc/ExternalAuth/RT_SiteConfig.pm 3.8$RTHOME/local/plugins/RT-Auth-ExternalAuth/etc/RT_SiteConfig.pm I went to our 3.6.4 directories and didn't see anything in /local/etc at all. So, if I have been using LDAP successfully with my 3.6.4 version, what do I need to do in order to have it work in my 3.8.6 installation? Do I even need the ExternalAuth extension? If so, what files do I move over from my 3.6.4 files, if anything? My 3.6.4 RT_SiteConfig Auth settings show the following: Set($AuthMethods, ['LDAP', 'Internal']); Set($LdapExternalAuth, 1); # enable LDAP authentication/lookups Set($LdapExternalInfo, 1); Set($LdapAutoCreateNonLdapUsers, 0); So, for 3.8.6 I set up my RT_SiteConfig settings to this: # Now what follows are the settings for LDAP Authorization Set($AuthMethods, ['My_LDAP', 'Internal']); Set($ExternalAuthPriority, ['My_LDAP']); Set($ExternalInfoPriority, ['My_LDAP']); Set($LdapExternalAuth, 1); # enable LDAP authentication/lookups Set($LdapAutoCreateNonLdapUsers, 0); Set($CanonicalizeOnCreate , 0); Set($LdapTLS, 1); Set($LdapSSLVersion, 3); And my Plugin array to this: Set(@Plugins,(qw(Extension::QuickDelete RT::FM RTx::Calendar RT::Extension::Timeline RT::Authen::ExternalAuth RT::Extension::CommandByMail RT::Extension::ExtractCustomFieldValues RT::Extension::SearchResults::XLS))); I saw some bug reports on ExternalAuth v.08. Is that fixed yet? Do I even need it if I'm using LDAP? Also, for each Plugin in my array, what corresponding files do I need and where do I put them? I know this is a lot to ask, but I really need the help or I go nowhere from here. Thanks. Kenn LBNL ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Question about changing the look and feel of RT
This works perfectly.
You da man.
Funny, I would've assumed the cache info was removed upon Apache
restart...
Thanks,
-jake
On Mon, 16 Nov 2009, Matthew Seaman wrote:
elsif wrote:
RT 3.8.5 on FreeBSD-6.2 using Apache 2.2.6 using mason_handler.fcgi
I can not figure out how to change the color scheme of RT to be red instead
of blue.
I've Googled the hell out of the issue and have yet to come to a solution.
I've found and replaced:
/opt/rt3/share/html/NoAuth/css/web2/images/source/background-gradient.png
Not using the FreeBSD ports then...
...with my own, which results in the top menu bar RT at a glance + New
ticket in toolbar is now red.
The rest of the page remains blue.
I've tried changing multiple color entries in multiple .css files, but have
yet to find the one that works.
My HTML source refers to:
link rel=stylesheet href=/NoAuth/css/web2/main-squished.css
type=text/css media=all /
...but I have no main-squished.css anywhere. I've tried changing settings
in /opt/rt3/share/html/NoAuth/css/web2/main.css, but have yet to find the
right one.
The worst part about this is that I know I've found the answer to this
years ago in what was probably RT 3.0.x ro 3.1.x...and I know the answer
must be out there somewhere, but just can't find it...
If anyone can provide me guidance here, I would greatly appreciate it.
You should follow the 'cleanly customize' concepts, which means creating
a parallel directory tree under /opt/rt3/local/html (I think. It might be
just /opt/rt3/local) [It's /usr/local/www/rt38 if you use the ports layout.]
Under there create a directory tree like so:
mkdir -p NoAuth/css/web2/images/source
Your replacement background gradient (an 800x2 pixel PNG image) goes into:
NoAuth/css/web2/images/source/background-gradient.png
Then you need to copy the original layout.css from
/opt/rt3/html/NoAuth/css/web2
into your new locally modified tree:
NoAuth/css/web2/layout.css
Edit this file to change the background colour to match the bottom end of
your
gradient file -- look for this section close to the top of the file and
change as
indicated:
body {
padding:0;
margin:0;
background: #a2a2a2
url(%RT-Config-Get('WebPath')%/NoAuth/css/web2/images/background-gradient.png)
top left repeat-x ;
font-family: arial, helvetica, sans-serif;
}
Here I've changed the original blue colour (#547CCC) to a fairly light grey
(#a2a2a2)
Finally you need to copy .../NoAuth/css/web2/images/dhandler unchanged into
the
equivalent position in your new local tree. Clear the mason cache and
restart apache. You should now have a customized background gradient.
Cheers,
Matthew
--
Dr Matthew Seaman The Bunker, Ash Radar Station
PGP: 0x60AE908C on serversMarshborough Rd
Tel: +44 1304 814890 Sandwich
Fax: +44 1304 814899 Kent, CT13 0PL, UK
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] REALLY Confused about RT Extension ExternalAuth and LDAP
On Mon, 16 Nov 2009 11:46:55 -0800, Ken Crocker kfcroc...@lbl.gov said: I went to our 3.6.4 directories and didn't see anything in /local/etc at all. So, if I have been using LDAP successfully with my 3.6.4 version, what do I need to do in order to have it work in my 3.8.6 installation? Do I even need the ExternalAuth extension? If so, what files do I move over from my 3.6.4 files, if anything? I'm not sure what the LDAP auth support was in 3.6.x, I'm using the ExternalAuth plugin (v0.8) with RT 3.8.x with no issues. My 3.6.4 RT_SiteConfig Auth settings show the following: Again, not sure about 3.6's LDAP support, so I can't comment on that...but the documentation seems to imply that all LDAP auth support was moved out of RT and is now soley supported by the ExternalAuth plugin. So, for 3.8.6 I set up my RT_SiteConfig settings to this: # Now what follows are the settings for LDAP Authorization Set($AuthMethods, ['My_LDAP', 'Internal']); Set($ExternalAuthPriority, ['My_LDAP']); Set($ExternalInfoPriority, ['My_LDAP']); Set($LdapExternalAuth, 1); # enable LDAP authentication/lookups Set($LdapAutoCreateNonLdapUsers, 0); Set($CanonicalizeOnCreate , 0); Set($LdapTLS, 1); Set($LdapSSLVersion, 3); Doesn't appear correct for ExternalAuth's configuration, once you install ExternalAuth you can look at a sample config file in local/plugins/RT-Authen-ExternalAuth/etc/RT_SiteConfig.pm I'll attach a sanitized and commented snippet of my config as well that you can use as a starting point. I saw some bug reports on ExternalAuth v.08. Is that fixed yet? Do I even need it if I'm using LDAP? I haven't been bitten by any bugs in it yet, but I'm curious to know what bugs exist. Also, for each Plugin in my array, what corresponding files do I need and where do I put them? Each plugin you have should have a config and install script...any configuration they use should be in RT_SiteConfig.pm, so a fresh install of those plugins into your new RT 3.8 directory should be fine as long as you copy relevant lines over from your RT 3.6 config. ldap_config Description: Binary data ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] binary attachment corrupted when RT mails them out
Sorry for the delay; I was sidetracked in other non rt-related weidness. Jesse Vincent wrote: On Thu, Nov 05, 2009 at 03:09:56PM -0500, Mauricio Tavares wrote: Let's say someone emails a pdf (or some other kind of binary) file as an attachment to a ticket through rt. If i access the said attachment trough the rt web interface it works fine. But if I get the ticket through email (ticket is being forwarded to the AdminCC: members) and then download the attachment to see it, a lot of times is corrupted. FYI, we received a 889K PDF and the copy forwarded to AdminCC is corrupted. However a 74K .pdf file we received just after it works fine. I do not know if that is an issue with the attachment size, but I thought by having the following set on RT_SiteConfig.pm, Can you tell us a bit more about your RT? Often the Configuration - Tools - System Information page is the easiest way to capture the various bits of metadata we really need to help you figure out what's going on. -j I am sending the request info as an attachment. Incidentally, I am running 3.6.7. I know right now it is rather old on the tooth (thanks ubuntu!) but since I have not upgraded it since I installed it, I would think that eliminates those kind of errors. Loaded perl modules Perl v5.10.0 under linux Apache2::Access v2.04; Apache2::Connection v2.04; Apache2::Const v2.04; Apache2::Filter v2.04; Apache2::Log v2.04; Apache2::Module v2.04; Apache2::RequestIO v2.04; Apache2::RequestRec v2.04; Apache2::RequestUtil v2.04; Apache2::Response v2.04; Apache2::ServerRec v2.04; Apache2::ServerUtil v2.04; Apache2::Status v4.00; Apache2::SubRequest v2.04; Apache2::URI v2.04; Apache2::Util v2.04; Apache::DBI v1.07; Apache::Session v1.87; Apache::Session::Generate::MD5 v2.11; Apache::Session::Lock::MySQL v1.01; Apache::Session::MySQL v1.01; Apache::Session::Serialize::Storable v1.01; Apache::Session::Store::DBI v1.02; Apache::Session::Store::MySQL v1.04; APR v0.009000; APR::Brigade v0.009000; APR::Bucket v0.009000; APR::Const v0.009000; APR::Date v0.009000; APR::Pool v0.009000; APR::Table v0.009000; APR::URI v0.009000; APR::Util v0.009000; AutoLoader v5.63; base v2.13; bytes v1.03; Cache::Simple::TimedExpiry v0.27; Carp v1.08; CGI v3.29; CGI::Cookie v1.28; CGI::Util v1.5_01; Class::Container v0.12; Class::Data::Inheritable v0.08; Class::ReturnValue v0.55; Clone v0.30; constant v1.13; Convert::ASN1 v0.22; Cwd v3.2501; Data::Dumper v2.121_14; Date::Format v2.22; Date::Parse v2.27; DBD::mysql v4.008; DBI v1.607; DBIx::SearchBuilder v1.54; DBIx::SearchBuilder::Union v0; DBIx::SearchBuilder::Unique v0.01; Devel::StackTrace v1.20; Devel::StackTraceFrame v1.20; Digest::base v1.00; Digest::MD5 v2.36_01; DynaLoader v1.08; Encode v2.23; Encode::Alias v2.07; Encode::Config v2.04; Encode::Encoding v2.05; Errno v1.1; Exception::Class v1.26; Exception::Class::Base v1.2; Exporter v5.62; Exporter::Heavy v5.62; Fcntl v1.06; File::Basename v2.76; File::Glob v1.06; File::Path v2.04; File::Spec v3.2501; File::Spec::Unix v3.2501; File::Temp v0.18; FileHandle v2.01; HTML::Element v3.23; HTML::Entities v3.57; HTML::Formatter v2.04; HTML::FormatText v2.04; HTML::Mason v1.39; HTML::Mason::ApacheHandler v1.69; HTML::Mason::Exception v1.1; HTML::Mason::Exception::Abort v1.1; HTML::Mason::Exception::Compilation v1.1; HTML::Mason::Exception::Compilation::IncompatibleCompiler v1.1; HTML::Mason::Exception::Compiler v1.1; HTML::Mason::Exception::Decline v1.1; HTML::Mason::Exception::Params v1.1; HTML::Mason::Exception::Syntax v1.1; HTML::Mason::Exception::System v1.1; HTML::Mason::Exception::TopLevelNotFound v1.1; HTML::Mason::Exception::VirtualMethod v1.1; HTML::Mason::Exceptions v1.43; HTML::Parser v3.59; HTML::Scrubber v0.08; HTML::Tagset v3.20; HTML::TreeBuilder v3.23; HTTP::Date v5.810; I18N::LangTags v0.35; I18N::LangTags::Detect v1.03; integer v1.00; IO v1.23_01; IO::File v1.14; IO::Handle v1.27; IO::InnerFile v2.110; IO::Lines v2.110; IO::ScalarArray v2.110; IO::Seekable v1.1; IO::Select v1.17; IO::Socket v1.30_01; IO::Socket::INET v1.31; IO::Socket::SSL v1.18; IO::Socket::UNIX v1.23; IO::WrapTie v2.110; IPC::Open2 v1.02; IPC::Open3 v1.02; lib v0.5565; List::Util v1.19; Locale::Maketext v1.12; Locale::Maketext::Fuzzy v0.10; Locale::Maketext::Lexicon v0.75; Locale::Maketext::Lexicon::Gettext v0.16; Log::Dispatch v2.22; Log::Dispatch::Base v1.09; Log::Dispatch::File v1.22; Log::Dispatch::Output v1.26; Log::Dispatch::Screen v1.17; Log::Dispatch::Syslog v1.18; Mail::Address v2.04; Mail::Field v2.04; Mail::Field::AddrList v2.04; Mail::Field::Date v2.04; Mail::Field::Generic v2.04; Mail::Header v2.04; Mail::Internet v2.04;
[rt-users] Attachment Processing
All, I am attempting to automate processing PDF and Word docs into clear text using xpdf strings so they can be posted in clear text in the RT tickets. I have two questions: 1 - Has anyone already done this already? I didn't see any obvious matches search the email lists. 2 - Do I just need to move the below files to local and start coding it out? Or is there some secret undocumented voodoo magic that would prevent me from ever being successful? /opt/rt3/share/html/Ticket/Attachment/dhandler /opt/rt3/share/html/Ticket/Attachment/WithHeaders/dhandler /opt/rt3/lib/RT/Attachment.pm Thanks, Paul Jaramillo ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Attachment Processing
On Mon, 16 Nov 2009, pjarami...@kcp.com wrote: All, I am attempting to automate processing PDF and Word docs into clear text using xpdf strings so they can be posted in clear text in the RT tickets. I have two questions: 1 - Has anyone already done this already? I didn't see any obvious matches search the email lists. I'm in the process of doing this for screenshots. My users tend to send those in as BMPs. I'd rather use PNG for filesize reasons among others. Right now my solution is to ask people to run their screenshots through a CGI script that converts whatever you throw at it into a PNG. I like your idea of doing something like this automatically and eagerly await the results of your experiments. 2 - Do I just need to move the below files to local and start coding it out? Or is there some secret undocumented voodoo magic that would prevent me from ever being successful? /opt/rt3/share/html/Ticket/Attachment/dhandler /opt/rt3/share/html/Ticket/Attachment/WithHeaders/dhandler /opt/rt3/lib/RT/Attachment.pm I haven't a clue where to begin. -- David Griffith dgri...@cs.csubak.edu A: Because it fouls the order in which people normally read text. Q: Why is top-posting such a bad thing? A: Top-posting. Q: What is the most annoying thing in e-mail? ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] RT Upgrade failing from 3.6.6 to 3.8.6
Ok I've been fighting this forever and its really starting to get to me.
I'm trying to upgrade RT and I'm at the step where I'm supposed to
upgrade the database to a certain point before applying a schema.
The command to run is:
/opt/rt3/sbin/rt-setup-database --prompt-for-dba-password --action
upgrade
It then attempts to connect as rt_user. I give it the password, proceed
through the prompts and then get:
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 106
Connect Failed Access denied for user 'rt_user'@'localhost' (using
password: YES)
at /opt/rt3/sbin/../lib/RT.pm line 204
So basically, it appears that my password is incorrect, HOWEVER, I can
connect to mysql using the exact user and password. Its almost like the
perl script is NOT taking the prompts.
Hope someone can help.
-Josh
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT Upgrade failing from 3.6.6 to 3.8.6
Hi Tom, Yes I tried connecting to mysql directly from localhost and that worked: [jbar...@help01 ~]$ mysql -u rt_u...@localhost -p Enter password: ERROR 1045 (28000): Access denied for user 'rt_u...@localhos'@'localhost' (using password: YES) [jbar...@help01 ~]$ mysql -u rt_user -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 138 Server version: 5.0.77 Source distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql exit; Bye [jbar...@help01 ~]$ The first connection failed when I specified localhost but connecting directly and specifying no host worked fine. Just to verify it was connecting to localhost I deliberately typed the password wrong and it showed me using rt_u...@localhost -Josh -Original Message- From: Tom Lahti [mailto:t...@bitstatement.net] Sent: Monday, November 16, 2009 5:25 PM To: Barron, Josh Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] RT Upgrade failing from 3.6.6 to 3.8.6 Connect Failed Access denied for user 'rt_user'@'localhost' (using password: YES) So basically, it appears that my password is incorrect, HOWEVER, I can connect to mysql using the exact user and password. Its almost like the perl script is NOT taking the prompts. Connecting at localhost? In MySQL, the user 'rt_user'@'something-else' is not the same user as 'rt_user'@'localhost'. -- -- Tom Lahti, SCMDBA, LPIC-1 BIT LLC (425)251-0833 x 117 http://www.bitstatement.net/ -- ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT Upgrade failing from 3.6.6 to 3.8.6
Connect Failed Access denied for user 'rt_user'@'localhost' (using password: YES) So basically, it appears that my password is incorrect, HOWEVER, I can connect to mysql using the exact user and password. Its almost like the perl script is NOT taking the prompts. Connecting at localhost? In MySQL, the user 'rt_user'@'something-else' is not the same user as 'rt_user'@'localhost'. -- -- Tom Lahti, SCMDBA, LPIC-1 BIT LLC (425)251-0833 x 117 http://www.bitstatement.net/ -- ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT Upgrade failing from 3.6.6 to 3.8.6
Try Yes I tried connecting to mysql directly from localhost and that worked: [jbar...@help01 ~]$ mysql -u rt_u...@localhost -p Enter password: ERROR 1045 (28000): Access denied for user 'rt_u...@localhos'@'localhost' (using password: YES) [jbar...@help01 ~]$ mysql -u rt_user -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 138 Server version: 5.0.77 Source distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql exit; Bye [jbar...@help01 ~]$ On *nix, mysql programs read startup options from the following in order: /etc/my.cnf SYSCONFDIR/my.cnf $MYSQL_HOME/my.cnf The file specified with --defaults-extra-file, if any ~/.my.cnf If any of these exist, and there is a [mysql] or [client] section that contains a host=... line, then mysql -u rt_user -p will connect to that host, not localhost. To force a localhost connection, do: mysql -h localhost -u rt_user -p What I'm getting at is: are you sure your MySQL instance for RT is on localhost? -- -- Tom Lahti, SCMDBA, LPIC-1 BIT LLC (425)251-0833 x 117 http://www.bitstatement.net/ -- ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Not sending auto response from certain from addresses
You probably need to check this out; http://wiki.bestpractical.com/view/OnCreateAutoReplyException -- Regards, Aaron On Tue, Nov 17, 2009 at 7:45 AM, Tyler Hall ty...@tylerhall.net wrote: All - Is it possible for RT to add an email into a ticket, however do not send an auto response, just for certain from addresses? Thanks! ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 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: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Scrip Question
Thanks, That was exactly as I needed. On Fri, Nov 13, 2009 at 6:46 PM, Ruslan Zakirov ruslan.zaki...@gmail.comwrote: Hello Aaron, $txn-Content returns text of the comment/reply, but if you need all attachements then you should walk $txn-Attachments collection. On Fri, Nov 13, 2009 at 6:18 AM, Aaron Guise aa...@guise.net.nz wrote: Hi All, Silly question but, how can I access the Attachments for a related Transaction via a scrip? I am wanting to collect a piece out of the plaintext content to populate a CF on comment. -- Regards, Aaron ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com -- Best regards, Ruslan. -- Regards, Aaron ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Attachment Processing
On Mon, Nov 16, 2009 at 17:03, pjarami...@kcp.com wrote: All, I am attempting to automate processing PDF and Word docs into clear text using xpdf strings so they can be posted in clear text in the RT tickets. I have two questions: 1 - Has anyone already done this already? I didn't see any obvious matches search the email lists. 2 - Do I just need to move the below files to local and start coding it out? Or is there some secret undocumented voodoo magic that would prevent me from ever being successful? /opt/rt3/share/html/Ticket/Attachment/dhandler /opt/rt3/share/html/Ticket/Attachment/WithHeaders/dhandler /opt/rt3/lib/RT/Attachment.pm Seems like a better place to do this would be between the MTA and rt-mailgate, where you look for attachments of specific MIME types, and then create a corresponding text version. IIRC there's something on the wiki to render html to text, and that would be a good place to start. Otherwise, I'd do it in a scrip at creation. -- Cambridge Energy Alliance: Save money. Save the planet. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] error on preferences page after upgrading from 3.8.5 to 3.8.6
Error on preferences page: Can't locate object method date_format_full via package DateTime::Locale::en at /opt/rt3/bin/../lib/RT/Date.pm line 659. Error in the error_log: FastCGI: server /opt/rt3/bin/mason_handler.fcgi stderr: Use of uninitialized value in hash element at /opt/rt386/share/html/Widgets/Form/Select line 120., referer: https://rt.warpdrive.net/Admin/ Running on CentOS 4.8 and mysql-4.1.22 and httpd-2.0.52 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
