Re: [rt-users] DBD::mysql::st execute failed: MySQL server has goneaway at
Ok here is some more diags I have deleted the database and recreated the database from the installation instructions. I am still getting the same error. In a browser it says DBD::mysql::st execute failed: MySQL server has gone away at /usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Lock/MySQL.pm line 71. This is the last few lines of the log says this: HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x2af2d455f180)', 'TimeEstimated', '', 'Status', 'new', 'new-DependsOn', '', 'Queue', 'General', ...) called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1284 eval {...} called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1274 HTML::Mason::Request::comp('undef', 'undef', 'undef', 'TimeEstimated', '', 'Status', 'new', 'new-DependsOn', '', ...) called at /opt/rt3/share/html/autohandler line 308 HTML::Mason::Commands::__ANON__('TimeEstimated', '', 'Status', 'new', 'new-DependsOn', '', 'Queue', 'General', 'AdminCc', ...) called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x2af2d4188ed0)', 'TimeEstimated', '', 'Status', 'new', 'new-DependsOn', '', 'Queue', 'General', ...) called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1279 eval {...} called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1274 HTML::Mason::Request::comp('undef', 'undef', 'undef', 'TimeEstimated', '', 'Status', 'new', 'new-DependsOn', '', ...) called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 473 eval {...} called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 473 eval {...} called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 425 HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x2af2d44ad6d0)') called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm line 168 HTML::Mason::Request::ApacheHandler::exec('RT::Interface::Web::Request=HASH(0x2af2d44ad6d0)') called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm line 825 HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x2af2d10de3f0)', 'Apache2::RequestRec=SCALAR(0x2af2d430fa50)') called at /opt/rt3/bin/webmux.pl line 148 eval {...} called at /opt/rt3/bin/webmux.pl line 148 RT::Mason::handler('Apache2::RequestRec=SCALAR(0x2af2d430fa50)') called at -e line 0 eval {...} called at -e line 0 (/usr/lib/perl5/5.8.8/Carp.pm:272) [Sun Oct 26 11:21:28 2008] [warning]: DBD::mysql::st execute failed: MySQL server has gone away at /usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Store/DBI.pm line 67. (/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Store/DBI.pm:67) [Sun Oct 26 11:21:28 2008] [warning]: DBD::mysql::st execute failed: MySQL server has gone away at /usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Lock/MySQL.pm line 71. (/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Lock/MySQL.pm:71) Please can someone help with this. Thank you Kobus Ruslan Zakirov wrote: Have you done steps from UPGRADING.mysql? On Sat, Oct 25, 2008 at 12:08 AM, Kobus Bensch <[EMAIL PROTECTED]> wrote: No nothing in the mysql log. I juast had to restart the server and i sent one ticket via email and it generated a 122mb log file. There is something really wrong here and I dont know what and why. I had RT running on a server with i386 acrch and version 3.6.5. I then moved it all to a new server and x64 arch and 3.8.1 and now I get all of these errors. [EMAIL PROTECTED] wrote: Anything in the mysql logs ? Sent via BlackBerry from T-Mobile -Original Message- From: Kobus Bensch - No Sig <[EMAIL PROTECTED]> Date: Fri, 24 Oct 2008 21:01:27 To: Curtis Bruneau<[EMAIL PROTECTED]> Cc: Subject: Re: [rt-users] DBD::mysql::st execute failed: MySQL server has gone away at Hi 2GB on rt/db server. I will have to look at the innodb settings, not changed these before so will have to dig around. Ticket volume is very low. Around 20 max a day. I checked httpd and mysql logs and when this occur there is nothing much going on in the logs. Thanks for the help. kobus Curtis Bruneau wrote: Sounds like the oom-killer is getting mysql. How much memory is on your db server? Is it configured in such a way that when the innodb pool is full it's not running out of memory? You shouldn't really have an issue with this unless you have a large amount of tickets. Might want to check some of your other logs and see what's occurring. Apache/mod_perl can be quite memory intensive at times depending how many children are setup, it will slowly grow. Kobus Bensch - No Sig wrote: Hi I am able to access the server, I am able to login, and in some cases even able to brwose normally. The problem I then get is that when I try to create a ticket it thinks a bit and then gives me this error. Due to this error the serv
[rt-users] Muckintrash attachments
Has anybody noticed "duplicate" attachments for what appears to be Mac meta-data popping up on tickets in RT? Anyone have a ready-made solution for preventing/culling them? Some of my local users are confused by the similar entries... Cheers! -- Cambridge Energy Alliance: Save money & the planet ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Display the name of the Requestor in the Reply/Comment composition screen somehow?
On Wed 22.Oct'08 at 17:52:11 +0200, Rainer Duffner wrote: > Hi, > > one thing that new users esp. seem to be missing is the possibility to > display the name of the requestor on the screen where you compose the mail. > Sometimes, our staff creates tickets on customer's behalf, sometimes not. > So, you've got to watch when you type a "reply" and when it's just a > "comment". > > Can this be done relatively easily? > > Searching the wiki didn't give any obvious candidates... Try out the 'ajaxy reply page' extension in the bps-public svn repository. That might do it for you. -j > > Rainer > ___ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: [EMAIL PROTECTED] > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > -- pgpzTsy71WJ2j.pgp Description: PGP signature ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] new install 3.8.1 old database
hello everyone, i installed rt to a new directory and new database. imported all data from my old database and i am not able to login. what can i be doing wrong? mysqldumped the old database for 3.6.7. installed 3.8.1 to different dir and database. imported mysqldumped db from 3.6.7 to 3.8.1 restarted httpd (after updating the new location) i am unable to login. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] new install 3.8.1 old database
Did you run the updates on the old database ? --Original Message-- From: slamp slamp Sender: To: rt-users@lists.bestpractical.com Sent: Oct 26, 2008 21:38 Subject: [rt-users] new install 3.8.1 old database hello everyone, i installed rt to a new directory and new database. imported all data from my old database and i am not able to login. what can i be doing wrong? mysqldumped the old database for 3.6.7. installed 3.8.1 to different dir and database. imported mysqldumped db from 3.6.7 to 3.8.1 restarted httpd (after updating the new location) i am unable to login. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com Sent via BlackBerry from T-Mobile ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] new install 3.8.1 old database
On Mon, Oct 27, 2008 at 7:38 AM, slamp slamp <[EMAIL PROTECTED]> wrote: > hello everyone, i installed rt to a new directory and new database. > imported all data from my old database and i am not able to login. > what can i be doing wrong? > > mysqldumped the old database for 3.6.7. > > installed 3.8.1 to different dir and database. > > imported mysqldumped db from 3.6.7 to 3.8.1 > > restarted httpd (after updating the new location) > > i am unable to login. It's because you did NOT follow the instructions on UPGRADING:-) Once you do that "to the letter", I believe it will work. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ "Life must be understood backwards; but... it must be lived forward." - Soren Kierkegaard "Oh My God! They killed init! You Bastards!" --from a /. post ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Condition scrip
Hi Eli, On Fri, Oct 24, 2008 at 5:26 PM, Eli Altman <[EMAIL PROTECTED]> wrote: > Stefan, RT may already be configured to do what you need right out of the > box. I'd suggest learning more about Scrips and Templates when you have > time. How much experience do you have with RT? > I've been using it for 6 months. I've managed to switch off scrips, create new ones and new templates. So not a total newbie but I haven't mastered the condition scripting. Maybe I did not explain my case too well. I want to initiate an email between my company and a customer and I want to track that conversation. So when I create the ticket the requestor will be me so I don't want to get the default "on create" email back to me. Then I want to go to the ticket and change the requestor from me to the person I want to email. Then I want to attach a document that is specific for that customer but the text in the body of the email will be the same for all customers. Something along the lines of "Please find attached an excel document with queries relating to your claim." (etc,etc). To save me (the company) having to create the email body text each time I was hoping that I could automate it somehow. My thought was to use a condition that would check if the status is going from "New" to "Open" and then send the template. You said: > Scrip Condition: On Open > Action: Notify Requestor > Template: > Stage: TransactionCreate I don't have an "On Open" condition in the condition drop down (In RT 3.6.7). But this could help me out maybe. Regards, Stefan >>I want to initiate a ticket and send a standard email out with an >>attachment that will be different each time. > > Please explain further "with an attachment that will be different each time." > When a ticket is created, by default RT will send an email to the requestor > using the 'Default Autoresponse template' This basically says something > like, "Thank you for submitting a ticket." But you can customize it to say > anything you'd like. > >>My thinking was as follows: >>Users creates new ticket in queue with a subject. >>Selects ticket and changes the requester to the person who will get the email. > > This should happen by default if the scrip action includes Notify Requestor > (which it does for the standard AutoReply scrip) The ticket creator is > usually the Requestor, unless that is overridden by a privileged user when > the ticket is created through the WebUI or overridden using the > CommandByEmail plugin. > >>Selects a reply on the ticket and attaches the document. > > Does the reply document need to be an actual attachment, or can it just be a > canned response in the body of the email? Reason I'm asking, you can > customize 'templates' to display whatever message you'd like in the RT > emails. As earlier, the default email templates in RT are pretty good. I > believe most of us use them with only a few modifications. Actually > attaching a specific file to those emails may be more challenging, but not > out of the question. > >>Now, instead of typing out the same email body every time or copying >>and pasting from an old one, I would like to use the scrips and >>templates to do that. >>I would think I need to put a condition to only send the template when >>the status is changing from New to Open. > > Scrip Condition: On Open > Action: Notify Requestor > Template: > Stage: TransactionCreate > >>As there could be further >>correspondence later I don't want the standard template to go out >>after the initial email. > > If you are saying you don't want the standard AutoReply going out when > someone creates a ticket, you can simply disable that one Scrip by changing > 'Stage' to 'Disabled' on the scrip responsible for the AutoReply. To sum up, > you can create as many custom scrips and templates as you'd like, to be > triggered by anything.. status changing to something specific, based on > content of the subject, the content of the ticket itself, specific > requestors, etc. > > Elias > > > ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com