Re: [rt-users] Looking for users of RT 4.4 that use the Asset feature

[Darin Perusich]

Sadly I'm no longer using RT, however at my previous employer my team
was using to for IT Support, numerous software development project,
and asset management. I was using the Puppet configuration management
system and integrated it with Assets-Import-CSV to automate adding and
updating of computers as they were provisioned in the environment.
This allowed for further integration with RT::Extension::Nagios to
associate system issues with your assets, which provides a rich
history of issues for systems.

IMO it's a natural fit if you're already using RT for tracking issues
and helpdesk requests, it allows you to keep all that information in a
single repository.
--
Later,
Darin


On Tue, Nov 29, 2016 at 2:51 PM, john boris  wrote:
> Good Day,
> My department is looking to replace our current Ticket/asset management
> system. I have been using RT on a small basis to handle my own Support
> requests and used the Asset Management add on (pre 4.4). Our current system
> used to have an agent that would populate the data set for us but lacked
> some of the info we needed. We were at the mercy of the company to add
> features.
>
> I am hoping we can roll our own Powershell script to gather the info we need
> and with some other tweaks we can roll our own.My question to the list is if
> anyone is using RT 4.4 with the Asset Management feature and would like to
> share their experience with it. I am putting together the proposal to use RT
> for this replacement. As a ticket system I think it is an easy sell but the
> Asset portion is my tough sell.
>
> Anyone who wants to reply can reply off list unless it you feel it is
> relevant to stay on the list. I will post what happens when completed
> (albeit that might not be for a month or so).
>
> TIA
>
> --
> John J. Boris, Sr.
>
>
> -
> RT 4.4 and RTIR training sessions, and a new workshop day!
> https://bestpractical.com/training
> * Los Angeles - January 9-11 2017
-
RT 4.4 and RTIR training sessions, and a new workshop day! 
https://bestpractical.com/training
* Los Angeles - January 9-11 2017

Re: [rt-users] Mapping users of a particular user database under OpenAM(SSO) to a specific queue

[Darin Perusich]

I don't see how you're going to be able to leverage OpenAM for this
when it's something that really needs to be done with RT's queue
permissions. I have to assume you're using the OpenAM web policy agent
for Apache, which is only going to allow you to permit/deny access
based on URI, which isn't how RT presents it's queues.

IMO you're complicating this by attempting to bolt on OpenAM onto
something that already provides very fine grained permission.
--
Later,
Darin


On Wed, Nov 9, 2016 at 7:58 AM, Maneesh Kumar  wrote:
> Hello members,
>
> We also have a requirement of mapping users of a particular user database
> under OpenAM(SSO) to a specific queue. This is required to enable users to
> have access to a specific queue rather than all queues. The access need to
> be enabled for creation of tickets and thereafter for listing his/her open
> and closed tickets.
>
> Please let me know if this is possible and steps to meet this requirement.
>
>
> Maneesh Kumar
>
>
> National PARAM Supercomputing Facility
>
> HPC Infrastructure and Ecosystem Group
> Centre for Development of Advanced Computing
>
> ---
> [ C-DAC is on Social-Media too. Kindly follow us at:
> Facebook: https://www.facebook.com/CDACINDIA & Twitter: @cdacindia ]
>
> This e-mail is for the sole use of the intended recipient(s) and may
> contain confidential and privileged information. If you are not the
> intended recipient, please contact the sender by reply e-mail and destroy
> all copies and the original message. Any unauthorized review, use,
> disclosure, dissemination, forwarding, printing or copying of this email
> is strictly prohibited and appropriate legal action will be taken.
> ---
>
> -
> RT 4.4 and RTIR training sessions, and a new workshop day!
> https://bestpractical.com/training
> * Los Angeles - January 9-11 2017
-
RT 4.4 and RTIR training sessions, and a new workshop day! 
https://bestpractical.com/training
* Los Angeles - January 9-11 2017

Re: [rt-users] How to backup/dump Postgre SQL

[Darin Perusich]

On Fri, Aug 5, 2016 at 7:05 AM, Martin Petersson  wrote:

> Then i tried:
> root@rt:~# su postgres
> postgres@rt:/root$ pg_dump rtdb > rtdb-backup
> bash: rtdb-backup: Access denied
>
> What do i have to do to create a backup of the database?
>

Not be in roots home directory when you run pg_dump.

--
Later,
Darin
-
RT 4.4 and RTIR Training Sessions https://bestpractical.com/training
* Los Angeles - September, 2016

[rt-users] "Projects" grouping

[Darin Perusich]

Hello All,

I'd like to be able to classify a group a tickets, mark them as a
"project", and have that project be accessible under a Projects menu
available along the top of the RT interface which I can then select
and display only those tickets. For those that have used Jira I'm
basically looking to mimic, to an extent, how Projects are
treated/displayed in their ServiceDesk offering. I realize I "could"
create additional queues to facilitate this behaviour, however I do
not want the overhead associated with creating new queues, and want
these tickets to live under an existing queue.

I didn't see any existing extensions which provide this functionality
and am curious to know if anyone has wanted this behaviour and how
they've addressed it. Also, if this is something Best Practical has
implemented or has thoughts on I'd be interested in engaging them for
some custom development.

Thanks!

--
Later,
Darin

Re: [rt-users] General reminder emails

[Darin Perusich]

You can create a dashboad to accomplish this.

https://www.bestpractical.com/docs/rt/4.2/dashboards.html
https://www.bestpractical.com/docs/rt/4.2/rt-email-dashboards.html
--
Later,
Darin


On Tue, Apr 7, 2015 at 10:38 AM, fleon  wrote:
> Hello, i currently have the following on my crontab to notify me every day at
> 2pm of opened or new tickets:
>
> 0 14 * * * root /opt/rt4/bin/rt-crontool --search RT::Search::FromSQL
> --search-arg "Queue = 'apoyo' AND Owner != 'Nobody' AND (  Status = 'open'
> OR Status = 'new' ) AND Created < '1 day ago'" --action RT::Action::Notify
> --action-arg Owner,AlwaysNotifyActor --template 'Recordatorio' --transaction
> first
>
> My issue is that i get a email for each ticket and i would like something
> more advanced, for example receiving just one mail with a list of these
> tickets.
>
> I am thinking the email should have a link to each ticket along with the
> ticket description
>
> Does RT come with something like this built in or would it require some
> coding? I don't really know perl but if at least i get some pointers
> regarding outputting the list of tickets in just one email maybe i can edit
> a template based on existing code. I am seeing
> RT::Search::ActiveTicketsInQueue and i don't know if that's relevant, but
> don't know if a template can handle complete perl
>
>
>
>
> --
> View this message in context: 
> http://requesttracker.8502.n7.nabble.com/General-reminder-emails-tp59838.html
> Sent from the Request Tracker - User mailing list archive at Nabble.com.

Re: [rt-users] Raising the standard of passwords in our RT instance

[Darin Perusich]

Switching to an alternate authentication source, like LDAP, is
probably the only way you're going to enforce any type of password
policy.
--
Later,
Darin


On Tue, Feb 24, 2015 at 3:27 AM, Fredrik Rambris
 wrote:
> Is there a way to check new passwords against a policy?
> I don't want users being able to change their password to weak ones like
> 123456 och Password123 etc.
>
> Also... what is the recommended way to change all users passwords in one go?
> --
> Fredrik Rambris 
> CDON IT
> Google Talk: fredrik.ramb...@cdon.com
> Telefon: 0700-807 626
> PGP: 01C1 B593 3394 3739 168F  37BB BD20 7D3A 54AB 5A3A
>
> [CDON.COM] 

[rt-users] associating tickets with an asset

[Darin Perusich]

Hello All,

I'd like to automatically associate tickets/alerts created by the
RT-Extension-Nagios with host the alert was created for, this will allow me
to easy see all the "issues" a given host has had. In my "Systems" catalog
I map the asset Name -> CF.fqdn so I'm hope it should be pretty straight
forward to create the association. I'm also using the CommandByMail
extension so  that can be leveraged too.

I haven't started digging into this yet but figured I'd ask before getting
started.

Thanks!

--
Later,
Darin

Re: [rt-users] RT not sending outgoing emails

[Darin Perusich]

Are you running postfix in a chroot? If so perhaps the chroot needs to
be updated.
--
Later,
Darin


On Fri, Nov 7, 2014 at 1:48 PM,   wrote:
> Hello All,
>
> I'm having a weird problem where RT can't send out going emails.  I'm using
> Postfix and running sendmail command from the shell works fine, just
> whenever a new ticket gets created or a comment was added, RT is not able to
> send outgoing emails.
>
> On the web interface, it says:
> The RT System itself - Sending the previous mail has failed. Please contact
> your admin, they can find more details in the logs.
>
> In syslogs, the following error is thrown:
> Nov  7 09:04:30 *** postfix/sendmail[30696]: fatal: file
> /etc/postfix/main.cf: parameter setgid_group: unknown group name: postdrop
>
> At first I thought a misconfigured postfix is causing the problem, but again
> I can run sendmail command from the shell and it sends out email with no
> problem.
>
> I do have the postdrop group in  my /etc/group file.
>
> What's weird is there is no "setgid_group" in file /etc/postfix/main.cf.
>
> Below is output of postconf -n:
>
> alias_database = hash:/etc/aliases
> alias_maps = hash:/etc/aliases
> append_dot_mydomain = no
> biff = no
> config_directory = /etc/postfix
> inet_interfaces = all
> inet_protocols = ipv4
> mailbox_size_limit = 0
> mydestination = [domain], [domain], localhost
> myhostname = [domain]
> mynetworks = 127.0.0.0/8 [:::127.0.0.0]/104 [::1]/128
> myorigin = /etc/mailname
> readme_directory = no
> recipient_delimiter = +
> relayhost = [some ip]
> smtp_tls_session_cache_database = btree:${data_directory}/smtp_scache
> smtpd_banner = $myhostname ESMTP I.T., have you tried turning it off and on
> again?
> smtpd_client_restrictions = reject_rbl_client bl.spamcop.net,
> reject_unauth_pipelining, permit
> smtpd_data_restrictions = reject_unauth_pipelining, permit
> smtpd_helo_required = yes
> smtpd_helo_restrictions = reject_invalid_helo_hostname,
> reject_non_fqdn_helo_hostname, reject_unauth_pipelining, permit
> smtpd_recipient_restrictions = reject_non_fqdn_recipient,
> reject_unknown_recipient_domain, reject_unauth_destination,
> reject_unauth_pipelining, permit_auth_destination, permit_mynetworks
> smtpd_timeout = 30s
> smtpd_tls_cert_file = /etc/ssl/certs/ssl-cert-snakeoil.pem
> smtpd_tls_key_file = /etc/ssl/private/ssl-cert-snakeoil.key
> smtpd_tls_session_cache_database = btree:${data_directory}/smtpd_scache
> smtpd_use_tls = yes
>
>
> I'm running RT 4.2.8 on a Debian Wheezy box with MySQL server.   Anyone has
> any insight to my problem?   Any suggestions is greatly appreciated!
>
> Livy

Re: [rt-users] a configuration manager/plugin for RT

[Darin Perusich]

Well if you were using Puppet there's a Request Tracker module,
'puppet module search darin-rt', which you could utilize for many
aspects to setting up RT, package and plugin installation, creating
queues, groups, etc. Currently it doesn't manage things configurations
like RT_SiteConfig.pm, beyond ensuring correct permissions, but
extending it for that wouldn't be difficult. The module fully supports
openSUSE/SLES systems but I'll gladly access pull requests if someone
what's to extend it, which should be straight forward.



--
Later,
Darin


On Tue, Jul 15, 2014 at 9:04 AM, Al Joslin  wrote:
> Am I correct in thinking that there is no easy way to transfer configuration 
> changes from one RT installation (test/dev) to another (prod) ?
>
> Unless someone has already written a plugin that will programmatically apply 
> sets of configuration changes, (or, silicon gods willing, it could diff 
> installations?)
>
> I find myself doing an awful lot of configuration as I learn RT and set it up 
> for different groups with different needs within our company -- and I 
> realized with dismay that I'm going to have to build up a clean install and 
> re-do only the required configs for a production version...  Not having kept 
> a log of what I tried and marking those attempts that worked, it's going to 
> be a bit of a slog.
>
> So, are there any suggestions or best practice references that anyone can 
> give ?
>
> thanks
> al;
>
> --
> RT Training - Boston, September 9-10
> http://bestpractical.com/training
-- 
RT Training - Boston, September 9-10
http://bestpractical.com/training

Re: [rt-users] Help with mySQL query to prune RT3 database before upgrading to RT 4.2.5

[Darin Perusich]

http://requesttracker.wikia.com/wiki/Shredder
--
Later,
Darin


On Thu, Jun 19, 2014 at 12:56 PM, Lists  wrote:
> Hi,
>
> As I have posted recently, I am working on upgrading our current production
> RT 3.8.1 to RT 4.2.5
>
> I have a working copy of RT 3.8.1 on my test server including a copy of our
> current production database which is over 18 gig of old data.  I have
> imported this database into RT 4 and when I run make upgrade-database
> against the RT4 database, it runs a while and then dies with a message that
> the script was killed.
>
> What I would like to be able to do before our "real" production upgrade is
> to wipeout everything from a given date back, including objects/attachments
> or anything associated with tickets older than 3 years.  Our current
> production RT3 database, in all it's glory will be archived for posterity.
> I was not the original admin of our RT system, so I am still on the learning
> curve and not completely familiar with all of the database tables and how
> they are linked.
>
> Will RT:Shredder do this or do I need to use a custom mysql query to catch
> everything?
>
> Thanks,
>
> Dave
>
>
>
>
> --
> RT Training - Boston, September 9-10
> http://bestpractical.com/training
-- 
RT Training - Boston, September 9-10
http://bestpractical.com/training

Re: [rt-users] Problem with attachment size limits

[Darin Perusich]

what's the mysql max_allowed_packet set to?

Also RT doesn't use PHP, it's written in perl so any php setting would
have no effect.
--
Later,
Darin


On Thu, May 29, 2014 at 4:04 PM, Duncan Napier  wrote:
> Hi,
>
> I'm running RT 4.0.8, Apache 2.2.24, on CentOS 6.4 (final) with Mysql 5.1.67-1
>
> I cannot attach files larger in size than a couple of hundred kb to tickets.
>
> Yes ... I've changed made all the upload max size parameters that I'm aware 
> of, restarted apache and restarted the server:
>
> php.ini:
> post_max_size = 8M
> upload_max_filesize = 4M
>
> conf.d/fcgid.conf:
> FcgidMaxRequestLen 400
>
> RT_SiteConfig.pm:
> Set($MaxAttachmentSize, 10_000_000);
> Set($DropLongAttachments, 10_000_000);
>
> Problem persists. Anyone know what I'm missing here?
> --
> RT Training - Boston, September 9-10
> http://bestpractical.com/training
-- 
RT Training - Boston, September 9-10
http://bestpractical.com/training

Re: [rt-users] Assets for RT versus RTx::AssetTracker

[Darin Perusich]

RTx::AssetTracker is no longer being maintained and only "work" due to
people hacking it just enough so it does. Assets for RT is maintained
and supported by Best Practical...enough said ;-)
--
Later,
Darin


On Tue, May 20, 2014 at 1:12 PM, Duncan Napier  wrote:
> Hi,
>
> Can anyone summarize the advantages of the new Assets for RT versus those of 
> RTx::AssetTracker? I have been using RT-AssetTracker version 2.0.0b4 on RT 
> 4.0.8 and it seems adequate for most my needs. Can anyone suggest what 
> benefits I would be able to leverage from switching to the new Assets for RT?
>
>   Duncan.
>
>
> --
> RT Training - Boston, September 9-10
> http://bestpractical.com/training
-- 
RT Training - Boston, September 9-10
http://bestpractical.com/training

Re: [rt-users] RT::Authen::ExternalAuth LDAPS

[Darin Perusich]

Is the CA certificate which signed your LDAP servers certs on your RT
host? It would need to be installed in /etc/ssl/certs or
/etc/pki/trust/anchors and hashed to be trusted.
--
Later,
Darin


On Tue, Mar 4, 2014 at 12:29 PM, Dewhirst, Rob  wrote:
> I am successfully authenticating via LDAP (cleartext) over TCP 389
> using RT::Authen::ExternalAuth
>
> However, once I change:
>
> Set($ExternalServiceUsesSSLorTLS,1);
>
> and in the ExternalSettings for My_LDAP:
>
> 'tls'   =>  1,
> 'ssl_version'   =>  3,
>
> It still authenticates (successfully) over TCP 389.
>
> I noticed someone else had a similar problem but was lacking
> Net::SSLeay.  Not my case here (I don't see how you can use Net::LDAP
> without Net:SSLeay)
>
> [root@rtir-test ~]# cpan -i Net::SSLeay
> CPAN: Storable loaded ok (v2.20)
> Reading '/root/.cpan/Metadata'
>   Database was generated on Mon, 03 Mar 2014 20:17:02 GMT
> CPAN: Module::CoreList loaded ok (v2.18)
> Net::SSLeay is up to date (1.58).
> [root@rtir-test ~]#
>
> I have debug logging enabled in RT, but it doesn't seem to tell me
> anything useful since nothing is failing.
>
> RT-Authen-ExternalAuth-0.17
> --
> RT Training London, March 19-20 and Dallas May 20-21
> http://bestpractical.com/training
-- 
RT Training London, March 19-20 and Dallas May 20-21
http://bestpractical.com/training

[rt-users] enable notification when metadata is modified

[Darin Perusich]

Hello,

Is it possible to enabled notifications when the metadata of a ticket
is modified? Ideally I'd like to enable this on a queue by queue
basis.

Thanks!

--
Later,
Darin
-- 
RT Training London, March 19-20 and Dallas May 20-21
http://bestpractical.com/training

Re: [rt-users] link to queue from ticket

[Darin Perusich]

Having Queue name in Basics clickable would be perfect!
--
Later,
Darin


On Thu, Nov 7, 2013 at 3:33 PM, Kevin Falcone  wrote:
> On Thu, Nov 07, 2013 at 03:22:06PM -0500, Darin Perusich wrote:
>> My RT install has a lot of queue's, 30+, and i find that while working
>> on a ticket in queue10, I want to quickly get back to the top-level of
>> said queue without having to click Home, find queue under Quick
>> search. Really I'd like a link in the ticket to do this.
>>
>> Is there a way to accomplish this easily?
>
> I'd totally merge a branch for 4.4 that made the Queue name in Basics
> clickable (and have thought about writing it myself).
>
> Depending on how you navigated to the ticket, you may also find
> Search -> Tickets -> Current Search available and gets you back to
> your working list.
>
> -kevin

[rt-users] link to queue from ticket

[Darin Perusich]

Hello All,

My RT install has a lot of queue's, 30+, and i find that while working
on a ticket in queue10, I want to quickly get back to the top-level of
said queue without having to click Home, find queue under Quick
search. Really I'd like a link in the ticket to do this.

Is there a way to accomplish this easily?

thanks!

--
Later,
Darin

Re: [rt-users] How to use JSGantt ?

[Darin Perusich]

There's a Gantt Chart link on the Links block of the ticket. You also
didn't say whether you added RT::Extension::JSGantt to the Plugins
section of RT_SiteConfig.pm
--
Later,
Darin


On Thu, Nov 7, 2013 at 1:53 PM, Lixus Zoran  wrote:
> Hello,
>
> I am  using RT 4.0.7 on debian 7 wheezy using the debian RT package.
>
> I would like to use JSGantt and got a copy by git clone from here
> https://github.com/bestpractical/rt-extension-jsgantt/
>
> This got set in my environment
>
> export PERL5LIB=/usr/share/request-tracker4/lib
> export RTHOME=/etc/request-tracker4
>
> I followed the instructions in README (twice) and I think i set it up 
> correctly:
>
> root@node:/opt/install/rt/rt-extension-jsgantt/#  perl Makefile.PL
> Using RT configuration from /usr/share/request-tracker4/lib/RT.pm:
> ./etc   => 
> /usr/local/share/request-tracker4/plugins/RT-Extension-JSGantt/etc
> ./html  => 
> /usr/local/share/request-tracker4/plugins/RT-Extension-JSGantt/html
> ./lib   => 
> /usr/local/share/request-tracker4/plugins/RT-Extension-JSGantt/lib
> Writing Makefile for RT::Extension::JSGantt
> Writing MYMETA.yml
>
> root@node:/opt/install/rt/rt-extension-jsgantt/#  make
> Skip blib/lib/RT/Extension/JSGantt.pm (unchanged)
> Manifying blib/man3/RT::Extension::JSGantt.3pm
>
> root@node:/opt/install/rt/rt-extension-jsgantt/#  make install
> Appending installation info to 
> /usr/local/share/request-tracker4/man/perllocal.pod
>
> After restarting apache the webinterface at /Admin/Tools/Configuration.html 
> shows this:
>
> JSGanttOptions   {
>   'ShowDuration' => 1,
>   'DefaultDays' => 7,
>   'NullDatesColor' => 333,
>   'DefaultFormat' => 'day',
>   'ShowProgress' => 1,
>   'WorkingHoursPerDay' => 8,
>   'ShowOwner' => 1
> }
>
> So I believe it should work.
>
> But I can't find any hint in the GUI how to use JSGantt or even see somthing 
> about it.
> I guess I have to have to have "Dates" set for my ticks like "Starts" and 
> "Due" ?
> And do a search with special "Display Columns"  ?
> Or JSGantt needs to be enabled for every queue ?
>
> On what URL do I get something like this:
> http://www.bestpractical.com/static/images/screenshots/rt-extensions/rt-extension-jsgantt.png
>
>
> Thanks a lot
> Lixus
>

[rt-users] including files in RT_SiteConfig.pm

[Darin Perusich]

Hello All,

Is it possible to include other files which contain config options in
RT_SiteConfig.pm? Was hoping something like this is possible, like how
you'd use Include in apache configs, to make it more readable.

Thanks!

--
Later,
Darin

[rt-users] Enter text after selecting from a list for a CustomFields

[Darin Perusich]

Hello All,

I have a CF which is a dropdown and when selecting one of those
options I'd like to be presented a text box so the user can "add one
value". Is there a way to do this or is it going to require something
custom?

thanks!

--
Later,
Darin

[rt-users] Fully removing RTx::AssetTracker

[Darin Perusich]

Hello All,

I want to fully expunge any RTx::AssetTracker data from my RT
installation in preparation for the RT Assets extension. This data's
junk/outdated so I plan to start from scratch. I've dropped all the
tables/sequences that it creates however there are still things like
CustomFields floating around that I'd like get rid of.  I know I can
disable those fields but I'd rather shred them so they're fully gone.
How can I remove these instead of simply disabling them?

Thanks1

--
Later,
Darin

-- 
RT Training in New York, October 8th and 9th: http://bestpractical.com/training

Re: [rt-users] Help with GNATT RT Extension: Doesn't show up!

[Darin Perusich]

Under Links next to Graph when viewing a ticket.

On Fri, Aug 2, 2013 at 10:38 AM, window camera  wrote:
> May I ask where the GNATT extension is supposed to show up in the GUI?


--
Later,
Darin

Re: [rt-users] Problems with Perl modules on CentOS

[Darin Perusich]

Perhaps I'm biased being the maintainer but all you have to do for
SuSE is add the devel:languages:perl repo followed by "zypper in
request-tracker" and you'll be ready to rock with request tracker. Oh,
and if you use puppet try the "darin-rt" module too ;-)

> In that context, We are suppose to pick a linux distro for our new RT. Any
> recommendation?
>

[rt-users] [Announce] Puppet Request Tracker Module

[Darin Perusich]

This is a cross-list post.

I'd like to announce the initial release of a puppet request-tracker
module, darin-rt, for managing Request Tracker. The module will
install request-tracker and database packages, install request-tracker
extensions (if packages are available in the repo), and create basic
request-tracker queues.

This is also a request for help in extending the module to support
more operating systems! Currently it only supports SuSE systems, my
distro of choice, so I'm hopeful people from the community who use RT
and Puppet will extend this module to support a more verbose set of
operating systems. If you're interested in contributing please contact
me off-list and I'll help get you up to speed.

Enjoy!

Puppet Forge: http://forge.puppetlabs.com/darin/rt
GitHub: https://github.com/deadpoint/puppet-rt
Installation: puppet module install darin-rt

--
Later,
Darin


-- 
RT Training in Seattle, June 19-20: http://bestpractical.com/training

[rt-users] making a custom field mandatory for select queues

[Darin Perusich]

Hello All,

It's is possible to make a custom field mandatory of selective queues?
Say I have a CF called "Environment" who's values are test,
development, and production which is a global CF since it may apply
any queue, but only needs to be mandatory in queue XYZ. Can this be
done?

--
Later,
Darin


-- 
RT Training in Seattle, June 19-20: http://bestpractical.com/training

[rt-users] RT::Extension::QuickUpdate feature request

[Darin Perusich]

Hello All,

I was wanting to create a feature request for
RT::Extension::QuickUpdate but there's no project for it in CPAN or
way to create github issues so I'm posting it here instead.

I'd like to see QuickUpdate extended to support PriorityAsString's if
that extension's been enabled, or provide a configuration option to
enable it. The majority of the time when setting the priority it's
done via QuickUpdate, users will try and type low|meduim|high into the
field, and it will unify the Priority display in the UI.

--
Later,
Darin


-- 
RT Training in Seattle, June 19-20: http://bestpractical.com/training

Re: [rt-users] using rt command line to check whether a queue exists

[Darin Perusich]

On Mon, May 13, 2013 at 3:14 PM, Thomas Sibley  wrote:
> On 05/13/2013 11:00 AM, Darin Perusich wrote:
>> Hello All,
>>
>> I've been playing around w/scripting the creation of queues and
>> haven't been able to figure this out. How do I use the rt command line
>> tool to list whether a queue exists or not? 'rt ls -t queue "name =
>> queue1"' throws unsupported object, "rt list -q queue1" lists the
>> tickets.
>
> ls/list is for tickets only.  You want "show":
>
> rt show queue/FooBar
> rt show queue/13
> rt show -t queue "Foo Bar"
>

Excellent...thanks!


-- 
RT Training in Seattle, June 19-20: http://bestpractical.com/training

[rt-users] using rt command line to check whether a queue exists

[Darin Perusich]

Hello All,

I've been playing around w/scripting the creation of queues and
haven't been able to figure this out. How do I use the rt command line
tool to list whether a queue exists or not? 'rt ls -t queue "name =
queue1"' throws unsupported object, "rt list -q queue1" lists the
tickets.

Ideally a command that throw's an exit code, 0=true or 1=false, would
be great but I can work w/whatever output.

Thanks!

--
Later,
Darin


-- 
RT Training in Seattle, June 19-20: http://bestpractical.com/training

Re: [rt-users] RT not emailing tickets after old exchange server decomissioning.

[Darin Perusich]

You mentioned yast2 so you're using some SuSE variant.

What's the output of "postconf relayhost"? You should see something
like 'relayhost = [new.server.com]'.

Are you able to send mail in general from the RT server? Try "echo
hello | mail y...@address.com" and check your inbox.

If you don't receive the message what's the output of "mailq"? If it's
huge don't send the whole thing to the list, one entry should be
sufficient.

Check /var/log/mail for errors, it probably contains the reason why
delivery is failing.

--
Later,
Darin


On Thu, May 9, 2013 at 3:11 PM, DeCoste, Wayne  wrote:
> Hello.
>
>
>
> We have recently migrated over to a new exchange environment. After we
> decommissioned the old server we began to have issues with mail outs from
> RT.
>
> Our linux\unix\rt admin is no longer accessible, so I am attempting to get
> mail working on this server. Please excuse my lack of knowledge and general
> unfamiliarity with the system. I’m new to working with RT.
>
>
>
> Steps so far :
>
>
>
> - Reviewed support
>
>
>
> - Run yast2 and changed the MTA outgoing mail server to our new server fqdn.
> Heres what the setting look like :
>
> MTA -> Permanent -> Outgoing Mail Server:new fqdn ->Use TLS:masquerade ->
> Accept Remote SMTP Connections (downloading: empty, \ forward root mail:
> empty).
>
>
>
> - Then rebooted the RT server. No joy.
>
>
>
> - Checked the “aliases” file in the /.etc folder. There are no references to
> my old mail server to change to the new mail server and the aliases are
> correct.
>
>
>
> - I ran the  “newaliases” command to be safe.
>
>
>
> - I am able to ping my mail server from RT
>
>
>
> - I am able to establish an smtp connection over port 25.
>
>
>
> I would welcome any suggestions on how to get ticket mailout working again.
>
>
>
>
>
> -  Wayne
>
>
>
>
> --
> RT Training in Seattle, June 19-20: http://bestpractical.com/training


-- 
RT Training in Seattle, June 19-20: http://bestpractical.com/training

[rt-users] adding "update ticket" to ticket display

[Darin Perusich]

Hello All,

I'd like to add an "update ticket" or "quick comment" element to the
ticket display so users of the webUI don't need to click Actions ->
Comment|Reply to add an update, ideally this would be placed on the
left hand side of the sceen under People. I've taken the 'Update
ticket' code from html/Ticket/ModifyAll.html and added it to
local/html/Ticket/Display.html but the pages fail to load and there
are messages in the rt.log that "Global symbol requires explicit
package name". I'm assuming this is because I need to add some
callbacks to the code but I'm not familiar with them.

Can someone give me some pointers on how to get around this, and
what's the proper way to submit the update?

Thanks!

--
Later,
Darin

[rt-users] migrate bugzilla into an existing RT installation

[Darin Perusich]

Hello All,

I'm tackling migrating an old bugzilla system into our existing RT
installation and am wondering if anyone has done this recently and has
any info, code, etc, to share? I've been reviewing the
MigrateBugzillaToRT wiki page and the bugzilla-rt-convert and I think
it'll suffice, but it's certainly going to need to be adapted and I'm
not sure how much yet.

http://requesttracker.wikia.com/wiki/MigrateBugzillaToRT

Thanks!
--
Later,
Darin

Re: [rt-users] bug tracker extensions

[Darin Perusich]

On Thu, May 2, 2013 at 1:44 PM, Ruslan Zakirov wrote:

>
>
>
> On Thu, May 2, 2013 at 8:51 PM, Darin Perusich  wrote:
>
>> Hello,
>>
>> Are the bug tracker extensions supported under RT4?
>>
>
> If you're talking about RT-BugTracker [1] then yes. Recently Thomas ported
> it and friends over RT4. However, it's specific product that is used by
> http://rt.cpan.org site and may be less suitable for others.
>
> [1] http://search.cpan.org/~ruz/RT-BugTracker-0.05/lib/RT/BugTracker.pm
>
>
>
I'm looking at migrating a bugzilla installation to RT and thought they
might be a handy addition to my RT setup.

Thanks!

[rt-users] bug tracker extensions

[Darin Perusich]

Hello,

Are the bug tracker extensions supported under RT4?

--
Later,
Darin

Re: [rt-users] RT4 and ITIL

[Darin Perusich]

On Thu, Apr 4, 2013 at 4:11 PM, Thomas Sibley  wrote:
> On 04/04/2013 02:29 AM, Bart wrote:
>> Asset management on it's own is something that we do in a different
>> system. However, I've been told that RT will come with a feature called
>> "Assets" with version 4.2. Which looks a little like the Articles
>> feature a.t.m. This could mean that you could do some asset management
>> within RT using that version. Not sure how extensive it will be, we're
>> waiting for the first RC for version 4.2 since we'd love to have this in
>> RT as well.
>
> To clarify a little: the assets feature you've heard about is being
> developed as an RT extension targeted at 4.2.  (It won't work with 4.0.)
>  It won't be included in the 4.2 releases themselves, so you'll need to
> wait for an assets RC and *then* run it against either git master or the
> latest 4.2 RC that exists at the time.
>

Will this assets extension be a replacement for AssetTracker extension?

Re: [rt-users] RT reports / statistics / charts

[Darin Perusich]

You can create a saved search which shows all tickets create within
say the last 7 days then create a dashboard to email the report to
whomever you'd like.

Search Criteria:
Queue = 'your_queue'
AND Create > '7 days ago'

--
Later,
Darin


On Mon, Mar 25, 2013 at 4:26 PM, Christine Spang
 wrote:
> What's the easiest way to generate some quick charts of e.g. tickets
> received per week? Do I need to write my own scripts? I'm using RT 4.
>
> Searching around, it seems like there's an idea that you can do some
> simple charts using dashboards, but it's not obvious to me from the UI
> how that works.
>
> thanks!
> Christine

Re: [rt-users] RT repo packages

[Darin Perusich]

On Thu, Feb 7, 2013 at 3:38 PM, Jay Ashworth  wrote:
>
> As a field report, BTW: SuSE 12.1 has no packages at all, even in Packman,
> and CentOS5 has only rt3 (of unknown release), even with epel and remi.

I'm the request-tracker package maintainer for OpenSUSE and there are
current packages, rt-4.0.10, available for OpenSUSE 11.4, 12,1 and
12.2 in the devel:languages:perl repositories. You can search all the
SuSE repositories at http://software.opensuse.org/search to find it or
use the below repo links.

http://download.opensuse.org/repositories/devel:/languages:/perl/openSUSE_11.4/
http://download.opensuse.org/repositories/devel:/languages:/perl/openSUSE_12.1/
http://download.opensuse.org/repositories/devel:/languages:/perl/openSUSE_12.2/


--
Later,
Darin


-- 
Help improve RT by taking our user survey: 
https://www.surveymonkey.com/s/N23JW9T

Re: [rt-users] Parse email address from message

[Darin Perusich]

The command-by-mail plugin will do this for you.
--
Later,
Darin



On Thu, Dec 20, 2012 at 3:07 PM, charlyc...@yahoo.com.ar <
charlyc...@yahoo.com.ar> wrote:

> Hi,
>
> I'm using rt-mailgate to download emails and then create tickets with them.
>
> On the first line of the message on the email I have the email address of
> the requestor, but by default when rt-mailgate creates the ticket, uses the
> FROM as requestor.
>
> Is it possible to have a scrip On Create that parses the email address
> (which is always on the first line of the message) and set it as
> "Requestor"?
>
> Thank you.
>
>
> 
> We're hiring! http://bestpractical.com/jobs
>
>

We're hiring! http://bestpractical.com/jobs

Re: [rt-users] Full text index with MySQL 5.6

[Darin Perusich]

On Wed, Dec 12, 2012 at 2:47 PM, Alex Vandiver wrote:

> > Is there a simple way to migrate from mySQL to postgres?
>
> Not currently.  There are community-created tools that attempt it, and
> we've been working with a few clients on a more robust solution; we
> expect that it will ship with RT 4.2.


I've used this tool with success, I also package it with request-tracker in
the OpenSuSE devel:languages:perl repo. There are also a number of
"generic" mysql to postgres tools available which I've used with success as
well, google will be your friend to find them.

http://wiki-archive.bestpractical.com/view/rt-mysql2pg

We're hiring! http://bestpractical.com/jobs

[rt-users] bulk ticket creation with support for child tickets

[Darin Perusich]

Hello All,

Is there anyway to create a large number of tickets with the ability
to set a parent/children relationships? I use RT a lot as a project
management tool with one top-level ticket with lots of child tickets,
and children of children and having a way to create these tickets
quickly would be ideal. One thought I have would be an ajax page which
interfaces with the REST interface for ticket creation.

Has anyone given this any thought or possible even have code they'd be
willing to share?

thanks!

--
Later,
Darin


Final RT training for 2012 in Atlanta, GA - October 23 & 24
  http://bestpractical.com/training

We're hiring! http://bestpractical.com/jobs

Re: [rt-users] Size of the database.

[Darin Perusich]

While my RT installation is tiny, 1gb in comparison, and migrating from 
mysql to postgres was fairly straight forward. I used the rt-mysql2ps 
script at the time with success. I have migrated other databases ranging 
in size from 1gb and 20gb using py-mysql2pgsql with great success as 
well. You mileage may very but these are a few options to try.

http://wiki-archive.bestpractical.com/view/rt-mysql2pg
http://pypi.python.org/pypi/py-mysql2pgsql

On 10/19/2012 10:57 AM, Tim Cutts wrote:
>
> On 19 Oct 2012, at 15:40, Albert Shih  wrote:
>
>> Hi all,
>>
>> When I start RT I make a big mistake, I choose mysql as database (instead
>> postgresql). I loose the feature to search inside of the ticket. But well
>> it's the past.
>
> You can implement full text searches by using Sphinx.  It's a bit of a faff, 
> but it can be made to work.  I have it working here.  And presumably we'll be 
> able to do it without Sphinx once RT works properly with MySQL 5.6, so don't 
> despair.
>
>> I knwon it's very hard to change the database. As it's very hard to decide if
>> I should break everything and make a new RT+postgresql.
>>
>> What I understand more the size of the database grow up more it's better to
>> run postgresql instead of mysql.
>>
>> I would like to known what size of mysql do you have. From what size I
>> shouldn't use mysql ?
>>
>> When I say mysql I mean «one standard» not some clustering/load-balancing 
>> installation.
>
> I haven't seen a problem here yet, and I'm running MySQL 5.1 and Sphinx 2.0.5 
> on a VM with 16GB of RAM and 2 virtual CPUs.  Database size is 300,000 
> tickets, about 33GB on disk.  I run the RT web interface on a separate VM.
>
> Like you, I wish I'd chosen Postgres instead, but I've tried migrating and 
> it's just too painful.  I'm betting on MySQL 5.6 fixing a lot of the 
> performance issues, and giving us proper full text searches into the bargain. 
>  Fingers crossed.
>
> Tim
>

-- 
Darin Perusich
Email: darin.perus...@ctg.com
Office: 716-888-3690
The information transmitted is intended only for the person or entity to which
it is addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any action
in reliance upon, this information by persons or entities other than the
intended recipient is prohibited. If you are not the intended recipient of this 
message, please contact the sender and delete this material from this computer.



Final RT training for 2012 in Atlanta, GA - October 23 & 24
  http://bestpractical.com/training

We're hiring! http://bestpractical.com/jobs

Re: [rt-users] RT-Authen-ExternalAuth - how to confirm that ssl ldap bind is used?

[Darin Perusich]

On Tue, Oct 16, 2012 at 6:46 AM, Marko Cupać  wrote:
> I have been using rt4 for some time now in plain protocols (site is on
> http, fetchmail is plain pop3, external auth is done from ldap without
> ssl). Now, I am increasing security by switching to encrypted
> protocols.
>
> Switching apache to https was easy thing to do, and I spent a few hours
> with fetchmail and certificates but it also works now.
>
> RT::Extension::LDAPimport "just worked" when switching ldaphost to
> ldaps:
>
> Set($LDAPHost,'ldaps://ldap.company.tld');
>
> Also, after setting
> Set($ExternalAuthPriority,['My_LDAP']);
> Set($ExternalInfoPriority,['My_LDAP']);
> Set($ExternalServiceUsesSSLorTLS,1);
> Set($ExternalSettings,{
> 'My_LDAP'   =>  {
> ...
> 'tls' =>  1,
> 'ssl_version' =>  3,
> ...
>  }
> }
>
> ... i can still authenticate.
>
> I can not believe this can be so simple :) Is there a way to check that
> ssl is really used?
>

Check your ldap servers logs or run wireshark/tcpdump from the RT
server and inspect the traffic.


Final RT training for 2012 in Atlanta, GA - October 23 & 24
  http://bestpractical.com/training

We're hiring! http://bestpractical.com/jobs

Re: [rt-users] Creating Tickets from forwarded emails?

[Darin Perusich]

You could install the command-by-mail plugin then you can add
requestor: email@com to the message body, amongst other things, to set
the requestor appropriately.

--
Later,
Darin


On Sun, Oct 14, 2012 at 4:50 PM, Jonathan Mills  wrote:
> Dear RT Users:
>
> Imagine an example where an external user sends an email to an employee, 
> rather than directly to RT.  The employee now wants to create a ticket on 
> behalf of the requestor in the quickest, easiest way possible.
>
> We know that there is the 'Redirect' or 'Bounce' button available in some 
> email clients.  However, it's often not an easy function to find.  It is also 
> no longer a default function of Thunderbird, at all, in any recent version of 
> that popular client.  Asking employees to modify Thunderbird with plugins, 
> etc, to enable a 'Redirect' button would pose an insurmountable challenge to 
> support staff.
>
> Secondly, we know it is possible to forward an email to RT, and add the 
> original requestor's email address to the Reply-To header field of the 
> forward.  While not tested, I have read that RT will understand this 
> natively.  However, this is another educational challenge, asking support 
> staff to always remember to custom modify this Reply-To field.
>
> In short, I need a solution that requires "no thought" on the part of support 
> staff, since they already have plenty of other things to think about.
>
> Is it possible to modify the configuration of RT itself -- perhaps with some 
> kind of plugin from CPAN -- to make RT smart enough to understand a forwarded 
> email, and automatically locate the original sender's address and make that 
> person the Requestor of the ticket?
>
> Any help would be much appreciated!
>
> Cheers,
>
> --
> Jonathan Mills
> Systems Administrator
> Renaissance Computing Institute
> UNC-Chapel Hill
>
> 
> Final RT training for 2012 in Atlanta, GA - October 23 & 24
>   http://bestpractical.com/training
>
> We're hiring! http://bestpractical.com/jobs


Final RT training for 2012 in Atlanta, GA - October 23 & 24
  http://bestpractical.com/training

We're hiring! http://bestpractical.com/jobs

Re: [rt-users] Installing RT via Puppet

[Darin Perusich]

You'll need modules for the various components like apache, database, 
and finally request-tracker itself. Deployment will certainly be much 
easier if you're installing RT from packages rather than source since 
dependencies, user and group creation, are taken care of.

I haven't written a module yet but it's on my very large todo list. 
There is a module on GitHub, 
https://github.com/lurdan/puppet-requesttracker, which is Debian 
specific and after a quick review of the init.pp it's incomplete, IMO. 
That might be a good starting point for you.

On 08/27/2012 08:27 PM, Mr IT Guru wrote:
> Good Morning All,
>
> I don't want to reinvent the wheel,  so I though tI'd ask here first.
> Has anyone here installed RT via Puppet?
>
> For those that don't know, Puppet, is a pretty awesome state
> management tool. Google is your friend, you can do the rest. For
> those that do, would you mind sharing your code? Or if there isn't
> any code, would you guys like to join me writing some?
>
> That way I can spend 5 minutes installing new boxes instead of
> looking up my notes, etc.
>
> Anyone interested?
>
> Thanks,
>
> -- Mr Guru
>

-- 
Darin Perusich
Email: darin.perus...@ctg.com
Office: 716-888-3690
The information transmitted is intended only for the person or entity to which
it is addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any action
in reliance upon, this information by persons or entities other than the
intended recipient is prohibited. If you are not the intended recipient of this 
message, please contact the sender and delete this material from this computer.

Re: [rt-users] Installing and Configuring Asset Tracker in RT

[Darin Perusich]

On Thu, Jul 5, 2012 at 7:42 PM, Kevin Falcone  wrote:
> On Thu, Jul 05, 2012 at 12:42:23PM +0200, Carlos Becker wrote:
>> I installed the debian rt4 packages on Debian stable 6.x squeeze.
>> Unfortunately squeeze does not provide rt4 and assettracker packages
>> so I use the packages that are available in debian testing (using apt 
>> pinning).
>>
>> After some tweaks (there were issues with the mysql schema about TYPE=InnoDB 
>> which now must be ENGINE=InnoDB)
>
> If debian is shipping rt4 packages with TYPE=InnoDB that's a bug. RT has
> shipped ENGINE since 4.0.0 and fixed it in 3.8 with 3.8.11.
>
>> basically installation went fine, but again I am getting display problems 
>> with the rt start page.
>> What I see in the front page is the text:
>>
>>  > onchange="document.CreateAssetOfType.submit()" class="select-assettype"> 
>>  
>> and
>
> Looks like Asset Tracker is pushing HTML into localized strings which
> is something we've discouraged for a long time and disabled in 4.0.6
> because of the massive security holes in the approach. The Asset
> Tracker authors can convert to using l_unsafe but need to make sure
> they're not just introducing security holes.  Best Practical doesn't
> work on Asset Tracker, so you probably want to contact the AT team
> directly.

FYI...this has been resolved, but it hasn't been pushed upstream yet.

https://github.com/rg1/rt-extension-assettracker/commit/c6f0a440358ab3695f692b4aa0eff540bc4cf156

[rt-users] configure RT-Authen-ExternalAuth to not verify certificates

[Darin Perusich]

Hello All,

Is there anyway to configure RT-Authen-ExternalAuth to not verify ssl
certificates? I'm hitting an ldap server that has a self-signed cert
and it would be much more simple to not verify the certificate. I
tried adding "verify => 'none'" to net_ldap_args which is used by
Net::LDAP start_tls but that didn't work.

--
Later,
Darin

Re: [rt-users] Getting Request Tracker to stick to HTTPS

[Darin Perusich]

On 05/16/2012 11:20 AM, Giles Coochey wrote:
>
> How can I force RT to HTTPS?
>

Have you tried use mod_rewrite to rewrite the all traffic for that 
virtual host to https?

Stubs of the config's for your RT virtual host. They http vhost only 
needs to have the basic's defined, the rewrite rules will push 
everything to https.


...
...
RewriteEngine On
RewriteCond %{SERVER_PORT} !^443$
RewriteRule  ^/(.*)https://%{SERVER_NAME}/$1 [L,R=301]



...
...

  Order allow,deny
  Allow from all
  SetHandler modperl
  PerlResponseHandler Plack::Handler::Apache2
  PerlSetVar psgi_app /usr/sbin/rt-server



  use Plack::Handler::Apache2;
  Plack::Handler::Apache2->preload("/usr/sbin/rt-server");
    
...
...


-- 
Darin Perusich
Email: darin.perus...@ctg.com
Office: 716-888-3690
The information transmitted is intended only for the person or entity to which
it is addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any action
in reliance upon, this information by persons or entities other than the
intended recipient is prohibited. If you are not the intended recipient of this 
message, please contact the sender and delete this material from this computer.

Re: [rt-users] Error with Asset Tracker RT4

[Darin Perusich]

On Thu, May 3, 2012 at 12:22 PM, Daniel Garcia Mejia  wrote:
> On 03/05/12 18:14, Darin Perusich wrote:
>>
>> Hello,
>>
>> On Thu, May 3, 2012 at 12:04 PM, Daniel Garcia Mejia
>>  wrote:
>>>
>>> I install the last version of RT and Asset Tracker. I don't know if this
>>> is
>>> my problem or a bug/error of Asset Tracker with the latest version of RT,
>>> but I can't add new asset or update at my system RT4. Also, I can't see
>>> any
>>> option of 'Asset' in menu of RT...
>>>
>>> It is normal? If this is normal, when Asset Tracker will launch a version
>>> that support RT4 ?
>>
>> I've been running AT 2.0.0b2 and RT 4.0.5 without issue, I upgraded
>> from RT 3.8.8 and AT 1.2.4 I believe. Are you seeing any errors in the
>> logs, what's your @plugins from RT_SiteConfig.pm, how did you setup
>> AT, etc?
>
>
>
> I install the version AT 2.0.0b2 with commands:
>
> $ RTHOME=/path/to/rt perl Makefile.PL
> $ make
> $ make install
> $ make initdb
>
>
> I put in mi @plugins:
>
> Set(@Plugins, (qw(RT::Extension::JSGantt RTx::AssetTracker
> RT::Extension::LDAPImport RT::Extension::NotifyOwners
> RT::Extension::SummaryByUser RTx::Calendar)));
>
>
> NO errors in my log...
> I cant see any 'Assets' on Menu and any button of 'Create new asset'...
> Only I can put is in "RT at glance" the quicksearch 'Asset types'...
>
>
> Any solution? Where is the button or menu 'Assets'? Is very hidden?
>

Did you restart apache and clear the mason-cache? The "Assets" menu
should be between "Tickets" and "Tools".

Re: [rt-users] Error with Asset Tracker RT4

[Darin Perusich]

Hello,

On Thu, May 3, 2012 at 12:04 PM, Daniel Garcia Mejia  wrote:
>
> I install the last version of RT and Asset Tracker. I don't know if this is
> my problem or a bug/error of Asset Tracker with the latest version of RT,
> but I can't add new asset or update at my system RT4. Also, I can't see any
> option of 'Asset' in menu of RT...
>
> It is normal? If this is normal, when Asset Tracker will launch a version
> that support RT4 ?

I've been running AT 2.0.0b2 and RT 4.0.5 without issue, I upgraded
from RT 3.8.8 and AT 1.2.4 I believe. Are you seeing any errors in the
logs, what's your @plugins from RT_SiteConfig.pm, how did you setup
AT, etc?

Re: [rt-users] RT 3.8.11 and AT 2.0.0b upgrade or uninstall and install fresh

[Darin Perusich]

First, there is an at-users group available at Google Group, link below. It's 
doesn't see as much traffic as the RT list but it's another resource.

http://groups.google.com/group/at-users
<mailto:at-us...@googlegroups.com> 

On 01/11/2012 05:21 PM, Susan McClure wrote: 

I have a similar question as Kevin Squire on 12/08/2011 till today.

I tried to install AT 1.2.4b1 on my old system without much success, but
now I have some AT
tables, groups etc in my DB (Postgresql)

I am trying to install AT 2.0.0b from github onto RT 3.8.11 upgraded
system.
I do not have any AT files/scrips in the RT installation.

If I try to do a "make initdb" it fails with the same error:


Now populating database schema.
DBD::Pg::st execute failed: ERROR:  relation "at_types" already 
exists
...returned with error: 65280
make: *** [initdb] Error 255

I got a similar error when trying to initialize Rt+AT with Postgres. To work 
around this I needed to remove AT from RT_SiteConfig.pm, uninstalled AT, init 
RT under Pg, install AT and init the AT tables, which I did  with the below 
commands. After this I did a mysql to postgres migration but I wouldn't think 
that should matter as my Pg instance was new. I'm using an RPM package for AT, 
perl-RTx-AssetTracker, so install/removal is a trivial matter. I can't comment 
on removing AT if installed from source but you might want to check if there's 
an 'make uninstall'. For those who are daring you could probably do "find 
/path/to/rt" -name \*AssetTracker\*" to find all the AT files and then remove 
manually.




If I try to do a "make dropdb" to drop the old tables etc, it does not 
give
any error, or any output, but neither does it drop any AT tables (like
at_assets, at_types, at_ips, at_ports).

I tried a "make realclean" and then tried to install again WITHOUT doing
an initdb.  I ran the upgrade :


 /usr/site/rt/sbin/rt-setup-database --dba postgres 
--prompt-for-dba-password --action schema --datadir etc/upgrade/1.2.4

and yes, there is NO schema.Pg file (only mysql and SQLite )

I'm running perl-RTx-AssetTracker 2.0.0b2 and the acl.Pg and schema.Pg files do 
exist. You need to specify the full path to the schema files when running 
rt-setup-database.


rt-setup-database --action schema --dba rt_user --prompt-for-dba-password 
--datadir \
  /usr/share/request-tracker/local/plugins/RTx-AssetTracker/etc/
rt-setup-database --action acl --dba rt_user --prompt-for-dba-password 
--datadir \
  /usr/share/request-tracker/local/plugins/RTx-AssetTracker/etc/



How can I do a complete "uninstall" of Asset Tracker, AND remove the
existing Asset Tracker items from the DB and start over with a fresh
install??

If you tell me all the tables, templates, AT global group and user
    rights etc, I could
try to manually drop all the  AT parts from the current DB.




-- 
Darin Perusich
Email: darin.perus...@ctg.com
Office: 716-888-3690
The information transmitted is intended only for the person or entity to which
it is addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any action
in reliance upon, this information by persons or entities other than the
intended recipient is prohibited. If you are not the intended recipient of this 
message, please contact the sender and delete this material from this computer.

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

Re: [rt-users] OpenSSO and RT

[Darin Perusich]

Michael,

While I haven't tried this yet, I suspect all you need to do is set/define 
$WebExternalAuth in RT_SiteConfig.pm and then install/configure the apache 
policy agent and create/configure the appropriate OpenAM/OpenSSO policies.

http://requesttracker.wikia.com/wiki/WebExternalAuth

On 01/03/2012 03:01 PM, Little, Michael B (JSC-IS2)[DB Consulting Group, Inc.] 
wrote: 

Greetings,

 

I have seen some older wiki articles on how someone had integrated NTLM 
authentication with RT. Has anyone had any experience with integrating RT with 
OpenSSO (http://docs.oracle.com/cd/E19681-01/)? 

 

Michael Little

IA / Middleware Engineer, ITAMS 

Building 46, Room 120B 
email to: michael.lit...@nasa.gov
281-483-1889 Office  832-816-1348 Mobile
281-244-6627 Fax

 

ITAMS - Information Technology And Multimedia Services Contract 

"One Team, One Vision >> Partnered For Innovative Solutions"

 


 


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


-- 
Darin Perusich
Email: darin.perus...@ctg.com
Office: 716-888-3690
The information transmitted is intended only for the person or entity to which
it is addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any action
in reliance upon, this information by persons or entities other than the
intended recipient is prohibited. If you are not the intended recipient of this 
message, please contact the sender and delete this material from this computer.

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

Re: [rt-users] 3.4.2 to 4.x

[Darin Perusich]

Hi Jeff,

I did an upgrade from mysql to postgres a few month back and it went
very smoothly. I used the rt-mysql2pg script available at
http://wiki-archive.bestpractical.com/view/rt-mysql2pg to convert the
data which performed seamlessly.

I have a bunch of notes I can share which might be helpful, I ran into a
few issues performing the update because of AssetTracker. Ping me
off-list and I'll share them.

On 12/28/2011 09:30 AM, Jeff Blaine wrote:
> The RT 3.4 to RT 4.0.4 upgrade went fine.
> 
> Now with our data in MySQL 5.1.x, instead of the old
> MySQL 4.1, and our new instance not in production yet,
> we want to migrate to PostgreSQL 8.4.9, largely in
> order to get performant full-text searching without
> doing something hackish with MySQL and Sphinx nonsense.
> 
> That task, however, is turning out to be a nightmare.
> The gory details are at the link below, but the short
> story is that PostgreSQL does not like some of the
> bytes (mostly when trying to INSERT into Attachments).
> 
> Cleaning the dump file of all non-ASCII characters,
> then trying the data load again, bought me nothing (!!??).
> 
> http://dba.stackexchange.com/questions/9792/no-nulls-yet-invalid-byte-sequence-for-encoding-utf8-0x00
> 
> 
> If anyone has any advice, please share!
> 
> RT Training Sessions (http://bestpractical.com/services/training.html)
> * Boston  March 5 & 6, 2012

-- 
Darin Perusich
Email: darin.perus...@ctg.com
Office: 716-888-3690
The information transmitted is intended only for the person or entity to which
it is addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any action
in reliance upon, this information by persons or entities other than the
intended recipient is prohibited. If you are not the intended recipient of this 
message, please contact the sender and delete this material from this computer.


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

Re: [rt-users] search/dashboard of ticket with childern

[Darin Perusich]

> On Mon, Oct 31, 2011 at 12:01:04PM -0400, Darin Perusich wrote:
> > I want to create a query for a dashboard where I'm searching on a
> > ticket and any children ticket underneath it. Think project
> management
> > type of view, 1 top level ticket, with any number of children,
> > children with children. I was thinking I'd be able to search on
> > HasMember where the HasMember of the top-level ticket but this
always
> returns zero results.
> >
> > How would I go about accomplishing this?
> 
> Go to the top level ticket, and in the Links box, the Children word
> will be clickable and take you to a search that shows you the syntax
> for the search that you want.

This gives me the second level of ticket but nothing deeper than that,
some of the tickets are 5 or 6 levels under the top-level ticket. Is
there a way to recurs deeper in hierarchy? I'm able to accomplish this
with memberof = 1 OR memberof 3 OR memberof 10, etc. but that isn't very
practical when you have lots of tickets at various depths. JSGantt is
able to pull in all the tickets to build a view of the tickets in a
"project". Maybe applying the logic it's using... I'll take a look at
the source, but in the mean time hopefully some has a quicker answer.

Thanks Kevin!

The information transmitted is intended only for the person or entity to which
it is addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any action
in reliance upon, this information by persons or entities other than the
intended recipient is prohibited. If you are not the intended recipient of this 
message, please contact the sender and delete this material from this computer.


RT Training Sessions (http://bestpractical.com/services/training.html)
*  Barcelona, Spain  November 28 & 29, 2011

[rt-users] search/dashboard of ticket with childern

[Darin Perusich]

Hello,

I want to create a query for a dashboard where I'm searching on a ticket
and any children ticket underneath it. Think project management type of
view, 1 top level ticket, with any number of children, children with
children. I was thinking I'd be able to search on HasMember where the
HasMember of the top-level ticket but this always returns zero results.

How would I go about accomplishing this?

Thanks!

--
Darin Perusich
Email: darin.perus...@ctg.com
Office: 716-888-3690


The information transmitted is intended only for the person or entity to which
it is addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any action
in reliance upon, this information by persons or entities other than the
intended recipient is prohibited. If you are not the intended recipient of this 
message, please contact the sender and delete this material from this computer.


RT Training Sessions (http://bestpractical.com/services/training.html)
*  Barcelona, Spain  November 28 & 29, 2011

Re: [rt-users] BKM for deployment of RT's perl

[Darin Perusich]

I use  the OBS (open(suse) build sevice) perl repository for my RT system, I’m 
running on OpenSUSE 11.3. For RT itself I build an rpm package for it and a 
bunch of extensions, see links below, which are deployed from an internal repo 
server. I’d like to get this RT package, plus my extension packages,  put into 
the OBS perl repo so all you’ll need to do is added the repo and “zypper in 
request-tracker” for SUSE systems.

 

http://download.opensuse.org/repositories/devel:/languages:/perl/openSUSE_11.3/

 

RT 4.0.2 source rpm

http://download.opensuse.org/repositories/home:/lrupp:/request-tracker/openSUSE_Factory/src/

 

RT extensions rpm’s

https://build.opensuse.org/project/packages?project=home%3Adeadpoint

 

--

Darin Perusich

Email: darin.perus...@ctg.com

Office: 716-888-3690

 

From: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Robert Nesius
Sent: Thursday, October 27, 2011 2:42 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] BKM for deployment of RT's perl

 

Hi all, 

Just curious how some of you provision perl to RT.  I am running over my 
server-distro's apache2/perl, and during a recent upgrade the system perl was 
moved forward and suddenly my modules disappeared.  I was able to patch it up 
without too much trouble, but did find myself debating rolling my own 
perl/mod_perl so I could roll the distro forward in the future without having 
to worry about blowing up RT again.   

Just curious how some of you approach this detail. 

Thanks in advance,
-Rob

The information transmitted is intended only for the person or entity to which
it is addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any action
in reliance upon, this information by persons or entities other than the
intended recipient is prohibited. If you are not the intended recipient of this 
message, please contact the sender and delete this material from this computer.

RT Training Sessions (http://bestpractical.com/services/training.html)
*  Washington DC, USA — October 31 & November 1, 2011
*  Barcelona, Spain — November 28 & 29, 2011

Re: [rt-users] RT-Extension-JSGantt question

[Darin Perusich]

> 
> From the README:
> 5. patch /Ticket/Elements/ShowSummary if you are using rt < 3.9
> 
> You're running 4.0.2 which is new enough to already contain this
patch.

Clearly I don't know how to read.

Thanks Kevin!
The information transmitted is intended only for the person or entity to which
it is addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any action
in reliance upon, this information by persons or entities other than the
intended recipient is prohibited. If you are not the intended recipient of this 
message, please contact the sender and delete this material from this computer.


RT Training Sessions (http://bestpractical.com/services/training.html)
*  San Francisco, CA, USA  October 18 & 19, 2011
*  Washington DC, USA  October 31 & November 1, 2011
*  Barcelona, Spain  November 28 & 29, 2011

[rt-users] RT-Extension-JSGantt question

[Darin Perusich]

Hello All,

Is it no longer necessary to patch html/Ticket/Elements/ShowSummary to
enable the RT-Extension-JSGantt? When I attempt to patch ShowSummary,
patch says it's already been applied and when I review the patch itself
and ShowSummary what would be patched is already set.

I'm running rt-4.0.2.

Thanks!

--
Darin Perusich
Email: darin.perus...@ctg.com
Office: 716-888-3690


The information transmitted is intended only for the person or entity to which
it is addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any action
in reliance upon, this information by persons or entities other than the
intended recipient is prohibited. If you are not the intended recipient of this 
message, please contact the sender and delete this material from this computer.


RT Training Sessions (http://bestpractical.com/services/training.html)
*  San Francisco, CA, USA  October 18 & 19, 2011
*  Washington DC, USA  October 31 & November 1, 2011
*  Barcelona, Spain  November 28 & 29, 2011

Re: [rt-users] AssetTracker and RT4.0.2 and css

[Darin Perusich]

Joop,

> No go in the logs but by accident I found it. I added the aileron
> folder
> maybe in the wrong place or you'll need to add it twice.
> Atleast it is needed here:
> /usr/local/share/request-tracker4/plugins/RTx-
> AssetTracker/html/Callbacks/AssetTracker/NoAuth/css/aileron
> Create the aileron folder and copy the files from the web2 folder to
> it.
> That consists of a folder Main.css and a file End contained in it.
That
> file includes webat.css.
> 
> Hope this will help some other people as well and I hope Todd will
> include it in the next release.
> 


You should open an issue at
https://github.com/chakatodd/rt-extension-assettracker/issues

The information transmitted is intended only for the person or entity to which
it is addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any action
in reliance upon, this information by persons or entities other than the
intended recipient is prohibited. If you are not the intended recipient of this 
message, please contact the sender and delete this material from this computer.


RT Training Sessions (http://bestpractical.com/services/training.html)
*  San Francisco, CA, USA  October 18 & 19, 2011
*  Washington DC, USA  October 31 & November 1, 2011
*  Barcelona, Spain  November 28 & 29, 2011

Re: [rt-users] Access RT from behind firewall

[Darin Perusich]

NAT'ing the traffic to your RT server should work just fine or use a
proxy server.

--
Darin Perusich
Email: darin.perus...@ctg.com
Office: 716-888-3690


> -Original Message-
> From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-
> boun...@lists.bestpractical.com] On Behalf Of Rocel M. Lacida
> Sent: Wednesday, August 03, 2011 3:08 AM
> To: rt-users@lists.bestpractical.com
> Subject: [rt-users] Access RT from behind firewall
> 
> Hi All,
> 
> I have RT running on Openvz hosted locally and this was running very
> will. Now my concern is how do I make users to access RT from the
> outside? I have tried port forwarding port 80 to it but doesn't work.
> 
> Is there any config that I would like to set on RT configuration?
> 
> Regards,
> Rocel Lacida
> 
> 
> 2011 Training: http://bestpractical.com/services/training.html
The information transmitted is intended only for the person or entity to which
it is addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any action
in reliance upon, this information by persons or entities other than the
intended recipient is prohibited. If you are not the intended recipient of this 
message, please contact the sender and delete this material from this computer.



2011 Training: http://bestpractical.com/services/training.html

Re: [rt-users] Setup RT with existing postfix on separate server

[Darin Perusich]

All you need to do on your external postfix server is add the email
address/alias you've created to the postfix transport(5) file and they
will be relayed to the RT server.

If you're using h...@domain.com and help-comm...@domain.com the entries
to /etc/postfix/transport would be:

h...@domain.com smtp:rt.domain.com
help-comm...@domain.com smtp:rt.domain.com

Make sure you run postmap on the transport file to rebuild the map.

--
Darin Perusich
Email: darin.perus...@ctg.com
Office: 716-888-3690


> -Original Message-
> From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-
> boun...@lists.bestpractical.com] On Behalf Of Donny Brooks
> Sent: Thursday, March 17, 2011 9:34 AM
> To: rt-users@lists.bestpractical.com
> Subject: [rt-users] Setup RT with existing postfix on separate server
> 
> Are there any others running an external postfix mail server and RT? I
> have been through all of the wiki/google hits and only see examples of
> how to setup RT in an exchange domain or with postfix/sendmail on the
> RT
> box. I have an existing domain with postfix/dovecot running on its own
> machine. RT is a totally separate machine (actually a Xen VM). I am at
> a
> loss as to even how to begin to get mail delivered to the RT machine
> and
> tickets created from that. I have the following setup on the RT box:
> 
> rt: "|/usr/sbin/rt-mailgate --queue 'general' --action correspond --
> urlhttp://localhost/";
> rt-comment: "|/usr/sbin/rt-mailgate --queue 'general' --action comment
> --urlhttp://localhost/";
> 
> However mail cannot be sent to r...@rt.domain.tld or
> rt-comm...@rt.domain.tld due to failing DNS resolution that we do not
> have control over. I have setup rt.domain.tld in our internal DNS
> though. How have others accomplished this? I have thought about
> fetchmail on the RT box but not sure if there was a better solution
> than
> that. Thanks for any and all input.
> 
> Donny B.
The information transmitted is intended only for the person or entity to which
it is addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any action
in reliance upon, this information by persons or entities other than the
intended recipient is prohibited. If you are not the intended recipient of this 
message, please contact the sender and delete this material from this computer.

Re: [rt-users] RT on OpenSUSE 11.3 64-bit w/mod_perl

[Darin Perusich]

Hi Mike,

 

I was never able to figure out the cause of those segfaults on opensuse
11.3 with mod_perl and given that mod_fastcgi just worked I stopped
trying to figure it out. Make sure you've configured RT for mod_fastcgi,
from your configure line looks like you should be all set. Your
commingling mod_perl and mod_fastcgi stuff in your apache configuration
which is likely a big part of the problems you're seeing. My
rt_fastcgi.conf for apache2 is below. 

 

--BEGIN--

#

# RT apache configuration

#

# ensure the trailing slash is added

#

RewriteEngine on

RewriteRule ^/rt$ /rt/ [R]

 

Alias /rt /opt/rt3/bin/mason_handler.fcgi/

Alias /NoAuth/images/ /opt/rt3/share/html/NoAuth/images/

 

FastCgiServer /opt/rt3/bin/mason_handler.fcgi -processes 8 -idle-timeout
120

 



   AllowOverride None

   Order allow,deny

   Allow from all



--END--

--

Darin Perusich

Email: darin.perus...@ctg.com

Office: 716-888-3690

 

From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Michael
Coakley
Sent: Friday, January 28, 2011 10:11 PM
To: RT-Users@lists.bestpractical.com
Subject: [rt-users] RT on OpenSUSE 11.3 64-bit w/mod_perl

 

I'm getting a constant segfault error 4 in libc-2.11.2.so with the
configuration given in the subject line. I've read the lists and found
this thread :
http://www.gossamer-threads.com/lists/rt/users/97348?do=post_view_thread
ed#97348

 

I want to configure fast-cgi but the examples given in the thread don't
get me there. I've also read the mod-fcgid docs and I can get fast-cgi
to work but then it bombs with that it can't read the webmux.pl file in
/opt/rt3/bin. 

 

I even uninstalled the RPM packages and manually installed Apache2 and
mod_perl but it still is segfaulting.

 

I configured RT with the following configure line:

 

./configure --with-apachectl=/usr/sbin/apache2ctl --with-web-user=wwwrun
--with-web-group=www --with-rt-group=rt

 

My Apache config for my virtual host looks like:

 



ServerName rt.example.com

 

DocumentRoot /opt/rt3/share/html

AddDefaultCharset UTF-8

 

# optional apache logs for RT

ErrorLog /var/log/apache2/rt3-error_log

TransferLog /var/log/apache2/rt3-access_log

 

AddHandler fastcgi-script fcgi

 

PerlRequire "/opt/rt3/bin/webmux.pl"

 



SetHandler default



 



 SetHandler fastcgi-script



 



Options FollowSymLinks

AllowOverride None

 

Order allow,deny

Allow from all



 

ScriptAlias / /opt/rt3/bin/mason_handler.fcgi/

 



Options +ExecCGI

AllowOverride None

 

Order allow,deny

Allow from all





 

Hopefully I'm just missing something. I wish mod_perl would just work
but all I need is RT to work using mod_perl or mod_fcgid. Any ideas?

 

Thanks,

 

Mike

The information transmitted is intended only for the person or entity to which
it is addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any action
in reliance upon, this information by persons or entities other than the
intended recipient is prohibited. If you are not the intended recipient of this 
message, please contact the sender and delete this material from this computer.

Re: [rt-users] Troubleshooting RT::Authen::ExternalAuth

[Darin Perusich]

Send the relevant RT_SiteConfig.pm portions to the list would be a good
place. I'd also set so the logging isn't muddled with stuff from the
system logs.

Set($LogToFileNamed , "rt.log");
Set($LogToFile      , 'debug'); 

--
Darin Perusich
Email: darin.perus...@ctg.com
Office: 716-888-3690


> -Original Message-
> From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-
> boun...@lists.bestpractical.com] On Behalf Of Lee Hughes
> Sent: Tuesday, December 28, 2010 7:49 PM
> To: rt-users@lists.bestpractical.com
> Subject: [rt-users] Troubleshooting RT::Authen::ExternalAuth
> 
> I've installed and configured RT::Authen::ExternalAuth for LDAP
> support but it does not appear to be querying our LDAP server. I tried
> setting LogToSyslog to 'debug' in RT_SiteConfig.pm but I'm not seeing
> anything related to ExternalAuth in the log. Any ideas on how to start
> troubleshooting?
> 
> Thanks-
> 
> Lee
The information transmitted is intended only for the person or entity to which
it is addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any action
in reliance upon, this information by persons or entities other than the
intended recipient is prohibited. If you are not the intended recipient of this 
message, please contact the sender and delete this material from this computer.

Re: [rt-users] advanced search w/ a sql call

[Darin Perusich]

Steve and Ken,

This is good to know, thanks! Now I have a question about
Dashboards...how should the permissions be granted? I know this is
rather general but after reviewing the ManualDashboards page in the wiki
I'm still unclear on this. The permissions in RT always seem to make me
stumble.

These are the permissions which make the most sense to me, these are
Global Group Rights.

Everyone: SeeDashboard, SubscribeDashboard
Privileged: CreateOwnDashboard, DeleteOwnDashboard, ModifyOwnDashboard,
SeeOwnDashboard

Thank!

--
Darin Perusich
Email: darin.perus...@ctg.com
Office: 716-888-3690
Cell: 716-807-4589


> -Original Message-
> From: Steve Anderson [mailto:steve.ander...@bipsolutions.com]
> Sent: Monday, December 20, 2010 12:58 PM
> To: Darin Perusich
> Cc: rt-users@lists.bestpractical.com
> Subject: RE: [rt-users] advanced search w/ a sql call
> 
> Use a dashboard (suing a saved search with the time limit as Ken says)
> with a subscription to fire it off to your boss.
> 
> Steve
> 
> -Original Message-
> From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-
> boun...@lists.bestpractical.com] On Behalf Of Kenneth Marshall
> Sent: 20 December 2010 17:56
> To: Darin Perusich
> Cc: rt-users@lists.bestpractical.com
> Subject: Re: [rt-users] advanced search w/ a sql call
> 
> On Mon, Dec 20, 2010 at 11:38:35AM -0500, Darin Perusich wrote:
> > Hello,
> >
> > I'd like to search for tickets created w/in the past 7 days which
can
> be
> > done easily enough by creating a query where Created after some day,
> > "Created > '2010-12-13'". I'd like to make this more dynamic so I go
> > into Advanced and change the Query to "Created >
> date_add(current_date,
> > interval - 7 day)" and when I apply the changes I'm left on the
> Advanced
> > query page and the format has been wiped out. Not what I was hoping
> for.
> >
> > Are you allowed to enter straight SQL through the interface like
this
> to
> > make dynamic queries? Certainly I can see why this would not be
> allowed
> > since it could lead to sql injection but I'm curious.
> >
> > Also, is there a way to save such a report so I could just point to
a
> > URL or something of that nature to fire it off? Basically my manager
> > wants a weekly report of all the tickets entered into RT and I'm
> trying
> > to automate the creation of the report I give him.
> >
> > Thanks!
> >
> > RT 3.8.8 w/mysql
> >
> 
> You should be able to use something like "7 days ago" or
> "-7 days" in the query.
> 
> Cheers,
> Ken
> 
> __
> This email has been scanned by Netintelligence
> http://www.netintelligence.com/email
> 
> 
> BiP Solutions Limited is a company registered in Scotland with Company
> Number SC086146 and VAT number 383030966 and having its registered
> office at Medius, 60 Pacific Quay, Glasgow, G51 1DZ.
> 
>
***
> *
> This e-mail (and any attachment) is intended only for the attention of
> the addressee(s). Its unauthorised use, disclosure, storage or copying
> is not permitted. If you are not the intended recipient, please
destroy
> all copies and inform the sender by return e-mail.
> This e-mail (whether you are the sender or the recipient) may be
> monitored, recorded and retained by BiP Solutions Ltd.
> E-mail monitoring/ blocking software may be used, and e-mail content
> may
> be read at any time.You have a responsibility to ensure laws are not
> broken when composing or forwarding e-mails and their contents.
>
***
> *
The information transmitted is intended only for the person or entity to which
it is addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any action
in reliance upon, this information by persons or entities other than the
intended recipient is prohibited. If you are not the intended recipient of this 
message, please contact the sender and delete this material from this computer.

[rt-users] advanced search w/ a sql call

[Darin Perusich]

Hello,

I'd like to search for tickets created w/in the past 7 days which can be
done easily enough by creating a query where Created after some day,
"Created > '2010-12-13'". I'd like to make this more dynamic so I go
into Advanced and change the Query to "Created > date_add(current_date,
interval - 7 day)" and when I apply the changes I'm left on the Advanced
query page and the format has been wiped out. Not what I was hoping for.

Are you allowed to enter straight SQL through the interface like this to
make dynamic queries? Certainly I can see why this would not be allowed
since it could lead to sql injection but I'm curious.

Also, is there a way to save such a report so I could just point to a
URL or something of that nature to fire it off? Basically my manager
wants a weekly report of all the tickets entered into RT and I'm trying
to automate the creation of the report I give him.

Thanks!

RT 3.8.8 w/mysql

--
Darin Perusich
Email: darin.perus...@ctg.com
Office: 716-888-3690
Cell: 716-807-4589


The information transmitted is intended only for the person or entity to which
it is addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any action
in reliance upon, this information by persons or entities other than the
intended recipient is prohibited. If you are not the intended recipient of this 
message, please contact the sender and delete this material from this computer.

Re: [rt-users] Possible to downgrade DB from 3.8 to 3.6?

[Darin Perusich]

The OpenSuSE build service has a lot of good information about using the
Build Service for packaging perl modules, see
http://en.opensuse.org/openSUSE:Packaging_Perl and
http://old-en.opensuse.org/Packaging/Perl. The can easily be adopted for
building locally.

All the perl packages needed for a default RT installation are available
in the perl development language repo,
http://download.opensuse.org/repositories/devel:/languages:/perl/. I ran
into missing packages for RTIR but was able to build rpms for them using
the above information. Additionally, I imported them into my personal
repository with the goal of having them included in the perl repo but
ran into a couple minor issues which I haven't had time to address. This
are build service glitches I'm not sure how to overcome and have nothing
to do with the packages themselves.

--
Darin Perusich
Email: darin.perus...@ctg.com
Office: 716-888-3690
Cell: 716-807-4589


> -Original Message-
> From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-
> boun...@lists.bestpractical.com] On Behalf Of John Arends
> Sent: Monday, December 13, 2010 7:14 PM
> To: rt-users@lists.bestpractical.com
> Subject: Re: [rt-users] Possible to downgrade DB from 3.8 to 3.6?
> 
> 
> On Dec 13, 2010, at 6:06 PM, Gary Greene wrote:
> 
> > On 13/12/10 9:43 AM, "John Arends"  wrote:
> >> CPAN makes me cranky, but trying to package all the perl modules as
> RPMs
> >> makes me crankier. It's like wrapping one packaging system around
> >> another one, and fighting with both of them.
> >>
> >
> > This is why I use cpan2rpm every time.
> >
> >> The reality is, every time RHEL updates perl, RT will break. I
solve
> >> this by having an identical test system. I apply the updates, see
> what
> >> breaks, and then reinstall the perl modules in question using CPAN.
> >
> > This ALSO can be avoided, if you know how to package your cpan2rpm
> packages
> > in site instead of vendor locations. This allows that NONE of the
> issues
> > that are endemic of RHEL's busted Perl packaging to cause long term
> > headaches for me.
> 
> 
> Do you know of a guide that explains how to do this?
The information transmitted is intended only for the person or entity to which
it is addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any action
in reliance upon, this information by persons or entities other than the
intended recipient is prohibited. If you are not the intended recipient of this 
message, please contact the sender and delete this material from this computer.

[rt-users] Comment/reply not being recorded

[Darin Perusich]

Hello All,

I'm seeing some strange behavior with one of the my tickets in RT. When
I add a comment or reply the message doesn't show up in the history yet
email is sent out. The last message in the history is an error, see
below, but nothing shows up after it. It doesn't matter if I
comment/reply w/ my user account of the root account. Fortunately I'm
just starting to use the system but I'm concerned this isn't the only
ticket like this. Anything new doesn't appear to be having this problem.

Any thoughts?

RT 3.8.8

Mon Dec 06 15:32:24 2010 Darin Perusich - Status changed from 'new' to
'open'
Wide character in FCGI::Stream::PRINT at
/usr/lib/perl5/vendor_perl/5.12.1/HTML/Mason/CGIHandler.pm line 105.

Thanks!
--
Darin Perusich
Email: darin.perus...@ctg.com
Office: 716-888-3690
Cell: 716-807-4589


The information transmitted is intended only for the person or entity to which
it is addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any action
in reliance upon, this information by persons or entities other than the
intended recipient is prohibited. If you are not the intended recipient of this 
message, please contact the sender and delete this material from this computer.

[rt-users] asset "change log" field

[Darin Perusich]

Hello,

I'm new to RT and I'm not sure how to go about creating this. I'd like
to be able to log changes that are made to assets, which are mostly
computers, and I haven't been having much luck figuring it out. I'm not
changing the properties of the asset like IPaddr, name, or custom
fields, but rather changes made on the asset.

For example if I updated the RT_SiteConfig.pm and restarted apache I'd
like to log the date/time this happened, different from the time it was
logged, whether or not files were checked into version control if
applicable, backout plan, whether or not it was successful, etc.

Give the number of elements I'd like to capture I don't know how to do
this with custom fields which appear to only be for single items. If
anyone can provide some guidance on how to accomplish this or if you've
already done so it will be greatly appreciated.

Thanks!

--
Darin Perusich
Email: darin.perus...@ctg.com
Office: 716-888-3690
Cell: 716-807-4589


The information transmitted is intended only for the person or entity to which
it is addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any action
in reliance upon, this information by persons or entities other than the
intended recipient is prohibited. If you are not the intended recipient of this 
message, please contact the sender and delete this material from this computer.

Re: [rt-users] httpd2-prefork segfaulting on SLES11

[Darin Perusich]

Apache is not crashing using mod_fastcgi, which I installed from the Apache 
Modules repo at 
http://download.opensuse.org/repositories/Apache:/Modules/openSUSE_11.3/

--
Darin Perusich
Email: darin.perus...@ctg.com
Office: 716-888-3690
Cell: 716-807-4589


> -Original Message-
> From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-
> boun...@lists.bestpractical.com] On Behalf Of Brian Dial
> Sent: Friday, November 05, 2010 9:27 AM
> To: rt-users@lists.bestpractical.com
> Subject: Re: [rt-users] httpd2-prefork segfaulting on SLES11
> 
> that looks a lot easier than the wiki made it look, thanks!
> 
> - Original Message -
> On Nov 5, 2010, at 9:09 AM, Brian Dial wrote:
> 
> > mod_perl.  fastcgi looked rather complicated so i was hoping to avoid
> that
> 
> Here's the whole of our RT config in apache.  First, install and enable
> the mod_fastcgi module in apache 2.2, then use the following, but
> adjust the file paths to match where you put things. Note that the
> trailing / in the Alias to mason_handler.fcgi is important.
> 
> Also you will want to make sure that the mason cache directory is
> writable by the user your apache runs under.  it will complain if this
> is not the case.
> 
> # RT3 Setup
> 
> 
> AllowOverride None
> Order allow,deny
> Allow from all
> 
> 
> 
> # set idle timeout a bit longer than RT's idle timeout.
> FastCgiServer /usr/local/share/rt38/bin/mason_handler.fcgi -processes 8
> -idle-timeout 305
> 
> 
> ServerName rt.example.com
> DocumentRoot "/usr/local/share/rt38/html"
> AddDefaultCharset UTF-8
> ErrorLog /var/log/httpd-rt-error.log
> CustomLog /var/log/httpd-rt-access.log combined
> AddHandler fastcgi-script fcgi
> 
> Alias /NoAuth/images /usr/local/share/rt38/html/NoAuth/images
> Alias / /usr/local/share/rt38/bin/mason_handler.fcgi/
> 
> 
> 
> # END RT3 Setup
> ###
> 
> 
> 
> "RK&K" and "RK&K Engineers" are registered trade names of Rummel,
> Klepper & Kahl, LLP, a Maryland
> limited liability partnership.  This message contains confidential
> information intended only for
> the person or persons named above.  If you have received this message
> in error, please immediately
> notify the sender by return email and delete the message.  Thank you.
The information transmitted is intended only for the person or entity to which
it is addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any action
in reliance upon, this information by persons or entities other than the
intended recipient is prohibited. If you are not the intended recipient of this 
message, please contact the sender and delete this material from this computer.

Re: [rt-users] httpd2-prefork segfaulting on SLES11

[Darin Perusich]

I setup RT on my home PC last night, opensuse 11.2, and I'm seeing the same seg 
fault it so that tells me it's not vmware. Are you running via mod_perl or 
fastcgi? I'm using mod_perl and my next move was to try fastcgi.

--
Darin Perusich
Email: darin.perus...@ctg.com
Office: 716-888-3690
Cell: 716-807-4589


> -Original Message-
> From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-
> boun...@lists.bestpractical.com] On Behalf Of Brian Dial
> Sent: Thursday, November 04, 2010 5:48 PM
> To: rt-users@lists.bestpractical.com
> Subject: Re: [rt-users] httpd2-prefork segfaulting on SLES11
> 
> interesting.  we're running it in vmware as well.  but i'm inclined to
> think it's more of a suse thing than a vmware thing.  thanks for the
> suggestions.  maybe i can work that into the init script since my main
> concern is that it starts on boot in case the machine has to be
> rebooted when i'm not around to make sure apache restarts correctly.
> 
> - Original Message -
> Brian,
> 
> I'm getting this same thing only on opensuse 11.3 x86_x64 running under
> VMware. I've been beating my head against it most of the day and making
> nearly zero headway. I've tried both httpd2-perfork and worker but it
> doesn't matter, sometimes is starts, mostly is doesn't. I see this
> behavior when installing the perl modules from either CPAN or the
> devel:languages:perl.repo.
> 
> I have been able to get it to start successfully doing the follow. It's
> ugly but it works.
> 
> - /etc/init.d/apache2 stop
> - mv /etc/apache2/conf.d/rt.conf /etc/apache2/conf.d/rt.off
> - /etc/init.d/apache2 start
> - mv /etc/apache2/conf.d/rt.off /etc/apache2/conf.d/rt.conf
> - /etc/init.d/apache2 reload
> 
> SegFault errors.
> httpd2-worker[13254]: segfault at 7f0ed3c173e8 ip 7f0ece748bb0 sp
> 7fff60526d60 error 4 in libc-2.11.2.so[7f0ece714000+156000]
> httpd2-prefork[13015]: segfault at 7f87b75a1f98 ip 7f87b20b5bb0 sp
> 7fff2657f100 error 4 in libc-2.11.2.so[7f87b2081000+156000]
> 
> --
> Darin Perusich
> Email: darin.perus...@ctg.com
> Office: 716-888-3690
> Cell: 716-807-4589
> 
> 
> > -Original Message-
> > From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-
> > boun...@lists.bestpractical.com] On Behalf Of Brian Dial
> > Sent: Thursday, November 04, 2010 3:24 PM
> > To: rt-users@lists.bestpractical.com
> > Subject: [rt-users] httpd2-prefork segfaulting on SLES11
> >
> > i'm having problems with running RT 3.8.8 on SLES11.  4/5 times when
> i
> > try to start apache it segfaults
> >
> >
> > [16167.712443] httpd2-prefork[24765]: segfault at ba37a3d4 ip
> b742f3b1
> > sp bfad70a4 error 4 in libc-2.11.1.so[b7402000+15b000]
> >
> >
> > when it does start, rt works fine though.  i've had this on several
> > builds i've done as i've been playing with RT.  Its similar to
> another
> > issue someone had with opensuse 11 (http://www.gossamer-
> > threads.com/lists/rt/users/96624)
> >
> > The first build I did, I let make fixdeps do most of the work
> > installing moduls from cpan.  I did another build today where I tried
> > to install as many modules as possible from the sles sdk cd.  results
> > were the same always.
> >
> > I did a strace httpd2-prefork -X and see this
> >
> >
> > time(NULL)  = 1288898480
> > semget(IPC_PRIVATE, 1, IPC_CREAT|0600)  = 524291
> > semctl(524291, 0, IPC_64|SETVAL, 0xbff7cfd8) = 0
> > geteuid32() = 0
> > semctl(524291, 0, IPC_64|IPC_SET, 0xbff7cfa8) = 0
> > gettimeofday({1288898480, 105778}, NULL) = 0
> > write(2, "[Thu Nov 04 15:21:20 2010] [warn"..., 96) = 96
> > stat64("/usr/lib/perl5/vendor_perl/5.10.0/i586-linux-thread-
> > multi/auto/DBI/DESTROY.al", 0xb793f460) = -1 ENOENT (No such file or
> > directory)
> > stat64("/srv/www/perl-lib/auto/DBI/DESTROY.al", 0xbff7ca80) = -1
> ENOENT
> > (No such file or directory)
> > stat64("/opt/rt/bin/../local/lib/auto/DBI/DESTROY.al", 0xbff7ca80) =
> -1
> > ENOENT (No such file or directory)
> > stat64("/opt/rt/bin/../lib/auto/DBI/DESTROY.al", 0xbff7ca80) = -1
> > ENOENT (No such file or directory)
> > stat64("/usr/lib/perl5/5.10.0/i586-linux-thread-
> > multi/auto/DBI/DESTROY.al", 0xbff7ca80) = -1 ENOENT (No such file or
> > directory)
> > stat64("/usr/lib/perl5/5.10.0/auto/DBI/DESTROY.al", 0xbff7ca80) = -1
> > ENOENT (No such file or directory)
> > stat64("

Re: [rt-users] httpd2-prefork segfaulting on SLES11

[Darin Perusich]

Oh, there was a similar issue on opensuse related to hald-probe-inpu seg 
faulting. libc-2.11.2.so is part of the glibc-32bit package which was recently 
updated, build date of the rpm is 27 Oct 2010. I haven't backed out of the 
patch but maybe it's releated.

https://bugzilla.novell.com/show_bug.cgi?id=577489
http://forums.opensuse.org/english/get-help-here/pre-release-beta/441429-errors-boot.html

--
Darin Perusich
Email: darin.perus...@ctg.com
Office: 716-888-3690
Cell: 716-807-4589


> -Original Message-
> From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-
> boun...@lists.bestpractical.com] On Behalf Of Darin Perusich
> Sent: Thursday, November 04, 2010 4:08 PM
> To: Brian Dial; rt-users@lists.bestpractical.com
> Subject: Re: [rt-users] httpd2-prefork segfaulting on SLES11
> 
> Brian,
> 
> I'm getting this same thing only on opensuse 11.3 x86_x64 running under
> VMware. I've been beating my head against it most of the day and making
> nearly zero headway. I've tried both httpd2-perfork and worker but it
> doesn't matter, sometimes is starts, mostly is doesn't. I see this
> behavior when installing the perl modules from either CPAN or the
> devel:languages:perl.repo.
> 
> I have been able to get it to start successfully doing the follow. It's
> ugly but it works.
> 
> - /etc/init.d/apache2 stop
> - mv /etc/apache2/conf.d/rt.conf /etc/apache2/conf.d/rt.off
> - /etc/init.d/apache2 start
> - mv /etc/apache2/conf.d/rt.off /etc/apache2/conf.d/rt.conf
> - /etc/init.d/apache2 reload
> 
> SegFault errors.
> httpd2-worker[13254]: segfault at 7f0ed3c173e8 ip 7f0ece748bb0 sp
> 7fff60526d60 error 4 in libc-2.11.2.so[7f0ece714000+156000]
> httpd2-prefork[13015]: segfault at 7f87b75a1f98 ip 7f87b20b5bb0 sp
> 7fff2657f100 error 4 in libc-2.11.2.so[7f87b2081000+156000]
> 
> --
> Darin Perusich
> Email: darin.perus...@ctg.com
> Office: 716-888-3690
> Cell: 716-807-4589
> 
> 
> > -Original Message-
> > From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-
> > boun...@lists.bestpractical.com] On Behalf Of Brian Dial
> > Sent: Thursday, November 04, 2010 3:24 PM
> > To: rt-users@lists.bestpractical.com
> > Subject: [rt-users] httpd2-prefork segfaulting on SLES11
> >
> > i'm having problems with running RT 3.8.8 on SLES11.  4/5 times when
> i
> > try to start apache it segfaults
> >
> >
> > [16167.712443] httpd2-prefork[24765]: segfault at ba37a3d4 ip
> b742f3b1
> > sp bfad70a4 error 4 in libc-2.11.1.so[b7402000+15b000]
> >
> >
> > when it does start, rt works fine though.  i've had this on several
> > builds i've done as i've been playing with RT.  Its similar to
> another
> > issue someone had with opensuse 11 (http://www.gossamer-
> > threads.com/lists/rt/users/96624)
> >
> > The first build I did, I let make fixdeps do most of the work
> > installing moduls from cpan.  I did another build today where I tried
> > to install as many modules as possible from the sles sdk cd.  results
> > were the same always.
> >
> > I did a strace httpd2-prefork -X and see this
> >
> >
> > time(NULL)  = 1288898480
> > semget(IPC_PRIVATE, 1, IPC_CREAT|0600)  = 524291
> > semctl(524291, 0, IPC_64|SETVAL, 0xbff7cfd8) = 0
> > geteuid32() = 0
> > semctl(524291, 0, IPC_64|IPC_SET, 0xbff7cfa8) = 0
> > gettimeofday({1288898480, 105778}, NULL) = 0
> > write(2, "[Thu Nov 04 15:21:20 2010] [warn"..., 96) = 96
> > stat64("/usr/lib/perl5/vendor_perl/5.10.0/i586-linux-thread-
> > multi/auto/DBI/DESTROY.al", 0xb793f460) = -1 ENOENT (No such file or
> > directory)
> > stat64("/srv/www/perl-lib/auto/DBI/DESTROY.al", 0xbff7ca80) = -1
> ENOENT
> > (No such file or directory)
> > stat64("/opt/rt/bin/../local/lib/auto/DBI/DESTROY.al", 0xbff7ca80) =
> -1
> > ENOENT (No such file or directory)
> > stat64("/opt/rt/bin/../lib/auto/DBI/DESTROY.al", 0xbff7ca80) = -1
> > ENOENT (No such file or directory)
> > stat64("/usr/lib/perl5/5.10.0/i586-linux-thread-
> > multi/auto/DBI/DESTROY.al", 0xbff7ca80) = -1 ENOENT (No such file or
> > directory)
> > stat64("/usr/lib/perl5/5.10.0/auto/DBI/DESTROY.al", 0xbff7ca80) = -1
> > ENOENT (No such file or directory)
> > stat64("/usr/lib/perl5/site_perl/5.10.0/i586-linux-thread-
> > multi/auto/DBI/DESTROY.al", 0xbff7ca80) = -1 ENOENT (No such file or
> > directory)
> > stat64("/usr/lib/perl5/site_perl/5.10.0/auto/DBI/DESTROY.al",

Re: [rt-users] httpd2-prefork segfaulting on SLES11

[Darin Perusich]

Brian,

I'm getting this same thing only on opensuse 11.3 x86_x64 running under VMware. 
I've been beating my head against it most of the day and making nearly zero 
headway. I've tried both httpd2-perfork and worker but it doesn't matter, 
sometimes is starts, mostly is doesn't. I see this behavior when installing the 
perl modules from either CPAN or the devel:languages:perl.repo.

I have been able to get it to start successfully doing the follow. It's ugly 
but it works.

- /etc/init.d/apache2 stop
- mv /etc/apache2/conf.d/rt.conf /etc/apache2/conf.d/rt.off
- /etc/init.d/apache2 start
- mv /etc/apache2/conf.d/rt.off /etc/apache2/conf.d/rt.conf
- /etc/init.d/apache2 reload

SegFault errors.
httpd2-worker[13254]: segfault at 7f0ed3c173e8 ip 7f0ece748bb0 sp 
7fff60526d60 error 4 in libc-2.11.2.so[7f0ece714000+156000]
httpd2-prefork[13015]: segfault at 7f87b75a1f98 ip 7f87b20b5bb0 sp 
7fff2657f100 error 4 in libc-2.11.2.so[7f87b2081000+156000]

--
Darin Perusich
Email: darin.perus...@ctg.com
Office: 716-888-3690
Cell: 716-807-4589


> -Original Message-
> From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-
> boun...@lists.bestpractical.com] On Behalf Of Brian Dial
> Sent: Thursday, November 04, 2010 3:24 PM
> To: rt-users@lists.bestpractical.com
> Subject: [rt-users] httpd2-prefork segfaulting on SLES11
> 
> i'm having problems with running RT 3.8.8 on SLES11.  4/5 times when i
> try to start apache it segfaults
> 
> 
> [16167.712443] httpd2-prefork[24765]: segfault at ba37a3d4 ip b742f3b1
> sp bfad70a4 error 4 in libc-2.11.1.so[b7402000+15b000]
> 
> 
> when it does start, rt works fine though.  i've had this on several
> builds i've done as i've been playing with RT.  Its similar to another
> issue someone had with opensuse 11 (http://www.gossamer-
> threads.com/lists/rt/users/96624)
> 
> The first build I did, I let make fixdeps do most of the work
> installing moduls from cpan.  I did another build today where I tried
> to install as many modules as possible from the sles sdk cd.  results
> were the same always.
> 
> I did a strace httpd2-prefork -X and see this
> 
> 
> time(NULL)  = 1288898480
> semget(IPC_PRIVATE, 1, IPC_CREAT|0600)  = 524291
> semctl(524291, 0, IPC_64|SETVAL, 0xbff7cfd8) = 0
> geteuid32() = 0
> semctl(524291, 0, IPC_64|IPC_SET, 0xbff7cfa8) = 0
> gettimeofday({1288898480, 105778}, NULL) = 0
> write(2, "[Thu Nov 04 15:21:20 2010] [warn"..., 96) = 96
> stat64("/usr/lib/perl5/vendor_perl/5.10.0/i586-linux-thread-
> multi/auto/DBI/DESTROY.al", 0xb793f460) = -1 ENOENT (No such file or
> directory)
> stat64("/srv/www/perl-lib/auto/DBI/DESTROY.al", 0xbff7ca80) = -1 ENOENT
> (No such file or directory)
> stat64("/opt/rt/bin/../local/lib/auto/DBI/DESTROY.al", 0xbff7ca80) = -1
> ENOENT (No such file or directory)
> stat64("/opt/rt/bin/../lib/auto/DBI/DESTROY.al", 0xbff7ca80) = -1
> ENOENT (No such file or directory)
> stat64("/usr/lib/perl5/5.10.0/i586-linux-thread-
> multi/auto/DBI/DESTROY.al", 0xbff7ca80) = -1 ENOENT (No such file or
> directory)
> stat64("/usr/lib/perl5/5.10.0/auto/DBI/DESTROY.al", 0xbff7ca80) = -1
> ENOENT (No such file or directory)
> stat64("/usr/lib/perl5/site_perl/5.10.0/i586-linux-thread-
> multi/auto/DBI/DESTROY.al", 0xbff7ca80) = -1 ENOENT (No such file or
> directory)
> stat64("/usr/lib/perl5/site_perl/5.10.0/auto/DBI/DESTROY.al",
> 0xbff7ca80) = -1 ENOENT (No such file or directory)
> stat64("/usr/lib/perl5/vendor_perl/5.10.0/i586-linux-thread-
> multi/auto/DBI/DESTROY.al", 0xbff7ca80) = -1 ENOENT (No such file or
> directory)
> stat64("/usr/lib/perl5/vendor_perl/5.10.0/auto/DBI/DESTROY.al",
> 0xbff7ca80) = -1 ENOENT (No such file or directory)
> stat64("/usr/lib/perl5/vendor_perl/auto/DBI/DESTROY.al", 0xbff7ca80) =
> -1 ENOENT (No such file or directory)
> stat64("./auto/DBI/DESTROY.al", 0xbff7ca80) = -1 ENOENT (No such file
> or directory)
> stat64("/srv/www/auto/DBI/DESTROY.al", 0xbff7ca80) = -1 ENOENT (No such
> file or directory)
> brk(0xba64c000) = 0xba64c000
> munmap(0xb61de000, 135168)  = 0
> brk(0xba625000) = 0xba625000
> brk(0xba602000) = 0xba602000
> brk(0xba5e) = 0xba5e
> brk(0xba5be000) = 0xba5be000
> brk(0xba599000) = 0xba599000
> munmap(0xb6ea8000, 24764)   = 0
> 
> (...)
> 
> 
> munmap(0xb778c000, 8352)= 0
> --- SIGSEGV (Segmentation fault) @ 0 (0) 

Re: [rt-users] Frustrating attempts to install RT3.8 from RPM

[Darin Perusich]

A few questions about your openSuSE packages. Are you using the
devel:languages:/perl repository for your perl dependencies? Would you
be willing to make your rpms available or at least the .spec? 

--
Darin Perusich
Email: darin.perus...@ctg.com
Office: 716-888-3690
Cell: 716-807-4589


> -Original Message-
> From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-
> boun...@lists.bestpractical.com] On Behalf Of Gary Greene
> Sent: Wednesday, November 03, 2010 2:52 PM
> To: Wes Modes; rt-users@lists.bestpractical.com
> Subject: Re: [rt-users] Frustrating attempts to install RT3.8 from RPM
> 
> Agreed. This is why I spent a week with cpan2rpm and built packages
for
> both
> openSuSE (which we're transitioning to) and CentOS.
> 
> 
> On 3/11/10 11:21 AM, "Wes Modes"  wrote:
> 
> > Paul, sounds like you aren't a long term fan of Fedora, RHEL, or
> CentOS,
> > so I'm guessing yum feels like an inconvenience to you, especially
> when
> > it seems to be getting in the way of your desired install.
> >
> > I've been a sysadmin for 20 years and I've never been a fan of the
> make
> > 'n' break style of system administration.  There is no way I could
> > manage a score of machines, many with subtly different hardware, if
I
> > had to build every package the old way.  As it is, I can spend a few
> > hours monthly updating the OS and all installed software on all of
> our
> > machines, with a simple "yum -y update"
> >
> > In my opinion, package managers like apt-get and yum are some of the
> > best things to happen to OS in a very long time.  Having installs
> > tracked and managed by package managers keeps complicated OSs and
> their
> > installed software up-to-date, eases system administration
> (especially
> > as the server to sysadmin ratio increases), increases scalability,
> > increases sysadmin efficiency, and creates standards for software
> > manufacturers.
> >
> > If as a conservative sysadmin you prefer to operate well-back from
> the
> > bleeding edge anyway, the small trade-off in control is a small
price
> to
> > pay.
> >
> > It is hardly the package manager's fault if a software manufacturer
> such
> > as Best Practical and its user community fail to create a package
for
> > the latest software.  Compare that to software whose RPMs are kept
> > relatively up-to-date.
> >
> > Wes
> >
> > On 11/2/2010 3:49 PM, Paul wrote:
> >> On 11/02/2010 02:19 PM, Wes Modes wrote:
> >>> Hello, I have been struggling with attempts to install RT3.8 via
> RPMs.
> >>>
> >>> I know it is perfectly possible to install RT3.8 using the BP
> install
> >>> scripts and docs, but I'd prefer to do it through yum for system
> >>> sustainability, ease of updates and upgrades, etc.
> >> ...
> >>> If I can't resolve this, I will just forget about RT3.8 and stick
> with
> >>> RT3.6 of which there is a well-behaved RPM already in the EPEL
> repo.
> >>>
> >>> Wes
> >>>
> >> I'm currently going through a RT move from freebsd to rhel5 (long
> story,
> >> would rather stay with freebsd but don't have a choice here) and
> have
> >> found all kinds of annoying difficulties with yum (or, rather, the
> >> packages available.) When I realized that I was trying to stick
with
> yum
> >> for ease of upgrades when yum was preventing me from easily keeping
> up
> >> to date, life got a lot easier.
> >>
> >> In the end I just let cpan install what it could and used yum for
> the
> >> things that gave me trouble in cpan. Using RT's configure and make
> >> targets is a lot easier and much more maintainable than having to
> roll
> >> my own rpm just to do it the yum way.
> >>
> >> Being stuck with an old version of the software in the name of easy
> >> upgrades didn't make sense to me.
> >>
> >> Cheers,
> >> Paul
> 
> --
> Gary L. Greene, Jr.
> IT Operations
> Minerva Networks, Inc.
> Cell:   (650) 704-6633
> Office: (408) 240-1239
> 

The information transmitted is intended only for the person or entity to which
it is addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any action
in reliance upon, this information by persons or entities other than the
intended recipient is prohibited. If you are not the intended recipient of this 
message, please contact the sender and delete this material from this computer.