[rt-users] Condition scrip
Hi, Using RT 3.6.7. I want to initiate a ticket and send a standard email out with an attachment that will be different each time. 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. Selects a reply on the ticket and attaches the document. 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. As there could be further correspondence later I don't want the standard template to go out after the initial email. Can anyone help out with this? Point me in the right direction to write user-conditions. Or maybe there is a better way to do this? Thanks, Stefan ___ 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] outside email
No permission to create tickets in the queue 'Partners' i have the everyone group set to create and reply tickets and i also have unprivlidged now and it still gives me this error. Eli Altman wrote: What message/error are you getting, exactly? Have you set the CreateTicket and ReplyToTicket for Everyone? Elias -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of jacharbonneau Sent: Thursday, October 23, 2008 11:03 AM To: rt-users@lists.bestpractical.com Subject: [rt-users] outside email Wondering how to have anyone send an email to a certain mailbox in our company's email that is associated with a queue in fetchmail. I have created the queue and the mailbox and email address but i can only send from email accounts that i have put into users on rt. is there a way so that anyone can send an email to the mailbox with out getting denied and without having to manually put the person's out side email address in rt and associate it with a queue. -- View this message in context: http://www.nabble.com/outside-email-tp19923396p19923396.html Sent from the Request Tracker - User mailing list archive at Nabble.com. ___ 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 ___ 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 -- View this message in context: http://www.nabble.com/outside-email-tp19923396p20148015.html Sent from the Request Tracker - User mailing list archive at Nabble.com. ___ 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] How to determine your RT version
Also from the web interface, click Configuration/Tools/System Configuration .. very useful page Roy Eli Altman wrote: It should be displaying itself at the bottom of each page. If not, I found $VERSION being set in rt3/lib/RT.pm. Elias From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Caraballo Sent: Thursday, October 23, 2008 1:05 PM To: rt-users@lists.bestpractical.com Subject: [rt-users] How to determine your RT version Does anyone know how I may determine what version of RT one has installed? I did this a while back and I want to upgrade yet I have don't know what version I currently have installed. --Mike Caraballo -- The contents of this message may be privileged and confidential. Therefore, if this message has been received in error, please delete it without reading it. All contents of the message, including any attachments, are the copyright property of the sender. This message cannot in any way bind McGarry Bowen, L.L.C. to any contract or other obligation. ___ 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 ___ 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] How to determine your RT version
Thanks so much for this info. Worked out great. On 10/23/08 7:52 PM, Eli Altman [EMAIL PROTECTED] wrote: It should be displaying itself at the bottom of each page. If not, I found $VERSION being set in rt3/lib/RT.pm. Elias From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Caraballo Sent: Thursday, October 23, 2008 1:05 PM To: rt-users@lists.bestpractical.com Subject: [rt-users] How to determine your RT version Does anyone know how I may determine what version of RT one has installed? I did this a while back and I want to upgrade yet I have don't know what version I currently have installed. --Mike Caraballo -- The contents of this message may be privileged and confidential. Therefore, if this message has been received in error, please delete it without reading it. All contents of the message, including any attachments, are the copyright property of the sender. This message cannot in any way bind McGarry Bowen, L.L.C. to any contract or other obligation. -- The contents of this message may be privileged and confidential. Therefore, if this message has been received in error, please delete it without reading it. All contents of the message, including any attachments, are the copyright property of the sender. This message cannot in any way bind McGarry Bowen, L.L.C. to any contract or other obligation. ___ 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] How to determine your RT version
Thanks, this worked. On 10/24/08 6:57 AM, Roy El-Hames [EMAIL PROTECTED] wrote: Also from the web interface, click Configuration/Tools/System Configuration .. very useful page Roy Eli Altman wrote: It should be displaying itself at the bottom of each page. If not, I found $VERSION being set in rt3/lib/RT.pm. Elias From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Caraballo Sent: Thursday, October 23, 2008 1:05 PM To: rt-users@lists.bestpractical.com Subject: [rt-users] How to determine your RT version Does anyone know how I may determine what version of RT one has installed? I did this a while back and I want to upgrade yet I have don't know what version I currently have installed. --Mike Caraballo - - The contents of this message may be privileged and confidential. Therefore, if this message has been received in error, please delete it without reading it. All contents of the message, including any attachments, are the copyright property of the sender. This message cannot in any way bind McGarry Bowen, L.L.C. to any contract or other obligation. ___ 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 -- The contents of this message may be privileged and confidential. Therefore, if this message has been received in error, please delete it without reading it. All contents of the message, including any attachments, are the copyright property of the sender. This message cannot in any way bind McGarry Bowen, L.L.C. to any contract or other obligation. ___ 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] Getting the owner of a ticket fails?
Hello Ruslan, Thanks for the advice! Ruslan Zakirov-2 wrote: It's correct way. Looks like some cache issue. you can use the following code to check if it's cache issue or not: my $ticket = RT::Ticket-new( $RT::SystemUser ); $ticket-Load( $self-TicketObj-id ); and then use this object instead of I was not successful - but I only exchanged $self-TicketObj-Owner in the check for the user ID with $ticket-Owner. I will next try it with exchanging every occurrence. Ruslan Zakirov-2 wrote: On Tue, Oct 21, 2008 at 8:40 PM, kschmitte [EMAIL PROTECTED] wrote: What I can see is that the scrip is executed twice - maybe due to what is described (and what I don't understand either) in Correspond Transaction Twice on Reply in Batchmode (http://www.nabble.com/Correspond-Transaction-Twice-on-Reply-in-Batchmode-td8730015.html#a8730015). Do you use transactions batch mode? If no then it's not related. I think Trasaction Batch Mode is for newer Version of RT? I'm using 3.6.5 and can't see anything like that ... Thanks - and best regards, Kai -- View this message in context: http://www.nabble.com/Getting-the-owner-of-a-ticket-fails--tp20094432p20150417.html Sent from the Request Tracker - User mailing list archive at Nabble.com. ___ 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] outside email
I have also went into the RT_SiteConfig and changed Set($SenderMustExistInExternalDatabase , undef) i changed the undef to 0 will this also cause issue if i have set the everyone group to create and reply i have also set unpriviledged group to create and reply also. Eli Altman wrote: What message/error are you getting, exactly? Have you set the CreateTicket and ReplyToTicket for Everyone? Elias -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of jacharbonneau Sent: Thursday, October 23, 2008 11:03 AM To: rt-users@lists.bestpractical.com Subject: [rt-users] outside email Wondering how to have anyone send an email to a certain mailbox in our company's email that is associated with a queue in fetchmail. I have created the queue and the mailbox and email address but i can only send from email accounts that i have put into users on rt. is there a way so that anyone can send an email to the mailbox with out getting denied and without having to manually put the person's out side email address in rt and associate it with a queue. -- View this message in context: http://www.nabble.com/outside-email-tp19923396p19923396.html Sent from the Request Tracker - User mailing list archive at Nabble.com. ___ 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 ___ 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 -- View this message in context: http://www.nabble.com/outside-email-tp19923396p20150828.html Sent from the Request Tracker - User mailing list archive at Nabble.com. ___ 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] Custom Field updates Status Field?
Any recommendations on a good start for using Custom field values to update the status field? Example: Bob in Art Department wants the GUI to have (Accepted Task, WIP, Project Completed) however, licensing want the statuses to remain the same. So I need the ability to change the status filed based on a simple combo box with the other values. I am sure it is a scrip solution but I would like to know how to link the two. -Mark ___ 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
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 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: create your own 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
Re: [rt-users] outside email
What version of RT are you running? How did you install it and have you made any modifications to it since the install? I can't remember if RT creates non privileged users by default when a ticket is create via email. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of jacharbonneau Sent: Friday, October 24, 2008 7:05 AM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] outside email I have also went into the RT_SiteConfig and changed Set($SenderMustExistInExternalDatabase , undef) i changed the undef to 0 will this also cause issue if i have set the everyone group to create and reply i have also set unpriviledged group to create and reply also. Eli Altman wrote: What message/error are you getting, exactly? Have you set the CreateTicket and ReplyToTicket for Everyone? Elias -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of jacharbonneau Sent: Thursday, October 23, 2008 11:03 AM To: rt-users@lists.bestpractical.com Subject: [rt-users] outside email Wondering how to have anyone send an email to a certain mailbox in our company's email that is associated with a queue in fetchmail. I have created the queue and the mailbox and email address but i can only send from email accounts that i have put into users on rt. is there a way so that anyone can send an email to the mailbox with out getting denied and without having to manually put the person's out side email address in rt and associate it with a queue. -- ___ 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] Custom Field updates Status Field?
Mark, with some custom modding I suppose it would be possible to have the Status display differently depending on a user or ticket customfield. You would also need a custom field for the ticket or user to hold the department. In my installation, we use an LDAP for all of our users, so this information is pulled automatically and placed in a CF called 'Department' for the ticket. You would need to add one additional Active status in your RT_SiteConfig called 'working' Set(@ActiveStatus, qw(new open working stalled)); You would then have to mod your share/html/Elements/SelectStatus to check what the department is in the customfield and display either the actual status names in the drop-down or your replacements. I imagine you'd also need to mod /share/html/Ticket/Elements/ShowBasics so it displays the alternate labels correctly in the ticket. You'll need some perl experience to do this cleanly. Unless you like this sort of challenge, you'd be better off telling Bob in the Art Department to just imagine he's seeing Accepted Task, WIP, Completed instead of New, Open, Working and Resolved. Worst case, just add the additional Active Status into your SiteConfig and restart apache to see the change. Elias -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Grob Sent: Friday, October 24, 2008 6:42 AM To: rt-users@lists.bestpractical.com Subject: [rt-users] Custom Field updates Status Field? Any recommendations on a good start for using Custom field values to update the status field? Example: Bob in Art Department wants the GUI to have (Accepted Task, WIP, Project Completed) however, licensing want the statuses to remain the same. So I need the ability to change the status filed based on a simple combo box with the other values. I am sure it is a scrip solution but I would like to know how to link the two. -Mark ___ 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 ___ 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] outside email
Just received this info from the person who built the server the source code hasn't been changed It was build from freebsd ports it's setup for ad auth via apache heimdal module -Original Message- From: Eli Altman [mailto:[EMAIL PROTECTED] Sent: Friday, October 24, 2008 11:33 AM To: Joe Charbonneau; rt-users@lists.bestpractical.com Subject: RE: [rt-users] outside email What version of RT are you running? How did you install it and have you made any modifications to it since the install? I can't remember if RT creates non privileged users by default when a ticket is create via email. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of jacharbonneau Sent: Friday, October 24, 2008 7:05 AM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] outside email I have also went into the RT_SiteConfig and changed Set($SenderMustExistInExternalDatabase , undef) i changed the undef to 0 will this also cause issue if i have set the everyone group to create and reply i have also set unpriviledged group to create and reply also. Eli Altman wrote: What message/error are you getting, exactly? Have you set the CreateTicket and ReplyToTicket for Everyone? Elias -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of jacharbonneau Sent: Thursday, October 23, 2008 11:03 AM To: rt-users@lists.bestpractical.com Subject: [rt-users] outside email Wondering how to have anyone send an email to a certain mailbox in our company's email that is associated with a queue in fetchmail. I have created the queue and the mailbox and email address but i can only send from email accounts that i have put into users on rt. is there a way so that anyone can send an email to the mailbox with out getting denied and without having to manually put the person's out side email address in rt and associate it with a queue. -- ___ 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] outside email
What version of RT again? There may be better options for AD authentication out there. Has this server been running for a while, is it filled with tickets yet? Has this installation of RT ever dealt with tickets created via email before? New issue or existing? -Original Message- From: Joe Charbonneau [mailto:[EMAIL PROTECTED] Sent: Friday, October 24, 2008 8:47 AM To: Eli Altman; rt-users@lists.bestpractical.com Subject: RE: [rt-users] outside email Just received this info from the person who built the server the source code hasn't been changed It was build from freebsd ports it's setup for ad auth via apache heimdal module -Original Message- From: Eli Altman [mailto:[EMAIL PROTECTED] Sent: Friday, October 24, 2008 11:33 AM To: Joe Charbonneau; rt-users@lists.bestpractical.com Subject: RE: [rt-users] outside email What version of RT are you running? How did you install it and have you made any modifications to it since the install? I can't remember if RT creates non privileged users by default when a ticket is create via email. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of jacharbonneau Sent: Friday, October 24, 2008 7:05 AM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] outside email I have also went into the RT_SiteConfig and changed Set($SenderMustExistInExternalDatabase , undef) i changed the undef to 0 will this also cause issue if i have set the everyone group to create and reply i have also set unpriviledged group to create and reply also. Eli Altman wrote: What message/error are you getting, exactly? Have you set the CreateTicket and ReplyToTicket for Everyone? Elias -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of jacharbonneau Sent: Thursday, October 23, 2008 11:03 AM To: rt-users@lists.bestpractical.com Subject: [rt-users] outside email Wondering how to have anyone send an email to a certain mailbox in our company's email that is associated with a queue in fetchmail. I have created the queue and the mailbox and email address but i can only send from email accounts that i have put into users on rt. is there a way so that anyone can send an email to the mailbox with out getting denied and without having to manually put the person's out side email address in rt and associate it with a queue. -- ___ 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] outside email
3.6.3 this is a new issue we are trying to get customers to send us trouble tickets -Original Message- From: Eli Altman [mailto:[EMAIL PROTECTED] Sent: Friday, October 24, 2008 12:02 PM To: Joe Charbonneau; rt-users@lists.bestpractical.com Subject: RE: [rt-users] outside email What version of RT again? There may be better options for AD authentication out there. Has this server been running for a while, is it filled with tickets yet? Has this installation of RT ever dealt with tickets created via email before? New issue or existing? -Original Message- From: Joe Charbonneau [mailto:[EMAIL PROTECTED] Sent: Friday, October 24, 2008 8:47 AM To: Eli Altman; rt-users@lists.bestpractical.com Subject: RE: [rt-users] outside email Just received this info from the person who built the server the source code hasn't been changed It was build from freebsd ports it's setup for ad auth via apache heimdal module -Original Message- From: Eli Altman [mailto:[EMAIL PROTECTED] Sent: Friday, October 24, 2008 11:33 AM To: Joe Charbonneau; rt-users@lists.bestpractical.com Subject: RE: [rt-users] outside email What version of RT are you running? How did you install it and have you made any modifications to it since the install? I can't remember if RT creates non privileged users by default when a ticket is create via email. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of jacharbonneau Sent: Friday, October 24, 2008 7:05 AM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] outside email I have also went into the RT_SiteConfig and changed Set($SenderMustExistInExternalDatabase , undef) i changed the undef to 0 will this also cause issue if i have set the everyone group to create and reply i have also set unpriviledged group to create and reply also. Eli Altman wrote: What message/error are you getting, exactly? Have you set the CreateTicket and ReplyToTicket for Everyone? Elias -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of jacharbonneau Sent: Thursday, October 23, 2008 11:03 AM To: rt-users@lists.bestpractical.com Subject: [rt-users] outside email Wondering how to have anyone send an email to a certain mailbox in our company's email that is associated with a queue in fetchmail. I have created the queue and the mailbox and email address but i can only send from email accounts that i have put into users on rt. is there a way so that anyone can send an email to the mailbox with out getting denied and without having to manually put the person's out side email address in rt and associate it with a queue. -- ___ 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] outside email
The installation unfortunately is not new its about 9700 tickets old. I will have to mull over the other options with my higher ups to see what they think. Thanks for your help. -Original Message- From: Eli Altman [mailto:[EMAIL PROTECTED] Sent: Friday, October 24, 2008 1:08 PM To: Joe Charbonneau Subject: RE: [rt-users] outside email Also is this a new installation, like is it filled with tickets? I would almost recommend installing the newest version as a clean install, add the Authen-ExternalAuth plugin and get that up and running. If that's not an option, upgrading is possible and I suppose you could attempt and install of the plugin into your installation. It just might get messy. -Original Message- From: Joe Charbonneau [mailto:[EMAIL PROTECTED] Sent: Friday, October 24, 2008 10:06 AM To: Eli Altman Subject: RE: [rt-users] outside email Sorry about that I don't think it auto creates users from ad as I have to actually go to the web UI to create the user with there domain account. So everything after that I do not think happens. -Original Message- From: Eli Altman [mailto:[EMAIL PROTECTED] Sent: Friday, October 24, 2008 12:48 PM To: Joe Charbonneau Subject: RE: [rt-users] outside email Nope. Please answer my previous questions as best you can if you'd like me to help further. -Original Message- From: Joe Charbonneau [mailto:[EMAIL PROTECTED] Sent: Friday, October 24, 2008 9:47 AM To: Eli Altman Subject: RE: [rt-users] outside email Would there be anykind of canceling out if I have everyone and unprivilidged set to create and reply -Original Message- From: Eli Altman [mailto:[EMAIL PROTECTED] Sent: Friday, October 24, 2008 12:37 PM To: Joe Charbonneau Subject: RE: [rt-users] outside email Also, do you currently have RT setup to automatically create the user and pull their information from AD on ticket create or login to WebUI? Normally on login to the WebUI, with the Authen-ExternalAuth plugin (possible better alternative to apache heimdal module) it would first check the LDAP (or AD in your case) to see if a user exists and password is correct. If it does exists, it creates the user in the local RT users and will pull any of their information you'd like. Otherwise it would fall back to the local RT users to check if it exists and if the password is correct. Authen-ExternalAuth will also be triggered if RT receives an email. It will first check the email address against the LDAP (or AD) to check whether the user exists, if not it will check against the local RT users, if that doesn't work it will simply create a more-or-less blank user with no password but their email address as their user. This user will be non-privileged and will also not be able to login to the WebUI. For this to work all you'd need to do is set the CreateTicket and ReplyToTicket rights to the Unprivileged group and it should work just fine. -Original Message- From: Joe Charbonneau [mailto:[EMAIL PROTECTED] Sent: Friday, October 24, 2008 9:21 AM To: Eli Altman Subject: RE: [rt-users] outside email OH no this was never working something we are trying to implement sorry about that. -Original Message- From: Eli Altman [mailto:[EMAIL PROTECTED] Sent: Friday, October 24, 2008 12:20 PM To: Joe Charbonneau Subject: RE: [rt-users] outside email By new issue I meant was it working just fine, now it isn't? -Original Message- From: Joe Charbonneau [mailto:[EMAIL PROTECTED] Sent: Friday, October 24, 2008 9:05 AM To: Eli Altman; rt-users@lists.bestpractical.com Subject: RE: [rt-users] outside email 3.6.3 this is a new issue we are trying to get customers to send us trouble tickets -Original Message- From: Eli Altman [mailto:[EMAIL PROTECTED] Sent: Friday, October 24, 2008 12:02 PM To: Joe Charbonneau; rt-users@lists.bestpractical.com Subject: RE: [rt-users] outside email What version of RT again? There may be better options for AD authentication out there. Has this server been running for a while, is it filled with tickets yet? Has this installation of RT ever dealt with tickets created via email before? New issue or existing? -Original Message- From: Joe Charbonneau [mailto:[EMAIL PROTECTED] Sent: Friday, October 24, 2008 8:47 AM To: Eli Altman; rt-users@lists.bestpractical.com Subject: RE: [rt-users] outside email Just received this info from the person who built the server the source code hasn't been changed It was build from freebsd ports it's setup for ad auth via apache heimdal module -Original Message- From: Eli Altman [mailto:[EMAIL PROTECTED] Sent: Friday, October 24, 2008 11:33 AM To: Joe Charbonneau; rt-users@lists.bestpractical.com Subject: RE: [rt-users] outside email What version of RT are you running? How did you install it and have you made any modifications to it since the install? I can't remember if RT creates non privileged users by default when a ticket is create via email. -Original
Re: [rt-users] outside email
Try a separate install of 3.8.1 into a different location using a different db name, get ExternalAuth running on it using AD, then copy the entire DB from the old installation and run the update script to get it compatible to 3.8.1. Make sure everything looks good on the new test install, then just point the web server to the new install. Are you familiar with VirtualHosts in apache? I have two separate installs of RT on the same box, using different install locations and different dbs in MySql. One is production and one is a dev box for testing updates/mods. IMO you should set this up instead of trying to upgrade/patch the current production RT. Cleaner and safer this way. Elias -Original Message- From: Joe Charbonneau [mailto:[EMAIL PROTECTED] Sent: Friday, October 24, 2008 10:12 AM To: Eli Altman; rt-users@lists.bestpractical.com Subject: RE: [rt-users] outside email The installation unfortunately is not new its about 9700 tickets old. I will have to mull over the other options with my higher ups to see what they think. Thanks for your help. -Original Message- From: Eli Altman [mailto:[EMAIL PROTECTED] Sent: Friday, October 24, 2008 1:08 PM To: Joe Charbonneau Subject: RE: [rt-users] outside email Also is this a new installation, like is it filled with tickets? I would almost recommend installing the newest version as a clean install, add the Authen-ExternalAuth plugin and get that up and running. If that's not an option, upgrading is possible and I suppose you could attempt and install of the plugin into your installation. It just might get messy. -Original Message- From: Joe Charbonneau [mailto:[EMAIL PROTECTED] Sent: Friday, October 24, 2008 10:06 AM To: Eli Altman Subject: RE: [rt-users] outside email Sorry about that I don't think it auto creates users from ad as I have to actually go to the web UI to create the user with there domain account. So everything after that I do not think happens. -Original Message- From: Eli Altman [mailto:[EMAIL PROTECTED] Sent: Friday, October 24, 2008 12:48 PM To: Joe Charbonneau Subject: RE: [rt-users] outside email Nope. Please answer my previous questions as best you can if you'd like me to help further. -Original Message- From: Joe Charbonneau [mailto:[EMAIL PROTECTED] Sent: Friday, October 24, 2008 9:47 AM To: Eli Altman Subject: RE: [rt-users] outside email Would there be anykind of canceling out if I have everyone and unprivilidged set to create and reply -Original Message- From: Eli Altman [mailto:[EMAIL PROTECTED] Sent: Friday, October 24, 2008 12:37 PM To: Joe Charbonneau Subject: RE: [rt-users] outside email Also, do you currently have RT setup to automatically create the user and pull their information from AD on ticket create or login to WebUI? Normally on login to the WebUI, with the Authen-ExternalAuth plugin (possible better alternative to apache heimdal module) it would first check the LDAP (or AD in your case) to see if a user exists and password is correct. If it does exists, it creates the user in the local RT users and will pull any of their information you'd like. Otherwise it would fall back to the local RT users to check if it exists and if the password is correct. Authen-ExternalAuth will also be triggered if RT receives an email. It will first check the email address against the LDAP (or AD) to check whether the user exists, if not it will check against the local RT users, if that doesn't work it will simply create a more-or-less blank user with no password but their email address as their user. This user will be non-privileged and will also not be able to login to the WebUI. For this to work all you'd need to do is set the CreateTicket and ReplyToTicket rights to the Unprivileged group and it should work just fine. -Original Message- From: Joe Charbonneau [mailto:[EMAIL PROTECTED] Sent: Friday, October 24, 2008 9:21 AM To: Eli Altman Subject: RE: [rt-users] outside email OH no this was never working something we are trying to implement sorry about that. -Original Message- From: Eli Altman [mailto:[EMAIL PROTECTED] Sent: Friday, October 24, 2008 12:20 PM To: Joe Charbonneau Subject: RE: [rt-users] outside email By new issue I meant was it working just fine, now it isn't? -Original Message- From: Joe Charbonneau [mailto:[EMAIL PROTECTED] Sent: Friday, October 24, 2008 9:05 AM To: Eli Altman; rt-users@lists.bestpractical.com Subject: RE: [rt-users] outside email 3.6.3 this is a new issue we are trying to get customers to send us trouble tickets -Original Message- From: Eli Altman [mailto:[EMAIL PROTECTED] Sent: Friday, October 24, 2008 12:02 PM To: Joe Charbonneau; rt-users@lists.bestpractical.com Subject: RE: [rt-users] outside email What version of RT again? There may be better options for AD authentication out there. Has this server been running for a while, is it filled with tickets yet? Has this installation of RT
[rt-users] rt 3.8.1: Graphical charts are not available. error
Hi folks, I hope this is the right list to submit my quesstion. Sorry in advance if it isn't. I upgraded to rt 3.8.1 last month and when I try to plot (bar or pie) the output of ticket searches I get the error Graphical charts are not available. I looked in the archives and saw the following Re: Hierarchy View in 3.8 by Helmuth Ramirez. Following this thread I did the following: - installed graphviz from http://www.graphviz.org/ using yum install 'graphviz*' I got the error: yum install graphviz-php.i386 -- missing dependency graphviz = 2.16-1.el5 is needed by package graphviz-php So I then - - downloaded the source from http://www.graphviz.org/ and installed it. - yum install webdot and did a perl -MCPAN -e 'install GraphViz' - ran the command dot -c in an xterm. rebooted the system and still no luck. I see the following in the apache2.access log file but nothing looks like a glaring reason why it won't graph: xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:01 -0400] GET /Search/Chart.html?Order=ASC%7CASC%7CASC%7CASCQuery=Queue+%3D+%27Problems%27Rows=50OrderBy=id%7C%7C%7CFormat=%27+++%3Cb%3E%3Ca+href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3A%23%27%2C%0D%0A%27%3Cb%3E%3Ca+href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__Subject__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3ASubject%27%2C%0D%0A%27__Status__%27%2C%0D%0A%27__QueueName__%27%2C%0D%0A%27__OwnerName__%27%2C%0D%0A%27__Priority__%27%2C%0D%0A%27__NEWLINE__%27%2C%0D%0A%27%27%2C%0D%0A%27%3Csmall%3E__Requestors__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__CreatedRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__ToldRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__LastUpdatedRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__TimeLeft__%3C%2Fsmall%3E%27ChartStyle=barPrimaryGroupBy=Status HTTP/1.1 200 13787 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:01 -0400] GET /NoAuth/css/web2/main-squished.css HTTP/1.1 200 21842 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] GET /NoAuth/css/print.css HTTP/1.1 200 443 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] GET /NoAuth/js/util.js HTTP/1.1 200 6190 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] GET /NoAuth/js/titlebox-state.js HTTP/1.1 200 928 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] GET /NoAuth/js/ahah.js HTTP/1.1 200 1032 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] GET /NoAuth/js/prototype/prototype.js HTTP/1.1 200 124137 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] GET /NoAuth/js/scriptaculous/scriptaculous.js?load=effects,controls HTTP/1.1 200 2655 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] GET /NoAuth/js/scriptaculous/effects.js HTTP/1.1 200 38986 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] GET /NoAuth/js/scriptaculous/controls.js HTTP/1.1 200 34927 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] GET /NoAuth/RichText/fckeditor.js HTTP/1.1 200 8983 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] GET /NoAuth/webrtfm.css HTTP/1.1 200 513 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] GET /NoAuth/css/calendar.css HTTP/1.1 200 746 There doesn't seem like there needs to be an entry for this in the RT_SiteConfig.pm file in order to get this to work but I could be missing the bleeding obvious. All suggestions welcome! thanks. janet ___ 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] rt 3.8.1: Graphical charts are not available. error
AFAIK GraphViz is only used to show relationship charts for dependencies, linked tickets, etc. Instead GD is used for displaying charts based on ticket search results (GD::Graph) Am I wrong? I assume Graphs based on ticket search results was working before the upgrade. Try adding this to your RT_SiteConfig: Set($DisableGD, 0); or Set($DisableGD, undef); If that doesn't work after an apache restart, there are other things to try. Also if someone out there knows, does --enable-gd during RT configure simply set the DisableGD value in RT_Config to undef or 1? Elias -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Janet Houser Sent: Friday, October 24, 2008 10:20 AM To: RT-Users@lists.bestpractical.com Subject: [rt-users] rt 3.8.1: Graphical charts are not available. error Hi folks, I hope this is the right list to submit my quesstion. Sorry in advance if it isn't. I upgraded to rt 3.8.1 last month and when I try to plot (bar or pie) the output of ticket searches I get the error Graphical charts are not available. I looked in the archives and saw the following Re: Hierarchy View in 3.8 by Helmuth Ramirez. Following this thread I did the following: - installed graphviz from http://www.graphviz.org/ using yum install 'graphviz*' I got the error: yum install graphviz-php.i386 -- missing dependency graphviz = 2.16-1.el5 is needed by package graphviz-php So I then - - downloaded the source from http://www.graphviz.org/ and installed it. - yum install webdot and did a perl -MCPAN -e 'install GraphViz' - ran the command dot -c in an xterm. rebooted the system and still no luck. I see the following in the apache2.access log file but nothing looks like a glaring reason why it won't graph: xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:01 -0400] GET /Search/Chart.html?Order=ASC%7CASC%7CASC%7CASCQuery=Queue+%3D+%27Problems%27Rows=50OrderBy=id%7C%7C%7CFormat=%27+++%3Cb%3E%3Ca+href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3A%23%27%2C%0D%0A%27%3Cb%3E%3Ca+href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__Subject__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3ASubject%27%2C%0D%0A%27__Status__%27%2C%0D%0A%27__QueueName__%27%2C%0D%0A%27__OwnerName__%27%2C%0D%0A%27__Priority__%27%2C%0D%0A%27__NEWLINE__%27%2C%0D%0A%27%27%2C%0D%0A%27%3Csmall%3E__Requestors__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__CreatedRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__ToldRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__LastUpdatedRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__TimeLeft__%3C%2Fsmall%3E%27ChartStyle=barPrimaryGroupBy=Status HTTP/1.1 200 13787 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:01 -0400] GET /NoAuth/css/web2/main-squished.css HTTP/1.1 200 21842 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] GET /NoAuth/css/print.css HTTP/1.1 200 443 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] GET /NoAuth/js/util.js HTTP/1.1 200 6190 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] GET /NoAuth/js/titlebox-state.js HTTP/1.1 200 928 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] GET /NoAuth/js/ahah.js HTTP/1.1 200 1032 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] GET /NoAuth/js/prototype/prototype.js HTTP/1.1 200 124137 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] GET /NoAuth/js/scriptaculous/scriptaculous.js?load=effects,controls HTTP/1.1 200 2655 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] GET /NoAuth/js/scriptaculous/effects.js HTTP/1.1 200 38986 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] GET /NoAuth/js/scriptaculous/controls.js HTTP/1.1 200 34927 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] GET /NoAuth/RichText/fckeditor.js HTTP/1.1 200 8983 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] GET /NoAuth/webrtfm.css HTTP/1.1 200 513 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] GET /NoAuth/css/calendar.css HTTP/1.1 200 746 There doesn't seem like there needs to be an entry for this in the RT_SiteConfig.pm file in order to get this to work but I could be missing the bleeding obvious. All suggestions welcome! thanks. janet ___ 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 ___ 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] rt 3.8.1: Graphical charts are not available. error
I would try reinstalling GD::Graph from CPAN (forcing if necessary). Perhaps the RT upgrade was coincidental to a redhat perl rpm upgrade? Janet Houser wrote: Hi folks, I hope this is the right list to submit my quesstion. Sorry in advance if it isn't. I upgraded to rt 3.8.1 last month and when I try to plot (bar or pie) the output of ticket searches I get the error Graphical charts are not available. I looked in the archives and saw the following Re: Hierarchy View in 3.8 by Helmuth Ramirez. Following this thread I did the following: - installed graphviz from http://www.graphviz.org/ using yum install 'graphviz*' I got the error: yum install graphviz-php.i386 -- missing dependency graphviz = 2.16-1.el5 is needed by package graphviz-php So I then - - downloaded the source from http://www.graphviz.org/ and installed it. - yum install webdot and did a perl -MCPAN -e 'install GraphViz' - ran the command dot -c in an xterm. rebooted the system and still no luck. I see the following in the apache2.access log file but nothing looks like a glaring reason why it won't graph: xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:01 -0400] GET /Search/Chart.html?Order=ASC%7CASC%7CASC%7CASCQuery=Queue+%3D+%27Problems%27Rows=50OrderBy=id%7C%7C%7CFormat=%27+++%3Cb%3E%3Ca+href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3A%23%27%2C%0D%0A%27%3Cb%3E%3Ca+href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__Subject__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3ASubject%27%2C%0D%0A%27__Status__%27%2C%0D%0A%27__QueueName__%27%2C%0D%0A%27__OwnerName__%27%2C%0D%0A%27__Priority__%27%2C%0D%0A%27__NEWLINE__%27%2C%0D%0A%27%27%2C%0D%0A%27%3Csmall%3E__Requestors__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__CreatedRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__ToldRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__LastUpdatedRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__TimeLeft__%3C%2Fsmall%3E%27ChartStyle=barPrimaryGroupBy=Status HTTP/1.1 200 13787 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:01 -0400] GET /NoAuth/css/web2/main-squished.css HTTP/1.1 200 21842 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] GET /NoAuth/css/print.css HTTP/1.1 200 443 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] GET /NoAuth/js/util.js HTTP/1.1 200 6190 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] GET /NoAuth/js/titlebox-state.js HTTP/1.1 200 928 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] GET /NoAuth/js/ahah.js HTTP/1.1 200 1032 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] GET /NoAuth/js/prototype/prototype.js HTTP/1.1 200 124137 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] GET /NoAuth/js/scriptaculous/scriptaculous.js?load=effects,controls HTTP/1.1 200 2655 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] GET /NoAuth/js/scriptaculous/effects.js HTTP/1.1 200 38986 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] GET /NoAuth/js/scriptaculous/controls.js HTTP/1.1 200 34927 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] GET /NoAuth/RichText/fckeditor.js HTTP/1.1 200 8983 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] GET /NoAuth/webrtfm.css HTTP/1.1 200 513 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] GET /NoAuth/css/calendar.css HTTP/1.1 200 746 There doesn't seem like there needs to be an entry for this in the RT_SiteConfig.pm file in order to get this to work but I could be missing the bleeding obvious. All suggestions welcome! thanks. janet ___ 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 -- Drew Barnes Applications Analyst Network Resources Department Raymond Walters College University of Cincinnati ___ 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] rt 3.8.1: Graphical charts are not available. error
It appears '--enable-gd' or '--with-gd' in configure simply turns on the testing for whether GD is installed and working, if so it will either set DisableGD to 1 or undef depending on the test. Janet, I'm betting DisableGD set to undef is what will make the magic happen. -Original Message- From: Eli Altman Sent: Friday, October 24, 2008 10:51 AM To: 'Janet Houser'; RT-Users@lists.bestpractical.com Subject: RE: [rt-users] rt 3.8.1: Graphical charts are not available. error AFAIK GraphViz is only used to show relationship charts for dependencies, linked tickets, etc. Instead GD is used for displaying charts based on ticket search results (GD::Graph) Am I wrong? I assume Graphs based on ticket search results was working before the upgrade. Try adding this to your RT_SiteConfig: Set($DisableGD, 0); or Set($DisableGD, undef); If that doesn't work after an apache restart, there are other things to try. Also if someone out there knows, does --enable-gd during RT configure simply set the DisableGD value in RT_Config to undef or 1? Elias -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Janet Houser Sent: Friday, October 24, 2008 10:20 AM To: RT-Users@lists.bestpractical.com Subject: [rt-users] rt 3.8.1: Graphical charts are not available. error Hi folks, I hope this is the right list to submit my quesstion. Sorry in advance if it isn't. I upgraded to rt 3.8.1 last month and when I try to plot (bar or pie) the output of ticket searches I get the error Graphical charts are not available. I looked in the archives and saw the following Re: Hierarchy View in 3.8 by Helmuth Ramirez. Following this thread I did the following: - installed graphviz from http://www.graphviz.org/ using yum install 'graphviz*' I got the error: yum install graphviz-php.i386 -- missing dependency graphviz = 2.16-1.el5 is needed by package graphviz-php So I then - - downloaded the source from http://www.graphviz.org/ and installed it. - yum install webdot and did a perl -MCPAN -e 'install GraphViz' - ran the command dot -c in an xterm. rebooted the system and still no luck. I see the following in the apache2.access log file but nothing looks like a glaring reason why it won't graph: xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:01 -0400] GET /Search/Chart.html?Order=ASC%7CASC%7CASC%7CASCQuery=Queue+%3D+%27Problems%27Rows=50OrderBy=id%7C%7C%7CFormat=%27+++%3Cb%3E%3Ca+href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3A%23%27%2C%0D%0A%27%3Cb%3E%3Ca+href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__Subject__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3ASubject%27%2C%0D%0A%27__Status__%27%2C%0D%0A%27__QueueName__%27%2C%0D%0A%27__OwnerName__%27%2C%0D%0A%27__Priority__%27%2C%0D%0A%27__NEWLINE__%27%2C%0D%0A%27%27%2C%0D%0A%27%3Csmall%3E__Requestors__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__CreatedRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__ToldRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__LastUpdatedRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__TimeLeft__%3C%2Fsmall%3E%27ChartStyle=barPrimaryGroupBy=Status HTTP/1.1 200 13787 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:01 -0400] GET /NoAuth/css/web2/main-squished.css HTTP/1.1 200 21842 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] GET /NoAuth/css/print.css HTTP/1.1 200 443 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] GET /NoAuth/js/util.js HTTP/1.1 200 6190 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] GET /NoAuth/js/titlebox-state.js HTTP/1.1 200 928 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] GET /NoAuth/js/ahah.js HTTP/1.1 200 1032 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] GET /NoAuth/js/prototype/prototype.js HTTP/1.1 200 124137 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] GET /NoAuth/js/scriptaculous/scriptaculous.js?load=effects,controls HTTP/1.1 200 2655 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] GET /NoAuth/js/scriptaculous/effects.js HTTP/1.1 200 38986 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] GET /NoAuth/js/scriptaculous/controls.js HTTP/1.1 200 34927 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] GET /NoAuth/RichText/fckeditor.js HTTP/1.1 200 8983 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] GET /NoAuth/webrtfm.css HTTP/1.1 200 513 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] GET /NoAuth/css/calendar.css HTTP/1.1 200 746 There doesn't seem like there needs to be an entry for this in the RT_SiteConfig.pm file in order to get this to work but I could be missing the bleeding obvious. All suggestions welcome! thanks. janet ___ 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] rt 3.8.1: Graphical charts are not available. error
Janet, if after the SiteConfig mod you get You've enabled GD, but we couldn't load the module: xxx then you need to reinstall GD::Graph as Drew suggested. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Drew Barnes Sent: Friday, October 24, 2008 10:59 AM To: Janet Houser Cc: RT-Users@lists.bestpractical.com Subject: Re: [rt-users] rt 3.8.1: Graphical charts are not available. error I would try reinstalling GD::Graph from CPAN (forcing if necessary). Perhaps the RT upgrade was coincidental to a redhat perl rpm upgrade? Janet Houser wrote: Hi folks, I hope this is the right list to submit my quesstion. Sorry in advance if it isn't. I upgraded to rt 3.8.1 last month and when I try to plot (bar or pie) the output of ticket searches I get the error Graphical charts are not available. I looked in the archives and saw the following Re: Hierarchy View in 3.8 by Helmuth Ramirez. Following this thread I did the following: - installed graphviz from http://www.graphviz.org/ using yum install 'graphviz*' I got the error: yum install graphviz-php.i386 -- missing dependency graphviz = 2.16-1.el5 is needed by package graphviz-php So I then - - downloaded the source from http://www.graphviz.org/ and installed it. - yum install webdot and did a perl -MCPAN -e 'install GraphViz' - ran the command dot -c in an xterm. rebooted the system and still no luck. I see the following in the apache2.access log file but nothing looks like a glaring reason why it won't graph: xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:01 -0400] GET /Search/Chart.html?Order=ASC%7CASC%7CASC%7CASCQuery=Queue+%3D+%27Problems%27Rows=50OrderBy=id%7C%7C%7CFormat=%27+++%3Cb%3E%3Ca+href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3A%23%27%2C%0D%0A%27%3Cb%3E%3Ca+href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__Subject__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3ASubject%27%2C%0D%0A%27__Status__%27%2C%0D%0A%27__QueueName__%27%2C%0D%0A%27__OwnerName__%27%2C%0D%0A%27__Priority__%27%2C%0D%0A%27__NEWLINE__%27%2C%0D%0A%27%27%2C%0D%0A%27%3Csmall%3E__Requestors__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__CreatedRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__ToldRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__LastUpdatedRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__TimeLeft__%3C%2Fsmall%3E%27ChartStyle=barPrimaryGroupBy=Status HTTP/1.1 200 13787 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:01 -0400] GET /NoAuth/css/web2/main-squished.css HTTP/1.1 200 21842 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] GET /NoAuth/css/print.css HTTP/1.1 200 443 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] GET /NoAuth/js/util.js HTTP/1.1 200 6190 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] GET /NoAuth/js/titlebox-state.js HTTP/1.1 200 928 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] GET /NoAuth/js/ahah.js HTTP/1.1 200 1032 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] GET /NoAuth/js/prototype/prototype.js HTTP/1.1 200 124137 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] GET /NoAuth/js/scriptaculous/scriptaculous.js?load=effects,controls HTTP/1.1 200 2655 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] GET /NoAuth/js/scriptaculous/effects.js HTTP/1.1 200 38986 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] GET /NoAuth/js/scriptaculous/controls.js HTTP/1.1 200 34927 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] GET /NoAuth/RichText/fckeditor.js HTTP/1.1 200 8983 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] GET /NoAuth/webrtfm.css HTTP/1.1 200 513 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] GET /NoAuth/css/calendar.css HTTP/1.1 200 746 There doesn't seem like there needs to be an entry for this in the RT_SiteConfig.pm file in order to get this to work but I could be missing the bleeding obvious. All suggestions welcome! thanks. janet ___ 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 -- Drew Barnes Applications Analyst Network Resources Department Raymond Walters College University of Cincinnati ___ 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 ___ 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
Re: [rt-users] rt 3.8.1: Graphical charts are not available. error
Hi Eli, Thanks. I didn't modify my new SiteConfig file for graphing. Did I miss something? In my previous verion (3.6.5) I didn't have to add anything special for bar and pie graphs to work, so I assumed I didn't need any new graphing mods in my 3.8.1 Site config file. j Janet, if after the SiteConfig mod you get You've enabled GD, but we couldn't load the module: xxx then you need to reinstall GD::Graph as Drew suggested. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Drew Barnes Sent: Friday, October 24, 2008 10:59 AM To: Janet Houser Cc: RT-Users@lists.bestpractical.com Subject: Re: [rt-users] rt 3.8.1: Graphical charts are not available. error I would try reinstalling GD::Graph from CPAN (forcing if necessary). Perhaps the RT upgrade was coincidental to a redhat perl rpm upgrade? Janet Houser wrote: Hi folks, I hope this is the right list to submit my quesstion. Sorry in advance if it isn't. I upgraded to rt 3.8.1 last month and when I try to plot (bar or pie) the output of ticket searches I get the error Graphical charts are not available. I looked in the archives and saw the following Re: Hierarchy View in 3.8 by Helmuth Ramirez. Following this thread I did the following: - installed graphviz from http://www.graphviz.org/ using yum install 'graphviz*' I got the error: yum install graphviz-php.i386 -- missing dependency graphviz = 2.16-1.el5 is needed by package graphviz-php So I then - - downloaded the source from http://www.graphviz.org/ and installed it. - yum install webdot and did a perl -MCPAN -e 'install GraphViz' - ran the command dot -c in an xterm. rebooted the system and still no luck. I see the following in the apache2.access log file but nothing looks like a glaring reason why it won't graph: xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:01 -0400] GET /Search/Chart.html?Order=ASC%7CASC%7CASC%7CASCQuery=Queue+%3D+%27Problems%27Rows=50OrderBy=id%7C%7C%7CFormat=%27+++%3Cb%3E%3Ca+href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3A%23%27%2C%0D%0A%27%3Cb%3E%3Ca+href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__Subject__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3ASubject%27%2C%0D%0A%27__Status__%27%2C%0D%0A%27__QueueName__%27%2C%0D%0A%27__OwnerName__%27%2C%0D%0A%27__Priority__%27%2C%0D%0A%27__NEWLINE__%27%2C%0D%0A%27%27%2C%0D%0A%27%3Csmall%3E__Requestors__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__CreatedRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__ToldRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__LastUpdatedRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__TimeLeft__%3C%2Fsmall%3E%27ChartStyle=barPrimaryGroupBy=Status HTTP/1.1 200 13787 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:01 -0400] GET /NoAuth/css/web2/main-squished.css HTTP/1.1 200 21842 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] GET /NoAuth/css/print.css HTTP/1.1 200 443 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] GET /NoAuth/js/util.js HTTP/1.1 200 6190 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] GET /NoAuth/js/titlebox-state.js HTTP/1.1 200 928 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] GET /NoAuth/js/ahah.js HTTP/1.1 200 1032 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] GET /NoAuth/js/prototype/prototype.js HTTP/1.1 200 124137 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] GET /NoAuth/js/scriptaculous/scriptaculous.js?load=effects,controls HTTP/1.1 200 2655 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] GET /NoAuth/js/scriptaculous/effects.js HTTP/1.1 200 38986 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] GET /NoAuth/js/scriptaculous/controls.js HTTP/1.1 200 34927 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] GET /NoAuth/RichText/fckeditor.js HTTP/1.1 200 8983 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] GET /NoAuth/webrtfm.css HTTP/1.1 200 513 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] GET /NoAuth/css/calendar.css HTTP/1.1 200 746 There doesn't seem like there needs to be an entry for this in the RT_SiteConfig.pm file in order to get this to work but I could be missing the bleeding obvious. All suggestions welcome! thanks. janet ___ 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 -- Drew Barnes Applications Analyst Network Resources Department Raymond Walters College University of Cincinnati ___ 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] rt 3.8.1: Graphical charts are not available. error
It won't hurt anything to set the DisableGD to undef anywhere in the SiteConfig (except the last line).. it can only help. Give it a shot, restart apache and tell me how it goes. -Original Message- From: Janet Houser [mailto:[EMAIL PROTECTED] Sent: Friday, October 24, 2008 11:27 AM To: Eli Altman Cc: Drew Barnes; RT-Users@lists.bestpractical.com Subject: Re: [rt-users] rt 3.8.1: Graphical charts are not available. error Hi Eli, Thanks. I didn't modify my new SiteConfig file for graphing. Did I miss something? In my previous verion (3.6.5) I didn't have to add anything special for bar and pie graphs to work, so I assumed I didn't need any new graphing mods in my 3.8.1 Site config file. j Janet, if after the SiteConfig mod you get You've enabled GD, but we couldn't load the module: xxx then you need to reinstall GD::Graph as Drew suggested. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Drew Barnes Sent: Friday, October 24, 2008 10:59 AM To: Janet Houser Cc: RT-Users@lists.bestpractical.com Subject: Re: [rt-users] rt 3.8.1: Graphical charts are not available. error I would try reinstalling GD::Graph from CPAN (forcing if necessary). Perhaps the RT upgrade was coincidental to a redhat perl rpm upgrade? Janet Houser wrote: Hi folks, I hope this is the right list to submit my quesstion. Sorry in advance if it isn't. I upgraded to rt 3.8.1 last month and when I try to plot (bar or pie) the output of ticket searches I get the error Graphical charts are not available. I looked in the archives and saw the following Re: Hierarchy View in 3.8 by Helmuth Ramirez. Following this thread I did the following: - installed graphviz from http://www.graphviz.org/ using yum install 'graphviz*' I got the error: yum install graphviz-php.i386 -- missing dependency graphviz = 2.16-1.el5 is needed by package graphviz-php So I then - - downloaded the source from http://www.graphviz.org/ and installed it. - yum install webdot and did a perl -MCPAN -e 'install GraphViz' - ran the command dot -c in an xterm. rebooted the system and still no luck. I see the following in the apache2.access log file but nothing looks like a glaring reason why it won't graph: xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:01 -0400] GET /Search/Chart.html?Order=ASC%7CASC%7CASC%7CASCQuery=Queue+%3D+%27Problems%27Rows=50OrderBy=id%7C%7C%7CFormat=%27+++%3Cb%3E%3Ca+href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3A%23%27%2C%0D%0A%27%3Cb%3E%3Ca+href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__Subject__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3ASubject%27%2C%0D%0A%27__Status__%27%2C%0D%0A%27__QueueName__%27%2C%0D%0A%27__OwnerName__%27%2C%0D%0A%27__Priority__%27%2C%0D%0A%27__NEWLINE__%27%2C%0D%0A%27%27%2C%0D%0A%27%3Csmall%3E__Requestors__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__CreatedRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__ToldRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__LastUpdatedRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__TimeLeft__%3C%2Fsmall%3E%27ChartStyle=barPrimaryGroupBy=Status HTTP/1.1 200 13787 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:01 -0400] GET /NoAuth/css/web2/main-squished.css HTTP/1.1 200 21842 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] GET /NoAuth/css/print.css HTTP/1.1 200 443 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] GET /NoAuth/js/util.js HTTP/1.1 200 6190 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] GET /NoAuth/js/titlebox-state.js HTTP/1.1 200 928 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] GET /NoAuth/js/ahah.js HTTP/1.1 200 1032 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] GET /NoAuth/js/prototype/prototype.js HTTP/1.1 200 124137 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] GET /NoAuth/js/scriptaculous/scriptaculous.js?load=effects,controls HTTP/1.1 200 2655 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] GET /NoAuth/js/scriptaculous/effects.js HTTP/1.1 200 38986 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] GET /NoAuth/js/scriptaculous/controls.js HTTP/1.1 200 34927 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] GET /NoAuth/RichText/fckeditor.js HTTP/1.1 200 8983 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] GET /NoAuth/webrtfm.css HTTP/1.1 200 513 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] GET /NoAuth/css/calendar.css HTTP/1.1 200 746 There doesn't seem like there needs to be an entry for this in the RT_SiteConfig.pm file in order to get this to work but I could be missing the bleeding obvious. All suggestions welcome! thanks. janet ___ 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 -- Drew
Re: [rt-users] rt 3.8.1: Graphical charts are not available. error
Hi Eli, I put an entry Set($DisableGD, undef); and restarted httpd. The good news is that the error went away. The bad is that it still doesn't plot. That's weird. j Eli Altman wrote: It won't hurt anything to set the DisableGD to undef anywhere in the SiteConfig (except the last line).. it can only help. Give it a shot, restart apache and tell me how it goes. -Original Message- From: Janet Houser [mailto:[EMAIL PROTECTED] Sent: Friday, October 24, 2008 11:27 AM To: Eli Altman Cc: Drew Barnes; RT-Users@lists.bestpractical.com Subject: Re: [rt-users] rt 3.8.1: Graphical charts are not available. error Hi Eli, Thanks. I didn't modify my new SiteConfig file for graphing. Did I miss something? In my previous verion (3.6.5) I didn't have to add anything special for bar and pie graphs to work, so I assumed I didn't need any new graphing mods in my 3.8.1 Site config file. j Janet, if after the SiteConfig mod you get You've enabled GD, but we couldn't load the module: xxx then you need to reinstall GD::Graph as Drew suggested. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Drew Barnes Sent: Friday, October 24, 2008 10:59 AM To: Janet Houser Cc: RT-Users@lists.bestpractical.com Subject: Re: [rt-users] rt 3.8.1: Graphical charts are not available. error I would try reinstalling GD::Graph from CPAN (forcing if necessary). Perhaps the RT upgrade was coincidental to a redhat perl rpm upgrade? Janet Houser wrote: Hi folks, I hope this is the right list to submit my quesstion. Sorry in advance if it isn't. I upgraded to rt 3.8.1 last month and when I try to plot (bar or pie) the output of ticket searches I get the error Graphical charts are not available. I looked in the archives and saw the following Re: Hierarchy View in 3.8 by Helmuth Ramirez. Following this thread I did the following: - installed graphviz from http://www.graphviz.org/ using yum install 'graphviz*' I got the error: yum install graphviz-php.i386 -- missing dependency graphviz = 2.16-1.el5 is needed by package graphviz-php So I then - - downloaded the source from http://www.graphviz.org/ and installed it. - yum install webdot and did a perl -MCPAN -e 'install GraphViz' - ran the command dot -c in an xterm. rebooted the system and still no luck. I see the following in the apache2.access log file but nothing looks like a glaring reason why it won't graph: xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:01 -0400] GET /Search/Chart.html?Order=ASC%7CASC%7CASC%7CASCQuery=Queue+%3D+%27Problems%27Rows=50OrderBy=id%7C%7C%7CFormat=%27+++%3Cb%3E%3Ca+href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3A%23%27%2C%0D%0A%27%3Cb%3E%3Ca+href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__Subject__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3ASubject%27%2C%0D%0A%27__Status__%27%2C%0D%0A%27__QueueName__%27%2C%0D%0A%27__OwnerName__%27%2C%0D%0A%27__Priority__%27%2C%0D%0A%27__NEWLINE__%27%2C%0D%0A%27%27%2C%0D%0A%27%3Csmall%3E__Requestors__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__CreatedRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__ToldRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__LastUpdatedRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__TimeLeft__%3C%2Fsmall%3E%27ChartStyle=barPrimaryGroupBy=Status HTTP/1.1 200 13787 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:01 -0400] GET /NoAuth/css/web2/main-squished.css HTTP/1.1 200 21842 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] GET /NoAuth/css/print.css HTTP/1.1 200 443 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] GET /NoAuth/js/util.js HTTP/1.1 200 6190 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] GET /NoAuth/js/titlebox-state.js HTTP/1.1 200 928 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] GET /NoAuth/js/ahah.js HTTP/1.1 200 1032 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] GET /NoAuth/js/prototype/prototype.js HTTP/1.1 200 124137 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] GET /NoAuth/js/scriptaculous/scriptaculous.js?load=effects,controls HTTP/1.1 200 2655 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] GET /NoAuth/js/scriptaculous/effects.js HTTP/1.1 200 38986 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] GET /NoAuth/js/scriptaculous/controls.js HTTP/1.1 200 34927 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] GET /NoAuth/RichText/fckeditor.js HTTP/1.1 200 8983 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] GET /NoAuth/webrtfm.css HTTP/1.1 200 513 xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] GET /NoAuth/css/calendar.css HTTP/1.1 200 746 There doesn't seem like there needs to be an entry for this in the RT_SiteConfig.pm file in order to get this to work but I could be missing the bleeding obvious. All suggestions welcome! thanks. janet ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
[rt-users] DBD::mysql::st execute failed: MySQL server has gone away at
Hi Please can someone help. Fresh install of os and rt and i get this error which ends of with the ticket email sent but no ticket created and my RT is currently not working. I have downloaded all the email archives and found other people with the same error but no real solution. Rt 3.8.1 on Centos 5.2 with php 5 perl 5.8.8 and mysql 5.0.45. Thanks for any help Kobus There is a lot more to this log entry, I just could not include it all here. HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x2b99543613e0)') 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(0x2b99543613e0)') 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(0x2b994c2469a0)', 'Apache2::RequestRec=SCALAR(0x2b995437e480)') 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(0x2b995437e480)') called at -e line 0 eval {...} called at -e line 0 (/usr/lib/perl5/5.8.8/Carp.pm:272) [Thu Oct 23 22:30:23 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) [Thu Oct 23 22:30:23 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) signature.asc Description: OpenPGP digital 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
Re: [rt-users] DBD::mysql::st execute failed: MySQL server has gone away at
Please explain in detail what problem you are experiencing. Are you having problems installing RT and running it for the first time? Can you not access RT at all through a browser? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kobus Bensch Sent: Friday, October 24, 2008 12:38 PM To: RT Users Subject: [rt-users] DBD::mysql::st execute failed: MySQL server has gone away at Hi Please can someone help. Fresh install of os and rt and i get this error which ends of with the ticket email sent but no ticket created and my RT is currently not working. I have downloaded all the email archives and found other people with the same error but no real solution. Rt 3.8.1 on Centos 5.2 with php 5 perl 5.8.8 and mysql 5.0.45. Thanks for any help Kobus There is a lot more to this log entry, I just could not include it all here. HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x2b99543613e0)') 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(0x2b99543613e0)') 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(0x2b994c2469a0)', 'Apache2::RequestRec=SCALAR(0x2b995437e480)') 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(0x2b995437e480)') called at -e line 0 eval {...} called at -e line 0 (/usr/lib/perl5/5.8.8/Carp.pm:272) [Thu Oct 23 22:30:23 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) [Thu Oct 23 22:30:23 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) ___ 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] DBD::mysql::st execute failed: MySQL server has gone away at
Kobus Bensch wrote: Hi Please can someone help. Fresh install of os and rt and i get this error which ends of with the ticket email sent but no ticket created and my RT is currently not working. I have downloaded all the email archives and found other people with the same error but no real solution. Rt 3.8.1 on Centos 5.2 with php 5 perl 5.8.8 and mysql 5.0.45. Thanks for any help Kobus try (re)installing DBD::mysql -- -- Chaim Rieger ___ 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] DBD::mysql::st execute failed: MySQL server has gone away at
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 server creates massive logs, so much so that I have to reboot the server and delete it as soon as it comes back. I deleted a 81GB rt.log file. Further problems, but after tghis issue has been solved is after each page i try to click on i have to login. Last error I sometimes just get blank pages. Thanks for the help Kobus Eli Altman wrote: Please explain in detail what problem you are experiencing. Are you having problems installing RT and running it for the first time? Can you not access RT at all through a browser? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kobus Bensch Sent: Friday, October 24, 2008 12:38 PM To: RT Users Subject: [rt-users] DBD::mysql::st execute failed: MySQL server has gone away at Hi Please can someone help. Fresh install of os and rt and i get this error which ends of with the ticket email sent but no ticket created and my RT is currently not working. I have downloaded all the email archives and found other people with the same error but no real solution. Rt 3.8.1 on Centos 5.2 with php 5 perl 5.8.8 and mysql 5.0.45. Thanks for any help Kobus There is a lot more to this log entry, I just could not include it all here. HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x2b99543613e0)') 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(0x2b99543613e0)') 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(0x2b994c2469a0)', 'Apache2::RequestRec=SCALAR(0x2b995437e480)') 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(0x2b995437e480)') called at -e line 0 eval {...} called at -e line 0 (/usr/lib/perl5/5.8.8/Carp.pm:272) [Thu Oct 23 22:30:23 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) [Thu Oct 23 22:30:23 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) ___ 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 ___ 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] 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 server creates massive logs, so much so that I have to reboot the server and delete it as soon as it comes back. I deleted a 81GB rt.log file. Further problems, but after tghis issue has been solved is after each page i try to click on i have to login. Last error I sometimes just get blank pages. Thanks for the help Kobus Eli Altman wrote: Please explain in detail what problem you are experiencing. Are you having problems installing RT and running it for the first time? Can you not access RT at all through a browser? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kobus Bensch Sent: Friday, October 24, 2008 12:38 PM To: RT Users Subject: [rt-users] DBD::mysql::st execute failed: MySQL server has gone away at Hi Please can someone help. Fresh install of os and rt and i get this error which ends of with the ticket email sent but no ticket created and my RT is currently not working. I have downloaded all the email archives and found other people with the same error but no real solution. Rt 3.8.1 on Centos 5.2 with php 5 perl 5.8.8 and mysql 5.0.45. Thanks for any help Kobus There is a lot more to this log entry, I just could not include it all here. HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x2b99543613e0)') 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(0x2b99543613e0)') 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(0x2b994c2469a0)', 'Apache2::RequestRec=SCALAR(0x2b995437e480)') 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(0x2b995437e480)') called at -e line 0 eval {...} called at -e line 0 (/usr/lib/perl5/5.8.8/Carp.pm:272) [Thu Oct 23 22:30:23 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) [Thu Oct 23 22:30:23 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) ___ 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 ___ 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] DBD::mysql::st execute failed: MySQL server has goneaway at
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: rt-users@lists.bestpractical.com 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 server creates massive logs, so much so that I have to reboot the server and delete it as soon as it comes back. I deleted a 81GB rt.log file. Further problems, but after tghis issue has been solved is after each page i try to click on i have to login. Last error I sometimes just get blank pages. Thanks for the help Kobus Eli Altman wrote: Please explain in detail what problem you are experiencing. Are you having problems installing RT and running it for the first time? Can you not access RT at all through a browser? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kobus Bensch Sent: Friday, October 24, 2008 12:38 PM To: RT Users Subject: [rt-users] DBD::mysql::st execute failed: MySQL server has gone away at Hi Please can someone help. Fresh install of os and rt and i get this error which ends of with the ticket email sent but no ticket created and my RT is currently not working. I have downloaded all the email archives and found other people with the same error but no real solution. Rt 3.8.1 on Centos 5.2 with php 5 perl 5.8.8 and mysql 5.0.45. Thanks for any help Kobus There is a lot more to this log entry, I just could not include it all here. HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x2b99543613e0)') 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(0x2b99543613e0)') 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(0x2b994c2469a0)', 'Apache2::RequestRec=SCALAR(0x2b995437e480)') 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(0x2b995437e480)') called at -e line 0 eval {...} called at -e line 0 (/usr/lib/perl5/5.8.8/Carp.pm:272) [Thu Oct 23 22:30:23 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) [Thu Oct 23 22:30:23 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) ___ 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 ___ 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 ___ 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] DBD::mysql::st execute failed: MySQL server has goneaway at
Title: Fullnet Solutions Limited 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: rt-users@lists.bestpractical.com 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 server creates massive logs, so much so that I have to reboot the server and delete it as soon as it comes back. I deleted a 81GB rt.log file. Further problems, but after tghis issue has been solved is after each page i try to click on i have to login. Last error I sometimes just get blank pages. Thanks for the help Kobus Eli Altman wrote: Please explain in detail what problem you are experiencing. Are you having problems installing RT and running it for the first time? Can you not access RT at all through a browser? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Kobus Bensch Sent: Friday, October 24, 2008 12:38 PM To: RT Users Subject: [rt-users] DBD::mysql::st execute failed: MySQL server has gone away at Hi Please can someone help. Fresh install of os and rt and i get this error which ends of with the ticket email sent but no ticket created and my RT is currently not working. I have downloaded all the email archives and found other people with the same error but no real solution. Rt 3.8.1 on Centos 5.2 with php 5 perl 5.8.8 and mysql 5.0.45. Thanks for any help Kobus There is a lot more to this log entry, I just could not include it all here. HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x2b99543613e0)') 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(0x2b99543613e0)') 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(0x2b994c2469a0)', 'Apache2::RequestRec=SCALAR(0x2b995437e480)') 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(0x2b995437e480)') called at -e line 0 eval {...} called at -e line 0 (/usr/lib/perl5/5.8.8/Carp.pm:272) [Thu Oct 23 22:30:23 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) [Thu Oct 23 22:30:23 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) ___ 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 ___ 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] rt 3.8.1: Graphical charts are not available. error
On Fri, 24 Oct 2008, Janet Houser wrote: |# I put an entry Set($DisableGD, undef); and restarted httpd. The good |# news is that the error went away. The |# bad is that it still doesn't plot. That's weird. Check your apache error log. I put up a fresh copy of 3.8.1 (src, not emerged) on a gentoo 2.6.25 box before I update our main instance. I get this in my error_log when trying to graph something in RT. I have not pursued any further at this point because of other projects. [Fri Oct 24 11:59:09 2008] [notice] Apache/2.2.9 (Unix) mod_ssl/2.2.9 OpenSSL/0.9.8h PHP/5.2.6-pl7-gentoo mod_perl/2.0.3-dev Perl/v5.8.8 configured -- resuming normal operations *** glibc detected *** /usr/sbin/apache2: double free or corruption (out): 0x0a841360 *** === Backtrace: = /lib/libc.so.6[0xb7c86a00] /lib/libc.so.6(cfree+0x89)[0xb7c886f9] /usr/lib/libgd.so.2(gdFree+0x1d)[0xb6d0c3fd] /usr/lib/perl5/vendor_perl/5.8.8/i686-linux/auto/GD/GD.so(XS_GD__Image_png+0xde)[0xb6eeea0e] /usr/lib/libperl.so.1(Perl_pp_entersub+0x3cf)[0xb713e8af] /usr/lib/libperl.so.1(Perl_runops_standard+0x25)[0xb713d0d5] /usr/lib/libperl.so.1[0xb70e8250] /usr/lib/libperl.so.1(Perl_call_sv+0x629)[0xb70e8f49] /usr/lib/apache2/modules/mod_perl.so(modperl_callback+0x377)[0xb71dbb83] /usr/lib/apache2/modules/mod_perl.so(modperl_callback_run_handlers+0x472)[0xb71dc325] /usr/lib/apache2/modules/mod_perl.so(modperl_callback_per_dir+0x5d)[0xb71dc7bc] /usr/lib/apache2/modules/mod_perl.so[0xb71d77f5] /usr/lib/apache2/modules/mod_perl.so(modperl_response_handler_cgi+0x17f)[0xb71d7a92] /usr/sbin/apache2(ap_run_handler+0x57)[0x80788f7] /usr/sbin/apache2(ap_invoke_handler+0x67)[0x807ba07] /usr/sbin/apache2(ap_process_request+0x178)[0x8086898] /usr/sbin/apache2[0x8083afe] /usr/sbin/apache2(ap_run_process_connection+0x57)[0x807f8a7] /usr/sbin/apache2[0x808ae2d] /usr/sbin/apache2[0x808b106] /usr/sbin/apache2(ap_mpm_run+0x438)[0x808b608] /usr/sbin/apache2(main+0x848)[0x80663c8] /lib/libc.so.6(__libc_start_main+0xdc)[0xb7c36fdc] /usr/sbin/apache2(apr_dso_error+0x41)[0x80655e1] === Memory map: 08048000-08097000 r-xp 08:03 631511 /usr/sbin/apache2 08097000-08098000 r--p 0004e000 08:03 631511 /usr/sbin/apache2 08098000-0809a000 rw-p 0004f000 08:03 631511 /usr/sbin/apache2 [etc, etc] [Fri Oct 24 12:48:53 2008] [notice] child pid 5640 exit signal Aborted (6) -- Tim Rosmus [EMAIL PROTECTED] Postmaster / USENET / DNS Northwest Nexus Inc. / NetOS Inc. ___ 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] DBD::mysql::st execute failed: MySQL server has goneaway at
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: rt-users@lists.bestpractical.com 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 server creates massive logs, so much so that I have to reboot the server and delete it as soon as it comes back. I deleted a 81GB rt.log file. Further problems, but after tghis issue has been solved is after each page i try to click on i have to login. Last error I sometimes just get blank pages. Thanks for the help Kobus Eli Altman wrote: Please explain in detail what problem you are experiencing. Are you having problems installing RT and running it for the first time? Can you not access RT at all through a browser? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kobus Bensch Sent: Friday, October 24, 2008 12:38 PM To: RT Users Subject: [rt-users] DBD::mysql::st execute failed: MySQL server has gone away at Hi Please can someone help. Fresh install of os and rt and i get this error which ends of with the ticket email sent but no ticket created and my RT is currently not working. I have downloaded all the email archives and found other people with the same error but no real solution. Rt 3.8.1 on Centos 5.2 with php 5 perl 5.8.8 and mysql 5.0.45. Thanks for any help Kobus There is a lot more to this log entry, I just could not include it all here. HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x2b99543613e0)') 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(0x2b99543613e0)') 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(0x2b994c2469a0)', 'Apache2::RequestRec=SCALAR(0x2b995437e480)') 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(0x2b995437e480)') called at -e line 0 eval {...} called at -e line 0 (/usr/lib/perl5/5.8.8/Carp.pm:272) [Thu Oct 23 22:30:23 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) [Thu Oct 23 22:30:23 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) ___ 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 ___ 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
Re: [rt-users] DBD::mysql::st execute failed: MySQL server has goneaway at
Title: Fullnet Solutions Limited No, because the previous server had the same version of MySQL as the new one. 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: rt-users@lists.bestpractical.com 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 server creates massive logs, so much so that I have to reboot the server and delete it as soon as it comes back. I deleted a 81GB rt.log file. Further problems, but after tghis issue has been solved is after each page i try to click on i have to login. Last error I sometimes just get blank pages. Thanks for the help Kobus Eli Altman wrote: Please explain in detail what problem you are experiencing. Are you having problems installing RT and running it for the first time? Can you not access RT at all through a browser? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Kobus Bensch Sent: Friday, October 24, 2008 12:38 PM To: RT Users Subject: [rt-users] DBD::mysql::st execute failed: MySQL server has gone away at Hi Please can someone help. Fresh install of os and rt and i get this error which ends of with the ticket email sent but no ticket created and my RT is currently not working. I have downloaded all the email archives and found other people with the same error but no real solution. Rt 3.8.1 on Centos 5.2 with php 5 perl 5.8.8 and mysql 5.0.45. Thanks for any help Kobus There is a lot more to this log entry, I just could not include it all here. HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x2b99543613e0)') 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(0x2b99543613e0)') 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(0x2b994c2469a0)', 'Apache2::RequestRec=SCALAR(0x2b995437e480)') 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(0x2b995437e480)') called at -e line 0 eval {...} called at -e line 0 (/usr/lib/perl5/5.8.8/Carp.pm:272) [Thu Oct 23 22:30:23 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) [Thu Oct 23 22:30:23 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) ___ 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 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover
Re: [rt-users] DBD::mysql::st execute failed: MySQL server has goneaway at
You still must do that. On Sat, Oct 25, 2008 at 12:43 AM, Kobus Bensch [EMAIL PROTECTED] wrote: No, because the previous server had the same version of MySQL as the new one. 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: rt-users@lists.bestpractical.com 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 server creates massive logs, so much so that I have to reboot the server and delete it as soon as it comes back. I deleted a 81GB rt.log file. Further problems, but after tghis issue has been solved is after each page i try to click on i have to login. Last error I sometimes just get blank pages. Thanks for the help Kobus Eli Altman wrote: Please explain in detail what problem you are experiencing. Are you having problems installing RT and running it for the first time? Can you not access RT at all through a browser? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kobus Bensch Sent: Friday, October 24, 2008 12:38 PM To: RT Users Subject: [rt-users] DBD::mysql::st execute failed: MySQL server has gone away at Hi Please can someone help. Fresh install of os and rt and i get this error which ends of with the ticket email sent but no ticket created and my RT is currently not working. I have downloaded all the email archives and found other people with the same error but no real solution. Rt 3.8.1 on Centos 5.2 with php 5 perl 5.8.8 and mysql 5.0.45. Thanks for any help Kobus There is a lot more to this log entry, I just could not include it all here. HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x2b99543613e0)') 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(0x2b99543613e0)') 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(0x2b994c2469a0)', 'Apache2::RequestRec=SCALAR(0x2b995437e480)') 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(0x2b995437e480)') called at -e line 0 eval {...} called at -e line 0 (/usr/lib/perl5/5.8.8/Carp.pm:272) [Thu Oct 23 22:30:23 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) [Thu Oct 23 22:30:23 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) ___ 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] DBD::mysql::st execute failed: MySQL server has goneaway at
Kobus Bensch wrote: No, because the previous server had the same version of MySQL as the new one. you need to upgrade the mysql schema when upgrading rt from 3.6 to 3.8 -- -- Chaim Rieger ___ 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] DBD::mysql::st execute failed: MySQL server has goneaway at
Yeah that's strange, I had a similar issue where my fastcgi segfaulted causing a permanent error state, which causes the process to keep cycling filling up the log/hard drive. This would only happen in low memory situations, yours seems to be somewhat driver/software related where it keeps trying and just fills up the log. Kobus Bensch 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: rt-users@lists.bestpractical.com 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 server creates massive logs, so much so that I have to reboot the server and delete it as soon as it comes back. I deleted a 81GB rt.log file. Further problems, but after tghis issue has been solved is after each page i try to click on i have to login. Last error I sometimes just get blank pages. Thanks for the help Kobus Eli Altman wrote: Please explain in detail what problem you are experiencing. Are you having problems installing RT and running it for the first time? Can you not access RT at all through a browser? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kobus Bensch Sent: Friday, October 24, 2008 12:38 PM To: RT Users Subject: [rt-users] DBD::mysql::st execute failed: MySQL server has gone away at Hi Please can someone help. Fresh install of os and rt and i get this error which ends of with the ticket email sent but no ticket created and my RT is currently not working. I have downloaded all the email archives and found other people with the same error but no real solution. Rt 3.8.1 on Centos 5.2 with php 5 perl 5.8.8 and mysql 5.0.45. Thanks for any help Kobus There is a lot more to this log entry, I just could not include it all here. HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x2b99543613e0)') 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(0x2b99543613e0)') 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(0x2b994c2469a0)', 'Apache2::RequestRec=SCALAR(0x2b995437e480)') 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(0x2b995437e480)') called at -e line 0 eval {...} called at -e line 0 (/usr/lib/perl5/5.8.8/Carp.pm:272) [Thu Oct 23 22:30:23 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) [Thu Oct 23 22:30:23 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) ___ 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
Re: [rt-users] DBD::mysql::st execute failed: MySQL server has goneaway at
Hi I have now run the actions for the upgrading rt and it still give me the same error. Kobus Chaim Rieger wrote: Kobus Bensch wrote: No, because the previous server had the same version of MySQL as the new one. you need to upgrade the mysql schema when upgrading rt from 3.6 to 3.8 signature.asc Description: OpenPGP digital 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
Re: [rt-users] DBD::mysql::st execute failed: MySQL server has goneaway at
Kobus Bensch - No Sig wrote: Hi I have now run the actions for the upgrading rt and it still give me the same error. Kobus stop and restart your web server clear the mason cache -- -- Chaim Rieger ___ 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] RTFM: Can't call method Id on an undefined value
RTFM installing was successful and in all other respects appears to be functioning fine (same with RT). First: click Reply to a RT ticket, select a given RTFM from the drop down, then click Go to apply it. This works as expected. Next: Click update. A blank page with the following error is displayed: https://domain.com/rt/Ticket/Update.html Can't call method Id on an undefined value at /opt/rt3/local/plugins/ RT-FM/lib/RT/URI/fsck_com_rtfm.pm line 134. However, the reply is successfully logged and any notifications emails are sent out correctly. Here's the function referred to in the error: http://pastebin.com/m2e7d01c8 Any help greatly appreciated, james kyle ___ 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] rt 3.8.1: Graphical charts are not available. error
A solution for the lists, have a good weekend Janet. -Original Message- From: Janet Houser [mailto:[EMAIL PROTECTED] Sent: Friday, October 24, 2008 2:10 PM To: Eli Altman Subject: Re: [rt-users] rt 3.8.1: Graphical charts are not available. error Hi Eli, On a hunch, I downloaded: 2007-04-25 ftp://ftp.int.ru/.1/FreeBSD/distfiles/GDGraph-1.44.tar.gz and installed it rather than going through CPAN. it worked! I get my charts. Very strange. There were no errors from teh CPAN install of GDGraph but it looks like something didn't work right. Thank you so much for your time and help. Have a really great weekend! Cheers, janet Janet Houser wrote: Hi, Yes. I get a table with choosing eith bar or pie for my chart I get only: Query: Queue = 'Problems' Status Tickets -- in black bold high 0 low0 medium 0 new 5 open 8 resolved16 stalled0 urgent0 Total 29 So it is doing the calculation. In rt 3.6.5, the pie or bar chart would get displayed above this output. very strange. Do you know of any log files that might have helpful output. I've checked int rt3/var/logs and there isn't anything useful. thanks for any help. j Eli Altman wrote: What does happen? Does it show the results in tables, just not the actual generated graphic for the graphs? -Original Message- From: Janet Houser [mailto:[EMAIL PROTECTED] Sent: Friday, October 24, 2008 12:35 PM To: Eli Altman Cc: RT-Users@lists.bestpractical.com Subject: Re: [rt-users] rt 3.8.1: Graphical charts are not available. error Hi Eli, I put an entry Set($DisableGD, undef); and restarted httpd. The good news is that the error went away. The bad is that it still doesn't plot. That's weird. j Eli Altman wrote: It won't hurt anything to set the DisableGD to undef anywhere in the SiteConfig (except the last line).. it can only help. Give it a shot, restart apache and tell me how it goes. -Original Message- From: Janet Houser [mailto:[EMAIL PROTECTED] Sent: Friday, October 24, 2008 11:27 AM To: Eli Altman Cc: Drew Barnes; RT-Users@lists.bestpractical.com Subject: Re: [rt-users] rt 3.8.1: Graphical charts are not available. error Hi Eli, Thanks. I didn't modify my new SiteConfig file for graphing. Did I miss something? In my previous verion (3.6.5) I didn't have to add anything special for bar and pie graphs to work, so I assumed I didn't need any new graphing mods in my 3.8.1 Site config file. j Janet, if after the SiteConfig mod you get You've enabled GD, but we couldn't load the module: xxx then you need to reinstall GD::Graph as Drew suggested. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Drew Barnes Sent: Friday, October 24, 2008 10:59 AM To: Janet Houser Cc: RT-Users@lists.bestpractical.com Subject: Re: [rt-users] rt 3.8.1: Graphical charts are not available. error I would try reinstalling GD::Graph from CPAN (forcing if necessary). Perhaps the RT upgrade was coincidental to a redhat perl rpm upgrade? Janet Houser wrote: Hi folks, I hope this is the right list to submit my quesstion. Sorry in advance if it isn't. I upgraded to rt 3.8.1 last month and when I try to plot (bar or pie) the output of ticket searches I get the error Graphical charts are not available. I looked in the archives and saw the following Re: Hierarchy View in 3.8 by Helmuth Ramirez. Following this thread I did the following: - installed graphviz from http://www.graphviz.org/ using yum install 'graphviz*' I got the error: yum install graphviz-php.i386 -- missing dependency graphviz = 2.16-1.el5 is needed by package graphviz-php So I then - - downloaded the source from http://www.graphviz.org/ and installed it. - yum install webdot and did a perl -MCPAN -e 'install GraphViz' - ran the command dot -c in an xterm. rebooted the system and still no luck. I see the following in the apache2.access log file but nothing looks like a glaring reason why it won't graph: xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:01 -0400] GET