Re: [rt-users] Issue with RT 3.8.1 and Active Directory authentication
On Mon, Dec 8, 2008 at 10:44 AM, Elton S. Fenner [EMAIL PROTECTED]wrote: I can login but get this message in browser: *Can't call method as_string on an undefined value at /opt/rt3/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/LDAP.pm line 97, line 514. * This looks like it's the section of code checking the group. *'group' = 'DSI_Rede_Usu', 'group_attr'= '',* Have you tried with these two lines commented out? I would think group_attr must be set. I believe 'uniqueMember' is what openldap uses, and active directory uses 'member'. I also think group would be a full DN, but the code may search. I've never used these before myself. 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
Re: [rt-users] rt 3.8.1: Font and spacing issues in ticket history section issue
On Mon, Dec 8, 2008 at 12:00 PM, Janet Houser [EMAIL PROTECTED]wrote: When my users add comments while logged into rt (3.8.1), the font is very large and the lines are double spaced. When you reply to rt tickets via a mailer, this doesn't happen. Have you tried turning off the WYSIWYG editor under Preferences? If this fixes your problem I would try setting: Set($MessageBoxRichText, 0); ___ 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] long page load times with many comments, was: is SELECT GET_LOCK normal?
On Thu, Dec 4, 2008 at 6:06 PM, Ruslan Zakirov [EMAIL PROTECTED] wrote: Could you check if ShowMessageStanza from 3.8 repository [1] improves situation? See also comments below. [1] http://svn.bestpractical.com/cgi-bin/index.cgi/bps/view/rt/3.8/trunk/share/html/Ticket/Elements/ShowMessageStanza Installed this and restarted. Didn't change the time to load. Pretty stable at just under 90 seconds for this ticket. Start from identifying where RT spends more time during the request. Turned on 'debug' logging to a file. When loading this ticket I see many lines like this: [Mon Dec 8 23:37:12 2008] [debug]: We found a merged ticket.1721/1698 (/opt/rt3/bin/../lib/RT/Ticket_Overlay.pm:185) After the first line, it will pause for one second, then print three more of the exact messages at the same time with the same timestamp as the first. Four messages every second for the 90 seconds it took for the ticket to load. After seeing this I opened up a few dozen tickets and watched the debugging log. Every ticket without merges took under two seconds, most of them a fraction of a second (short ones). Tickets with merges took 50-110 seconds. Definitely looks like some sort of recursive loop to do with parsing ticket merges. 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
Re: [rt-users] long page load times with many comments, was: is SELECT GET_LOCK normal?
On Mon, Dec 8, 2008 at 5:14 PM, Ruslan Zakirov [EMAIL PROTECTED] wrote: http://rt3.fsck.com//Ticket/Display.html?id=12774 Note that to read that, login as guest/guest. That's it, thanks. Added this to RT_SiteConfig.pm. Set($LogToSyslog, 'info'); Also linked in that bug is a debian bug [1]. They also discuss that installing the debian package 'libsys-syslog-perl' should resolve this issue. Maybe RT_Config.pm should ship with LogToSyslog set to info as a general measure rather than related to this bug? Bryan [1] http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=498692 ___ 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] is SELECT GET_LOCK normal?
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
[rt-users] long page load times with many comments, was: is SELECT GET_LOCK normal?
On Thu, Dec 4, 2008 at 5:07 PM, Micah Gersten [EMAIL PROTECTED] wrote: 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. Thanks, yes. Although, that seems like a hack of some kind. The select lock's go away when I changed 3006 to 1 in [1] but the page still takes almost 90 seconds to load. Switching from mod_perl to fastcgi didn't affect the load time, nor did switching mysql from the default my.cnf to huge.cnf. I'm using the default mpm-prefork settings but increasing them doesn't appear to decrease the load time. I feel like something in the process isn't threading enough and causing a bottleneck but I'm unsure as to what's left. Will keep digging. Bryan [1] /usr/share/perl5/Apache/Session/Lock/MySQL.pm ___ 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 3.8.1 Logged out on Search
On Fri, Nov 7, 2008 at 4:03 AM, JOHN ROMAN [EMAIL PROTECTED] wrote: this should be an easy fix that has to do with differences in the RT database you migrated from versus the one you use in 3.8.1. you'll need to follow these steps 1. export the database from your old RT 2. update the schema using the information contained in the UPGRADING.mysql file 3. update the RT databases using the normal scripts contained in README I ran [1] per the README during the upgrade, it all went slick. The original install of this RT instance was on Debian etch, so it's always been in mysql = 5 so UPGRADING.mysql doesn't apply. Per Mike Peachy's recent post [2] about not running RT-Authen-ExternalAuth-0.06x, I just got the latest version of 0.07_01 from CPAN here [3], as it wasn't listed in the available versions for download, nor was it on CPAN when I installed on Wednesday. Installing this did not correct the logged out on searches problem however. Bryan [1] /opt/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-password --action upgrade [2] http://www.gossamer-threads.com/lists/rt/users/80097 [3] http://mirrors.gossamer-threads.com/CPAN/authors/id/Z/ZO/ZORDRAK/RT-Authen-ExternalAuth-0.07_01.tar.gz ___ 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] [SOLVED] Re: RT 3.8.1 Logged out on Search
On Fri, Nov 7, 2008 at 9:55 AM, John [EMAIL PROTECTED] wrote: what version are you migrating from? im certain UPGRADING.mysql applies... it says at line 13/14: If you're upgrading RT from versions prior to 3.8.0 then you MUST follow instructions below. Thanks John, I missed that RT wasn't using the collation when it originally created the database, despite the database version. Updating the database collation and restarting apache appears to have corrected the problem while searching. Since my mysql server was on another host, I copied schema.mysql-4.0-4.1.pl to that host and ran: perl schema.mysql-4.0-4.1.pl rtdb root sql.rtdb mysql -u root rtdb sql.rtdb ___ 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.8.1 Logged out on Search
I recently upgraded to RT 3.8.1, RT-Authen-ExternalAuth-0.06_03 and RT-Extension-CommandByMail-0.06 from source. I was running RT 3.6.7, installed over the top of the RT 3.6.5 debian package. Everything looks pretty good, although I think I see that odd performance problem with firefox on linux sometimes. Generally when I search I get logged out, and see this error: [Fri Nov 7 02:42:54 2008] [error]: Couldn't get principal for not loaded object (/opt/rt3/bin/../lib/RT/User_Overlay.pm:1113) [Fri Nov 7 02:42:54 2008] [error]: Group::HasMember was called with an argument that isn't an RT::Principal or id. It's (undefined) (/opt/rt3/bin/../lib/RT/Group_Overlay.pm:1031) When I log back in, I get the expected search results page. I'm able to log in, manipulate tickets just fine. I just get logged out on the search. Ideas? I'll look at the source tomorrow I think. Bryan McLellan ___ 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
