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

Status: VERIFIED FIXED

(Bugzilla :: Bugzilla-General, defect, P2)

Description

[dan]

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

Comment 1

[Terry Weissman]

[e-mail] 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 .)

Comment 2

[Tara Hernandez]

chris--I think you know the most about this.  Want to have a look?

Comment 3

[Dave Miller [:justdave]]

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.

Comment 4

[Chris Yeh]

the minimum mysql requirements are both in checksetup.pl and in the readme.

Comment 5

[leger]

Marking Verified.

Comment 6

[Dave Miller [:justdave]]

In search of accurate queries....  (sorry for the spam)

Comment 7

[Dave Miller [:justdave]]

Moving closed bugs to Bugzilla product