[rt-users] Slow performance - 4.0.4 with PostgreSQL installed from Ubuntu 12.04 packages

2012-05-28 Thread David X. Glover
to start diagnosing what's eating up the most time? -- David X. Glover IT Support, Physics University of Oxford

Re: [rt-users] Slow performance - 4.0.4 with PostgreSQL installed from Ubuntu 12.04 packages

2012-05-28 Thread David X. Glover
On 28 May 2012, at 16:05, Ruslan Zakirov wrote: Start from logs: SQL log and RT log. Timestamps in RT logs on debug level can give you idea. Good tip. I've pinned down the problem to being only when mail is sent, which would imply exim is somehow being slow... -- David X. Glover IT Support

[rt-users] Comments about this user

2010-06-01 Thread David X. Glover
Is it possible to allow staff to edit the Comments about this user field on regular users without the staff being admins? We're using RT 3.6.5 but will be upgrading in a few months. Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at

[rt-users] More about box loads very slowly

2010-03-08 Thread David X. Glover
? Cheers. *Yes, we acknowledge that it's out of date and we do have plans to upgrade, just not immediately. -- David X. Glover Department of Physics University of Oxford http://www.physics.ox.ac.uk/ ___ http://lists.bestpractical.com/cgi-bin/mailman

Re: [rt-users] More about box loads very slowly

2010-03-08 Thread David X. Glover
On 8 Mar 2010, at 10:29, David X. Glover wrote: We're running RT 3.6.5* on MySQL 5.0.51a, and the More about User box on the ticket display page takes several seconds to load. I've seen other people with this problem on the list, but never a solution. Does anyone have any ideas about

[rt-users] rtUnifiedreminder on 3.6

2009-12-04 Thread David X . Glover
Has anyone attempted to get this script: http://wiki.bestpractical.com/view/rtUnifiedreminder Working on RT 3.6? It fails because it can't find the Config Class Method, and I'm wondering whether to bother trying to hack it to make it work, or whether I should give up now. -- David X. Glover

Re: [rt-users] Migrating from SQLite to MySQL

2009-11-27 Thread David X. Glover
On 26 Nov 2009, at 15:38, David X. Glover wrote: In the end, that's what we did. One (hopefully minor) problem left over. When attempting to create a new ticket in the migrated database, I'm getting the SQL error Duplicate entry '0' for key 1 when trying to create the new record

Re: [rt-users] Migrating from SQLite to MySQL

2009-11-27 Thread David X. Glover
On 27 Nov 2009, at 10:32, David X. Glover wrote: One (hopefully minor) problem left over. When attempting to create a new ticket in the migrated database, I'm getting the SQL error Duplicate entry '0' for key 1 when trying to create the new record in the Tickets table. Apologies for solving

[rt-users] Migrating from SQLite to MySQL

2009-11-26 Thread David X. Glover
Hello, We've been running a test RT server using SQLite, and we'd now like to migrate the data in it to MySQL, in order to move the system to a production environment. I dumped the contents of the SQLite database into a file using .dump, but I'm having problems importing it into MySQL.

Re: [rt-users] Migrating from SQLite to MySQL

2009-11-26 Thread David X. Glover
On 26 Nov 2009, at 11:22, Dominic Hargreaves wrote: or just write a little filter to tweak things yourself (eg you could start by removing the BEGIN TRANSACTION and corresponding COMMIT.. lines from the dump), then see what else breaks. In the end, that's what we did. So, for anyone else who