How JIRA managed user email address on DB?

[naotaka terazawa]

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

[Naren · Accepted solution]

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

Refer this link

[naotaka terazawa]

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?

[naotaka terazawa]

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?

[C_ Faysal]

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

did you tried to do so?

[Naren]

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 :)

[Nic Brough -Adaptavist-]

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.

[Naren]

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

[naotaka terazawa]

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!

[naotaka terazawa]

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?

[Naren]

Try this one -

SELECT LOWER_EMAIL_ADDRESS FROM CWD_USER WHERE LOWER_USER_NAME = "user_name";

[naotaka terazawa]

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.