Re: [rt-users] Sessions Table is MyISAM
On 09/22/2009 08:05 AM, Jesse Vincent wrote: On Mon, Sep 21, 2009 at 07:15:09PM -0700, Behzad Mahini wrote: I have done a fresh installation of RT 3.8.4, and have done no modifications of any sort to the default installation.and was preparing to do my database backup (using mysqldump),and noticed the only table that has a MyISAM engine is the 'Sessions' Table (the rest are all InnoDB as expected). My understanding is that all of these tables were to have been of the InnoDB engine type (RT's transaction-based requirements/ recommendations). 1) Is this by design, or due to an unresolved bug? Closer to the former than the latter. What are the benefits of the Sessions table being MyISAM now that InnoDB read/write throughput is in most cases superior to MyISAM? Micah
Re: [rt-users] Sessions Table is MyISAM
On 11/29/2010 07:22 PM, Ruslan Zakirov wrote: On Tue, Nov 30, 2010 at 4:00 AM, Micah Gersten mi...@onshore.com wrote: On 09/22/2009 08:05 AM, Jesse Vincent wrote: On Mon, Sep 21, 2009 at 07:15:09PM -0700, Behzad Mahini wrote: I have done a fresh installation of RT 3.8.4, and have done no modifications of any sort to the default installation.and was preparing to do my database backup (using mysqldump),and noticed the only table that has a MyISAM engine is the 'Sessions' Table (the rest are all InnoDB as expected). My understanding is that all of these tables were to have been of the InnoDB engine type (RT's transaction-based requirements/ recommendations). 1) Is this by design, or due to an unresolved bug? Closer to the former than the latter. What are the benefits of the Sessions table being MyISAM now that InnoDB read/write throughput is in most cases superior to MyISAM? No reason for a long time. Except converting needs upgrade script to handle existing instances. Also, it's not trivial to measure real RT oriented performance impact to force development. Simulating spherical horses in vacuum is not enough for motivation :) So, it could break future upgrades then?
Re: [rt-users] A problem with Ticket Search
I'm also having this issue. Does anyone know how to limit which users show up in the Query Builder? Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com anusiak wrote: I am a begginer RT administrator, and we are using RT with our company's user support system. We have about 10 or more e-mail addresses/users in RT database at the moment, and trying to enter search engine, run simple search or bulk update causes all of those e-mail addresses to load (which takes approximately 20-30 minutes) before we can do anything. Is there any way to configure RT not to load all of those data? I would appreciate any help. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Day of the week
This might be what you're looking for: http://search.cpan.org/~stbey/Date-Calc-5.4/Calc.pod Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Tomáš Sára wrote: Hello everybody, is there a possibility to find out the day of the week out of the date? I sopose there should be a perl function for this. Am I right? I searched mailing lists but I didn't find any information there. Thanks in advance for any help, Tom. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Consistency check script?
We lost a DB and had an old backup. We reran all the binlogs that we had, but there was some missing data that's causing problems now when trying to use RT. Mainly missing users and groups. Does someone have a script that can check the DB and purge anything that's not consistent such as Watchers and requestors on tickets? -- Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] RT API on another system
Has anyone ever worked with the API on a machine other than the RT server? We're looking at have apps on another machine interact with RT. If I point the local installation (not RT server) at the RT server MySQL DB, will I have full access all the features that the API allows? Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] is SELECT GET_LOCK normal?
I had this problem about a month ago. Search the archives for: Apache Session locking taking a while You should see some info on a possible fix. Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Bryan McLellan wrote: I'm having issues with large tickets taking a while to load. FF3, IE7 and Links all show the symptoms where there will be long pauses between tickets being displayed RT 3.8.1 (source build) on Ubuntu intrepid amd64, with fast-cgi mysql-server 5.0.32-7etch5 on Debian etch x86, with huge.cnf on the mysql server in the show process-list shows: | Id | User | Host | db | Command | Time | State | Info | | 220 | rtuser | client:60233 | rtdb | Query | 28 | User lock | SELECT GET_LOCK('Apache-Session-a085f3079e948dbcff5c416644dce981', 3600) | | 221 | rtuser | client:60260 | rtdb | Query | 28 | User lock | SELECT GET_LOCK('Apache-Session-a085f3079e948dbcff5c416644dce981', 3600) | | 223 | rtuser | client:60281 | rtdb | Query | 28 | User lock | SELECT GET_LOCK('Apache-Session-a085f3079e948dbcff5c416644dce981', 3600) | About 20 comments on this ticket. One merge. The time column continues growing until the page is loaded: Time to display: 87.689462 The database has been through a number of upgrades from about 3.6.1. Perhaps there's something that went wrong in a db upgrade? Maybe I should try to dump and import the data to a fresh database? Bryan ___ 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] MySQL Admin Commands?
I'm looking at PHPMyAdmin. It says about 48% of queries to the MySQL server are Admin commands. This info is in the com_admin_commands status variable in MySQL. Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Ham MI-ID, Torsten Brumm wrote: What kind of Admin Commands ? We are on 3.6.5 and we don't see Admin Commands Torsten -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Micah Gersten Gesendet: Mittwoch, 19. November 2008 04:55 An: RT Users Betreff: [rt-users] MySQL Admin Commands? Almost half of the queries from RT to the MySQL DB seem to be Admin commands. Is this normal? We're using 3.6.0. Was this improved in future versions? ___ 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] Purging sessions table in rt DB
Is there a reason not to? -- Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.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] MySQL Admin Commands?
Almost half of the queries from RT to the MySQL DB seem to be Admin commands. Is this normal? We're using 3.6.0. Was this improved in future versions? -- Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.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] Changes to HTML files not showing.
You have to restart Apache. Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Antikx wrote: Hello, First off...I'm really enjoying RT. It's a great product. I'm trying to customize the SelfServe/Create.html page so that it doesn't display the Requester, CC and Attach file fields. I've created the dir SelfServe in local/html ...and copied the Create.html from share/html/SelfServe When I edit that file the updates do not show up. When I edit share/html/SelfServeCreate.html the updates do not show up. After I restart apache the updates do not show up. After I clean out the var/mason_data/obj/ folder the updates do not show up. When I hold down shift and click refresh on my browser (to grab a non--cached page), the updates do not show up. When I try a different browser, the updates do not show up. When I set develmode to 1, the updates do not show up. I guess what I'm trying to say is... the updates do not show up no matter what I do. :) Any suggestions please? I'm trying to put the selfserve page into production ASAP, so your help would be greatly appreciated. ___ 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] Weird issue - web gui logout on comment/reply
Are you using https? Is RT configured to use https? We have this problem when someone tries to access RT with https, but our server is not det up to handle it properly. Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Shane Ronan wrote: Hello everyone, Hoping someone else has experienced what I am, so I can get some help. Whenever I comment or reply to a ticket in the web gui and hit submit, I get logged out. When I log back in, I am brought right back to the ticket I was commenting or replying to. Any ideas? thanks in advance. Shane I am running RT v. 3.8.0 w/ Apache/2.2.3 ___ 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] Let's say...
Can't you just make an alias on the mail server and make the queue address [EMAIL PROTECTED](t).com? Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Jean-Sebastien Morisset wrote: Let's say you have 4 e-mail addresses for 'appearances', but you really need only one queue in RT. So all 4 e-mail addresses all go to the same queue. Now when a queue worker adds a reply to a ticket, an e-mail gets sent to the requestor. The problem is that e-mail is not one of the original 4. For example: [EMAIL PROTECTED] - Help Queue [EMAIL PROTECTED] - Help Queue [EMAIL PROTECTED] - Help Queue [EMAIL PROTECTED] - Help Queue And the reply would come from [EMAIL PROTECTED] for example. How would you solve a problem like this? Do you have no choice but to create 4 queues? Thanks, js. ___ 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] Username at RT login not matching Ticket sent via e-mail
In RT 3.6.0 it doesn't seem to create 2 accounts for this. Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Jorge Aldana wrote: Well users login with username and the ticket is sent in via e-mail as [EMAIL PROTECTED] so yes there's two accounts. Does RT allow for users to login via [EMAIL PROTECTED] Or is there a scrip to alter the tickets to set it to username instead of [EMAIL PROTECTED] as requester when tickets are created? Or force users to login as [EMAIL PROTECTED] I'm still fishing through the doc's and learning RT so don't quite know where the tweaking can take place for this. Any guide or pointing to guides if anyone can. Thanks, Jorge On Mon, 28 Jul 2008, John Arends wrote: Do their usernames have the proper email address? Or do you end up with 2 accounts per person? If the account a user logs in with is not the same as the account created when the email is sent in, then the user won't be able to see the tickets from the other account because you will have essentially two accounts. Jorge Aldana wrote: Hello All, As users send tickets via e-mail their tickets are Requester set to [EMAIL PROTECTED] but at login they are username and as username cannot see their e-mailed tickets within the RT website. Is there a way to set it so logging in users can see their e-mailed tickets? A scrip or config? I just was moved to running our RT so I'm still fishing through the config's and setup. Thanks, Jorge ___ 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
[rt-users] 3.8.0 and backwards compatability
I'm wondering if the 3.8.0 DB schema is backwards compatible with 3.6.0. Does anyone know? -- Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.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] mysql performance problem
Turn this on in your my.cnf file so you can see if it's the MySQL queries: #log_slow_queries= /var/log/mysql/mysql-slow.log Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Raphael Loziczky wrote: How can I enable RT debug log? mysql error log shows no errors... very slow means that it hangs for about 1 minute - we have our old system running with the same db which is much faster! (on old hardware) the mysql dump is about 20 gigs... when I made the dump from the old system I had to use force recovery mode with mysql to get a working dump. maybe thats the problem? Ruslan Zakirov schrieb: RT debug log. mysql slow log. Very slow? How slow? Hangs forever or 1 minute? How big is your DB? On Fri, Jul 11, 2008 at 12:47 PM, Raphael Loziczky [EMAIL PROTECTED] wrote: hi, I fixed the issue with lighttpd and got it up and running :) Now for testing proposals I use lighttpd and apache with both webservers I have the problem that e.g. opening a ticket is very slow (with both webservers) and the CPU usage increases to 100% Does anyone has an idea how to fix this? Its a brand new server and i dumped the mysql data in it... Thanks for any help! best regards, Raphael ___ 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 -- Raphael Loziczky System Administrator [EMAIL PROTECTED] -- Greentube Internet Entertainment Solutions AG Mariahilfer Straße 47/1/102 A-1060 Wien FN 197003k, HG Wien Tel: +43 1 494 50 56 - 30 Fax: +43 1 494 50 56 - 14 http://www.greentube.com/ Internet Email Confidentiality Footer Privileged/confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to this person), you may not copy or deliver this message to anyone. In such a case, you should destroy this message and kindly notify the sender by replying. Please make it known immediately f you or your employer does not consent to the medium of e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of my firm shall be understood as neither given nor endorsed by it. ___ 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] Out of office.RT-Users Digest, Vol 52, Issue 26
Can the maintainer of the list prevent these bounces from going to everyone? Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Steve Walsh wrote: Steve Walsh is off on leave. For Ottawa Sun IT related issues please contact: Tom Barnes [EMAIL PROTECTED] (613) 739-5159 Thank you. ___ 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] mysql 5.1 slow query in RT
What are your indices on? Which columns? Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Mike Zupan wrote: We moved our RT server from mysql 4.0 to 5.1 and we are having some slow query issues on the Attachments table not finding the correct index mysql explain SELECT main.* FROM Attachments main WHERE (main.Parent = '308267') AND (main.ContentType = 'text/plain') ORDER BY main.id http://main.id ASC; ++-+---+---+--+-+-+--+-+-+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | ++-+---+---+--+-+-+--+-+-+ | 1 | SIMPLE | main | index | Attachments3,Attachments4,Parent | PRIMARY | 4 | NULL | 1321158 | Using where | ++-+---+---+--+-+-+--+-+-+ 1 row in set (0.00 sec) mysql explain SELECT main.* FROM Attachments main FORCE INDEX(Attachments3) WHERE (main.Parent = '308267') AND (main.ContentType = 'text/plain') ORDER BY main.id http://main.id ASC; ++-+---+--+---+--+-+---+--+-+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | ++-+---+--+---+--+-+---+--+-+ | 1 | SIMPLE | main | ref | Attachments3 | Attachments3 | 4 | const | 1 | Using where; Using filesort | ++-+---+--+---+--+-+---+--+-+ 1 row in set (0.00 sec) It works if I choose to force the index. I have been trying to find where in the code this is to at least force the index but I have not found it. ___ 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] new tickets don't email cc'ers
Check to see the global permissions for CC users. Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Kimberly McKinnis wrote: I don’t know who broke what, but my RT system is not even attempting to email cc’d folks on new tickets created through the web. On any queue, so it doesn’t appear to be a permissions issue. No edits appear to have been made to SendEmail.pm. Does anyone know of anything else that could cause this? Thanks! ~~ Kimberly McKinnis System Operations Engineer Service Provider Division, TiVo Inc 408-519-9607 ___ 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] RT Query - Ticket SQL
In SQL, you have to use % as a wildcard when doing a like query. If GL is a prefix then you want to do Queue LIKE 'GL%'. Thank you, Micah Gersten Internal Developer onShore Networks www.onshore.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kenneth Crocker Sent: Thursday, March 27, 2008 3:13 PM To: rt Users Subject: [rt-users] RT Query - Ticket SQL To all, I don't believe I have seen any threads on this question, but if so, please forgive me. I just re-named a bunch of queues to include a prefix so that if a particular group works with tickets in several queues, they can create a query that asks for queues LIKE XX- instead of listing each queue they want to search. So, I went to advanced and change the SQL from (Queue = 'GL' OR Queue = 'AP' etc.) to Queue LIKE 'FS-' and I got garbage. Didn't work at all. I tried a few variations like (Queue LIKE 'FS') but to no avail. Does anyone have a list of the available 'Ticket SQL' commands? Has anyone tried this and been successful? If so, what did you code? Thanks. Kenn LBNL ___ 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 No virus found in this incoming message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.22.0/1344 - Release Date: 3/26/2008 8:52 AM No virus found in this outgoing message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.22.0/1344 - Release Date: 3/26/2008 8:52 AM ___ 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] Seeing Unowned tickets in queues that a user cannot see
We’re having a problem that users can see unowned tickets in queues that they do not have the SeeQueue right for. The ticket info shows up, but not the queue name. We are running RT 3.6.0. Is there an easy fix for this? Thank you, Micah Gersten Internal Developer onShore Networks www.onshore.com No virus found in this outgoing message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.21.7/1333 - Release Date: 3/18/2008 8:10 AM ___ 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] Remove Auto Create User
What if you remove the create ticket right from Everyone and Unprivileged? Micah Gersten onShore Networks www.onshore.com _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Aaron Allard Sent: Monday, February 25, 2008 4:21 PM To: rt-users@lists.bestpractical.com Subject: [rt-users] Remove Auto Create User I have spent about 4 hours trying to find out how to stop the auto creation of users. I need RT to only accept users that are specifically created through the administration of RT by an administrator. I have found one thread: HYPERLINK http://www.gossamer-threads.com/lists/rt/users/17680?search_string=auto%20c reate%20user;#17680http://www.gossamer-threads.com/lists/rt/users/17680?sea rch_string=auto%20create%20user;#17680 that comes close to a solid fix for this but not quite. This is a production system so I need a solid fix. OS=RHEL3.4 RT=3.6.5 Thank you, Aaron No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.21.1/1297 - Release Date: 2/25/2008 9:22 AM No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.21.1/1297 - Release Date: 2/25/2008 9:22 AM ___ 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] Monitor disc space on RT/SQL database
I believe that Webmin can do this. http://www.webmin.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Shannon Adams Sent: Monday, February 18, 2008 2:51 PM To: rt-users@lists.bestpractical.com Subject: [rt-users] Monitor disc space on RT/SQL database I need to know how to monitor available space for my RT database. I am very much a novice regarding SQL db administration. Are there any other areas I should keep my eye on to avoid any future RT db problems? I am running RT on a FC4 box and my installation is in /opt/rt3. Thanks for any help. Shannon Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ ___ 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 No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.20.7/1285 - Release Date: 2/18/2008 5:50 AM No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.20.7/1285 - Release Date: 2/18/2008 5:50 AM ___ 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] RT 3.6.0 and MySQL 5
Has anyone upgraded from MySQL 4.0 to 5 running RT 3.6.0 and seen any speed improvements? Thank you, Micah Gersten onShore Networks http://www.onshore.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. 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] RT 3.6.0 and MySQL 5
So, it would be better if I tune 4 than upgrade to 5? I'm not sure my boss is ready to upgrade to 3.6.5 yet as it just came out a month ago. How stable is 3.6.5 compared to 3.6.0? Thank you, Micah Gersten onShore Networks http://www.onshore.com -Original Message- From: Jesse Vincent [mailto:[EMAIL PROTECTED] Sent: Monday, November 19, 2007 9:49 AM To: Micah Gersten Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] RT 3.6.0 and MySQL 5 On Mon, Nov 19, 2007 at 09:43:07AM -0600, Micah Gersten wrote: Has anyone upgraded from MySQL 4.0 to 5 running RT 3.6.0 and seen any speed improvements? You'll get a lot more bang for your buck by upgrading to RT 3.6.5 and/or tuning mysql. If you're going to MySQL 5, be _sure_ to go to 5.0.45. (See posts on rt-devel this weekend for info about the issue mysql fixed in 5.0.45) -j ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. 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] RT 3.6.0 and MySQL 5
Is there a guide for how to tune MySQL for RT? Thank you, Micah Gersten onShore Networks http://www.onshore.com -Original Message- From: Jesse Vincent [mailto:[EMAIL PROTECTED] Sent: Monday, November 19, 2007 10:11 AM To: Micah Gersten Cc: 'Jesse Vincent'; rt-users@lists.bestpractical.com Subject: Re: [rt-users] RT 3.6.0 and MySQL 5 On Mon, Nov 19, 2007 at 09:50:46AM -0600, Micah Gersten wrote: So, it would be better if I tune 4 than upgrade to 5? Generally, I'd recommend tuning what you have, rather than starting over with another unknown quantity. Make sure you're current on 4.x and then make sure you have a configuration that's using your system respurces well. I'm not sure my boss is ready to upgrade to 3.6.5 yet as it just came out a month ago. How stable is 3.6.5 compared to 3.6.0? Well, the 3.6.x series is primarily bugfixes, performance and stability improvements. So, you're running code that's about a year behind on bugfixes, performance and stability improvements. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. 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] RT 3.6.0 and MySQL 5
Were there any DB changes from 3.6.0 to 3.6.5? Is it easy to revert back if there are problems? Thank you, Micah Gersten onShore Networks http://www.onshore.com -Original Message- From: Jesse Vincent [mailto:[EMAIL PROTECTED] Sent: Monday, November 19, 2007 10:11 AM To: Micah Gersten Cc: 'Jesse Vincent'; rt-users@lists.bestpractical.com Subject: Re: [rt-users] RT 3.6.0 and MySQL 5 I'm not sure my boss is ready to upgrade to 3.6.5 yet as it just came out a month ago. How stable is 3.6.5 compared to 3.6.0? Well, the 3.6.x series is primarily bugfixes, performance and stability improvements. So, you're running code that's about a year behind on bugfixes, performance and stability improvements. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. 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] RT 3.6.0 and MySQL 5
Should we upgrade from 4.0.24 to 4.1.11a? We're running debian and these are the packages available. Thank you, Micah Gersten onShore Networks http://www.onshore.com -Original Message- From: Brian Kerr [mailto:[EMAIL PROTECTED] Sent: Monday, November 19, 2007 10:27 AM To: Micah Gersten Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] RT 3.6.0 and MySQL 5 On Nov 19, 2007 10:50 AM, Micah Gersten [EMAIL PROTECTED] wrote: So, it would be better if I tune 4 than upgrade to 5? I'm not sure my boss is ready to upgrade to 3.6.5 yet as it just came out a month ago. How stable is 3.6.5 compared to 3.6.0? If you stick with Mysql4, make sure you use 4.1.18. There are query optimizer changes in versions above it that negatively affect performance. There was a thread open regarding this but I think it died out. -Brian ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. 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] What is searchbuilder
The main problem is searching through the RT interface is slow. The DB lookups seem to be fine. Thank you, Micah Gersten onShore Networks http://www.onshore.com -Original Message- From: Kenneth Crocker [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 30, 2007 2:10 PM To: Micah Gersten Cc: 'Roy El-Hames'; rt-users@lists.bestpractical.com Subject: Re: [rt-users] What is searchbuilder Micah, Actually, there are several ways to speed up searches without trying to fool around with searchbuilder. It works fine for us. If we have a search/query that takes too long, we look at any of the following: 1) Does the SQL create any inefficient joins or links? 2) How is the DB set up? Are there ways to speed up the DB access using different pathways, etc. 3) Does the query look for data in a list/sequential fashion or does it use existing keys/indexes? 4) Does the DB table need additional indexes? Also, depending on the search, if you have too many privileges that are global in nature, that could also increase search time. You just have to evaluate the way you write queries with an experienced eye. Hope this helps. Kenn LBNL On 10/29/2007 9:09 AM, Micah Gersten wrote: I think it's a built in component, but I would like to know if there is a way to tweak it to make searches faster. Thank you, Micah Gersten onShore Networks http://www.onshore.com -Original Message- From: Roy El-Hames [mailto:[EMAIL PROTECTED] Sent: Monday, October 29, 2007 11:07 AM To: Micah Gersten Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] What is searchbuilder Can you use RT without it ??? Roy Micah Gersten wrote: My company is running an RT installation v. 3.6.0. What is searchbuilder? Can we use it to speed up RT searches? Thank you, Micah Gersten onShore Networks ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. 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 SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. 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 SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. 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] What is searchbuilder
I think it's a built in component, but I would like to know if there is a way to tweak it to make searches faster. Thank you, Micah Gersten onShore Networks http://www.onshore.com -Original Message- From: Roy El-Hames [mailto:[EMAIL PROTECTED] Sent: Monday, October 29, 2007 11:07 AM To: Micah Gersten Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] What is searchbuilder Can you use RT without it ??? Roy Micah Gersten wrote: My company is running an RT installation v. 3.6.0. What is searchbuilder? Can we use it to speed up RT searches? Thank you, Micah Gersten onShore Networks ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. 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 SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. 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] What is searchbuilder
My company is running an RT installation v. 3.6.0. What is searchbuilder? Can we use it to speed up RT searches? Thank you, Micah Gersten onShore Networks ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. 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] Speeding up queries
I found that if I index the Subject column in the Tickets table, searches are much faster. Thank you, Micah Gersten onShore Networks www.onshore.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] FW: Trying to create a custom form
I posted this last week, but no one replied. -Original Message- From: Micah Gersten [mailto:[EMAIL PROTECTED] Sent: Thursday, May 10, 2007 1:35 PM To: 'rt-users@lists.bestpractical.com' Subject: Trying to create a custom form I'm trying to create a custom form in RT. The form works, but I cannot figure out how to take the form data and put in into the body of the ticket. How does post processing work with the RT forms? Thank you, Micah Gersten onShore Networks www.onshore.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] Trying to create a custom form
I'm trying to create a custom form in RT. The form works, but I cannot figure out how to take the form data and put in into the body of the ticket. How does post processing work with the RT forms? Thank you, Micah Gersten onShore Networks www.onshore.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