[#QB-2464] JIRA authenticator creates malformed email address

QuickBuild

JIRA authenticator creates malformed email address

Created: 08/Jun/15 07:52 PM Updated: 03/Apr/16 07:15 AM

Component/s:

None

Affects Version/s:

6.0.13, 6.0.18

Fix Version/s:

None

Original Estimate:

Unknown

Remaining Estimate:

Unknown

Time Spent:

Unknown

File Attachments:

None

Image Attachments:

1. JiraUser.JPG
(13 kb)

2. QBuser.JPG
(14 kb)

Environment:

Latest Amazon Linux, Open JDK 1.8.0_31, QB 6.0.13 and 6.0.18

Description

« Hide

When migrating from QB 6.0.13 to 6.0.18 this error occurred:
2015-06-08 18:41:46,073 ERROR - Error migrating.
com.pmease.quickbuild.validation.ValidationException: not a well-formed email address (class:com.pmease.quickbuild.model.User, property:email, value:gavin dot wood at us dot panasonic dot com)
        at com.pmease.quickbuild.web.component.editor.EditContext.validate(EditContext.java:191)
        at com.pmease.quickbuild.web.component.editor.EditContext.validate(EditContext.java:140)
        at com.pmease.quickbuild.util.BeanUtils.validate(BeanUtils.java:367)
        at com.pmease.quickbuild.entitymanager.impl.DefaultDataManager.importData(DefaultDataManager.java:970)
        at com.pmease.quickbuild.Quickbuild.importData(Quickbuild.java:909)
        at com.pmease.quickbuild.bootstrap.Migrate$7.execute(Migrate.java:374)
        at com.pmease.quickbuild.Quickbuild$3.run(Quickbuild.java:627)
        at java.lang.Thread.run(Thread.java:745)
*********************** IMPORTANT ***********************
Migration process is failed and the data of previous version may got deleted from database. To restore the previous data, please delete and re-create the database and run below command:
/usr/lib64/quickbuild-6.0.13/bin/restore.sh /usr/lib64/quickbuild-6.0.18/migrate/2015.06.08_18.40.57.zip

The suggested restore did not work for the same reason.
I edited the Users.xml in the migrate zip file and changed two email entries from the format "alias at some dot domain dot com" to "alias@some.domain.com". and then followed procedures to remove/recreate the database, restore to 6.0.13 and retry the migration to 6.0.18, which subsequently worked.

Whenever a user logs into QB using the JIRA Authenticator, the email address will be malformed in this manner. You can correct the email address, but it will be malformed again at next logon.

All

Comments

Work Log

Change History

Sort Order:

[ Permlink | « Hide ]

Steve Luo [09/Jun/15 01:39 AM]

The email address you see in QuickBuild is fetched from JIRA side. So, please make sure you have correct email address in JIRA.

[ Permlink | « Hide ]

Gavin Wood [19/Jun/15 02:03 PM]

The screen shots better represent what is happening to the email address as it comes over from JIRA. The format or syntax of the address is coming across incorrect.

[ Permlink | « Hide ]

Steve Luo [19/Jun/15 03:54 PM]

Is it possible that some plugins installed in JIRA caused this? Or is there any mechanism in your environment that can change the email automatically? For example, JIRA is running behind apache and apache server has some plugin doing this work?

Please install a fresh JIRA instance without any extra plugins to see if it can work in your side.
By the way, I have just tested with a fresh JIRA instance and it works.

[ Permlink | « Hide ]

Gavin Wood [19/Jun/15 05:00 PM]

Thanks Steve, I will do more looking into the Jira config and add-ons to see if it is happening before QB pulls the data. Workload may push my investigation out a few weeks, but I will get to it.

[ Permlink | « Hide ]

Steve Luo [03/Apr/16 07:15 AM]

There is no further information received. If you still have problems, comment this so we will reopen the issue.