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=apa

[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 t

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

[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 err

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

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 no

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 pers

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 half

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 ther

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 mea

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 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 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 searc

[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 & 2

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 seem

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. rt-

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 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. > > You can

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] 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 configura

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

2012-10-19 Thread Tim Cutts
On 19 Oct 2012, at 15:40, Albert Shih wrote: > 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. You can implement full text searches by using Sphinx. It's a bit

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. -k

[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 RT+po

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 charac

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

2012-10-19 Thread Tim Cutts
On 19 Oct 2012, at 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!! You certainly can

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 previou

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 > > On 18 Oct 2012, at 15:58, Juanjo wrote