Re: [rt-users] RT2.0.15 to RT3.8.1
--- On Tue, 1/6/09, Joseph Spenner joseph85...@yahoo.com wrote: --max_allowed_packet=128M as recommended at http://wiki.bestpractical.com/view/PgToMySQL to get rid of a 'max allowed packet' error I got. What is the recommended max_allowed_packet size for RT3? Is there a performance hit making it too big, as I set above? The default value (16M) would cause a failure during the import, but I'm not sure how it would behave now that the import is finished. I don't want it to crash later though. I was also curious about more generic mysql settings. Does anyone have some /etc/my.conf recommendations? On my distro (slackware 12.2) there exists: /etc/my-huge.cnf /etc/my-large.cnf /etc/my-medium.cnf /etc/my-small.cnf My RT has about 13000 tickets, and isn't very busy. However, since my test upgrade the new RT3 is quite a bit slower in response time compared to my RT2. Ticket content loads slowly. I'm also configured with FastCGI. Should I expect this to be slower than mod_perl ? ___ 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] RT2.0.15 to RT3.8.1
On Tue, 6 Jan 2009, Joseph Spenner wrote: I successfully migrated a RT 2.0.15 system to RT 3.8.1. Everything worked quite well, with only 2 small stumbling blocks: 1) The importer didn't like to import tickets/queues that were disabled. So, I re-enabled all the queues, did a new dump/import. All went well. 2) I had to modify how mysql started: --max_allowed_packet=128M as recommended at http://wiki.bestpractical.com/view/PgToMySQL to get rid of a 'max allowed packet' error I got. I have a question/issue with RT3.8.1 though. On the main menu, RT at a glance, everything looks great. However, the section titles: 10 highest priority tickets I own, 10 newest unowned tickets, and Bookmarked Tickets are hyperlinks which give an error when clicked. They appear to be trying to go to a 'localhost' address: http://localhost/Search/Results.html?Format=%27%3Ca%20href%3D%22%2FTicket%2FDispl ay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E%2FTITLE%3A%23%27%2C%27%3Ca%20href%3D% 22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__Subject__%3C%2Fa%3E%2FTITLE%3ASub ject%27%2CPriority%2C%20QueueName%2C%20ExtendedStatusOrder=DESCOrderBy=Priority Query=%20Owner%20%3D%20%27__CurrentUser__%27%20AND%20(%20Status%20%3D%20%27new%2 7%20OR%20Status%20%3D%20%27open%27) http://localhost/Search/Results.html?Format=%27%3Ca%20href%3D%22%2FTicket%2FDispl ay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E%2FTITLE%3A%23%27%2C%27%3Ca%20href%3D% 22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__Subject__%3C%2Fa%3E%2FTITLE%3ASub ject%27%2CQueueName%2C%20ExtendedStatus%2C%20CreatedRelative%2C%20%27%3CA%20HREF% 3D%22%2FTicket%2FDisplay.html%3FAction%3DTake%26id%3D__id__%22%3ETake%3C%2Fa%3E%2 FTITLE%3ANBSP%27Order=DESCOrderBy=CreatedQuery=%20Owner%20%3D%20%27Nob ody%27%20AND%20(%20Status%20%3D%20%27new%27%20OR%20Status%20%3D%20%27open%27) http://localhost/Search/Results.html?Format=%27%3Ca%20href%3D%22%2FTicket%2FDispl ay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E%2FTITLE%3A%23%27%2C%27%3Ca%20href%3D% 22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__Subject__%3C%2Fa%3E%2FTITLE%3ASub ject%27%2CPriority%2C%20QueueName%2C%20ExtendedStatus%2C%20BookmarkOrder=DESCOr derBy=LastUpdatedQuery=id%20%3D%20%27__Bookmarked__%27Rows=999 When the error is on the screen, if I replace 'localhost' with the system/ip and reload, the section comes up correctly. Where is it getting 'localhost' ? The following parameter controls what is used in the URL: Set($WebDomain, 'localhost'); Add to RT_SiteConfig.pm and change localhost to the IP or hostname. ___ 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] RT2.0.15 to RT3.8.1
--- On Tue, 1/6/09, Duane Hill d.h...@yournetplus.com wrote: From: Duane Hill d.h...@yournetplus.com Subject: Re: [rt-users] RT2.0.15 to RT3.8.1 To: rt-users@lists.bestpractical.com Date: Tuesday, January 6, 2009, 11:06 AM On Tue, 6 Jan 2009, Joseph Spenner wrote: Where is it getting 'localhost' ? The following parameter controls what is used in the URL: Set($WebDomain, 'localhost'); Add to RT_SiteConfig.pm and change localhost to the IP or hostname. ___ That was it. Thanks! Curious how all the other links seemed to know where to go... ___ 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] RT2.0.15 to RT3.8.1
--- On Tue, 1/6/09, Joseph Spenner joseph85...@yahoo.com wrote: From: Joseph Spenner joseph85...@yahoo.com Subject: [rt-users] RT2.0.15 to RT3.8.1 To: rt-users@lists.bestpractical.com Date: Tuesday, January 6, 2009, 10:48 AM I successfully migrated a RT 2.0.15 system to RT 3.8.1. Everything worked quite well, with only 2 small stumbling blocks: 1) The importer didn't like to import tickets/queues that were disabled. So, I re-enabled all the queues, did a new dump/import. All went well. 2) I had to modify how mysql started: --max_allowed_packet=128M as recommended at http://wiki.bestpractical.com/view/PgToMySQL to get rid of a 'max allowed packet' error I got. What is the recommended max_allowed_packet size for RT3? Is there a performance hit making it too big, as I set above? The default value (16M) would cause a failure during the import, but I'm not sure how it would behave now that the import is finished. I don't want it to crash later though. ___ 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