Login screen popping up after each request for a new screen

RT Users
1

Hi,

I posted this a few weeks ago, but I wasn’t able to follow up then.
Sorry for the repeat.

I’m using RT 3.0.12 on Windows 2000. Every time I switch screens, I’m
prompted to enter my username and password. This happens in IE6 only,
Firefox works great. I’ve tried changing cookie settings, and I’ve added
the RT server to the list of trusted sites, but that doesn’t help.

From what I remember, one person wrote back and said that I need to
change the perl scripts. If that’s the case, I have no idea how to do
that. Can I get specific instructions on where to look for the scripts,
and what lines of text need to be inserted into the scripts.

Thanks!

Jeff

Jeff Brooks-Manas - Sr. IT Coordinator
Raines, Melton & Carella, Inc.
2001 N. Main St., Suite 400
Walnut Creek, CA 94596

(925) 627-4136 (direct)
(925) 299-6733 (office)
(925) 299-6736 (fax)

jbrooks-manas@rmcengr.com
http://www.rmcengr.com

Innovative Solutions for Water and the Environment.

2

I’m using RT 3.0.12 on Windows 2000. Every time I switch screens, I’m
prompted to enter my username and password. This happens in IE6 only,
Firefox works great. I’ve tried changing cookie settings, and I’ve added
the RT server to the list of trusted sites, but that doesn’t help.

Check your IE6 security zone settings, you’re probably still blocking
cookies (e.g. are you using a popup blocker?)

-- Niels.
3

Thanks for your reply.

I’m not blocking cookies, and I turned off the popup blocker. I’m not
getting cookies from that site for some reason.

Any other thoughts would be appreciated.

Thanks again!

JeffFrom: Niels Bakker [mailto:niels=rt@bakker.net]
Sent: Tuesday, October 12, 2004 4:16 AM
To: Jeff Brooks-Manas
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Login screen popping up after each request for a
new screen

I’m using RT 3.0.12 on Windows 2000. Every time I switch screens, I’m
prompted to enter my username and password. This happens in IE6 only,
Firefox works great. I’ve tried changing cookie settings, and I’ve
added
the RT server to the list of trusted sites, but that doesn’t help.

Check your IE6 security zone settings, you’re probably still blocking
cookies (e.g. are you using a popup blocker?)

-- Niels.

Jeff Brooks-Manas - Sr. IT Coordinator
Raines, Melton & Carella, Inc.
2001 N. Main St., Suite 400
Walnut Creek, CA 94596

(925) 627-4136 (direct)
(925) 299-6733 (office)
(925) 299-6736 (fax)

jbrooks-manas@rmcengr.com
http://www.rmcengr.com

Innovative Solutions for Water and the Environment.

4

I need to find a way to match the Users table to the Tickets table based
on the Requestor.

Currently I’ve got a nightly cronjob which compares people’s email
addresses to our ldap server and updates their department in RT (using
Users.Organzation field).

I do this so that I can use this with a php page that shows tickets
submitted by department. A simplified version of my mysql statement:
SELECT Tickets.id, Users.Organization
FROM Tickets, Users
WHERE Tickets.Creator = Users.id;

This works fairly well except for when IT staff create tickets for
people. Because this associates their Users.Id with Tickets.Creator.
This makes my tables associate tickets and departments by who created
it, not by who the requestor/s are.

I need a way to show this information based on who the Requestors
Organization (dept) is. When I browse around the tables, it isn’t clear
to me where the Users.id of the Requestor is stored.

When I look at Transactions I see some info like this (so the new user
is Users.id=10428):
id Ticket Type Field NewValue
64460 3026 AddWatcher Requestor 10428

But I’m not sure how to link it all up. So I guess what I’m looking for
is where the Requestor/s data is stored and how I can match a Ticket.id
to the Users.id of the Requestor.

Any ideas?

Thanks,
Mike

5

Use the RT perl API.On Tue, Feb 08, 2005 at 04:41:20PM -0800, Mike Patterson wrote:

I need to find a way to match the Users table to the Tickets table based
on the Requestor.

Currently I’ve got a nightly cronjob which compares people’s email
addresses to our ldap server and updates their department in RT (using
Users.Organzation field).

I do this so that I can use this with a php page that shows tickets
submitted by department. A simplified version of my mysql statement:
SELECT Tickets.id, Users.Organization
FROM Tickets, Users
WHERE Tickets.Creator = Users.id;

This works fairly well except for when IT staff create tickets for
people. Because this associates their Users.Id with Tickets.Creator.
This makes my tables associate tickets and departments by who created
it, not by who the requestor/s are.

I need a way to show this information based on who the Requestors
Organization (dept) is. When I browse around the tables, it isn’t clear
to me where the Users.id of the Requestor is stored.

When I look at Transactions I see some info like this (so the new user
is Users.id=10428):
id Ticket Type Field NewValue
64460 3026 AddWatcher Requestor 10428

But I’m not sure how to link it all up. So I guess what I’m looking for
is where the Requestor/s data is stored and how I can match a Ticket.id
to the Users.id of the Requestor.

Any ideas?

Thanks,
Mike

The rt-users Archives

RT Administrator and Developer training is coming to your town soon!
(Boston, San Francisco, Austin, Sydney) Contact training@bestpractical.com
for details.

Be sure to check out the RT Wiki at http://wiki.bestpractical.com