[rt-users] a question about rigths

2009-02-19 Thread Alberto Villanueva
Hi all!! I have a question: OwnTicket right involves StealTicket?? Thanks! Regards, ALBERTO VILLANUEVA VAL Consultor Altran ParqueEmpresarial Las Mercedes, Edificio 1 C/ Campezo, 1. 28022 Madrid Tel : + 34 91 744 46 00 Fax: +

[rt-users] PATH for executing external programs from RT?

2009-02-19 Thread Matthew Seaman
Dear all, When I click on 'graph' links in the Ticket display I get an error like so: Command 'dot' not found in /bin, /usr/bin at /usr/local/lib/perl5/site_perl/5.8.9/GraphViz.pm line 1160 Stack: [/usr/local/lib/perl5/5.8.9/Carp.pm:44] [/usr/local/lib/perl5/site_perl/5.8.9/IPC/Run.pm:1213]

Re: [rt-users] PATH for executing external programs from RT?

2009-02-19 Thread Kenneth Marshall
Re-install the GraphViz and GnuPG modules using the correct paths to these programs. Alternatively, you can make a symbolic link from the actual location to where the module is looking for these programs. Cheers, Ken On Thu, Feb 19, 2009 at 01:32:43PM +, Matthew Seaman wrote: Dear all,

[rt-users] Autocreated on ticket submission - Quert Builder

2009-02-19 Thread Bashir Jahed
Hi Alll, I have a problem that has shown up over the last week. It looks as if every single person who has ever submitted a ticket request has had a user autocreated. These users now how up in query builder when we try and do a search on the owner. Selecting the owner shows every single email

Re: [rt-users] Autocreated on ticket submission - Quert Builder

2009-02-19 Thread Kenneth Marshall
Bashir, You need to fix your permissions. Somewhere you are letting every address own a ticket. That is what determines what shows up in the pull-down. Happy hunting. Ken On Thu, Feb 19, 2009 at 04:16:07PM +0200, Bashir Jahed wrote: Hi Alll, I have a problem that has shown up over the

Re: [rt-users] Autocreated on ticket submission - Quert Builder

2009-02-19 Thread Bashir Jahed
Man how did this happen, all user have ticked Allow user to access RT I am assuming this is the permission problem. Problem is how do i disable thisThousands of email addresses -Original Message- From: Kenneth Marshall [mailto:k...@rice.edu] Sent: 19 February 2009 04:18 PM To:

Re: [rt-users] Autocreated on ticket submission - Quert Builder

2009-02-19 Thread Mike Peachey
Bashir Jahed wrote: Man how did this happen, all user have ticked Allow user to access RT I am assuming this is the permission problem. Problem is how do i disable thisThousands of email addresses I think you're misunderstanding how the system works. In order to raise a ticket, the

Re: [rt-users] Autocreated on ticket submission - Quert Builder

2009-02-19 Thread Bashir Jahed
I have done the following: Checked for a specific user in the search box as owner to confirm it shows up. Then went into the specific user and unchecked /users/Access Control/Let this user access RT checkbox and confirmed that the user no longer shows up in the search box in the Owner Field They

Re: [rt-users] Autocreated on ticket submission - Quert Builder

2009-02-19 Thread Mike Peachey
Bashir Jahed wrote: I have done the following: Checked for a specific user in the search box as owner to confirm it shows up. Then went into the specific user and unchecked /users/Access Control/Let this user access RT checkbox and confirmed that the user no longer shows up in the search

Re: [rt-users] PATH for executing external programs from RT?

2009-02-19 Thread Matthew Seaman
Kenneth Marshall wrote: Re-install the GraphViz and GnuPG modules using the correct paths to these programs. Alternatively, you can make a symbolic link from the actual location to where the module is looking for these programs. Both of those modules use the PATH setting in the environment to

[rt-users] Deleted status

2009-02-19 Thread Alberto Villanueva
Hi, Does anyone know if a ticket has 'deleted' status it will be deleted permanently? Thanks! Regards, ALBERTO VILLANUEVA VAL Consultor Altran ParqueEmpresarial Las Mercedes, Edificio 1 C/ Campezo, 1. 28022 Madrid Tel : + 34 91

[rt-users] WebService for RT?

2009-02-19 Thread Chris Black
Has anyone ever written a webservice or something to remotely create and update tickets? I have a few ideas where I need an external system to check, create and update RT tickets. I have done this in the past with the SSH and local scripts, but I would rather not have to do that with this

Re: [rt-users] Deleted status

2009-02-19 Thread Drew Barnes
Nope, it will still exist in the database and will still be viewable if someone knows the id. The only way to truly delete is to use Shredder. Alberto Villanueva wrote: Hi, Does anyone know if a ticket has ‘deleted’ status it will be deleted permanently? Thanks! Regards, ALBERTO

Re: [rt-users] PATH for executing external programs from RT?

2009-02-19 Thread Matthew Seaman
Matthew Seaman wrote: Kenneth Marshall wrote: Re-install the GraphViz and GnuPG modules using the correct paths to these programs. Alternatively, you can make a symbolic link from the actual location to where the module is looking for these programs. Both of those modules use the PATH

Re: [rt-users] Deleted status

2009-02-19 Thread Alberto Villanueva
Thanks!! I thought that :) Now, if I want to delete several tickets by id, could it be done on shredder? I doesn't accept queries :( Regards, ALBERTO VILLANUEVA VAL Consultor Altran ParqueEmpresarial Las Mercedes, Edificio 1 C/ Campezo, 1. 28022

[rt-users] RT 3.8 mangles html attachment

2009-02-19 Thread Todd Chapman
We have an RT instance in a trusted environment. I have the following in RT_SiteConfig.pm: Set($TrustHTMLAttachments, 1); Set($PreferRichText, 1); Set($MaxAttachmentSize , 1000); I even turned of the HTML scrubber, yet when I attach an html file to a ticket and then save it back to my

Re: [rt-users] RT 3.8 mangles html attachment

2009-02-19 Thread Jesse Vincent
On Thu, Feb 19, 2009 at 10:44:50AM -0500, Todd Chapman wrote: We have an RT instance in a trusted environment. I have the following in RT_SiteConfig.pm: Set($TrustHTMLAttachments, 1); Set($PreferRichText, 1); Set($MaxAttachmentSize , 1000); I even turned of the HTML scrubber, yet

Re: [rt-users] RT 3.8 mangles html attachment

2009-02-19 Thread Todd Chapman
Thanks for the reply Jessee, The html no longer displays correctly in the browser after canonicalization. Suggestions? On Thu, Feb 19, 2009 at 10:47 AM, Jesse Vincent je...@bestpractical.comwrote: On Thu, Feb 19, 2009 at 10:44:50AM -0500, Todd Chapman wrote: We have an RT instance in a

Re: [rt-users] Deleted status

2009-02-19 Thread Alberto Villanueva
I have a possible solution: - Select tickets - Change to deleted status - Remove to shredder Regards, ALBERTO VILLANUEVA VAL Consultor Altran ParqueEmpresarial Las Mercedes, Edificio 1 C/ Campezo, 1. 28022 Madrid Tel : + 34 91 744 46 00 Fax: + 34

Re: [rt-users] WebService for RT?

2009-02-19 Thread Stefan Hornburg
Chris Black wrote: Thanks. This looks like a good solution, however I need something that can give me back the Ticket ID and other information immediately. Having to wait for an email reply from RT to confirm the changes, etc would not be ideal. The REST interface just gives you the

Re: [rt-users] RT 3.8 mangles html attachment

2009-02-19 Thread Todd Chapman
The original file when opened up in a browser looks like a formatted web page. After processing by RT the file look like it is rendered as what looks like plain text in Safari. In Firefox there are a bunch of weird question mark characters representing the spaces between characters. FF's page info

Re: [rt-users] Forward an entire ticket to an outside email address.

2009-02-19 Thread Todd Chapman
That's a feature of RT 3.8. On Wed, Feb 18, 2009 at 6:29 PM, Chris Crow chrisc.em...@abshernw.comwrote: I have a quick question about RT. We have a group of technicians that work entirely from the RT's web interface, so they never see any email. This works great, but they want a way to

Re: [rt-users] RT 3.8 mangles html attachment

2009-02-19 Thread Jesse Vincent
On Thu 19.Feb'09 at 11:33:25 -0500, Todd Chapman wrote: Correction, the weird question mark characters are between every character in the original document. Like so: �h�e�a�d�� � ��m�e�t�a� Fascinating. Does it do this with all html attachments?

Re: [rt-users] Forward an entire ticket to an outside email address.

2009-02-19 Thread Todd Chapman
Actually, you can't forward a whole ticket, but you can forward a comment or correspondence. On Thu, Feb 19, 2009 at 11:34 AM, Todd Chapman t...@chaka.net wrote: That's a feature of RT 3.8. On Wed, Feb 18, 2009 at 6:29 PM, Chris Crow chrisc.em...@abshernw.comwrote: I have a quick question

Re: [rt-users] RT 3.8 mangles html attachment

2009-02-19 Thread Todd Chapman
Correction, the weird question mark characters are between every character in the original document. Like so: �h�e�a�d�� � ��m�e�t�a� �h�t�t�p�-�e�q�u�i�v�=�C�o�n�t�e�n�t�-�T�y�p�e� �c�o�n�t�e�n�t�=��t�e�x�t�/�h�t�m�l�;� �c�h�a�r�s�e�t�=�u�n�i�c�o�d�e��� � ��m�e�t�a� �n�a�m�e�=�P�r�o�g�I�d�

Re: [rt-users] WebService for RT?

2009-02-19 Thread Stefan Hornburg
Chris Black wrote: Has anyone ever written a webservice or something to remotely create and update tickets? I have a few ideas where I need an external system to check, create and update RT tickets. I have done this in the past with the SSH and local scripts, but I would rather not have

Re: [rt-users] RT 3.8 mangles html attachment

2009-02-19 Thread Todd Chapman
According to FF the original file has an encoding of UTF-16LE. It was generated by Word. (I know, I know) On Thu, Feb 19, 2009 at 11:35 AM, Jesse Vincent je...@bestpractical.comwrote: On Thu 19.Feb'09 at 11:33:25 -0500, Todd Chapman wrote: Correction, the weird question mark characters

Re: [rt-users] PATH for executing external programs from RT?

2009-02-19 Thread Kenneth Marshall
I just assumed that the values were hardcoded and not something that changing your PATH setting would affect. Since that is the case, this is the appropriate change. I am glad you fixed it. Cheers, Ken On Thu, Feb 19, 2009 at 03:36:30PM +, Matthew Seaman wrote: Matthew Seaman wrote:

Re: [rt-users] RT 3.8 mangles html attachment

2009-02-19 Thread Jesse Vincent
On Thu 19.Feb'09 at 11:42:42 -0500, Todd Chapman wrote: According to FF the original file has an encoding of UTF-16LE. It was generated by Word. (I know, I know) Now we're getting somewhere. Was it attached to a mail as an attachment? If so, what do the headers for the original

Re: [rt-users] WebService for RT?

2009-02-19 Thread Jesse Vincent
On Thu 19.Feb'09 at 16:50:03 +0100, Stefan Hornburg wrote: There is a REST interface and a corresponding Perl module (though that might be a bit outdated with 3.8). I'm using RT::Client::REST against 3.8.2 just fine. ___

Re: [rt-users] RT 3.8 mangles html attachment

2009-02-19 Thread Todd Chapman
It was attached using the web interface. On Thu, Feb 19, 2009 at 11:45 AM, Jesse Vincent je...@bestpractical.comwrote: On Thu 19.Feb'09 at 11:42:42 -0500, Todd Chapman wrote: According to FF the original file has an encoding of UTF-16LE. It was generated by Word. (I know, I know)

Re: [rt-users] RT 3.8 mangles html attachment

2009-02-19 Thread Todd Chapman
It was attached in the web interface on the Create.html page. (Not a custom field) On Thu, Feb 19, 2009 at 11:45 AM, Jesse Vincent je...@bestpractical.comwrote: On Thu 19.Feb'09 at 11:42:42 -0500, Todd Chapman wrote: According to FF the original file has an encoding of UTF-16LE. It was

Re: [rt-users] a question about rigths

2009-02-19 Thread Jesse Vincent
I have a question: OwnTicket right involves StealTicket?? StealTicket means you can take ownership of a ticket someone else owns. OwnTicket is who's allowed to own the ticket at all ___

Re: [rt-users] a question about rigths

2009-02-19 Thread Alberto Villanueva
Hi! Thanks by the answer ;) But... I have granted the take permission to my users..., and they can steal tickets!! :( :( Any idea? Regards, ALBERTO VILLANUEVA VAL Consultor Altran ParqueEmpresarial Las Mercedes, Edificio 1 C/ Campezo, 1. 28022

Re: [rt-users] RT 3.8 mangles html attachment

2009-02-19 Thread Jesse Vincent
On Thu 19.Feb'09 at 11:55:19 -0500, Todd Chapman wrote: It was attached in the web interface on the Create.html page. (Not a custom field) And what headers is RT serving it out with? Is RT announcing it as utf8? Is that stored in the database as content-type? If you save the raw data

[rt-users] changed site to SSL -- no username/password prompt?

2009-02-19 Thread Jo Rhett
This is probably FAQ but I've been searching and coming up dry. We changed the site to SSL. Setup the apache vhost correctly. Changed the webbaseurl in RT_SiteConfig. Changed the mailgate aliases. Stopped apache and cleared the mason cache. It's working just fine in an Apache sense.

Re: [rt-users] changed site to SSL -- no username/password prompt?

2009-02-19 Thread Jo Rhett
In specific, the titlebox content is empty. div id=login-box div class= div class=titlebox id= div class=titlebox-title span class=left Login/span span class=right3.8.2/span /div div class=titlebox-content id=TitleBox--_index.html-- TG9naW4=---0 hr

Re: [rt-users] RT 3.8 mangles html attachment

2009-02-19 Thread Todd Chapman
On Thu, Feb 19, 2009 at 12:29 PM, Jesse Vincent je...@bestpractical.comwrote: On Thu 19.Feb'09 at 11:55:19 -0500, Todd Chapman wrote: It was attached in the web interface on the Create.html page. (Not a custom field) And what headers is RT serving it out with? Is RT announcing it

Re: [rt-users] Autocreated on ticket submission - Quert Builder

2009-02-19 Thread Kenneth Crocker
Bashir, What Mike was telling you is that if the BOTTOM box is checked for a user, they can have privileges. This means that if you grant the OwnTicket right globally to Privileged users, then all these requestors that send in tickets via email will have the right to OWN a ticket,

Re: [rt-users] WebService for RT?

2009-02-19 Thread Tom Lahti
Jesse Vincent wrote: On Thu 19.Feb'09 at 16:50:03 +0100, Stefan Hornburg wrote: There is a REST interface and a corresponding Perl module (though that might be a bit outdated with 3.8). I'm using RT::Client::REST against 3.8.2 just fine. I'm also right now working on a ruby class that

Re: [rt-users] a question about rigths

2009-02-19 Thread Kenneth Crocker
Alberto, They shouldn't be able to Steal a ticket (which means it already has an owner) unless that right is being granted somewhere. Have you looked at your global rights? Have you check memberships in groups and roles and compare the rights granted to those? HAve you checked both

Re: [rt-users] changed site to SSL -- no username/password prompt?

2009-02-19 Thread Kevin Falcone
On Feb 19, 2009, at 12:53 PM, Jo Rhett wrote: In specific, the titlebox content is empty. div id=login-box div class= div class=titlebox id= div class=titlebox-title span class=left Login/span span class=right3.8.2/span /div div class=titlebox-content

Re: [rt-users] changed site to SSL -- no username/password prompt?

2009-02-19 Thread Jo Rhett
On Feb 19, 2009, at 10:14 AM, Kevin Falcone wrote: Sounds like you've set WebExternalAuth to 1 and WebFallbackToInternalAuth to 0 Bingo. Where can I send the beer? For a bonus question: why did this work in non-ssl mode? I remember setting this way way way back when we though we'd use http

Re: [rt-users] change updates from unprivileged user to a different transaction type?

2009-02-19 Thread Jo Rhett
On Feb 12, 2009, at 2:02 PM, Jesse Vincent wrote: Jesse, how would you feel about having an action which indicates an update not by a privileged user? Ie, Correspond and Comments would be from privileged. Update or Response (or any other name you like) would be an update from

Re: [rt-users] change updates from unprivileged user to a different transaction type?

2009-02-19 Thread Stephen Turner
On Thu, 19 Feb 2009 13:40:33 -0500, Jo Rhett jrh...@netconsonance.com wrote: On Feb 12, 2009, at 2:02 PM, Jesse Vincent wrote: RT::Transaction-IsInbounda So I figured I'd test this out. It wasn't working, so I dug around inside RT/Transact.pm and I can't find this function. Is this

Re: [rt-users] change updates from unprivileged user to a different transaction type?

2009-02-19 Thread Jesse Vincent
We already have something for you, I think. RT::Transaction-IsInbounda So I figured I'd test this out. It wasn't working, so I dug around inside RT/Transact.pm and I can't find this function. Is this going into 3.8.3 or 4.0 ? Sorry. the a at the end was a typo. It's been there

Re: [rt-users] change updates from unprivileged user to a different transaction type?

2009-02-19 Thread Jo Rhett
On Feb 19, 2009, at 10:43 AM, Stephen Turner wrote: On Thu, 19 Feb 2009 13:40:33 -0500, Jo Rhett jrh...@netconsonance.com wrote: On Feb 12, 2009, at 2:02 PM, Jesse Vincent wrote: RT::Transaction-IsInbounda So I figured I'd test this out. It wasn't working, so I dug around inside

Re: [rt-users] RT 3.8 mangles html attachment

2009-02-19 Thread Jesse Vincent
meta http-equiv=Content-Type content=text/html; charset=unicode I don't know how FF figures out that it is UTF-16LE. I'd recommend starting in lib/RT/I18N.pm sub SetMIMEEntityToUTF8. instrument there. On Thu, Feb 19, 2009 at 1:48 PM, Todd Chapman t...@chaka.net wrote: On Thu,

[rt-users] 500 - Internal error

2009-02-19 Thread Alberto Villanueva
Hi all! I have this problem because I have tried to update lots of tickets. I have resolved giving grant to the rt3 database to the machine_rt_user user. But. now I can initialize session with no user :-( :-( :-( Some idea?? PS. The installation is a production server that it

Re: [rt-users] 500 - Internal error

2009-02-19 Thread chaim . rieger
What do the logs say ? Sent via BlackBerry from T-Mobile -Original Message- From: Alberto Villanueva alberto.villanu...@altran.es Date: Thu, 19 Feb 2009 20:23:50 To: rt-users@lists.bestpractical.com Subject: [rt-users] 500 - Internal error

Re: [rt-users] 500 - Internal error

2009-02-19 Thread Alberto Villanueva
The rt log (/var/log/rt.log) is empty :S :S :S The log of apache (/var/log/httpd/error_log): [Thu Feb 19 19:38:45 2009] [warning]: DBD::mysql::st execute failed: INSERT command denied to user 'vtd_rt_dbuser'@'localhost' for table 'sessions' at

Re: [rt-users] ERROR 1062 during 3.4.5 - 3.8.2 database update

2009-02-19 Thread Jim Faulkner
Just wanted to follow up on this. I was able to work around the Duplicate entry mysql error by modifying the ALTER TABLE command that caused the problem to be ALTER IGNORE TABLE. The IGNORE mysql extension is described on this page: http://dev.mysql.com/doc/refman/5.1/en/alter-table.html

Re: [rt-users] ERROR 1062 during 3.4.5 - 3.8.2 database update

2009-02-19 Thread Curtis Bruneau
I had the same problem and it was caused by accents, since mysql has no accent sensitive collations (_as) aside from utf8_bin which is everything sensitive, I basically just removed the user (or rename) to fix the issue. Since emails generally shouldn't have them it's pretty safe to do, the

[rt-users] date search criteria?

2009-02-19 Thread Jo Rhett
Can someone please smack me upside the head on what search words to use to find the date search criteria? The best I have found is not in the wiki, but http://web.mit.edu/tooltime/notebook/reference/search-guide.html Some of the queries I have been failing to do Queue1 tickets between 8am

Re: [rt-users] a question about rigths

2009-02-19 Thread Alberto Villanueva
Good morning ;) Yes, I have checked all permissions, and nobody has that. Anyway, I will check them again. Thanks! ;) Regards, ALBERTO VILLANUEVA VAL Consultor Altran ParqueEmpresarial Las Mercedes, Edificio 1 C/ Campezo, 1. 28022 Madrid Tel : +

Re: [rt-users] Autocreated on ticket submission - Quert Builder

2009-02-19 Thread Bashir Jahed
I have just removed all privileges for the Everyone group and the Privileged group has no rights assigned but still no luck. Really baffled by this one. -Original Message- From: Kenneth Crocker [mailto:kfcroc...@lbl.gov] Sent: 19 February 2009 07:57 PM To: Bashir Jahed Cc: