Re: [rt-users] Issues on RT 3.8.1
rmp dmd wrote: Hi, Im getting errors when I run 'install DBD::mysql'. Is there a way to put password when runinng 'install DBD::mysql'. Basically put this mysql -uroot -p t/10connect.skipped all skipped: ERROR: Access denied for user 'root'@'localhost' mailto:'root'@'localhost' (using password: NO) Can't continue test t/20createdrop..skipped all skipped: ERROR: Access denied for user 'root'@'localhost' mailto:'root'@'localhost' (using password: NO). Can't continue test Thanks! Make some changes in your Makefile. Look into the Makefile.PL and find --testuser, you'll see the other options. Go to your cpan directory (typically ~/.cpan/build/DBD-mysql-version etc./ and run: perl Makefile.PL --testuser=username --testpassword=pwd then try to install it again. David ___ 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] Issues on RT 3.8.1
Upgrade your DBD::mysql module. The easiest way is using CPAN shell, so type this command: /usr/bin/perl -MCPAN -e shell and when in shell, type: upgrade DBD::mysql Regards Davdi rmp dmd wrote: Thank you very for the help Ruslan. I'm running perl etc/upgrade/schema.mysql-4.0-4.1.pl http://schema.mysql-4.0-4.1.pl rt3 user password sql.queries I'm getting DBD::mysql version 4.002 required--this is only version 3.0002 at etc/upgrade/schema.mysql-4.0-4.1.pl http://schema.mysql-4.0-4.1.pl line 7. BEGIN failed--compilation aborted at etc/upgrade/schema.mysql-4.0-4.1.pl http://schema.mysql-4.0-4.1.pl line 7. I googled the error but there's no information available on this. Thanks again! Roehl On Wed, Aug 27, 2008 at 11:48 AM, Ruslan Zakirov [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: `a_session` column is longtext what is WRONG and means that you HAVN'T upgraded correctly. Read UPGRADING.mysql, this column must be LONGBLOB. On Wed, Aug 27, 2008 at 7:16 PM, rmp dmd [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Thanks for the reply Ruslan. I'm not that familiar with mysql but when I run SHOW CREATE TABLE sessions; I have this output which I believe does not indicate any corruption. How do I know if there is corruption RT3.8.1 is working fine only this weird occurence of asking to log-again after clicking items as indicated on the previous message. Has anyone encounter this? -Roehl --+ | Table| Create Table | +--+--+ | sessions | CREATE TABLE `sessions` ( `id` varchar(32) NOT NULL default '', `a_session` longtext, `LastUpdated` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 | +--+--+ 1 row in set (0.00 sec) On Tue, Aug 26, 2008 at 5:07 PM, Ruslan Zakirov [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: On Tue, Aug 26, 2008 at 7:15 PM, rmp dmd [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Hi, First, I'd like to say great job on putting up an excellent documentation that is easy to follow for upgrading 3.8.1. http://3.8.1./ I'm newbie RT user/admin but was able to do the updagrade easily. I just have few minor issues on 3.8.1. http://3.8.1./ - On RT at Glance the link for Bookmarked Tickets, 10 highest priority tickets I own, 10 newest unowned tickets are pointing for http://localhost/rt/Search/Results.html?format... How can change this link to http://mydomain.com/rt/Search/Results.html?format... ? WebDomain option? - While I'm exploring the new interface 3.8.1, I stumble in this weird scenario which I'm not sure if it's normal or bug. when I click Home-Tickets-configuration, it will be on site http://mydomain.com/rt/Admin/index.html but it will ask me to log again. same thing when I click Home-simpleSearch-tickets-Tools, it will on site http://mydomain.com/rt/Tools/index.html but it will ask me to log again. I'm not sure what else is in ther but this may be nuisance. Any ideas? WebDomain or session corruption because of incorrect upgrade. SHOW CREATE TABLE sessions; Thanks! Roehl ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com http://wiki.bestpractical.com/ Commercial support: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com http://rtbook.bestpractical.com/ -- Best regards, Ruslan. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community
Re: [rt-users] Issues on RT 3.8.1
rmp dmd wrote: Thanks for the help David. Apologies for my simple questions as I do not have any knowledge on CPAN. I run below but upgrade is not an available command on CPAN shell. Error: Unknown command 'upgrade'. Type ? for help. What do I need to run to upgrade? It seems you have older version of CPAN, never mind. Try 'install DB::mysql' instead of 'upgrade DB::mysql', it should recognize newer version available and install (upgrade) it. David ___ 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] 3.8.1 issues, not displaying page
andrew fay wrote: Hi, got rt 3.8.1 up and running with an upgraded DB that i restored and upgraded from 3.6.4 when i click through the links i can only get a couple of links through before they all start displaying blank pages, Any ideas on this? it happens if i view RT from the localhost or any other machine, Thanks, Andy Hi Andy, if you're using MySQL, then modify your RT database like this: mysql ALTER TABLE sessions CHANGE a_session a_session LONGBLOB; David ___ 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] monitoring RT
Nicholas Clark wrote: Nicholas Clark wrote: We're going to make the RT self-service interface visible to our external clients. We'd like to monitor it, so that we know if it's down? What's the best way to monitor RT? Are there any built in pages that would let us quickly tell that (say) 1: users can log in 2: the RT web application has a live connection to a working database without burning lots of CPU? Have I missed anything key to check? On Mon, Jul 23, 2007 at 10:15:35AM -0400, Drew Barnes wrote: Nagios (or something similar) monitoring each of the services seems the easiest way to me. And if RT goes down, just have Nagios send an alert into RT andoh, wait... Yes, but this doesn't catch the case where the web server is working, the database is working, but the mod_perl has got itself into a state where the database handle is invalid and spewing errors, but DBI still thinks that it's connected. I was already assuming that the low level services could be monitored easily. Nicholas Clark Hi Nicholas, Nagios seems to me to be good enough for that. For example check_http plugin with sensible options combination will make Nagios to log in - when it fails, you'll know that something went terrible wrong and users can't log in. Is that what you want? David Svejda ___ 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] Grant ModifyTicket but not allow to send Reply
Hi, as far as I understand, acl rule ModifyTicket somehow includes the ReplyToTicket permission. Is there any possibility to grant users or groups to ModifyTicket (so they can move tickets from Queue to Queue or change the Status etc.) but still to prevent them from posting a Reply (ReplyToTicket)? I want to grant ReplyToTicket only to selected users/groups. I was trying but haven't found any suitable ACL rules combination. Is it in principle possible or it will require some core programming? I'm using RT 3.6.4 with RTFM 2.2.0RC5 Thank you for any advice or pointing me to the right direction. David ___ 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