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

[Christopher P. Lindsey]

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;