[rt-users] Article as replies (Markup)

[Scott Horsley]

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

Re: [rt-users] rt-mailgate

[Allen]

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

Re: [rt-users] RES:RE: Re: RES: Sphinx fulltext index v4.0.4

[gekkoman]

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 orig

[rt-users] Due Date not setting correctly

[David Hollinger]

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] rt-mailgate

[Mark Story]

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

Re: [rt-users] rt-mailgate

[Mark Story]

> 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

[Mark Story]

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] No Delete option on 3.8.8

[Kevin Falcone]

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__', '',
> '__Requestors__', '__CreatedRelative__',
> '__ToldRelative__', '__LastUpdatedRelative__',
> '__TimeLeft__' 
> 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  
> >> >> > 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
> >> >> >

Re: [rt-users] No Delete option on 3.8.8

[martinmoore]

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__', '',
'__Requestors__', '__CreatedRelative__',
'__ToldRelative__', '__LastUpdatedRelative__',
'__TimeLeft__'   
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  
>> >> > 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.nabbl

[rt-users] RES: RES: RES: Re: RES: Sphinx fulltext index v4.0.4

[Luciano Ernesto da Silva]

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] RES: RES: Re: RES: Sphinx fulltext index v4.0.4

[Jeff Blaine]

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: Re: RES: Sphinx fulltext index v4.0.4

[Luciano Ernesto da Silva]

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

[rt-users] RES:RE: Re: RES: Sphinx fulltext index v4.0.4

[Luciano Ernesto da Silva]

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

[rt-users] Apache2.2 won't start at boot. RT4.0.4 on debian 6

[Glenn McNeill]

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:


 ### 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"
 
  Order allow,deny
  Allow from all

  SetHandler modperl
  PerlResponseHandler Plack::Handler::Apache2
  PerlSetVar psgi_app /opt/rt4/sbin/rt-server
 
 
  use Plack::Handler::Apache2;
  Plack::Handler::Apache2->preload("/opt/rt4/sbin/rt-server");
 



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

Re: [rt-users] No Delete option on 3.8.8

[Kevin Falcone]

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  
> >> > 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


pgp1

Re: [rt-users] RES: Re: RES: Sphinx fulltext index v4.0.4

[Jeff Blaine]

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

[martinmoore]

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  
>> > 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] No Delete option on 3.8.8

[Kevin Falcone]

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  
> > 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] RES: Sphinx fulltext index v4.0.4

[Poulter, Dale]

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 \
> -DDE

[rt-users] RES: Re: RES: Sphinx fulltext index v4.0.4

[Luciano Ernesto da Silva]

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';
>
> mysql>s elect * from mysql.plugin;
>
> This should indicated that

Re: [rt-users] No Delete option on 3.8.8

[martinmoore]

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  
> 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

Re: [rt-users] No Delete option on 3.8.8

[Raphaël MOUNEYRES]

you probably need to clear mason cache before restarting apache

rm -rf /opt/rt3/var/mason_data/obj

Raphaël MOUNEYRES




martinmoore  
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] Allow unprivileged users to search

[Iulian Dragan]

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] RT 3.8.11 and AT 2.0.0b upgrade or uninstall and install fresh

[Darin Perusich]

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
 

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] No Delete option on 3.8.8

[martinmoore]

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] Problems with an SLA Scrip I created

[Robert Wysocki]

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