[rt-users] Perl scripts ?

Jesse jesse at fsck.com
Tue Nov 14 13:21:14 EST 2000


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 at mail1.xoom.com>
> To: "Adam Maurice" <adam at live-networks.net>
> Cc: <rt-users at 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 at 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 at 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 at lists.fsck.com
> > http://lists.fsck.com/mailman/listinfo/rt-users
> >
> 
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 

-- 
jesse reed vincent -- root at eruditorum.org -- jesse at 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. 




More information about the rt-users mailing list