Re: [rt-users] Problems with an SLA Scrip I created
Dnia 2012-01-11, śro o godzinie 17:50 -0500, David Hollinger pisze: (cut) my $ticketPriority = $self-TicketObj-Priority; if($ticketPriority == 0) { my $SLA = '24'; } elsif($ticketPriority == 25) { my $SLA = '8'; } elsif($ticketPriority == 50) { my $SLA = '4'; } elsif($ticketPriority == 75) { my $SLA = '1'; } else { my $SLA = 'Critical'; } my keyword defines variable in the smallest posibble lexical context - in this case your SLA variable is visible only in the if/elsif/else blocks, not beyond them. Regards, -- Robert Wysocki administrator systemów linuksowych CONTIUM S.A., http://www.contium.pl RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] No Delete option on 3.8.8
I've installed RT-Extension-QuickDelete, added it to RT_SiteConfig.pm and restarted Apache, but it doesn't appear. Do I need to do anything else? If not, where's it hiding :) Kevin Falcone-2 wrote: You appear to want to RT-Extension-QuickDelete extension. I assume you had it installed in 3.8.4 and lost it in the upgrade. -kevin RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 -- View this message in context: http://old.nabble.com/No-Delete-option-on-3.8.8-tp33107653p33127240.html Sent from the Request Tracker - User mailing list archive at Nabble.com. RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] RT 3.8.11 and AT 2.0.0b upgrade or uninstall and install fresh
First, there is an at-users group available at Google Group, link below. It's doesn't see as much traffic as the RT list but it's another resource. http://groups.google.com/group/at-users mailto:at-us...@googlegroups.com On 01/11/2012 05:21 PM, Susan McClure wrote: I have a similar question as Kevin Squire on 12/08/2011 till today. I tried to install AT 1.2.4b1 on my old system without much success, but now I have some AT tables, groups etc in my DB (Postgresql) I am trying to install AT 2.0.0b from github onto RT 3.8.11 upgraded system. I do not have any AT files/scrips in the RT installation. If I try to do a make initdb it fails with the same error: Now populating database schema. DBD::Pg::st execute failed: ERROR: relation at_types already exists ...returned with error: 65280 make: *** [initdb] Error 255 I got a similar error when trying to initialize Rt+AT with Postgres. To work around this I needed to remove AT from RT_SiteConfig.pm, uninstalled AT, init RT under Pg, install AT and init the AT tables, which I did with the below commands. After this I did a mysql to postgres migration but I wouldn't think that should matter as my Pg instance was new. I'm using an RPM package for AT, perl-RTx-AssetTracker, so install/removal is a trivial matter. I can't comment on removing AT if installed from source but you might want to check if there's an 'make uninstall'. For those who are daring you could probably do find /path/to/rt -name \*AssetTracker\* to find all the AT files and then remove manually. If I try to do a make dropdb to drop the old tables etc, it does not give any error, or any output, but neither does it drop any AT tables (like at_assets, at_types, at_ips, at_ports). I tried a make realclean and then tried to install again WITHOUT doing an initdb. I ran the upgrade : /usr/site/rt/sbin/rt-setup-database --dba postgres --prompt-for-dba-password --action schema --datadir etc/upgrade/1.2.4 and yes, there is NO schema.Pg file (only mysql and SQLite ) I'm running perl-RTx-AssetTracker 2.0.0b2 and the acl.Pg and schema.Pg files do exist. You need to specify the full path to the schema files when running rt-setup-database. rt-setup-database --action schema --dba rt_user --prompt-for-dba-password --datadir \ /usr/share/request-tracker/local/plugins/RTx-AssetTracker/etc/ rt-setup-database --action acl --dba rt_user --prompt-for-dba-password --datadir \ /usr/share/request-tracker/local/plugins/RTx-AssetTracker/etc/ How can I do a complete uninstall of Asset Tracker, AND remove the existing Asset Tracker items from the DB and start over with a fresh install?? If you tell me all the tables, templates, AT global group and user rights etc, I could try to manually drop all the AT parts from the current DB. -- Darin Perusich Email: darin.perus...@ctg.com Office: 716-888-3690 The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you are not the intended recipient of this message, please contact the sender and delete this material from this computer. RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] Allow unprivileged users to search
Hi, here's a quick hack that should allow unprivileged users to use the Simple Search page. First copy 3 files as follows: # mkdir -p /your/rt/location/local/html/SelfService/Search # mkdir /your/rt/location/local/html/Elements # cp /your/rt/location/share/html/Search/Simple.html /your/rt/location/local/html/SelfService/Search/ # cp /your/rt/location/share/html/Search/Results.html /your/rt/location/local/html/SelfService/Search/ # cp /your/rt/location/share/html/Elements/Tabs /your/rt/location/local/html/Elements/ Then download and apply the attached patches: # patch /your/rt/location/local/html/SelfService/Search/Simple.html -i ./simple.txt # patch /your/rt/location/local/html/SelfService/Search/Results.html -i ./results.txt # patch /your/rt/location/local/html/Elements/Tabs -i ./tabs.txt Restart the web server. Now the unprivileged users should be able to search through the tickets visible to them. Best regards, Iulian 88a90,96 # Iulian, stolen from MyRequests my $id = $session{'CurrentUser'}-id; my @roles = qw(Requestor Cc AdminCc Watcher); my $Query .= AND ( . join( ' OR ', map $_.id = $id, @roles) . ); 763a764,765 #add Simple Search to SelfService: $tickets-child( search = title = loc('Simple Search'), path = '/SelfService/Search/Simple.html', ); 83c83 $Format ||= $prefs-{'Format'} || RT-Config-Get('DefaultSearchResultFormat'); --- $Format ||= RT-Config-Get('DefaultSelfServiceSearchResultFormat'); 100a101,110 #limit to visible tickets (stolen from MyRequests) if($Query){ my $id = $session{'CurrentUser'}-id; my @roles = qw(Requestor Cc AdminCc Watcher); $Query .= AND ( . join( ' OR ', map $_.id = $id, @roles) . ); } RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] No Delete option on 3.8.8
you probably need to clear mason cache before restarting apache rm -rf /opt/rt3/var/mason_data/obj Raphaël MOUNEYRES martinmoore mart...@it-helps.co.uk Envoyé par : rt-users-boun...@lists.bestpractical.com 12/01/2012 12:45 A rt-users@lists.bestpractical.com cc Objet Re: [rt-users] No Delete option on 3.8.8 I've installed RT-Extension-QuickDelete, added it to RT_SiteConfig.pm and restarted Apache, but it doesn't appear. Do I need to do anything else? If not, where's it hiding :) Kevin Falcone-2 wrote: You appear to want to RT-Extension-QuickDelete extension. I assume you had it installed in 3.8.4 and lost it in the upgrade. -kevin RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 -- View this message in context: http://old.nabble.com/No-Delete-option-on-3.8.8-tp33107653p33127240.html Sent from the Request Tracker - User mailing list archive at Nabble.com. RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 # Ce courriel et les documents qui lui sont joints peuvent contenir des informations confidentielles ou ayant un caractère privé. S'ils ne vous sont pas destinés, nous vous signalons qu'il est strictement interdit de les divulguer, de les reproduire ou d'en utiliser de quelque manière que ce soit le contenu. Si ce message vous a été transmis par erreur, merci d'en informer l'expéditeur et de supprimer immédiatement de votre système informatique ce courriel ainsi que tous les documents qui y sont attachés. ** This e-mail and any attached documents may contain confidential or proprietary information. If you are not the intended recipient, you are notified that any dissemination, copying of this e-mail and any attachments thereto or use of their contents by any means whatsoever is strictly prohibited. If you have received this e-mail in error, please advise the sender immediately and delete this e-mail and all attached documents from your computer system. # RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] No Delete option on 3.8.8
I didn't have that dir for mason, so did rm -rf /var/cache/request-tracker3.8/mason_data/obj which appears to be the directory on my server. Now restarting apache2 gives the following, which is hopefully a simple path issue, but not to me: [error] Can't locate Extension/QuickDelete.pm in @INC (@INC contains: /usr/local/share/request-tracker3.8/lib /usr/share/request-tracker3.8/lib /etc/perl /usr/local/lib/perl/5.10.1 /usr/local/share/perl/5.10.1 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl . /etc/apache2) at /usr/share/request-tracker3.8/lib/RT.pm line 670.\nCompilation failed in require at (eval 5) line 1.\n Raphaël MOUNEYRES wrote: you probably need to clear mason cache before restarting apache rm -rf /opt/rt3/var/mason_data/obj Raphaël MOUNEYRES martinmoore mart...@it-helps.co.uk Envoyé par : rt-users-boun...@lists.bestpractical.com 12/01/2012 12:45 A rt-users@lists.bestpractical.com cc Objet Re: [rt-users] No Delete option on 3.8.8 I've installed RT-Extension-QuickDelete, added it to RT_SiteConfig.pm and restarted Apache, but it doesn't appear. Do I need to do anything else? If not, where's it hiding :) Kevin Falcone-2 wrote: You appear to want to RT-Extension-QuickDelete extension. I assume you had it installed in 3.8.4 and lost it in the upgrade. -kevin RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 -- View this message in context: http://old.nabble.com/No-Delete-option-on-3.8.8-tp33107653p33127240.html Sent from the Request Tracker - User mailing list archive at Nabble.com. RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 # Ce courriel et les documents qui lui sont joints peuvent contenir des informations confidentielles ou ayant un caractère privé. S'ils ne vous sont pas destinés, nous vous signalons qu'il est strictement interdit de les divulguer, de les reproduire ou d'en utiliser de quelque manière que ce soit le contenu. Si ce message vous a été transmis par erreur, merci d'en informer l'expéditeur et de supprimer immédiatement de votre système informatique ce courriel ainsi que tous les documents qui y sont attachés. ** This e-mail and any attached documents may contain confidential or proprietary information. If you are not the intended recipient, you are notified that any dissemination, copying of this e-mail and any attachments thereto or use of their contents by any means whatsoever is strictly prohibited. If you have received this e-mail in error, please advise the sender immediately and delete this e-mail and all attached documents from your computer system. # RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 -- View this message in context: http://old.nabble.com/No-Delete-option-on-3.8.8-tp33107653p33128088.html Sent from the Request Tracker - User mailing list archive at Nabble.com. RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
[rt-users] RES: Re: RES: Sphinx fulltext index v4.0.4
Tarek, I already tried migrate from Mysql 5.1 to postgreSQL 9.1 but I had some problems quith some charset. Some records in Attachments table (from users that send an email in 8859-1) don't get converted to utf8 and I get the strange character with letter I with acute, like í looking to  (there's a space after Â, hidden or not). I don't know fix that, do you know any way to do that? I even used sed command, but it don't remove the space or whatever this is. Dale, SPHINX: I'm thing theirs is a problem with perl module DBIx::SearchBuilder, mine is 1.61, but can't connect to localhost port 3312. I tested searchd daemon and is working OK. Dale, what version of DBIx::SearchBuilder are you using? Luciano -Mensagem original- De: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Em nome de gekkoman Enviada em: quinta-feira, 5 de janeiro de 2012 19:02 Para: Poulter, Dale; rt-users@lists.bestpractical.com Assunto: [*SPAM*] Re: [rt-users] RES: Sphinx fulltext index v4.0.4 Greetings, FYI I got sphinx running on 4.04 by following instructions before Christmas and everything looked ok.but then I started discovering non functioning aspects of RT post the change eg changing user group memberships stopped working for example. The database was intact with no corruptions. This is obviously not ideal. I had debugged it to the point of finding some RT generated SQL no longer running properly on the database. Since I actually prefer psql over mysql I ended up migrated to psql using exactly the same dataset, engaged fulltext indexing and the problems all went away. Tarek Sounds like it cannot connect to the sphinx server. Can you confirm that sphinx is running (ps -eaf |grep searchd ) and that it is running on the port specified in the attachmentsindex create statement (mysql show create table AttachmentsIndex; )? I believe the default port is 9312 but the documents at http://blog.bestpractical.com/2011/06/full-text-searching.html indicate that the port is 3312. -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Luciano Ernesto da Silva Sent: Thursday, January 05, 2012 5:24 AM To: rt-users@lists.bestpractical.com Subject: [rt-users] RES: Sphinx fulltext index v4.0.4 Hello, I installed everything as described here by Dale/ documentation from docs/full_text_indexing.podc , documentarion by sphinxsearch but i got this error: RT: DBD::mysql::st execute failed: Unable to connect to foreign data source: failed to resolve searchd host (name=localhost) at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587. (/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587) Jan 5 08:45:16 rt4 RT: RT::Handle=HASH(0x7faacbf8ec58) couldn't execute the query 'SELECT COUNT(DISTINCT main.id) FROM Tickets main JOIN Transactions Transactions_1 ON ( Transactions_1.ObjectType = 'RT::Ticket' ) AND ( Transactions_1.ObjectId = main.id ) JOIN Attachments Attachments_2 ON ( Attachments_2.TransactionId = Transactions_1.id ) JOIN AttachmentsIndex AttachmentsIndex_3 ON ( AttachmentsIndex_3.id = Attachments_2.id ) WHERE (main.Status != 'deleted') AND (main.Queue = '23' AND ( AttachmentsIndex_3.query = 'ESEF;limit=1;maxmatches=1' ) ) AND (main.Type = 'ticket') AND (main.EffectiveId = main.id) ' at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600 The Mysql server is running on localhost and the firewall is off(Devel server) and SELINUX is disabled. DBIx::SearchBuilder is up to date. Any ideas? Luciano -Mensagem original- De: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Em nome de Luciano Ernesto da Silva Enviada em: sexta-feira, 30 de dezembro de 2011 10:49 Para: Poulter, Dale Cc: rt-users@lists.bestpractical.com Assunto: Re: [rt-users] Sphinx fulltext index v4.0.4 Thanks for you help! Luciano -Original Message- From: Poulter, Dale [mailto:dale.poul...@vanderbilt.edu] Sent: Thu 12/29/2011 4:42 PM To: Luciano Ernesto da Silva Cc: rt-users@lists.bestpractical.com Subject: RE: [rt-users] Sphinx fulltext index v4.0.4 Here is the process I used. From Mysql-5.5.17 source Move the sphinx source directory msqlse (I used sphinx-2.0.2-beta) to storage/sphinx in the source tree cmake \ -DWITH_UNIXODBC=1 \ -DWITH_INNOBASE_STORAGE_ENGINE=1 \ -DWITH_ARCHIVE_STORAGE_ENGINE=1 \ -DWITH_SPHINX_STORAGE_ENGINE=1 \ -DDEFAULT_CHARSET=utf8 \ -DDEFAULT_COLLATION=utf8_general_ci \ -DWITH_SSL=yes Once mysql is compiled and installed you just need to install the plugin mysql INSTALL PLUGIN sphinx SONAME 'ha_sphinx.so'; mysqls elect * from mysql.plugin; This should indicated that the sphinx plugin is installed. -Original Message- From: Luciano Ernesto da Silva
Re: [rt-users] RES: Sphinx fulltext index v4.0.4
We are using v.1.6.1 -Original Message- From: Luciano Ernesto da Silva [mailto:luci...@cpd.ufrgs.br] Sent: Thursday, January 12, 2012 8:47 AM To: gekkoman; Poulter, Dale; rt-users@lists.bestpractical.com Subject: RES: Re: [rt-users] RES: Sphinx fulltext index v4.0.4 Tarek, I already tried migrate from Mysql 5.1 to postgreSQL 9.1 but I had some problems quith some charset. Some records in Attachments table (from users that send an email in 8859-1) don't get converted to utf8 and I get the strange character with letter I with acute, like í looking to  (there's a space after Â, hidden or not). I don't know fix that, do you know any way to do that? I even used sed command, but it don't remove the space or whatever this is. Dale, SPHINX: I'm thing theirs is a problem with perl module DBIx::SearchBuilder, mine is 1.61, but can't connect to localhost port 3312. I tested searchd daemon and is working OK. Dale, what version of DBIx::SearchBuilder are you using? Luciano -Mensagem original- De: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Em nome de gekkoman Enviada em: quinta-feira, 5 de janeiro de 2012 19:02 Para: Poulter, Dale; rt-users@lists.bestpractical.com Assunto: [*SPAM*] Re: [rt-users] RES: Sphinx fulltext index v4.0.4 Greetings, FYI I got sphinx running on 4.04 by following instructions before Christmas and everything looked ok.but then I started discovering non functioning aspects of RT post the change eg changing user group memberships stopped working for example. The database was intact with no corruptions. This is obviously not ideal. I had debugged it to the point of finding some RT generated SQL no longer running properly on the database. Since I actually prefer psql over mysql I ended up migrated to psql using exactly the same dataset, engaged fulltext indexing and the problems all went away. Tarek Sounds like it cannot connect to the sphinx server. Can you confirm that sphinx is running (ps -eaf |grep searchd ) and that it is running on the port specified in the attachmentsindex create statement (mysql show create table AttachmentsIndex; )? I believe the default port is 9312 but the documents at http://blog.bestpractical.com/2011/06/full-text-searching.html indicate that the port is 3312. -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Luciano Ernesto da Silva Sent: Thursday, January 05, 2012 5:24 AM To: rt-users@lists.bestpractical.com Subject: [rt-users] RES: Sphinx fulltext index v4.0.4 Hello, I installed everything as described here by Dale/ documentation from docs/full_text_indexing.podc , documentarion by sphinxsearch but i got this error: RT: DBD::mysql::st execute failed: Unable to connect to foreign data source: failed to resolve searchd host (name=localhost) at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587. (/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587) Jan 5 08:45:16 rt4 RT: RT::Handle=HASH(0x7faacbf8ec58) couldn't execute the query 'SELECT COUNT(DISTINCT main.id) FROM Tickets main JOIN Transactions Transactions_1 ON ( Transactions_1.ObjectType = 'RT::Ticket' ) AND ( Transactions_1.ObjectId = main.id ) JOIN Attachments Attachments_2 ON ( Attachments_2.TransactionId = Transactions_1.id ) JOIN AttachmentsIndex AttachmentsIndex_3 ON ( AttachmentsIndex_3.id = Attachments_2.id ) WHERE (main.Status != 'deleted') AND (main.Queue = '23' AND ( AttachmentsIndex_3.query = 'ESEF;limit=1;maxmatches=1' ) ) AND (main.Type = 'ticket') AND (main.EffectiveId = main.id) ' at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600 The Mysql server is running on localhost and the firewall is off(Devel server) and SELINUX is disabled. DBIx::SearchBuilder is up to date. Any ideas? Luciano -Mensagem original- De: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Em nome de Luciano Ernesto da Silva Enviada em: sexta-feira, 30 de dezembro de 2011 10:49 Para: Poulter, Dale Cc: rt-users@lists.bestpractical.com Assunto: Re: [rt-users] Sphinx fulltext index v4.0.4 Thanks for you help! Luciano -Original Message- From: Poulter, Dale [mailto:dale.poul...@vanderbilt.edu] Sent: Thu 12/29/2011 4:42 PM To: Luciano Ernesto da Silva Cc: rt-users@lists.bestpractical.com Subject: RE: [rt-users] Sphinx fulltext index v4.0.4 Here is the process I used. From Mysql-5.5.17 source Move the sphinx source directory msqlse (I used sphinx-2.0.2-beta) to storage/sphinx in the source tree cmake \ -DWITH_UNIXODBC=1 \ -DWITH_INNOBASE_STORAGE_ENGINE=1 \ -DWITH_ARCHIVE_STORAGE_ENGINE=1 \ -DWITH_SPHINX_STORAGE_ENGINE=1 \ -DDEFAULT_CHARSET=utf8 \ -DDEFAULT_COLLATION=utf8_general_ci \ -DWITH_SSL=yes Once mysql is compiled and installed
Re: [rt-users] No Delete option on 3.8.8
On Thu, Jan 12, 2012 at 06:26:11AM -0800, martinmoore wrote: I didn't have that dir for mason, so did rm -rf /var/cache/request-tracker3.8/mason_data/obj which appears to be the directory on my server. Now restarting apache2 gives the following, which is hopefully a simple path issue, but not to me: [error] Can't locate Extension/QuickDelete.pm in @INC (@INC contains: The extension is named RT::Extension::QuickDelete, not Extension::QuickDelete. It doesn't appear that you've followed the instructions from the README. /usr/local/share/request-tracker3.8/lib /usr/share/request-tracker3.8/lib /etc/perl /usr/local/lib/perl/5.10.1 /usr/local/share/perl/5.10.1 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl . /etc/apache2) at /usr/share/request-tracker3.8/lib/RT.pm line 670.\nCompilation failed in require at (eval 5) line 1.\n Raphaël MOUNEYRES wrote: you probably need to clear mason cache before restarting apache rm -rf /opt/rt3/var/mason_data/obj Raphaël MOUNEYRES martinmoore mart...@it-helps.co.uk Envoyé par : rt-users-boun...@lists.bestpractical.com 12/01/2012 12:45 A rt-users@lists.bestpractical.com cc Objet Re: [rt-users] No Delete option on 3.8.8 I've installed RT-Extension-QuickDelete, added it to RT_SiteConfig.pm and restarted Apache, but it doesn't appear. Do I need to do anything else? If not, where's it hiding :) Kevin Falcone-2 wrote: You appear to want to RT-Extension-QuickDelete extension. I assume you had it installed in 3.8.4 and lost it in the upgrade. -kevin RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 -- View this message in context: http://old.nabble.com/No-Delete-option-on-3.8.8-tp33107653p33127240.html Sent from the Request Tracker - User mailing list archive at Nabble.com. RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 # Ce courriel et les documents qui lui sont joints peuvent contenir des informations confidentielles ou ayant un caractère privé. S'ils ne vous sont pas destinés, nous vous signalons qu'il est strictement interdit de les divulguer, de les reproduire ou d'en utiliser de quelque manière que ce soit le contenu. Si ce message vous a été transmis par erreur, merci d'en informer l'expéditeur et de supprimer immédiatement de votre système informatique ce courriel ainsi que tous les documents qui y sont attachés. ** This e-mail and any attached documents may contain confidential or proprietary information. If you are not the intended recipient, you are notified that any dissemination, copying of this e-mail and any attachments thereto or use of their contents by any means whatsoever is strictly prohibited. If you have received this e-mail in error, please advise the sender immediately and delete this e-mail and all attached documents from your computer system. # RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 -- View this message in context: http://old.nabble.com/No-Delete-option-on-3.8.8-tp33107653p33128088.html Sent from the Request Tracker - User mailing list archive at Nabble.com. RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 pgpYtu05U4oFB.pgp Description: PGP signature RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] No Delete option on 3.8.8
Great - thanks Kevin. I now have 'delete' from within the ticket view. Is it possible to have it in the list view to allow deletion of spam without opening the ticket? Kevin Falcone-2 wrote: On Thu, Jan 12, 2012 at 06:26:11AM -0800, martinmoore wrote: I didn't have that dir for mason, so did rm -rf /var/cache/request-tracker3.8/mason_data/obj which appears to be the directory on my server. Now restarting apache2 gives the following, which is hopefully a simple path issue, but not to me: [error] Can't locate Extension/QuickDelete.pm in @INC (@INC contains: The extension is named RT::Extension::QuickDelete, not Extension::QuickDelete. It doesn't appear that you've followed the instructions from the README. /usr/local/share/request-tracker3.8/lib /usr/share/request-tracker3.8/lib /etc/perl /usr/local/lib/perl/5.10.1 /usr/local/share/perl/5.10.1 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl . /etc/apache2) at /usr/share/request-tracker3.8/lib/RT.pm line 670.\nCompilation failed in require at (eval 5) line 1.\n Raphaël MOUNEYRES wrote: you probably need to clear mason cache before restarting apache rm -rf /opt/rt3/var/mason_data/obj Raphaël MOUNEYRES martinmoore mart...@it-helps.co.uk Envoyé par : rt-users-boun...@lists.bestpractical.com 12/01/2012 12:45 A rt-users@lists.bestpractical.com cc Objet Re: [rt-users] No Delete option on 3.8.8 I've installed RT-Extension-QuickDelete, added it to RT_SiteConfig.pm and restarted Apache, but it doesn't appear. Do I need to do anything else? If not, where's it hiding :) Kevin Falcone-2 wrote: You appear to want to RT-Extension-QuickDelete extension. I assume you had it installed in 3.8.4 and lost it in the upgrade. -kevin RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 -- View this message in context: http://old.nabble.com/No-Delete-option-on-3.8.8-tp33107653p33127240.html Sent from the Request Tracker - User mailing list archive at Nabble.com. RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 # Ce courriel et les documents qui lui sont joints peuvent contenir des informations confidentielles ou ayant un caractère privé. S'ils ne vous sont pas destinés, nous vous signalons qu'il est strictement interdit de les divulguer, de les reproduire ou d'en utiliser de quelque manière que ce soit le contenu. Si ce message vous a été transmis par erreur, merci d'en informer l'expéditeur et de supprimer immédiatement de votre système informatique ce courriel ainsi que tous les documents qui y sont attachés. ** This e-mail and any attached documents may contain confidential or proprietary information. If you are not the intended recipient, you are notified that any dissemination, copying of this e-mail and any attachments thereto or use of their contents by any means whatsoever is strictly prohibited. If you have received this e-mail in error, please advise the sender immediately and delete this e-mail and all attached documents from your computer system. # RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 -- View this message in context: http://old.nabble.com/No-Delete-option-on-3.8.8-tp33107653p33128088.html Sent from the Request Tracker - User mailing list archive at Nabble.com. RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 -- View this message in context: http://old.nabble.com/No-Delete-option-on-3.8.8-tp33107653p33128980.html Sent from the Request Tracker - User mailing list archive at Nabble.com. RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] RES: Re: RES: Sphinx fulltext index v4.0.4
On 1/12/2012 9:46 AM, Luciano Ernesto da Silva wrote: Tarek, I already tried migrate from Mysql 5.1 to postgreSQL 9.1 but I had some problems quith some charset. Some records in Attachments table (from users that send an email in 8859-1) don't get converted to utf8 and I get the strange character with letter I with acute, like í looking to  (there's a space after Â, hidden or not). I don't know fix that, do you know any way to do that? I even used sed command, but it don't remove the space or whatever this is. We had the same problem. This worked perfectly for us in the end, though we went to PostgreSQL 8.4.9 as provided by RHEL 6.x http://wiki-archive.bestpractical.com/view/rt-mysql2pg RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] No Delete option on 3.8.8
On Thu, Jan 12, 2012 at 08:42:31AM -0800, martinmoore wrote: Great - thanks Kevin. I now have 'delete' from within the ticket view. Is it possible to have it in the list view to allow deletion of spam without opening the ticket? Yes, the README explains how to modify your default search format. -kevin Kevin Falcone-2 wrote: On Thu, Jan 12, 2012 at 06:26:11AM -0800, martinmoore wrote: I didn't have that dir for mason, so did rm -rf /var/cache/request-tracker3.8/mason_data/obj which appears to be the directory on my server. Now restarting apache2 gives the following, which is hopefully a simple path issue, but not to me: [error] Can't locate Extension/QuickDelete.pm in @INC (@INC contains: The extension is named RT::Extension::QuickDelete, not Extension::QuickDelete. It doesn't appear that you've followed the instructions from the README. /usr/local/share/request-tracker3.8/lib /usr/share/request-tracker3.8/lib /etc/perl /usr/local/lib/perl/5.10.1 /usr/local/share/perl/5.10.1 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl . /etc/apache2) at /usr/share/request-tracker3.8/lib/RT.pm line 670.\nCompilation failed in require at (eval 5) line 1.\n Raphaël MOUNEYRES wrote: you probably need to clear mason cache before restarting apache rm -rf /opt/rt3/var/mason_data/obj Raphaël MOUNEYRES martinmoore mart...@it-helps.co.uk Envoyé par : rt-users-boun...@lists.bestpractical.com 12/01/2012 12:45 A rt-users@lists.bestpractical.com cc Objet Re: [rt-users] No Delete option on 3.8.8 I've installed RT-Extension-QuickDelete, added it to RT_SiteConfig.pm and restarted Apache, but it doesn't appear. Do I need to do anything else? If not, where's it hiding :) Kevin Falcone-2 wrote: You appear to want to RT-Extension-QuickDelete extension. I assume you had it installed in 3.8.4 and lost it in the upgrade. -kevin RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 -- View this message in context: http://old.nabble.com/No-Delete-option-on-3.8.8-tp33107653p33127240.html Sent from the Request Tracker - User mailing list archive at Nabble.com. RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 # Ce courriel et les documents qui lui sont joints peuvent contenir des informations confidentielles ou ayant un caractère privé. S'ils ne vous sont pas destinés, nous vous signalons qu'il est strictement interdit de les divulguer, de les reproduire ou d'en utiliser de quelque manière que ce soit le contenu. Si ce message vous a été transmis par erreur, merci d'en informer l'expéditeur et de supprimer immédiatement de votre système informatique ce courriel ainsi que tous les documents qui y sont attachés. ** This e-mail and any attached documents may contain confidential or proprietary information. If you are not the intended recipient, you are notified that any dissemination, copying of this e-mail and any attachments thereto or use of their contents by any means whatsoever is strictly prohibited. If you have received this e-mail in error, please advise the sender immediately and delete this e-mail and all attached documents from your computer system. # RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 -- View this message in context: http://old.nabble.com/No-Delete-option-on-3.8.8-tp33107653p33128088.html Sent from the Request Tracker - User mailing list archive at Nabble.com. RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 -- View this message in context: http://old.nabble.com/No-Delete-option-on-3.8.8-tp33107653p33128980.html Sent from the Request Tracker - User mailing list archive at Nabble.com. RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 pgp1mPSdvB0eZ.pgp Description: PGP signature RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
[rt-users] Apache2.2 won't start at boot. RT4.0.4 on debian 6
Hi, I'm having a major headache trying to get apache2 (for a clean install of RT4.0.4, on a clean install of Debian 6.0.3) to start at boot. If I leave the default apache site enabled, with no RT site in the config, then apache will start at boot with no problem. If I enable the RT site and disable the default one then apache will not start at boot. However there is absolutely nothing in **any** log file to suggest that apache has even attempted to start, let alone why it has not started. I can start apache manually by running /etc/init.d/apache2 start which works perfectly. I've followed the RT4 install readme to the letter and I've gone through the whole process from scratch (and I mean installing debian from scratch) at least 4 times now and it's getting frustrating to say the least. My RT site apache conf is as follows, and is only different from the default as suggested in web_deployment.pod in that my VirtualHost has been changed to my own: VirtualHost rtir.abuse ### Optional apache logs for RT ErrorLog /opt/rt4/var/log/apache2.error TransferLog /opt/rt4/var/log/apache2.access LogLevel debug AddDefaultCharset UTF-8 DocumentRoot /opt/rt4/share/html Location / Order allow,deny Allow from all SetHandler modperl PerlResponseHandler Plack::Handler::Apache2 PerlSetVar psgi_app /opt/rt4/sbin/rt-server /Location Perl use Plack::Handler::Apache2; Plack::Handler::Apache2-preload(/opt/rt4/sbin/rt-server); /Perl /VirtualHost I use the commands a2ensite a2dissite to enable/disable both the default apache site and my RT site There doesn't seem to be any other reports from anyone else having this issue so what the hell is going on, and how do I fix it?! Cheers, Glenn RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
[rt-users] RES:RE: Re: RES: Sphinx fulltext index v4.0.4
Did yoy run rt-fulltext-indexer with the default options, like sphinx://localhost:3312 ? Luciano -Mensagem original- De: Poulter, Dale [mailto:dale.poul...@vanderbilt.edu] Enviada em: quinta-feira, 12 de janeiro de 2012 13:02 Para: Luciano Ernesto da Silva; gekkoman; rt-users@lists.bestpractical.com Assunto: [*SPAM*] RE: Re: [rt-users] RES: Sphinx fulltext index v4.0.4 We are using v.1.6.1 -Original Message- From: Luciano Ernesto da Silva [mailto:luci...@cpd.ufrgs.br] Sent: Thursday, January 12, 2012 8:47 AM To: gekkoman; Poulter, Dale; rt-users@lists.bestpractical.com Subject: RES: Re: [rt-users] RES: Sphinx fulltext index v4.0.4 Tarek, I already tried migrate from Mysql 5.1 to postgreSQL 9.1 but I had some problems quith some charset. Some records in Attachments table (from users that send an email in 8859-1) don't get converted to utf8 and I get the strange character with letter I with acute, like í looking to  (there's a space after Â, hidden or not). I don't know fix that, do you know any way to do that? I even used sed command, but it don't remove the space or whatever this is. Dale, SPHINX: I'm thing theirs is a problem with perl module DBIx::SearchBuilder, mine is 1.61, but can't connect to localhost port 3312. I tested searchd daemon and is working OK. Dale, what version of DBIx::SearchBuilder are you using? Luciano -Mensagem original- De: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Em nome de gekkoman Enviada em: quinta-feira, 5 de janeiro de 2012 19:02 Para: Poulter, Dale; rt-users@lists.bestpractical.com Assunto: [*SPAM*] Re: [rt-users] RES: Sphinx fulltext index v4.0.4 Greetings, FYI I got sphinx running on 4.04 by following instructions before Christmas and everything looked ok.but then I started discovering non functioning aspects of RT post the change eg changing user group memberships stopped working for example. The database was intact with no corruptions. This is obviously not ideal. I had debugged it to the point of finding some RT generated SQL no longer running properly on the database. Since I actually prefer psql over mysql I ended up migrated to psql using exactly the same dataset, engaged fulltext indexing and the problems all went away. Tarek Sounds like it cannot connect to the sphinx server. Can you confirm that sphinx is running (ps -eaf |grep searchd ) and that it is running on the port specified in the attachmentsindex create statement (mysql show create table AttachmentsIndex; )? I believe the default port is 9312 but the documents at http://blog.bestpractical.com/2011/06/full-text-searching.html indicate that the port is 3312. -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Luciano Ernesto da Silva Sent: Thursday, January 05, 2012 5:24 AM To: rt-users@lists.bestpractical.com Subject: [rt-users] RES: Sphinx fulltext index v4.0.4 Hello, I installed everything as described here by Dale/ documentation from docs/full_text_indexing.podc , documentarion by sphinxsearch but i got this error: RT: DBD::mysql::st execute failed: Unable to connect to foreign data source: failed to resolve searchd host (name=localhost) at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587. (/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587) Jan 5 08:45:16 rt4 RT: RT::Handle=HASH(0x7faacbf8ec58) couldn't execute the query 'SELECT COUNT(DISTINCT main.id) FROM Tickets main JOIN Transactions Transactions_1 ON ( Transactions_1.ObjectType = 'RT::Ticket' ) AND ( Transactions_1.ObjectId = main.id ) JOIN Attachments Attachments_2 ON ( Attachments_2.TransactionId = Transactions_1.id ) JOIN AttachmentsIndex AttachmentsIndex_3 ON ( AttachmentsIndex_3.id = Attachments_2.id ) WHERE (main.Status != 'deleted') AND (main.Queue = '23' AND ( AttachmentsIndex_3.query = 'ESEF;limit=1;maxmatches=1' ) ) AND (main.Type = 'ticket') AND (main.EffectiveId = main.id) ' at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600 The Mysql server is running on localhost and the firewall is off(Devel server) and SELINUX is disabled. DBIx::SearchBuilder is up to date. Any ideas? Luciano -Mensagem original- De: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Em nome de Luciano Ernesto da Silva Enviada em: sexta-feira, 30 de dezembro de 2011 10:49 Para: Poulter, Dale Cc: rt-users@lists.bestpractical.com Assunto: Re: [rt-users] Sphinx fulltext index v4.0.4 Thanks for you help! Luciano -Original Message- From: Poulter, Dale [mailto:dale.poul...@vanderbilt.edu] Sent: Thu 12/29/2011 4:42 PM To: Luciano Ernesto da Silva Cc: rt-users@lists.bestpractical.com Subject: RE: [rt-users] Sphinx fulltext index v4.0.4 Here is the
[rt-users] RES: RES: Re: RES: Sphinx fulltext index v4.0.4
When you migrate to PostgreSQL, what version of RT were you using? RT 4? Any special option on script? Luciano -Mensagem original- De: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Em nome de Jeff Blaine Enviada em: quinta-feira, 12 de janeiro de 2012 15:06 Para: rt-users@lists.bestpractical.com Assunto: Re: [rt-users] RES: Re: RES: Sphinx fulltext index v4.0.4 On 1/12/2012 9:46 AM, Luciano Ernesto da Silva wrote: Tarek, I already tried migrate from Mysql 5.1 to postgreSQL 9.1 but I had some problems quith some charset. Some records in Attachments table (from users that send an email in 8859-1) don't get converted to utf8 and I get the strange character with letter I with acute, like í looking to  (there's a space after Â, hidden or not). I don't know fix that, do you know any way to do that? I even used sed command, but it don't remove the space or whatever this is. We had the same problem. This worked perfectly for us in the end, though we went to PostgreSQL 8.4.9 as provided by RHEL 6.x http://wiki-archive.bestpractical.com/view/rt-mysql2pg RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] RES: RES: Re: RES: Sphinx fulltext index v4.0.4
On 1/12/2012 12:54 PM, Luciano Ernesto da Silva wrote: When you migrate to PostgreSQL, what version of RT were you using? RT 4? Any special option on script? We dumped our RT 3.4.4 database from MySQL 4.1 (this is the last time we touched the old data) We stood up a new host. It had MySQL 5.1.x We loaded the MySQL 4.1 dump into the new MySQL 5.1.x instance We followed docs/UPGRADING.mysql We updated the password salt stuff (docs/UPGRADING.*) Then... We stood up PostgreSQL 8.4.9 on the same server We reconfigured RT for 'Pg', then primed the DB + tables + acls make install sbin/rt-setup-database --action drop # ignore any errors sbin/rt-setup-database --action create sbin/rt-setup-database --action schema sbin/rt-setup-database --action acl Then we migrated the data from MySQL 5.1 (running) to PostgreSQL 8.4.9 (running) with: http://wiki-archive.bestpractical.com/view/rt-mysql2pg There's no magic to the script's options. It has --help -Mensagem original- De: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Em nome de Jeff Blaine Enviada em: quinta-feira, 12 de janeiro de 2012 15:06 Para: rt-users@lists.bestpractical.com Assunto: Re: [rt-users] RES: Re: RES: Sphinx fulltext index v4.0.4 On 1/12/2012 9:46 AM, Luciano Ernesto da Silva wrote: Tarek, I already tried migrate from Mysql 5.1 to postgreSQL 9.1 but I had some problems quith some charset. Some records in Attachments table (from users that send an email in 8859-1) don't get converted to utf8 and I get the strange character with letter I with acute, like í looking to  (there's a space after Â, hidden or not). I don't know fix that, do you know any way to do that? I even used sed command, but it don't remove the space or whatever this is. We had the same problem. This worked perfectly for us in the end, though we went to PostgreSQL 8.4.9 as provided by RHEL 6.x http://wiki-archive.bestpractical.com/view/rt-mysql2pg RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
[rt-users] RES: RES: RES: Re: RES: Sphinx fulltext index v4.0.4
Thanks for your help. I'll try the script. Luciano -Mensagem original- De: Jeff Blaine [mailto:jbla...@kickflop.net] Enviada em: quinta-feira, 12 de janeiro de 2012 16:12 Para: Luciano Ernesto da Silva Cc: rt-users@lists.bestpractical.com Assunto: Re: RES: [rt-users] RES: Re: RES: Sphinx fulltext index v4.0.4 On 1/12/2012 12:54 PM, Luciano Ernesto da Silva wrote: When you migrate to PostgreSQL, what version of RT were you using? RT 4? Any special option on script? We dumped our RT 3.4.4 database from MySQL 4.1 (this is the last time we touched the old data) We stood up a new host. It had MySQL 5.1.x We loaded the MySQL 4.1 dump into the new MySQL 5.1.x instance We followed docs/UPGRADING.mysql We updated the password salt stuff (docs/UPGRADING.*) Then... We stood up PostgreSQL 8.4.9 on the same server We reconfigured RT for 'Pg', then primed the DB + tables + acls make install sbin/rt-setup-database --action drop # ignore any errors sbin/rt-setup-database --action create sbin/rt-setup-database --action schema sbin/rt-setup-database --action acl Then we migrated the data from MySQL 5.1 (running) to PostgreSQL 8.4.9 (running) with: http://wiki-archive.bestpractical.com/view/rt-mysql2pg There's no magic to the script's options. It has --help -Mensagem original- De: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Em nome de Jeff Blaine Enviada em: quinta-feira, 12 de janeiro de 2012 15:06 Para: rt-users@lists.bestpractical.com Assunto: Re: [rt-users] RES: Re: RES: Sphinx fulltext index v4.0.4 On 1/12/2012 9:46 AM, Luciano Ernesto da Silva wrote: Tarek, I already tried migrate from Mysql 5.1 to postgreSQL 9.1 but I had some problems quith some charset. Some records in Attachments table (from users that send an email in 8859-1) don't get converted to utf8 and I get the strange character with letter I with acute, like í looking to  (there's a space after Â, hidden or not). I don't know fix that, do you know any way to do that? I even used sed command, but it don't remove the space or whatever this is. We had the same problem. This worked perfectly for us in the end, though we went to PostgreSQL 8.4.9 as provided by RHEL 6.x http://wiki-archive.bestpractical.com/view/rt-mysql2pg RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] No Delete option on 3.8.8
Hmm - added to site config as per the readme, rm mason/obj restarted apache. It seems to have loaded, but I can't find it anywhere in the setup: DefaultSearchResultFormat ' /rt/Ticket/Display.html?id=__id__ __id__ /TITLE:#', ' /rt/Ticket/Display.html?id=__id__ __Subject__ /TITLE:Subject', Status, QueueName, OwnerName, Priority, QuickDelete, '__NEWLINE__', '', 'small__Requestors__/small', 'small__CreatedRelative__/small', 'small__ToldRelative__/small', 'small__LastUpdatedRelative__/small', 'small__TimeLeft__/small' site config Kevin Falcone-2 wrote: On Thu, Jan 12, 2012 at 08:42:31AM -0800, martinmoore wrote: Great - thanks Kevin. I now have 'delete' from within the ticket view. Is it possible to have it in the list view to allow deletion of spam without opening the ticket? Yes, the README explains how to modify your default search format. -kevin Kevin Falcone-2 wrote: On Thu, Jan 12, 2012 at 06:26:11AM -0800, martinmoore wrote: I didn't have that dir for mason, so did rm -rf /var/cache/request-tracker3.8/mason_data/obj which appears to be the directory on my server. Now restarting apache2 gives the following, which is hopefully a simple path issue, but not to me: [error] Can't locate Extension/QuickDelete.pm in @INC (@INC contains: The extension is named RT::Extension::QuickDelete, not Extension::QuickDelete. It doesn't appear that you've followed the instructions from the README. /usr/local/share/request-tracker3.8/lib /usr/share/request-tracker3.8/lib /etc/perl /usr/local/lib/perl/5.10.1 /usr/local/share/perl/5.10.1 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl . /etc/apache2) at /usr/share/request-tracker3.8/lib/RT.pm line 670.\nCompilation failed in require at (eval 5) line 1.\n Raphaël MOUNEYRES wrote: you probably need to clear mason cache before restarting apache rm -rf /opt/rt3/var/mason_data/obj Raphaël MOUNEYRES martinmoore mart...@it-helps.co.uk Envoyé par : rt-users-boun...@lists.bestpractical.com 12/01/2012 12:45 A rt-users@lists.bestpractical.com cc Objet Re: [rt-users] No Delete option on 3.8.8 I've installed RT-Extension-QuickDelete, added it to RT_SiteConfig.pm and restarted Apache, but it doesn't appear. Do I need to do anything else? If not, where's it hiding :) Kevin Falcone-2 wrote: You appear to want to RT-Extension-QuickDelete extension. I assume you had it installed in 3.8.4 and lost it in the upgrade. -kevin RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 -- View this message in context: http://old.nabble.com/No-Delete-option-on-3.8.8-tp33107653p33127240.html Sent from the Request Tracker - User mailing list archive at Nabble.com. RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 # Ce courriel et les documents qui lui sont joints peuvent contenir des informations confidentielles ou ayant un caractère privé. S'ils ne vous sont pas destinés, nous vous signalons qu'il est strictement interdit de les divulguer, de les reproduire ou d'en utiliser de quelque manière que ce soit le contenu. Si ce message vous a été transmis par erreur, merci d'en informer l'expéditeur et de supprimer immédiatement de votre système informatique ce courriel ainsi que tous les documents qui y sont attachés. ** This e-mail and any attached documents may contain confidential or proprietary information. If you are not the intended recipient, you are notified that any dissemination, copying of this e-mail and any attachments thereto or use of their contents by any means whatsoever is strictly prohibited. If you have received this e-mail in error, please advise the sender immediately and delete this e-mail and all attached documents from your computer system. # RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 -- View this message in context: http://old.nabble.com/No-Delete-option-on-3.8.8-tp33107653p33128088.html Sent from the Request Tracker - User mailing list archive at Nabble.com. RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 -- View this message in context: http://old.nabble.com/No-Delete-option-on-3.8.8-tp33107653p33128980.html Sent from the Request Tracker - User mailing list archive at Nabble.com.
Re: [rt-users] No Delete option on 3.8.8
On Thu, Jan 12, 2012 at 11:23:51AM -0800, martinmoore wrote: Hmm - added to site config as per the readme, rm mason/obj restarted apache. It seems to have loaded, but I can't find it anywhere in the setup: Where are you looking? Click on Tickets and do a new search for id 1 If you want it on existing searches you will need to add QuickDelete to your formats. -kevin DefaultSearchResultFormat ' /rt/Ticket/Display.html?id=__id__ __id__ /TITLE:#', ' /rt/Ticket/Display.html?id=__id__ __Subject__ /TITLE:Subject', Status, QueueName, OwnerName, Priority, QuickDelete, '__NEWLINE__', '', 'small__Requestors__/small', 'small__CreatedRelative__/small', 'small__ToldRelative__/small', 'small__LastUpdatedRelative__/small', 'small__TimeLeft__/small' site config Kevin Falcone-2 wrote: On Thu, Jan 12, 2012 at 08:42:31AM -0800, martinmoore wrote: Great - thanks Kevin. I now have 'delete' from within the ticket view. Is it possible to have it in the list view to allow deletion of spam without opening the ticket? Yes, the README explains how to modify your default search format. -kevin Kevin Falcone-2 wrote: On Thu, Jan 12, 2012 at 06:26:11AM -0800, martinmoore wrote: I didn't have that dir for mason, so did rm -rf /var/cache/request-tracker3.8/mason_data/obj which appears to be the directory on my server. Now restarting apache2 gives the following, which is hopefully a simple path issue, but not to me: [error] Can't locate Extension/QuickDelete.pm in @INC (@INC contains: The extension is named RT::Extension::QuickDelete, not Extension::QuickDelete. It doesn't appear that you've followed the instructions from the README. /usr/local/share/request-tracker3.8/lib /usr/share/request-tracker3.8/lib /etc/perl /usr/local/lib/perl/5.10.1 /usr/local/share/perl/5.10.1 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl . /etc/apache2) at /usr/share/request-tracker3.8/lib/RT.pm line 670.\nCompilation failed in require at (eval 5) line 1.\n Raphaël MOUNEYRES wrote: you probably need to clear mason cache before restarting apache rm -rf /opt/rt3/var/mason_data/obj Raphaël MOUNEYRES martinmoore mart...@it-helps.co.uk Envoyé par : rt-users-boun...@lists.bestpractical.com 12/01/2012 12:45 A rt-users@lists.bestpractical.com cc Objet Re: [rt-users] No Delete option on 3.8.8 I've installed RT-Extension-QuickDelete, added it to RT_SiteConfig.pm and restarted Apache, but it doesn't appear. Do I need to do anything else? If not, where's it hiding :) Kevin Falcone-2 wrote: You appear to want to RT-Extension-QuickDelete extension. I assume you had it installed in 3.8.4 and lost it in the upgrade. -kevin RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 -- View this message in context: http://old.nabble.com/No-Delete-option-on-3.8.8-tp33107653p33127240.html Sent from the Request Tracker - User mailing list archive at Nabble.com. RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 # Ce courriel et les documents qui lui sont joints peuvent contenir des informations confidentielles ou ayant un caractère privé. S'ils ne vous sont pas destinés, nous vous signalons qu'il est strictement interdit de les divulguer, de les reproduire ou d'en utiliser de quelque manière que ce soit le contenu. Si ce message vous a été transmis par erreur, merci d'en informer l'expéditeur et de supprimer immédiatement de votre système informatique ce courriel ainsi que tous les documents qui y sont attachés. ** This e-mail and any attached documents may contain confidential or proprietary information. If you are not the intended recipient, you are notified that any dissemination, copying of this e-mail and any attachments thereto or use of their contents by any means whatsoever is strictly prohibited. If you have received this e-mail in error, please advise the sender immediately and delete this e-mail and all attached documents from your computer system. # RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 -- View this message in context: http://old.nabble.com/No-Delete-option-on-3.8.8-tp33107653p33128088.html Sent from the Request Tracker - User mailing list archive at Nabble.com. RT Training
Re: [rt-users] rt-mailgate
Hello, I verified my certificates, openssl says they're OK. --Mark Sorry, left out the -CApath flag, and this is just for illustration: root@xxx:/var/www/servers# openssl verify -CApath /etc/ssl/certs/ /usr/share/ca-certificates/mozilla/DST_ACES_CA_X6.crt /usr/share/ca-certificates/mozilla/DST_ACES_CA_X6.crt: OK RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] rt-mailgate
Make sure you have Crypt::SSLeay, Net::SSL, LWP::UserAgent, LWP::Protocol::https, and Mozilla::CA installed. We didn't have Mozilla::CA Crypt::SSLeay installed, but still didn't help: rt ls -t 59 Query:Status!='resolved' and Status!='rejected' rt: Server error: Can't connect to rt.myhost.com:443 (certificate verify failed) (500) --Mark Thomas RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] rt-mailgate
I have rt4 installed manually in /opt/rt4 but when I ran dpkg I got: www:/etc/ssl/certs# dpkg --list | grep reques ii libapache2-mod-apreq22.08-5+b1 generic Apache request library - Apache modu ii libapache2-request-perl 2.08-5+b1 generic Apache request library - Perl module ii libapreq22.08-5+b1 generic Apache request library pc request-tracker3.6 3.6.7-5+lenny6 Extensible trouble-ticket tracking system pc rt3.6-db-postgresql 3.6.7-5+lenny6 PostgreSQL database backend for request-trac Is that a potential issue? I tried removing request-tracker3.6 rt3.6-db-postgresql but it failed ...? www:/etc/ssl/certs# apt-get remove rt3.6-db-postgresql Reading package lists... Done Building dependency tree Reading state information... Done Package rt3.6-db-postgresql is not installed, so not removed 0 upgraded, 0 newly installed, 0 to remove and 48 not upgraded. www:/etc/ssl/certs# apt-get remove request-tracker3.6 Reading package lists... Done Building dependency tree Reading state information... Done Package request-tracker3.6 is not installed, so not removed 0 upgraded, 0 newly installed, 0 to remove and 48 not upgraded. --Mark This is on Ubuntu 11.10 Oneiric running reqest-tracker4 pinned with apt preferences to Precise packages for version 4.0.4-1: root@web0:/etc/logrotate.d# dpkg --list | grep reques ii request-tracker44.0.4-1 extensible trouble-ticket tracking system ii rt4-apache2 4.0.4-1 Apache 2 specific files for request-tracker4 ii rt4-clients 4.0.4-1 mail gateway and command-line interface to request-tracker4 ii rt4-db-sqlite 4.0.4-1 SQLite database backend for request-tracker4 RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
[rt-users] Due Date not setting correctly
I need Due date set to the default 24 hours when a ticket comes in and change anytime the priority is change and/or a reply is sent, but for some reason it only seems to work with tickets created from within RT and by reply to tickets that were emailed in. And even then, the due date resets back to Not Set If priority is changed and a reply isn't sent. Any suggestions? David Hollinger III IT Infrastructure Coordinator Handwriting Without Tears (301)263-2700 ext 285 (402)430-3127 RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] RES:RE: Re: RES: Sphinx fulltext index v4.0.4
Luciano, this is probably a new thread, but I migrated to pg using the process and script provided here http://www.mailinglistarchive.com/html/rt-users@lists.bestpractical.com/2011-06/msg00514.html and on mine I did not have any issues. There is an attempt at UTF-8 encoding done in this script. eg push @values, encode(UTF-8, $row-{$key}); Not sure if this will fix your issue. Tarek Did yoy run rt-fulltext-indexer with the default options, like sphinx://localhost:3312 ? Luciano -Mensagem original- De: Poulter, Dale [mailto:dale.poul...@vanderbilt.edu] Enviada em: quinta-feira, 12 de janeiro de 2012 13:02 Para: Luciano Ernesto da Silva; gekkoman; rt-users@lists.bestpractical.com Assunto: [*SPAM*] RE: Re: [rt-users] RES: Sphinx fulltext index v4.0.4 We are using v.1.6.1 -Original Message- From: Luciano Ernesto da Silva [mailto:luci...@cpd.ufrgs.br] Sent: Thursday, January 12, 2012 8:47 AM To: gekkoman; Poulter, Dale; rt-users@lists.bestpractical.com Subject: RES: Re: [rt-users] RES: Sphinx fulltext index v4.0.4 Tarek, I already tried migrate from Mysql 5.1 to postgreSQL 9.1 but I had some problems quith some charset. Some records in Attachments table (from users that send an email in 8859-1) don't get converted to utf8 and I get the strange character with letter I with acute, like í looking to  (there's a space after Â, hidden or not). I don't know fix that, do you know any way to do that? I even used sed command, but it don't remove the space or whatever this is. Dale, SPHINX: I'm thing theirs is a problem with perl module DBIx::SearchBuilder, mine is 1.61, but can't connect to localhost port 3312. I tested searchd daemon and is working OK. Dale, what version of DBIx::SearchBuilder are you using? Luciano -Mensagem original- De: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Em nome de gekkoman Enviada em: quinta-feira, 5 de janeiro de 2012 19:02 Para: Poulter, Dale; rt-users@lists.bestpractical.com Assunto: [*SPAM*] Re: [rt-users] RES: Sphinx fulltext index v4.0.4 Greetings, FYI I got sphinx running on 4.04 by following instructions before Christmas and everything looked ok.but then I started discovering non functioning aspects of RT post the change eg changing user group memberships stopped working for example. The database was intact with no corruptions. This is obviously not ideal. I had debugged it to the point of finding some RT generated SQL no longer running properly on the database. Since I actually prefer psql over mysql I ended up migrated to psql using exactly the same dataset, engaged fulltext indexing and the problems all went away. Tarek Sounds like it cannot connect to the sphinx server. Can you confirm that sphinx is running (ps -eaf |grep searchd ) and that it is running on the port specified in the attachmentsindex create statement (mysql show create table AttachmentsIndex; )? I believe the default port is 9312 but the documents at http://blog.bestpractical.com/2011/06/full-text-searching.html indicate that the port is 3312. -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Luciano Ernesto da Silva Sent: Thursday, January 05, 2012 5:24 AM To: rt-users@lists.bestpractical.com Subject: [rt-users] RES: Sphinx fulltext index v4.0.4 Hello, I installed everything as described here by Dale/ documentation from docs/full_text_indexing.podc , documentarion by sphinxsearch but i got this error: RT: DBD::mysql::st execute failed: Unable to connect to foreign data source: failed to resolve searchd host (name=localhost) at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587. (/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587) Jan 5 08:45:16 rt4 RT: RT::Handle=HASH(0x7faacbf8ec58) couldn't execute the query 'SELECT COUNT(DISTINCT main.id) FROM Tickets main JOIN Transactions Transactions_1 ON ( Transactions_1.ObjectType = 'RT::Ticket' ) AND ( Transactions_1.ObjectId = main.id ) JOIN Attachments Attachments_2 ON ( Attachments_2.TransactionId = Transactions_1.id ) JOIN AttachmentsIndex AttachmentsIndex_3 ON ( AttachmentsIndex_3.id = Attachments_2.id ) WHERE (main.Status != 'deleted') AND (main.Queue = '23' AND ( AttachmentsIndex_3.query = 'ESEF;limit=1;maxmatches=1' ) ) AND (main.Type = 'ticket') AND (main.EffectiveId = main.id) ' at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600 The Mysql server is running on localhost and the firewall is off(Devel server) and SELINUX is disabled. DBIx::SearchBuilder is up to date. Any ideas? Luciano -Mensagem original- De: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Em nome de Luciano Ernesto da Silva Enviada em: sexta-feira, 30 de dezembro de
Re: [rt-users] rt-mailgate
pc request-tracker3.6 3.6.7-5+lenny6 Extensible trouble-ticket tracking system pc rt3.6-db-postgresql 3.6.7-5+lenny6 PostgreSQL database backend for request-trac p in first column means already marked for purging. c in second column means configuration files from those are still present try: dpkg --purge rt3.6-db-postgresql but it failed ...? www:/etc/ssl/certs# apt-get remove rt3.6-db-postgresql Reading package lists... Done Building dependency tree Reading state information... Done Package rt3.6-db-postgresql is not installed, so not removed 0 upgraded, 0 newly installed, 0 to remove and 48 not upgraded. www:/etc/ssl/certs# apt-get remove request-tracker3.6 Reading package lists... Done Building dependency tree Reading state information... Done Package request-tracker3.6 is not installed, so not removed 0 upgraded, 0 newly installed, 0 to remove and 48 not upgraded. --Mark RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
[rt-users] Article as replies (Markup)
Hi List, Running into a problem when using articles as a reply to a request. I have an article which contains HTML only which is stored in a Fill in one text area CustomField. This stores the article perfectly fine and presents it correctly when viewing the article in a browser, however.. When attaching the Article to a ticket reply, it appears to convert the content to Wiki markup (Even though the field is NOT a Fill in one wikitext area), destroying the markup entirely and enforcing a text content type. I have tried adding a Content-Type: text/html to the article head and this still produces the same result. I am hoping somebody else has successfully achieved this and can give any pointers as to the correct approach. RT Version: 4.0.4 Thanks Scott RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012