[rt-users] Ability to disable/override scrips per queue

[Dan O'Neill]

Kevin Murphy wrote:
> Has anybody used Dirk Pape's HideGlobalScrips patch with 3.4(.4) and 
> postgresql?

Yes. What question do you have?  HideGlobalScrips works quite well.

> I am very eager to have this ability, as I understand that the 
> alternative is to undefine the global scrips and redefine scrips for all 
> my 16 queues.  Blech.  I guess doing the latter programmatically would 
> be the way to go.

I suspect you're looking for the Postgresql scheme :->  Here's one 
better. It's the portion of my RT build recipe in which I install Dirk's 
patch.  Beware of bugs, I think this is all correct, but haven't 
installed for many months.

20. Add the HideGlobalScrips-1.0b1 patch from Dirk Pape found at
     http://page.mi.fu-berlin.de/~pape/rt3screenshots/

     cd /mp3/src/
     wget http://page.mi.fu-berlin.de/~pape/rt3/HideGlobalScrips.tgz
     tar xzvf HideGlobalScrips.tgz

     This needs some modifications before it can be used.

     20.1  Modify the schema for postgrest

           cd /mp3/src/HideGlobalScrips-1.0b1/etc
	  cat > schema.pg
CREATE SEQUENCE queuedeactivatedscrips_id_seq;

CREATE TABLE QueueDeactivatedScrips (
   id INTEGER DEFAULT nextval('queuedeactivatedscrips_id_seq'),
   QueueId INTEGER NOT NULL default 0,
   ScripId INTEGER NOT NULL default 0,
   Status varchar(15) NOT NULL default 'deactivated',
   Description varchar(255) default NULL,
   PRIMARY KEY  (id)
)

GRANT ALL PRIVILEGES ON queuedeactivatedscrips_id_seq TO postgres;
GRANT ALL PRIVILEGES ON queuedeactivatedscrips        TO postgres;

GRANT INSERT,SELECT,UPDATE,DELETE ON queuedeactivatedscrips_id_seq TO 
rt_user;
GRANT INSERT,SELECT,UPDATE,DELETE ON queuedeactivatedscrips        TO 
rt_user;



     20.2 Do a make install

          cd /mp3/src/HideGlobalScrips-1.0b1
	 make install



21.  Add in the Hide Configuration Tab patch found at
      http://wiki.bestpractical.com/cgi-bin/index.cgi?HideConfigurationTab

      cd /mp3/rt3
      mkdir -p local/html/Elements
      cp -p share/html/Elements/Tabs local/html/Elements/

     (follow the instructions for editing the new version of "Tab"
      as provided in the wiki page above)

---
good luck!

dano