Ability to disable/override scrips per queue

RT Users
1

Has anybody used Dirk Pape’s HideGlobalScrips patch with 3.4(.4) and
postgresql?

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’ve googled lists.fsck.com and wiki.bestpractical.com for this issue
and really haven’t found very much.

Thanks,
Kevin Murphy

2

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.

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

  1. Add in the Hide Configuration Tab patch found at
    Request Tracker Wiki

    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