Problems after security patch RT 3.8.8

Hi,

we have run into problem after adding following security patches

  • security-2011-04-14
  • security-2012-05-22
  • security-2012-10-25
  • security-2013-05-22
    and
  • RT-Extension-SaltedPasswords-1.2

I include an example of the log messages we get when we “Launch a new investigation”.

Looking forward hearing from you,
/thomas s.
CSIRT, Uppsala University

Jun 25 11:08:23 kock6 RT: rt-3.8.8-12857-1372151303-953.219672-3-0@uu.se sent To: xxxxxx.yyyyyy
.xxxx@zzzzzzz.uu.se (/usr/local/rt3/bin/…/lib/RT/Action/SendEmail.pm:331)

Jun 25 11:08:23 kock6 RT: DBD::mysql::st execute failed: MySQL server has gone away at /usr/share/p
erl5/DBIx/SearchBuilder/Handle.pm line 509. (/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:509)

Jun 25 11:08:23 kock6 RT: RT::Handle=HASH(0x7fda0bfb8958) couldn’t execute the query ‘INSERT INTO T
ransactions (OldValue, NewReference, OldReference, NewValue, Creator, ObjectId, Type, Field, Refere
nceType, Created, Data, ObjectType) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ at /usr/share/perl
5/DBIx/SearchBuilder/Handle.pm line 522#012#011DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle
=HASH(0x7fda0bfb8958)’, ‘INSERT INTO Transactions (OldValue, NewReference, OldReferenc…’, undef,
undef, undef, undef, 1, 219672, ‘EmailRecord’, …) called at /usr/share/perl5/DBIx/SearchBuilder/H
andle.pm line 357#012#011DBIx::SearchBuilder::Handle::Insert(‘RT::Handle=HASH(0x7fda0bfb8958)’, ‘Tr
ansactions’, ‘OldValue’, undef, ‘NewReference’, undef, ‘OldReference’, undef, ‘NewValue’, …) call
ed at /usr/share/perl5/DBIx/SearchBuilder/Handle/mysql.pm line 36#012#011DBIx::SearchBuilder::Handl
e::mysql::Insert(‘RT::Handle=HASH(0x7fda0bfb8958)’, ‘Transactions’, ‘OldValue’, undef, ‘NewReferenc
e’, undef, ‘OldReference’, undef, ‘NewValue’, …) called at /usr/share/perl5/DBIx/SearchBuilder/Re
cord.pm line 1293#012#011DBIx::SearchBuilder::Record::Create(‘RT::Transaction=HASH(0x7fda089442d8)’
, ‘OldValue’, undef, ‘NewReference’, undef, ‘OldReference’, undef, ‘NewValue’, undef, …) called a
t /usr/local/rt3/bin/…/lib/RT/Record.pm line 289#012#011RT::Record::Create(‘RT::Transaction=HASH(0
x7fda089442d8)’, ‘OldValue’, undef, ‘NewReference’, undef, ‘OldReference’, undef, ‘NewValue’, undef
, …) called at /usr/local/rt3/bin/…/lib/RT/Transaction_Overlay.pm line 151#012#011RT::Transactio
n::Create(‘RT::Transaction=HASH(0x7fda089442d8)’, ‘Ticket’, 219672, ‘Type’, ‘EmailRecord’, ‘Data’,
rt-3.8.8-12857-1372151303-953.219672-3-0@uu.se’, ‘MIMEObj’, ‘MIME::Entity=HASH(0x7fda08913db8)’,
…) called at /usr/local/rt3/bin/…/lib/RT/Action/SendEmail.pm line 546#012#011RT::Action::SendEm
ail::RecordOutgoingMailTransaction(‘RT::Action::Autoreply=HASH(0x7fda08903568)’, ‘MIME::Entity=HASH
(0x7fda08913db8)’) called at /Jun 25 11:08:23 kock6 RT: DBD::mysql::st execute failed: MySQL server has gone away at
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 509. (/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:509)

Jun 25 11:08:23 kock6 RT: RT::Handle=HASH(0x7fda0bfb8958) couldn’t execute the query ‘SELECT * FRO
M Transactions WHERE id = ?’ at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 522#012#011DBIx:
:SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x7fda0bfb8958)’, ‘SELECT * FROM Transactions
WHERE id = ?’, 0) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1207#012#011DBIx::S
earchBuilder::Record::_LoadFromSQL(‘RT::Transaction=HASH(0x7fda089442d8)’, ‘SELECT * FROM Transact
ions WHERE id = ?’, 0) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1126#012#011DBI
x::SearchBuilder::Record::LoadByCols(‘RT::Transaction=HASH(0x7fda089442d8)’, ‘id’, 0) called at /us
r/share/perl5/DBIx/SearchBuilder/Record/Cachable.pm line 119#012#011DBIx::SearchBuilder::Record::Ca
chable::LoadByCols(‘RT::Transaction=HASH(0x7fda089442d8)’, ‘id’, 0) called at /usr/local/rt3/bin/…
/lib/RT/Record.pm line 350#012#011RT::Record::LoadByCols(‘RT::Transaction=HASH(0x7fda089442d8)’, ‘i
d’, 0) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1141#012#011DBIx::SearchBuilder
::Record::LoadById(‘RT::Transaction=HASH(0x7fda089442d8)’, 0) called at /usr/share/perl5/DBIx/Searc
hBuilder/Record.pm line 1057#012#011DBIx::SearchBuilder::Record::Load(‘RT::Transaction=HASH(0x7fda0
89442d8)’, 0) called at /usr/local/rt3/bin/…/lib/RT/Transaction_Overlay.pm line 152#012#011RT::Tra
nsaction::Create(‘RT::Transaction=HASH(0x7fda089442d8)’, ‘Ticket’, 219672, ‘Type’, ‘EmailRecord’, ’
Data’, ‘rt-3.8.8-12857-1372151303-953.219672-3-0@uu.se’, ‘MIMEObj’, ‘MIME::Entity=HASH(0x7fda0891
3db8)’, …) called at /usr/local/rt3/bin/…/lib/RT/Action/SendEmail.pm line 546#012#011RT::Action:
:SendEmail::RecordOutgoingMailTransaction(‘RT::Action::Autoreply=HASH(0x7fda08903568)’, ‘MIME::Enti
ty=HASH(0x7fda08913db8)’) called at /usr/local/rt3/bin/…/lib/RT/Action/SendEmail.pm line 138#012#0
11RT::Action::SendEmail::Commit(‘RT::Action::Autoreply=HASH(0x7fda08903568)’) called at /usr/local/
rt3/bin/…/lib/RT/ScripAction_Overlay.pm line 238#012#011RTJun 25 11:08:23 kock6 RT: RT::Attachment->Create couldn’t, as
you didn’t specify a transaction (/usr/local/rt3/bin/…/lib/RT/Attachment_Overlay.pm:114)

Jun 25 11:08:23 kock6 RT: Could not record outgoing message transaction: Transaction Created (/usr/
local/rt3/bin/…/lib/RT/Action/SendEmail.pm:557)

Jun 25 11:08:23 kock6 RT: DBD::mysql::st execute failed: MySQL server has gone away at /usr/share/p
erl5/DBIx/SearchBuilder/Handle.pm line 509. (/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:509)
Jun 25 11:08:23 kock6 RT: RT::Handle=HASH(0x7fda0bfb8958) couldn’t execute the query ‘SELECT DISTIN
CT main.* FROM CustomFields main JOIN ObjectCustomFields ObjectCustomFields_1 ON ( ObjectCustomFie
lds_1.CustomField = main.id ) WHERE (main.Name = ‘Constituency’) AND (ObjectCustomFields_1.ObjectI
d = ‘5’) AND (main.LookupType = ‘RT::Queue-RT::Ticket’) ORDER BY main.Disabled ASC LIMIT 1’ at /u
sr/share/perl5/DBIx/SearchBuilder/Handle.pm line 522#012#011DBIx::SearchBuilder::Handle::SimpleQuer
y(‘RT::Handle=HASH(0x7fda0bfb8958)’, ‘SELECT DISTINCT main.* FROM CustomFields main JOIN ObjectCust
…’) called at /usr/share/perl5/DBIx/SearchBuilder.pm line 236#012#011DBIx::SearchBuilder::_DoSear
ch(‘RT::CustomFields=HASH(0x7fda0894e0b8)’) called at /usr/local/rt3/bin/…/lib/RT/SearchBuilder.pm
line 391#012#011RT::SearchBuilder::_DoSearch(‘RT::CustomFields=HASH(0x7fda0894e0b8)’) called at /u
sr/share/perl5/DBIx/SearchBuilder.pm line 504#012#011DBIx::SearchBuilder::Next(‘RT::CustomFields=HA
SH(0x7fda0894e0b8)’) called at /usr/local/rt3/bin/…/lib/RT/CustomFields_Overlay.pm line 324#012#01
1RT::CustomFields::Next(‘RT::CustomFields=HASH(0x7fda0894e0b8)’) called at /usr/share/perl5/DBIx/Se
archBuilder.pm line 561#012#011DBIx::SearchBuilder::First(‘RT::CustomFields=HASH(0x7fda0894e0b8)’)
called at /usr/local/rt3/bin/…/lib/RT/CustomField_Overlay.pm line 358#012#011RT::CustomField::Load
ByName(‘RT::CustomField=HASH(0x7fda0893bdc8)’, ‘Name’, ‘Constituency’, ‘Queue’, 5) called at /usr/l
ocal/rt3/bin/…/lib/RT/Ticket_Overlay.pm line 3614#012#011RT::ticket::CustomFieldValues(‘RT::Ticket
=HASH(0x7fda0b44e650)’, ‘Constituency’) called at /usr/local/rt3/bin/…/lib/RT/Record.pm line 1828#
012#011RT::Record::FirstCustomFieldValue(‘RT::Ticket=HASH(0x7fda0b44e650)’, ‘Constituency’) called
at /usr/local/rt3/local/plugins/RT-IR/lib/RT/Action/RTIR_SetConstituency.pm line 102#012#011RT::Act
ion::RTIR_SetConstituency::SetConstituencyOnCreate(‘RT::Action::RTIR_SetConstituency=HASH(0x7fda089
3c5f0)’) called at /usr/local/rt3/local/plugins/RT-IR/lib/RT/Action/RT

Jun 25 11:08:23 kock6 RT: DBD::mysql::st execute failed: MySQL server has gone away at /usr/share/p
erl5/DBIx/SearchBuilder/Handle.pm line 509. (/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:509)
Jun 25 11:08:23 kock6 RT: RT::Handle=HASH(0x7fda0bfb8958) couldn’t execute the query ‘SELECT DISTIN
CT main.* FROM CustomFields main JOIN ObjectCustomFields ObjectCustomFields_1 ON ( ObjectCustomFie
lds_1.CustomField = main.id ) WHERE (main.Name = ‘Constituency’) AND (ObjectCustomFields_1.ObjectI
d = ‘0’) AND (main.LookupType = ‘RT::Queue-RT::Ticket’) ORDER BY main.Disabled ASC LIMIT 1’ at /u
sr/share/perl5/DBIx/SearchBuilder/Handle.pm line 522#012#011DBIx::SearchBuilder::Handle::SimpleQuer
y(‘RT::Handle=HASH(0x7fda0bfb8958)’, ‘SELECT DISTINCT main.* FROM CustomFields main JOIN ObjectCust
…’) called at /usr/share/perl5/DBIx/SearchBuilder.pm line 236#012#011DBIx::SearchBuilder::_DoSear
ch(‘RT::CustomFields=HASH(0x7fda08941968)’) called at /usr/local/rt3/bin/…/lib/RT/SearchBuilder.pm
line 391#012#011RT::SearchBuilder::_DoSearch(‘RT::CustomFields=HASH(0x7fda08941968)’) called at /u
sr/share/perl5/DBIx/SearchBuilder.pm line 504#012#011DBIx::SearchBuilder::Next(‘RT::CustomFields=HA
SH(0x7fda08941968)’) called at /usr/local/rt3/bin/…/lib/RT/CustomFields_Overlay.pm line 324#012#01
1RT::CustomFields::Next(‘RT::CustomFields=HASH(0x7fda08941968)’) called at /usr/share/perl5/DBIx/Se
archBuilder.pm line 561#012#011DBIx::SearchBuilder::First(‘RT::CustomFields=HASH(0x7fda08941968)’)
called at /usr/local/rt3/bin/…/lib/RT/CustomField_Overlay.pm line 358#012#011RT::CustomField::Load
ByName(‘RT::CustomField=HASH(0x7fda0893bdc8)’, ‘Name’, ‘Constituency’, ‘Queue’, 0) called at /usr/l
ocal/rt3/bin/…/lib/RT/Ticket_Overlay.pm line 3615#012#011RT::ticket::CustomFieldValues(‘RT::Ticket
=HASH(0x7fda0b44e650)’, ‘Constituency’) called at /usr/local/rt3/bin/…/lib/RT/Record.pm line 1828#
012#011RT::Record::FirstCustomFieldValue(‘RT::Ticket=HASH(0x7fda0b44e650)’, ‘Constituency’) called
at /usr/local/rt3/local/plugins/RT-IR/lib/RT/Action/RTIR_SetConstituency.pm line 102#012#011RT::Act
ion::RTIR_SetConstituency::SetConstituencyOnCreate(‘RT::Action::RTIR_SetConstituency=HASH(0x7fda089
3c5f0)’) called at /usr/local/rt3/local/plugins/RT-IR/lib/RT/Action/RTJun 25 11:08:23 kock6 RT: DBD::mysql::st execute
failed: MySQL server has gone away at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 509.
(/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:509)

Jun 25 11:08:23 kock6 RT: RT::Handle=HASH(0x7fda0bfb8958) couldn’t execute the query ‘SELECT DISTIN
CT main.* FROM CustomFields main JOIN ObjectCustomFields ObjectCustomFields_1 ON ( ObjectCustomFie
lds_1.CustomField = main.id ) WHERE (main.Name = ‘Constituency’) AND (ObjectCustomFields_1.ObjectI
d = ‘0’) AND (main.LookupType = ‘RT::Queue-RT::Ticket’) ORDER BY main.Disabled ASC LIMIT 1’ at /u
sr/share/perl5/DBIx/SearchBuilder/Handle.pm line 522#012#011DBIx::SearchBuilder::Handle::SimpleQuer
y(‘RT::Handle=HASH(0x7fda0bfb8958)’, ‘SELECT DISTINCT main.* FROM CustomFields main JOIN ObjectCust
…’) called at /usr/share/perl5/DBIx/SearchBuilder.pm line 236#012#011DBIx::SearchBuilder::_DoSear
ch(‘RT::CustomFields=HASH(0x7fda08941968)’) called at /usr/local/rt3/bin/…/lib/RT/SearchBuilder.pm
line 391#012#011RT::SearchBuilder::_DoSearch(‘RT::CustomFields=HASH(0x7fda08941968)’) called at /u
sr/share/perl5/DBIx/SearchBuilder.pm line 504#012#011DBIx::SearchBuilder::Next(‘RT::CustomFields=HA
SH(0x7fda08941968)’) called at /usr/local/rt3/bin/…/lib/RT/CustomFields_Overlay.pm line 324#012#01
1RT::CustomFields::Next(‘RT::CustomFields=HASH(0x7fda08941968)’) called at /usr/share/perl5/DBIx/Se
archBuilder.pm line 561#012#011DBIx::SearchBuilder::First(‘RT::CustomFields=HASH(0x7fda08941968)’)
called at /usr/local/rt3/bin/…/lib/RT/CustomField_Overlay.pm line 358#012#011RT::CustomField::Load
ByName(‘RT::CustomField=HASH(0x7fda0893bdc8)’, ‘Name’, ‘Constituency’, ‘Queue’, 0) called at /usr/l
ocal/rt3/bin/…/lib/RT/Ticket_Overlay.pm line 3615#012#011RT::ticket::CustomFieldValues(‘RT::Ticket
=HASH(0x7fda0b44e650)’, ‘Constituency’) called at /usr/local/rt3/bin/…/lib/RT/Record.pm line 1828#
012#011RT::Record::FirstCustomFieldValue(‘RT::Ticket=HASH(0x7fda0b44e650)’, ‘Constituency’) called
at /usr/local/rt3/local/plugins/RT-IR/lib/RT/Action/RTIR_SetConstituency.pm line 102#012#011RT::Act
ion::RTIR_SetConstituency::SetConstituencyOnCreate(‘RT::Action::RTIR_SetConstituency=HASH(0x7fda089
3c5f0)’) called at /usr/local/rt3/local/plugins/RT-IR/lib/RT/Action/RT

Jun 25 11:08:23 kock6 RT: DBD::mysql::st execute failed: MySQL server has gone away at /usr/share/p
erl5/DBIx/SearchBuilder/Handle.pm line 509. (/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:509)

Jun 25 11:08:23 kock6 RT: RT::Handle=HASH(0x7fda0bfb8958) couldn’t execute the query ‘SELECT DISTIN
CT main.* FROM Tickets main JOIN Links Links_1 ON ( Links_1.LocalBase = ‘219672’ ) AND ( Links_1.T
ype = ‘MemberOf’ ) AND ( Links_1.LocalTarget = main.id ) WHERE (main.Status != ‘deleted’) AND (Lin
ks_1.LocalBase IS NOT NULL) AND (main.Type = ‘ticket’) AND (main.EffectiveId = main.id) ORDER BY m
ain.LastUpdated DESC LIMIT 1’ at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 522#012#011DBI
x::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x7fda0bfb8958)’, ‘SELECT DISTINCT main.* FR
OM Tickets main JOIN Links Links_1 …’) called at /usr/share/perl5/DBIx/SearchBuilder.pm line 236
#012#011DBIx::SearchBuilder::_DoSearch(‘RT::Tickets=HASH(0x7fda08928660)’) called at /usr/local/rt3
/bin/…/lib/RT/SearchBuilder.pm line 391#012#011RT::SearchBuilder::_DoSearch(‘RT::Tickets=HASH(0x7f
da08928660)’) called at /usr/local/rt3/bin/…/lib/RT/Tickets_Overlay.pm line 2897#012#011RT::Ticket
s::_DoSearch(‘RT::Tickets=HASH(0x7fda08928660)’) called at /usr/share/perl5/DBIx/SearchBuilder.pm l
ine 504#012#011DBIx::SearchBuilder::Next(‘RT::Tickets=HASH(0x7fda08928660)’) called at /usr/local/r
t3/bin/…/lib/RT/Tickets_Overlay.pm line 2869#012#011RT::tickets::Next(‘RT::Tickets=HASH(0x7fda0892
8660)’) called at /usr/share/perl5/DBIx/SearchBuilder.pm line 561#012#011DBIx::SearchBuilder::First
(‘RT::Tickets=HASH(0x7fda08928660)’) called at /usr/local/rt3/local/plugins/RT-IR/lib/RT/Action/RTI
R_SetConstituency.pm line 152#012#011RT::Action::RTIR_SetConstituency::GetConstituencyFromParent(‘R
T::Action::RTIR_SetConstituency=HASH(0x7fda0893c5f0)’) called at /usr/local/rt3/local/plugins/RT-IR
/lib/RT/Action/RTIR_SetConstituency.pm line 103#012#011RT::Action::RTIR_SetConstituency::SetConstit
uencyOnCreate(‘RT::Action::RTIR_SetConstituency=HASH(0x7fda0893c5f0)’) called at /usr/local/rt3/loc
al/plugins/RT-IR/lib/RT/Action/RTIR_SetConstituency.pm line 29#012#011RT::Action::RTIR_SetConstitue
ncy::Commit(‘RT::Action::RTIR_SetConstituency=HASH(0x7fda0893c5f0)’) c

Jun 25 11:08:23 kock6 RT: DBD::mysql::st execute failed: MySQL server has gone away at /usr/share/p
erl5/DBIx/SearchBuilder/Handle.pm line 509. (/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:509)

Jun 25 11:08:23 kock6 RT: RT::Handle=HASH(0x7fda0bfb8958) couldn’t execute the query 'SELECT main.i
d AS id, main.Parent AS parent, main.TransactionId AS transactionid, main.ContentType AS contenttyp
e, main.ContentEncoding AS contentencoding, main.Headers AS headers, main.Subject AS subject, main.
Created AS created FROM Attachments main WHERE (main.TransactionId = ‘5097569’) ORDER BY main.Cre
ated ASC, main.id ASC ’ at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 522#012#011DBIx::Sear
chBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x7fda0bfb8958)’, ‘SELECT main.id AS id, main.Paren
t AS parent, main.Transaction…’) called at /usr/share/perl5/DBIx/SearchBuilder.pm line 236#012#01
1DBIx::SearchBuilder::_DoSearch(‘RT::Attachments=HASH(0x7fda0893edd8)’) called at /usr/local/rt3/bi
n/…/lib/RT/SearchBuilder.pm line 391#012#011RT::SearchBuilder::_DoSearch(‘RT::Attachments=HASH(0x7
fda0893edd8)’) called at /usr/share/perl5/DBIx/SearchBuilder.pm line 504#012#011DBIx::SearchBuilder
::Next(‘RT::Attachments=HASH(0x7fda0893edd8)’) called at /usr/local/rt3/bin/…/lib/RT/Attachments_O
verlay.pm line 227#012#011RT::Attachments::Next(‘RT::Attachments=HASH(0x7fda0893edd8)’) called at /
usr/share/perl5/DBIx/SearchBuilder.pm line 561#012#011DBIx::SearchBuilder::First(‘RT::Attachments=H
ASH(0x7fda0893edd8)’) called at /usr/local/rt3/local/plugins/RT-IR/lib/RT/Action/RTIR_SetConstituen
cy.pm line 137#012#011RT::Action::RTIR_SetConstituency::GetConstituencyFromAttachment(‘RT::Action::
RTIR_SetConstituency=HASH(0x7fda0893c5f0)’) called at /usr/local/rt3/local/plugins/RT-IR/lib/RT/Act
ion/RTIR_SetConstituency.pm line 115#012#011RT::Action::RTIR_SetConstituency::SetConstituencyOnCrea
te(‘RT::Action::RTIR_SetConstituency=HASH(0x7fda0893c5f0)’) called at /usr/local/rt3/local/plugins/
RT-IR/lib/RT/Action/RTIR_SetConstituency.pm line 29#012#011RT::Action::RTIR_SetConstituency::Commit
(‘RT::Action::RTIR_SetConstituency=HASH(0x7fda0893c5f0)’) called at /usr/local/rt3/bin/…/lib/RT/Sc
ripAction_Overlay.pm line 238#012#011RT::ScripAction::Commit('RT::ScriJun 25 11:08:23 kock6 RT: DBD::mysql::st execute
failed: MySQL server has gone away at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 509.
(/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:509)

Jun 25 11:08:23 kock6 RT: RT::Handle=HASH(0x7fda0bfb8958) couldn’t execute the query 'SELECT main.*
FROM CustomFields main JOIN ObjectCustomFields ObjectCustomFields_1 ON ( ObjectCustomFields_1.Cus
tomField = main.id ) WHERE (main.Disabled = ‘0’) AND (main.Name = ‘Constituency’) AND (ObjectCusto
mFields_1.ObjectId = ‘5’ OR ObjectCustomFields_1.ObjectId = ‘0’) AND (main.LookupType = ‘RT::Queue-
RT::Ticket’) GROUP BY main.id ORDER BY MIN(ObjectCustomFields_1.SortOrder) ASC ’ at /usr/share/pe
rl5/DBIx/SearchBuilder/Handle.pm line 522#012#011DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Hand
le=HASH(0x7fda0bfb8958)’, ‘SELECT main.* FROM CustomFields main JOIN ObjectCustomFields …’) calle
d at /usr/share/perl5/DBIx/SearchBuilder.pm line 236#012#011DBIx::SearchBuilder::_DoSearch(‘RT::Cus
tomFields=HASH(0x7fda08946400)’) called at /usr/local/rt3/bin/…/lib/RT/SearchBuilder.pm line 391#0
12#011RT::SearchBuilder::_DoSearch(‘RT::CustomFields=HASH(0x7fda08946400)’) called at /usr/share/pe
rl5/DBIx/SearchBuilder.pm line 504#012#011DBIx::SearchBuilder::Next(‘RT::CustomFields=HASH(0x7fda08
946400)’) called at /usr/local/rt3/bin/…/lib/RT/CustomFields_Overlay.pm line 324#012#011RT::Custom
Fields::Next(‘RT::CustomFields=HASH(0x7fda08946400)’) called at /usr/share/perl5/DBIx/SearchBuilder
.pm line 561#012#011DBIx::SearchBuilder::First(‘RT::CustomFields=HASH(0x7fda08946400)’) called at /
usr/local/rt3/bin/…/lib/RT/Record.pm line 1916#012#011RT::Record::LoadCustomFieldByIdentifier(‘RT:
:Ticket=HASH(0x7fda0b44e650)’, ‘Constituency’) called at /usr/local/rt3/bin/…/lib/RT/Record.pm lin
e 1598#012#011RT::Record::_AddCustomFieldValue called at /usr/local/share/perl/5.10.0/Hook/LexWrap.
pm line 50#012#011Hook::LexWrap::ANON(‘RT::Ticket=HASH(0x7fda0b44e650)’, ‘Field’, 'Constituency
', ‘Value’, ‘HASH(0x7fda092019d8)’) called at /usr/local/rt3/bin/…/lib/RT/Record.pm line 1584#012#
011RT::Record::AddCustomFieldValue(‘RT::Ticket=HASH(0x7fda0b44e650)’, ‘Field’, ‘Constituency’, ‘Val
ue’, ‘HASH(0x7fda092019d8)’) called at /usr/local/rt3/local/plugins/RT

Jun 25 11:08:23 kock6 RT: Couldn’t set CF: Custom field Constituency not found (/usr/local/rt3/loca
l/plugins/RT-IR/lib/RT/Action/RTIR_SetConstituency.pm:123)

Jun 25 11:08:23 kock6 RT: DBD::mysql::st execute failed: MySQL server has gone away at /usr/share/p
erl5/DBIx/SearchBuilder/Handle.pm line 509. (/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:509)
Jun 25 11:08:23 kock6 RT: RT::Handle=HASH(0x7fda0bfb8958) couldn’t execute the query ‘SELECT * FRO
M Groups WHERE Instance = ? AND Type = ? AND Domain = ?’ at /usr/share/perl5/DBIx/SearchBuilder/Han
dle.pm line 522#012#011DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x7fda0bfb8958)’,
‘SELECT * FROM Groups WHERE Instance = ? AND Type = ? AND Dom…’, 219672, ‘AdminCc’, ‘RT::Ticket-
Role’) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1207#012#011DBIx::SearchBuilder
::Record::_LoadFromSQL(‘RT::Group=HASH(0x7fda0891e5b0)’, ‘SELECT * FROM Groups WHERE Instance = ?
AND Type = ? AND Dom…’, 219672, ‘AdminCc’, ‘RT::Ticket-Role’) called at /usr/share/perl5/DBIx/Sea
rchBuilder/Record.pm line 1126#012#011DBIx::SearchBuilder::Record::LoadByCols(‘RT::Group=HASH(0x7fd
a0891e5b0)’, ‘Type’, ‘AdminCc’, ‘Instance’, 219672, ‘Domain’, ‘RT::Ticket-Role’) called at /usr/sha
re/perl5/DBIx/SearchBuilder/Record/Cachable.pm line 119#012#011DBIx::SearchBuilder::Record::Cachabl
e::LoadByCols(‘RT::Group=HASH(0x7fda0891e5b0)’, ‘Domain’, ‘RT::Ticket-Role’, ‘Instance’, 219672, ‘T
ype’, ‘AdminCc’) called at /usr/local/rt3/bin/…/lib/RT/Record.pm line 350#012#011RT::Record::LoadB
yCols(‘RT::Group=HASH(0x7fda0891e5b0)’, ‘Domain’, ‘RT::Ticket-Role’, ‘Instance’, 219672, ‘Type’, ‘A
dminCc’) called at /usr/local/rt3/bin/…/lib/RT/Group_Overlay.pm line 331#012#011RT::Group::LoadTic
ketRoleGroup(‘RT::Group=HASH(0x7fda0891e5b0)’, ‘Type’, ‘AdminCc’, ‘Ticket’, 219672) called at /usr/
local/rt3/bin/…/lib/RT/Ticket_Overlay.pm line 1470#012#011RT::ticket::AdminCc(‘RT::Ticket=HASH(0x7
fda0b44e650)’) called at /usr/local/rt3/local/plugins/RT-IR/lib/RT/Action/RTIR_SetConstituencyGroup
.pm line 26#012#011RT::Action::RTIR_SetConstituencyGroup::Commit(‘RT::Action::RTIR_SetConstituencyG
roup=HASH(0x7fda08937f28)’) called at /usr/local/rt3/bin/…/lib/RT/ScripAction_Overlay.pm line 238#
012#011RT::ScripAction::Commit(‘RT::ScripAction=HASH(0x7fda08925ad0)’) called at /usr/local/rt3/bin
/…/lib/RT/Scrip_Overlay.pm line 477#012#011eval {…} called at /usr/
[…]
Jun 25 11:09:24 kock6 RT: DBD::mysql::st execute failed: MySQL server has gone away at /usr/share/p
erl5/Apache/Session/Store/DBI.pm line 67. (/usr/share/perl5/Apache/Session/Store/DBI.pm:67)
Jun 25 11:09:24 kock6 RT: DBD::mysql::st execute failed: MySQL server has gone away at /usr/share/p
erl5/Apache/Session/Lock/MySQL.pm line 71. (/usr/share/perl5/Apache/Session/Lock/MySQL.pm:71)
Jun 25 11:09:24 kock6 RT: DBD::mysql::st execute failed: MySQL server has gone away at /usr/share/p
erl5/Apache/Session/Lock/MySQL.pm line 71. (/usr/local/rt3/bin/…/lib/RT/Interface/Web/Handler.pm:2
32)

smime.p7s (3.23 KB)

Hi,

we have run into problem after adding following security patches

  • security-2011-04-14
  • security-2012-05-22
  • security-2012-10-25
  • security-2013-05-22
    and
  • RT-Extension-SaltedPasswords-1.2

I include an example of the log messages we get when we “Launch a new investigation”.

You applied all of those at once?

What’s in your mysql logs?
What is your Apache configuration?
What kind of Apache worker are you running (httpd -l or apache2 -l)

-kevin

Keeping replies on the mailing list.
Mail sent to me personally tends to get lost or a severely delayed
response.

mysql log showing error when I try to launch a email:

Jun 25 11:08:23 kock6 RT: rt-3.8.8-12857-1372151303-953.219672-3-0@uu.se sent To: xxxxxx.yyyyyy
.xxxx@zzzzzzz.uu.se (/usr/local/rt3/bin/…/lib/RT/Action/SendEmail.pm:331)

These are apache logs, not mysql logs.

What is your Apache configuration?

Answer:

I don’t want to send the whole apache2 configuration what exactly are you interested in.

The VirtualHost that contains your RT stanza should suffice.

apache2 -l

Answer:

Compiled in modules:
core.c
mod_log_config.c
mod_logio.c
prefork.c
http_core.c
mod_so.c

Thanks - this at least eliminates one possible problem.

It would also be good to know if you are using the GnuPG integration.

-kevin