RT 4.0.12rc1 ready for testing

RT 4.0.12rc1 is now available for testing.

http://download.bestpractical.com/pub/rt/devel/rt-4.0.12rc1.tar.gz
http://download.bestpractical.com/pub/rt/devel/rt-4.0.12rc1.tar.gz.sig

SHA1 sums
e07c7e8a78f605b44ed6dce855cb472ae0f31c05 rt-4.0.12rc1.tar.gz
6d8acbe21e249171f7ab4aa5b7e277b40f98adae rt-4.0.12rc1.tar.gz.sig

This release of RT repairs a regression in 4.0.11. If you use the Rich
Text Editor, the red background on Reply was missing due to the update
of CKEditor to support IE10. It also includes a database upgrade, so
please make sure to run ‘make upgrade-database’.

Features

  • Date and DateTime Custom Fields now have the same ‘smart’ date parsing
    that core RT date fields have.
  • Improved logging when the sending of a Correspond or Comment fails.
  • The Quick Search preferences page now has Select/Clear All buttons.
  • Unprivileged users can now change Language and Time Zone.
  • Warn MySQL users if their max_allowed_packet is dangerously low.

Bugfixes

  • Repair 4.0.11 regression where red background on Reply with the
    RichText Editor was lost.
  • Quiet warnings in the verbose user format.
  • Allow changing the case of a Group’s name (prevented by earlier code
    stopping you from having two groups with the same name).
  • Allow changing the case of a Class’s name.
  • Avoid warnings when using empty Templates.
  • Update our InnoDB checks for MySQL 5.6 compatibility.
  • Clarification of when SetOutgoingMailFrom and OverrideOutgoingMailFrom
    are available.
  • Improve layout of collection lists in IE.
  • Fix Attach more files button in Self Service.
  • Set caching headers on autocomplete endpoints.
  • Restore and improve prematurely deleted documentation for
    DontSearchFileAttachments.
  • Correct the encoding of Dashboard email Subject headers.
  • Fix the default roles on User->WatchedQueues.
  • Document the need to grant SeeCustomField in UPGRADING-3.4.
  • Nudge menus below the shadows in aileron.
  • Fix missing headers and a syntax error in the
    /REST/1.0/attachment/NN endpoint.

Localization

  • Improve the display of numbers when using the French localization.
  • Built in components and searches (such as Bookmarked Tickets) are now
    localizable.
  • Use PostgreSQL error codes in the full-text-indexer instead of
    matching on error messages that may be in a non-english language.
  • Localize ‘Dashboard’ during creation.
  • Mark ‘Modify this user’ as localizable.

Developer

  • Test can now be run against a remote DB server.
  • Install etc/upgrade to make some rt-setup-database actions easier
    without requiring access to the install directory.
  • RT_TEST_PARALLEL_NUM controls the -j param in make parallel-test
  • Work around a git bug in git archive when packaging releases.
    This caused the third party sources to bloat the 4.0.11 tarball.
  • Fix examples in the CreateTickets documentation.
  • RT Ticket types (ticket, approval, reminder) are now always forced to
    lower case.
  • Allow the use of ‘NOT IN’ in Limits (assuming a new enough
    DBIx::SearchBuilder).

A complete changelog is available from git by running:
git log rt-4.0.11…rt-4.0.12rc1
or visiting
Comparing rt-4.0.11...rt-4.0.12rc1 · bestpractical/rt · GitHub

I have installed this over my 4.0.11 and when restarting apache, I get
this warning:

[root@jaribu] ~/Tools/RT/rt-4.0.12rc1# /usr/local/etc/rc.d/apache22 stop
Stopping apache22.
Waiting for PIDS: 83534.
[root@jaribu] ~/Tools/RT/rt-4.0.12rc1# /usr/local/etc/rc.d/apache22 start
Performing sanity check on apache22 configuration:
[Fri Apr 26 15:57:47 2013] [warning]: max_allowed_packet is set to
1.0M, which limits the maximum attachment or email size that RT can
process. Consider adjusting MySQL’s max_allowed_packet setting.
(/opt/rt4/sbin/…/lib/RT/Handle.pm:296)
Syntax OK
Starting apache22.
[Fri Apr 26 15:57:48 2013] [warning]: max_allowed_packet is set to
1.0M, which limits the maximum attachment or email size that RT can
process. Consider adjusting MySQL’s max_allowed_packet setting.
(/opt/rt4/sbin/…/lib/RT/Handle.pm:296)
[root@jaribu] ~/Tools/RT/rt-4.0.12rc1#

However,

[root@jaribu] ~/Tools/RT/rt-4.0.12rc1# grep max_allowe /etc/my.cnf
max_allowed_packet = 5M
max_allowed_packet = 16MOn 26 April 2013 18:45, Kevin Falcone falcone@bestpractical.com wrote:

RT 4.0.12rc1 is now available for testing.

http://download.bestpractical.com/pub/rt/devel/rt-4.0.12rc1.tar.gz
http://download.bestpractical.com/pub/rt/devel/rt-4.0.12rc1.tar.gz.sig

SHA1 sums
e07c7e8a78f605b44ed6dce855cb472ae0f31c05 rt-4.0.12rc1.tar.gz
6d8acbe21e249171f7ab4aa5b7e277b40f98adae rt-4.0.12rc1.tar.gz.sig

This release of RT repairs a regression in 4.0.11. If you use the Rich
Text Editor, the red background on Reply was missing due to the update
of CKEditor to support IE10. It also includes a database upgrade, so
please make sure to run ‘make upgrade-database’.

Features

  • Date and DateTime Custom Fields now have the same ‘smart’ date parsing
    that core RT date fields have.
  • Improved logging when the sending of a Correspond or Comment fails.
  • The Quick Search preferences page now has Select/Clear All buttons.
  • Unprivileged users can now change Language and Time Zone.
  • Warn MySQL users if their max_allowed_packet is dangerously low.

Bugfixes

  • Repair 4.0.11 regression where red background on Reply with the
    RichText Editor was lost.
  • Quiet warnings in the verbose user format.
  • Allow changing the case of a Group’s name (prevented by earlier code
    stopping you from having two groups with the same name).
  • Allow changing the case of a Class’s name.
  • Avoid warnings when using empty Templates.
  • Update our InnoDB checks for MySQL 5.6 compatibility.
  • Clarification of when SetOutgoingMailFrom and OverrideOutgoingMailFrom
    are available.
  • Improve layout of collection lists in IE.
  • Fix Attach more files button in Self Service.
  • Set caching headers on autocomplete endpoints.
  • Restore and improve prematurely deleted documentation for
    DontSearchFileAttachments.
  • Correct the encoding of Dashboard email Subject headers.
  • Fix the default roles on User->WatchedQueues.
  • Document the need to grant SeeCustomField in UPGRADING-3.4.
  • Nudge menus below the shadows in aileron.
  • Fix missing headers and a syntax error in the
    /REST/1.0/attachment/NN endpoint.

Localization

  • Improve the display of numbers when using the French localization.
  • Built in components and searches (such as Bookmarked Tickets) are now
    localizable.
  • Use PostgreSQL error codes in the full-text-indexer instead of
    matching on error messages that may be in a non-english language.
  • Localize ‘Dashboard’ during creation.
  • Mark ‘Modify this user’ as localizable.

Developer

  • Test can now be run against a remote DB server.
  • Install etc/upgrade to make some rt-setup-database actions easier
    without requiring access to the install directory.
  • RT_TEST_PARALLEL_NUM controls the -j param in make parallel-test
  • Work around a git bug in git archive when packaging releases.
    This caused the third party sources to bloat the 4.0.11 tarball.
  • Fix examples in the CreateTickets documentation.
  • RT Ticket types (ticket, approval, reminder) are now always forced to
    lower case.
  • Allow the use of ‘NOT IN’ in Limits (assuming a new enough
    DBIx::SearchBuilder).

A complete changelog is available from git by running:
git log rt-4.0.11…rt-4.0.12rc1
or visiting
Comparing rt-4.0.11...rt-4.0.12rc1 · bestpractical/rt · GitHub

Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254733744121/+254722743223
“I can’t hear you – I’m using the scrambler.”

[Fri Apr 26 15:57:47 2013] [warning]: max_allowed_packet is set to
1.0M, which limits the maximum attachment or email size that RT can
process. Consider adjusting MySQL’s max_allowed_packet setting.
(/opt/rt4/sbin/…/lib/RT/Handle.pm:296)
[root@jaribu] ~/Tools/RT/rt-4.0.12rc1# grep max_allowe /etc/my.cnf
max_allowed_packet = 5M
max_allowed_packet = 16M

Connect to the mysql rt database as your rt_user and show what
show variables like ‘max_allowed_packet’;
returns?

Thanks

-kevin

[root@jaribu] ~/Tools/RT/rt-4.0.12rc1# grep max_allo vars.txt
max_allowed_packet 1048576
slave_max_allowed_packet 1073741824On 26 April 2013 19:33, Kevin Falcone falcone@bestpractical.com wrote:

On Fri, Apr 26, 2013 at 06:59:04PM +0300, Odhiambo Washington wrote:

[Fri Apr 26 15:57:47 2013] [warning]: max_allowed_packet is set to
1.0M, which limits the maximum attachment or email size that RT can
process. Consider adjusting MySQL’s max_allowed_packet setting.
(/opt/rt4/sbin/…/lib/RT/Handle.pm:296)
[root@jaribu] ~/Tools/RT/rt-4.0.12rc1# grep max_allowe /etc/my.cnf
max_allowed_packet = 5M
max_allowed_packet = 16M

Connect to the mysql rt database as your rt_user and show what
show variables like ‘max_allowed_packet’;
returns?

Thanks

-kevin

Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254733744121/+254722743223
“I can’t hear you – I’m using the scrambler.”

[root@jaribu] ~/Tools/RT/rt-4.0.12rc1# grep max_allo vars.txt
max_allowed_packet 1048576
slave_max_allowed_packet 1073741824

So - mysqld is still running with a 1MB max_allowed_packet according
to that.

[root@jaribu] ~/Tools/RT/rt-4.0.12rc1# grep max_allowe /etc/my.cnf
max_allowed_packet = 5M
max_allowed_packet = 16M

What sections are these max_allowed_packet’s defined in?
I’d guess that one is in the [mysqldump] section, not so sure about
the 5M one, possibly [safe_mysqld] rather than [mysqld] or vice-versa.

-kevin

max_allowed_packet variables are in [mysqld] and [mysqldump] sections of my.cnf.
I’ve restarted mysqld but the values appear to be persistent, somehow…On 26 April 2013 19:41, Kevin Falcone falcone@bestpractical.com wrote:

On Fri, Apr 26, 2013 at 07:36:06PM +0300, Odhiambo Washington wrote:

[root@jaribu] ~/Tools/RT/rt-4.0.12rc1# grep max_allo vars.txt
max_allowed_packet 1048576
slave_max_allowed_packet 1073741824

So - mysqld is still running with a 1MB max_allowed_packet according
to that.

[root@jaribu] ~/Tools/RT/rt-4.0.12rc1# grep max_allowe /etc/my.cnf
max_allowed_packet = 5M
max_allowed_packet = 16M

What sections are these max_allowed_packet’s defined in?
I’d guess that one is in the [mysqldump] section, not so sure about
the 5M one, possibly [safe_mysqld] rather than [mysqld] or vice-versa.

-kevin

Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254733744121/+254722743223
“I can’t hear you – I’m using the scrambler.”

max_allowed_packet variables are in [mysqld] and [mysqldump] sections of my.cnf.
I’ve restarted mysqld but the values appear to be persistent, somehow…

Depending on how mysql is started from the init script, you can
sometimes need to put things in safe_mysqld vs mysqld (although
generally I see it the other way around and [mysqld] is the safest
place to put things).

Check other customizations you’ve made to the [mysqld] section and see
if they’re showing up in show variables?

-kevin