Ability to disable/override scrips per queue

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

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