new users all unable to login: profiles.cryptpassword is NULL

VERIFIED FIXED in Bugzilla 2.12

Status

()

P2
minor
VERIFIED FIXED
19 years ago
6 years ago

People

(Reporter: dan, Assigned: Chris.Yeh)

Tracking

unspecified
Bugzilla 2.12
x86
Linux

Details

(Reporter)

Description

19 years ago
Every time I add a user to bugzilla, it gets created with NULL in its
cryptpassword column, so I have to fill in its encrypted password by hand using
MySQL

This turns out eventually to be a mysql version problem: 3.21.17a-beta-log
doesn't have an encrypt() function.  Could you add a note warning of this to
the (otherwise very useful) README file?

mysql> select encrypt('foo');
+----------------+
| encrypt('foo') |
+----------------+
| NULL           |
+----------------+

As it works in other respects (and I've set up all my categories nicely) and a
bunch of other things are using this mysql installation already, I'm just going
to hack globals.pl to call crypt() from Perl

Updated

19 years ago
Status: NEW → ASSIGNED
Priority: P3 → P2

Comment 1

19 years ago
tara@tequilarista.org is the new owner of Bugzilla and Bonsai.  (For details,
see my posting in netscape.public.mozilla.webtools,
news://news.mozilla.org/38F5D90D.F40E8C1A%40geocast.com .)
Assignee: terry → tara
Status: ASSIGNED → NEW

Comment 2

19 years ago
chris--I think you know the most about this.  Want to have a look?
Assignee: tara → cyeh
I think this is fixed already.  Every time I run checksetup.pl, I get a 
"reminder" that bugzilla requires mySQL 3.22.x, and when I did the original 
install as 2.8, I could swear it said that in the readme, too, but I don't 
remember for sure (and it's not somewhere I can look easily right now).  If you 
missed it in the readme, you'd get the notice when you ran checksetup.pl.
(Assignee)

Comment 4

19 years ago
the minimum mysql requirements are both in checksetup.pl and in the readme.
Status: NEW → RESOLVED
Last Resolved: 19 years ago
Resolution: --- → FIXED

Comment 5

18 years ago
Marking Verified.
Status: RESOLVED → VERIFIED
In search of accurate queries....  (sorry for the spam)
Target Milestone: --- → Bugzilla 2.12
Moving closed bugs to Bugzilla product
Component: Bugzilla → Bugzilla-General
Product: Webtools → Bugzilla
QA Contact: matty
Version: other → unspecified
QA Contact: matty_is_a_geek → default-qa
You need to log in before you can comment on or make changes to this bug.