Re: [rt-users] Browser (Firefox) does not save username and passwords
Hi, I'm running rt in dev mode (Set($DevelMode, '1');) for setting it up, so cache is not used anyway... -Ursprüngliche Nachricht- Von: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Im Auftrag von Emmanuel Lacour Gesendet: Mittwoch, 5. Januar 2011 15:05 An: rt-users@lists.bestpractical.com Betreff: Re: [rt-users] Browser (Firefox) does not save username and passwords On Wed, Jan 05, 2011 at 02:17:49PM +0100, Obando, David DE - EV wrote: I already change the code (Elements/Login) and removed the autocomplete=off parameter, but browser behaviour does not change. Any ideas? did you cleaned-up the mason cache? rm -rf ./rt/var/mason_data/obj then restart your web server.
Re: [rt-users] Custom field queries are very slow after 3.8.8 upgrade (from 3.6.10)
On Thu, Jan 06, 2011 at 01:50:19PM +0900, Georgi Georgiev wrote:
Quoting Kenneth Marshall at 05/01/2011-08:14:10(-0600):
On Wed, Jan 05, 2011 at 07:31:37PM +0900, Georgi Georgiev wrote:
I am looking for some advice on how to speed up some queries using
custom fields that got unusably slow after an upgrade from the RT 3.6
series
to 3.8.
We are currently running RT 3.6.10 on CentOS 5.5 with a postgresql
back end (used to be PgSQL 8.1 but we upgraded to 8.4 when CentOS 5.5
came out). The RT package is from EPEL and everything is fine.
When trying to upgrade to RT 3.8.8 some of our saved queries using
custom fields get very, *very* slow. I tried this twelve months ago with
RT 3.8.7 on CentOS 5.x and PgSQL 8.1 (whatever was current then), and
also again today, on RHEL6 with PgSQL 8.4.
The problematic queries look something like this:
Queue = 'somequeue' AND Status = 'stalled' AND (
'CF.{MyCF}' = 'value1' OR
'CF.{MyCF}' = 'value2' OR
'CF.{MyCF}' = 'value3' OR
'CF.{MyCF}' = 'value4' OR
'CF.{MyCF}' = 'value5' OR
'CF.{MyCF}' = 'value6' OR
'CF.{MyCF}' = 'value7' )
where the listed values are 3-4 characters long and their number varies.
After the ugprade, and with logging of slow queries enabled, I saw these
numbers for queries with 5, 6, 7, and 8 OR statements for the custom
field in the postgresql logs:
- query for 5 possible CF values - 0.6 seconds
- query for 6 possible CF values - 6 seconds
- query for 7 possible CF values - 65 seconds
- query for 8 possible CF values - 681 seconds
In comparison, the corresponding query in RT 3.6 executes in less than 2
milliseconds.
One thing I noticed is that the SQL that is generated by RT 3.6 and 3.8
is substantially different.
In 3.6 there is a single SELECT on the ObjectCustomFieldValues table, so
the generated SQL looks like this:
SELECT DISTINCT main.*
FROM Tickets main
JOIN ObjectCustomFieldValues ObjectCustomFieldValues_1
ON ( ObjectCustomFieldValues_1.CustomField = '1' )
AND ( ObjectCustomFieldValues_1.ObjectType = 'RT::Ticket' )
AND ( ObjectCustomFieldValues_1.Disabled = '0' )
AND ( ObjectCustomFieldValues_1.ObjectId = main.id )
WHERE (main.Status != 'deleted')
AND (main.Queue = '11' AND main.Status = 'stalled' AND
(
( ( ObjectCustomFieldValues_1.Content = 'value1' ) )
OR ( ( ObjectCustomFieldValues_1.Content = 'value2' ) )
...
)
)
AND (main.Type = 'ticket')
AND (main.EffectiveId = main.id)
ORDER BY main.id ASC
In RT 3.8.8 the generated SQL looks like this:
SELECT DISTINCT main.*
FROM Tickets main
LEFT JOIN ObjectCustomFieldValues ObjectCustomFieldValues_1
ON ( ObjectCustomFieldValues_1.CustomField = '1' )
AND ( ObjectCustomFieldValues_1.ObjectType = 'RT::Ticket' )
AND ( ObjectCustomFieldValues_1.Disabled = '0' )
AND ( ObjectCustomFieldValues_1.ObjectId = main.id )
LEFT JOIN ObjectCustomFieldValues ObjectCustomFieldValues_2
ON ( ObjectCustomFieldValues_2.CustomField = '1' )
AND ( ObjectCustomFieldValues_2.ObjectType = 'RT::Ticket' )
AND ( ObjectCustomFieldValues_2.Disabled = '0' )
AND ( ObjectCustomFieldValues_2.ObjectId = main.id )
WHERE (main.Status != 'deleted')
AND (
main.Queue = '11' AND main.Status = 'stalled' AND
(
( ( ( ObjectCustomFieldValues_1.Content = 'value1' ) ) )
OR ( ( ( ObjectCustomFieldValues_2.Content = 'value2' ) ) )
)
)
AND (main.Type = 'ticket')
AND (main.EffectiveId = main.id)
ORDER BY main.id ASC
I ran the queries through explain analyze and tried disabling nested
loops, then disabling hash joins (I tried disabling whatever the planner
was trying to use hoping it will try something else that is faster) but
the query speed did not change considerably.
Our database is not that big and can easily fit in the memory of the
machine (400MB filesize), and we have less than 6000 tickets total. The
queries I tried out return only a total of 4 to 5 tickets in the end. The
custom field that I am referring to above is a mandatory field so it is
assigned for almost all tickets, and with multiple values most of the
time.
Any advice?
Hi Georgi,
What are your postgresql.conf parameters?
What are the EXPLAIN ANALYZE results for the fast query (3.6.x) and
the slow (3.8.8) query? That should also point out where an index may
help.
Thanks for the pointers, Kenneth.
We actually haven't touched postgresql.conf at all. The defaults have
worked fine for our small postgresql installation thus far and I just
didn't know where I should look next - in RT or postgres. Here is our
postgresql.conf (it's the default one on the distro) and it is identical
on RHEL6 and CentOS 5.5.
max_connections = 100
shared_buffers = 32MB
logging_collector = on
log_directory = 'pg_log'
Re: [rt-users] RTx::Calendar Not Displaying
On Wed, Jan 05, 2011 at 09:09:44AM -0800, Lee Hughes wrote: MyCalendar is included in $HomepageComponents (below) but nothing related to Calendar appears on the homepage. In fact, if I comment out the $HomepageComponents line completely and restart the web server, the homepage still looks the same, even if I clear my browser cache. How could that be? Just adding it to HomepageComponents doesn't make it show up on your homepage, it makes it available. You need to click on Preferences - RT at a Glance -kevin I have the ExternalAuth plugin configured in the same RT_SiteConfig.pm file (below) and it is working fine. Search on Calendar and calendar shows no results. Are there any screenshots of what the Calendar links/pages should look like? Is it possible to insert debug statements somewhere to verify that the Calendar plugin is actually getting called? Thanks very much for the help. Lee Date: Tue, 4 Jan 2011 17:18:23 -0500 From: Kevin Falcone falc...@bestpractical.com To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] RTx::Calendar Not Displaying Message-ID: 20110104221823.gv65...@jibsheet.com Content-Type: text/plain; charset=us-ascii On Tue, Jan 04, 2011 at 12:44:51PM -0800, Lee Hughes wrote: I cleared the Mason cache but still don't see any Calendar links. Where should I see links, and how would I go about enabling basic tracing to see if the Calendar module is even being called? You didn't say where you looked for the calendars. Did you try editing your homepage to include the MyCalendar widget? Did you do a search and look for the calendar link? -kevin I've installed and configured RTx::Calendar per the instructions and restarted the web server but don't see any links to it anywhere. I have syslogging set to debug but no errors are logged. Here are the relevant settings from RT_SiteConfig.pm: # Calendar Plugin require '/usr/local/rt3/local/plugins/RTx-Calendar/lib/RTx/Calendar.pm'; Set($HomepageComponents, [qw(QuickCreate Quicksearch MyCalendar MyAdminQueues MySupportQueues MyReminders RefreshHomepage)]); # enable all plugins Set(@Plugins,qw( RT::Authen::ExternalAuth RTx::Calendar )); Any ideas what I'm missing? Did you clear the Mason cache? rm -rf /usr/local/rt3/var/mason_data/obj/* See http://requesttracker.wikia.com/wiki/CleanMasonCache for details. pgpKKgjhE2Qk3.pgp Description: PGP signature
Re: [rt-users] attachment and This transaction appears to have no content
On Wed, Jan 05, 2011 at 10:48:21PM +0500, Rana Tanveer wrote: I am using RT 3.8.7, my problem is when we send attachment it returns following message to requesters of the tickets along with attachment. This transaction appears to have no content and normal communication is fine, this happens only when any of the requester or AdminCC of the queue send attachment, can someone please help regarding this issue as i am clueless reading mailing lists. You really need to specify which Scrip is triggering this email and the template it is using -kevin pgpNp7lZwQDFq.pgp Description: PGP signature
Re: [rt-users] Not the spell fckeditor when creating a ticket
On Wed, Jan 05, 2011 at 12:28:30PM +0100, jose.fernan...@naxos-fr.net wrote: when creating a ticket, the spell checker button is disabled fckeditor. How to enable this button? RT doesn't actually ship the php spellchecker that fckeditor provides. We recommend that you use the spellchecker built into your browser. -kevin pgpHuOAAWo3Sx.pgp Description: PGP signature
Re: [rt-users] RT-Authen-ExternalAuth and AD...
On Wed, Jan 05, 2011 at 03:29:01PM -0600, Tollefsen, Lyle wrote: We're running RT 3.8.8 and using RT-Authen-ExternalAuth 0.08 to authenticate against Active Directory. Any new AD account I create can logon to RT, and have corresponding account created in RT, if it is in the necessary security group, but older accounts, mine included, pass the password test, but fail at the group membership test, and fail to logon. The RT account, however, does get created. The log entries look like this... If you turn on debug logging, you should be able to see the query being run and you can run it manually from ldapsearch to see what is going wrong. -kevin Jan 5 15:12:29 RT388 RT: AD_GROUP2 AUTH FAILED: my-name (/opt/rt3/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/LDAP.pm:127) Jan 5 15:12:29 RT388 RT: FAILED LOGIN for my-name from 192.168.1.1 (/opt/rt3/bin/../lib/RT/Interface/Web.pm:424) As I said above, older accounts (3 years plus) which are members of the group being tested fail to fully authenticate, while new accounts which are members of the same group, authenticate properly. In fact, If I comment out the group test from RT_SiteConfig.pm, I can logon to RT with my old account. I don't know if this is pertinent, but we upgraded to Exchange 2007 a few months back, and I wonder if the AD schema changes could be affecting things? Lyle. pgpWvL0eGiaak.pgp Description: PGP signature
Re: [rt-users] Disallow 'resolve' unless a CF is set?
Jeff, Actually, yes, please do provide details if you would. One would also need to make mods to Modify.html as well, no? As far as I can tell Update.html called for the Resolve *link* but there are other ways to resolve a ticket. Jeff Blaine On 1/5/2011 4:33 PM, Jeff Stark wrote: Because we only require the CF on resolve and at no other time I hacked the update page when status = resolved. I have seen others put scrips in place that set the status back to open but this didn't work for us, as we didn't want the ticket to appear to be resolved (submitted), we wanted to remain on the same page with the typical feedback. Would be really nice if there was a way to add logic like that to the CF. Good luck, and let me know if you need additional info on how I did this. Jeff Stark Sr Saas Engineer Moxie Software (919)622-0418 jst...@moxiesoft.com Www.Moxiesoft.com CONNECT PEOPLE. SHARE KNOWLEDGE. DELIVER RESULTS. -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Jeff Blaine Sent: Wednesday, January 05, 2011 2:03 PM To: rt-users@lists.bestpractical.com Subject: [rt-users] Disallow 'resolve' unless a CF is set? We need to reject 'resolve' actions unless a certain custom field is set to a value. Is there a known solution for this, or should I start hacking?
Re: [rt-users] Scrip modifies ticket, but downstream scrips don't see the updates
Hot dig! Changing the second scrip to TransactionBatch did indeed work. Thank you! Now I just have to translate the new owner's id into their user name, and I'll be set. -- Sue Kenneth Crocker wrote: Sue, Try changing the stage to TransactionBatch. Make sure your configuration is set to use same. Then, you need to be sure the names of the scrips a such that an alphabetical execution of them will execute the scrip that assigns the owners first. Kenn LBNL On Wed, Jan 5, 2011 at 12:46 PM, Sue D. Nymme sdn.old...@mailnull.comwrote: ... -- View this message in context: http://old.nabble.com/Scrip-modifies-ticket%2C-but-downstream-scrips-don%27t-see-the-updates-tp30599938p30605822.html Sent from the Request Tracker - User mailing list archive at Nabble.com.
Re: [rt-users] RTx::Calendar Not Displaying
Enabling MyCalendar under Preferences RT at a Glance, and fixing missing file/directory permissions for the plugin, did the trick. Calendar now displays on RT at a Glance (Home) and Edit Query Advanced Calendar. Thanks very much for everyone's help. Lee MyCalendar is included in $HomepageComponents (below) but nothing related to Calendar appears on the homepage. In fact, if I comment out the $HomepageComponents line completely and restart the web server, the homepage still looks the same, even if I clear my browser cache. How could that be? Just adding it to HomepageComponents doesn't make it show up on your homepage, it makes it available. You need to click on Preferences - RT at a Glance -kevin I have the ExternalAuth plugin configured in the same RT_SiteConfig.pm file (below) and it is working fine. Search on Calendar and calendar shows no results. Are there any screenshots of what the Calendar links/pages should look like? Is it possible to insert debug statements somewhere to verify that the Calendar plugin is actually getting called? Thanks very much for the help. Lee Date: Tue, 4 Jan 2011 17:18:23 -0500 From: Kevin Falcone falc...@bestpractical.com To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] RTx::Calendar Not Displaying Message-ID: 20110104221823.gv65...@jibsheet.com Content-Type: text/plain; charset=us-ascii On Tue, Jan 04, 2011 at 12:44:51PM -0800, Lee Hughes wrote: I cleared the Mason cache but still don't see any Calendar links. Where should I see links, and how would I go about enabling basic tracing to see if the Calendar module is even being called? You didn't say where you looked for the calendars. Did you try editing your homepage to include the MyCalendar widget? Did you do a search and look for the calendar link? -kevin I've installed and configured RTx::Calendar per the instructions and restarted the web server but don't see any links to it anywhere. I have syslogging set to debug but no errors are logged. Here are the relevant settings from RT_SiteConfig.pm: # Calendar Plugin require '/usr/local/rt3/local/plugins/RTx-Calendar/lib/RTx/Calendar.pm'; Set($HomepageComponents, [qw(QuickCreate Quicksearch MyCalendar MyAdminQueues MySupportQueues MyReminders RefreshHomepage)]); # enable all plugins Set(@Plugins,qw( RT::Authen::ExternalAuth RTx::Calendar )); Any ideas what I'm missing? Did you clear the Mason cache? rm -rf /usr/local/rt3/var/mason_data/obj/* See http://requesttracker.wikia.com/wiki/CleanMasonCache for details.
Re: [rt-users] attachment and This transaction appears to have no content
I am using Correspondence template and On Correspond Notify Requestors and Ccshttps://ticket.team-kh.qualityprogrammers.com/Admin/Global/Scrip.html?id=6Queue=0 scrip. ** Rana Tanveer
Re: [rt-users] attachment and This transaction appears to have no content
This is because it is only set up to 'notify' - Same thing here when I give a ticket to a user I receive (Notify) an email: Wed Dec 31 17:00:00 1969: Request TicketID was acted upon. Transaction: Given to User1 by User2 Queue: QueueName Subject: Subject Owner: User Requestors: Requestor Email Status: Status Ticket URL: URL This transaction appears to have no content Or is this not what you are doing. Kris Germann Supervisor, Sales Technical Support Fibernetics Corporation freephoneline.ca 605 Boxwood Drive Cambridge ON, N3E1A5 From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Rana Tanveer Sent: Thursday, January 06, 2011 1:14 PM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] attachment and This transaction appears to have no content I am using Correspondence template and On Correspond Notify Requestors and Ccs https://ticket.team-kh.qualityprogrammers.com/Admin/Global/Scrip.html?id=6; Queue=0 scrip. Rana Tanveer
Re: [rt-users] attachment and This transaction appears to have no content
Also make sure you have RT-Attach-Message: yes and {$Transaction-Content()}
set.
Kris Germann
Supervisor, Sales Technical Support
Fibernetics Corporation
freephoneline.ca
605 Boxwood Drive
Cambridge ON, N3E1A5
From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Kris Germann
Sent: Thursday, January 06, 2011 1:26 PM
To: 'Rana Tanveer'; rt-users@lists.bestpractical.com
Subject: Re: [rt-users] attachment and This transaction appears to have no
content
This is because it is only set up to 'notify' - Same thing here when I give
a ticket to a user I receive (Notify) an email:
Wed Dec 31 17:00:00 1969: Request TicketID was acted upon.
Transaction: Given to User1 by User2
Queue: QueueName
Subject: Subject
Owner: User
Requestors: Requestor Email
Status: Status
Ticket URL: URL
This transaction appears to have no content
Or is this not what you are doing.
Kris Germann
Supervisor, Sales Technical Support
Fibernetics Corporation
freephoneline.ca
605 Boxwood Drive
Cambridge ON, N3E1A5
From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Rana Tanveer
Sent: Thursday, January 06, 2011 1:14 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] attachment and This transaction appears to have no
content
I am using Correspondence template and On Correspond Notify Requestors and
Ccs
https://ticket.team-kh.qualityprogrammers.com/Admin/Global/Scrip.html?id=6;
Queue=0 scrip.
Rana Tanveer
Re: [rt-users] Scrip modifies ticket, but downstream scrips don't see the updates
There's also some actions, like Notify, that read their data in prepare, so any changes done in commit won't be seen. Been bitten. -- Mathieu Longtin 1-514-803-8977 On Thu, Jan 6, 2011 at 11:39 AM, Sue D. Nymme sdn.old...@mailnull.comwrote: Hot dig! Changing the second scrip to TransactionBatch did indeed work. Thank you! Now I just have to translate the new owner's id into their user name, and I'll be set. -- Sue Kenneth Crocker wrote: Sue, Try changing the stage to TransactionBatch. Make sure your configuration is set to use same. Then, you need to be sure the names of the scrips a such that an alphabetical execution of them will execute the scrip that assigns the owners first. Kenn LBNL On Wed, Jan 5, 2011 at 12:46 PM, Sue D. Nymme sdn.old...@mailnull.comwrote: ... -- View this message in context: http://old.nabble.com/Scrip-modifies-ticket%2C-but-downstream-scrips-don%27t-see-the-updates-tp30599938p30605822.html Sent from the Request Tracker - User mailing list archive at Nabble.com.
Re: [rt-users] attachment and This transaction appears to have no content
On Thu, Jan 6, 2011 at 11:31 PM, Kris Germann kris_germ...@295.ca wrote:
Also make sure you have RT-Attach-Message: yes and
{$Transaction-Content()} set.
Yes same as below.
Content-Type: text/html
RT-Attach-Message: Yes
{$Transaction-Content()}
This is because it is only set up to ‘notify’ – Same thing here when I give
a ticket to a user I receive (Notify) an email:
I am not doing this...it happens during normal correspondence when any of
requestor send attachment.
Wed Dec 31 17:00:00 1969: Request TicketID was acted upon.
Transaction: Given to User1 by User2
Queue: QueueName
Subject: Subject
Owner: User
Requestors: Requestor Email
Status: Status
Ticket URL: URL
This transaction appears to have no content
Or is this not what you are doing…
Yes this is not i am doing.
Re: [rt-users] Communicate a message to web UI from inside Scrip?
On Thu, Jan 06, 2011 at 01:10:47PM -0500, Jeff Blaine wrote: Is there a way to queue one of these notices to the user from within my Scrip? ERROR: Cannot resolve without a value for BlahBlah. Unfortunately, no. -kevin pgp0auEXCHplx.pgp Description: PGP signature
Re: [rt-users] Communicate a message to web UI from inside Scrip?
More user friendly way to go is to prevent action right in the ui. Look at mandatory subject extention as example. Regards, Ruslan. From phone. 06.01.2011 21:11 пользователь Jeff Blaine jbla...@kickflop.net написал: As part of my current solution (ongoing) to the Don't allow resolve if a certain CF is not set topic, I am resetting the ticket status back to open when I see that someone tried to resolve while the specific CF was not set. Unfortunately, even though my code set the status back to open, the BriefMessage on the transaction still says that the status went from open to resolved ... yet the ticket shows properly *as open still*. Is there a way to queue one of these notices to the user from within my Scrip? ERROR: Cannot resolve without a value for BlahBlah.
Re: [rt-users] Copy Multiple value CF to the child ticket
I am using version 3.8.4 so CustomFieldValuesAsString is not available.
I changed the template like this:
CustomField-n: {
my $separator = \n;
my $CFValue = $Tickets{'TOP'}-CustomFieldValues(n);
return join ($separator, grep { defined $_ }
map { $_-Content }
@{$CFValue-ItemsArrayRef});
}
To get the values as strings but it still not working, Am I doing
something wrong or is there any extension available for
'CustomFieldValuesAsString' method?
Thanks
N Ahmed
-Original Message-
From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Kevin
Falcone
Sent: Tuesday, January 04, 2011 5:03 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Copy Multiple value CF to the child ticket
On Tue, Jan 04, 2011 at 03:19:45PM -0500, Ahmed, Mohammed Naweed
(LNG-BCT) wrote:
I am creating a child ticket with some of the custom fields
populated from the parent ticket.
I know that we can copy the values of the parent CF to the child CF
by:
CustomField-n: {$Tickets{'TOP'}-FirstCustomFieldValue('CF Name')}
But, how to copy multiple-value CF to the child ticket? The above
code is just populating the
first selected value.
Given a new enough RT, CustomFieldValuesAsString will work
-kevin
-
The information contained in this e-mail message is intended only
for the personal and confidential use of the recipient(s) named
above. This message may be an attorney-client communication and/or
work product and as such is privileged and confidential. If the
reader of this message is not the intended recipient or an agent
responsible for delivering it to the intended recipient, you are
hereby notified that you have received this document in error and
that any review, dissemination, distribution, or copying of this
message is strictly prohibited. If you have received this
communication in error, please notify us immediately by e-mail, and
delete the original message.
Re: [rt-users] attachment and This transaction appears to have no content
Not clear who sends attachment and how (ui or mail). If message is empty and there is only an attachment then sure transaction has no content. Regards, Ruslan. From phone. 05.01.2011 20:57 пользователь Rana Tanveer ranatanv...@gmail.com написал: Hi Community. I am using RT 3.8.7, my problem is when we send attachment it returns following message to requesters of the tickets along with attachment. This transaction appears to have no content and normal communication is fine, this happens only when any of the requester or AdminCC of the queue send attachment, can someone please help regarding this issue as i am clueless reading mailing lists. *LAHORE LIONS* Rana Tanveer
[rt-users] Restoring data after a system crash
Today we had a disk crash of my mysql server. After I restored the machine (from Dec 31), I then tried to restore the nightly backup of the mysql data itself. It *almost* worked. ... the backup of the data is done using mysqlhotcopy, tar the copy, then scp over to another computer. All but 1 of my tables seems to have restored. What I did was (1) copy the tar file to the restored server (2) untar the hotcopy into /tmp/restored (3) stop mysql, (4) copy the tables (directories) from /tmp/restored to /var/lib/mysql (5) restart mysql. All but 1 of the databases is now using the restored data. The database that did not restore is (the reason I am asking here) the RT database. For that 1 database, when I look at the contents I get the data from Dec 31 (not last night). Ideas? -- Chris Barnes AOL IM: CNBarnes chris-bar...@tamu.eduYahoo IM: chrisnbarnes Computer Systems Manager MSN IM: ch...@txbarnes.com Department of Physics ph: 979-845-1379 Texas AM University fax: 979-845-2590
Re: [rt-users] RT-Authen-ExternalAuth and AD...
Hi Kevin, Thanks for the reply. Your suggestions led to finding the problem, but not the fix. As I originally said, the username:password combo would work only if not testing for group membership, it would fail if it did test for membership. An ldapearch revealed that the sAMAccountName was fine, but, as the fullname in our AD is Last, first, the CN would be returned as Last\, First'. If we renamed the account to Last First, omitting the comma, authentication using group membership succeded. The comma is breaking something. Have you seen this before, and is a fix available? Thanks. Lyle Tollefsen Network Administrator Innovation Place 114 - 15 Innovation Blvd Saskatoon, Sk. S7N 2X8 (P) 306-933-7243 (F) 306.933.8200 ltollef...@innovationplace.com www.innovationplace.com -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Kevin Falcone Sent: Thursday, January 06, 2011 10:18 AM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] RT-Authen-ExternalAuth and AD... On Wed, Jan 05, 2011 at 03:29:01PM -0600, Tollefsen, Lyle wrote: We're running RT 3.8.8 and using RT-Authen-ExternalAuth 0.08 to authenticate against Active Directory. Any new AD account I create can logon to RT, and have corresponding account created in RT, if it is in the necessary security group, but older accounts, mine included, pass the password test, but fail at the group membership test, and fail to logon. The RT account, however, does get created. The log entries look like this... If you turn on debug logging, you should be able to see the query being run and you can run it manually from ldapsearch to see what is going wrong. -kevin Jan 5 15:12:29 RT388 RT: AD_GROUP2 AUTH FAILED: my-name (/opt/rt3/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalA uth/LDAP.pm:127) Jan 5 15:12:29 RT388 RT: FAILED LOGIN for my-name from 192.168.1.1 (/opt/rt3/bin/../lib/RT/Interface/Web.pm:424) As I said above, older accounts (3 years plus) which are members of the group being tested fail to fully authenticate, while new accounts which are members of the same group, authenticate properly. In fact, If I comment out the group test from RT_SiteConfig.pm, I can logon to RT with my old account. I don't know if this is pertinent, but we upgraded to Exchange 2007 a few months back, and I wonder if the AD schema changes could be affecting things? Lyle.
[rt-users] RT 4.0rc1 install error
Hello, I'm installing a 4.0rc1 instance for test purposes. All steps when fine but when restarting apache i get this error: Can't locate /opt/rt4/bin/webmux.pl in @INC (@INC contains: /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.7/i386-linux-thread-multi My apache setup is this (same as running 3.6: VirtualHost *:80 DocumentRoot /opt/rt4/share/html ErrorLog logs/rt PerlRequire /opt/rt4/bin/webmux.pl Location /NoAuth/images SetHandler default /Location Directory /opt/rt4/share/html Order allow,deny Allow from all SetHandler perl-script PerlResponseHandler RT::Mason /Directory /VirtualHost Thanks! Seb.-
Re: [rt-users] RT 4.0rc1 install error
On 06 Jan 2011 16:32, seb...@gmail.com wrote: Hello, I'm installing a 4.0rc1 instance for test purposes. All steps when fine but when restarting apache i get this error: Can't locate /opt/rt4/bin/webmux.pl in @INC (@INC contains: /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.7/i386-linux-thread-multi Read the error message. That file doesn't exist anymore. You should read docs/web_deployment.pod and update your Apache config. Thomas
Re: [rt-users] RT 4.0rc1 install error
On Thu, Jan 06, 2011 at 06:32:02PM -0300, seb...@gmail.com wrote: Hello, I'm installing a 4.0rc1 instance for test purposes. All steps when fine but when restarting apache i get this error: Can't locate /opt/rt4/bin/webmux.pl in @INC (@INC contains: /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.7/i386-linux-thread-multi My apache setup is this (same as running 3.6: Please have a look through the README when upgrading. It points to the new deployment documentation. That is not a valid apache config for 4.0. -kevin VirtualHost *:80 DocumentRoot /opt/rt4/share/html ErrorLog logs/rt PerlRequire /opt/rt4/bin/webmux.pl Location /NoAuth/images SetHandler default /Location Directory /opt/rt4/share/html Order allow,deny Allow from all SetHandler perl-script PerlResponseHandler RT::Mason /Directory /VirtualHost Thanks! Seb.- pgpDviD0uM6L4.pgp Description: PGP signature
Re: [rt-users] Communicate a message to web UI from inside Scrip?
On 1/6/2011 2:00 PM, Ruslan Zakirov wrote:
More user friendly way to go is to prevent action right in the ui. Look
at mandatory subject extention as example.
I completely agree.
Unfortunately it doesn't look very doable so far.
Here's what I've got to say after 4 hours.
Mandatory Subject Extension works because there's a clear
hook (and flag, $skip_create) available in the callback calls.
There are 2 places that we care about where resolving a ticket
can happen:
Update.html (via clicking the 'Resolve' action link)
Modify.html (via clicking 'Basics')
Oddity: Update.html redirects to Display.html on success.
Modify.html redisplays Modify.html on success.
Here are my notes (as comments) on these two files:
Modify.html
# This one doesn't even have a CallbackName (???)
# How do I make my own Callback? Proper path for that?
$m-callback( TicketObj = $TicketObj,
CustomFields = $CustomFields,
ARGSRef = \%ARGS );
Update.html
...
$m-callback( Ticket = $TicketObj, ARGSRef = \%ARGS,
results = \...@results, CallbackName = 'Initial' );
...
if ( !$checks_failure exists $ARGS{SubmitTicket} ) {
$m-callback( Ticket = $TicketObj, ARGSRef = \%ARGS,
CallbackName = 'BeforeDisplay' );
#
# All okay -- Complete jump to Display.html and not
# passing along @results, yet SOMEHOW Display.html
# shows what was performed. Mystery to me.
#
return $m-comp('Display.html', TicketObj = $TicketObj,
%ARGS);
}
# ELSE Update.html is called and shows the failed hardcoded
# checks*it* cared about.
#
# This blows, because if the hardcoded checks are okay
# (but not MY checks), we jump to a completely different
# page.
#
# What would work, I think, is if the Initial callback
# passed $checks_failure so that I could check what I
# wanted and set $checks_failure to 1 (and update @results)
# as I saw fit.
Along with all of that, I can't seem to get even a basic callback
working for the life of me.
I have tried all sorts of variations on the following, with
server restarts, and gotten nowhere:
/rt/local/html/Callbacks/MyCallbacks/Ticket/TheFile.html/TheCallbackName
Where TheFile.html is something like Update.html
Where TheCallbackName is something like Initial
Regards, Ruslan. From phone.
06.01.2011 21:11 пользователь Jeff Blaine jbla...@kickflop.net
mailto:jbla...@kickflop.net написал:
As part of my current solution (ongoing) to the Don't allow
resolve if a certain CF is not set topic, I am resetting
the ticket status back to open when I see that someone
tried to resolve while the specific CF was not set.
Unfortunately, even though my code set the status back to
open, the BriefMessage on the transaction still says
that the status went from open to resolved ... yet the
ticket shows properly *as open still*.
Is there a way to queue one of these notices to the user
from within my Scrip?
ERROR: Cannot resolve without a value for BlahBlah.
Re: [rt-users] RT-Authen-ExternalAuth and AD...
On Thu, Jan 06, 2011 at 03:22:03PM -0600, Tollefsen, Lyle wrote: Thanks for the reply. Your suggestions led to finding the problem, but not the fix. As I originally said, the username:password combo would work only if not testing for group membership, it would fail if it did test for membership. An ldapearch revealed that the sAMAccountName was fine, but, as the fullname in our AD is Last, first, the CN would be returned as Last\, First'. If we renamed the account to Last First, omitting the comma, authentication using group membership succeded. The comma is breaking something. Have you seen this before, and is a fix available? There may be an open bug about this in rt.cpan.org against RT::Authen::ExternalAuth , but I don't know if I've seen a root cause or patch. -kevin -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Kevin Falcone Sent: Thursday, January 06, 2011 10:18 AM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] RT-Authen-ExternalAuth and AD... On Wed, Jan 05, 2011 at 03:29:01PM -0600, Tollefsen, Lyle wrote: We're running RT 3.8.8 and using RT-Authen-ExternalAuth 0.08 to authenticate against Active Directory. Any new AD account I create can logon to RT, and have corresponding account created in RT, if it is in the necessary security group, but older accounts, mine included, pass the password test, but fail at the group membership test, and fail to logon. The RT account, however, does get created. The log entries look like this... If you turn on debug logging, you should be able to see the query being run and you can run it manually from ldapsearch to see what is going wrong. -kevin Jan 5 15:12:29 RT388 RT: AD_GROUP2 AUTH FAILED: my-name (/opt/rt3/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalA uth/LDAP.pm:127) Jan 5 15:12:29 RT388 RT: FAILED LOGIN for my-name from 192.168.1.1 (/opt/rt3/bin/../lib/RT/Interface/Web.pm:424) As I said above, older accounts (3 years plus) which are members of the group being tested fail to fully authenticate, while new accounts which are members of the same group, authenticate properly. In fact, If I comment out the group test from RT_SiteConfig.pm, I can logon to RT with my old account. I don't know if this is pertinent, but we upgraded to Exchange 2007 a few months back, and I wonder if the AD schema changes could be affecting things? Lyle. pgpeL2O9GHgKy.pgp Description: PGP signature
Re: [rt-users] Communicate a message to web UI from inside Scrip?
How about put a comment with your script in the ticket. The Ticket history would then look like this: * Status change from open to resolve * Comment: ERROR: Cannot resolve without a value for BlahBlah. * Status change from resolved to open I think this would make it clear for the user why they can't resolve the ticket. -Chris Am 06.01.2011 19:10, schrieb Jeff Blaine: As part of my current solution (ongoing) to the Don't allow resolve if a certain CF is not set topic, I am resetting the ticket status back to open when I see that someone tried to resolve while the specific CF was not set. Unfortunately, even though my code set the status back to open, the BriefMessage on the transaction still says that the status went from open to resolved ... yet the ticket shows properly *as open still*. Is there a way to queue one of these notices to the user from within my Scrip? ERROR: Cannot resolve without a value for BlahBlah.
Re: [rt-users] RT 4.0rc1 install error
Thanks guys, i did the changes, and now apache starts fine but i cant access the RT Web. error.log says: [Thu Jan 06 18:56:42 2011] [error] (1)Operation not permitted: mod_mime_magic: can't read magic file /opt/rt4/conf/magic [Thu Jan 06 18:56:42 2011] [notice] Digest: generating secret for digest authentication ... [Thu Jan 06 18:56:42 2011] [notice] Digest: done [Thu Jan 06 18:56:42 2011] [notice] mod_python: Creating 4 session mutexes based on 256 max processes and 0 max threads. [Thu Jan 06 18:56:42 2011] [error] (2)No such file or directory: could not create /opt/rt4/run/httpd.pid [Thu Jan 06 18:56:42 2011] [error] httpd: could not log pid to file /opt/rt4/run/httpd.pid On Thu, Jan 6, 2011 at 6:36 PM, Kevin Falcone falc...@bestpractical.com wrote: On Thu, Jan 06, 2011 at 06:32:02PM -0300, seb...@gmail.com wrote: Hello, I'm installing a 4.0rc1 instance for test purposes. All steps when fine but when restarting apache i get this error: Can't locate /opt/rt4/bin/webmux.pl in @INC (@INC contains: /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.7/i386-linux-thread-multi My apache setup is this (same as running 3.6: Please have a look through the README when upgrading. It points to the new deployment documentation. That is not a valid apache config for 4.0. -kevin VirtualHost *:80 DocumentRoot /opt/rt4/share/html ErrorLog logs/rt PerlRequire /opt/rt4/bin/webmux.pl Location /NoAuth/images SetHandler default /Location Directory /opt/rt4/share/html Order allow,deny Allow from all SetHandler perl-script PerlResponseHandler RT::Mason /Directory /VirtualHost Thanks! Seb.-
Re: [rt-users] Communicate a message to web UI from inside Scrip?
On 1/6/2011 4:57 PM, Christian Loos wrote: How about put a comment with your script in the ticket. The Ticket history would then look like this: * Status change from open to resolve * Comment: ERROR: Cannot resolve without a value for BlahBlah. * Status change from resolved to open That's exactly what I am trying to do :) I don't want to do it way down in the history though. The user should be notified at the top of the screen where normal operation status messages go. I think this would make it clear for the user why they can't resolve the ticket. -Chris Am 06.01.2011 19:10, schrieb Jeff Blaine: As part of my current solution (ongoing) to the Don't allow resolve if a certain CF is not set topic, I am resetting the ticket status back to open when I see that someone tried to resolve while the specific CF was not set. Unfortunately, even though my code set the status back to open, the BriefMessage on the transaction still says that the status went from open to resolved ... yet the ticket shows properly *as open still*. Is there a way to queue one of these notices to the user from within my Scrip? ERROR: Cannot resolve without a value for BlahBlah.
Re: [rt-users] RT 4.0rc1 install error
You really have more problems not related to RT! I'd be surprised if your Apache instance runs when you exclude RT configuration from it. Does it?? First thing is you must have a running instance of Apache. Thereafter you ensure that it meets RTs requirements in terms of either mod_perl. I am afraid you have to follow that, though I must say I don't speak for RT Team. On Fri, Jan 7, 2011 at 1:04 AM, seb...@gmail.com seb...@gmail.com wrote: Thanks guys, i did the changes, and now apache starts fine but i cant access the RT Web. error.log says: [Thu Jan 06 18:56:42 2011] [error] (1)Operation not permitted: mod_mime_magic: can't read magic file /opt/rt4/conf/magic [Thu Jan 06 18:56:42 2011] [notice] Digest: generating secret for digest authentication ... [Thu Jan 06 18:56:42 2011] [notice] Digest: done [Thu Jan 06 18:56:42 2011] [notice] mod_python: Creating 4 session mutexes based on 256 max processes and 0 max threads. [Thu Jan 06 18:56:42 2011] [error] (2)No such file or directory: could not create /opt/rt4/run/httpd.pid [Thu Jan 06 18:56:42 2011] [error] httpd: could not log pid to file /opt/rt4/run/httpd.pid On Thu, Jan 6, 2011 at 6:36 PM, Kevin Falcone falc...@bestpractical.com wrote: On Thu, Jan 06, 2011 at 06:32:02PM -0300, seb...@gmail.com wrote: Hello, I'm installing a 4.0rc1 instance for test purposes. All steps when fine but when restarting apache i get this error: Can't locate /opt/rt4/bin/webmux.pl in @INC (@INC contains: /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.7/i386-linux-thread-multi My apache setup is this (same as running 3.6: Please have a look through the README when upgrading. It points to the new deployment documentation. That is not a valid apache config for 4.0. -kevin VirtualHost *:80 DocumentRoot /opt/rt4/share/html ErrorLog logs/rt PerlRequire /opt/rt4/bin/webmux.pl Location /NoAuth/images SetHandler default /Location Directory /opt/rt4/share/html Order allow,deny Allow from all SetHandler perl-script PerlResponseHandler RT::Mason /Directory /VirtualHost Thanks! Seb.- -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Damn!!
Re: [rt-users] RT 4.0rc1 install error
On Fri, Jan 7, 2011 at 1:51 AM, seb...@gmail.com seb...@gmail.com wrote: On Thu, Jan 6, 2011 at 7:13 PM, Odhiambo Washington odhia...@gmail.com wrote: You really have more problems not related to RT! I'd be surprised if your Apache instance runs when you exclude RT configuration from it. Does it?? My apache runs 4 other applications normally. When i configure the apache as the docs i got the apache to crash. Maybe someone can paste his apache setup to compare with? As it was pointed to you, please have a look through the README when upgrading. It points to the new deployment documentation. cd rt-4.0.0rc1 perldoc docs/web_deployment.pod Copy the one you want verbatim and change the paths only. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Damn!!
Re: [rt-users] Restoring data after a system crash
On Thu, Jan 6, 2011 at 10:42 PM, Chris Barnes chris-bar...@tamu.edu wrote: mysqlhotcopy http://dev.mysql.com/doc/refman/5.0/en/mysqlhotcopy.html *mysqlhotcopy works only for backing up MyISAM and ARCHIVE tables* RT runs on InnoDB tables. -- Best regards, Ruslan.
Re: [rt-users] Communicate a message to web UI from inside Scrip?
Pulling my hair out here. Why is this callback not being tickled? I see nothing in my logs. RT 3.8.7 Mason cache cleared and server restarted a million times. The call to the callback in Ticket/Display.html is: $m-callback( CallbackName = 'BeforeDisplay', TicketObj = \$TicketObj, Tickets = \$Tickets, Actions = \...@actions, ARGSRef = \%ARGS, ); And my setup is: [r...@rtdev1 Display.html]# pwd /rt/local/html/Callbacks/MyCallbacks/Ticket/Display.html [r...@rtdev1 Display.html]# ls -l BeforeDisplay -rw-r--r-- 1 rt root 689 Jan 6 22:06 BeforeDisplay [r...@rtdev1 Display.html]# cat BeforeDisplay %INIT $RT::Logger-info(In Callback/Display.html/BeforeDisplay\n); return 1; /%INIT %ARGS $Actions = [] /%ARGS
Re: [rt-users] Restoring data after a system crash
On 1/6/2011 6:58 PM, Ruslan Zakirov wrote: On Thu, Jan 6, 2011 at 10:42 PM, Chris Barneschris-bar...@tamu.edu wrote: mysqlhotcopy http://dev.mysql.com/doc/refman/5.0/en/mysqlhotcopy.html *mysqlhotcopy works only for backing up MyISAM and ARCHIVE tables* RT runs on InnoDB tables. Wel alrighty then. -- Chris Barnes AOL IM: CNBarnes chris-bar...@tamu.eduYahoo IM: chrisnbarnes Computer Systems Manager MSN IM: ch...@txbarnes.com Department of Physics ph: 979-845-1379 Texas AM University fax: 979-845-2590
