How JIRA managed user email address on DB?

I'm looking for a tabel that user email adress managed on DB.
I found user table named "userbase" on DB, but it dosen't have email field.(Its fileds ware username, password_hash.)
I wonder how JIRA managed user email address on DB?

Anyone knows the table name?

My JIRA environment is bellow.
JIRA version:4.1
DB: MySQL

4 answers

1 accepted

Accepted Answer
0 votes

You need to check with the PROPERTYENTRY and PROPERTYSTRING table for JIRA 4.1.

Refer this link

Thank you for your help!

I've confirmed the email field in "propertystring" table on DB.

My goal is to replace all users email adress domain from "@aaa">xx@aaa" to "xx@bbb" in a lump by SQL.

so I tried to execute this SQL, and I could replace all users email domain to "bbb" on DB.


#update 'propertystring' set propertyvalue = replace(propertyvalue, 'aaa', 'bbb') where propertyvalue like @aaa'">'%@aaa'


Then I loggined JIRA and checked the individual email address, but the domain remained old one.(aaa)

It seems that some cache works.

Do I need something to do to clear(Already tried to clear the blowser cashe) or some more works?

Thank you for your help!

I've confirmed the email field in "propertystring" table on DB.

My goal is to replace all users email adress domain from "@aaa">xx@aaa" to "xx@bbb" in a lump by SQL.

so I tried to execute this SQL, and I could replace all users email domain to "bbb" on DB.


#update 'propertystring' set propertyvalue = replace(propertyvalue, 'aaa', 'bbb') where propertyvalue like @aaa'">'%@aaa'


Then I loggined JIRA and checked the individual email address, but the domain remained old one.(aaa)

It seems that some cache works.

Do I need something to do to clear(Already tried to clear the blowser cashe) or some more works?

i remember doin a reindex after changing somethin in the DB.

did you tried to do so?

Yeah. I hope you updated the table only after shutting the JIRA instance and retsrting it later. Jira needs reindexing after changes are made to its database. You can mark the above answer as correct, if it helped you :)

You must NEVER run SQL on an active Jira database, the system must be halted before you run any SQL.

This change you've made is a relatively safe one, but you may have lost some of the email addresses you updated - you might want to reread the propertyvalue rows you changed to make sure they're all still there.

Glad it worked! You can mark the above answer as correct if it helped you :)

Try this one -

SELECT LOWER_EMAIL_ADDRESS FROM CWD_USER WHERE LOWER_USER_NAME = "user_name";

I've recieved this message.

#1146 - Table 'jira4.cwd_user' doesn't exist

"jira4" is my databae name.

And I've checked that my database doesn't hava "CWD_USER" table through the phpMyAdmin.

Thank you for your help!

I've confirmed the email field in "propertystring" table on DB.

My goal is to replace all users email adress domain from "xx@aaa" to "xx@bbb" in a lump by SQL.

so I tried to execute this SQL, and I could replace all users email domain to "bbb" on DB.


#update 'propertystring' set propertyvalue = replace(propertyvalue, 'aaa', 'bbb') where propertyvalue like @aaa'">'%@aaa'


Then I loggined JIRA and checked the individual email address, but the domain remained old one.(aaa)

It seems that some cache works.

Do I need something to do to clear(Already tried to clear the blowser cashe) or some more works?

Thanks to your support, I managed to solve the problem.

I might not doing reindex the DB, I've just reboot the JIRA service.

Thank you again for all!

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Oct 16, 2018 in Jira

Looking for anyone who made the switch to Data Center

The Jira Marketing team is putting together an ebook on migrating to Data Center. We're looking for pro tips on how you staffed your project team and organized your Proof of Concept. Share yo...

78 views 0 3
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you