4.4.1 autocreate on submission error

Hello,
I’ve been using RT since 3.x days and last week I moved from 4.2.12 to
4.4.1. I thought all was working OK as I was receiving tickets but
apparently new users can’t submit tickets via email. This was all working
properly with previous versions using the ldap plugins. During upgrade
there I went into MySQL and nulled the values in "ExternalContactInfoId"
and “ExternalAuthID” to get the upgrade to complete.

here is some log data from the failed submission:

[debug]: RT::User::CanonicalizeUserInfoFromExternalAuth called by RT::User
/opt/rt4/sbin/…/lib/RT/User.pm 699 with: Comments: Autocreated on ticket
submission, Disabled: , EmailAddress: user@domain.org, Name: user@domain.org,
Privileged: , RealName: Jones, User (/opt/rt4/sbin/…/lib/RT/User.pm:735)
[4255] [Mon Jul 25 19:25:24 2016] [info]:
RT::User::CanonicalizeUserInfoFromExternalAuth returning Address1: Finance,
City: Administration Office, Comments: Autocreated on ticket submission,
Country: , Disabled: , EmailAddress: user@domain.org, ExternalAuthId:
JonesU, Gecos: JonesU, Name: JonesU, Organization: , Privileged: ,
RealName: User, State: , WorkPhone: , Zip:
(/opt/rt4/sbin/…/lib/RT/User.pm:811)
[4255] [Mon Jul 25 19:25:24 2016] [warning]: DBD::mysql::st execute failed:
Unknown column ‘ExternalAuthId’ in ‘field list’ at
/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 586.
(/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:586)
[4255] [Mon Jul 25 19:25:24 2016] [warning]: RT::Handle=HASH(0x7f07508)
couldn’t execute the query ‘INSERT INTO Users (Comments, City, RealName,
State, EmailAddress, Password, WorkPhone, Zip, id, Organization,
LastUpdated, Creator, Gecos, Country, LastUpdatedBy, Address1, Created,
Name, ExternalAuthId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?)’ at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line
599.

[4516] [Mon Jul 25 19:13:15 2016] [error]: Could not create a new user -
Comments-Autocreated on ticket submission-City-Administration
Office-RealName-Heather-State–EmailAddress-user@domain.org-Gecos-JonesU-Password-NO-PASSWORD-Country–Address1-Finance-WorkPhone–Zip–Organization–Name-JonesU-ExternalAuthId-JonesU
(/opt/rt4/sbin/…/lib/RT/User.pm:193)
[4516] [Mon Jul 25 19:13:20 2016] [critical]: Failed to create user
user@domain.org: Could not create user (/opt/rt4/sbin/…/lib/RT/User.pm:546)
[4516] [Mon Jul 25 19:13:20 2016] [crit]: Permission Denied: You do not
have permission to communicate with RT
(/opt/rt4/sbin/…/lib/RT/Interface/Email.pm:698)

Is the problem the “ExternalAuthID” in mySQL (per the logs)? or a
misconfiguration?

Thanks,
Aaron

Hi!

Could it be possible, that you have the field ExternalAuthId specified in your attr_map in RT_Siteconfig?
This field does not exist anymore on 4.4.1 so it leads to an error when inserting…

BR,
Markus

Markus,
Thanks for the tip. You were correct that I had an ExternalAuthID set in
RT_Siteconfig.

AaronOn Thu, Jul 28, 2016 at 6:35 AM, Wildbolz, Markus (MCG-I, MLC) < Markus.Wildbolz@magna.com> wrote:

Hi!

Could it be possible, that you have the field ExternalAuthId specified in
your attr_map in RT_Siteconfig?

This field does not exist anymore on 4.4.1 so it leads to an error when
inserting…

BR,

Markus


RT 4.4 and RTIR Training Sessions https://bestpractical.com/training

  • Los Angeles - September, 2016