Re: [rt-users] Change text in tickts using database

2012-10-19 Thread Juanjo
Thanks. But i don´t see the email content, only see the headers. I´m looking to change the content of the messages. I see in the attachments tab, a column called content, but says (trough phpMyAdmin) Binary Not Edit!! Regards. 2012/10/18 Tim Cutts t...@sanger.ac.uk On 18 Oct 2012, at

Re: [rt-users] Change text in tickts using database

2012-10-19 Thread Mark Goodge
On 19/10/2012 08:00, Juanjo wrote: Thanks. But i don´t see the email content, only see the headers. I´m looking to change the content of the messages. I see in the attachments tab, a column called content, but says (trough phpMyAdmin) Binary Not Edit!! That's because (as I said in my

Re: [rt-users] Change text in tickts using database

2012-10-19 Thread Tim Cutts
On 19 Oct 2012, at 08:00, Juanjo juanji...@gmail.com wrote: Thanks. But i don´t see the email content, only see the headers. I´m looking to change the content of the messages. I see in the attachments tab, a column called content, but says (trough phpMyAdmin) Binary Not Edit!! You

Re: [rt-users] Change text in tickts using database

2012-10-19 Thread Juanjo
I need edit to change some characterset. I migrate from mysql to postgresql. And some local character (spaniard character) text are now showhing proper. I wan´t to mantain the Actually encondig and Collate. To make that, i think that is enought to only change a string like ú to my spaniard

[rt-users] Size of the database.

2012-10-19 Thread Albert Shih
Hi all, When I start RT I make a big mistake, I choose mysql as database (instead postgresql). I loose the feature to search inside of the ticket. But well it's the past. I knwon it's very hard to change the database. As it's very hard to decide if I should break everything and make a new

Re: [rt-users] summing time per queue

2012-10-19 Thread Kevin Falcone
On Thu, Oct 18, 2012 at 02:01:19PM +1100, Chris Herrmann wrote: Is it possible to use ticket sql to sum a list of tickets by queue? I.e. is there an equivalent to the SQL SUM and Group by construct? You can't do it from TicketSQL, but you can do it using the perl code that RT's charts use.

Re: [rt-users] Command by Mail CC and AddCC for new users

2012-10-19 Thread Kevin Falcone
On Fri, Oct 19, 2012 at 09:35:48AM +1100, Tom Robinson wrote: On 17/10/12 00:35, Kevin Falcone wrote: On Mon, Oct 08, 2012 at 11:51:30AM +1100, Tom Robinson wrote: It looks as if the Command by Mail commands CC: and AddCC: can only be used for existing users. Is this configurable so that

Re: [rt-users] Change text in tickts using database

2012-10-19 Thread Kevin Falcone
On Fri, Oct 19, 2012 at 10:41:48AM +0200, Juanjo wrote: I need edit to change some characterset. I migrate from mysql to postgresql. And some local character (spaniard character) text are now showhing proper. I wan*t to mantain the Actually encondig and Collate. To make that, i

Re: [rt-users] Size of the database.

2012-10-19 Thread Kevin Falcone
On Fri, Oct 19, 2012 at 03:57:35PM +0100, Tim Cutts wrote: On 19 Oct 2012, at 15:40, Albert Shih albert.s...@obspm.fr wrote: When I start RT I make a big mistake, I choose mysql as database (instead postgresql). I loose the feature to search inside of the ticket. But well it's the past.

Re: [rt-users] spawn-fcgi and rt-server.fcgi fail

2012-10-19 Thread Alex Vandiver
On Wed, 2012-10-17 at 15:21 -0500, Alex Hanselka wrote: Ah I should have included this in the first place! I am using Scientific Linux 6.3 (RHEL repack thing) and the latest RT, 4.0.7. SELinux is disabled in this case. The owner and group of mason-data is set to my webserver user.

Re: [rt-users] spawn-fcgi and rt-server.fcgi fail

2012-10-19 Thread Alex Hanselka
On 2012-10-19 11:59, Alex Vandiver wrote: You might be able to get some enlightenment through strace'ing the process, but your failure mode doesn't ring any bells to me. What was your configure line, out of curiosity? - Alex Thank you for your response! Upon strace-ing the file, it

[rt-users] QuickUpdate shows all status values for all lifecycles - rt 4.0.7

2012-10-19 Thread Jim Lesinski
Hello, Is there some way to make the quick update plugin only show the correct status values for the current queue's lifecycle? Currently the Quick Update plugin shows all status values from all lifecycles. Thanks, Jim Final RT training for 2012 in Atlanta, GA - October 23

Re: [rt-users] spawn-fcgi and rt-server.fcgi fail

2012-10-19 Thread Alex Vandiver
On Fri, 2012-10-19 at 12:21 -0500, Alex Hanselka wrote: Upon strace-ing the file, it seems to have a lot of issues with (No such file or directory) errors. I assume this is because it searches for the files and the first places it tries are wrong? Correct, those are expected as perl searches

Re: [rt-users] spawn-fcgi and rt-server.fcgi fail

2012-10-19 Thread Alex Hanselka
On 2012-10-19 13:32, Alex Vandiver wrote: On Fri, 2012-10-19 at 12:21 -0500, Alex Hanselka wrote: I also see a bunch of Inappropriate ioctl for device. I can provide a pastebin of the strace if necessary. The ioctl error is somewhat more surprising. Seeing a pastebin of the strace might

Re: [rt-users] spawn-fcgi and rt-server.fcgi fail

2012-10-19 Thread Alex Vandiver
On Fri, 2012-10-19 at 14:25 -0500, Alex Hanselka wrote: You can find that at http://darkdna.net/strace.txt Was this from before or after the patch? I don't see any of the expected calls to bind or listen there, which is the problem the patch was meant to address. Can you strace the spawn-fcgi

Re: [rt-users] spawn-fcgi and rt-server.fcgi fail

2012-10-19 Thread Alex Hanselka
On 2012-10-19 14:48, Alex Vandiver wrote: On Fri, 2012-10-19 at 14:25 -0500, Alex Hanselka wrote: You can find that at http://darkdna.net/strace.txt Was this from before or after the patch? I don't see any of the expected calls to bind or listen there, which is the problem the patch was

Re: [rt-users] spawn-fcgi and rt-server.fcgi fail

2012-10-19 Thread Alex Hanselka
On 2012-10-19 14:54, Alex Hanselka wrote: On 2012-10-19 14:48, Alex Vandiver wrote: On Fri, 2012-10-19 at 14:25 -0500, Alex Hanselka wrote: You can find that at http://darkdna.net/strace.txt Was this from before or after the patch? I don't see any of the expected calls to bind or listen

Re: [rt-users] spawn-fcgi and rt-server.fcgi fail

2012-10-19 Thread Alex Vandiver
On Fri, 2012-10-19 at 14:59 -0500, Alex Hanselka wrote: I lied! I misapplied that patch! I feel stupid and now it is recorded for all time in the archives. In any case, the rt-server.fcgi works now by itself, but spawn-fcgi still fails to spawn a persistent process. Glad to hear that

Re: [rt-users] spawn-fcgi and rt-server.fcgi fail

2012-10-19 Thread Alex Hanselka
On 2012-10-19 15:06, Alex Vandiver wrote: On Fri, 2012-10-19 at 14:59 -0500, Alex Hanselka wrote: I lied! I misapplied that patch! I feel stupid and now it is recorded for all time in the archives. In any case, the rt-server.fcgi works now by itself, but spawn-fcgi still fails to spawn a

Re: [rt-users] spawn-fcgi and rt-server.fcgi fail

2012-10-19 Thread Alex Vandiver
On Fri, 2012-10-19 at 15:13 -0500, Alex Hanselka wrote: I can! http://darkdna.net/spawn-fcgi.7021.txt and http://darkdna.net/spawn-fcgi.7022.txt. spawn-fcgi is redirecting stdout and stderr to /dev/null, which is hiding the helpful error message we're printing about /opt/rt4/var/log/rt.log not

Re: [rt-users] spawn-fcgi and rt-server.fcgi fail

2012-10-19 Thread Alex Hanselka
On 2012-10-19 15:25, Alex Vandiver wrote: On Fri, 2012-10-19 at 15:13 -0500, Alex Hanselka wrote: I can! http://darkdna.net/spawn-fcgi.7021.txt and http://darkdna.net/spawn-fcgi.7022.txt. spawn-fcgi is redirecting stdout and stderr to /dev/null, which is hiding the helpful error message we're

[rt-users] Unable to get paste Step 2

2012-10-19 Thread Cynthia Roe
HI, I am very new to the open source world and I am no programer by any means. New install for RT 4 Centos 6.3 running in OSX Parrallels container (test server) MySQL 5.1.61 Perl v5.10.1 mod_perl 2.0.4-10 mod_fastcgi-2.4.6 I have not been able to figure out why I am receiving the following

Re: [rt-users] spawn-fcgi and rt-server.fcgi fail

2012-10-19 Thread k...@rice.edu
On Fri, Oct 19, 2012 at 02:25:09PM -0500, Alex Hanselka wrote: On 2012-10-19 13:32, Alex Vandiver wrote: On Fri, 2012-10-19 at 12:21 -0500, Alex Hanselka wrote: I also see a bunch of Inappropriate ioctl for device. I can provide a pastebin of the strace if necessary. The ioctl error is

[rt-users] Web-UI navigation question

2012-10-19 Thread Robert Nesius
Both myself and fellow RT Users have noticed the following little quirk in navigating the UI. * While looking at a list of tickets (like My Tickets), we click on a ticket. * We resolve the ticket. * RT updates the view and says the ticket is solved. What would be mega handy is a link here Back

Re: [rt-users] Unable to get paste Step 2

2012-10-19 Thread Kevin Falcone
On Fri, Oct 19, 2012 at 05:35:37PM -0400, Cynthia Roe wrote: I have not been able to figure out why I am receiving the following error when I run Step 2) from the RT README file. $ pwd /tmp/rt-4.0.7 $ ./configure --with-db-rt-pass=rtsucks --with-db-database=rt3 --with-web-group=apache