Re: [rt-users] RT 4.0.1 Custom Field -> Wikitext box not saving all data.
On Mon, Jul 25, 2011 at 9:24 AM, Kevin Falcone wrote: > On Fri, Jul 22, 2011 at 02:22:44PM -0500, Scott wrote: > > Well it does save all the data if entered from a unix Firefox, but > > on a windows box (IE or Firefox) > > only the last line of the text is saved. > > > > i.e. > > One > > > > Two > > > > Three > > > > ...will show up in the ticket display and be saved to the table if > > it is entered from firefox on > > What do you mean by "The table" ? The database table? > Yes. > > >a linux box. If this is saved from a browser on windows, only > > the "Three" is saved. Any ideas?? > > > > This is rt 4.0.1 with an Oracle db. > > Is this working with normal text boxes? > > I changed it to text and will have the users test. oddly enough the wikitext does work on an older windows server (2003 I think) with ie7 & firefox 3.6.18. > It'd also be nice to know exactly what is in the database. > In the content field only the last typed line is saved when entered on a windows7 box with ie or firefox. > > -kevin > > > > 2011 Training: http://bestpractical.com/services/training.html > 2011 Training: http://bestpractical.com/services/training.html
Re: [rt-users] 3.9
On Tue, 2011-04-05 at 12:18 -0400, Thomas Sibley wrote: > On 04/05/2011 12:07 PM, Burton Simonds wrote: > > What is the current status of rt 3.9? I noticed in the devel > > repository there were a several there, but the release candidates for > > RT4 seem to have more recent updates. Is 3.9 considered stable enough > > for production? The reason I ask, is it seems to have several > > features that I might be interested in. > > 3.9 became 4.0, the same way 3.5 became 3.6 and the shorter lived 3.7 > became 3.8. If you want to test the fun new features, you want to try > our latest release candidate, 4.0.0rc8. Where is rc8, I don't see it in the devel directory? Thanks. > Release candidate means we > think it's ready for production testing. If you try it out, please let > us know how it goes for you. > > Thomas
Re: [rt-users] RT-4.0.0rc7 and CAS problems
On Wed, 2011-03-30 at 15:08 -0500, Scott T. Hildreth wrote: > On Wed, 2011-03-30 at 15:29 -0400, Kevin Falcone wrote: > > On Wed, Mar 30, 2011 at 01:35:09PM -0500, Scott T. Hildreth wrote: > > > On Wed, 2011-03-30 at 14:12 -0400, Kevin Falcone wrote: > > > > On Wed, Mar 30, 2011 at 12:15:10PM -0500, Scott T. Hildreth wrote: > > > > > I installed 4.0.0rc7 for testing. Our production version is 3.8.4. > > > > > The 3.8.4 install has "Set($WebExternalAuth , 1);" in the > > > > > RT_SiteConfig.pm and Apache2::AuthCAS set up in the Apache config. > > > > > This works in 3.8.4, but when I set it up for 4.0.0rc7 and tried to > > > > > login I was redirected to our CAS login page as expected and then > > > > > redirected back the RT login page that says the login failed and > > > > > has the login text box showing (which does not accept text). Is > > > > > there > > > > > something more I need to do for 4.0 or did I forgot some setting? > > > > > > > > Does your apache log show that REMOTE_USER is being set to what you > > > > expect? > > > > > > I don't see REMOTE_USER in the logs, but I do see this > > > > > > CAS(95219): setHeader: Setting header: CAS_FILTER_USER = shildret > > > > That isn't a header that RT matches on, did you have a local > > customization to 3.8.4 to handle that? > > > > -kevin > > > > > > There have been several changes since 3.8.4 for the login > > > > path, so you may be better off testing if 3.8.9 also fails for you. > > > > > > > > I know of a few folks using RT's External Auth against the 4.0.0 > > > > betas, so I suspect a misconfiguration or some weird bug we haven't > > > > seen yet, rather than a general failure. > > I looked at my 3.8.4 install and there wasn't any customization. If I > check the apache logs I don't see REMOTE_USER in that one as well. I > set the log level to debug on the server where I have 4.0 installed, but > I still don't see REMOTE_USER being set. Would I see that in the log > with debug set? Can I set REMOTE_USER = CAS_FILER_USER in the > httpd.conf? > Never mind, I was just told that I need to make it work with Tivoli. I need to parse iv_user out of the header and redirect to the Tivoli server if a user tries to access the server/rt directly. >
Re: [rt-users] RT-4.0.0rc7 and CAS problems
On Wed, 2011-03-30 at 15:29 -0400, Kevin Falcone wrote: > On Wed, Mar 30, 2011 at 01:35:09PM -0500, Scott T. Hildreth wrote: > > On Wed, 2011-03-30 at 14:12 -0400, Kevin Falcone wrote: > > > On Wed, Mar 30, 2011 at 12:15:10PM -0500, Scott T. Hildreth wrote: > > > > I installed 4.0.0rc7 for testing. Our production version is 3.8.4. > > > > The 3.8.4 install has "Set($WebExternalAuth , 1);" in the > > > > RT_SiteConfig.pm and Apache2::AuthCAS set up in the Apache config. > > > > This works in 3.8.4, but when I set it up for 4.0.0rc7 and tried to > > > > login I was redirected to our CAS login page as expected and then > > > > redirected back the RT login page that says the login failed and > > > > has the login text box showing (which does not accept text). Is there > > > > something more I need to do for 4.0 or did I forgot some setting? > > > > > > Does your apache log show that REMOTE_USER is being set to what you > > > expect? > > > > I don't see REMOTE_USER in the logs, but I do see this > > > > CAS(95219): setHeader: Setting header: CAS_FILTER_USER = shildret > > That isn't a header that RT matches on, did you have a local > customization to 3.8.4 to handle that? > > -kevin > > > > There have been several changes since 3.8.4 for the login > > > path, so you may be better off testing if 3.8.9 also fails for you. > > > > > > I know of a few folks using RT's External Auth against the 4.0.0 > > > betas, so I suspect a misconfiguration or some weird bug we haven't > > > seen yet, rather than a general failure. I looked at my 3.8.4 install and there wasn't any customization. If I check the apache logs I don't see REMOTE_USER in that one as well. I set the log level to debug on the server where I have 4.0 installed, but I still don't see REMOTE_USER being set. Would I see that in the log with debug set? Can I set REMOTE_USER = CAS_FILER_USER in the httpd.conf?
Re: [rt-users] RT-4.0.0rc7 and CAS problems
On Wed, 2011-03-30 at 14:12 -0400, Kevin Falcone wrote: > On Wed, Mar 30, 2011 at 12:15:10PM -0500, Scott T. Hildreth wrote: > > I installed 4.0.0rc7 for testing. Our production version is 3.8.4. > > The 3.8.4 install has "Set($WebExternalAuth , 1);" in the > > RT_SiteConfig.pm and Apache2::AuthCAS set up in the Apache config. > > This works in 3.8.4, but when I set it up for 4.0.0rc7 and tried to > > login I was redirected to our CAS login page as expected and then > > redirected back the RT login page that says the login failed and > > has the login text box showing (which does not accept text). Is there > > something more I need to do for 4.0 or did I forgot some setting? > > Does your apache log show that REMOTE_USER is being set to what you > expect? I don't see REMOTE_USER in the logs, but I do see this CAS(95219): setHeader: Setting header: CAS_FILTER_USER = shildret > There have been several changes since 3.8.4 for the login > path, so you may be better off testing if 3.8.9 also fails for you. > > I know of a few folks using RT's External Auth against the 4.0.0 > betas, so I suspect a misconfiguration or some weird bug we haven't > seen yet, rather than a general failure. > > -kevin
[rt-users] RT-4.0.0rc7 and CAS problems
I installed 4.0.0rc7 for testing. Our production version is 3.8.4. The 3.8.4 install has "Set($WebExternalAuth , 1);" in the RT_SiteConfig.pm and Apache2::AuthCAS set up in the Apache config. This works in 3.8.4, but when I set it up for 4.0.0rc7 and tried to login I was redirected to our CAS login page as expected and then redirected back the RT login page that says the login failed and has the login text box showing (which does not accept text). Is there something more I need to do for 4.0 or did I forgot some setting? Thank You, Scott
Re: [rt-users] Docs for mailgate comments?
On Wed, 2009-07-22 at 14:54 -0400, Jerrad Pierce wrote: > On Wed, Jul 22, 2009 at 14:13, Scott T. > Hildreth wrote: > > Can someone please explain or point me to the docs on how > > the comments work for email. I'm sure it is right under my > > nose, but all I can find is how to setup the rt-mailgate. > You need a separate email address routing to RT with the --action set > to comment. I recommend using I do have the separate email for comment. > --action correspond --extension action though. > > Then qu...@rt.example.net is correspond and > queue+comm...@rt.example.net is comment. > > > Does RT parse the ticket number from the subject? > Yes, but that has nothing to do with comments per se. Okay, maybe I misunderstand the comments, I thought it would be a comment for a certain ticket?? > ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Docs for mailgate comments?
Can someone please explain or point me to the docs on how the comments work for email. I'm sure it is right under my nose, but all I can find is how to setup the rt-mailgate. Does RT parse the ticket number from the subject? Thanks, Scott ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] mailgateway & Cass
Thanks for the replies, this actually worked for me, SetHandler perl-script PerlHandler RT::Mason satisfy any allow from all SetHandler perl-script PerlHandler RT::Mason satisfy any allow from all ...from the wiki, which I apparently didn't search well enough. Thanks again, Scott On Mon, 2009-07-20 at 15:20 -0500, Scott T. Hildreth wrote: > Hello, > I'm not sure if this is possible and am hoping someone can tell me, > > In the Apache httpd.conf I have this, > > > AuthType Apache2::AuthCAS >... > > which redirects to a Cass login page. Currently the rt-mailgate is not > set up, but we would like to set up some queues that clients can just > email to create tickets. The emails fail because the redirect occurs > for a Cass login. I tried adding this to the httpd.conf, > > > Order allow,deny > Allow from all > Options All > AllowOverride All > > > but as I suspected it wouldn't work, since the share/html dir is > required to redirect. Is there a way for me to get this to work? > > > Thanks, > > Scott > > ___ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: sa...@bestpractical.com > > > 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: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] mailgateway & Cass
Hello, I'm not sure if this is possible and am hoping someone can tell me, In the Apache httpd.conf I have this, AuthType Apache2::AuthCAS ... which redirects to a Cass login page. Currently the rt-mailgate is not set up, but we would like to set up some queues that clients can just email to create tickets. The emails fail because the redirect occurs for a Cass login. I tried adding this to the httpd.conf, Order allow,deny Allow from all Options All AllowOverride All but as I suspected it wouldn't work, since the share/html dir is required to redirect. Is there a way for me to get this to work? Thanks, Scott ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Multiple Tickets being created when create button is pushed
We are running rt-3.8.2 (I plan to upgrade to 3.8.4) and have had an issue where a user will fill out a ticket and hit the create button which will produce 20 tickets. This doesn't happen all the time, but it has occurred a few times with different users. I am hoping the upgrade will fix this issue, but I wanted to see if anyone else has had this occur or if someone has an idea of how this could happen. The end users are using IE. Thanks, Scott ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] History for a Ticket not displaying
That was it, I saw the segfaults in the error log. Thanks Ruslan! On Sat, 2008-08-02 at 01:50 +0400, Ruslan Zakirov wrote: > It could be segmentation fault caused be perl and Text::Quoted module. > Update that module to the latest version available from the CPAN, > stop/start server. Check that RT server uses new version of the module > using Web UI -> Configuration -> Tools ->System Configuration. Test > ticket. > > On Sat, Aug 2, 2008 at 1:35 AM, Scott T. Hildreth > <[EMAIL PROTECTED]> wrote: > > Hello all, > > > >We are running 3.6.3 (soon moving to 3.8.x). One of the tickets in > > our system is not displaying the history on the Ticket Metadata page, > > even the History title doesn't show up. Other Tickets in the Queue show > > the History. All the transactions are in the db for that ticket #, so > > am not sure how the history display got turned off. Any ideas on how > > this could occur? > > > > > > Thanks, > > Scott > > ___ > > 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
[rt-users] History for a Ticket not displaying
Hello all, We are running 3.6.3 (soon moving to 3.8.x). One of the tickets in our system is not displaying the history on the Ticket Metadata page, even the History title doesn't show up. Other Tickets in the Queue show the History. All the transactions are in the db for that ticket #, so am not sure how the history display got turned off. Any ideas on how this could occur? Thanks, Scott ___ 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] Upgrading to 3.8.0: schema.mysql, column_info selection problem
On Wed, 2008-07-16 at 11:53 -0500, Scott T. Hildreth wrote: > Well I ran all the etc/upgrade/3.7.* upgrades and then created the > query script with schema.mysql-4.0-4.1.pl and I get this error, > > ERROR 1067 (42000) at line 36: Invalid default value for 'LookupType' I looked at the sql, ALTER TABLE CustomFields MODIFY LookupType VARBINARY(255) NOT NULL DEFAULT NULL; ...I guess it doesn't like "NOT NULL" defaulting to ...well NULL. :-) There were 5 of these, so I removed the "DEFAULT NULL" and all was well. >grep "NOT NULL DEFAULT NULL" sql.queries ALTER TABLE CustomFields MODIFY LookupType VARCHAR(255) CHARACTER SET ascii NOT NULL DEFAULT NULL; ALTER TABLE ObjectCustomFieldValues MODIFY ObjectType VARBINARY(255) NOT NULL DEFAULT NULL; ALTER TABLE ObjectCustomFieldValues MODIFY ObjectType VARCHAR(255) CHARACTER SET ascii NOT NULL DEFAULT NULL; ALTER TABLE Transactions MODIFY ObjectType VARBINARY(64) NOT NULL DEFAULT NULL; ALTER TABLE Transactions MODIFY ObjectType VARCHAR(64) CHARACTER SET ascii NOT NULL DEFAULT NULL; > > I am using Server version: 5.0.51a. > > I am confused as well, if you are already on mysql > 4.0 do you need > to run the queries created by schema.mysql-4.0-4.1.pl? I think the > answer is probably yes, since the char set is changed to utf8. > > > On Wed, 2008-07-16 at 11:03 -0500, [EMAIL PROTECTED] wrote: > > Interesting. We're running 5.0.27 and the script worked just fine. > > However, I ran all the schema/acl/insert upgrade commands using all the > > 5.7.xx directories in etc/upgrade. > > > > Still waiting to hear from Ruslan to confirm 100% that you don't need to > > run all these commands and you need only run the schema.mysql-4.0-4.1.pl > > script. > > > > Additionally, not entirely sure, but it sounds like he acknowledges there > > is a problem with the script. > > > > > > James Moseley > > > > > > > > > > > > "Ryan Hardester" > > <[EMAIL PROTECTED] > > i.tracy.ca.us> To > >"Ruslan Zakirov" > > 07/16/2008 10:41 <[EMAIL PROTECTED]>, > > AM<[EMAIL PROTECTED]> > > cc > > > >Subject > >RE: [rt-users] Upgrading to 3.8.0: > >schema.mysql,column_info selection > >problem > > > > > > > > > > > > > > > > > > > > > > I am getting the same column_info failed error message when running the > > script. I'm using mysql5.0.22 on Ubuntu. I did have to move this file to > > the DB server since we are not running RT and the DB on the same > > machine. > > > > --Ryan > > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Ruslan > > Zakirov > > Sent: Wednesday, July 16, 2008 6:57 AM > > To: [EMAIL PROTECTED] > > Cc: rt-users@lists.bestpractical.com > > Subject: Re: [rt-users] Upgrading to 3.8.0: schema.mysql,column_info > > selection problem > > > > In 3.8.0 it's one step :) > > > > However, we've done changes to mysql DB that require additional > > upgrade steps for mysql, and this step fails. > > > > On Wed, Jul 16, 2008 at 5:24 PM, <[EMAIL PROTECTED]> wrote: > > > Did you follow these steps first? > > > > > > You may also need to update RT's database. To find out, type: > > > > > > ls etc/upgrade > > > > > > For each item
Re: [rt-users] Upgrading to 3.8.0: schema.mysql, column_info selection problem
Well I ran all the etc/upgrade/3.7.* upgrades and then created the query script with schema.mysql-4.0-4.1.pl and I get this error, ERROR 1067 (42000) at line 36: Invalid default value for 'LookupType' I am using Server version: 5.0.51a. I am confused as well, if you are already on mysql > 4.0 do you need to run the queries created by schema.mysql-4.0-4.1.pl? I think the answer is probably yes, since the char set is changed to utf8. On Wed, 2008-07-16 at 11:03 -0500, [EMAIL PROTECTED] wrote: > Interesting. We're running 5.0.27 and the script worked just fine. > However, I ran all the schema/acl/insert upgrade commands using all the > 5.7.xx directories in etc/upgrade. > > Still waiting to hear from Ruslan to confirm 100% that you don't need to > run all these commands and you need only run the schema.mysql-4.0-4.1.pl > script. > > Additionally, not entirely sure, but it sounds like he acknowledges there > is a problem with the script. > > > James Moseley > > > > > > "Ryan Hardester" > <[EMAIL PROTECTED] > i.tracy.ca.us> To >"Ruslan Zakirov" > 07/16/2008 10:41 <[EMAIL PROTECTED]>, > AM<[EMAIL PROTECTED]> > cc > >Subject >RE: [rt-users] Upgrading to 3.8.0: >schema.mysql,column_info selection >problem > > > > > > > > > > > I am getting the same column_info failed error message when running the > script. I'm using mysql5.0.22 on Ubuntu. I did have to move this file to > the DB server since we are not running RT and the DB on the same > machine. > > --Ryan > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Ruslan > Zakirov > Sent: Wednesday, July 16, 2008 6:57 AM > To: [EMAIL PROTECTED] > Cc: rt-users@lists.bestpractical.com > Subject: Re: [rt-users] Upgrading to 3.8.0: schema.mysql,column_info > selection problem > > In 3.8.0 it's one step :) > > However, we've done changes to mysql DB that require additional > upgrade steps for mysql, and this step fails. > > On Wed, Jul 16, 2008 at 5:24 PM, <[EMAIL PROTECTED]> wrote: > > Did you follow these steps first? > > > > You may also need to update RT's database. To find out, type: > > > > ls etc/upgrade > > > > For each item in that directory whose name is greater than > > your previously installed RT version, run: > > > > /opt/rt3/sbin/rt-setup-database --action schema \ > > --datadir etc/upgrade/ > > /opt/rt3/sbin/rt-setup-database --action acl \ > > --datadir etc/upgrade/ > > /opt/rt3/sbin/rt-setup-database --action insert \ > >--datadir etc/upgrade/ > > > > > > There are 10 3.7.xx directories that you'll need to go through. > > > > > > James Moseley > > > > > > > > > > > > "web master" > > <[EMAIL PROTECTED] > > ra.com> > To > > Sent by: rt-users@lists.bestpractical.com > > rt-users-bounces@ > cc > > lists.bestpractic > > al.com > Subject > > [rt-users] Upgrading to 3.8.0: > > schema.mysql, column_info > > 07/16/2008 05:00 selection problem > > AM > > > > > > > > > > > > > > > > > > > > Hi there > > I am having schema.mysql-4.0-4.1.pl problems upgrading to version > > 3.8.0 from 3.6.6. > > make upgrade worked well. > > > > As in point 4) of UPGRADING.mysql > > > > [EMAIL PROTECTED] etc/upgrade/schema.mysql-4.0-4.1.pl > sql.queries > > > > but > > > > usage: etc/upgrade/schema.mysql-4.0-4.1.pl db_name db_user db_password > > > > Ok, then I inserted the info needed > > > > [EMAIL PROTECTED] etc/upgrade/schema.mysql-4.0-4.1.pl DB USER PASS > > sql.queries > > > > but > > > > DBD::mysql::db column_info failed: column_info doesn't support column > > selection
Re: [rt-users] Custom Field in ticket display - can a drop down box be added?
On Tue, 2008-03-25 at 13:22 -0500, Scott T. Hildreth wrote: > We have a Queue that has custom fields and when a ticket is created > we can see the custom fields in the ticket display. There is a need > to have one of the fields be a drop down box in the ticket display. Well solved this one, I was looking at the ticket display and my mouse hovered over the "Custom Fields" title and I noticed it was link. I clicked and Shazam, there were all the custom fields ready to be modified. I showed my co-worker, he rolled his eyes, and walked away. Problem Solved. Nothing gets by us. :-D > This would allow the status to be changed, much like the Reminders > section of the display. Is this possible in the custom fields section > of the display or do we need to create section like the Reminders? > >Thanks, >STH > ___ > 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
[rt-users] Custom Field in ticket display - can a drop down box be added?
We have a Queue that has custom fields and when a ticket is created we can see the custom fields in the ticket display. There is a need to have one of the fields be a drop down box in the ticket display. This would allow the status to be changed, much like the Reminders section of the display. Is this possible in the custom fields section of the display or do we need to create section like the Reminders? Thanks, STH ___ 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] History Display for a Ticket
On Wed, 2007-08-08 at 08:28 -0400, Joe Casadonte wrote: > On 8/7/2007 1:01 PM, Scott T. Hildreth wrote: > > > If I query the Transactions table, selecting only transactions for > > this > > ticket that were created by non-RT::System ids, there are 29. All of > > type > > RT::Ticket. If unset the $OldestTransactionsFirst, the history on the > > display > > page shows the first 20 Tickets (non-system tickets, I added the > > HideTransactons override) > > If re-set $OldestTransactionsFirst in RT_SiteConfig.pm, stop apache, > > remove > > mason_data/obj/*, restart apache, search for that ticket, the ticket > > display > > only shows the last 7 tickets. I have looked at RT code and read > > relevant chapters > > in RT Essentials and I cannot figure out why the all history will not > > show up > > in the History section. I feel like I am really overlooking > > something obvious, > > does anyone have any ideas on what is going? > > I just looked at the 3.6.3 code, and I can't see anything that would > limit the number of history records shown, nor do I see anything > different with OldestTransactionsFirst aside from ASC vs. DESC in the > select. I couldn't find anything either. > What code base are you on? > 3.6.4, but it happens with 3.6.3 as well. -- Scott T. Hildreth <[EMAIL PROTECTED]> ___ 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] History Display for a Ticket
On Fri, 2007-08-03 at 15:19 -0500, Scott T. Hildreth wrote:
> On Fri, 2007-08-03 at 10:51 -0500, Scott T. Hildreth wrote:
> > On Thu, 2007-08-02 at 11:53 -0500, Scott T. Hildreth wrote:
> > > On Thu, 2007-08-02 at 09:27 -0700, Kenneth Crocker wrote:
> > > > Scott,
> > > >
> > > >
> > > > Normally, I would say that giving the privilege
> > > > "ShowOutgoingEmail"
> > > > would do the trick. It works just like "ShowTicketComments". Having
> > > > rights like "SeeQueue" and "ShowTicket" does not do the trick alone.
> > > > However, I am now a little confused hearing that flipping the switch on
> > > > $OldestTransactionsFirst did the trick.
> > >
> > > Maybe, I didn't explain it right. They can see the replies & email it
> > > is that all the history does not display on the page. By reversing the
> > > order the newer transactions fill the page now and the older history is
> > > not displaying. I'm wondering if this is some sort of limit set?
> > >
> >
> > This ticket I am looking at has 83 transactions.
If I query the Transactions table, selecting only transactions for this
ticket that were created by non-RT::System ids, there are 29. All of type
RT::Ticket. If unset the $OldestTransactionsFirst, the history on the
display
page shows the first 20 Tickets (non-system tickets, I added the
HideTransactons override)
If re-set $OldestTransactionsFirst in RT_SiteConfig.pm, stop apache,
remove
mason_data/obj/*, restart apache, search for that ticket, the ticket
display
only shows the last 7 tickets. I have looked at RT code and read
relevant chapters
in RT Essentials and I cannot figure out why the all history will not
show up
in the History section. I feel like I am really overlooking something
obvious,
does anyone have any ideas on what is going?
Thanks.
> Only 17 or so show
> > up in the History section of the page.
>
> Well, I opened my eyes wider and found this,
>
> http://wiki.bestpractical.com/view/HideTransactions
>
> which should show all the history on the History Tab,
> although it shows a couple of more of the Transactions,
> they are all not there.
>
> Something is limiting the page size, not sure what. I will
> continue testing, just seeing if more info will spark an
> answer.
>
>
> > Is there a way to display all
> > the transactions or have "next page" link?
>
> I see this is on the WishList on the wiki,
>
> "Ability to display ticket history by page, e.g. 15 rows/transaction
> logs per page, with Next, First, Previous, Last buttons/links at the
> bottom or top. Especially helpful and useful for tickets with huge
> history/transactions and if using RT from a slow connection.
>
> >Does anyone else have
> > this issue?
>
>
> Thanks for listening. :-)
>
> >
> > >
> > > > Unless you had already granted
> > > > that privilege ("ShowOutgoingEmail") and the descending order was the
> > > > problem. Interesting.
> > > >
> > > >
> > > > Kenn
> > > > LBNL
> > > >
> > > >
> > > > Scott T. Hildreth wrote:
> > > > > I know I must be missing something obvious hear, but I can't find the
> > > > > answer. I've had complaints about updates not displaying for a
> > > > > ticket.
> > > > > The email would go out, but the reply was not shown in the Ticket
> > > > > History. I looked into it and saw the data was there just not
> > > > > displaying on the web page. So I set the $OldestTransactionsFirst
> > > > > to '0' and the data showed up to the top of the history. This turned
> > > > > to be an option the users wanted anyways. My question is how do you
> > > > > access the history data that is not showing on the page?
> > > > >
> > > > >
> > > > > Thanks.
> > > > >
--
Scott T. Hildreth <[EMAIL PROTECTED]>
___
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] History Display for a Ticket
On Fri, 2007-08-03 at 10:51 -0500, Scott T. Hildreth wrote:
> On Thu, 2007-08-02 at 11:53 -0500, Scott T. Hildreth wrote:
> > On Thu, 2007-08-02 at 09:27 -0700, Kenneth Crocker wrote:
> > > Scott,
> > >
> > >
> > > Normally, I would say that giving the privilege "ShowOutgoingEmail"
> > > would do the trick. It works just like "ShowTicketComments". Having
> > > rights like "SeeQueue" and "ShowTicket" does not do the trick alone.
> > > However, I am now a little confused hearing that flipping the switch on
> > > $OldestTransactionsFirst did the trick.
> >
> > Maybe, I didn't explain it right. They can see the replies & email it
> > is that all the history does not display on the page. By reversing the
> > order the newer transactions fill the page now and the older history is
> > not displaying. I'm wondering if this is some sort of limit set?
> >
>
> This ticket I am looking at has 83 transactions. Only 17 or so show
> up in the History section of the page.
Well, I opened my eyes wider and found this,
http://wiki.bestpractical.com/view/HideTransactions
which should show all the history on the History Tab,
although it shows a couple of more of the Transactions,
they are all not there.
Something is limiting the page size, not sure what. I will
continue testing, just seeing if more info will spark an
answer.
> Is there a way to display all
> the transactions or have "next page" link?
I see this is on the WishList on the wiki,
"Ability to display ticket history by page, e.g. 15 rows/transaction
logs per page, with Next, First, Previous, Last buttons/links at the
bottom or top. Especially helpful and useful for tickets with huge
history/transactions and if using RT from a slow connection.
>Does anyone else have
> this issue?
Thanks for listening. :-)
>
> >
> > > Unless you had already granted
> > > that privilege ("ShowOutgoingEmail") and the descending order was the
> > > problem. Interesting.
> > >
> > >
> > > Kenn
> > > LBNL
> > >
> > >
> > > Scott T. Hildreth wrote:
> > > > I know I must be missing something obvious hear, but I can't find the
> > > > answer. I've had complaints about updates not displaying for a ticket.
> > > > The email would go out, but the reply was not shown in the Ticket
> > > > History. I looked into it and saw the data was there just not
> > > > displaying on the web page. So I set the $OldestTransactionsFirst
> > > > to '0' and the data showed up to the top of the history. This turned
> > > > to be an option the users wanted anyways. My question is how do you
> > > > access the history data that is not showing on the page?
> > > >
> > > >
> > > > Thanks.
> > > >
--
Scott T. Hildreth <[EMAIL PROTECTED]>
___
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] History Display for a Ticket
On Thu, 2007-08-02 at 11:53 -0500, Scott T. Hildreth wrote:
> On Thu, 2007-08-02 at 09:27 -0700, Kenneth Crocker wrote:
> > Scott,
> >
> >
> > Normally, I would say that giving the privilege "ShowOutgoingEmail"
> > would do the trick. It works just like "ShowTicketComments". Having
> > rights like "SeeQueue" and "ShowTicket" does not do the trick alone.
> > However, I am now a little confused hearing that flipping the switch on
> > $OldestTransactionsFirst did the trick.
>
> Maybe, I didn't explain it right. They can see the replies & email it
> is that all the history does not display on the page. By reversing the
> order the newer transactions fill the page now and the older history is
> not displaying. I'm wondering if this is some sort of limit set?
>
This ticket I am looking at has 83 transactions. Only 17 or so show
up in the History section of the page. Is there a way to display all
the transactions or have "next page" link? Does anyone else have
this issue?
>
> > Unless you had already granted
> > that privilege ("ShowOutgoingEmail") and the descending order was the
> > problem. Interesting.
> >
> >
> > Kenn
> > LBNL
> >
> >
> > Scott T. Hildreth wrote:
> > > I know I must be missing something obvious hear, but I can't find the
> > > answer. I've had complaints about updates not displaying for a ticket.
> > > The email would go out, but the reply was not shown in the Ticket
> > > History. I looked into it and saw the data was there just not
> > > displaying on the web page. So I set the $OldestTransactionsFirst
> > > to '0' and the data showed up to the top of the history. This turned
> > > to be an option the users wanted anyways. My question is how do you
> > > access the history data that is not showing on the page?
> > >
> > >
> > > Thanks.
> > >
--
Scott T. Hildreth <[EMAIL PROTECTED]>
___
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] RTx::Shredder - make test
This looks like an error, but all the tests pass. t/00loadok t/00skeletonok t/01basics..ok t/01ticket..ok t/02group_memberok t/02queue...ok 1/16DBD::SQLite::db prepare failed: no such column: main.Queue(1) at dbdimp.c line 271 at /usr/local/perl-5.8.8/lib/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 465. RT::Handle=HASH(0x8fecbb8) couldn't prepare the query 'SELECT main.* FROM CustomFields main WHERE (main.Disabled = '0') AND (main.Queue = '3') ORDER BY main.SortOrder ASC, main.id ASC 'no such column: main.Queue(1) at dbdimp.c line 271 t/02queue...ok 2/16DBD::SQLite::db prepare failed: no such column: main.Queue(1) at dbdimp.c line 271 at /usr/local/perl-5.8.8/lib/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 465. RT::Handle=HASH(0x8f96a34) couldn't prepare the query 'SELECT main.* FROM CustomFields main WHERE (main.Disabled = '0') AND (main.Queue = '3') ORDER BY main.SortOrder ASC, main.id ASC 'no such column: main.Queue(1) at dbdimp.c line 271 DBD::SQLite::db prepare failed: no such column: main.Queue(1) at dbdimp.c line 271 at /usr/local/perl-5.8.8/lib/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 465. RT::Handle=HASH(0x99b6318) couldn't prepare the query 'SELECT main.* FROM CustomFields main WHERE (main.Disabled = '0') AND (main.Queue = '3') ORDER BY main.SortOrder ASC, main.id ASC 'no such column: main.Queue(1) at dbdimp.c line 271 t/02queue...ok 8/16DBD::SQLite::db prepare failed: no such column: main.Queue(1) at dbdimp.c line 271 at /usr/local/perl-5.8.8/lib/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 465. RT::Handle=HASH(0x9a37ce4) couldn't prepare the query 'SELECT main.* FROM CustomFields main WHERE (main.Disabled = '0') AND (main.Queue = '3') ORDER BY main.SortOrder ASC, main.id ASC 'no such column: main.Queue(1) at dbdimp.c line 271 t/02queue...ok 12/16Odd number of elements in hash assignment at /usr/local/rt-3.6.4/lib/RT/Group_Overlay.pm line 464. DBD::SQLite::db prepare failed: no such column: main.Queue(1) at dbdimp.c line 271 at /usr/local/perl-5.8.8/lib/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 465. RT::Handle=HASH(0x9a0fbdc) couldn't prepare the query 'SELECT main.* FROM CustomFields main WHERE (main.Disabled = '0') AND (main.Queue = '3') ORDER BY main.SortOrder ASC, main.id ASC 'no such column: main.Queue(1) at dbdimp.c line 271 t/02queue...ok t/02templateok t/02userok t/03plugin..ok t/03plugin_usersok All tests successful. Files=10, Tests=109, 35 wallclock secs (22.02 cusr + 4.52 csys = 26.54 CPU) -- Scott T. Hildreth <[EMAIL PROTECTED]> ___ 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] History Display for a Ticket
On Thu, 2007-08-02 at 09:27 -0700, Kenneth Crocker wrote:
> Scott,
>
>
> Normally, I would say that giving the privilege "ShowOutgoingEmail"
> would do the trick. It works just like "ShowTicketComments". Having
> rights like "SeeQueue" and "ShowTicket" does not do the trick alone.
> However, I am now a little confused hearing that flipping the switch on
> $OldestTransactionsFirst did the trick.
Maybe, I didn't explain it right. They can see the replies & email it
is that all the history does not display on the page. By reversing the
order the newer transactions fill the page now and the older history is
not displaying. I'm wondering if this is some sort of limit set?
> Unless you had already granted
> that privilege ("ShowOutgoingEmail") and the descending order was the
> problem. Interesting.
>
>
> Kenn
> LBNL
>
>
> Scott T. Hildreth wrote:
> > I know I must be missing something obvious hear, but I can't find the
> > answer. I've had complaints about updates not displaying for a ticket.
> > The email would go out, but the reply was not shown in the Ticket
> > History. I looked into it and saw the data was there just not
> > displaying on the web page. So I set the $OldestTransactionsFirst
> > to '0' and the data showed up to the top of the history. This turned
> > to be an option the users wanted anyways. My question is how do you
> > access the history data that is not showing on the page?
> >
> >
> > Thanks.
> >
--
Scott T. Hildreth <[EMAIL PROTECTED]>
___
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] History Display for a Ticket
I know I must be missing something obvious hear, but I can't find the answer. I've had complaints about updates not displaying for a ticket. The email would go out, but the reply was not shown in the Ticket History. I looked into it and saw the data was there just not displaying on the web page. So I set the $OldestTransactionsFirst to '0' and the data showed up to the top of the history. This turned to be an option the users wanted anyways. My question is how do you access the history data that is not showing on the page? Thanks. -- Scott T. Hildreth <[EMAIL PROTECTED]> ___ 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] Sudden segfaults Rt-3.6.3
On Fri, 2007-07-27 at 01:12 +0400, Ruslan Zakirov wrote: > On 7/27/07, Scott T. Hildreth <[EMAIL PROTECTED]> wrote: > > On Fri, 2007-07-27 at 00:48 +0400, Ruslan Zakirov wrote: > > > mysql update? perl modules updates? Try different versions of > > > DBIx::SearchBuilder, but if you see seg faults then it's most probably > > > some binary module, for example DBI or DBD::mysql. > > > > I will try the updates, I figured I might have to just wanted to see > > if anybody else had experienced this problem. I did run the > > 'make fixdeps' when I installed it so modules should be fine, but I will > > try an update. > May be you didn't get my crappy response :) :-) > I meant that update of > mysql may cause problems in DBI or DBD::mysql, in this case you should > at least rebuild these modules, it often helps. Mysql hasn't been upgraded, so that shouldn't be the issue. But I am going to upgrade DBD::mysql anyways and see if that fixes the issue. > > > > Thanks Ruslan. > > > > > > > > On 7/27/07, Scott T. Hildreth <[EMAIL PROTECTED]> wrote: > > > > Looking back through old logs, this has happened before but not > > > > with the frequency that has occurred in the last 3 days. > > > > > > > > On Thu, 2007-07-26 at 14:50 -0500, Scott T. Hildreth wrote: > > > > > I've had rt-3.6.3 running for awhile, while I was on vacation > > > > > users were complaining that the changes to tickets were not saved. > > > > > My manager was poking around and found seg fault messages in the > > > > > Apache logs. I ran mysqlcheck on the databases (we have replication > > > > > running) and the tables seem fine. I checked /var/log/messages and > > > > > I see this error message when the seq fault occurs, > > > > > > > > > > Jul 26 13:36:51 dots1a RT: DBD::mysql::st execute failed: Unknown > > > > > column > > > > > > > > > > 'main.0xa00c930' in 'order clause' > > > > > > > > > > > > > > > at > > > > > /usr/local/perl-5.8.8/lib/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm > > > > > line 505. > > > > > > > > > > (/usr/local/perl-5.8.8/lib/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:505) > > > > > Jul 26 13:36:51 dots1a RT: RT::Handle=HASH(0x9af88ac) couldn't > > > > > execute the query > > > > > 'SELECT main.* FROM Tickets main WHERE (main.Status != 'deleted') > > > > > AND ( ( main.Owner = '10' ) > > > > > AND ( main.Status = 'new' OR main.Status = 'open' ) ) AND ( > > > > > > > > > > > > > > > 'main.0xa00c930' <= this doesn't look good > > > > > > > > > > any ideas? > > > > > > > > > > Thanks. > > > > > > > > -- > > > > Scott T. Hildreth <[EMAIL PROTECTED]> > > > > _______ > > > > 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 > > > > > > > > > > > > -- > > Scott T. Hildreth <[EMAIL PROTECTED]> > > ___ > > 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 > > > > -- Scott T. Hildreth <[EMAIL PROTECTED]> ___ 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] Sudden segfaults Rt-3.6.3
On Fri, 2007-07-27 at 00:48 +0400, Ruslan Zakirov wrote: > mysql update? perl modules updates? Try different versions of > DBIx::SearchBuilder, but if you see seg faults then it's most probably > some binary module, for example DBI or DBD::mysql. I will try the updates, I figured I might have to just wanted to see if anybody else had experienced this problem. I did run the 'make fixdeps' when I installed it so modules should be fine, but I will try an update. Thanks Ruslan. > > On 7/27/07, Scott T. Hildreth <[EMAIL PROTECTED]> wrote: > > Looking back through old logs, this has happened before but not > > with the frequency that has occurred in the last 3 days. > > > > On Thu, 2007-07-26 at 14:50 -0500, Scott T. Hildreth wrote: > > > I've had rt-3.6.3 running for awhile, while I was on vacation > > > users were complaining that the changes to tickets were not saved. > > > My manager was poking around and found seg fault messages in the > > > Apache logs. I ran mysqlcheck on the databases (we have replication > > > running) and the tables seem fine. I checked /var/log/messages and > > > I see this error message when the seq fault occurs, > > > > > > Jul 26 13:36:51 dots1a RT: DBD::mysql::st execute failed: Unknown column > > > > > > 'main.0xa00c930' in 'order clause' > > > > > > > > > at > > > /usr/local/perl-5.8.8/lib/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm > > > line 505. > > > > > > (/usr/local/perl-5.8.8/lib/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:505) > > > Jul 26 13:36:51 dots1a RT: RT::Handle=HASH(0x9af88ac) couldn't execute > > > the query > > > 'SELECT main.* FROM Tickets main WHERE (main.Status != 'deleted') AND ( > > > ( main.Owner = '10' ) > > > AND ( main.Status = 'new' OR main.Status = 'open' ) ) AND ( > > > > > > > > > 'main.0xa00c930' <= this doesn't look good > > > > > > any ideas? > > > > > > Thanks. > > > > -- > > Scott T. Hildreth <[EMAIL PROTECTED]> > > ___ > > 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 > > > > -- Scott T. Hildreth <[EMAIL PROTECTED]> ___ 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] Sudden segfaults Rt-3.6.3
Looking back through old logs, this has happened before but not with the frequency that has occurred in the last 3 days. On Thu, 2007-07-26 at 14:50 -0500, Scott T. Hildreth wrote: > I've had rt-3.6.3 running for awhile, while I was on vacation > users were complaining that the changes to tickets were not saved. > My manager was poking around and found seg fault messages in the > Apache logs. I ran mysqlcheck on the databases (we have replication > running) and the tables seem fine. I checked /var/log/messages and > I see this error message when the seq fault occurs, > > Jul 26 13:36:51 dots1a RT: DBD::mysql::st execute failed: Unknown column > > 'main.0xa00c930' in 'order clause' > > > at /usr/local/perl-5.8.8/lib/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm > line 505. > > (/usr/local/perl-5.8.8/lib/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:505) > Jul 26 13:36:51 dots1a RT: RT::Handle=HASH(0x9af88ac) couldn't execute the > query > 'SELECT main.* FROM Tickets main WHERE (main.Status != 'deleted') AND ( ( > main.Owner = '10' ) > AND ( main.Status = 'new' OR main.Status = 'open' ) ) AND ( > > > 'main.0xa00c930' <= this doesn't look good > > any ideas? > > Thanks. -- Scott T. Hildreth <[EMAIL PROTECTED]> ___ 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] Sudden segfaults Rt-3.6.3
I've had rt-3.6.3 running for awhile, while I was on vacation users were complaining that the changes to tickets were not saved. My manager was poking around and found seg fault messages in the Apache logs. I ran mysqlcheck on the databases (we have replication running) and the tables seem fine. I checked /var/log/messages and I see this error message when the seq fault occurs, Jul 26 13:36:51 dots1a RT: DBD::mysql::st execute failed: Unknown column 'main.0xa00c930' in 'order clause' at /usr/local/perl-5.8.8/lib/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 505. (/usr/local/perl-5.8.8/lib/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:505) Jul 26 13:36:51 dots1a RT: RT::Handle=HASH(0x9af88ac) couldn't execute the query 'SELECT main.* FROM Tickets main WHERE (main.Status != 'deleted') AND ( ( main.Owner = '10' ) AND ( main.Status = 'new' OR main.Status = 'open' ) ) AND ( 'main.0xa00c930' <= this doesn't look good any ideas? Thanks. -- Scott T. Hildreth <[EMAIL PROTECTED]> ___ 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 4
On Tue, 2007-05-01 at 12:18 -0700, Justin Brodley wrote: > I'd like to see the following: > > 1. Better Documentation and resources for the product (current methods > are cumbersome and slow ie. List Archives or the Wiki) > 2. Ruby on rails would be great... Just curious, why ror. I would be that RT4 would be written using Jifty. > but as your PERL guys I assume > unrealistic. Really a complete SOA architecture would be fantastic > 3. More complexity around Custom Fields, current model is very > cumbersome > 4. Have every function and feature exported into a fully functional API > layer > 5. Ability for RT to natively sync data between multiple RT instances > (Enterprise feature set) > 6. A robust change management interface that follows ITIL standards > 7. Way to track SLA's based on Response and remedy commitments > 8. Ability to do more site maintenance tasks in the GUI, DB backups, RTx > Extensions, Simple Branding, etc. > 9. Reporting layer utilizing the Jasper Framework > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Jesse > Vincent > Sent: Tuesday, May 01, 2007 10:55 AM > To: RT Users > Subject: [rt-users] RT 4 > > If, for the sake of argument, Best Practical were to rewrite RT, what > would you want to see in the new product? > > Think big. > > Jesse > ___ > 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 > -- Scott T. Hildreth <[EMAIL PROTECTED]> ___ 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] Rename Queues
On Thu, 2007-02-01 at 09:17 -0600, Scott T. Hildreth wrote: > I renamed a Queue, but the old Queue name is in the drop down list > for the Search page. I tried stopping & starting Apache, but the > old Queue name is still in the drop down list. Is this a cache that > needs to be cleaned out? > http://wiki.bestpractical.com/index.cgi?CleanMasonCache Well I tried this and the old name still shows up in the drop down list. > Thanks. > -- Scott T. Hildreth <[EMAIL PROTECTED]> ___ 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] Rename Queues
On Thu, 2007-02-01 at 10:20 -0500, Stephen Turner wrote: > Scott T. Hildreth wrote: > > I renamed a Queue, but the old Queue name is in the drop down list > > for the Search page. I tried stopping & starting Apache, but the > > old Queue name is still in the drop down list. Is this a cache that > > needs to be cleaned out? > > > > Thanks. > > > > Does log out/in do it? Yep... :-) Thanks. > > Steve -- Scott T. Hildreth <[EMAIL PROTECTED]> ___ 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] Rename Queues
I renamed a Queue, but the old Queue name is in the drop down list for the Search page. I tried stopping & starting Apache, but the old Queue name is still in the drop down list. Is this a cache that needs to be cleaned out? Thanks. -- Scott T. Hildreth <[EMAIL PROTECTED]> ___ 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] Bug... maybe
This is was occurring on 3.6.0 & 3.6.3. A user created a queue 'Foo & Bar'. When "RT at a glance" page came up, you can see the queue in the Quick Search box. If it is clicked none of the tickets would show up, but if a search is done with "Queue is Foo & Bar" the tickets would be displayed. I finally figured out it was the '&' causing the problem. I renamed the queue and all is well. Is the '&' causing html problems? Should there be a constraint on queue names that doesn't allow certain characters? Thanks. -- Scott T. Hildreth <[EMAIL PROTECTED]> ___ 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] Does anyone else think the 3.6.1 UI is... less attractive... than 3.4.5?
On Wed, 2006-10-18 at 23:10 +0200, Luca Corti wrote: > On Wed, 2006-10-18 at 16:19 -0400, Lee Whalen wrote: > > or could I not have gotten out of the woods yet on this CSS issue? Does > > anyone have any screenshots of a good working 3.6.1 install? > > Hello, > > I have not had any issue with the new appearence, I prefer the new look, no complaints or 'ewww's from the users when I installed the new version. :-) > > my 2 cents > > Luca > > ___ > 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 -- Scott T. Hildreth <[EMAIL PROTECTED]> ___ 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.6 : apache2 configuration issues
On Wed, 2006-10-11 at 17:03 +0200, Manuel wrote: > Here they are... > As I said this are just copies of example found in links since I do not > understand all directives implications especially those related to INODB and > perl. > Do you have mod_perl installed? Here is what I have (I don't use a VirtualHost) ### Alias /rt /usr/local/rt-3.6pre0/share/html/ SetHandler perl-script PerlHandler RT::Mason PerlModule Apache::DBI PerlRequire /usr/local/rt-3.6pre0/bin/webmux.pl ... (I left out the ldap settings) SetHandler perl-script PerlHandler RT::Mason ## PerlModule Apache2 Apache::compat <= You don't need this. > >PerlModule Apache::DBI >PerlRequire /opt/rt3/bin/webmux.pl > > >SetHandler perl-script >PerlHandler RT::Mason > > > > This one gives me the syntax error on line 10 (first PerlModule) ... > > I guess perl is not properly linked to apache2... > How can I check this? > I tried several different but there is always something wrong somewhere > > > Thanks > > Manuel > > > -Message d'origine- > De : Scott T. Hildreth [mailto:[EMAIL PROTECTED] > Envoyé : mercredi 11 octobre 2006 15:41 > À : Manuel ESCHENBRENNER > Cc : rt-users@lists.bestpractical.com > Objet : Re: [rt-users] rt 3.6 : apache2 configuration issues > > > Can you post your httpd.conf, the rt section? > > On Wed, 2006-10-11 at 14:14 +0200, Manuel ESCHENBRENNER wrote: > > I am trying to get RT 3.6 running with apache2 on Ubuntu for 2 weeks > > now... > > I'm not very advanced in RT nor Linux > > > > I really look at a lot of places to find the right helpful information > > about apache2 settings for RT 3.6 that are required to get out of the > > "almost here". > > > > I know that my apache2 configuration is wrong and found a lot about this > > but never in this particular configuration. RT3.6 + apache2 Parameter > > samples are always related to RT 3.4+apache2 or RT3.6+Apache and did not > > work. I tried almost all samples available in related links from your > > advices: > > > > http://wiki.bestpractical.com/ (the place lots of answers) > > http://gossamer-threads.com/lists/rt/ (searchable list archives) > > http://www.google.com/ (I generally start > > "+RT+MostUniqueErrMsg") And some more... > > > > Can anyone point me in the right direction? > > > > Thanks. > > > > Manuel Eschenbrenner > > > > ___ > > 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 > > -- Scott T. Hildreth <[EMAIL PROTECTED]> ___ 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.6 : apache2 configuration issues
Can you post your httpd.conf, the rt section? On Wed, 2006-10-11 at 14:14 +0200, Manuel ESCHENBRENNER wrote: > I am trying to get RT 3.6 running with apache2 on Ubuntu for 2 weeks > now... > I'm not very advanced in RT nor Linux > > I really look at a lot of places to find the right helpful information > about apache2 settings for RT 3.6 that are required to get out of the > "almost here". > > I know that my apache2 configuration is wrong and found a lot about this > but never in this particular configuration. RT3.6 + apache2 Parameter > samples are always related to RT 3.4+apache2 or RT3.6+Apache and did not > work. I tried almost all samples available in related links from your > advices: > > http://wiki.bestpractical.com/ (the place lots of answers) > http://gossamer-threads.com/lists/rt/ (searchable list archives) > http://www.google.com/ (I generally start > "+RT+MostUniqueErrMsg") And some more... > > Can anyone point me in the right direction? > > Thanks. > > Manuel Eschenbrenner > > ___ > 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 > -- Scott T. Hildreth <[EMAIL PROTECTED]> ___ 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] There is a podcast interview with Jesse..
on http://www.perlcast.com - all about Jifty. Very interesting, check it out if haven't already. -- Scott T. Hildreth <[EMAIL PROTECTED]> ___ 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 We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
[rt-users] Jesse Will Be At YAPC
My Plug for Jesse: -- I thought I would mention, that if you haven't noticed, Jesse will be giving a talk on Jifty at YAPC. http://yapcchicago.org/the-schedule/tuesday ..so if you are in Chicago June 26-28 attend YAPC and go see Jesse talk about Jifty, I am. :-) My Sales Pitch for YAPC : There is a early-register discount until April 30th, $85 for the three days, normally a $100 (still a bargain). http://yapcchicago.org/zencart/ Thanks for listening, hope to see you there! STH -- Scott T. Hildreth <[EMAIL PROTECTED]> ___ 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 We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
