nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How JIRA managed user email address on DB?

naotaka terazaw

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

Accepted answers

Naren3

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

Refer this link

All comments

Naren3

Try this one -

SELECT LOWER_EMAIL_ADDRESS FROM CWD_USER WHERE LOWER_USER_NAME = "user_name";

naotaka terazaw

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.

Naren3

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

Refer this link

naotaka terazaw

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 terazaw

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 terazaw

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?

C.Faysal {CFcon}

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

did you tried to do so?

naotaka terazaw

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!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-cloud