date:20070807

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

2007-08-07 Thread Luke E Morgan


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.

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

I have modified by RT_SiteConfig.pm file.
If I log into the web interface, under tools, choose system configuration,
the following variables are set :
RT::LogoLinkURL http://192.168.66.1
RT::LogoURL /rt3/NoAuth/images/mtllogo.jpg
RT::LogoWidth 92
RT::LogoHeight 50
RT::MasonDataDir /var/cache/rt3/mason_data

I've tried stopping the webserver, deleting Logo.obj from
/var/cache/rt3/mason_data/obj/3989424063/standard
When I restart apache, and refresh the RT page, Logo.obj is recreated with
the best practical logo in it.

Where am I going wrong ?  Can anyone point me in the right direction please
?

Thanks in advance

Luke

_

This email message may contain privileged/confidential information and/or
copyright material.  It is intended only for the use of the person(s) to whom 
it is addressed and any unauthorised use may be unlawful.  If you receive this
email by mistake, please advise the sender immediately by using the reply
facility in your email software and delete the material from your computer.

The material contained in this message does not constitute a binding
contract with any company within the MTL Instruments Group plc.  Opinions,
conclusions and other information in this email that do not relate to the 
official
business of this organisation shall be understood as neither given nor endorsed 
by it.  Registered in England No. 1871978, VAT Reg. No 449343040, 
MTL Instruments Ltd, Power Court, Luton, LU1 3JJ

___
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-07 Thread Boris Lytochkin

=us-ascii


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.

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

I have modified by RT_SiteConfig.pm file.
If I log into the web interface, under tools, choose system configuration,
the following variables are set :
RT::LogoLinkURL http://192.168.66.1
RT::LogoURL /rt3/NoAuth/images/mtllogo.jpg
RT::LogoWidth 92
RT::LogoHeight 50
RT::MasonDataDir /var/cache/rt3/mason_data

I've tried stopping the webserver, deleting Logo.obj from
/var/cache/rt3/mason_data/obj/3989424063/standard
When I restart apache, and refresh the RT page, Logo.obj is recreated with
the best practical logo in it.

Where am I going wrong ?  Can anyone point me in the right direction please
?

Thanks in advance

Luke

_

This email message may contain privileged/confidential information and/or
copyright material.  It is intended only for the use of the person(s) to whom 
it is addressed and any unauthorised use may be unlawful.  If you receive this
email by mistake, please advise the sender immediately by using the reply
facility in your email software and delete the material from your computer.

The material contained in this message does not constitute a binding
contract with any company within the MTL Instruments Group plc.  Opinions,
conclusions and other information in this email that do not relate to the 
official
business of this organisation shall be understood as neither given nor endorsed 
by it.  Registered in England No. 1871978, VAT Reg. No 449343040, 
MTL Instruments Ltd, Power Court, Luton, LU1 3JJ

-- next part --
An HTML attachment was scrubbed...
URL: 
http://lists.bestpractical.com/pipermail/rt-users/attachments/20070807/37bbd464/attachment-0001.htm

--

Message: 5
Date: Tue, 7 Aug 2007 12:39:04 +0100
From: Luke E Morgan [EMAIL PROTECTED]
Subject: Re: {Disarmed} [rt-users] Trying to change the logo. Fedora
Core 7, RT3.6.3 yum install
To: Boris Jordanov [EMAIL PROTECTED]
Cc: rt-users@lists.bestpractical.com
Message-ID:
[EMAIL PROTECTED]

Content-Type: text/plain; charset=us-ascii

Skipped content of type multipart/alternative-- next part 
--
A non-text attachment was scrubbed...
Name: graycol.gif
Type: image/gif
Size: 105 bytes
Desc: not available
Url : 
http://lists.bestpractical.com/pipermail/rt-users/attachments/20070807/910b3d6a/graycol.gif
-- next part --
A non-text attachment was scrubbed...
Name: pic05705.gif
Type: image/gif
Size: 1255 bytes
Desc: not available
Url : 
http://lists.bestpractical.com/pipermail/rt-users/attachments/20070807/910b3d6a/pic05705.gif
-- next part --
A non-text attachment was scrubbed...
Name: ecblank.gif
Type: image/gif
Size: 45 bytes
Desc: not available
Url : 
http://lists.bestpractical.com/pipermail/rt-users/attachments/20070807/910b3d6a/ecblank.gif

--

___
RT-Users mailing list
RT-Users@lists.bestpractical.com
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users


End of RT-Users Digest, Vol 41, Issue 20


 

attach.patch
Description: Binary data


dhandler
Description: Binary data


attach_and_thumbs.patch2.diff
Description: Binary data


attach_and_thumbs.patch1.diff
Description: Binary data
___
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] Attachments table of RT's Mysql database

2007-08-07 Thread Kenneth Marshall

://wiki.bestpractical.com/view/ManualRights
nor in my personal page .

I tried copy pasting the first ManualScrips table wiki markup into another
edit page and saving, and it wouldn't render there either after save.

Ed Matthews
[EMAIL PROTECTED]

Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail,
news, photos more.
http://mobile.yahoo.com/go?refer=1GNXIC

Message: 4
Date: Tue, 7 Aug 2007 10:20:33 +0100
From: Luke E Morgan [EMAIL PROTECTED]
Subject: [rt-users] Trying to change the logo. Fedora Core 7, RT3.6.3
yum install
To: rt-users@lists.bestpractical.com
Message-ID:
[EMAIL PROTECTED]

Content-Type: text/plain; charset=us-ascii

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.

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

I have modified by RT_SiteConfig.pm file.
If I log into the web interface, under tools, choose system configuration,
the following variables are set :
RT::LogoLinkURL http://192.168.66.1
RT::LogoURL /rt3/NoAuth/images/mtllogo.jpg
RT::LogoWidth 92
RT::LogoHeight 50
RT::MasonDataDir /var/cache/rt3/mason_data

I've tried stopping the webserver, deleting Logo.obj from
/var/cache/rt3/mason_data/obj/3989424063/standard
When I restart apache, and refresh the RT page, Logo.obj is recreated with
the best practical logo in it.

Where am I going wrong ? Can anyone point me in the right direction please
?

Thanks in advance

Luke

This email message may contain privileged/confidential information and/or
copyright material. It is intended only for the use of the person(s) to whom
it is addressed and any unauthorised use may be unlawful. If you receive this
email by mistake, please advise the sender immediately by using the reply
facility in your email software and delete the material from your computer.

The material contained in this message does not constitute a binding
contract with any company within the MTL Instruments Group plc. Opinions,
conclusions and other information in this email that do not relate to the
official
business of this organisation shall be understood as neither given nor
endorsed
by it. Registered in England No. 1871978, VAT Reg. No 449343040,
MTL Instruments Ltd, Power Court, Luton, LU1 3JJ

-- next part --
An HTML attachment was scrubbed...
URL:
http://lists.bestpractical.com/pipermail/rt-users/attachments/20070807/37bbd464/attachment-0001.htm

Message: 5
Date: Tue, 7 Aug 2007 12:39:04 +0100
From: Luke E Morgan [EMAIL PROTECTED]
Subject: Re: {Disarmed} [rt-users] Trying to change the logo. Fedora
Core 7, RT3.6.3 yum install
To: Boris Jordanov [EMAIL PROTECTED]
Cc: rt-users@lists.bestpractical.com
Message-ID:
[EMAIL PROTECTED]

Content-Type: text/plain; charset=us-ascii

Skipped content of type multipart/alternative-- next part
--
A non-text attachment was scrubbed...
Name: graycol.gif
Type: image/gif
Size: 105 bytes
Desc: not available
Url :
http://lists.bestpractical.com/pipermail/rt-users/attachments/20070807/910b3d6a/graycol.gif
-- next part --
A non-text attachment was scrubbed...
Name: pic05705.gif
Type: image/gif
Size: 1255 bytes
Desc: not available
Url :
http://lists.bestpractical.com/pipermail/rt-users/attachments/20070807/910b3d6a/pic05705.gif
-- next part --
A non-text attachment was scrubbed...
Name: ecblank.gif
Type: image/gif
Size: 45 bytes
Desc: not available
Url :
http://lists.bestpractical.com/pipermail/rt-users/attachments/20070807/910b3d6a/ecblank.gif

___
RT-Users mailing list
RT-Users@lists.bestpractical.com
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

End of RT-Users Digest, Vol 41, Issue 20

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

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

Discover RT's

[rt-users] Optimize database after using rtx-shredder

2007-08-07 Thread Mathew Snyder

When we migrated from 3.2.x to 3.6.1 I cleared out roughly 15,000 users created
by spam and a comparable number of tickets.  I now have in place a script which
does this automatically and, considering we get about 100-150 emails a day which
are deemed to be spam, this leaves us with quite a few holes in our database.

I was looking into optimization to clean things up a bit but read that doing so
might require rebuilding indexes.  As the indexes are created when the database
is built at installation, I don't think it would be wise for me to run an
optimization which will leave me lacking these key items.

Does anyone have any insight as to whether or not optimization will mess with
things too much?

Thanks
Mathew
-- 
Keep up with me and what I'm up to: http://theillien.blogspot.com
___
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

[rt-users] Error while dumping RT database

2007-08-07 Thread Alex Moura

Hello,

Recently our RT database backup script started to show this message.

mysqldump: Error 5: Out of memory (Needed 19928072 bytes) when dumping table
`Attachments` at row: 390157

Any recommendations?

Thanks in advance,

Alex
___
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-07 Thread Boris Lytochkin

Harper , Stevens Industries

___
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

Thanks Justin for the feedback. Anyone else have input regarding their
experiences with Attachments and RT?

thanks - Greg

Message: 3
Date: Mon, 6 Aug 2007 11:53:13 -0700 (PDT)
From: Ed Matthews [EMAIL PROTECTED]
Subject: [rt-users] Kwiki Table Rendering?
To: rt-users@lists.bestpractical.com
Message-ID: [EMAIL PROTECTED]
Content-Type: text/plain; charset=us-ascii

Happy Monday.

Does anyone know why Kwiki renders tables on this page,
http://wiki.bestpractical.com/view/ManualScrips

but not on this page
http://wiki.bestpractical.com/view/ManualRights
nor in my personal page .

I tried copy pasting the first ManualScrips table wiki markup into another
edit page and saving, and it wouldn't render there either after save.

Ed Matthews
[EMAIL PROTECTED]

Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail,
news, photos more.
http://mobile.yahoo.com/go?refer=1GNXIC

Content-Type: text/plain; charset=us-ascii

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.

Where am I going wrong ? Can anyone point me in the right direction please
?

Thanks in advance

Luke

This email message may contain privileged/confidential information and/or
copyright material. It is intended only for the use of the person(s) to
whom
it is addressed and any unauthorised use may be unlawful. If you receive
this
email by mistake, please advise the sender immediately by using the reply
facility in your email software and delete the material from your computer.

-- next part --
An HTML attachment was scrubbed...
URL:
http://lists.bestpractical.com/pipermail/rt-users/attachments/20070807/37bbd464/attachment-0001.htm

Content-Type: text/plain; charset=us-ascii

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

2007-08-07 Thread Justin Brodley

6.06. I've made no modifications to the databases.
The primary concern at this point is that the Attachments table of the
Mysql database is growing significantly. Our CSR's want to attach
PDFs, jpegs, etc. to the tickets with the jpegs usually created by our
customers. The digital photos are the main culprit. I've read about
scaling back the photos, creating thumbnails, etc. and we need to find a
way to limit the attachment size prior to attachment.

Has anyone else using RT had this type of problem?

What are the best approaches for minimizing and controlling the size
of the Attachments table?

Any information, feedback and guidance are appreciated.

thanks - Gregory Harper , Stevens Industries

___
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

Thanks Justin for the feedback. Anyone else have input regarding their
experiences with Attachments and RT?

thanks - Greg

Happy Monday.

Does anyone know why Kwiki renders tables on this page,
http://wiki.bestpractical.com/view/ManualScrips

but not on this page
http://wiki.bestpractical.com/view/ManualRights
nor in my personal page .

I tried copy pasting the first ManualScrips table wiki markup into another
edit page and saving, and it wouldn't render there either after save.

Ed Matthews
[EMAIL PROTECTED]

Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail,
news, photos more.
http://mobile.yahoo.com/go?refer=1GNXIC

Content-Type: text/plain; charset=us-ascii

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.

Where am I going wrong ? Can anyone point me in the right direction please
?

Thanks in advance

Luke

This email message may contain privileged/confidential information and/or
copyright material. It is intended only for the use of the person(s) to
whom
it is addressed and any unauthorised use may be unlawful. If you receive
this
email by mistake, please advise the sender immediately by using the reply
facility in your email software and delete the material from your computer.

-- next part --
An HTML attachment was scrubbed...
URL:
http://lists.bestpractical.com/pipermail/rt-users/attachments/20070807/37bbd464/attachment-0001.htm

Message: 5
Date: Tue, 7 Aug 2007 12:39:04

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

2007-08-07 Thread Viktor

, please advise the sender immediately by using the reply
  facility in your email software and delete the material from your computer.
  
  The material contained in this message does not constitute a binding
  contract with any company within the MTL Instruments Group plc.  Opinions,
  conclusions and other information in this email that do not relate to the 
  official
  business of this organisation shall be understood as neither given nor 
  endorsed 
  by it.  Registered in England No. 1871978, VAT Reg. No 449343040, 
  MTL Instruments Ltd, Power Court, Luton, LU1 3JJ
  
  -- next part --
  An HTML attachment was scrubbed...
  URL: 
  http://lists.bestpractical.com/pipermail/rt-users/attachments/20070807/37bbd464/attachment-0001.htm
  
  --
  
  Message: 5
  Date: Tue, 7 Aug 2007 12:39:04 +0100
  From: Luke E Morgan [EMAIL PROTECTED]
  Subject: Re: {Disarmed} [rt-users] Trying to change the logo. Fedora
  Core 7, RT3.6.3 yum install
  To: Boris Jordanov [EMAIL PROTECTED]
  Cc: rt-users@lists.bestpractical.com
  Message-ID:
  [EMAIL PROTECTED]
  
  Content-Type: text/plain; charset=us-ascii
  
  Skipped content of type multipart/alternative-- next part 
  --
  A non-text attachment was scrubbed...
  Name: graycol.gif
  Type: image/gif
  Size: 105 bytes
  Desc: not available
  Url : 
  http://lists.bestpractical.com/pipermail/rt-users/attachments/20070807/910b3d6a/graycol.gif
  -- next part --
  A non-text attachment was scrubbed...
  Name: pic05705.gif
  Type: image/gif
  Size: 1255 bytes
  Desc: not available
  Url : 
  http://lists.bestpractical.com/pipermail/rt-users/attachments/20070807/910b3d6a/pic05705.gif
  -- next part --
  A non-text attachment was scrubbed...
  Name: ecblank.gif
  Type: image/gif
  Size: 45 bytes
  Desc: not available
  Url : 
  http://lists.bestpractical.com/pipermail/rt-users/attachments/20070807/910b3d6a/ecblank.gif
  
  --
  
  ___
  RT-Users mailing list
  RT-Users@lists.bestpractical.com
  http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
  
  
  End of RT-Users Digest, Vol 41, Issue 20
  
  
   
 
 
 
 
  ___
  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
 
 
 
 -- 
 Best regards,
  Boris Lytochkinmailto:[EMAIL PROTECTED]
 
 ___
 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
 
 ___
 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
 
___
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] Optimize database after using rtx-shredder

2007-08-07 Thread Viktor

Hello, Mathew.

 When we migrated from 3.2.x to 3.6.1 I cleared out roughly 15,000 users 
 created
 by spam and a comparable number of tickets.  I now have in place a script 
 which
 does this automatically and, considering we get about 100-150 emails a day 
 which
 are deemed to be spam, this leaves us with quite a few holes in our database.
 
 I was looking into optimization to clean things up a bit but read that doing 
 so
 might require rebuilding indexes.  As the indexes are created when the 
 database
 is built at installation, I don't think it would be wise for me to run an
 optimization which will leave me lacking these key items.
 
 Does anyone have any insight as to whether or not optimization will mess with
 things too much?

Which DBMS are you using?
If you use PostgreSQL, there is 'VACUUM FULL ANALYZE' option (I/O | RAM 
expensive, though...). It is described in postgres manual.
There's also CLUSTER or CLUSTER INDEX command in pgsql, it does reorder your 
data physically on the underlying storage.
However, data get messed again during normal database usage (inserts, deletes, 
updates...)

If you aren't using PostgreSQL, you probably should :)

 Thanks
 Mathew
 -- 
 Keep up with me and what I'm up to: http://theillien.blogspot.com
 ___
 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
 
___
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-07 Thread Scott T. Hildreth

On Fri, 2007-08-03 at 15:19 -0500, Scott T. Hildreth wrote:
 On Fri, 2007-08-03 at 10:51 -0500, Scott T. Hildreth wrote:
  On Thu, 2007-08-02 at 11:53 -0500, Scott T. Hildreth wrote:
   On Thu, 2007-08-02 at 09:27 -0700, Kenneth Crocker wrote:
Scott,


Normally, I would say that giving the privilege 
ShowOutgoingEmail 
would do the trick. It works just like ShowTicketComments. Having 
rights like SeeQueue and ShowTicket does not do the trick alone. 
However, I am now a little confused hearing that flipping the switch on 
$OldestTransactionsFirst did the trick. 
   
 Maybe, I didn't explain it right.  They can see the replies  email it
   is that all the history does not display on the page.  By reversing the 
   order the newer transactions fill the page now and the older history is
   not displaying.  I'm wondering if this is some sort of limit set?
   
  
This ticket I am looking at has 83 transactions. 

  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?

  Thanks.

  
  Only 17 or so show 
up in the History section of the page. 
 
 Well, I opened my eyes wider and found this,
  
   http://wiki.bestpractical.com/view/HideTransactions
 
 which should show all the history on the History Tab, 
 although it shows a couple of more of the Transactions,
 they are all not there.
 
 Something is limiting the page size, not sure what.  I will
 continue testing, just seeing if more info will spark an 
 answer. 
 
 
   Is there a way to display all
the transactions or have next page link?
 
 I see this is on the WishList on the wiki,
 
 Ability to display ticket history by page, e.g. 15 rows/transaction 
  logs per page, with Next, First, Previous, Last buttons/links at the 
  bottom or top. Especially helpful and useful for tickets with huge 
  history/transactions and if using RT from a slow connection.
 
 Does anyone else have 
this issue?   
 
   
 Thanks for listening. :-)
   

  
   
Unless you had already granted 
that privilege (ShowOutgoingEmail) and the descending order was the 
problem. Interesting.


Kenn
LBNL


Scott T. Hildreth wrote:
 I know I must be missing something obvious hear, but I can't find the
 answer.   I've had complaints about updates not displaying for a 
 ticket.
 The email would go out, but the reply was not shown in the Ticket
 History.   I looked into it and saw the data was there just not
 displaying on the web page.  So I set the $OldestTransactionsFirst
 to '0' and the data showed up to the top of the history.  This turned
 to be an option the users wanted anyways.  My question is how do you 
 access the history data that is not showing on the page?  
 
 
 Thanks.
 
-- 
Scott T. Hildreth [EMAIL PROTECTED]
___
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] Attachments table of RT's Mysql database

2007-08-07 Thread Drew Barnes

the attachment size prior to attachment.

Has anyone else using RT had this type of problem?

What are the best approaches for minimizing and controlling the size
of the Attachments table?

Any information, feedback and guidance are appreciated.

thanks - Gregory Harper , Stevens Industries

___
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

Thanks Justin for the feedback. Anyone else have input regarding their
experiences with Attachments and RT?

thanks - Greg

Happy Monday.

Does anyone know why Kwiki renders tables on this page,
http://wiki.bestpractical.com/view/ManualScrips

but not on this page
http://wiki.bestpractical.com/view/ManualRights
nor in my personal page .

I tried copy pasting the first ManualScrips table wiki markup into another
edit page and saving, and it wouldn't render there either after save.

Ed Matthews
[EMAIL PROTECTED]

Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail,
news, photos more.
http://mobile.yahoo.com/go?refer=1GNXIC

Content-Type: text/plain; charset=us-ascii

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.

Where am I going wrong ? Can anyone point me in the right direction please
?

Thanks in advance

Luke

This email message may contain privileged/confidential information and/or
copyright material. It is intended only for the use of the person(s) to
whom
it is addressed and any unauthorised use may be unlawful. If you receive
this
email by mistake, please advise the sender immediately by using the reply
facility in your email software and delete the material from your computer.

-- next part --
An HTML attachment was scrubbed...
URL:
http://lists.bestpractical.com/pipermail/rt-users/attachments/20070807/37bbd464/attachment-0001.htm

Content-Type: text/plain; charset=us-ascii

Skipped content of type multipart/alternative-- next part
--
A non-text attachment was scrubbed...
Name: graycol.gif
Type: image/gif

[rt-users] Problem initializing database

2007-08-07 Thread John Oliver

[EMAIL PROTECTED] ~]# /usr/sbin/rt-setup-database --action init --dba root
--prompt-for-dba-password
In order to create or update your RT database,this script needs to
connect to your mysql instance on 10.12.14.149 as root.
Please specify that user's database password below. If the user has no
database
password, just press return.

Password:
Now creating a database for RT.
Creating mysql database rt3.
Now populating database schema.
Creating database schema.
readline() on closed filehandle SCHEMA_LOCAL at
/usr/sbin/rt-setup-database line 192.
Done setting up database schema.
Now inserting database ACLs
DBD::mysql::st execute failed: Access denied for user
'root'@'10.12.14.164' to database 'rt3' at /usr/sbin/rt-setup-database
line 345.
Problem with statement:
 GRANT SELECT,INSERT,CREATE,INDEX,UPDATE,DELETE ON rt3.* TO
rt_user@'10.12.14.164' IDENTIFIED BY '***';
Access denied for user 'root'@'10.12.14.164' to database 'rt3' at
/usr/sbin/rt-setup-database line 346.


On the MySQL server, I did:

grant all on *.* to 'root'@'10.12.14.164' identified by ''

but am still getting that error.


I'm aware that this is almost certainly a MySQL error, but I don't think
I'll get much help from any MySQL forums since I can't tell them exactly
what /usr/sbin/rt-setup-database is doing.

-- 
***
* John Oliver http://www.john-oliver.net/ *
* *
***
___
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] Problem initializing database

2007-08-07 Thread Scott Hebert

On 8/7/07, John Oliver [EMAIL PROTECTED] wrote:


 grant all on *.* to 'root'@'10.12.14.164' identified by ''



This is *almost* proper syntax.

Try this instead...

GRANT ALL ON *.* TO 'root'@'10.12.14.164' IDENTIFIED BY 'password' WITH
GRANT OPTION

Good luck!

--
Scott
___
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] Problem initializing database

2007-08-07 Thread John Oliver

On Tue, Aug 07, 2007 at 01:11:24PM -0500, Scott Hebert wrote:
 On 8/7/07, John Oliver [EMAIL PROTECTED] wrote:
 
 
  grant all on *.* to 'root'@'10.12.14.164' identified by ''
 
 
 
 This is *almost* proper syntax.
 
 Try this instead...
 
 GRANT ALL ON *.* TO 'root'@'10.12.14.164' IDENTIFIED BY 'password' WITH
 GRANT OPTION


THAT DID IT

Thank you! :-)

-- 
***
* John Oliver http://www.john-oliver.net/ *
* *
***
___
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

[rt-users] Search old tickets from within scrip

2007-08-07 Thread Keith Edmunds

RT 3.6.1

We have one custom field per ticket, Customer, of type 'select one
value'. So far, we've set that value manually on each new ticket, but I'd
like to automate it.

What I'd like to do, within a script, is search for the last ticket from
this requestor and set the customer custom field to the same value. In
pseudo SQL terms: select customer from custom_fields where
requestor_address = '$requestor' and customer != null order id desc limit
1. How can I do that kind of search from a script? I'm not looking for
in-depth instructions, just a pointer as to the best way of doing this.

Thanks,
Keith
___
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] Search old tickets from within scrip

2007-08-07 Thread Ruslan Zakirov


my $tickets = RT::Tickets-new( $RT::SystemUser );
$tickets-FromSQL(Requestor.EmailAddress = '$address' AND
'CustomField.{Customer}' IS NOT NULL);
# fetch from DB only first one ticket
$tickets-RowsPerPage(1);

my $ticket = $tickets-First;
return undef unless $ticket;

return $ticket-FirstCustomFieldValue('Customer');


* code not tested
* I'm not sure if 3.6.1 supports 'IS NOT NULL' for CFs, but 3.6.latest should

I can suggest you another way with two scrips:
1) Update Company field of requestors when an user update customer custom field
2) On ticket create check if a requestor has defined Company property
and update the field

On 8/8/07, Keith Edmunds [EMAIL PROTECTED] wrote:
 RT 3.6.1

 We have one custom field per ticket, Customer, of type 'select one
 value'. So far, we've set that value manually on each new ticket, but I'd
 like to automate it.

 What I'd like to do, within a script, is search for the last ticket from
 this requestor and set the customer custom field to the same value. In
 pseudo SQL terms: select customer from custom_fields where
 requestor_address = '$requestor' and customer != null order id desc limit
 1. How can I do that kind of search from a script? I'm not looking for
 in-depth instructions, just a pointer as to the best way of doing this.

 Thanks,
 Keith
 ___
 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



-- 
Best regards, Ruslan.
___
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

[rt-users] RTFM public viewable

2007-08-07 Thread Kevin Squire


I have been doing about 2 days worth of searching both the mailing list
and the general web trying to find some example/screenshots/etc of RTFM,
but with little luck.

I am trying to figure out (1) If RTFM can be used to create/maintain a
publicly viewable (i.e. no need to log into RT) FAQ base (2) If it would
fit well into our organization.

Of course no one can answer #2 for me, but I was hoping someone one the
list was using RTFM as noted in #1 and would be willing to share with
me the URL or a few screenshots. (off list would be fine if you prefer)

Or do I have this all wrong, and RTFM is only for the privileged user?


-- 
http://gentgeen.homelinux.org

#
 Associate yourself with men of good quality if you esteem
 your own reputation; for 'tis better to be alone then in bad 
 company.- George Washington, Rules of Civility
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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


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

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

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

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

[rt-users] Optimize database after using rtx-shredder

[rt-users] Error while dumping RT database

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

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

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

Re: [rt-users] Optimize database after using rtx-shredder

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

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

[rt-users] Problem initializing database

Re: [rt-users] Problem initializing database

Re: [rt-users] Problem initializing database

[rt-users] Search old tickets from within scrip

Re: [rt-users] Search old tickets from within scrip

[rt-users] RTFM public viewable

17 matches

Site Navigation

Mail list logo

Footer information