[rt-users] RT couldn't store your session when moving to a new server
I've read many threads on this issue but none of the suggestions have worked for me. I'm trying to move an existing 3.6.5 database to a new server to set up a sandbox for testing the 4.x upgrade. I have 3.6.5 installed and running on the new server with our plugins and customizations. Now I'm trying to move a copy of our data over. We use InnoDB and store sessions in the database (default). I copied over all the .frm files and the InnoDB data/log files and restarted MySQL and Apache. Browsing to the site gives: RT couldn't store your session. This may mean that that the directory '/usr/local/rt3/var/session_data' isn't writable or a database table is missing or corrupt. Trace begun at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Exceptions.pm line 129 HTML::Mason::Exceptions::rethrow_exception('RT couldn\'t store your session.^JThis may mean that that the directory \'/usr/local/rt3/var/session_data\' isn\'t writable or a database table is missing or corrupt.^J^J') called at /usr/local/rt3/share/html/Elements/SetupSessionCookie line 100 HTML::Mason::Commands::__ANON__ at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x8a1f3f4)') called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1302 eval {...} at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1292 HTML::Mason::Request::comp(undef, undef) called at /usr/local/rt3/share/html/autohandler line 120 HTML::Mason::Commands::__ANON__ at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x8a1e68c)') called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1297 eval {...} at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1292 HTML::Mason::Request::comp(undef, undef, undef) called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 481 eval {...} at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 481 eval {...} at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 433 HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0xa314d44)') called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm line 168 HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0xa314d44)') called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm line 825 HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x98a9da4)', 'Apache2::RequestRec=SCALAR(0x9a77ca0)') called at /usr/local/rt3/bin/webmux.pl line 125 eval {...} at /usr/local/rt3/bin/webmux.pl line 125 RT::Mason::handler('Apache2::RequestRec=SCALAR(0x9a77ca0)') called at /usr/lib/perl5/site_perl/5.8.8/Apache/Session/MySQL.pm line 0 eval {...} at /usr/lib/perl5/site_perl/5.8.8/Apache/Session/MySQL.pm line 0 --- Any help or ideas greatly appreciated. Thanks- Lee 2011 Training: http://bestpractical.com/services/training.html
[rt-users] Filter Tickets on LastUpdatedBy InternalUser
I've seen lots of requests for this in the archives but couldn't find an easy solution. I'm looking for the TicketSQL syntax to only show tickets where the LastUpdatedBy is not an RT user; i.e., the ticket has been updated by an external party and therefore needs our attention. Any help or ideas are greatly appreciated. Thanks- Lee
[rt-users] unrecognized time zone name: GMT
Testing RT 3.8.8 with PostgreSQL 9.0.3, seeing these warnings in the Apache error log: [Wed Feb 9 18:46:38 2011] [warning]: DBD::Pg::st execute failed: ERROR: unrecognized time zone name: GMT (/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:509) [Wed Feb 9 18:46:38 2011] [warning]: RT::Handle=HASH(0xb14ed7c) couldn't execute the query 'SET TIME ZONE 'GMT'' at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 522 Looks like these errors occur on every ticket transaction, for example saving a Comment. I confirmed that correct timestamps are getting assigned to ticket transactions. Any ideas are greatly appreciated. Thanks- Lee
Re: [rt-users] unrecognized time zone name: GMT
Great question Kevin, turns out the timezone files were not readable by postgres. This fix worked: chmod o+r /usr/local/pgsql/share/timezone/* Thanks again for your prompt and excellent help. Lee That's unusual. What timezones does your Pg know about? http://www.postgresql.org/docs/9.0/static/view-pg-timezone-names.html -kevin
[rt-users] Secure RSS Feeds?
I'm testing the RSS feeds feature in RT and noticed that I can update the feed results in my RSS reader without logging into RT. I'm guessing this is related to the NoAuth that is embedded in the feed location URL. Is there a way to secure all RT RSS feeds so that the user is prompted for their credentials the first time they update the feed during a browser/reader session? Thanks- Lee
Re: [rt-users] RTx::Calendar Not Displaying
Good point Shawn: there is a Calendar link at the top of the Search Results page, along with Edit Search, Graph, etc, and it shows the filtered results in a Calendar format. Interestingly though, sometimes it shows the task details in a hover-over box, other times it embeds the details right in the calendar. Refreshing the page a couple of times brings the hover-over back. The Calendar link itself doesn't always appear either and I have to refresh a time or two to see it. Any ideas what would cause that? Thanks much- Lee MyCalendar is included in $HomepageComponents (below) but nothing related to Calendar appears on the homepage. In fact, if I comment out the $HomepageComponents line completely and restart the web server, the homepage still looks the same, even if I clear my browser cache. How could that be? Just adding it to HomepageComponents doesn't make it show up on your homepage, it makes it available. You need to click on Preferences - RT at a Glance -kevin I have the ExternalAuth plugin configured in the same RT_SiteConfig.pm file (below) and it is working fine. Search on Calendar and calendar shows no results. Also note that this is searching for tickets that are *about* calendars. You should see a link to the calendar from the tickets search results page alongside other display formats like spreadsheet and chart. Shawn
Re: [rt-users] RTx::Calendar Not Displaying
Enabling MyCalendar under Preferences RT at a Glance, and fixing missing file/directory permissions for the plugin, did the trick. Calendar now displays on RT at a Glance (Home) and Edit Query Advanced Calendar. Thanks very much for everyone's help. Lee MyCalendar is included in $HomepageComponents (below) but nothing related to Calendar appears on the homepage. In fact, if I comment out the $HomepageComponents line completely and restart the web server, the homepage still looks the same, even if I clear my browser cache. How could that be? Just adding it to HomepageComponents doesn't make it show up on your homepage, it makes it available. You need to click on Preferences - RT at a Glance -kevin I have the ExternalAuth plugin configured in the same RT_SiteConfig.pm file (below) and it is working fine. Search on Calendar and calendar shows no results. Are there any screenshots of what the Calendar links/pages should look like? Is it possible to insert debug statements somewhere to verify that the Calendar plugin is actually getting called? Thanks very much for the help. Lee Date: Tue, 4 Jan 2011 17:18:23 -0500 From: Kevin Falcone falc...@bestpractical.com To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] RTx::Calendar Not Displaying Message-ID: 20110104221823.gv65...@jibsheet.com Content-Type: text/plain; charset=us-ascii On Tue, Jan 04, 2011 at 12:44:51PM -0800, Lee Hughes wrote: I cleared the Mason cache but still don't see any Calendar links. Where should I see links, and how would I go about enabling basic tracing to see if the Calendar module is even being called? You didn't say where you looked for the calendars. Did you try editing your homepage to include the MyCalendar widget? Did you do a search and look for the calendar link? -kevin I've installed and configured RTx::Calendar per the instructions and restarted the web server but don't see any links to it anywhere. I have syslogging set to debug but no errors are logged. Here are the relevant settings from RT_SiteConfig.pm: # Calendar Plugin require '/usr/local/rt3/local/plugins/RTx-Calendar/lib/RTx/Calendar.pm'; Set($HomepageComponents, [qw(QuickCreate Quicksearch MyCalendar MyAdminQueues MySupportQueues MyReminders RefreshHomepage)]); # enable all plugins Set(@Plugins,qw( RT::Authen::ExternalAuth RTx::Calendar )); Any ideas what I'm missing? Did you clear the Mason cache? rm -rf /usr/local/rt3/var/mason_data/obj/* See http://requesttracker.wikia.com/wiki/CleanMasonCache for details.
Re: [rt-users] RTx::Calendar Not Displaying
MyCalendar is included in $HomepageComponents (below) but nothing related to Calendar appears on the homepage. In fact, if I comment out the $HomepageComponents line completely and restart the web server, the homepage still looks the same, even if I clear my browser cache. How could that be? I have the ExternalAuth plugin configured in the same RT_SiteConfig.pm file (below) and it is working fine. Search on Calendar and calendar shows no results. Are there any screenshots of what the Calendar links/pages should look like? Is it possible to insert debug statements somewhere to verify that the Calendar plugin is actually getting called? Thanks very much for the help. Lee Date: Tue, 4 Jan 2011 17:18:23 -0500 From: Kevin Falcone falc...@bestpractical.com To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] RTx::Calendar Not Displaying Message-ID: 20110104221823.gv65...@jibsheet.com Content-Type: text/plain; charset=us-ascii On Tue, Jan 04, 2011 at 12:44:51PM -0800, Lee Hughes wrote: I cleared the Mason cache but still don't see any Calendar links. Where should I see links, and how would I go about enabling basic tracing to see if the Calendar module is even being called? You didn't say where you looked for the calendars. Did you try editing your homepage to include the MyCalendar widget? Did you do a search and look for the calendar link? -kevin I've installed and configured RTx::Calendar per the instructions and restarted the web server but don't see any links to it anywhere. I have syslogging set to debug but no errors are logged. Here are the relevant settings from RT_SiteConfig.pm: # Calendar Plugin require '/usr/local/rt3/local/plugins/RTx-Calendar/lib/RTx/Calendar.pm'; Set($HomepageComponents, [qw(QuickCreate Quicksearch MyCalendar MyAdminQueues MySupportQueues MyReminders RefreshHomepage)]); # enable all plugins Set(@Plugins,qw( RT::Authen::ExternalAuth RTx::Calendar )); Any ideas what I'm missing? Did you clear the Mason cache? rm -rf /usr/local/rt3/var/mason_data/obj/* See http://requesttracker.wikia.com/wiki/CleanMasonCache for details.
Re: [rt-users] RTx::Calendar Not Displaying
I cleared the Mason cache but still don't see any Calendar links. Where should I see links, and how would I go about enabling basic tracing to see if the Calendar module is even being called? BTW this is with RT 3.8.8 on PostgreSQL 9. Thanks much for the help. Lee I've installed and configured RTx::Calendar per the instructions and restarted the web server but don't see any links to it anywhere. I have syslogging set to debug but no errors are logged. Here are the relevant settings from RT_SiteConfig.pm: # Calendar Plugin require '/usr/local/rt3/local/plugins/RTx-Calendar/lib/RTx/Calendar.pm'; Set($HomepageComponents, [qw(QuickCreate Quicksearch MyCalendar MyAdminQueues MySupportQueues MyReminders RefreshHomepage)]); # enable all plugins Set(@Plugins,qw( RT::Authen::ExternalAuth RTx::Calendar )); Any ideas what I'm missing? Did you clear the Mason cache? rm -rf /usr/local/rt3/var/mason_data/obj/* See http://requesttracker.wikia.com/wiki/CleanMasonCache for details.
[rt-users] RT::Authen::ExternalAuth - LDAP Accounts Not Shown in Users List
I have the latest RT::Authen::ExternalAuth installed and working with RT 3.8.8. I can log in as a user in our LDAP directory, and a corresponding record is created in the users table in the rt3 database (Postgres 9). But when I log in as root and try to add that user to a new group, it lists only Enoch Root in the Users list under Add Members. Not sure if it's relevant but when I log in with the LDAP account I see this error in syslog: RT: DBD::Pg::db selectall_hashref failed: ERROR: column disabled does not exist at character 13 (/usr/local/rt3/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/DBI.pm:279) Appreciate any help. Thanks- Lee
Re: [rt-users] RT::Authen::ExternalAuth - LDAP Accounts Not Shown in Users List
I have the latest RT::Authen::ExternalAuth installed and working with RT 3.8.8. I can log in as a user in our LDAP directory, and a corresponding record is created in the users table in the rt3 database (Postgres 9). But when I log in as root and try to add that user to a new group, it lists only Enoch Root in the Users list under Add Members. Those users are unprivileged by default, search for them Not sure if it's relevant but when I log in with the LDAP account I see this error in syslog: RT: DBD::Pg::db selectall_hashref failed: ERROR: column disabled does not exist at character 13 (/usr/local/rt3/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/DBI.pm:279) sounds like you left the default dbi example config in place, rather than only enabling the ldap config. -kevin Kevin- Great suggestions. I incorrectly assumed I needed to keep dbi in place for root login, but I disabled dbi and I can still log in as root. I found the LDAP accounts under Configuration Users Find, checked Let this user be granted rights, and I'm now able to add them to the Group. Thanks alot for your help, it is greatly appreciated. Lee
[rt-users] RTx::Calendar Not Displaying
I've installed and configured RTx::Calendar per the instructions and restarted the web server but don't see any links to it anywhere. I have syslogging set to debug but no errors are logged. Here are the relevant settings from RT_SiteConfig.pm: # Calendar Plugin require '/usr/local/rt3/local/plugins/RTx-Calendar/lib/RTx/Calendar.pm'; Set($HomepageComponents, [qw(QuickCreate Quicksearch MyCalendar MyAdminQueues MySupportQueues MyReminders RefreshHomepage)]); # enable all plugins Set(@Plugins,qw( RT::Authen::ExternalAuth RTx::Calendar )); Any ideas what I'm missing? Thanks much- Lee
Re: [rt-users] Can't locate Apache/Session/Postgres.pm in @INC
Fresh install of RT 3.8.8 with mod_perl2 and Postgres 9 on CentOS 5.5. Browsing to site gives: Can't locate Apache/Session/Postgres.pm in @INC (@INC contains: /usr/local/rt3/bin/../local/lib /usr/local/rt3/bin/../lib /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.8/i386-linux-thread-multi /usr/lib/perl5/5.8.8 . /etc/httpd) at (eval 3351) line 3. I verified that Apache/Session/Postgres.pm is in /usr/lib/perl5/site_perl/5.8.8 and is readable by all. How did you check that, with ls -l or by su'ing to the web user and seeing if you can read it? -kevin Great question, that was the problem: the Apache directory under site_perl/5.8.8 was root readable only. Thanks alot for your help Kevin, I'm up and running now. Lee
[rt-users] Troubleshooting RT::Authen::ExternalAuth
I've installed and configured RT::Authen::ExternalAuth for LDAP support but it does not appear to be querying our LDAP server. I tried setting LogToSyslog to 'debug' in RT_SiteConfig.pm but I'm not seeing anything related to ExternalAuth in the log. Any ideas on how to start troubleshooting? Thanks- Lee
[rt-users] Can't locate Apache/Session/Postgres.pm in @INC
Fresh install of RT 3.8.8 with mod_perl2 and Postgres 9 on CentOS 5.5. Browsing to site gives: Can't locate Apache/Session/Postgres.pm in @INC (@INC contains: /usr/local/rt3/bin/../local/lib /usr/local/rt3/bin/../lib /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.8/i386-linux-thread-multi /usr/lib/perl5/5.8.8 . /etc/httpd) at (eval 3351) line 3. I verified that Apache/Session/Postgres.pm is in /usr/lib/perl5/site_perl/5.8.8 and is readable by all. Any help greatly appreciated. Lee