[Phptest-users] login problem

[Dan Kegel]

Hey, it looks like there's some portability problem.  I'm
running phptest-0.6.0 on www.pair.com, which uses freebsd.

The passwords in the users table I generate when adding
a user are so long they seem to get truncated... here's a log:

2002-07-29 02:43:18 Query: INSERT INTO users (username, password, email, 
real_name, date_joined, admin) VALUES ('qwerty', 
'$1$KGktWeHX$.BsZ1b9CNiJefEiLpF4tW1', '', '', NOW(), 0)
2002-07-29 02:43:18 Insert ID is 29
2002-07-29 02:43:18 Query: SELECT g_id FROM groups WHERE description = 
'visitors'
2002-07-29 02:43:18 Query: INSERT INTO user_groups (user_id, g_id) 
VALUES (29, 20)
2002-07-29 02:43:18 --- Connected to mysql---
2002-07-29 02:43:40 --- Connected to mysql---
2002-07-29 02:43:40 Query: SELECT password FROM users WHERE username = 
'qwerty'
2002-07-29 02:43:40 Numrows is 1
2002-07-29 02:43:40 Query: SELECT * FROM users WHERE username = 'qwerty' 
AND password = '$1$KGktWeHX$.BsZ1b9CNiJefEiLpF4tW1'
2002-07-29 02:43:40 Numrows is 0

My, my -- password was same but no matchy -- could it be the table 
truncates the value, causing the compare to fail?  Here's the table
contents:

mysql> select * from users;
+---------+----------+--------------------------------+------------------+---------------------+---------------------+-------+
| user_id | username | password                       | email 
 | real_name           | date_joined         | admin |
+---------+----------+--------------------------------+------------------+---------------------+---------------------+-------+
|       1 | admin    | $1$LiQsrgDg$9aZjbQKQWCI15YsxfQ | none 
 | Administrative user | 2002-04-05 10:14:31 |     1 |
|      26 | pink     | tO7t1xqN0kmpo                  | address@hidden 
 | Mr. Pink            | 2002-06-14 14:55:28 |     0 |
|      25 | brown    | twaR3fBd1S0i2                  | address@hidden 
| Ms. Brown           | 2002-06-14 14:51:14 |     0 |
|      27 | green    | tJmnGO9JuPrFI                  | address@hidden 
| Mr. Green           | 2002-06-14 14:56:00 |     0 |
|      28 | dank     | $1$HwcygUOV$aUPg//8e7BD7f0OfP9 | 
 |                     | 2002-07-29 02:40:45 |     0 |
|      29 | qwerty   | $1$KGktWeHX$.BsZ1b9CNiJefEiLpF | 
 |                     | 2002-07-29 02:43:18 |     0 |
+---------+----------+--------------------------------+------------------+---------------------+---------------------+-------+

What do you think?

I'm just a beginner at php + mysql, I have no idea...

Thanks,
Dan