[rt-users] 0 results after corrupt sessions table, myisamchk

On Friday afternoon, for no apparent reason, while I was the only user on my RT 3.8.0 system, after clicking a link, I was presented with the logon prompt. Puzzled, I entered my username and password and logged back in. Everything seemed normal, and the ticket I was trying to edit was there. I con

[rt-users] 0 results after corrupt sessions table, myisamchk

Additional info: After a short while, I observed the rt.log file was growing at an astounding rate, and quickly grew to fill up the entire available space. Every second or faster, it was filling up with the lines below. Inspired by the first line, I ran another myisamchck against the Attributes.MY

Re: [rt-users] 0 results after corrupt sessions table, myisamchk

Ruslan Zakirov wrote: > > Most of RT's table MUST use InnoDB engine to work correctly. I'm not > sure what's going on but I have feeling that you've disabled innodb > and mysql went wild after that. > Hi Ruslan, To my knowledge, we've never used InnoDB on this system. We upgraded to 3.6.6 months a

[rt-users] SOLVED 0 results after corrupt sessions table, myisamchk

Problem solved. I wrote a loop to go through and convert all of my tables to InnoDB. It choked on the Tickets table, so I ran a "myisamchk -r Tickets" on it, which repaired 7 indexes. I was then able to successfully convert it to InnoDB along with the rest of the tables. Oh Happy Day! It's worki

Re: [rt-users] RT 4 on Amazon EC2

, apache2ctl restart no longer works, but /etc/init.d/apache2ctl restart does. I haven't had time to investigate this yet.  Best, Peter  -- Peter Nikolaidis, CISSP, GCFE, GCIH, GPPA, GSNA http://ParadigmCC.com Ph: 617.517.2940 _ From: François Meehan Sent: Tu

Re: [rt-users] RT 4 on Amazon EC2

Sorry- too quick with the send button. I did have to add a separate swap partition because my instance was indeed running out of memory. I also was not able to quickly get fcgi working, so I just moved on with standard Apache2. I am using the Amazon Ubuntu AMI. Peter -- Peter Nikolaidis, CISSP

[rt-users] rt could not create user from command line

="Joe Blow" EmailAddress=joe.b...@example.com \ Organization="Example Organization Password="asdhjrewkj" Comments=" " rt: # Could not create user. # Could not create user. Any idea what I'm doing wrong? Thanks, Peter -- Peter N

[rt-users] Use lifecycle to set status and invoke Dates page?

Hi,  I'd like to have a lifecycle action called "schedule," which would set the ticket's status to "scheduled" and take the user to the ticket's Dates page so they could set a due date. It's this possible?  Thanks, Peter -- Peter Nikolaidis, CISSP, GCFE

[rt-users] Regex in scrip won't match multi-line strings

need to test in another way? This is an extract of the test I am running: (($self->TicketObj->Subject =~ /Cron \ \/usr\/bin\/s3cmd sync \/var\/spool\/blah\/ s3\:\/\/somes3buckethere\//) && ($self->TicketObj->Body =~ /Done\. Uploaded \d* bytes in \d\.\d seconds/)) Thank you, Pete

Re: [rt-users] Use lifecycle to set status and invoke Dates page?

Hi Matt, Thanks for the reply. What woudl be the callback/action to take someone to the Dates page for a ticket? Thanks again, Peter On Mon, Feb 27, 2017 at 9:22 AM, Matt Zagrabelny wrote: > Hi Peter, > > On Sun, Feb 26, 2017 at 7:59 PM, Peter Nikolaidis > wrote: > > Hi, &

Re: [rt-users] Regex in scrip won't match multi-line strings

bj->Body =~ /^\* Starting Asterisk PBX\: asterisk.*\.\.\.done\.$/ms)) || - Any ideas? Thanks, Peter On Mon, Feb 27, 2017 at 10:57 AM, Matt Zagrabelny wrote: > On Mon, Feb 27, 2017 at 9:48 AM, Peter Nikolaidis > wrote: > > Hi all, > > >

Re: [rt-users] unrecognized roll option "nocreateuser"

nd where is the NOCREATEUSER > coming from? > > Thanks > > Jim Ballantine > - > RT 4.4 and RTIR Training Sessions https://bestpractical.com/training > * Paris - April 24-26, 2017 > -- Peter Nikolaidis CISSP <https://webportal.isc2.org/custom/Certificat