Re: [rt-users] Performance on PostgreSQL
On Oct 15, 2006, at 8:23 PM, Joby Walker wrote: As was pointed out to me the current value function returns the last value used for that connection, so from the pgsql side it is multithread safe -- but I don't know how using a connection pooling system like SQLRelay impacts things (because we might use a sqlrelay in the future is one of the reasons I modified our instance of SB). Well, you're not gonna multiplex the connection during the same transaction, so it will be safe to call the last_insert_id() method from DBD::Pg to query the sequence number of the last insert. smime.p7s Description: S/MIME cryptographic signature ___ 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] Problems with Searching
Hi, I want to specify the following search via the SearchBuilder: ( Status = 'new' OR Status = 'open' OR Status = 'stalled' ) AND ( Queue = 'Project1' OR ( Queue = 'General' AND 'CF.{Project}' LIKE 'Project1' ) ) After executing the search, there were no tickets found an when I go back to edit the search, I see that the OR between the queues is replaced by AND: ( Status = 'new' OR Status = 'open' OR Status = 'stalled' ) AND ( Queue = 'Project1' AND ( Queue = 'General' AND 'CF.{Project}' LIKE 'Project1' ) ) Is there any other way to create the above statement? I am using rt 3.6.1. Thanks, Joerg ___ 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] (no subject)
Hi, We're in the process of upgrading from rt-3.2.2 to rt-3.6.1. We were using the messageid patch from: http://lists.fsck.com/pipermail/rt-devel/2004-September/006279.html which meant that even if an email reply did not include the ticket reference it still ended up being appended to the correct ticket history. RT seems to have moved on to the point that applying this patch to rt-3.6.1 fails. Trying to hack things by hand didn't work for me either. Is anyone else doing anything like this at all? Many thanks, Steve. -- Stephen Ison Unix Support University of Cambridge Computing Service [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
[rt-users] DueDateinBusinessHours
Greetings - Turned out I installed this one incorrectly, and it hasn't been updating the Due data in the Tickets. Without having to do each Ticket by hand, is there a way to apply this script to all previous tickets still open? Thanks folks, Jud. ___ 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] Ludicrously slow queries on custom fields
On Mon, Oct 16, 2006 at 07:06:58PM +0100, Tony Bowden wrote: After investigating a set of particularly problematic queries that were each taking 40 minutes(!) to run we noticed a very peculiar clause in the query, which basically boils down to a select on Tickets LEFT JOIN TicketCustomFieldValues ON TicketCustomFieldValues.CustomField = '1' OR TicketCustomFieldValues.Ticket = Tickets.id Unless I'm missing something important about how this should work, this should surely be an AND, not an OR. And, indeed, replacing the OR with an AND and running the query by hand gets back the correct results in a fraction of a second. That sure doesn't look right, but 3.2.2 was a _long_ time ago. 3.4 entirely reimplemented the custom fields searching, and 3.6 further improved queries on customfields. This appears to have happened after we upgraded mysql. From what to what? We've seen pathalogically bad query optimization on 5.0. But still, that query above just doesn't look right. -j ___ 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] pages hanging
Ubuntu also puts some of the httpd.conf file into a sites-available directory and file named ssl. Here's that file in case it helps. NameVirtualHost *:443 VirtualHost *:443 ServerAdmin [EMAIL PROTECTED] SSLEngine On SSLCertificateFile /etc/apache2/ssl/apache.pem DocumentRoot /var/www Directory / Options FollowSymLinks AllowOverride None /Directory Directory /var/www/ Options Indexes FollowSymLinks MultiViews AllowOverride None Order allow,deny allow from all # Uncomment this directive is you want to see apache2's # default start page (in /apache2-default) when you go to / #RedirectMatch ^/$ /apache2-default/ /Directory ScriptAlias /cgi-bin/ /usr/lib/cgi-bin/ Directory /usr/lib/cgi-bin AllowOverride None Options +ExecCGI -MultiViews +SymLinksIfOwnerMatch Order allow,deny Allow from all /Directory ErrorLog /var/log/apache2/error.log # Possible values include: debug, info, notice, warn, error, crit, # alert, emerg. LogLevel warn CustomLog /var/log/apache2/access.log combined ServerSignature On Alias /doc/ /usr/share/doc/ Directory /usr/share/doc/ Options Indexes MultiViews FollowSymLinks AllowOverride None Order deny,allow Deny from all Allow from 127.0.0.0/255.0.0.0 ::1/128 /Directory Include /etc/request-tracker3.4/apache2-modperl2.conf /VirtualHost Thanks, John ___ 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] Ludicrously slow queries on custom fields
On Mon, Oct 16, 2006 at 02:40:49PM -0400, Jesse Vincent wrote: Tickets LEFT JOIN TicketCustomFieldValues ON TicketCustomFieldValues.CustomField = '1' OR TicketCustomFieldValues.Ticket = Tickets.id That sure doesn't look right, but 3.2.2 was a _long_ time ago. 3.4 entirely reimplemented the custom fields searching, and 3.6 further improved queries on customfields. Yeah - upgrading has been on the todo list for quite a while, but we're not sure how easy it'll be so it keeps getting put off. This appears to have happened after we upgraded mysql. From what to what? We've seen pathalogically bad query optimization on 5.0. But still, that query above just doesn't look right. Not sure what we were at, but we're now on 5.0.24 In further investigation we found a line in the DBIx::SearchBuilder Changes file from earlier this year that says: * Allow ORs on left joins It's conceivable that that was upgraded with mysql - is it possible that this change might have made the old 3.2.2 query work differently? Tony ___ 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] went from mysql 4.1 to 5.0
*1666:* $dbh-STORE('AutoCommit', 0); # will croak if driver doesn't support it did a full dump prior to upgrading mysql, and no errors showed during import, can browse all tickets, cant create/resolve etc. am assuming that i need to update DBI ? ___ 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] went from mysql 4.1 to 5.0
I think you have to rebuild the DBI and DBD::mysql perl modules. On 10/17/06, Chaim Rieger [EMAIL PROTECTED] wrote: *1666:* $dbh-STORE('AutoCommit', 0); # will croak if driver doesn't support it did a full dump prior to upgrading mysql, and no errors showed during import, can browse all tickets, cant create/resolve etc. am assuming that i need to update DBI ? ___ 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
Re: [rt-users] (no subject)
Interesting patch. May be the author has an update. Peter? On 10/16/06, Steve Ison [EMAIL PROTECTED] wrote: Hi, We're in the process of upgrading from rt-3.2.2 to rt-3.6.1. We were using the messageid patch from: http://lists.fsck.com/pipermail/rt-devel/2004-September/006279.html which meant that even if an email reply did not include the ticket reference it still ended up being appended to the correct ticket history. RT seems to have moved on to the point that applying this patch to rt-3.6.1 fails. Trying to hack things by hand didn't work for me either. Is anyone else doing anything like this at all? Many thanks, Steve. -- Stephen Ison Unix Support University of Cambridge Computing Service [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 -- 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] Disable auto-create users when added as watchers?
I'd like to disable the auto-creation of users when added as watchers (so it gives an error if the user/email added doesn't exist in RT) - is this possible? PK -- Philip Kime NOPS Systems Architect 310 401 0407 ___ 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