[Ruqueue-devel] Re: Password field length in MySQL > 4.10

[John Fulton]

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;