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: u...@domain.org, Name: u...@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: u...@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-u...@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 u...@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
--------- RT 4.4 and RTIR Training Sessions https://bestpractical.com/training * Los Angeles - September, 2016
