74032 - Password stored in plaintext on the MySQL Data Base.

Status: RESOLVED FIXED

(Bugzilla :: Bugzilla-General, defect)

Description

[Girino Vey!]

System administrators at my site are concerned about my running bugzilla in one 
of their machines since users tend to use the same password for bugzilla and 
for their login account in the other machines. This password being plaintext in 
the DB mekes it available to the bugzilla admin (me) at any time.

Password should be only stored in it's encrypted form on the DB.

Comment 1

[Dave Miller [:justdave]]

See also bug 15980: Password visible in location bar in browser

I agree, this is a concern of mine, too, for my local system.

Do keep in mind that unless you're using SSL, the passwords are transmitting in 
cleartext over the network, too (if everyone's inside a firewall, this part might 
not be a big deal).

Marking 2.14 since this is a security issue.

Comment 2

[Myk Melez [:myk] [@mykmelez]]

Making this bug depend on bug 77473 because existing installations will have to
re-crypt their user's passwords when that fix is applied, and they need to keep
the plain-text versions of those passwords around until then in order to be able
to do that.

Comment 3

[Myk Melez [:myk] [@mykmelez]]

taking.  A patch for this bug exists as part of the patch to bug 77473.

Comment 4

[Dave Miller [:justdave]]

bug 77473 has been fixed, and the patch included the fix for this, therefore
this is fixed.

Comment 5

[Dave Miller [:justdave]]

Moving to Bugzilla product

Comment 6

[victory <[e-mail]>]

Attachment: docs patch about 'Bugzilla Database Tables' section, for 2.18

Comment 7

[timeless]

Comment on attachment 214072 [details] [diff] [review]
docs patch about 'Bugzilla Database Tables' section, for 2.18

>+profiles:  Ahh, so you were wondering where your precious user
>+information was stored?  Here it is!  This table stores crypted
>+passwords, disabledtext, emailflags, login_name, whether to show
_the_
>+<quote>My Bugs</quote> link, the user's real name, and when the
>+profiles were updated.

... when || profiles were _last_ updated.
or
... when the /profile/ /was/ _last_ updated.