date:20070808

[rt-users] Links are not clickable

2007-08-08 Thread Firas Batal $QA/EMC$

 

Hi everyone,

 

I am wondering whether there is someone there who could help.

 

This is the summary of the problem: Links are not clickable after I have
changed the Default RT at a Glance.   I am running RT 3.6.3,  Perl
v5.8.3 under Linux (FC6), and MySql 5.0.27. This is not a production
site, but rather an experimental PC that carry RT 3.6.3.  I were doing
some tests and experimenting when the reported problem has happened.
 
This is what I have done: I have logged in as root.  I have changed the
default RT at a glance page using the information posted on the wiki
(ChangeDefaultRTAtAGlance
http://wiki.bestpractical.com/view/ChangeDefaultRTAtAGlance  ).  I
intentionally removed 10 newest unowned tickets, and did some
customization on 10 highest priority tickets I own and then the tickets
listed under the heading are not clickable.  When I click on 10 highest
priority tickets I own, I see the ticket, but they are not clickable.
 
I am wondering if some one has seen this before.  I have searched the
mail list, but to avail. 

Thanks and I apologize for the innconvinience.
Firas 

 

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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re[2]: [rt-users] Attachments table of RT's Mysql database

2007-08-08 Thread Boris Lytochkin

Wiki would be enough, but there is a problem in current patch state:
it uses special constant string inplace of real content to indicate
that file is located out of DB.
Right way is to use flag in table. I do not think that changing scheme
 witch patching is a good idea, that is why this patch must be merged into RT.

Now about different strokes for different folks.
This way of storing attachments is reasonable when you get 50Mb+ of mail
each week (scans, faxes, documents, etc).

-- 
Boris Lytochkin,
JSC e-port, Moscow
web: www.e-port.ru, wap: wap.e-port.ru
tel: +7 (495) 777 1872, ext. 251


__

From: Drew Barnes
Sent: 7 августа 2007 г., 21:08
To:   Boris Lytochkin
Subject: [rt-users] Attachments table of RT's Mysql database
I guess it all comes down to different strokes for different folks. 
Perhaps this could be put up on the wiki and then if someone needs this
capability they can easily get it?

DB


Boris Lytochkin wrote:
 Ken,

   
 First, if everything is inside a database, then a
 simple backup of the database will get everything related to a
 particular RT instance.
 
 Wrong. We _stopped_ backup process of RT database due to LARGE amount
 data every day. We have no such amount of tape to store DB's everyday
 backups.
 Now, DB backup is done every day and attachment backup is done
 separately. As a result we have everyday SQL-backup of DB and
 incremental backup for attachments. It uses much less space.

   
 Second, in many cases you would like to
 isolate the front-end from the back-end information store. Once
 you need access to the filesystem, everything becomes much more
 involved.
 

 I understand that storing attachments out of RT involves much more
 than DB-only solution, BUT 10 Gb DB with 9.5 Gb of images involves much more.

 Anyway, it is up to admin to decide whether to store attachments
 separate or not.


 Tuesday, August 7, 2007, 4:22:49 PM, you wrote:

   
 Dear Mr. Lytochkin,
 

   
 There are two very good reasons to not store attachments outside
 of the database. First, if everything is inside a database, then a
 simple backup of the database will get everything related to a
 particular RT instance. Second, in many cases you would like to
 isolate the front-end from the back-end information store. Once
 you need access to the filesystem, everything becomes much more
 involved. I am certain that there are other reasons, but those
 two are certainly enough for me. I have appreciated the ease of
 generating a consistent backup of my RT information store.
 

   
 Ken
 

   
 On Tue, Aug 07, 2007 at 04:15:02PM +0400, Boris Lytochkin wrote:
 
 I wrote a patch that allows to store non-text attachments to be
 stored out of DB - in my case it greatly reduced DB swelling.
 Just for now it uses constant string in Attachments-Content to
 indicate that file is written to FS.

 You will need to specify some variables in RT_Siteconfig.pm:
 Set($AttachmentsDirectory, '/var/RT/attachments');
 Set($LogAttachmentsLoading, 1);
 Set($LogAttachmentsSaving, 1);
 Set($StoreNonTextAttachmensInDB, undef);
 #Set($StoreNonTextAttachmensInDB, 1);

 A new share/html/Ticket/Attachment/dhandler and attach.patch for
 rest of RT distribution is in attachment.


 Gregory Harper, you can find more complex set of patches allowing to
 produce  show image thumbs automaticly in attachment too.
 Some more variables must be specified in RT_Siteconfig.pm

 Set($ShowTransactionImages, 1);
 Set($ProduceImageThumbs, 1);
 Set($ImageThumbsDirectory, '/var/RT/thumbs');


 I wonder why bestprcactical is not interested in intergating these
 patches into RT:
 From: Jesse Vincent
 Sent: 21 march 2007 ?., 23:53
 To:   lytochkin
 Subject: [RT 3.6] Storing attachments away from DB
 Hi Boris,

 Thanks very much for the mail, but I think we're not really  
 interested in offering this feature within RT.
 Best,
 Jesse




 -- 
 Boris Lytochkin,
 JSC e-port, Moscow
 web: www.e-port.ru, wap: wap.e-port.ru
 tel: +7 (495) 777 1872, ext. 251


 

 Date: Mon, 06 Aug 2007 12:31:31 -0500
 From: Gregory Harper [EMAIL PROTECTED]
 Subject: Re: [rt-users] Attachments table of RT's Mysql database
 To: Justin Brodley [EMAIL PROTECTED]
 Cc: rt-users@lists.bestpractical.com
 Message-ID: [EMAIL PROTECTED]
 Content-Type: text/plain; charset=ISO-8859-1; format=flowed

 Justin Brodley wrote:
   
 We actually had to disable the attachment feature as we were having our 
 customers attach enormous files and killed our DB processing. Ultimately we
 
 are looking
   
 into rewriting the attachment feature to store the attachments on the web 
 server to alleviate this overhead from the DB. I understand that the
 
 attachment table also
   
 stores all updates to a ticket, not just the attachments. 


 Justin Brodley 



 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gregory 
 Harper
 Sent: Wednesday, August 01, 2007

[rt-users] Pg database connection - authentication failed

2007-08-08 Thread Gary Stainburn

Hi folks.

I've just had to move my RT3 install onto a new box and all's going well until 
I try to use it.  When I try to bring the login page up I get Internal Server 
Error.

The log file shows:
[Wed Aug 08 11:18:06 2007] [error] [client 10.1.1.118] Connect Failed FATAL:  
password authentication failed for user rt_user\n\n at /opt/rt3/lib/RT.pm 
line 205\n

If I try to access the database using:

export PGDATABASE=rt3
export PGHOST=127.0.0.1
export PGPASSWORD=password
export PGUSER=rt_user
psql

it lets me in no problem, but RT fails.  my RT_Config.pm includes:

Set($DatabaseType , 'Pg');
Set($DatabaseHost   , 'localhost');
Set($DatabaseRTHost , 'localhost');
Set($DatabasePort , '');
Set($DatabaseUser , 'rt_user');
Set($DatabasePassword , 'password');
Set($DatabaseName , 'rt3');
Set($DatabaseRequireSSL , undef);

Anyone got any suggestions
-- 
Gary Stainburn
 
This email does not contain private or confidential material as it
may be snooped on by interested government parties for unknown
and undisclosed purposes - Regulation of Investigatory Powers Act, 2000 
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Trying to change the logo. Fedora Core 7, RT3.6.3 yum install

2007-08-08 Thread Joe Casadonte


On 8/7/2007 5:20 AM, Luke E Morgan wrote:

I'm sure I'm just missing something simple, but I cannot seem to change 
the BP logo on my install of RT 3.6.3 on Fedora Core 7.
I've installed RT using yum (lazy I know, but it works apart from this 
issue).


It has been installed into
/usr/share/rt3
I've created /usr/local/rt3/html/Elements/
and copied the Logo file into that directory.

I've added the logo I want to use into /usr/share/rt3/html/NoAuth/images
It is a 92x50pixels jpeg.


I'm using 3.6.3 (not from yum, though) and I have done the same thing, 
up to this point.  However, I have something different for the Logo file 
changes:


Following suggestions from the wiki and the mailing list archives, I put 
this line into the Logo file :
a href=%$RT::LogoLinkURL%img src=%$RT::LogoURL% 
alt=Intranet width=%$RT::LogoWidth% height=%$RT::LogoHeight% 
//a


a href=%$RT::WebBaseURL%img 
src=%$RT::WebImagesURL%my-logo.jpg alt=Alternate Logo width=139 
height=20 //a


Where WebBaseURL and WebImagesURL are:

Set($WebBaseURL , http://machine.domain.com;);
Set($WebImagesURL , $WebPath . /NoAuth/images/); # default
Set($WebPath , );# default

Cleared the cache and that was it.

--
Regards,


joe
Joe Casadonte
[EMAIL PROTECTED]

==  ==
== The statements and opinions expressed here are my own and do not ==
== necessarily represent those of Oracle Corporation.   ==
==  ==
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] History Display for a Ticket

2007-08-08 Thread Joe Casadonte

On 8/7/2007 1:01 PM, Scott T. Hildreth wrote:

If I query the Transactions table, selecting only transactions for this
ticket that were created by non-RT::System ids, there are 29. All of type
RT::Ticket. If unset the $OldestTransactionsFirst, the history on the display
page shows the first 20 Tickets (non-system tickets, I added the HideTransactons override)
If re-set $OldestTransactionsFirst in RT_SiteConfig.pm, stop apache, remove
mason_data/obj/*, restart apache, search for that ticket, the ticket display

only shows the last 7 tickets. I have looked at RT code and read
relevant chapters
in RT Essentials and I cannot figure out why the all history will not
show up
in the History section. I feel like I am really overlooking something obvious,
does anyone have any ideas on what is going?

I just looked at the 3.6.3 code, and I can't see anything that would
limit the number of history records shown, nor do I see anything
different with OldestTransactionsFirst aside from ASC vs. DESC in the
select. What code base are you on?

--
Regards,

joe
Joe Casadonte
[EMAIL PROTECTED]

== ==
== The statements and opinions expressed here are my own and do not ==
== necessarily represent those of Oracle Corporation. ==
== ==
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

53 matches

Mail list logo