Perl scripts?


#1

Hey all

I am writing a series of PERL script to help out our support people and I am
wondering if it is possible to search the body of a request for a given
string, and if so how, I am afraid I am not very familiar with mysql and
have been unable to find the information

thanks

eOinFrom: “Valerio Romano” vlove@mail1.xoom.com
To: “Adam Maurice” adam@live-networks.net
Cc: rt-users@lists.fsck.com
Sent: Thursday, November 09, 2000 12:05 AM
Subject: Re: [rt-users] Non-Queue Member Access etc.

Thanks many all.

Worked like a charm!

I had even read through that a week ago my first time around and now had
forgotten about it.

Valerio Romano
grasshopper

Hey.

Ive setup RT to the best of my knowledge correctly, yet I am having
trouble

creating tickets from users outside the members list.

When I send in a request, I get:

There has been an error:
There has been an error with your request:
You don’t have permission to create requests in this queue. Either
you’re

not a queue member or non-members aren’t allowed to create requests in
this

queue.

I have triple checked, and then triple checked again that the tickbox in
the queue admin window says:Allow non-members to create requests
– IT IS TICKED !!

Mysqldump shows:

CREATE TABLE queues (
queue_id char(40) DEFAULT ‘’ NOT NULL,
mail_alias char(40),
comment_alias char(40),
m_owner_trans int(11),
m_members_trans int(11),
m_user_trans int(11),
m_user_create int(11),
m_members_corresp int(11),
m_members_comment int(11),
m_user_resolve int(11),
allow_user_create int(11),
default_prio int(11),
default_final_prio int(11),
default_due_in int(11),
PRIMARY KEY (queue_id)
);

Dumping data for table ‘queues’

INSERT INTO queues VALUES

(‘LiveNet’,‘support@live-networks.net’,NULL,1,1,1,1,1,1,NULL,1,0,0,NULL);

It all looks fine to me, but it just aint working…

I’d be interested to hear any comments as I need to set this thing up
and

get it working asap.

Thanks very much in advance,

Yours sincerely,

-Adam Maurice


Adam Maurice, E-mail: adam@live-networks.co.uk
Executive Technical Director, Tel: +44 (0)20 8208 2425
Live-Networks Fax: +44 (0)20 8450 7744
Millenium Business Centre, Staples Corner, London NW2 6DW


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users


#2

In RT 1.0, you’ll need to run grep or glimpse over rt/transactions////
as the RT user.On Tue, Nov 14, 2000 at 06:15:59PM -0000, eOin wrote:

Hey all

I am writing a series of PERL script to help out our support people and I am
wondering if it is possible to search the body of a request for a given
string, and if so how, I am afraid I am not very familiar with mysql and
have been unable to find the information

thanks

eOin

----- Original Message -----
From: “Valerio Romano” vlove@mail1.xoom.com
To: “Adam Maurice” adam@live-networks.net
Cc: rt-users@lists.fsck.com
Sent: Thursday, November 09, 2000 12:05 AM
Subject: Re: [rt-users] Non-Queue Member Access etc.

Thanks many all.

Worked like a charm!

I had even read through that a week ago my first time around and now had
forgotten about it.

Valerio Romano
grasshopper

On Wed, 8 Nov 2000, Adam Maurice wrote:

Hey.

Ive setup RT to the best of my knowledge correctly, yet I am having
trouble

creating tickets from users outside the members list.

When I send in a request, I get:

There has been an error:
There has been an error with your request:
You don’t have permission to create requests in this queue. Either
you’re

not a queue member or non-members aren’t allowed to create requests in
this

queue.

I have triple checked, and then triple checked again that the tickbox in
the queue admin window says:Allow non-members to create requests
– IT IS TICKED !!

Mysqldump shows:

CREATE TABLE queues (
queue_id char(40) DEFAULT ‘’ NOT NULL,
mail_alias char(40),
comment_alias char(40),
m_owner_trans int(11),
m_members_trans int(11),
m_user_trans int(11),
m_user_create int(11),
m_members_corresp int(11),
m_members_comment int(11),
m_user_resolve int(11),
allow_user_create int(11),
default_prio int(11),
default_final_prio int(11),
default_due_in int(11),
PRIMARY KEY (queue_id)
);

Dumping data for table ‘queues’

INSERT INTO queues VALUES

(‘LiveNet’,‘support@live-networks.net’,NULL,1,1,1,1,1,1,NULL,1,0,0,NULL);

It all looks fine to me, but it just aint working…

I’d be interested to hear any comments as I need to set this thing up
and

get it working asap.

Thanks very much in advance,

Yours sincerely,

-Adam Maurice


Adam Maurice, E-mail: adam@live-networks.co.uk
Executive Technical Director, Tel: +44 (0)20 8208 2425
Live-Networks Fax: +44 (0)20 8450 7744
Millenium Business Centre, Staples Corner, London NW2 6DW


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

jesse reed vincent – root@eruditorum.orgjesse@fsck.com
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

Any e-mail sent to the SLA will immediately become the intellectual property
of the SLA and the author of said message will enter into a period of
indentured servitude which will last for a period of time no less than seven
years.