[rt-users] Is this a bug or a feature? Rights to allow personal (My) saved search

2010-02-08 Thread Carlos Garcia Montoro
Hi, We are using RT 3.8.7 and I want to allow my privileged users to save the searches that they want. In order to do that, I granted the following GLOBAL rights to my PRIVILEGED users: -CreateSavedSearch -EditSavedSearch -LoadSavedSearches -ShowSavedSearches I thought that it would be

[rt-users] I Need urgent help about very unsual issue

2010-02-08 Thread softouch
Hello Folks, i have installed RT3.8.7 on Ubuntu 8.4 a couple of week ago. in beginning every thing was working smoothly but from last couple of days i am facing very strange issue. All other functions of RT are working fine except. it happening that when ever i am trying to do any thing about

[rt-users] Regarding Duplicate Mails

2010-02-08 Thread Varun
Hello All I have RT 3.6.3 setup with oracle 9i as backend and I have one weird problem of RT creating duplicate ticket from same mail. When I tried to debug it I found it that it is fetch mail which is not flushing data once mail has been read and ticket is created. Fetch mail again sends same

[rt-users] SELECT * FROM CachedGroupMembers WHERE GroupId = 'x' AND MemberId = '1', please help

2010-02-08 Thread Raed El-Hames
Hi; RT-3.8.7 apach2, mysql5,mod_perl2,DBIx::SearchBuilder v1.56; -- I have Set($StatementLog,'debug') so I can see sql statements -- And I have Set($UseSQLForACLChecks,'1'); I am seeing lots of SELECT * FROM CachedGroupMembers WHERE GroupId = '2034' AND MemberId = '1', in my logs 2034 is a

Re: [rt-users] Is this a bug or a feature? Rights to allow personal (My) saved search

2010-02-08 Thread Carlos Garcia Montoro
I forgot to say that the message that my users receive when they try to save a search as a personal search is. If helps, it is: Results: Can't find a saved search to work with. Failed to create search attribute. Regards Carlos Garcia Montoro wrote: Hi, We are using RT 3.8.7 and I want to

Re: [rt-users] I Need urgent help about very unsual issue

2010-02-08 Thread Raed El-Hames
Riz; What are your Set($WebBaseURL , Set($WebURL , Set to, I believe these should be ending with / ie Set($WebBaseURL , https://mydomain.com/;); Set($WebURL ,https://mydomain.com/;); Regards; Roy softouch wrote: Hello Folks, i have installed RT3.8.7 on Ubuntu 8.4 a couple of week ago. in

Re: [rt-users] I Need urgent help about very unsual issue

2010-02-08 Thread Emmanuel Lacour
On Mon, Feb 08, 2010 at 03:20:29AM -0800, softouch wrote: https://mydomain.comticket/Display.html?id=12; look at the .comticket portion. there should be a / between .com and ticket also ticket should be Ticket. when i edit this manually every thing went ok. i have tested each option by

Re: [rt-users] I Need urgent help about very unusual issue

2010-02-08 Thread softouch
Guys my problem is resolved by the suggestion provided by Raed El-Hames. Hats off to Him... :) softouch wrote: Hello Folks, i have installed RT3.8.7 on Ubuntu 8.4 a couple of week ago. in beginning every thing was working smoothly but from last couple of days i am facing very strange

[rt-users] Download a source code of RT

2010-02-08 Thread Alberto Villanueva
Good morning, I would like to download a file of the RT source code. The filename is combobox.js, and the version is 3.8.1. Does a ftp exist where I can download the file? Thanks a lot! Best regards, -- Alberto Villanueva Departamento de Industria __

Re: [rt-users] Download a source code of RT

2010-02-08 Thread Emmanuel Lacour
On Mon, Feb 08, 2010 at 12:41:11PM +0100, Alberto Villanueva wrote: Good morning, I would like to download a file of the RT source code. The filename is combobox.js, and the version is 3.8.1. Does a ftp exist where I can download the file? tarballs are available here:

[rt-users] How to change footer note in RT Web pages.

2010-02-08 Thread softouch
Hello Folks how can i change the »|« RT 3.8.7 Copyright 1996-2009 Best Practical Solutions, LLC. string from the RT web pages?? also how to change the legal statement from Login page. Thanking in Advance. R i Z. -- View this message in context:

Re: [rt-users] How to change footer note in RT Web pages.

2010-02-08 Thread Jesse Vincent
On Mon, Feb 08, 2010 at 03:58:24AM -0800, softouch wrote: Hello Folks how can i change the »|« RT 3.8.7 Copyright 1996-2009 Best Practical Solutions, LLC. string from the RT web pages?? also how to change the legal statement from Login page. Please don't remove the

[rt-users] I can't create a ticket in RT

2010-02-08 Thread Wagner Pereira
Hi, folks. I need some help with that: There is a Postfix MTA running in the same server of RT. I configured procmail to deliver the messages to rt-mailgate, but after some tests I still can't create a ticket through e-mail messages. This is my rt.log: === 403

Re: [rt-users] I can't create a ticket in RT

2010-02-08 Thread Emmanuel Lacour
On Mon, Feb 08, 2010 at 12:21:47PM -0200, Wagner Pereira wrote: Hi, folks. I need some help with that: There is a Postfix MTA running in the same server of RT. I configured procmail to deliver the messages to rt-mailgate, but after some tests I still can't create a ticket through e-mail

Re: [rt-users] I can't create a ticket in RT

2010-02-08 Thread Wagner Pereira
Hi, Emmanuel. Thanks for answered me. My authentication is HTTPS: https://rtracker.rt.pop-sp.rnp.br/rt/ if so, either allow localhost to connect without a password or create an account and set credentials in your rt-mailgate call. How can I implement that? P.S.: I observed a thing: every time

Re: [rt-users] I can't create a ticket in RT

2010-02-08 Thread Emmanuel Lacour
On Mon, Feb 08, 2010 at 12:40:00PM -0200, Wagner Pereira wrote: My authentication is HTTPS: https://rtracker.rt.pop-sp.rnp.br/rt/ That's the way you access your RT server, not the way you authenticate to it. Can you give us your VirtualHost configuration? P.S.: I observed a thing: every

Re: [rt-users] I can't create a ticket in RT

2010-02-08 Thread Wagner Pereira
Emmanuel, That's my VirtualHost file: === VirtualHost *:443 ServerName rtracker.rt.pop-sp.rnp.br RedirectMatch ^/$ https://rtracker.rt.pop-sp.rnp.br/rt/ DocumentRoot /var/www CustomLog /var/log/apache2/rt.log combined ServerSignature Off LogLevel

Re: [rt-users] I can't create a ticket in RT

2010-02-08 Thread Kevin Falcone
On Mon, Feb 08, 2010 at 01:34:51PM -0200, Wagner Pereira wrote: Emmanuel, That's my VirtualHost file: === VirtualHost *:443 ServerName rtracker.rt.pop-sp.rnp.br RedirectMatch ^/$ https://rtracker.rt.pop-sp.rnp.br/rt/ DocumentRoot /var/www

Re: [rt-users] I can't create a ticket in RT

2010-02-08 Thread Emmanuel Lacour
On Mon, Feb 08, 2010 at 01:34:51PM -0200, Wagner Pereira wrote: Emmanuel, That's my VirtualHost file: === VirtualHost *:443 ServerName rtracker.rt.pop-sp.rnp.br RedirectMatch ^/$ https://rtracker.rt.pop-sp.rnp.br/rt/ DocumentRoot /var/www CustomLog

[rt-users] ACL.RightName = 'SuperUser' OR ACL.RightName = 'ShowACL' :: please help

2010-02-08 Thread Raed El-Hames
Maybe this time I'll get an answer .. RT-3.8.7 NO customisation apart from css DBIx - 1.56 apache2,mod_perl2 I am seeing a lot of queries (1146 of them) SELECT ACL.id FROM ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'ShowACL') AND

Re: [rt-users] ACL.RightName = 'SuperUser' OR ACL.RightName = 'ShowACL' :: please help

2010-02-08 Thread Ken Crocker
Raed, The only thing I can think of to help de-bug this is to list the privileges you've set and then compare that list to what you see in the ACL table. Unless, of course, you have Rights Matrix installed. That would also help. I don't know if Rights Matrix works on 3.8.x, but it certainly

Re: [rt-users] ACL.RightName = 'SuperUser' OR ACL.RightName = 'ShowACL' :: please help

2010-02-08 Thread Raed El-Hames
Thanks for your response Ken , I traced it down to missing entry in CachedGroupMembers; When I upgraded my dev box from 3.6.3 to 3.8.7 I ran shrink_cgm_table.pl, which for some reason (maybe something in my system) deleted the following row: mysql select * from CachedGroupMembers where id = 2;

Re: [rt-users] ACL.RightName = 'SuperUser' OR ACL.RightName = 'ShowACL' :: please help

2010-02-08 Thread Ken Crocker
Raed, From my evaluations when scrutinizing the DB, I've noticed that it seems ANY query saved by group (OH, this is on 3.6.4. I haven't had a chance yet to REALLY look at the DB from a 3.8.x view) will always want to check permissions for a single user that wants to look at that query to

[rt-users] DataBase question for RT 3.8.7

2010-02-08 Thread Ken Crocker
To list, Were there any new Tables added to the DataBase for 3.8.7 not in 3.6.4? Thanks. Kenn LBNL ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support:

Re: [rt-users] Ticket Links on reqults - problem

2010-02-08 Thread Kevin Falcone
On Mon, Feb 08, 2010 at 09:19:48AM -0800, Ken Crocker wrote: Emmanuel, Here's a snapshot of the screen. We got the pie/bar charts to work, BTW, so thanks. Kenn You missed what is possibly the most important thing that Emmanuel asked for, the Format copied from the Advanced tab on that

Re: [rt-users] DataBase question for RT 3.8.7

2010-02-08 Thread Raed El-Hames
No new tables Ken, just a lot of new content and data type changes. if you download the source code have a look in etc/upgrade/* for each version above 3.6.4 As I remember , you use oracle , not sure if the data type changes effect your system, Regards; Roy -- returning the favour Ken

Re: [rt-users] DataBase question for RT 3.8.7

2010-02-08 Thread Joop van de Wege
Ken Crocker wrote: To list, Were there any new Tables added to the DataBase for 3.8.7 not in 3.6.4? You can check that yourself by looking at the source archive. Look in the etc/upgrade/.. for the file 'content'. Those files hold changes to the database, if I'm correct. Regards, Joop

Re: [rt-users] SELECT * FROM CachedGroupMembers WHERE GroupId = 'x' AND MemberId = '1', please help

2010-02-08 Thread Raed El-Hames
Any ideas anyone Roy Raed El-Hames wrote: Hi; RT-3.8.7 apach2, mysql5,mod_perl2,DBIx::SearchBuilder v1.56; -- I have Set($StatementLog,'debug') so I can see sql statements -- And I have Set($UseSQLForACLChecks,'1'); I am seeing lots of SELECT * FROM CachedGroupMembers WHERE GroupId =

Re: [rt-users] DataBase question for RT 3.8.7

2010-02-08 Thread Ken Crocker
Joop everyone, Thanks. I didn't do the upgrade, but I'll get access and look at that data. Thanks again. Kenn LBNL On 2/8/2010 10:59 AM, Joop van de Wege wrote: Ken Crocker wrote: To list, Were there any new Tables added to the DataBase for 3.8.7 not in 3.6.4? You can check that

Re: [rt-users] Ticket Links on reqults - problem

2010-02-08 Thread Ken Crocker
Emmanuel, Sorry about the Advanced format shot. Here it is: 'b__id__/a/b/TITLE:Ticket Id', QueueName, 'b__Subject__/a/b/TITLE:Subject','__Requestors__', Priority, Status,'__CustomField.{Work-State}__', OwnerName, '__Due__/a/b/TITLE:Due Date'. Thanks for the reminder Kevin. Kenn LBNL On

Re: [rt-users] Ticket Links on reqults - problem

2010-02-08 Thread Ken Crocker
Emmanuel, HA! I found it. Your clue as to the format settings put me in the right direction. I had screwed up the default format settings. I've got it working now. Thanks. Kenn LBNL On 2/8/2010 12:23 PM, Ken Crocker wrote: Emmanuel, Sorry about the Advanced format shot. Here it is:

Re: [rt-users] I can't create a ticket in RT

2010-02-08 Thread Wagner Pereira
Kevin and Emmanuel, Q: So you have somewhere else something that define that /rt runs RT, yes? A: I'm affraid don't understand that question. The following is my /var/log/apache2/error.log [Sun Feb 07 06:25:02 2010] [warn] RSA server certificate CommonName

Re: [rt-users] I can't create a ticket in RT

2010-02-08 Thread Kevin Falcone
On Mon, Feb 08, 2010 at 07:05:02PM -0200, Wagner Pereira wrote: Kevin and Emmanuel, Q: So you have somewhere else something that define that /rt runs RT, yes? A: I'm affraid don't understand that question. There must be more Apache conf, because the part you sent was not actually serving

[rt-users] Trouble with ConciseSpreadsheet

2010-02-08 Thread Ken Crocker
To list, I'm having trouble getting my ConciseSpreadsheet extension working. We installed ConciseSpreadsheet into /share/html. However, I can't find any instructions on what to do after that. I had some old instructions for 3.6.4, but they can't apply because the code in Results.html has

Re: [rt-users] Ticket Links on reqults - problem

2010-02-08 Thread Emmanuel Lacour
On Mon, Feb 08, 2010 at 12:56:05PM -0800, Ken Crocker wrote: Emmanuel, HA! I found it. Your clue as to the format settings put me in the right direction. I had screwed up the default format settings. I've got it working now. Thanks. You're welcome ;)

[rt-users] how to delete tickets in RT

2010-02-08 Thread softouch
Hello. after installation of Fresh RT, there is a bulk of test tickets in rt DB. i want to remove these tickets before commencing operational launch of my system. please help me to remove these tickets. also after deletion of tickets ticket counter no should be reset. also kindly help me to