[rt-users] sendmailpipe returns EX_TEMPFAIL

2013-08-13 Thread Nathan Cutler
Greetings:

We are having an problem with Postfix sendmail returning code 75
(EX_TEMPFAIL) on outgoing emails from RT. I have been monitoring the
bug and can find no rhyme or reason to it. Most of the time, emails
leave RT without any trouble. But occasionally they fail
unreproducibly like this:

Aug 12 08:01:16 perelman RT:
rt-4.0.13-29527-1376287275-1791.35212-...@suse.de #35212/333905 -
Scrip 4 On Create Notify AdminCcs
(/usr/lib/perl5/vendor_perl/5.10.0/RT/Action/SendEmail.pm:285)
Aug 12 08:01:16 perelman RT:
rt-4.0.13-29527-1376287275-1791.35212-...@suse.de:
`/usr/sbin/sendmail -oi -t` exited with code 75
(/usr/lib/perl5/vendor_perl/5.10.0/RT/Interface/Email.pm:486)
Aug 12 08:01:16 perelman RT:
rt-4.0.13-29527-1376287275-1791.35212-...@suse.de: Could not send
mail with command `/usr/sbin/sendmail -oi -t`:
rt-4.0.13-29527-1376287275-1791.35212-...@suse.de:
`/usr/sbin/sendmail -oi -t` exited with code 75 at
/usr/lib/perl5/vendor_perl/5.10.0/RT/Interface/Email.pm line 487.
Stack:   [/usr/lib/perl5/vendor_perl/5.10.0/RT/Interface/Email.pm:487]
  [/usr/lib/perl5/vendor_perl/5.10.0/RT/Action/SendEmail.pm:292]
[/usr/lib/perl5/vendor_perl/5.10.0/RT/Action/SendEmail.pm:114]
[/usr/lib/perl5/vendor_perl/5.10.0/RT/ScripAction.pm:232]
[/usr/lib/perl5/vendor_perl/5.10.0/RT/Scrip.pm:475]
[/usr/lib/perl5/vendor_perl/5.10.0/RT/Scrips.pm:188]
[/usr/lib/perl5/vendor_perl/5.10.0/RT/Transaction.pm:201]
[/usr/lib/perl5/vendor_perl/5.10.0/RT/Record.pm:1504]
[/usr/lib/perl5/vendor_perl/5.10.0/RT/Ticket.pm:682]
[/usr/lib/perl5/vendor_perl/5.10.0/RT/Interface/Email.pm:1569]
[/usr/share/request-tracker/html/REST/1.0/NoAuth/mail-gateway:61]
(/usr/lib/perl5/vendor_perl/5.10.0/RT/Interface/Email.pm:491)

This is RT 4.0.13 and we are running it on a virtual machine with 8GB
of RAM. Free RAM is around 80%, so the problem is not memory-related.
There is one other mod_perl application running on the same machine,
but adding PerlOptions +Parent to the Apache vhost configuration
didn't help. (Do I need to add it to the vhost configuration of the
other mod_perl app, too?)

In RT_SiteConfig.pm I have:

Set($SendmailCommand, 'sendmailpipe');
Set($SendmailArguments, '-oi -t');

I'm running a fairly modern Postfix (v. 2.5.13) on a fairly modern OS
(SLES11-SP2). Here's apache2ctl -V:

# apache2ctl -V
Server version: Apache/2.2.12 (Linux/SUSE)
Server built:   Mar 27 2013 18:47:49
Server's Module Magic Number: 20051115:23
Server loaded:  APR 1.3.3, APR-Util 1.3.4
Compiled using: APR 1.3.3, APR-Util 1.3.4
Architecture:   64-bit
Server MPM: Prefork
  threaded: no
forked: yes (variable process count)
Server compiled with
 -D APACHE_MPM_DIR=server/mpm/prefork
 -D APR_HAS_SENDFILE
 -D APR_HAS_MMAP
 -D APR_HAVE_IPV6 (IPv4-mapped addresses enabled)
 -D APR_USE_SYSVSEM_SERIALIZE
 -D APR_USE_PTHREAD_SERIALIZE
 -D SINGLE_LISTEN_UNSERIALIZED_ACCEPT
 -D APR_HAS_OTHER_CHILD
 -D AP_HAVE_RELIABLE_PIPED_LOGS
 -D DYNAMIC_MODULE_LIMIT=128
 -D HTTPD_ROOT=/srv/www
 -D SUEXEC_BIN=/usr/sbin/suexec2
 -D DEFAULT_PIDLOG=/var/run/httpd2.pid
 -D DEFAULT_SCOREBOARD=logs/apache_runtime_status
 -D DEFAULT_LOCKFILE=/var/run/accept.lock
 -D DEFAULT_ERRORLOG=/var/log/apache2/error_log
 -D AP_TYPES_CONFIG_FILE=/etc/apache2/mime.types
 -D SERVER_CONFIG_FILE=/etc/apache2/httpd.conf

What appears to be happening is this: for reasons unknown,
occasionally when RT goes to send an email, the sendmailpipe command
('/usr/bin/sendmail -oi -t') gets executed but nothing is piped in.
This causes sendmail to report:

postfix/sendmail[23352]: fatal: wwwrun(30): No recipient addresses
found in message header

and RT logs the code 75 error quoted above. In the web UI, when I
look at the transaction with headers, it says:

X-RT-Interface: API
MIME-Version: 1.0
X-Mailer: MIME-tools 5.502 (Entity 5.502)
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: ascii
RT-Message-ID: rt-4.0.13-29527-1376293428-636.35212-...@suse.de
Content-Length: 105

Sending the previous mail has failed.  Please contact your admin, they
can find more details in the logs.

Yesterday I added the '-v' switch to the sendmail command line, which
is causing mail delivery reports to be sent to a local user on the
machine. These mail delivery reports reproduce all the headers. I have
not managed to capture the bug in this way, yet, however. But as
soon as I do I will post the mail delivery report here.

Does anyone have any other ideas for debugging this issue? Especially
I am interested in how I could confirm or deny that it's related to
mod_perl cohabitation -- i.e. two different Perl applications in a
single mod_perl host?

Nathan


Re: [rt-users] sendmailpipe returns EX_TEMPFAIL

2013-08-13 Thread Nathan Cutler
 Does anyone have any other ideas for debugging this issue? Especially
 I am interested in how I could confirm or deny that it's related to
 mod_perl cohabitation -- i.e. two different Perl applications in a
 single mod_perl host?

I noticed that when I don't have PerlOptions +Parent in the apache
config, the Perl library search order on the System Configuration page
is different than when I do. Here's what it looks like _without_
PerlOptions +Parent (omitting the line numbers which do not
copy-paste):

Perl library search order

/usr/share/request-tracker/local/lib
/usr/share/request-tracker/local/plugins/RT-Extension-MergeUsers/lib
/usr/lib/perl5/vendor_perl/5.10.0
/usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi
/srv/www/perl-lib
/srv/www/vhosts/pdb/
/usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi
/usr/lib/perl5/site_perl/5.10.0
/usr/lib/perl5/vendor_perl
/usr/lib/perl5/5.10.0/x86_64-linux-thread-multi
/usr/lib/perl5/5.10.0
.
/srv/www

Notice lines 5 and 6 which obviously come from the other mod_perl application.

Now, here's what it says _with_ PerlOptions +Parent:

Perl library search order

/usr/share/request-tracker/local/lib
/usr/share/request-tracker/local/plugins/RT-Extension-MergeUsers/lib
/usr/lib/perl5/vendor_perl/5.10.0
/usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi
/usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi
/usr/lib/perl5/site_perl/5.10.0
/usr/lib/perl5/vendor_perl
/usr/lib/perl5/5.10.0/x86_64-linux-thread-multi
/usr/lib/perl5/5.10.0
.
/srv/www

So maybe the problem is solved? I did have PerlOptions +Parent in the
apache configuration before, but maybe not correctly? I checked the
other application's vhosts file and it _does_ have PerlOptions
+Parent.

Nathan


Re: [rt-users] Trying to retrive the Queue Description.

2013-08-13 Thread Kevin Falcone
On Mon, Aug 12, 2013 at 09:08:38PM +, Bryon Baker wrote:
my $qname = $self-TicketObj-QueueObj-Name;
my $qdescription = $self-QueueObj-Description (Name = $qname);

You don't say how this failed (since I expect it was a runtime error
in your logs) but compare how in the first line you got a ticket, got
the queue, requested the name with the second line where you skipped
the ticket and went right to queue.  

Also, the (Name = $qname) part is nonsense and I'm not sure why you
thought you needed it?

-kevin


pgpgkVhl4qT2Y.pgp
Description: PGP signature


Re: [rt-users] How to add articles to response

2013-08-13 Thread Max McGrath
Was a permissions thing.  From what I saw, the Article in question was
applied to appropriate queue, but I still was not seeing it.  I ended up
clicking the *check this box to apply this Class globally to all Queues *and
that fixed it.

Not sure why it didn't work with how it was originally set up.

Thanks Kevin!

Max

--
Max McGrath
Network Administrator
Carthage College
262-552-5512
mmcgr...@carthage.edu


On Mon, Aug 12, 2013 at 3:18 PM, Kevin Falcone falc...@bestpractical.comwrote:

 On Mon, Aug 12, 2013 at 02:45:21PM -0500, Max McGrath wrote:
 Running rt 4.0.16 -- and this used to work when I was on 4.0.6.
 When replying to a ticket I see the Search for Articles matching and
 the Include Article
 boxes, but neither of them are working for me (I've tried different
 browsers).
 In 4.0.6 there was a drop-down of all the available articles. In
 4.0.16 there is a Go button
 that does nothing when I click it.
 Am I missing something?

 This is working for us on a production 4.0.17 instance, so I'd suspect
 some local change.

 What kind of local modifications do you have?
 Can you see the Articles you expect to see if you browse around?
 Check other permissions and whether or not Classes apply to the right
 Queues.

 -kevin



Re: [rt-users] How to add articles to response

2013-08-13 Thread Max McGrath
Nevermind!  My mistake...

It is working as it is suppose to.  It had permissions for a specific
queue, and the ticket I was working on was not in that queue.

Disregard!

Max

--
Max McGrath
Network Administrator
Carthage College
262-552-5512
mmcgr...@carthage.edu


On Tue, Aug 13, 2013 at 8:36 AM, Max McGrath mmcgr...@carthage.edu wrote:

 Was a permissions thing.  From what I saw, the Article in question was
 applied to appropriate queue, but I still was not seeing it.  I ended up
 clicking the *check this box to apply this Class globally to all Queues *and
 that fixed it.

 Not sure why it didn't work with how it was originally set up.

 Thanks Kevin!

 Max

 --
 Max McGrath
 Network Administrator
 Carthage College
 262-552-5512
 mmcgr...@carthage.edu


 On Mon, Aug 12, 2013 at 3:18 PM, Kevin Falcone 
 falc...@bestpractical.comwrote:

 On Mon, Aug 12, 2013 at 02:45:21PM -0500, Max McGrath wrote:
 Running rt 4.0.16 -- and this used to work when I was on 4.0.6.
 When replying to a ticket I see the Search for Articles matching and
 the Include Article
 boxes, but neither of them are working for me (I've tried different
 browsers).
 In 4.0.6 there was a drop-down of all the available articles. In
 4.0.16 there is a Go button
 that does nothing when I click it.
 Am I missing something?

 This is working for us on a production 4.0.17 instance, so I'd suspect
 some local change.

 What kind of local modifications do you have?
 Can you see the Articles you expect to see if you browse around?
 Check other permissions and whether or not Classes apply to the right
 Queues.

 -kevin





[rt-users] RT-at-a-Glance Saved Searches not showing RT System searches

2013-08-13 Thread Joe Kirby

Joe Kirby ,  Assistant Vice President, Business Systems
Division of Information Technology (DoIT) 
Support Response -   http://www.umbc.edu/doit 
Administration 627
Office - 410-455-3020 
Email - ki...@umbc.edu

On Aug 9, 2013, at 12:00 PM, rt-users-requ...@lists.bestpractical.com wrote:

 Send rt-users mailing list submissions to
   rt-users@lists.bestpractical.com
 
 To subscribe or unsubscribe via the World Wide Web, visit
   http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
 or, via email, send a message with subject or body 'help' to
   rt-users-requ...@lists.bestpractical.com
 
 You can reach the person managing the list at
   rt-users-ow...@lists.bestpractical.com
 
 When replying, please edit your Subject line so it is more specific
 than Re: Contents of rt-users digest...
 
 
 Today's Topics:
 
   1. Lost Root Password (Dennis Comeaux)
   2. Re: Migration Prep (Paul O'Rorke)
   3. Re: nginx / varnish / apache with RT? (Asif Iqbal)
   4. Searching for a string (Bryon Baker)
   5. Re: custom fields on dashboard for new tickets? (window camera)
   6. RT-at-a-Glance Saved Searches not showing RT System  searches
  (Joe Kirby)
   7. Re: Migration Prep (Paul O'Rorke)
   8. Re: error when replace bpslogo.png file (Chrilly Cheng)
   9. Re: Migration Prep (Paul O'Rorke)
  10. Re: Searching for a string (Nathan Cutler)
 
 
 --
 
 Message: 1
 Date: Thu, 8 Aug 2013 11:43:47 -0500
 From: Dennis Comeaux dennis.come...@gmail.com
 To: rt-users@lists.bestpractical.com
 Subject: [rt-users] Lost Root Password
 Message-ID:
   cap52nhm2w_oswzwypr9zyi1dqf7z811pe2tchnzwm6kztg1...@mail.gmail.com
 Content-Type: text/plain; charset=utf-8
 
 Another one of these threads.
 
 * Root password for Linux known
 * RT 3.8.4
 * http://requesttracker.wikia.com/wiki/RecoverRootPassword didn't work
 * we have httpd restrictions on the website taht require login that
 authenticates against an ldap server
 * other users can login... but we can't get in as root and root doesn't
 seem to have an account on the ldap server
 
 Anyone have ideas? It looks like RT takes the userid and auth from ldap as
 well.
 
 Can I just make a different account admin level?  I need to just move some
 users around from one queue to another.  I know its the ldap auth.
 
 
 -- 
 il n'y a pas de libert? s'il y a d?pendance
   --Theobalt
 -- next part --
 An HTML attachment was scrubbed...
 URL: 
 http://lists.bestpractical.com/pipermail/rt-users/attachments/20130808/941e8d25/attachment-0001.html
 
 --
 
 Message: 2
 Date: Thu, 08 Aug 2013 10:41:52 -0700
 From: Paul O'Rorke p...@tracker-software.com
 To: rt-users@lists.bestpractical.com
 Subject: Re: [rt-users] Migration Prep
 Message-ID: 5203d860.5000...@tracker-software.com
 Content-Type: text/plain; charset=utf-8; Format=flowed
 
 Just a heads up that running the make upgrade-database on an upgrade 
 from 3.8.4 to 4.0.17 worked flawlessly once I successfully restored the 
 DB from mysqldump.
 
 Thanks for the help and more importantly thanks for fixing that script.
 
 :-)
 
 *Paul O?Rorke*
 Tracker Software Products
 p...@tracker-software.com mailto:paul.oro...@tracker-software.com
 
 On 8/2/2013 10:23 AM, Thomas Sibley wrote:
 On 08/02/2013 10:04 AM, Kevin Falcone wrote:
 On Fri, Aug 02, 2013 at 12:49:47PM -0400, Asif Iqbal wrote:
  Please show a log of your make upgrade-database step
 
* 3.9.8
* 4.0.1
 That's definitely skipping steps.
 
 It should read:
 * 3.9.8
 * 4.0.0rc2
 * 4.0.0rc4
 * 4.0.0rc7
 * 4.0.1
 Paul and Asif, you've helped uncover a regression in RT's upgrade logic
 beginning in 4.0.14.  It only affects folks who are upgrading from an RT
 3.8.x (or older) install to 4.0.14 or higher.  If you're upgrading from
 4.0.0 or higher, you're unaffected.
 
 4.0.17 will be out shortly to correct this regression.  Thanks for your
 time spent debugging on the list.
 
 -- next part --
 An HTML attachment was scrubbed...
 URL: 
 http://lists.bestpractical.com/pipermail/rt-users/attachments/20130808/b599c0c8/attachment-0001.html
 
 --
 
 Message: 3
 Date: Thu, 8 Aug 2013 15:28:54 -0400
 From: Asif Iqbal vad...@gmail.com
 To: k...@rice.edu k...@rice.edu
 Cc: rt-users Users rt-users@lists.bestpractical.com,Chris Herrmann
   chrisherrma...@gmail.com
 Subject: Re: [rt-users] nginx / varnish / apache with RT?
 Message-ID:
   caohbbgx4d_bgbicfkdhgllsecfehf3sz9eihopt0nnwb90x...@mail.gmail.com
 Content-Type: text/plain; charset=iso-8859-1
 
 On Tue, Aug 6, 2013 at 12:15 PM, Asif Iqbal vad...@gmail.com wrote:
 
 care to share your nginx/fascgi config ? I am seeing one in the
 http://bestpractical.com/docs/rt/latest/web_deployment.html#nginx
 as a start.
 
 
 I used that from doc with an exception of adding some ssl options and
 adding fastcgi_param  HTTPS on;
 
 It works 

[rt-users] Migration to RT 4.0.17 from 3.8.9 with new server

2013-08-13 Thread Lois Bennett
Hello,

I have read the documentation on upgrading and  none of the particulars
exactly fit.

I have a new VM (Centos6).  I have installed RT 4.0.17 completely vanilla.

Old mysql:
mysql  Ver 14.12 Distrib 5.0.81, for unknown-linux-gnu (x86_64) using
readline 5.2
Old RT is  3.8.9

New mysql:
mysql  Ver 14.14 Distrib 5.1.66, for redhat-linux-gnu (x86_64) using
readline 5.1

All has gone well.

I have gotten  as far as running make initialize-database.

Now what?  I am not clear if the next step is to take a dump of the running
server and copy it to the new server then run update database?

Do I need to do anything to the database before I use it?

I see  someone else doing this:
 1. make a clone of the existing RT,
 2. upgrade it to 4.0.13
 3. do a mysqldump on the upgraded clone
 4. restore the dump on the new server.

Is it recommended to actually clone the old and upgrade it in place?
Could I simply restore a backup from the old on the new and run
  make upgrade-database

I know I will need to setup users, groups, cron, email and probably some
other things as well.

T
hank you for your help.

Peace,
Lois


--
Lois Bennett, MSEE
Senior System Administrator
Channing Laboratory
Brigham  Women's Hospital
A Teaching Affiliate of
Harvard Medical School and
Harvard School of Public Health


[rt-users] MySQL issue - Windows vs. Linux - Table name case seems to matter

2013-08-13 Thread Cena, Stephen (ext. 300)
I'm looking to move all of my MySQL servers from Windows XP systems to
Linux. I'm doing testing now  so far all is well, except with RT. I
currently am running RT 4.0.17 on Ubuntu 12.04LTS with a MySQL 5.5x
database on Windows XP SP3. I am able to successfully backup  restore
the database on the Windows machine. However, when I restore it to the
new Linux box, I get the following error:
=
root@starbug:/home/admsjc/rt-4.0.17# service apache2 start
 * Starting web server apache2
[Tue Aug 13 18:40:45 2013] [warning]: DBD::mysql::st execute failed:
Table 'rtdb.Users' doesn't exist at
/usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Handle.pm line 589.
(/usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Handle.pm:589)
[Tue Aug 13 18:40:45 2013] [warning]: RT::Handle=HASH(0xb8986ab4)
couldn't execute the query 'SELECT  * FROM Users WHERE Name = ?' at
/usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Handle.pm line 602.
 
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xb8986ab4)',
'SELECT  * FROM Users WHERE Name = ?', 'RT_System') called at
/usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Record.pm line 1234
 
DBIx::SearchBuilder::Record::_LoadFromSQL('RT::CurrentUser=HASH(0xb895ab
10)', 'SELECT  * FROM Users WHERE Name = ?', 'RT_System') called at
/usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Record.pm line 1153
 
DBIx::SearchBuilder::Record::LoadByCols('RT::CurrentUser=HASH(0xb895ab10
)', 'Name', 'RT_System') called at
/usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Record/Cachable.pm line
120
 
DBIx::SearchBuilder::Record::Cachable::LoadByCols('RT::CurrentUser=HASH(
0xb895ab10)', 'Name', 'RT_System') called at
/opt/rt4/sbin/../lib/RT/Record.pm line 375
RT::Record::LoadByCols('RT::CurrentUser=HASH(0xb895ab10)',
'Name', 'RT_System') called at
/usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Record.pm line 1098
 
DBIx::SearchBuilder::Record::LoadByCol('RT::CurrentUser=HASH(0xb895ab10)
', 'Name', 'RT_System') called at /opt/rt4/sbin/../lib/RT/User.pm line
479
RT::User::Load('RT::CurrentUser=HASH(0xb895ab10)', 'RT_System')
called at /opt/rt4/sbin/../lib/RT/Handle.pm line 238
RT::Handle::CheckIntegrity('RT::Handle') called at
/opt/rt4/sbin/rt-server line 99
require /opt/rt4/sbin/rt-server called at (eval 6) line 3
eval 'package Plack::Sandbox::_2fopt_2frt4_2fsbin_2frt_2dserver;
{
my $app = do $_file;
if ( !$app  ( my $error = $@ || $! )) { die $error; }
$app;
}
 
;' called at /usr/share/perl5/Plack/Util.pm line 118
Plack::Util::_load_sandbox('/opt/rt4/sbin/rt-server') called at
/usr/share/perl5/Plack/Util.pm line 155
Plack::Util::load_psgi('/opt/rt4/sbin/rt-server') called at
/usr/share/perl5/Plack/Handler/Apache2.pm line 32
Plack::Handler::Apache2::load_app('Plack::Handler::Apache2',
'/opt/rt4/sbin/rt-server') called at
/usr/share/perl5/Plack/Handler/Apache2.pm line 24
Plack::Handler::Apache2::preload('Plack::Handler::Apache2',
'/opt/rt4/sbin/rt-server') called at
/etc/apache2/sites-enabled/000-default line 20
eval 'package
Apache2::ReadConfig::etc::apache2::sites_enabled::000_default::line_19;
#line 19 /etc/apache2/sites-enabled/000-default
use Plack::Handler::Apache2;
Plack::Handler::Apache2-preload(/opt/rt4/sbin/rt-server);
 
;' called at /opt/rt4/sbin/rt-server line 0
(/usr/local/share/perl/5.14.2/Carp.pm:103)
[Tue Aug 13 18:40:45 2013] [warning]: Use of uninitialized value in
concatenation (.) or string at /opt/rt4/sbin/../lib/RT/Handle.pm line
240. (/opt/rt4/sbin/../lib/RT/Handle.pm:239)
 
RT couldn't connect to the database where tickets are stored.
If this is a new installation of RT, you should visit the URL below
to configure RT and initialize your database.
 
If this is an existing RT installation, this may indicate a database
connectivity problem.
 
The error RT got back when trying to connect to your database was:
 
Couldn't find RT_System user in the DB ''
(more error messages after this)
==
 
I am able to use the MySQL client tools on the Ubuntu Server running RT
to successfully access the RT database. There is something funny I
noticed. If I try to execute: SELECT  * FROM Users WHERE Name = ?'
 
I get: ERROR 1146 (42S02): Table 'rtdb.Users' doesn't exist

If I then go into the RT database  change the user table to User,
RT goes further  has the same error for the ticket tables. Did I do
something wrong with my backup? Or is this a Windows/Linux issue I've
never seen before?
 
 
 
Stephen Cena
QVII
MIS/IT Dept
850 Hudson Ave.
Rochester, NY. 14620
585-544-0450 x300
s...@qvii.com
Thank you for helping us help you help us all.
--For email related issues, please contact postmas...@qvii.com
 
 
 


Re: [rt-users] Migration to RT 4.0.17 from 3.8.9 with new server

2013-08-13 Thread Asif Iqbal
On Tue, Aug 13, 2013 at 1:40 PM, Lois Bennett 
lois.benn...@channing.harvard.edu wrote:

 Hello,

 I have read the documentation on upgrading and  none of the particulars
 exactly fit.

 I have a new VM (Centos6).  I have installed RT 4.0.17 completely vanilla.


 Old mysql:
 mysql  Ver 14.12 Distrib 5.0.81, for unknown-linux-gnu (x86_64) using
 readline 5.2
 Old RT is  3.8.9

 New mysql:
 mysql  Ver 14.14 Distrib 5.1.66, for redhat-linux-gnu (x86_64) using
 readline 5.1

 All has gone well.

 I have gotten  as far as running make initialize-database.

 Now what?  I am not clear if the next step is to take a dump of the
 running server and copy it to the new server then run update database?


This is what I did as next steps

- copy over the RT_SiteConfig.pm from /opt/rt3/etc to /opt/rt4/etc
- comment out the plugins
- mysql drop database rt4;
- mysql create database rt4;
- # mysql  dump.from.rt3.sql
- src/rt-4.0.17# sudo make upgrade-database
- uncomment the plugins from RT_SiteConfig.pm
- .. follow the rest of the steps from README ..


Do I need to do anything to the database before I use it?

 I see  someone else doing this:
  1. make a clone of the existing RT,
  2. upgrade it to 4.0.13
  3. do a mysqldump on the upgraded clone
  4. restore the dump on the new server.

 Is it recommended to actually clone the old and upgrade it in place?
 Could I simply restore a backup from the old on the new and run
   make upgrade-database

 I know I will need to setup users, groups, cron, email and probably some
 other things as well.

 T
 hank you for your help.

 Peace,
 Lois


 --
 Lois Bennett, MSEE
 Senior System Administrator
 Channing Laboratory
 Brigham  Women's Hospital
 A Teaching Affiliate of
 Harvard Medical School and
 Harvard School of Public Health




-- 
Asif Iqbal
PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?


[rt-users] Re-send a previously attached attachment?

2013-08-13 Thread Boli
Hi All,

Apologies if I have missed something obvious.

How can I re-send an attachment that has previously been attached to a
ticket without downloading it and re-attaching it.

For example, if a new requestor or CC is added to a ticket, and I want
to get them up to date quickly by referring to previously
discussed/attached information.

Comments/Suggestions welcomed

Regards,

Boli
-- 
Network Engineer



[rt-users] AUTO: Manuel Lauk is out of the office (Rückkehr am 19.08.2013)

2013-08-13 Thread Manuel Lauk


Ich bin bis 19.08.2013 abwesend.

In urgent cases please contact SupportCenter
Email: suportcenter2.surgi...@meditec.zeiss.com
Phone: +49 7364 20 6363


Hinweis: Dies ist eine automatische Antwort auf Ihre Nachricht  rt-users
Digest, Vol 113, Issue 18 gesendet am 13.08.2013 18:00:02.

Diese ist die einzige Benachrichtigung, die Sie empfangen werden, während
diese Person abwesend ist.

 
This message is intended for a particular addressee only and may contain 
business or company secrets. If you have received this email in error, please 
contact the sender and delete the message immediately. Any use of this email, 
including saving, publishing, copying, replication or forwarding of the message 
or the contents is not permitted.  


Re: [rt-users] Re-send a previously attached attachment?

2013-08-13 Thread Beachey, Kendric
Point them to the web view of the ticket?  The attachment should be there in 
the ticket history, so they can download/view it at their leisure.

(assuming you don't have a security policy that would prevent this)
--
Kendric Beachey


-Original Message-
From: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Boli
Sent: Tuesday, August 13, 2013 3:36 PM
To: RT users
Subject: [rt-users] Re-send a previously attached attachment?

Hi All,

Apologies if I have missed something obvious.

How can I re-send an attachment that has previously been attached to a ticket 
without downloading it and re-attaching it.

For example, if a new requestor or CC is added to a ticket, and I want to get 
them up to date quickly by referring to previously discussed/attached 
information.

Comments/Suggestions welcomed

Regards,

Boli
--
Network Engineer





CONFIDENTIALITY NOTICE: This email and any attachments are for the sole use of 
the intended recipient(s) and contain information that may be confidential 
and/or legally privileged. If you have received this email in error, please 
notify the sender by reply email and delete the message. Any disclosure, 
copying, distribution or use of this communication (including attachments) by 
someone other than the intended recipient is prohibited. Thank you.