[rt-users] Re: rt-users digest, Vol 1 #637 - 2 msgs

kukla at acsu.buffalo.edu kukla at acsu.buffalo.edu
Tue Apr 2 13:44:33 EST 2002


Aye-Aye Sir!  Stopping and re-starting did the trick. Thanks!

Mike Kukla


> Message: 1
> From: Vivek Khera <khera at kcilink.com>
> Date: Tue, 2 Apr 2002 11:44:43 -0500
> To: rt-users at lists.fsck.com
> Subject: Re: [rt-users] version number doesn't change after (presumably)
> upgrading to rt-2-0-13 <4134529564.1017746811 at skiptonpc>
> 
>>>>>> "k" == kukla  <kukla at acsu.buffalo.edu> writes:
> 
> k> Harmless, a problem, or did I not actually upgrade?  Has anyone else
> k> noticed this?
> 
> You did not stop and start your server, so nothing was reloaded.  A
> simple "restart" is not sufficient.
> 
> This is a VFAQ on this list.
> 
> 
> --__--__--
> 
> Message: 2
> To: rt-users at lists.fsck.com
> From: Matt Disney <matthew.disney at fedex.com>
> Subject: Re: [rt-users] version number doesn't change after (presumably)
> upgrading to rt-2-0-13 Date: Tue, 02 Apr 2002 10:45:48 -0600
> 
> Did you stop/start your webserver?
> 
> Since your RT number is in a perl module, and mod_perl (Maybe also
> fcgi) caches perl modules, you need to stop and start your webserver
> after changing any RT related perl module.
> 
> This may or may not be your problem. But it is probably the most
> frequently given answer to RT problems like this.
> 
> Matt
> 
> kukla at acsu.buffalo.edu writes:
>> I've upgraded to rt-2-0-13 from 2-0-11 as recently recommended by Jesse,
>> up to and including running 
>> 
>>> insertdata 2-0-11   
>> 
>> The upgrade was entirely painless. 
>> 
>> However when I reach the login screen of our post-upgrade rt instance,
>> the old version number still appears.
>> 
>> Harmless, a problem, or did I not actually upgrade?  Has anyone else
>> noticed this?
>> 
>> Mike Kukla
>> University at Buffalo
>> 
>> 
>> 
>> 
>> 
>> --On Monday, April 01, 2002, 7:30 PM -0500
>> rt-users-request at lists.fsck.com wrote:
>> 
>>> Send rt-users mailing list submissions to
>>>	 rt-users at lists.fsck.com
>>> 
>>> To subscribe or unsubscribe via the World Wide Web, visit
>>>	 http://lists.fsck.com/mailman/listinfo/rt-users
>>> or, via email, send a message with subject or body 'help' to
>>>	 rt-users-request at lists.fsck.com
>>> 
>>> You can reach the person managing the list at
>>>	 rt-users-admin at lists.fsck.com
>>> 
>>> When replying, please edit your Subject line so it is more specific
>>> than "Re: Contents of rt-users digest..."
>>> 
>>> 
>>> Today's Topics:
>>> 
>>>   1. Dates in Stats offset (Alexander, John)
>>>   2. Re: Dates in Stats offset (David C. Troy)
>>>   3. Re: requestor parsing errors (Darrin Walton)
>>>   4. RE: Connect Failed Access denied for user (Boyko Dimitrov)
>>>   5. RE: Dates in Stats offset (Alexander, John)
>>>   6. operation order and changing queues (Christian Gilmore)
>>>   7. RE: Dates in Stats offset (David C. Troy)
>>>   8. Re: requestor parsing errors (Fred Purdue)
>>>   9. RE: Connect Failed Access denied for user (Boyko Dimitrov)
>>>   10. Upgrade to 2.0.13 .. step by step? (RT2 Troubles)
>>>   11. Re: Upgrade to 2-0-13 (Andrew Yager)
>>> 
>>> -- __--__-- 
>>> 
>>> Message: 1
>>> From: "Alexander, John" <alexandj at fortrex.com>
>>> To: "'rt-users at lists.fsck.com'" <rt-users at lists.fsck.com>
>>> Date: Mon, 1 Apr 2002 15:31:49 -0500
>>> Subject: [rt-users] Dates in Stats offset
>>> 
>>> I've noticed that the dates displayed in the Stats pages is offset by
>>> one day.  It is showing tickets for monday as being on sunday.  Anyone
>>> seen this and know how to fix it?
>>> 
>>> -----------------------------------------------------------------------
>>> -- --- ------------
>>> John Alexander                          john.alexander at fortrex.com
>>> Network Security Operations       phone: 301-977-6966
>>> Fortrex Technologies, Inc            fax:     301-947-3539
>>> Gaithersburg, MD
>>> http://www.fortrex.com
>>> 
>>> Because Your Information is Your Business
>>> 
>>> 
>>> 
>>> 
>>> -- __--__-- 
>>> 
>>> Message: 2
>>> Date: Mon, 1 Apr 2002 15:34:57 -0500 (EST)
>>> From: "David C. Troy" <dave at toad.net>
>>> To: "Alexander, John" <alexandj at fortrex.com>
>>> Cc: "'rt-users at lists.fsck.com'" <rt-users at lists.fsck.com>
>>> Subject: Re: [rt-users] Dates in Stats offset
>>> 
>>> 
>>> Is it perhaps a difference between GMT and EST?  I think RT stores dates
>>> in GMT and then translates to the local timezone on the fly.
>>> 
>>> Dave
>>> 
>>> =====================================================================
>>> David C. Troy   [dave at toad.net]                   410-544-6193 Sales
>>> ToadNet - Want to go fast?                        410-544-1329 FAX
>>> 570 Ritchie Highway, Severna Park, MD 21146-2925  www.toad.net
>>> 
>>> On Mon, 1 Apr 2002, Alexander, John wrote:
>>> 
>>>> I've noticed that the dates displayed in the Stats pages is offset by
>>>> one day.  It is showing tickets for monday as being on sunday.  Anyone
>>>> seen this and know how to fix it?
>>>> 
>>>> ----------------------------------------------------------------------
>>>> -- ---- ------------
>>>> John Alexander                          john.alexander at fortrex.com
>>>> Network Security Operations       phone: 301-977-6966
>>>> Fortrex Technologies, Inc            fax:     301-947-3539
>>>> Gaithersburg, MD
>>>> http://www.fortrex.com
>>>> 
>>>> Because Your Information is Your Business
>>>> 
>>>> 
>>>> 
>>>> _______________________________________________
>>>> rt-users mailing list
>>>> rt-users at lists.fsck.com
>>>> http://lists.fsck.com/mailman/listinfo/rt-users
>>>> 
>>> 
>>> 
>>> 
>>> -- __--__-- 
>>> 
>>> Message: 3
>>> Date: Mon, 1 Apr 2002 16:13:16 -0500
>>> From: Darrin Walton <darrinw at nixc.net>
>>> To: Fred Purdue <Fred.Purdue at Pobox.com>
>>> Cc: rt-users at lists.fsck.com
>>> Subject: Re: [rt-users] requestor parsing errors
>>> Fred Purdue <Fred.Purdue at Pobox.com>, rt-users at lists.fsck.com
>>> Organization: NIXC, Inc.
>>> 
>>>   |+ Mandrake Linux 2,4,8-26mdk
>>>   |+ Apache-AdvancedExtranetServer/1.3.20 (Mandrake Linux/3mdk)
>>>   |+ Perl 5.6.1
>>>   |+ mod_fastcgi-2.2.12
>>>   |+ Postfix (postfix-20010228-15mdk)
>>>   |+ All dependencies checked out fine with 'make testdeps'
>>>   |+ All dependencies are from CPAN less than 10 days ago.
>>> 
>>> What version of RT?
>>> 
>>> 
>>> 
>>> -- __--__-- 
>>> 
>>> Message: 4
>>> From: "Boyko Dimitrov" <bdimitrov at advantageds.com>
>>> To: <rt-users at lists.fsck.com>
>>> Subject: RE: [rt-users] Connect Failed Access denied for user
>>> Date: Mon, 1 Apr 2002 13:44:48 -0800
>>> charset="iso-8859-1"
>>> 
>>> This is new install and I used all default values. The only
>>> modification I had to do was to create rt_user in MySQL and give it
>>> privileges to RT2 (make install would fail until I did so). Would
>>> replacing the current config.pm (in /usr/local/rt2/etc) with the one
>>> unpacked in
>>> /tmp/rt-2-0-12/etc fix this? Do I need to try reinstalling until no
>>> errors are reported, or is my setup complete and this is just post
>>> install issue?
>>> 
>>> Thanks again.
>>> 
>>> -----Original Message-----
>>> From: rt-users-admin at lists.fsck.com
>>> [mailto:rt-users-admin at lists.fsck.com]On Behalf Of Ferguson, Kevin
>>> Sent: Monday, April 01, 2002 12:08 PM
>>> To: 'Boyko Dimitrov'
>>> Cc: rt-users at lists.fsck.com
>>> Subject: RE: [rt-users] Connect Failed Access denied for user
>>> 
>>> 
>>> 
>>> rt_user is the default username that RT uses for mysql.  It looks
>>> like you modified either this or its password in your original
>>> RT config.pm file.  The upgrade overwrites the config.pm file.
>>> Reinstate your site customizations in the new config.pm.
>>> 
>>> 
>>> 
>>>> -----Original Message-----
>>>> From: Boyko Dimitrov [mailto:bdimitrov at advantageds.com]
>>>> Sent: Monday, April 01, 2002 1:27 PM
>>>> To: rt-users at lists.fsck.com
>>>> Subject: [rt-users] Connect Failed Access denied for user
>>>> 
>>>> 
>>>> I got the following "error" at the end of my RT installation. Should I
>>>> assume that RT is installed correctly and the only problem is user
>>>> name/password with mysql? Is there something I should edit?
>>>> 
>>>> TIA.
>>>> Boyko
>>>> 
>>>> Congratulations. RT has been upgraded. You should now check-over
>>>> /usr/local/rt2/etc/config.pm for any necessary site customization.
>>>> Additionally,
>>>> you should update RT's system database objects by running
>>>>            /usr/local/rt2/etc/insertdata <version>
>>>> where <version> is the version of RT you're upgrading from.
>>>> /usr/bin/perl /usr/local/rt2/etc/insertdata
>>>> DBI->connect(dbname=rt2;host=localhost) failed: Access denied
>>>> for user:
>>>> 'rt_user at localhost' (Using password: YES) at
>>>> /usr/local/lib/perl5/site_perl/5.005/DBIx/SearchBuilder/Handle
>>>> .pm line 121
>>>> Connect Failed Access denied for user: 'rt_user at localhost'
>>>> (Using password:
>>>> YES)
>>>>  at /usr/local/rt2/lib/RT/Handle.pm line 43
>>>> *** Error code 255
>>>> 
>>>> Stop in /tmp/rt-2-0-12.
>>>> 
>>>> 
>>>> _______________________________________________
>>>> rt-users mailing list
>>>> rt-users at lists.fsck.com
>>>> http://lists.fsck.com/mailman/listinfo/rt-users
>>>> 
>>> 
>>> _______________________________________________
>>> rt-users mailing list
>>> rt-users at lists.fsck.com
>>> http://lists.fsck.com/mailman/listinfo/rt-users
>>> 
>>> 
>>> 
>>> 
>>> -- __--__-- 
>>> 
>>> Message: 5
>>> From: "Alexander, John" <alexandj at fortrex.com>
>>> To: "'rt-users at lists.fsck.com'" <rt-users at lists.fsck.com>
>>> Date: Mon, 1 Apr 2002 16:48:14 -0500
>>> Subject: RE: [rt-users] Dates in Stats offset
>>> 
>>> I checked the date/times in the tickets in question and GMT vs Local
>>> time does not account for the disparity.  In the stats pages, all of
>>> mondays tickets are being counted for sunday.
>>> 
>>> John Alexander
>>> 
>>> 
>>> -----Original Message-----
>>> From: David C. Troy [mailto:dave at toad.net]
>>> Sent: Monday, April 01, 2002 3:35 PM
>>> To: Alexander, John
>>> Cc: 'rt-users at lists.fsck.com'
>>> Subject: Re: [rt-users] Dates in Stats offset
>>> 
>>> 
>>> 
>>> Is it perhaps a difference between GMT and EST?  I think RT stores dates
>>> in GMT and then translates to the local timezone on the fly.
>>> 
>>> Dave
>>> 
>>> =====================================================================
>>> David C. Troy   [dave at toad.net]                   410-544-6193 Sales
>>> ToadNet - Want to go fast?                        410-544-1329 FAX
>>> 570 Ritchie Highway, Severna Park, MD 21146-2925  www.toad.net
>>> 
>>> On Mon, 1 Apr 2002, Alexander, John wrote:
>>> 
>>>> I've noticed that the dates displayed in the Stats pages is offset by
>>>> one day.  It is showing tickets for monday as being on sunday.  Anyone
>>>> seen
>>> this
>>>> and know how to fix it?
>>>> 
>>>> 
>>> -----------------------------------------------------------------------
>>> -- ---
>>>> ------------
>>>> John Alexander                          john.alexander at fortrex.com
>>>> Network Security Operations       phone: 301-977-6966
>>>> Fortrex Technologies, Inc            fax:     301-947-3539
>>>> Gaithersburg, MD
>>>> http://www.fortrex.com
>>>> 
>>>> Because Your Information is Your Business
>>>> 
>>>> 
>>>> 
>>>> _______________________________________________
>>>> rt-users mailing list
>>>> rt-users at lists.fsck.com
>>>> http://lists.fsck.com/mailman/listinfo/rt-users
>>>> 
>>> 
>>> 
>>> -- __--__-- 
>>> 
>>> Message: 6
>>> From: "Christian Gilmore" <cgilmore at tivoli.com>
>>> To: "RT Users Mailing List (E-mail)" <rt-users at lists.fsck.com>
>>> Date: Mon, 1 Apr 2002 15:45:05 -0600
>>> charset="iso-8859-1"
>>> Subject: [rt-users] operation order and changing queues
>>> 
>>> I have a little problem and hope there's a simple solution. I have
>>> multiple queues and potentially mutually exclusive privileged members of
>>> each queue. I need for people to be able to transfer tickets from one
>>> queue to the next via the web UI. This transfer occurs, but I see two
>>> sets of errors:
>>> 
>>> 1) While the queue change does take effect, the web UI states: "Queue:
>>> 0" instead of what transaction actually occurred.
>>> 
>>> 2) The system then complains that the user does not have sufficient
>>> privilege to change the remaining fields on the Basics page. Is there a
>>> way to enforce operational order so that queue change is the last
>>> possible transaction instead of the first to be reviewed?
>>> 
>>> Thanks,
>>> Christian
>>> 
>>> -----------------
>>> Christian Gilmore
>>> Technology Leader
>>> GeT WW Global Applications Development
>>> IBM Software Group
>>> 
>>> 
>>> 
>>> -- __--__-- 
>>> 
>>> Message: 7
>>> Date: Mon, 1 Apr 2002 16:56:11 -0500 (EST)
>>> From: "David C. Troy" <dave at toad.net>
>>> To: "Alexander, John" <alexandj at fortrex.com>
>>> Cc: "'rt-users at lists.fsck.com'" <rt-users at lists.fsck.com>
>>> Subject: RE: [rt-users] Dates in Stats offset
>>> 
>>> 
>>> Might be a Sunday=0 vs. Sunday=1 problem then...
>>> 
>>> =====================================================================
>>> David C. Troy   [dave at toad.net]                   410-544-6193 Sales
>>> ToadNet - Want to go fast?                        410-544-1329 FAX
>>> 570 Ritchie Highway, Severna Park, MD 21146-2925  www.toad.net
>>> 
>>> On Mon, 1 Apr 2002, Alexander, John wrote:
>>> 
>>>> I checked the date/times in the tickets in question and GMT vs Local
>>>> time does not account for the disparity.  In the stats pages, all of
>>>> mondays tickets are being counted for sunday.
>>>> 
>>>> John Alexander
>>>> 
>>>> 
>>>> -----Original Message-----
>>>> From: David C. Troy [mailto:dave at toad.net]
>>>> Sent: Monday, April 01, 2002 3:35 PM
>>>> To: Alexander, John
>>>> Cc: 'rt-users at lists.fsck.com'
>>>> Subject: Re: [rt-users] Dates in Stats offset
>>>> 
>>>> 
>>>> 
>>>> Is it perhaps a difference between GMT and EST?  I think RT stores
>>>> dates in GMT and then translates to the local timezone on the fly.
>>>> 
>>>> Dave
>>>> 
>>>> =====================================================================
>>>> David C. Troy   [dave at toad.net]                   410-544-6193 Sales
>>>> ToadNet - Want to go fast?                        410-544-1329 FAX
>>>> 570 Ritchie Highway, Severna Park, MD 21146-2925  www.toad.net
>>>> 
>>>> On Mon, 1 Apr 2002, Alexander, John wrote:
>>>> 
>>>> > I've noticed that the dates displayed in the Stats pages is offset by
>>>> > one day.  It is showing tickets for monday as being on sunday.
>>>> > Anyone seen
>>>> this
>>>> > and know how to fix it?
>>>> > 
>>>> > 
>>>> ----------------------------------------------------------------------
>>>> -- ----
>>>> > ------------
>>>> > John Alexander                          john.alexander at fortrex.com
>>>> > Network Security Operations       phone: 301-977-6966
>>>> > Fortrex Technologies, Inc            fax:     301-947-3539
>>>> > Gaithersburg, MD
>>>> > http://www.fortrex.com
>>>> > 
>>>> > Because Your Information is Your Business
>>>> > 
>>>> > 
>>>> > 
>>>> > _______________________________________________
>>>> > rt-users mailing list
>>>> > rt-users at lists.fsck.com
>>>> > http://lists.fsck.com/mailman/listinfo/rt-users
>>>> > 
>>>> 
>>>> _______________________________________________
>>>> rt-users mailing list
>>>> rt-users at lists.fsck.com
>>>> http://lists.fsck.com/mailman/listinfo/rt-users
>>>> 
>>> 
>>> 
>>> 
>>> -- __--__-- 
>>> 
>>> Message: 8
>>> Subject: Re: [rt-users] requestor parsing errors
>>> From: Fred Purdue <Fred.Purdue at Pobox.com>
>>> To: Darrin Walton <darrinw at nixc.net>
>>> Cc: rt-users at lists.fsck.com
>>> <20020401161316.J99604 at nixc.net>
>>> Date: 01 Apr 2002 17:37:48 -0500
>>> 
>>> 
>>> --=-R0t2xSqxcpo0RrSjlClN
>>> Content-Type: text/plain
>>> Content-Transfer-Encoding: 7bit
>>> 
>>> Darrin,
>>> 
>>> The version is 2.0.12
>>> 
>>> I found the cause of the problem (but not really the solution)
>>> 
>>> "        my $email = ~
>>> s/\@(.*).newopportunitiesinc.org/\@newopportunitiesinc.org/;  "
>>> 
>>> The Canonical address translation was nuking anything that went through
>>> it.  Once I replaced it with shift; and restarted httpd everything
>>> worked fine.  My string looks exactly like the foo.com example that
>>> comes in config.pm.  Any ideas what is wrong with it?  Could the problem
>>> be that some of the mail is coming from/to another domain? 
>>> (corp.newoppinc.org)?
>>> 
>>> 
>>> -- 
>>> ------=====================================------
>>> Fred Purdue              General Technology Group 
>>> E: Fred at GTGCorp.com               www.gtgcorp.com
>>> P: (203) 235-7175          164 Scott St - Suite 1
>>> C: (203) 605-6853               Meriden, CT 06450
>>> ------=====================================------
>>> 
>>>       |+ Mandrake Linux 2,4,8-26mdk
>>>       |+ Apache-AdvancedExtranetServer/1.3.20 (Mandrake Linux/3mdk)
>>>       |+ Perl 5.6.1
>>>       |+ mod_fastcgi-2.2.12
>>>       |+ Postfix (postfix-20010228-15mdk)
>>>       |+ All dependencies checked out fine with 'make testdeps'
>>>       |+ All dependencies are from CPAN less than 10 days ago.
>>>     
>>>     What version of RT?
>>>     
>>>     
>>> 
>>> -- 
>>> ------=====================================------
>>> Fred Purdue              General Technology Group 
>>> E: Fred at GTGCorp.com               www.gtgcorp.com
>>> P: (203) 235-7175          164 Scott St - Suite 1
>>> C: (203) 605-6853               Meriden, CT 06450
>>> ------=====================================------
>>> 
>>> --=-R0t2xSqxcpo0RrSjlClN
>>> Content-Type: text/html; charset=utf-8
>>> 
>>> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
>>> <HTML>
>>> <HEAD>
>>>   <META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
>>>   <META NAME="GENERATOR" CONTENT="GtkHTML/1.0.2.99">
>>> </HEAD>
>>> <BODY>
>>> Darrin,
>>> <BR>
>>> 
>>> <BR>
>>> The version is 2.0.12
>>> <BR>
>>> 
>>> <BR>
>>> I found the cause of the problem (but not really the solution)
>>> <BR>
>>> 
>>> <BR>
>>> "        my $email = ~
>>> s/\@(.*).newopportunitiesinc.org/\@newopportunitiesinc.org/; 
>>> " <BR>
>>> 
>>> <BR>
>>> The Canonical address translation was nuking anything that went through
>>> it.  Once I replaced it with shift; and restarted httpd everything
>>> worked fine.  My string looks exactly like the foo.com example that
>>> comes in config.pm.  Any ideas what is wrong with it?  Could
>>> the problem be that some of the mail is coming from/to another
>>> domain?  (corp.newoppinc.org)? <BR>
>>> 
>>> <BR>
>>> 
>>> <TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
>>> <TR>
>>> <TD>
>>> <PRE>-- 
>>> ------=====================================------
>>> Fred Purdue              General Technology Group 
>>> E: Fred at GTGCorp.com               www.gtgcorp.com
>>> P: (203) 235-7175          164 Scott St - Suite 1
>>> C: (203) 605-6853               Meriden, CT 06450
>>> ------=====================================------</PRE>
>>> </TD>
>>> </TR>
>>> </TABLE>
>>> 
>>>     <BLOCKQUOTE>
>>> <PRE><FONT SIZE="3"><I>  |+ Mandrake Linux 2,4,8-26mdk</FONT></I>
>>> <FONT SIZE="3"><I>  |+ Apache-AdvancedExtranetServer/1.3.20 (Mandrake
>>> Linux/3mdk)</FONT></I> <FONT SIZE="3"><I>  |+ Perl 5.6.1</FONT></I>
>>> <FONT SIZE="3"><I>  |+ mod_fastcgi-2.2.12</FONT></I>
>>> <FONT SIZE="3"><I>  |+ Postfix (postfix-20010228-15mdk)</FONT></I>
>>> <FONT SIZE="3"><I>  |+ All dependencies checked out fine with 'make
>>> testdeps'</FONT></I> <FONT SIZE="3"><I>  |+ All dependencies are from
>>> CPAN less than 10 days ago.</FONT></I> <FONT SIZE="3"><I></FONT></I>
>>> <FONT SIZE="3"><I>What version of RT?</FONT></I>
>>> <FONT SIZE="3"><I></FONT></I>
>>> <FONT SIZE="3"><I></FONT></I></PRE>
>>>     </BLOCKQUOTE>
>>> <TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
>>> <TR>
>>> <TD>
>>> <PRE>-- 
>>> ------=====================================------
>>> Fred Purdue              General Technology Group 
>>> E: Fred at GTGCorp.com               www.gtgcorp.com
>>> P: (203) 235-7175          164 Scott St - Suite 1
>>> C: (203) 605-6853               Meriden, CT 06450
>>> ------=====================================------</PRE>
>>> </TD>
>>> </TR>
>>> </TABLE>
>>> 
>>> </BODY>
>>> </HTML>
>>> 
>>> --=-R0t2xSqxcpo0RrSjlClN--
>>> 
>>> 
>>> -- __--__-- 
>>> 
>>> Message: 9
>>> From: "Boyko Dimitrov" <bdimitrov at advantageds.com>
>>> To: <rt-users at lists.fsck.com>
>>> Subject: RE: [rt-users] Connect Failed Access denied for user
>>> Date: Mon, 1 Apr 2002 14:45:21 -0800
>>> charset="iso-8859-1"
>>> 
>>> Well looking in config.pm did solve my problem. I change the password in
>>> MySQL to the one in config.pm and the installation completed with the
>>> only complaint for /var/log/rt2 not existing. I created it and ran "make
>>> install" again no errors.
>>> 
>>> This raises a question however. Should RT create all user/groups it
>>> needs during the install process. I had to create rt_user manually and
>>> edit it's privileges as well, including the directory above that
>>> finally solved my problem. Also the initial password I entered for
>>> rt_user should have been saved at the very beginning.
>>> 
>>> -----Original Message-----
>>> From: rt-users-admin at lists.fsck.com
>>> [mailto:rt-users-admin at lists.fsck.com]On Behalf Of Boyko Dimitrov
>>> Sent: Monday, April 01, 2002 1:45 PM
>>> To: rt-users at lists.fsck.com
>>> Subject: RE: [rt-users] Connect Failed Access denied for user
>>> 
>>> 
>>> This is new install and I used all default values. The only
>>> modification I had to do was to create rt_user in MySQL and give it
>>> privileges to RT2 (make install would fail until I did so). Would
>>> replacing the current config.pm (in /usr/local/rt2/etc) with the one
>>> unpacked in
>>> /tmp/rt-2-0-12/etc fix this? Do I need to try reinstalling until no
>>> errors are reported, or is my setup complete and this is just post
>>> install issue?
>>> 
>>> Thanks again.
>>> 
>>> -----Original Message-----
>>> From: rt-users-admin at lists.fsck.com
>>> [mailto:rt-users-admin at lists.fsck.com]On Behalf Of Ferguson, Kevin
>>> Sent: Monday, April 01, 2002 12:08 PM
>>> To: 'Boyko Dimitrov'
>>> Cc: rt-users at lists.fsck.com
>>> Subject: RE: [rt-users] Connect Failed Access denied for user
>>> 
>>> 
>>> 
>>> rt_user is the default username that RT uses for mysql.  It looks
>>> like you modified either this or its password in your original
>>> RT config.pm file.  The upgrade overwrites the config.pm file.
>>> Reinstate your site customizations in the new config.pm.
>>> 
>>> 
>>> 
>>>> -----Original Message-----
>>>> From: Boyko Dimitrov [mailto:bdimitrov at advantageds.com]
>>>> Sent: Monday, April 01, 2002 1:27 PM
>>>> To: rt-users at lists.fsck.com
>>>> Subject: [rt-users] Connect Failed Access denied for user
>>>> 
>>>> 
>>>> I got the following "error" at the end of my RT installation. Should I
>>>> assume that RT is installed correctly and the only problem is user
>>>> name/password with mysql? Is there something I should edit?
>>>> 
>>>> TIA.
>>>> Boyko
>>>> 
>>>> Congratulations. RT has been upgraded. You should now check-over
>>>> /usr/local/rt2/etc/config.pm for any necessary site customization.
>>>> Additionally,
>>>> you should update RT's system database objects by running
>>>>            /usr/local/rt2/etc/insertdata <version>
>>>> where <version> is the version of RT you're upgrading from.
>>>> /usr/bin/perl /usr/local/rt2/etc/insertdata
>>>> DBI->connect(dbname=rt2;host=localhost) failed: Access denied
>>>> for user:
>>>> 'rt_user at localhost' (Using password: YES) at
>>>> /usr/local/lib/perl5/site_perl/5.005/DBIx/SearchBuilder/Handle
>>>> .pm line 121
>>>> Connect Failed Access denied for user: 'rt_user at localhost'
>>>> (Using password:
>>>> YES)
>>>>  at /usr/local/rt2/lib/RT/Handle.pm line 43
>>>> *** Error code 255
>>>> 
>>>> Stop in /tmp/rt-2-0-12.
>>>> 
>>>> 
>>>> _______________________________________________
>>>> rt-users mailing list
>>>> rt-users at lists.fsck.com
>>>> http://lists.fsck.com/mailman/listinfo/rt-users
>>>> 
>>> 
>>> _______________________________________________
>>> rt-users mailing list
>>> rt-users at lists.fsck.com
>>> http://lists.fsck.com/mailman/listinfo/rt-users
>>> 
>>> 
>>> 
>>> _______________________________________________
>>> rt-users mailing list
>>> rt-users at lists.fsck.com
>>> http://lists.fsck.com/mailman/listinfo/rt-users
>>> 
>>> 
>>> 
>>> 
>>> -- __--__-- 
>>> 
>>> Message: 10
>>> charset="iso-8859-15"
>>> From: RT2 Troubles <rt2trouble at morben.ca>
>>> To: rt-users at lists.fsck.com
>>> Date: Mon, 1 Apr 2002 16:12:27 -0800
>>> Subject: [rt-users] Upgrade to 2.0.13 .. step by step?
>>> 
>>> So here's what I can gather for instructions on upgrading 2.0.11 to
>>> 2.0.13  and I'd like some feedback before I go ahead and try it:
>>> 
>>> Download the rt.tar.gz
>>> tar xzvf rt.tar.gz
>>> cd rt-2-0-13
>>> vi Makefile
>>>   - change all options that are different on your install
>>> cp /path/to/rt2/etc/config.pm /etc/config.pm.backup
>>> make upgrade
>>> vi /path/to/rt2/etc/config.pm
>>>   - reconfig based on the old backed up config
>>> /etc/rc.d/init.d/httpd restart
>>> 
>>> Done?
>>> 
>>> No stopping of services, no recompliing of Perl, no dependency hunting?
>>> Could it be that easy?
>>> 
>>> -- RT2 Troubles 
>>> 
>>> 
>>> -- __--__-- 
>>> 
>>> Message: 11
>>> Date: Tue, 02 Apr 2002 10:22:54 +1000
>>> Subject: Re: [rt-users] Upgrade to 2-0-13
>>> From: Andrew Yager <andrew at rwts.com.au>
>>> To: rt-users <rt-users at lists.fsck.com>
>>> 
>>> Hi,
>>> 
>>> Just thought I=B9d let people know that somone had enabled
>>> Apache::Status somewhere in my httpd.conf file... And this caused
>>> problems.
>>> 
>>> But... We do have another interesting problem...
>>> 
>>> When we start apache, we get
>>> 
>>> mod_perl: </VirtualHost>
>>> mod_perl: Missing </VirtualHost> directive at end-of-file
>>> 
>>> ... Everything appears to still work - but if anyone knows why we get
>>> this error (it seems to dissapear if you comment out PerlModule
>>> Apache::DBI through to </Location>)
>>> 
>>> Relevant section of httpd.conf file below...
>>> 
>>> <VirtualHost XXX.XXX.XXX.19>
>>>         ServerName secure.somewhere.com.au
>>>         ServerAdmin admin
>>>         DocumentRoot /home/sites/site16/web
>>>         ServerAlias secure.ultraserve.com.au
>>>         Alias /queue/ /usr/local/rt2/WebRT/html/
>>>         PerlModule Apache::DBI
>>>         PerlFreshRestart On
>>>         PerlRequire /usr/local/rt2/bin/webmux.pl
>>>         <Location /queue>
>>>                 SetHandler perl-script
>>>                 PerlHandler RT::Mason
>>>         </Location>
>>>         RewriteEngine on
>>>         RewriteCond %{HTTP_HOST}       !^XXX.XXX.XXX.19(:80)?$
>>>         RewriteCond %{HTTP_HOST}       !^secure.somewhere.com.au(:80)?$
>>>         RewriteRule ^/(.*)
>>>         https://secure.somewhere.com.au/$1[L,R] RewriteOptions inherit
>>>         AliasMatch ^/~([^/]+)(/(.*))? /home/sites/site16/users/$1/web/$3
>>>         AddHandler cgi-wrapper .cgi
>>>         AddHandler cgi-wrapper .pl
>>>         AddType application/x-httpd-php .php4
>>>         AddType application/x-httpd-php .php
>>> </VirtualHost>
>>> 
>>> Thanks,
>>> Andrew
>>> 
>>> 
>>> On 1/4/02 9:46 PM, "Andrew Yager" <andrew at rwts.com.au> wrote:
>>> 
>>>> Hi,
>>>> =20
>>>> Just upgraded from 2-0-5_03 to 2-0-13 (don=B9t you love version
>>>> numbers)! =20
>>>> When I restart Apache I get:
>>>> =20
>>>> Subroutine menu_item redefined at
>>>> /usr/lib/perl5/site_perl/5.005/i386-linux/Apache/Status.pm line 46.
>>>> Subroutine handler redefined at
>>>> /usr/lib/perl5/site_perl/5.005/i386-linux/Apache/Status.pm line 54.
>>>> Subroutine header redefined at
>>>> /usr/lib/perl5/site_perl/5.005/i386-linux/Apache/Status.pm line 83.
>>>> Subroutine symdump redefined at
>>>> /usr/lib/perl5/site_perl/5.005/i386-linux/Apache/Status.pm line 99.
>>>> Subroutine status_symdump redefined at
>>>> /usr/lib/perl5/site_perl/5.005/i386-linux/Apache/Status.pm line 112.
>>>> Subroutine status_section_config redefined at
>>>> /usr/lib/perl5/site_perl/5.005/i386-linux/Apache/Status.pm line 117.
>>>> Subroutine status_hooks redefined at
>>>> /usr/lib/perl5/site_perl/5.005/i386-linux/Apache/Status.pm line 123.
>>>> Subroutine status_inc redefined at
>>>> /usr/lib/perl5/site_perl/5.005/i386-linux/Apache/Status.pm line 138.
>>>> Subroutine status_script redefined at
>>>> /usr/lib/perl5/site_perl/5.005/i386-linux/Apache/Status.pm line 169.
>>>> Subroutine status_rgysubs redefined at
>>>> /usr/lib/perl5/site_perl/5.005/i386-linux/Apache/Status.pm line 183.
>>>> Subroutine status_env redefined at
>>>> /usr/lib/perl5/site_perl/5.005/i386-linux/Apache/Status.pm line 197.
>>>> Subroutine status_sig redefined at
>>>> /usr/lib/perl5/site_perl/5.005/i386-linux/Apache/Status.pm line 203.
>>>> Subroutine status_myconfig redefined at
>>>> /usr/lib/perl5/site_perl/5.005/i386-linux/Apache/Status.pm line 217.
>>>> Subroutine status_inh_tree redefined at
>>>> /usr/lib/perl5/site_perl/5.005/i386-linux/Apache/Status.pm line 222.
>>>> Subroutine status_isa_tree redefined at
>>>> /usr/lib/perl5/site_perl/5.005/i386-linux/Apache/Status.pm line 223.
>>>> Subroutine status_data_dump redefined at
>>>> /usr/lib/perl5/site_perl/5.005/i386-linux/Apache/Status.pm line 225.
>>>> Subroutine cv_file redefined at
>>>> /usr/lib/perl5/site_perl/5.005/i386-linux/Apache/Status.pm line 241.
>>>> Subroutine status_cv_dump redefined at
>>>> /usr/lib/perl5/site_perl/5.005/i386-linux/Apache/Status.pm line 246.
>>>> Subroutine status_config redefined at
>>>> /usr/lib/perl5/site_perl/5.005/i386-linux/Apache/Status.pm line 281.
>>>> Subroutine b_graph_link redefined at
>>>> /usr/lib/perl5/site_perl/5.005/i386-linux/Apache/Status.pm line 287.
>>>> Subroutine b_lexinfo_link redefined at
>>>> /usr/lib/perl5/site_perl/5.005/i386-linux/Apache/Status.pm line 296.
>>>> Subroutine noh_b_lexinfo redefined at
>>>> /usr/lib/perl5/site_perl/5.005/i386-linux/Apache/Status.pm line 304.
>>>> Subroutine b_terse_link redefined at
>>>> /usr/lib/perl5/site_perl/5.005/i386-linux/Apache/Status.pm line 317.
>>>> Subroutine noh_b_terse redefined at
>>>> /usr/lib/perl5/site_perl/5.005/i386-linux/Apache/Status.pm line 331.
>>>> Subroutine b_terse_size_link redefined at
>>>> /usr/lib/perl5/site_perl/5.005/i386-linux/Apache/Status.pm line 340.
>>>> Subroutine noh_b_terse_size redefined at
>>>> /usr/lib/perl5/site_perl/5.005/i386-linux/Apache/Status.pm line 354.
>>>> Subroutine b_package_size_link redefined at
>>>> /usr/lib/perl5/site_perl/5.005/i386-linux/Apache/Status.pm line 365.
>>>> Subroutine noh_b_package_size redefined at
>>>> /usr/lib/perl5/site_perl/5.005/i386-linux/Apache/Status.pm line 373.
>>>> Subroutine b_deparse_link redefined at
>>>> /usr/lib/perl5/site_perl/5.005/i386-linux/Apache/Status.pm line 410.
>>>> Subroutine noh_b_deparse redefined at
>>>> /usr/lib/perl5/site_perl/5.005/i386-linux/Apache/Status.pm line 419.
>>>> Subroutine b_fathom_link redefined at
>>>> /usr/lib/perl5/site_perl/5.005/i386-linux/Apache/Status.pm line 430.
>>>> Subroutine noh_b_fathom redefined at
>>>> /usr/lib/perl5/site_perl/5.005/i386-linux/Apache/Status.pm line 439.
>>>> Subroutine peek_link redefined at
>>>> /usr/lib/perl5/site_perl/5.005/i386-linux/Apache/Status.pm line 449.
>>>> Subroutine noh_peek redefined at
>>>> /usr/lib/perl5/site_perl/5.005/i386-linux/Apache/Status.pm line 457.
>>>> Subroutine xref_link redefined at
>>>> /usr/lib/perl5/site_perl/5.005/i386-linux/Apache/Status.pm line 467.
>>>> Subroutine noh_xref redefined at
>>>> /usr/lib/perl5/site_perl/5.005/i386-linux/Apache/Status.pm line 474.
>>>> Subroutine noh_b_graph redefined at
>>>> /usr/lib/perl5/site_perl/5.005/i386-linux/Apache/Status.pm line 490.
>>>> Subroutine B::Graph::TIEHANDLE redefined at
>>>> /usr/lib/perl5/site_perl/5.005/i386-linux/Apache/Status.pm line 532.
>>>> Subroutine B::Graph::PRINT redefined at
>>>> /usr/lib/perl5/site_perl/5.005/i386-linux/Apache/Status.pm line 555.
>>>> Subroutine as_HTML redefined at
>>>> /usr/lib/perl5/site_perl/5.005/i386-linux/Apache/Status.pm line 562.
>>>> =20
>>>> --
>>>> :-)
>>>> =20
>>>> RT doesn=B9t quite work =AD it logged me in ,but won=B9t log me out,
>>>> and won=B9t =
>>> let
>>>> me view any tickets or anything.
>>>> =20
>>>> If anyone knows what I might have done wrong =AD I=B9d love to know...
>>>> It wor=
>>> ked
>>>> fine as 2-0-5...
>>>> =20
>>>> Any assistance appreciated.
>>>> =20
>>>> Thanks,
>>>> Andrew
>>>> =20
>>>> ___________________
>>>> Andrew Yager
>>>> Real World Technology Solutions
>>>> Real People, Real SolUtions (tm)
>>>> ph: (02) 9945 2567 fax: (02) 9945 2566
>>>> mob: 0405 15 2568
>>>> http://www.rwts.com.au/
>>>> _________________________
>>>> =20
>>> 
>>> 
>>> ___________________
>>> Andrew Yager
>>> Real World Technology Solutions
>>> Real People, Real SolUtions (tm)
>>> ph: (02) 9945 2567 fax: (02) 9945 2566
>>> mob: 0405 15 2568
>>> http://www.rwts.com.au/
>>> _________________________
>>> 
>>> 
>>> 
>>> 
>>> -- __--__-- 
>>> 
>>> _______________________________________________
>>> rt-users mailing list
>>> rt-users at lists.fsck.com
>>> http://lists.fsck.com/mailman/listinfo/rt-users
>>> 
>>> 
>>> End of rt-users Digest_______________________________________________
>>> rt-users mailing list
>>> rt-users at lists.fsck.com
>>> http://lists.fsck.com/mailman/listinfo/rt-users
>>> 
>> 
>> 
>> 
>> 
>> 
>> _______________________________________________
>> rt-users mailing list
>> rt-users at lists.fsck.com
>> http://lists.fsck.com/mailman/listinfo/rt-users
>> 
> 
> 
> 
> --__--__--
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 
> 
> End of rt-users Digest_______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 








More information about the rt-users mailing list