[rt-users] Trying to change the logo. Fedora Core 7, RT3.6.3 yum install
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
=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
://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
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
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
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 -- 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
RE: Re[2]: [rt-users] Attachments table of RT's Mysql database
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 -- 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 -- 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
Re[4]: [rt-users] Attachments table of RT's Mysql database
, 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
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
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
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 -- 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 -- 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
[rt-users] Problem initializing database
[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
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
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
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
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
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