[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Ruqueue-devel] Re: Password field length in MySQL > 4.10
From: |
John Fulton |
Subject: |
[Ruqueue-devel] Re: Password field length in MySQL > 4.10 |
Date: |
Tue, 11 Oct 2005 21:19:01 -0400 (EDT) |
Chris,
Thanks for the patch. I've applied it to CVS.
John
On Sat, 1 Oct 2005 04:38:06 -0500 Christopher P. Lindsey wrote:
> I was having problems logging in after installing ruQueue and realized
> that the password field of VARCHAR(32) is too short with newer
> versions of MySQL. Since the database was already created, the fix
> was to issue an ALTER TABLE command that increased the password size,
> then reset the password.
>
> alter table staff modify password varchar(64);
> update staff set password=password('Rutgers1766') where
> username='root';
>
> Here's a patch that makes the above command unnecessary if run before
> creating the database.
>
> Chris
>
>
> *** DB/ruqueue.sql Sat Oct 1 04:34:29 2005
> --- DB/ruqueue.sql.new Sat Oct 1 04:34:43 2005
> ***************
> *** 429,435 ****
> pager varchar(25) default NULL,
> comments text,
> html_email int(1) default '0',
> ! password varchar(32) default NULL,
> PRIMARY KEY (username)
> ) TYPE=MyISAM;
>
> --- 429,435 ----
> pager varchar(25) default NULL,
> comments text,
> html_email int(1) default '0',
> ! password varchar(64) default NULL,
> PRIMARY KEY (username)
> ) TYPE=MyISAM;
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Ruqueue-devel] Re: Password field length in MySQL > 4.10,
John Fulton <=